17:
18: -- Global variable declaration
19:
20: -- variables to log this job run from concurrent manager
21: g_request_id oki.oki_refreshs.request_id%TYPE;
22: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
23: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
24: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
25:
18: -- Global variable declaration
19:
20: -- variables to log this job run from concurrent manager
21: g_request_id oki.oki_refreshs.request_id%TYPE;
22: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
23: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
24: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
25:
26: --------------------------------------------------------------------------------
19:
20: -- variables to log this job run from concurrent manager
21: g_request_id oki.oki_refreshs.request_id%TYPE;
22: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
23: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
24: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
25:
26: --------------------------------------------------------------------------------
27: -- Procedure to create top n contract records.
20: -- variables to log this job run from concurrent manager
21: g_request_id oki.oki_refreshs.request_id%TYPE;
22: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
23: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
24: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
25:
26: --------------------------------------------------------------------------------
27: -- Procedure to create top n contract records.
28: --