APPS.PA_REP_UTILS_SUMM_PKG dependencies on PA_OBJECTS

Line 2213: from pa_objects OB

2209:
2210: UPDATE pa_rep_util_summ_tmp T
2211: SET (T.object_id,T.process_mode_flag)
2212: = ( select OB.object_id ,'UI'
2213: from pa_objects OB
2214: where OB.OBJECT_TYPE_CODE = T.OBJECT_TYPE_CODE
2215: and OB.BALANCE_TYPE_CODE = T.BALANCE_TYPE_CODE
2216: and OB.EXPENDITURE_ORG_ID = T.EXPENDITURE_ORG_ID
2217: and OB.EXPENDITURE_ORGANIZATION_ID

Line 2240: * Populate pa_rep_util_summ_tmp with unique key for pa_objects.

2236: AND T.process_mode_flag = 'II'
2237: ;
2238:
2239: /*
2240: * Populate pa_rep_util_summ_tmp with unique key for pa_objects.
2241: */
2242: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2243: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp with unique key for pa_objects';
2244: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 2243: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp with unique key for pa_objects';

2239: /*
2240: * Populate pa_rep_util_summ_tmp with unique key for pa_objects.
2241: */
2242: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2243: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp with unique key for pa_objects';
2244: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2245: END IF;
2246:
2247: INSERT INTO pa_rep_util_summ_tmp

Line 2275: pa_objects_s.nextval,

2271: expenditure_type_class,
2272: summ_level_flag,
2273: process_mode_flag)
2274: SELECT 'TMP3',
2275: pa_objects_s.nextval,
2276: NULL,
2277: T1.object_type_code,
2278: T1.balance_type_code,
2279: T1.expenditure_org_id,

Line 2364: * Insert New Objects in PA_OBJECTS.

2360: ;
2361:
2362:
2363: /*
2364: * Insert New Objects in PA_OBJECTS.
2365: */
2366: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2367: PA_DEBUG.g_err_stage := 'Insert New Objects in PA_OBJECTS';
2368: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 2367: PA_DEBUG.g_err_stage := 'Insert New Objects in PA_OBJECTS';

2363: /*
2364: * Insert New Objects in PA_OBJECTS.
2365: */
2366: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2367: PA_DEBUG.g_err_stage := 'Insert New Objects in PA_OBJECTS';
2368: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2369: END IF;
2370:
2371: INSERT INTO PA_OBJECTS

Line 2371: INSERT INTO PA_OBJECTS

2367: PA_DEBUG.g_err_stage := 'Insert New Objects in PA_OBJECTS';
2368: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2369: END IF;
2370:
2371: INSERT INTO PA_OBJECTS
2372: ( OBJECT_ID,
2373: OBJECT_TYPE_CODE,
2374: BALANCE_TYPE_CODE,
2375: PROJECT_ORG_ID,