APPS.OKI_LOAD_RBS_PVT dependencies on OKI_REFRESHS

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

42: -- Calculate the signed amounts and counts
43: -- Determine if the record should be inserted or updated
44: -- Calculate the forecast amounts and counts
45: -- Determine if the record should be inserted or updated
46: -- Update OKI_REFRESHS table with concurrent manager statistics
47: --
48: -- End of comments
49: --------------------------------------------------------------------------------
50:

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

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

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

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

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

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

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

53: -- variables to log this job run from concurrent manager
54: g_request_id oki.oki_refreshs.request_id%TYPE;
55: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
56: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
57: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
58:
59:
60: --------------------------------------------------------------------------------
61: -- Procedure to create the renew by statuses records.