APPS.OKI_LOAD_RAG_PVT dependencies on OKI_REFRESHS

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

26: -- For each distinct organization in OKI_SALES_K_HDRS
27: -- For valid period from GL_PERIODS
28: -- Calculate the forecast amounts
29: -- Determine if the record should be inserted or updated
30: -- Update OKI_REFRESHS table with concurrent manager statistics
31: --
32: -- End of comments
33: --------------------------------------------------------------------------------
34:

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

35:
36: -- Global variable declaration
37:
38: -- variables to log this job run from concurrent manager
39: g_request_id oki.oki_refreshs.request_id%TYPE;
40: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
41: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
42: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
43:

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

36: -- Global variable declaration
37:
38: -- variables to log this job run from concurrent manager
39: g_request_id oki.oki_refreshs.request_id%TYPE;
40: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
41: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
42: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
43:
44:

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

37:
38: -- variables to log this job run from concurrent manager
39: g_request_id oki.oki_refreshs.request_id%TYPE;
40: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
41: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
42: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
43:
44:
45: --------------------------------------------------------------------------------

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

38: -- variables to log this job run from concurrent manager
39: g_request_id oki.oki_refreshs.request_id%TYPE;
40: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
41: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
42: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
43:
44:
45: --------------------------------------------------------------------------------
46: -- Procedure to create the forecast renewal aging records.