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