Extend Global Temporary Tables

The following are the steps to extend GTTs:

1. Alter the GTT, to add a new column.
2. Write population logic for the new column in User Exit package. For example, to populate case level table rep_case_tmp the following User Exit package - procedure can be used: pkg_rep_linelisting_user_exit.p_modify_case_tmp
3. Modify the User Exit package to append case number with ABC, such as:

   PROCEDURE p_modify_case_tmp IS

   BEGIN

   UPDATE REP_CASE_TMP SET CASE_NUM = 'ABC'||CASE_NUM;

   END p_modify_case_tmp;

   Note:

   Any DML statement or complex PL/SQL logic can be implemented in the User Exit packages.)
4. Compile the User Exit package and run the report.

In the report, you will find case number prefixed with ABC.