APPS.PA_REP_UTILS_SUMM_PKG dependencies on PA_OBJECTS

Line 2214: from pa_objects OB

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

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

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

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

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

Line 2276: pa_objects_s.nextval,

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

Line 2365: * Insert New Objects in PA_OBJECTS.

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

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

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

Line 2372: INSERT INTO PA_OBJECTS

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