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: AND ASSIGNMENT_ID IS NOT NULL /*bug#8344802*/

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

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

Line 1991: INSERT INTO pa_rep_util_summ_tmp

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

Line 2092: INSERT INTO pa_rep_util_summ_tmp

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

Line 2162: from pa_rep_util_summ_tmp

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

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

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

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

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

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

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

Line 2211: UPDATE pa_rep_util_summ_tmp T

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

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

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

Line 2301: FROM pa_rep_util_summ_tmp T1

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

Line 2307: FROM pa_rep_util_summ_tmp T2

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

Line 2326: * Populate the other records of pa_rep_util_summ_tmp with

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

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

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

Line 2334: UPDATE pa_rep_util_summ_tmp T1

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

Line 2337: FROM pa_rep_util_summ_tmp T2

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

Line 2423: FROM pa_rep_util_summ_tmp

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

Line 2491: FROM pa_rep_util_summ_tmp T

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

Line 2522: UPDATE pa_rep_util_summ_tmp B

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

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

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

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

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

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

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

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

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

Line 2667: FROM pa_rep_util_summ_tmp

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

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

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

Line 2728: * populate PA_REP_UTIL_SUMM_TMP for total hours.

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

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

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

Line 2735: INSERT INTO pa_rep_util_summ_tmp

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

Line 2800: from pa_rep_util_summ_tmp tmp,

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

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

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

Line 2894: * Populate the object entity from pa_rep_util_summ_tmp

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

Line 2905: * Populate the balance entity from pa_rep_util_summ_tmp

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