APPS.PA_REP_UTILS_SUMM_PKG dependencies on PA_REP_UTIL_SUMM0_TMP

Line 164: * 'A' - means all records from pa_rep_util_summ0_tmp should be processed.

160: */
161:
162: /*
163: * Separate the SQL for delete flag = 'A' and <>'A'
164: * 'A' - means all records from pa_rep_util_summ0_tmp should be processed.
165: * 'F' - means only non deleted record will be processed .
166: */
167:
168: IF ( l_delete_flag <> 'A')

Line 252: FROM pa_rep_util_summ0_tmp

248: NULL,
249: NULL,
250: 'N',
251: 'NN'
252: FROM pa_rep_util_summ0_tmp
253: WHERE DELETE_FLAG = 'N'
254: AND TOTAL_HOURS <> 0;
255:
256:

Line 340: FROM pa_rep_util_summ0_tmp

336: NULL,
337: NULL,
338: 'N',
339: 'NN'
340: FROM pa_rep_util_summ0_tmp
341: WHERE DELETE_FLAG = 'N'
342: AND TOTAL_PROV_HOURS <> 0;
343: END IF;
344:

Line 426: FROM pa_rep_util_summ0_tmp

422: NULL,
423: NULL,
424: 'N',
425: 'NN'
426: FROM pa_rep_util_summ0_tmp
427: WHERE DELETE_FLAG = 'N'
428: AND TOTAL_WGHTED_HOURS_PEOPLE <> 0;
429:
430: /*

Line 511: FROM pa_rep_util_summ0_tmp

507: NULL,
508: NULL,
509: 'N',
510: 'NN'
511: FROM pa_rep_util_summ0_tmp
512: WHERE DELETE_FLAG = 'N'
513: AND TOTAL_WGHTED_HOURS_ORG <> 0;
514:
515: IF (l_balance_type_code <> l_actual_c) THEN

Line 597: FROM pa_rep_util_summ0_tmp

593: NULL,
594: NULL,
595: 'N',
596: 'NN'
597: FROM pa_rep_util_summ0_tmp
598: WHERE DELETE_FLAG = 'N'
599: AND PROV_WGHTED_HOURS_PEOPLE <> 0;
600:
601: /*

Line 682: FROM pa_rep_util_summ0_tmp

678: NULL,
679: NULL,
680: 'N',
681: 'NN'
682: FROM pa_rep_util_summ0_tmp
683: WHERE DELETE_FLAG = 'N'
684: AND PROV_WGHTED_HOURS_ORG <> 0;
685:
686: END IF;

Line 768: FROM pa_rep_util_summ0_tmp

764: NULL,
765: NULL,
766: 'N',
767: 'NN'
768: FROM pa_rep_util_summ0_tmp
769: WHERE DELETE_FLAG = 'N'
770: AND REDUCE_CAPACITY <> 0;
771:
772: ELSE

Line 774: * Here we process all records of pa_rep_util_summ0_tmp.

770: AND REDUCE_CAPACITY <> 0;
771:
772: ELSE
773: /*
774: * Here we process all records of pa_rep_util_summ0_tmp.
775: */
776:
777: /*
778: * Populate pa_rep_util_summ_tmp for Total Hours.

Line 860: FROM pa_rep_util_summ0_tmp

856: NULL,
857: NULL,
858: 'N',
859: 'NN'
860: FROM pa_rep_util_summ0_tmp
861: WHERE TOTAL_HOURS <> 0;
862:
863:
864: IF (l_balance_type_code <> l_actual_c) THEN

Line 946: FROM pa_rep_util_summ0_tmp

942: NULL,
943: NULL,
944: 'N',
945: 'NN'
946: FROM pa_rep_util_summ0_tmp
947: WHERE TOTAL_PROV_HOURS <> 0;
948:
949: END IF;
950:

Line 1032: FROM pa_rep_util_summ0_tmp

1028: NULL,
1029: NULL,
1030: 'N',
1031: 'NN'
1032: FROM pa_rep_util_summ0_tmp
1033: WHERE TOTAL_WGHTED_HOURS_PEOPLE <> 0;
1034:
1035: /*
1036: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.

Line 1115: FROM pa_rep_util_summ0_tmp

1111: NULL,
1112: NULL,
1113: 'N',
1114: 'NN'
1115: FROM pa_rep_util_summ0_tmp
1116: WHERE TOTAL_WGHTED_HOURS_ORG <> 0;
1117:
1118: IF (l_balance_type_code <> l_actual_c) THEN
1119:

Line 1201: FROM pa_rep_util_summ0_tmp

1197: NULL,
1198: NULL,
1199: 'N',
1200: 'NN'
1201: FROM pa_rep_util_summ0_tmp
1202: WHERE PROV_WGHTED_HOURS_PEOPLE <> 0;
1203:
1204: /*
1205: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.

Line 1285: FROM pa_rep_util_summ0_tmp

1281: NULL,
1282: NULL,
1283: 'N',
1284: 'NN'
1285: FROM pa_rep_util_summ0_tmp
1286: WHERE PROV_WGHTED_HOURS_ORG <> 0;
1287:
1288: END IF;
1289:

Line 1371: FROM pa_rep_util_summ0_tmp

1367: NULL,
1368: NULL,
1369: 'N',
1370: 'NN'
1371: FROM pa_rep_util_summ0_tmp
1372: WHERE REDUCE_CAPACITY <> 0;
1373:
1374: END IF;
1375:

Line 2452: * before inserting into the global temporary table pa_rep_util_summ0_tmp

2448: PROCEDURE populate_balance_entity IS
2449:
2450: /*
2451: * Define PL/SQL Table for holding the fetched records from the cursor
2452: * before inserting into the global temporary table pa_rep_util_summ0_tmp
2453: */
2454: L_PERIOD_BALANCE_TAB PA_PLSQL_DATATYPES.NumTabTyp;
2455: L_OBJECT_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
2456: L_VERSION_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;