APPS.OKI_LOAD_SGR_PVT dependencies on OKI_REFRESHS

Line 42: -- Update OKI_REFRESHS table with concurrent manager statistics

38: -- Determine if each of the above should be inserted or updated
39: -- For each summary build date
40: -- Repeat steps 1 - 9 above.
41: -- Determine if each of the above should be inserted or updated
42: -- Update OKI_REFRESHS table with concurrent manager statistics
43: --
44: -- End of comments
45: --------------------------------------------------------------------------------
46:

Line 51: g_request_id oki.oki_refreshs.request_id%TYPE;

47:
48: -- Global variable declaration
49:
50: -- variables to log this job run from concurrent manager
51: g_request_id oki.oki_refreshs.request_id%TYPE;
52: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
53: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
54: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
55:

Line 52: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;

48: -- Global variable declaration
49:
50: -- variables to log this job run from concurrent manager
51: g_request_id oki.oki_refreshs.request_id%TYPE;
52: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
53: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
54: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
55:
56:

Line 53: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;

49:
50: -- variables to log this job run from concurrent manager
51: g_request_id oki.oki_refreshs.request_id%TYPE;
52: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
53: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
54: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
55:
56:
57: --------------------------------------------------------------------------------

Line 54: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;

50: -- variables to log this job run from concurrent manager
51: g_request_id oki.oki_refreshs.request_id%TYPE;
52: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
53: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
54: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
55:
56:
57: --------------------------------------------------------------------------------
58: -- Procedure to create the sequential growth rate records.