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.PJI_PJP_SUM_ROLLUP dependencies on PJI_PA_PROJ_EVENTS_LOG

Line 326: insert into PJI_PA_PROJ_EVENTS_LOG

322: l_last_update_login := FND_GLOBAL.LOGIN_ID;
323:
324: if (l_extraction_type = 'FULL') then
325:
326: insert into PJI_PA_PROJ_EVENTS_LOG
327: (
328: WORKER_ID,
329: LOG_ROWID,
330: EVENT_TYPE,

Line 400: from PJI_PA_PROJ_EVENTS_LOG

396:
397: delete
398: from PA_PJI_PROJ_EVENTS_LOG
399: where ROWID in (select LOG_ROWID
400: from PJI_PA_PROJ_EVENTS_LOG
401: where WORKER_ID = p_worker_id);
402:
403: elsif (l_extraction_type = 'INCREMENTAL') then
404:

Line 407: insert into PJI_PA_PROJ_EVENTS_LOG

403: elsif (l_extraction_type = 'INCREMENTAL') then
404:
405: for c in events(p_worker_id) loop
406:
407: insert into PJI_PA_PROJ_EVENTS_LOG
408: (
409: WORKER_ID,
410: LOG_ROWID,
411: EVENT_TYPE,

Line 478: insert into PJI_PA_PROJ_EVENTS_LOG

474: end loop;
475:
476: for c in prg_change_events(p_worker_id) loop
477:
478: insert into PJI_PA_PROJ_EVENTS_LOG
479: (
480: WORKER_ID,
481: LOG_ROWID,
482: EVENT_TYPE,

Line 550: from PJI_PA_PROJ_EVENTS_LOG log1

546:
547: -- RBS_PRG events override RBS_ASSOC events
548:
549: delete
550: from PJI_PA_PROJ_EVENTS_LOG log1
551: where log1.WORKER_ID = p_worker_id and
552: log1.EVENT_TYPE = 'RBS_ASSOC' and
553: exists (select 1
554: from PJI_PA_PROJ_EVENTS_LOG log2

Line 554: from PJI_PA_PROJ_EVENTS_LOG log2

550: from PJI_PA_PROJ_EVENTS_LOG log1
551: where log1.WORKER_ID = p_worker_id and
552: log1.EVENT_TYPE = 'RBS_ASSOC' and
553: exists (select 1
554: from PJI_PA_PROJ_EVENTS_LOG log2
555: where log2.WORKER_ID = p_worker_id and
556: log2.EVENT_TYPE = 'RBS_PRG' and
557: log2.EVENT_OBJECT = log1.EVENT_OBJECT and
558: log2.ATTRIBUTE1 = log1.ATTRIBUTE1);

Line 566: from PJI_PA_PROJ_EVENTS_LOG

562: for c in (select distinct
563: EVENT_OBJECT RBS_VERSION_ID,
564: ATTRIBUTE1 PROJECT_ID,
565: ATTRIBUTE2 RBS_HEADER_ID
566: from PJI_PA_PROJ_EVENTS_LOG
567: where WORKER_ID = p_worker_id and
568: EVENT_TYPE = 'RBS_PRG') loop
569:
570: insert into PJI_PA_PROJ_EVENTS_LOG

Line 570: insert into PJI_PA_PROJ_EVENTS_LOG

566: from PJI_PA_PROJ_EVENTS_LOG
567: where WORKER_ID = p_worker_id and
568: EVENT_TYPE = 'RBS_PRG') loop
569:
570: insert into PJI_PA_PROJ_EVENTS_LOG
571: (
572: WORKER_ID,
573: LOG_ROWID,
574: EVENT_TYPE,

Line 639: PJI_PA_PROJ_EVENTS_LOG log

635: from
636: PA_XBS_DENORM prg,
637: PA_PROJ_ELEMENTS emt,
638: PJI_PJP_RBS_HEADER rbs_hdr,
639: PJI_PA_PROJ_EVENTS_LOG log
640: where
641: prg.SUP_PROJECT_ID = c.PROJECT_ID and
642: (prg.SUB_EMT_ID = prg.SUB_ROLLUP_ID or
643: prg.SUP_EMT_ID <> prg.SUB_EMT_ID) and

Line 659: from PJI_PA_PROJ_EVENTS_LOG

655:
656: end loop;
657:
658: delete
659: from PJI_PA_PROJ_EVENTS_LOG
660: where WORKER_ID = p_worker_id and
661: EVENT_TYPE = 'RBS_PRG';
662:
663: elsif (l_extraction_type = 'PARTIAL') then

Line 737: insert into PJI_PA_PROJ_EVENTS_LOG

733: for c in rbs_push_events(p_worker_id, l_rbs_header_id) loop
734:
735: if (c.ATTRIBUTE2 is not null) then
736:
737: insert into PJI_PA_PROJ_EVENTS_LOG
738: (
739: WORKER_ID,
740: LOG_ROWID,
741: EVENT_TYPE,

Line 812: insert into PJI_PA_PROJ_EVENTS_LOG

808: -- get RBS_DELETE events
809:
810: for c in rbs_delete_events(p_worker_id, l_rbs_header_id) loop
811:
812: insert into PJI_PA_PROJ_EVENTS_LOG
813: (
814: WORKER_ID,
815: LOG_ROWID,
816: EVENT_TYPE,

Line 884: from PJI_PA_PROJ_EVENTS_LOG

880:
881: -- normalize chains of 'RBS_PUSH' events
882:
883: for c in (select EVENT_ID
884: from PJI_PA_PROJ_EVENTS_LOG
885: where WORKER_ID = p_worker_id and
886: EVENT_TYPE = 'RBS_PUSH'
887: order by EVENT_ID) loop
888:

Line 891: from PJI_PA_PROJ_EVENTS_LOG

887: order by EVENT_ID) loop
888:
889: select ATTRIBUTE18
890: into l_chain_flag
891: from PJI_PA_PROJ_EVENTS_LOG
892: where WORKER_ID = p_worker_id and
893: EVENT_TYPE = 'RBS_PUSH' and
894: EVENT_ID = c.EVENT_ID;
895:

Line 898: update PJI_PA_PROJ_EVENTS_LOG log1

894: EVENT_ID = c.EVENT_ID;
895:
896: if (l_chain_flag is null) then
897:
898: update PJI_PA_PROJ_EVENTS_LOG log1
899: set log1.ATTRIBUTE18 = 'PJI$LIST',
900: log1.ATTRIBUTE17 = c.EVENT_ID
901: where log1.WORKER_ID = p_worker_id and
902: log1.EVENT_TYPE = 'RBS_PUSH' and

Line 907: PJI_PA_PROJ_EVENTS_LOG log1

903: log1.EVENT_ID in
904: (select
905: log1.EVENT_ID
906: from
907: PJI_PA_PROJ_EVENTS_LOG log1
908: start with
909: log1.WORKER_ID = p_worker_id and
910: log1.EVENT_TYPE = 'RBS_PUSH' and
911: log1.EVENT_ID = c.EVENT_ID and

Line 918: from PJI_PA_PROJ_EVENTS_LOG log1

914: log1.ATTRIBUTE2 = prior log1.EVENT_OBJECT);
915:
916: select log1.EVENT_OBJECT
917: into l_last_rbs_link
918: from PJI_PA_PROJ_EVENTS_LOG log1
919: where log1.WORKER_ID = p_worker_id and
920: log1.EVENT_TYPE = 'RBS_PUSH' and
921: log1.ATTRIBUTE17 = c.EVENT_ID and
922: log1.ATTRIBUTE18 = 'PJI$LIST' and

Line 924: from PJI_PA_PROJ_EVENTS_LOG log2

920: log1.EVENT_TYPE = 'RBS_PUSH' and
921: log1.ATTRIBUTE17 = c.EVENT_ID and
922: log1.ATTRIBUTE18 = 'PJI$LIST' and
923: log1.EVENT_ID in (select max(log2.EVENT_ID)
924: from PJI_PA_PROJ_EVENTS_LOG log2
925: where log2.WORKER_ID = p_worker_id and
926: log2.EVENT_TYPE = 'RBS_PUSH' and
927: log2.ATTRIBUTE17 = c.EVENT_ID and
928: log2.ATTRIBUTE18 = 'PJI$LIST');

Line 930: update PJI_PA_PROJ_EVENTS_LOG

926: log2.EVENT_TYPE = 'RBS_PUSH' and
927: log2.ATTRIBUTE17 = c.EVENT_ID and
928: log2.ATTRIBUTE18 = 'PJI$LIST');
929:
930: update PJI_PA_PROJ_EVENTS_LOG
931: set EVENT_OBJECT = l_last_rbs_link
932: where WORKER_ID = p_worker_id and
933: EVENT_TYPE = 'RBS_PUSH' and
934: ATTRIBUTE17 = c.EVENT_ID and

Line 943: insert into PJI_PA_PROJ_EVENTS_LOG

939: end loop;
940:
941: -- 'RBS_DELETE' event overrides 'RBS_PUSH' event
942:
943: insert into PJI_PA_PROJ_EVENTS_LOG
944: (
945: WORKER_ID,
946: LOG_ROWID,
947: EVENT_TYPE,

Line 1005: PJI_PA_PROJ_EVENTS_LOG log_del,

1001: log_del.ATTRIBUTE18,
1002: log_del.ATTRIBUTE19,
1003: log_del.ATTRIBUTE20
1004: from
1005: PJI_PA_PROJ_EVENTS_LOG log_del,
1006: PJI_PA_PROJ_EVENTS_LOG log_push
1007: where
1008: log_del.WORKER_ID = p_worker_id and
1009: log_del.EVENT_TYPE = 'RBS_DELETE' and

Line 1006: PJI_PA_PROJ_EVENTS_LOG log_push

1002: log_del.ATTRIBUTE19,
1003: log_del.ATTRIBUTE20
1004: from
1005: PJI_PA_PROJ_EVENTS_LOG log_del,
1006: PJI_PA_PROJ_EVENTS_LOG log_push
1007: where
1008: log_del.WORKER_ID = p_worker_id and
1009: log_del.EVENT_TYPE = 'RBS_DELETE' and
1010: log_push.WORKER_ID = p_worker_id and

Line 1015: from PJI_PA_PROJ_EVENTS_LOG log1

1011: log_push.EVENT_TYPE = 'RBS_PUSH' and
1012: log_push.EVENT_OBJECT = log_del.EVENT_OBJECT;
1013:
1014: delete
1015: from PJI_PA_PROJ_EVENTS_LOG log1
1016: where log1.WORKER_ID = p_worker_id and
1017: log1.EVENT_TYPE = 'RBS_PUSH' and
1018: log1.EVENT_OBJECT in (select log2.EVENT_OBJECT
1019: from PJI_PA_PROJ_EVENTS_LOG log2

Line 1019: from PJI_PA_PROJ_EVENTS_LOG log2

1015: from PJI_PA_PROJ_EVENTS_LOG log1
1016: where log1.WORKER_ID = p_worker_id and
1017: log1.EVENT_TYPE = 'RBS_PUSH' and
1018: log1.EVENT_OBJECT in (select log2.EVENT_OBJECT
1019: from PJI_PA_PROJ_EVENTS_LOG log2
1020: where log2.WORKER_ID = p_worker_id and
1021: log2.EVENT_TYPE = 'RBS_DELETE');
1022:
1023: -- add PROJECT_ID to RBS_PUSH events

Line 1025: insert into PJI_PA_PROJ_EVENTS_LOG

1021: log2.EVENT_TYPE = 'RBS_DELETE');
1022:
1023: -- add PROJECT_ID to RBS_PUSH events
1024: /* Midified this insert for bug#6450097 */
1025: insert into PJI_PA_PROJ_EVENTS_LOG
1026: (
1027: WORKER_ID,
1028: LOG_ROWID,
1029: EVENT_TYPE,

Line 1087: PJI_PA_PROJ_EVENTS_LOG log,

1083: log.ATTRIBUTE18,
1084: rbs_prj.PROJECT_ID ATTRIBUTE19,
1085: log.ATTRIBUTE20
1086: from
1087: PJI_PA_PROJ_EVENTS_LOG log,
1088: PA_RBS_PRJ_ASSIGNMENTS rbs_prj,
1089: PA_RBS_VERSIONS_B rbs
1090: where
1091: log.WORKER_ID = p_worker_id and

Line 1097: from PJI_PA_PROJ_EVENTS_LOG

1093: rbs.RBS_VERSION_ID = log.ATTRIBUTE2 and
1094: rbs.rbs_header_id = rbs_prj.rbs_header_id;
1095:
1096: delete
1097: from PJI_PA_PROJ_EVENTS_LOG
1098: where WORKER_ID = p_worker_id and
1099: EVENT_TYPE = 'RBS_PUSH' and
1100: ATTRIBUTE16 = 'N';
1101:

Line 1131: PJI_PA_PROJ_EVENTS_LOG

1127: ATTRIBUTE20 RBS_HEADER_ID,
1128: ATTRIBUTE2 OLD_RBS_VERSION_ID,
1129: EVENT_OBJECT NEW_RBS_VERSION_ID
1130: from
1131: PJI_PA_PROJ_EVENTS_LOG
1132: where
1133: WORKER_ID = p_worker_id and
1134: EVENT_TYPE = 'RBS_PUSH';
1135:

Line 1638: from PJI_PA_PROJ_EVENTS_LOG

1634: LAST_UPDATED_BY = l_last_updated_by,
1635: LAST_UPDATE_LOGIN = l_last_update_login
1636: where PLAN_VERSION_ID = -1 and
1637: PROJECT_ID in (select EVENT_OBJECT
1638: from PJI_PA_PROJ_EVENTS_LOG
1639: where WORKER_ID = p_worker_id and
1640: EVENT_TYPE in ('WBS_CHANGE',
1641: 'WBS_PUBLISH'));
1642:

Line 1685: PJI_PA_PROJ_EVENTS_LOG log,

1681: select
1682: distinct
1683: prj_emt.PROJECT_ID
1684: from
1685: PJI_PA_PROJ_EVENTS_LOG log,
1686: PA_PROJ_ELEMENTS prj_emt,
1687: PJI_PJP_WBS_HEADER hdr
1688: where
1689: log.WORKER_ID = p_worker_id and

Line 1762: PJI_PA_PROJ_EVENTS_LOG log

1758: 'WBS_PUBLISH', -1,
1759: 'PLAN_BASELINE', log.ATTRIBUTE2,
1760: 'PLAN_ORIGINAL', log.ATTRIBUTE2)
1761: from
1762: PJI_PA_PROJ_EVENTS_LOG log
1763: where
1764: log.WORKER_ID = p_worker_id and
1765: log.EVENT_TYPE in ('WBS_CHANGE',
1766: 'WBS_PUBLISH',

Line 1776: from PJI_PA_PROJ_EVENTS_LOG log

1772: delete
1773: from PJI_PJP_RBS_HEADER
1774: where RBS_VERSION_ID in (select distinct
1775: log.EVENT_OBJECT
1776: from PJI_PA_PROJ_EVENTS_LOG log
1777: where log.WORKER_ID = p_worker_id and
1778: log.EVENT_TYPE = 'RBS_DELETE');
1779:
1780: delete

Line 1786: from PJI_PA_PROJ_EVENTS_LOG log

1782: where RBS_VERSION_ID in (select distinct
1783: decode(log.EVENT_TYPE,
1784: 'RBS_PUSH', log.ATTRIBUTE2,
1785: 'RBS_DELETE', log.EVENT_OBJECT)
1786: from PJI_PA_PROJ_EVENTS_LOG log
1787: where log.WORKER_ID = p_worker_id and
1788: log.EVENT_TYPE in ('RBS_PUSH',
1789: 'RBS_DELETE'));
1790:

Line 1800: from PJI_PA_PROJ_EVENTS_LOG log,

1796: RBS_VERSION_ID) in (select distinct
1797: rbs_hdr.PROJECT_ID,
1798: rbs_hdr.PLAN_VERSION_ID,
1799: rbs_hdr.RBS_VERSION_ID
1800: from PJI_PA_PROJ_EVENTS_LOG log,
1801: PJI_PJP_RBS_HEADER rbs_hdr
1802: where log.WORKER_ID = p_worker_id and
1803: log.EVENT_TYPE = 'RBS_PUSH' and
1804: rbs_hdr.RBS_VERSION_ID =

Line 1811: from PJI_PA_PROJ_EVENTS_LOG log,

1807: select distinct
1808: rbs_hdr.PROJECT_ID,
1809: rbs_hdr.PLAN_VERSION_ID,
1810: rbs_hdr.RBS_VERSION_ID
1811: from PJI_PA_PROJ_EVENTS_LOG log,
1812: PJI_PJP_RBS_HEADER rbs_hdr
1813: where log.WORKER_ID = p_worker_id and
1814: log.EVENT_TYPE = 'RBS_DELETE' and
1815: rbs_hdr.RBS_VERSION_ID =

Line 1886: PJI_PA_PROJ_EVENTS_LOG log

1882: 'Y' REPORTING_USAGE_FLAG,
1883: 'N' FP_USAGE_FLAG,
1884: log.ATTRIBUTE19 UPDATE_HEADER_ONLY_FLAG
1885: from
1886: PJI_PA_PROJ_EVENTS_LOG log
1887: where
1888: log.WORKER_ID = p_worker_id and
1889: log.EVENT_TYPE = 'RBS_ASSOC' and
1890: log.ATTRIBUTE20 = 'CONVERTED_RBS_PRG_EVENT'

Line 1906: PJI_PA_PROJ_EVENTS_LOG log

1902: 'N' PROG_REP_USAGE_FLAG,
1903: 'Y' REPORTING_USAGE_FLAG,
1904: 'N' FP_USAGE_FLAG
1905: from
1906: PJI_PA_PROJ_EVENTS_LOG log
1907: where
1908: log.WORKER_ID = p_worker_id and
1909: log.EVENT_TYPE = 'RBS_ASSOC' and
1910: log.ATTRIBUTE20 is null

Line 1926: PJI_PA_PROJ_EVENTS_LOG log

1922: 'N' PROG_REP_USAGE_FLAG,
1923: 'Y' REPORTING_USAGE_FLAG,
1924: 'N' FP_USAGE_FLAG
1925: from
1926: PJI_PA_PROJ_EVENTS_LOG log
1927: where
1928: log.WORKER_ID = p_worker_id and
1929: log.EVENT_TYPE = 'RBS_PUSH'
1930: order by

Line 2222: insert into PJI_PA_PROJ_EVENTS_LOG

2218: l_last_update_login,
2219: 'A'
2220: );
2221:
2222: insert into PJI_PA_PROJ_EVENTS_LOG
2223: (
2224: WORKER_ID,
2225: EVENT_TYPE,
2226: EVENT_ID,

Line 2259: from PJI_PA_PROJ_EVENTS_LOG

2255:
2256: end if;
2257:
2258: delete
2259: from PJI_PA_PROJ_EVENTS_LOG
2260: where WORKER_ID = p_worker_id and
2261: EVENT_TYPE = 'RBS_ASSOC' and
2262: ATTRIBUTE19 = 'MARK_AS_PROG_REP';
2263:

Line 2339: insert into PJI_PA_PROJ_EVENTS_LOG

2335: l_last_update_login,
2336: 'A'
2337: );
2338:
2339: insert into PJI_PA_PROJ_EVENTS_LOG
2340: (
2341: WORKER_ID,
2342: EVENT_TYPE,
2343: EVENT_ID,

Line 2416: insert into PJI_PA_PROJ_EVENTS_LOG

2412: where PROJECT_ID = c.PROJECT_ID and
2413: RBS_VERSION_ID = c.OLD_RBS_VERSION_ID and
2414: PLAN_VERSION_ID = -1;
2415:
2416: insert into PJI_PA_PROJ_EVENTS_LOG
2417: (
2418: WORKER_ID,
2419: EVENT_TYPE,
2420: EVENT_ID,

Line 2608: PJI_PA_PROJ_EVENTS_LOG log

2604: 'X' RELATIONSHIP_TYPE,
2605: +1 SIGN
2606: from
2607: PA_XBS_DENORM wbs,
2608: PJI_PA_PROJ_EVENTS_LOG log
2609: where
2610: log.WORKER_ID = p_worker_id and
2611: log.EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH') and
2612: wbs.STRUCT_TYPE = 'WBS' and

Line 2638: PJI_PA_PROJ_EVENTS_LOG log

2634: 'X' RELATIONSHIP_TYPE,
2635: -1 SIGN
2636: from
2637: PJI_XBS_DENORM wbs,
2638: PJI_PA_PROJ_EVENTS_LOG log
2639: where
2640: log.WORKER_ID = p_worker_id and
2641: log.EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH') and
2642: wbs.STRUCT_TYPE = 'WBS' and

Line 2668: PJI_PA_PROJ_EVENTS_LOG log

2664: prg.RELATIONSHIP_TYPE,
2665: +1 SIGN
2666: from
2667: PA_XBS_DENORM prg,
2668: PJI_PA_PROJ_EVENTS_LOG log
2669: where
2670: log.WORKER_ID = p_worker_id and
2671: log.EVENT_TYPE = 'PRG_CHANGE' and
2672: log.EVENT_OBJECT <> -1 and

Line 2698: PJI_PA_PROJ_EVENTS_LOG log

2694: prg.RELATIONSHIP_TYPE,
2695: -1 SIGN
2696: from
2697: PJI_XBS_DENORM prg,
2698: PJI_PA_PROJ_EVENTS_LOG log
2699: where
2700: log.WORKER_ID = p_worker_id and
2701: log.EVENT_TYPE = 'PRG_CHANGE' and
2702: log.EVENT_OBJECT <> -1 and

Line 2725: insert into PJI_PA_PROJ_EVENTS_LOG

2721: sum(SIGN) <> 0;
2722:
2723: -- push down program RBSs across new links
2724:
2725: insert into PJI_PA_PROJ_EVENTS_LOG
2726: (
2727: WORKER_ID,
2728: LOG_ROWID,
2729: EVENT_TYPE,

Line 2834: PJI_PA_PROJ_EVENTS_LOG log

2830: sub_ver.ELEMENT_VERSION_ID = prg.SUB_ID and
2831: hdr.RBS_VERSION_ID = sup_rbs_hdr.RBS_VERSION_ID
2832: ) evt,
2833: PJI_PJP_RBS_HEADER sub_rbs_hdr,
2834: PJI_PA_PROJ_EVENTS_LOG log
2835: where
2836: evt.ATTRIBUTE1 = sub_rbs_hdr.PROJECT_ID (+) and
2837: -1 = sub_rbs_hdr.PLAN_VERSION_ID (+) and
2838: evt.EVENT_OBJECT = sub_rbs_hdr.RBS_VERSION_ID (+) and

Line 2863: PJI_PA_PROJ_EVENTS_LOG log

2859: 'Y' REPORTING_USAGE_FLAG,
2860: 'N' FP_USAGE_FLAG,
2861: log.ATTRIBUTE19 UPDATE_HEADER_ONLY_FLAG
2862: from
2863: PJI_PA_PROJ_EVENTS_LOG log
2864: where
2865: log.WORKER_ID = p_worker_id and
2866: log.EVENT_TYPE = 'RBS_ASSOC' and
2867: log.ATTRIBUTE20 = 'NEW_CONVERTED_RBS_PRG_EVENT'

Line 2931: insert into PJI_PA_PROJ_EVENTS_LOG

2927: l_last_update_login,
2928: 'A'
2929: );
2930:
2931: insert into PJI_PA_PROJ_EVENTS_LOG
2932: (
2933: WORKER_ID,
2934: EVENT_TYPE,
2935: EVENT_ID,

Line 3155: PJI_PA_PROJ_EVENTS_LOG log

3151: 'X' SUB_LEAF_FLAG,
3152: +1 SIGN
3153: from
3154: PA_RBS_DENORM rbs,
3155: PJI_PA_PROJ_EVENTS_LOG log
3156: where
3157: log.WORKER_ID = p_worker_id and
3158: log.EVENT_TYPE = 'RBS_PUSH' and
3159: rbs.STRUCT_VERSION_ID = log.EVENT_OBJECT

Line 3175: PJI_PA_PROJ_EVENTS_LOG log

3171: 'X' SUB_LEAF_FLAG,
3172: -1 SIGN
3173: from
3174: PJI_RBS_DENORM rbs,
3175: PJI_PA_PROJ_EVENTS_LOG log
3176: where
3177: log.WORKER_ID = p_worker_id and
3178: log.EVENT_TYPE = 'RBS_PUSH' and
3179: rbs.STRUCT_VERSION_ID = log.ATTRIBUTE2

Line 3996: PJI_PA_PROJ_EVENTS_LOG log

3992: distinct
3993: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
3994: to_number(log.ATTRIBUTE1) PROJECT_ID
3995: from
3996: PJI_PA_PROJ_EVENTS_LOG log
3997: where
3998: log.WORKER_ID = p_worker_id and
3999: log.EVENT_TYPE = 'RBS_ASSOC'
4000: ) log

Line 4080: PJI_PA_PROJ_EVENTS_LOG log

4076: distinct
4077: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
4078: to_numbeR(log.ATTRIBUTE1) PROJECT_ID
4079: from
4080: PJI_PA_PROJ_EVENTS_LOG log
4081: where
4082: log.WORKER_ID = p_worker_id and
4083: log.EVENT_TYPE = 'RBS_ASSOC'
4084: ) log

Line 4157: PJI_PA_PROJ_EVENTS_LOG log,

4153: to_number(null) G2_OTH_COMMITTED_COST,
4154: bal.QUANTITY,
4155: bal.BILL_QUANTITY
4156: from
4157: PJI_PA_PROJ_EVENTS_LOG log,
4158: PJI_PJP_PROJ_EXTR_STATUS stat,
4159: PJI_FP_TXN_ACCUM bal
4160: where
4161: l_extraction_type = 'RBS' and

Line 4236: PJI_PA_PROJ_EVENTS_LOG log,

4232: bal.G2_OTH_COMMITTED_COST,
4233: to_number(null) QUANTITY,
4234: to_number(null) BILL_QUANTITY
4235: from
4236: PJI_PA_PROJ_EVENTS_LOG log,
4237: PJI_PJP_PROJ_EXTR_STATUS stat,
4238: PJI_FP_TXN_ACCUM1 bal
4239: where
4240: l_extraction_type = 'RBS' and

Line 7476: PJI_PA_PROJ_EVENTS_LOG log

7472: distinct
7473: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
7474: to_number(log.ATTRIBUTE1) PROJECT_ID
7475: from
7476: PJI_PA_PROJ_EVENTS_LOG log
7477: where
7478: log.WORKER_ID = p_worker_id and
7479: log.EVENT_TYPE = 'RBS_ASSOC'
7480: ) log

Line 8776: PJI_PA_PROJ_EVENTS_LOG log,

8772: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
8773: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
8774: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
8775: from
8776: PJI_PA_PROJ_EVENTS_LOG log,
8777: PJI_PJP_WBS_HEADER wbs_hdr,
8778: PJI_XBS_DENORM_DELTA wbs,
8779: PJI_XBS_DENORM prg,
8780: PJI_FP_XBS_ACCUM_F fpr,

Line 12604: PJI_PA_PROJ_EVENTS_LOG log,

12600: wbs.SIGN * acr.CUSTOM13 CUSTOM13,
12601: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
12602: wbs.SIGN * acr.CUSTOM15 CUSTOM15
12603: from
12604: PJI_PA_PROJ_EVENTS_LOG log,
12605: PJI_PJP_WBS_HEADER wbs_hdr,
12606: PJI_XBS_DENORM_DELTA wbs,
12607: PJI_XBS_DENORM prg,
12608: PJI_AC_XBS_ACCUM_F acr,

Line 16369: PJI_PA_PROJ_EVENTS_LOG log,

16365: decode(invert.INVERT_ID,
16366: 1, log.EVENT_OBJECT,
16367: 2, log.ATTRIBUTE1) PRG_GROUP
16368: from
16369: PJI_PA_PROJ_EVENTS_LOG log,
16370: (
16371: select 1 INVERT_ID from DUAL union all
16372: select 2 INVERT_ID from DUAL
16373: ) invert

Line 16380: from PJI_PA_PROJ_EVENTS_LOG log,Pji_pjp_wbs_header ver

16376: log.EVENT_TYPE = 'PRG_CHANGE' and
16377: log.EVENT_OBJECT <> -1)
16378: union all
16379: select ver.wbs_version_id
16380: from PJI_PA_PROJ_EVENTS_LOG log,Pji_pjp_wbs_header ver
16381: where ver.project_id=to_number(log.ATTRIBUTE1) and
16382: log.WORKER_ID = p_worker_id and
16383: log.EVENT_TYPE = 'PRG_CHANGE' and
16384: log.EVENT_OBJECT = -1

Line 16389: from PJI_PA_PROJ_EVENTS_LOG log,

16385: union all
16386: select to_number(decode(invert.INVERT_ID,
16387: 1, log.EVENT_OBJECT,
16388: 2, log.ATTRIBUTE2)) struct_version_id
16389: from PJI_PA_PROJ_EVENTS_LOG log,
16390: (
16391: select 1 INVERT_ID from DUAL union all
16392: select 2 INVERT_ID from DUAL
16393: ) invert

Line 16417: PJI_PA_PROJ_EVENTS_LOG log,

16413: decode(invert.INVERT_ID,
16414: 1, log.EVENT_OBJECT,
16415: 2, log.ATTRIBUTE1) PRG_GROUP
16416: from
16417: PJI_PA_PROJ_EVENTS_LOG log,
16418: (
16419: select 1 INVERT_ID from DUAL union all
16420: select 2 INVERT_ID from DUAL
16421: ) invert

Line 16431: from PJI_PA_PROJ_EVENTS_LOG log

16427: l_count := l_count + sql%rowcount;
16428:
16429: delete from PJI_XBS_DENORM
16430: where SUP_PROJECT_ID in (select log.ATTRIBUTE1
16431: from PJI_PA_PROJ_EVENTS_LOG log
16432: where log.WORKER_ID = p_worker_id and
16433: log.EVENT_TYPE = 'PRG_CHANGE' and
16434: log.EVENT_OBJECT = -1);
16435:

Line 16445: PJI_PA_PROJ_EVENTS_LOG log,

16441: decode(invert.INVERT_ID,
16442: 1, log.EVENT_OBJECT,
16443: 2, log.ATTRIBUTE2)
16444: from
16445: PJI_PA_PROJ_EVENTS_LOG log,
16446: (
16447: select 1 INVERT_ID from DUAL union all
16448: select 2 INVERT_ID from DUAL
16449: ) invert

Line 16515: PJI_PA_PROJ_EVENTS_LOG log,

16511: decode(invert.INVERT_ID,
16512: 1, log.EVENT_OBJECT,
16513: 2, log.ATTRIBUTE1) PRG_GROUP
16514: from
16515: PJI_PA_PROJ_EVENTS_LOG log,
16516: (
16517: select 1 INVERT_ID from DUAL union all
16518: select 2 INVERT_ID from DUAL
16519: ) invert

Line 16526: from PJI_PA_PROJ_EVENTS_LOG log

16522: log.EVENT_TYPE = 'PRG_CHANGE' and
16523: log.EVENT_OBJECT <> -1)
16524: union
16525: select to_number(log.ATTRIBUTE1) PROJECT_ID
16526: from PJI_PA_PROJ_EVENTS_LOG log
16527: where log.WORKER_ID = p_worker_id and
16528: log.EVENT_TYPE = 'PRG_CHANGE' and
16529: log.EVENT_OBJECT = -1)
16530: union all

Line 16559: PJI_PA_PROJ_EVENTS_LOG

16555: distinct
16556: EVENT_OBJECT,
16557: ATTRIBUTE2
16558: from
16559: PJI_PA_PROJ_EVENTS_LOG
16560: where
16561: WORKER_ID = p_worker_id and
16562: EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH')
16563: ) log

Line 16889: from PJI_PA_PROJ_EVENTS_LOG log

16885: l_extraction_type = 'FULL')) then
16886:
16887: delete from PJI_RBS_DENORM
16888: where STRUCT_VERSION_ID in (select log.EVENT_OBJECT
16889: from PJI_PA_PROJ_EVENTS_LOG log
16890: where log.WORKER_ID = p_worker_id and
16891: log.EVENT_TYPE = 'PJI_RBS_CHANGE');
16892:
16893: insert into PJI_RBS_DENORM

Line 16928: PJI_PA_PROJ_EVENTS_LOG log

16924: select
16925: distinct
16926: log.EVENT_OBJECT
16927: from
16928: PJI_PA_PROJ_EVENTS_LOG log
16929: where
16930: log.WORKER_ID = p_worker_id and
16931: log.EVENT_TYPE in ('PJI_RBS_CHANGE')
16932: ) log

Line 16947: PJI_PA_PROJ_EVENTS_LOG log,

16943: 1, log.EVENT_OBJECT,
16944: 2, log.ATTRIBUTE2),
16945: 'RBS_DELETE', log.EVENT_OBJECT)
16946: from
16947: PJI_PA_PROJ_EVENTS_LOG log,
16948: (
16949: select 1 INVERT_ID from DUAL union all
16950: select 2 INVERT_ID from DUAL
16951: ) invert

Line 16993: PJI_PA_PROJ_EVENTS_LOG

16989: distinct
16990: EVENT_OBJECT,
16991: ATTRIBUTE2
16992: from
16993: PJI_PA_PROJ_EVENTS_LOG
16994: where
16995: WORKER_ID = p_worker_id and
16996: EVENT_TYPE = 'RBS_PUSH'
16997: ) log

Line 18060: 'PJI_PA_PROJ_EVENTS_LOG',

18056: 'PARTITION',
18057: 'P' || p_worker_id);
18058:
18059: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
18060: 'PJI_PA_PROJ_EVENTS_LOG',
18061: 'PARTITION',
18062: 'P' || p_worker_id);
18063:
18064: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);'); -- Bug#5171542