eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_REP_UTILS_SUMM_PKG dependencies on PA_REP_UTIL_SUMM_TMP

Line 52: * pa_rep_util_summ_tmp.

48: */
49:
50: /*
51: * Delete Flag identifying whether any deleted record exists in
52: * pa_rep_util_summ_tmp.
53: */
54: l_delete_flag VARCHAR2(1);
55:
56: /*

Line 145: * 1. It loads data into a temporary table pa_rep_util_summ_tmp

141: /*
142: * This procedure reads data from global table, summarize by
143: * PA_PERIOD ,GL Period or Global Expenditure week based on the
144: * global setup data. This procedure has two steps -
145: * 1. It loads data into a temporary table pa_rep_util_summ_tmp
146: * from global PL/SQL Table.
147: * 2. Summarize the data by period depending on setup and populate
148: * a PL/SQL Table.
149: */

Line 172: * Populate pa_rep_util_summ_tmp for Total Hours.

168: IF ( l_delete_flag <> 'A')
169: THEN
170:
171: /*
172: * Populate pa_rep_util_summ_tmp for Total Hours.
173: */
174: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
175: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';
176: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 175: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';

171: /*
172: * Populate pa_rep_util_summ_tmp for Total Hours.
173: */
174: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
175: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';
176: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
177: END IF;
178: INSERT INTO pa_rep_util_summ_tmp
179: ( RECORD_TYPE

Line 178: INSERT INTO pa_rep_util_summ_tmp

174: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
175: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';
176: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
177: END IF;
178: INSERT INTO pa_rep_util_summ_tmp
179: ( RECORD_TYPE
180: ,EXPENDITURE_ORGANIZATION_ID
181: ,PERSON_ID
182: ,ASSIGNMENT_ID

Line 260: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.

256:
257: IF (l_balance_type_code <> l_actual_c) THEN
258:
259: /*
260: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.
261: */
262: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
263: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
264: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 263: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';

259: /*
260: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.
261: */
262: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
263: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
264: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
265: END IF;
266:
267: INSERT INTO pa_rep_util_summ_tmp

Line 267: INSERT INTO pa_rep_util_summ_tmp

263: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
264: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
265: END IF;
266:
267: INSERT INTO pa_rep_util_summ_tmp
268: ( RECORD_TYPE
269: ,EXPENDITURE_ORGANIZATION_ID
270: ,PERSON_ID
271: ,ASSIGNMENT_ID

Line 346: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.

342: AND TOTAL_PROV_HOURS <> 0;
343: END IF;
344:
345: /*
346: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.
347: */
348: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
349: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
350: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 349: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';

345: /*
346: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.
347: */
348: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
349: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
350: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
351: END IF;
352:
353: INSERT INTO pa_rep_util_summ_tmp

Line 353: INSERT INTO pa_rep_util_summ_tmp

349: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
350: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
351: END IF;
352:
353: INSERT INTO pa_rep_util_summ_tmp
354: ( RECORD_TYPE
355: ,EXPENDITURE_ORGANIZATION_ID
356: ,PERSON_ID
357: ,ASSIGNMENT_ID

Line 431: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.

427: WHERE DELETE_FLAG = 'N'
428: AND TOTAL_WGHTED_HOURS_PEOPLE <> 0;
429:
430: /*
431: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.
432: */
433: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
434: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
435: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 434: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';

430: /*
431: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.
432: */
433: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
434: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
435: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
436: END IF;
437:
438: INSERT INTO pa_rep_util_summ_tmp

Line 438: INSERT INTO pa_rep_util_summ_tmp

434: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
435: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
436: END IF;
437:
438: INSERT INTO pa_rep_util_summ_tmp
439: ( RECORD_TYPE
440: ,EXPENDITURE_ORGANIZATION_ID
441: ,PERSON_ID
442: ,ASSIGNMENT_ID

Line 517: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.

513: AND TOTAL_WGHTED_HOURS_ORG <> 0;
514:
515: IF (l_balance_type_code <> l_actual_c) THEN
516: /*
517: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.
518: */
519: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
520: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
521: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 520: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';

516: /*
517: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.
518: */
519: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
520: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
521: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
522: END IF;
523:
524: INSERT INTO pa_rep_util_summ_tmp

Line 524: INSERT INTO pa_rep_util_summ_tmp

520: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
521: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
522: END IF;
523:
524: INSERT INTO pa_rep_util_summ_tmp
525: ( RECORD_TYPE
526: ,EXPENDITURE_ORGANIZATION_ID
527: ,PERSON_ID
528: ,ASSIGNMENT_ID

Line 602: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.

598: WHERE DELETE_FLAG = 'N'
599: AND PROV_WGHTED_HOURS_PEOPLE <> 0;
600:
601: /*
602: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.
603: */
604: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
605: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
606: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 605: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';

601: /*
602: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.
603: */
604: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
605: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
606: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
607: END IF;
608:
609: INSERT INTO pa_rep_util_summ_tmp

Line 609: INSERT INTO pa_rep_util_summ_tmp

605: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
606: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
607: END IF;
608:
609: INSERT INTO pa_rep_util_summ_tmp
610: ( RECORD_TYPE
611: ,EXPENDITURE_ORGANIZATION_ID
612: ,PERSON_ID
613: ,ASSIGNMENT_ID

Line 688: * Populate pa_rep_util_summ_tmp for Reduce Capacity.

684: AND PROV_WGHTED_HOURS_ORG <> 0;
685:
686: END IF;
687: /*
688: * Populate pa_rep_util_summ_tmp for Reduce Capacity.
689: */
690: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
691: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Reduce Capacity';
692: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 691: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Reduce Capacity';

687: /*
688: * Populate pa_rep_util_summ_tmp for Reduce Capacity.
689: */
690: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
691: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Reduce Capacity';
692: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
693: END IF;
694:
695: INSERT INTO pa_rep_util_summ_tmp

Line 695: INSERT INTO pa_rep_util_summ_tmp

691: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Reduce Capacity';
692: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
693: END IF;
694:
695: INSERT INTO pa_rep_util_summ_tmp
696: ( RECORD_TYPE
697: ,EXPENDITURE_ORGANIZATION_ID
698: ,PERSON_ID
699: ,ASSIGNMENT_ID

Line 778: * Populate pa_rep_util_summ_tmp for Total Hours.

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.
779: */
780:
781: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
782: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';

Line 782: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';

778: * Populate pa_rep_util_summ_tmp for Total Hours.
779: */
780:
781: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
782: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';
783: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
784: END IF;
785:
786: INSERT INTO pa_rep_util_summ_tmp

Line 786: INSERT INTO pa_rep_util_summ_tmp

782: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';
783: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
784: END IF;
785:
786: INSERT INTO pa_rep_util_summ_tmp
787: ( RECORD_TYPE
788: ,EXPENDITURE_ORGANIZATION_ID
789: ,PERSON_ID
790: ,ASSIGNMENT_ID

Line 866: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.

862:
863:
864: IF (l_balance_type_code <> l_actual_c) THEN
865: /*
866: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.
867: */
868: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
869: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
870: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 869: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';

865: /*
866: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.
867: */
868: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
869: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
870: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
871: END IF;
872:
873: INSERT INTO pa_rep_util_summ_tmp

Line 873: INSERT INTO pa_rep_util_summ_tmp

869: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
870: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
871: END IF;
872:
873: INSERT INTO pa_rep_util_summ_tmp
874: ( RECORD_TYPE
875: ,EXPENDITURE_ORGANIZATION_ID
876: ,PERSON_ID
877: ,ASSIGNMENT_ID

Line 952: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.

948:
949: END IF;
950:
951: /*
952: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.
953: */
954: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
955: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
956: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 955: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';

951: /*
952: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.
953: */
954: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
955: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
956: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
957: END IF;
958:
959: INSERT INTO pa_rep_util_summ_tmp

Line 959: INSERT INTO pa_rep_util_summ_tmp

955: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
956: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
957: END IF;
958:
959: INSERT INTO pa_rep_util_summ_tmp
960: ( RECORD_TYPE
961: ,EXPENDITURE_ORGANIZATION_ID
962: ,PERSON_ID
963: ,ASSIGNMENT_ID

Line 1036: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.

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.
1037: */
1038: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1039: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
1040: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 1039: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';

1035: /*
1036: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.
1037: */
1038: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1039: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
1040: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1041: END IF;
1042: INSERT INTO pa_rep_util_summ_tmp
1043: ( RECORD_TYPE

Line 1042: INSERT INTO pa_rep_util_summ_tmp

1038: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1039: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
1040: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1041: END IF;
1042: INSERT INTO pa_rep_util_summ_tmp
1043: ( RECORD_TYPE
1044: ,EXPENDITURE_ORGANIZATION_ID
1045: ,PERSON_ID
1046: ,ASSIGNMENT_ID

Line 1121: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.

1117:
1118: IF (l_balance_type_code <> l_actual_c) THEN
1119:
1120: /*
1121: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.
1122: */
1123: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1124: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
1125: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 1124: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';

1120: /*
1121: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.
1122: */
1123: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1124: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
1125: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1126: END IF;
1127:
1128: INSERT INTO pa_rep_util_summ_tmp

Line 1128: INSERT INTO pa_rep_util_summ_tmp

1124: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
1125: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1126: END IF;
1127:
1128: INSERT INTO pa_rep_util_summ_tmp
1129: ( RECORD_TYPE
1130: ,EXPENDITURE_ORGANIZATION_ID
1131: ,PERSON_ID
1132: ,ASSIGNMENT_ID

Line 1205: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.

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.
1206: */
1207: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1208: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
1209: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 1208: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';

1204: /*
1205: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.
1206: */
1207: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1208: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
1209: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1210: END IF;
1211:
1212: INSERT INTO pa_rep_util_summ_tmp

Line 1212: INSERT INTO pa_rep_util_summ_tmp

1208: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
1209: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1210: END IF;
1211:
1212: INSERT INTO pa_rep_util_summ_tmp
1213: ( RECORD_TYPE
1214: ,EXPENDITURE_ORGANIZATION_ID
1215: ,PERSON_ID
1216: ,ASSIGNMENT_ID

Line 1291: * Populate pa_rep_util_summ_tmp for Reduce Capacity.

1287:
1288: END IF;
1289:
1290: /*
1291: * Populate pa_rep_util_summ_tmp for Reduce Capacity.
1292: */
1293: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1294: PA_DEBUG.g_err_stage:='Populate pa_rep_util_summ_tmp for Reduce Capacity';
1295: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 1294: PA_DEBUG.g_err_stage:='Populate pa_rep_util_summ_tmp for Reduce Capacity';

1290: /*
1291: * Populate pa_rep_util_summ_tmp for Reduce Capacity.
1292: */
1293: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1294: PA_DEBUG.g_err_stage:='Populate pa_rep_util_summ_tmp for Reduce Capacity';
1295: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1296: END IF;
1297:
1298: INSERT INTO pa_rep_util_summ_tmp

Line 1298: INSERT INTO pa_rep_util_summ_tmp

1294: PA_DEBUG.g_err_stage:='Populate pa_rep_util_summ_tmp for Reduce Capacity';
1295: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1296: END IF;
1297:
1298: INSERT INTO pa_rep_util_summ_tmp
1299: ( RECORD_TYPE
1300: ,EXPENDITURE_ORGANIZATION_ID
1301: ,PERSON_ID
1302: ,ASSIGNMENT_ID

Line 1378: * table pa_rep_util_summ_tmp based on setup.

1374: END IF;
1375:
1376: /*
1377: * Step 2 - Populate PL/SQL Table after summarizing data from global temporary
1378: * table pa_rep_util_summ_tmp based on setup.
1379: */
1380:
1381: /*
1382: * Summarization by PA period if enabled.

Line 1392: INSERT INTO pa_rep_util_summ_tmp

1388: PA_DEBUG.g_err_stage:='Summarization By PA Period';
1389: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1390: END IF;
1391:
1392: INSERT INTO pa_rep_util_summ_tmp
1393: ( record_type,
1394: object_id,
1395: version_id,
1396: period_type,

Line 1466: FROM pa_rep_util_summ_tmp

1462: NULL,
1463: NULL,
1464: NULL,
1465: NULL
1466: FROM pa_rep_util_summ_tmp
1467: -- mpuvathi: changed line below so that it is an FTS instead of an index scan
1468: -- WHERE record_type = 'TMP1'
1469: WHERE process_mode_flag = 'NN'
1470: GROUP BY AMOUNT_TYPE_ID,PA_PERIOD_NAME,EXPENDITURE_ORGANIZATION_ID,

Line 1488: INSERT INTO pa_rep_util_summ_tmp

1484: PA_DEBUG.g_err_stage:='Summarization By GL Period';
1485: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1486: END IF;
1487:
1488: INSERT INTO pa_rep_util_summ_tmp
1489: ( record_type,
1490: object_id,
1491: version_id,
1492: period_type,

Line 1562: FROM pa_rep_util_summ_tmp

1558: NULL,
1559: NULL,
1560: NULL,
1561: NULL
1562: FROM pa_rep_util_summ_tmp
1563: -- mpuvathi: changed line below so that it is an FTS instead of an index scan
1564: -- WHERE record_type = 'TMP1'
1565: WHERE process_mode_flag = 'NN'
1566: GROUP BY AMOUNT_TYPE_ID,GL_PERIOD_NAME,EXPENDITURE_ORGANIZATION_ID,

Line 1584: INSERT INTO pa_rep_util_summ_tmp

1580: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1581: END IF;
1582:
1583:
1584: INSERT INTO pa_rep_util_summ_tmp
1585: ( record_type,
1586: object_id,
1587: version_id,
1588: period_type,

Line 1657: FROM pa_rep_util_summ_tmp

1653: NULL,
1654: NULL,
1655: NULL,
1656: NULL
1657: FROM pa_rep_util_summ_tmp
1658: -- mpuvathi: changed line below so that it is an FTS instead of an index scan
1659: -- WHERE record_type = 'TMP1'
1660: WHERE process_mode_flag = 'NN'
1661: GROUP BY AMOUNT_TYPE_ID,GLOBAL_EXP_PERIOD_END_DATE,

Line 1692: INSERT INTO pa_rep_util_summ_tmp

1688: PA_DEBUG.g_err_stage := 'Summarization at resource level';
1689: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1690: END IF;
1691:
1692: INSERT INTO pa_rep_util_summ_tmp
1693: ( record_type,
1694: object_id,
1695: version_id,
1696: object_type_code,

Line 1765: from pa_rep_util_summ_tmp

1761: '000','R'), /* Expenditure Organization
1762: Organization Utilization
1763: Resource Utilization Level */
1764: 'II'
1765: from pa_rep_util_summ_tmp
1766: WHERE record_type = 'TMP1A'
1767: AND process_mode_flag = 'II'
1768: AND summ_level_flag = 'U'
1769: group by period_type,

Line 1985: PA_DEBUG.g_err_stage := 'Inserting Records into pa_rep_util_summ_tmp for capacity';

1981: , x_msg_count => l_msg_count
1982: , x_msg_data => l_msg_data);
1983:
1984: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1985: PA_DEBUG.g_err_stage := 'Inserting Records into pa_rep_util_summ_tmp for capacity';
1986: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1987: END IF;
1988:
1989: FORALL I in l_out_person_id_tab.FIRST..l_out_person_id_tab.LAST

Line 1990: INSERT INTO pa_rep_util_summ_tmp

1986: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1987: END IF;
1988:
1989: FORALL I in l_out_person_id_tab.FIRST..l_out_person_id_tab.LAST
1990: INSERT INTO pa_rep_util_summ_tmp
1991: ( record_type,
1992: object_id,
1993: version_id,
1994: object_type_code,

Line 2091: INSERT INTO pa_rep_util_summ_tmp

2087: PA_DEBUG.g_err_stage := 'Summarizing at Organization level';
2088: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2089: END IF;
2090:
2091: INSERT INTO pa_rep_util_summ_tmp
2092: ( record_type,
2093: object_id,
2094: version_id,
2095: object_type_code,

Line 2161: from pa_rep_util_summ_tmp

2157: NULL,
2158: NULL,
2159: 'O',
2160: 'II'
2161: from pa_rep_util_summ_tmp
2162: where summ_level_flag in ( 'R','S')
2163: and record_type = 'TMP2'
2164: and process_mode_flag = 'II'
2165: and amount_type_id not in (l_tot_wght_hrs_people_id,

Line 2192: pa_rep_util_summ_tmp with record type = 'TMP2' and process_mode_flag = 'II'

2188: raise;
2189: END summarize_temp_data_by_org;
2190:
2191: /** This procedure will find the object Id for each record of
2192: pa_rep_util_summ_tmp with record type = 'TMP2' and process_mode_flag = 'II'
2193: and populate it. If not found, generate an object id **/
2194:
2195:
2196: PROCEDURE populate_object_entity IS

Line 2203: * Update the pa_rep_util_summ_tmp with matching object Id.

2199:
2200: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.summarize_temp_data_by_org');
2201:
2202: /*
2203: * Update the pa_rep_util_summ_tmp with matching object Id.
2204: */
2205: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2206: PA_DEBUG.g_err_stage := 'Update pa_rep_util_summ_tmp with matching object Id';
2207: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 2206: PA_DEBUG.g_err_stage := 'Update pa_rep_util_summ_tmp with matching object Id';

2202: /*
2203: * Update the pa_rep_util_summ_tmp with matching object Id.
2204: */
2205: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2206: PA_DEBUG.g_err_stage := 'Update pa_rep_util_summ_tmp with matching object Id';
2207: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2208: END IF;
2209:
2210: UPDATE pa_rep_util_summ_tmp T

Line 2210: UPDATE pa_rep_util_summ_tmp T

2206: PA_DEBUG.g_err_stage := 'Update pa_rep_util_summ_tmp with matching object Id';
2207: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2208: END IF;
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

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 2247: INSERT INTO pa_rep_util_summ_tmp

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
2248: ( record_type,
2249: object_id,
2250: version_id,
2251: object_type_code,

Line 2300: FROM pa_rep_util_summ_tmp T1

2296: T1.expenditure_type,
2297: T1.expenditure_type_class,
2298: 'H',
2299: 'HH'
2300: FROM pa_rep_util_summ_tmp T1
2301: WHERE T1.record_type = 'TMP2'
2302: -- mpuvathi: since even process_mode_flag would have been updated to NULL
2303: AND T1.process_mode_flag is NULL
2304: AND T1.object_id IS NULL

Line 2306: FROM pa_rep_util_summ_tmp T2

2302: -- mpuvathi: since even process_mode_flag would have been updated to NULL
2303: AND T1.process_mode_flag is NULL
2304: AND T1.object_id IS NULL
2305: AND T1.rowid in (SELECT max(T2.rowid)
2306: FROM pa_rep_util_summ_tmp T2
2307: -- mpuvathi: since even process_mode_flag would have been updated to NULL
2308: WHERE T2.process_mode_flag is NULL
2309: AND T2.object_id IS NULL
2310: AND T2.record_type = 'TMP2'

Line 2325: * Populate the other records of pa_rep_util_summ_tmp with

2321: ;
2322:
2323:
2324: /*
2325: * Populate the other records of pa_rep_util_summ_tmp with
2326: * record type = 'TMP2' and null object Id.
2327: */
2328: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2329: PA_DEBUG.g_err_stage := 'Populate the other records of pa_rep_util_summ_tmp with record type =TMP2 and null object Id';

Line 2329: PA_DEBUG.g_err_stage := 'Populate the other records of pa_rep_util_summ_tmp with record type =TMP2 and null object Id';

2325: * Populate the other records of pa_rep_util_summ_tmp with
2326: * record type = 'TMP2' and null object Id.
2327: */
2328: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2329: PA_DEBUG.g_err_stage := 'Populate the other records of pa_rep_util_summ_tmp with record type =TMP2 and null object Id';
2330: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2331: END IF;
2332:
2333: UPDATE pa_rep_util_summ_tmp T1

Line 2333: UPDATE pa_rep_util_summ_tmp T1

2329: PA_DEBUG.g_err_stage := 'Populate the other records of pa_rep_util_summ_tmp with record type =TMP2 and null object Id';
2330: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2331: END IF;
2332:
2333: UPDATE pa_rep_util_summ_tmp T1
2334: SET (T1.object_id ,
2335: T1.process_mode_flag) = ( SELECT T2.object_id,'II'
2336: FROM pa_rep_util_summ_tmp T2
2337: WHERE T1.OBJECT_TYPE_CODE

Line 2336: FROM pa_rep_util_summ_tmp T2

2332:
2333: UPDATE pa_rep_util_summ_tmp T1
2334: SET (T1.object_id ,
2335: T1.process_mode_flag) = ( SELECT T2.object_id,'II'
2336: FROM pa_rep_util_summ_tmp T2
2337: WHERE T1.OBJECT_TYPE_CODE
2338: = T2.OBJECT_TYPE_CODE
2339: AND T1.BALANCE_TYPE_CODE
2340: = T2.BALANCE_TYPE_CODE

Line 2422: FROM pa_rep_util_summ_tmp

2418: l_request_id,
2419: l_program_application_id,
2420: l_program_id,
2421: l_creation_date
2422: FROM pa_rep_util_summ_tmp
2423: WHERE record_type = 'TMP3'
2424: AND summ_level_flag = 'H'
2425: AND process_mode_flag = 'HH'
2426: AND object_type_code <> l_utildet_c

Line 2490: FROM pa_rep_util_summ_tmp T

2486: , T.GLOBAL_EXP_PERIOD_END_DATE GLOBAL_EXP_PERIOD_END_DATE
2487: , T.PERIOD_YEAR PERIOD_YEAR
2488: , T.QUARTER_OR_MONTH_NUMBER QUARTER_OR_MONTH_NUMBER
2489: , T.AMOUNT_TYPE_ID AMOUNT_TYPE_ID
2490: FROM pa_rep_util_summ_tmp T
2491: WHERE
2492: T.RECORD_TYPE = 'TMP4'
2493: AND T.PROCESS_MODE_FLAG = 'U'
2494: GROUP BY

Line 2521: UPDATE pa_rep_util_summ_tmp B

2517: PA_DEBUG.g_err_stage := 'Update the global temporary table for successful update1';
2518: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2519: END IF;
2520:
2521: UPDATE pa_rep_util_summ_tmp B
2522: SET B.process_mode_flag = 'U'
2523: , B.record_type = 'TMP4'
2524: WHERE exists( SELECT T.period_balance
2525: FROM pa_summ_balances T

Line 2564: * Update the balance entity for existing records of pa_rep_util_summ_tmp

2560: L_QUARTER_OR_MONTH_NUMBER_TAB.delete;
2561: L_AMOUNT_TYPE_ID_TAB.delete;
2562:
2563: /*
2564: * Update the balance entity for existing records of pa_rep_util_summ_tmp
2565: * marked for update.
2566: */
2567: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2568: PA_DEBUG.g_err_stage := 'Update the balance entity for existing records of pa_rep_util_summ_tmp marked for update';

Line 2568: PA_DEBUG.g_err_stage := 'Update the balance entity for existing records of pa_rep_util_summ_tmp marked for update';

2564: * Update the balance entity for existing records of pa_rep_util_summ_tmp
2565: * marked for update.
2566: */
2567: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2568: PA_DEBUG.g_err_stage := 'Update the balance entity for existing records of pa_rep_util_summ_tmp marked for update';
2569: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2570: END IF;
2571:
2572: IF cur_update_bal%ISOPEN then

Line 2628: * Insert new balance records from pa_rep_util_summ_tmp if needed.

2624: CLOSE cur_update_bal;
2625:
2626:
2627: /*
2628: * Insert new balance records from pa_rep_util_summ_tmp if needed.
2629: */
2630: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2631: PA_DEBUG.g_err_stage := 'Insert new balance records from pa_rep_util_summ_tmp if needed.';
2632: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 2631: PA_DEBUG.g_err_stage := 'Insert new balance records from pa_rep_util_summ_tmp if needed.';

2627: /*
2628: * Insert new balance records from pa_rep_util_summ_tmp if needed.
2629: */
2630: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2631: PA_DEBUG.g_err_stage := 'Insert new balance records from pa_rep_util_summ_tmp if needed.';
2632: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2633: END IF;
2634:
2635: INSERT INTO pa_summ_balances

Line 2666: FROM pa_rep_util_summ_tmp

2662: max(UNIT_OF_MEASURE),
2663: sum(PERIOD_BALANCE),
2664: NULL,
2665: NULL
2666: FROM pa_rep_util_summ_tmp
2667: WHERE RECORD_TYPE = 'TMP2'
2668: -- mpuvathi: for both UI and II
2669: AND PROCESS_MODE_FLAG in ('UI' , 'II')
2670: AND object_type_code <> l_utildet_c

Line 2688: * This will populate the PA_REP_UTIL_SUMM_TMP table for incremental rollup.

2684: END populate_balance_entity;
2685:
2686:
2687: /*
2688: * This will populate the PA_REP_UTIL_SUMM_TMP table for incremental rollup.
2689: */
2690: PROCEDURE populate_incremental_rollup
2691: IS
2692: /*

Line 2727: * populate PA_REP_UTIL_SUMM_TMP for total hours.

2723:
2724: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.populate_incremental_rollup');
2725:
2726: /*
2727: * populate PA_REP_UTIL_SUMM_TMP for total hours.
2728: */
2729: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2730: PA_DEBUG.g_err_stage := 'populate PA_REP_UTIL_SUMM_TMP for total hours';
2731: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 2730: PA_DEBUG.g_err_stage := 'populate PA_REP_UTIL_SUMM_TMP for total hours';

2726: /*
2727: * populate PA_REP_UTIL_SUMM_TMP for total hours.
2728: */
2729: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2730: PA_DEBUG.g_err_stage := 'populate PA_REP_UTIL_SUMM_TMP for total hours';
2731: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2732: END IF;
2733:
2734: INSERT INTO pa_rep_util_summ_tmp

Line 2734: INSERT INTO pa_rep_util_summ_tmp

2730: PA_DEBUG.g_err_stage := 'populate PA_REP_UTIL_SUMM_TMP for total hours';
2731: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2732: END IF;
2733:
2734: INSERT INTO pa_rep_util_summ_tmp
2735: ( record_type,
2736: object_id,
2737: version_id,
2738: object_type_code,

Line 2799: from pa_rep_util_summ_tmp tmp,

2795: tmp.expenditure_type,
2796: tmp.expenditure_type_class,
2797: 'O',
2798: 'II'
2799: from pa_rep_util_summ_tmp tmp,
2800: pa_org_hierarchy_denorm org,
2801: pa_implementations imp,
2802: (select 'T' dummy_col from dual union select 'S' from dual) dummytab
2803: where tmp.summ_level_flag = 'O'

Line 2876: * If incremental rollup is enabled, populate the pa_rep_util_summ_tmp.

2872:
2873: summarize_temp_data_by_org;
2874:
2875: /*
2876: * If incremental rollup is enabled, populate the pa_rep_util_summ_tmp.
2877: */
2878: IF (l_org_rollup_method = 'I')
2879: THEN
2880: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 2893: * Populate the object entity from pa_rep_util_summ_tmp

2889:
2890: END IF;
2891:
2892: /*
2893: * Populate the object entity from pa_rep_util_summ_tmp
2894: * for record_type='TMP2'.
2895: */
2896: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2897: PA_DEBUG.g_err_stage := 'Before calling populate_object_entity';

Line 2904: * Populate the balance entity from pa_rep_util_summ_tmp

2900:
2901: populate_object_entity;
2902:
2903: /*
2904: * Populate the balance entity from pa_rep_util_summ_tmp
2905: * for record_type='TMP2'.
2906: */
2907: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2908: PA_DEBUG.g_err_stage := 'Before calling populate_balance_entity';