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 1336: PJI_PA_PROJ_EVENTS_LOG log,

1332: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
1333: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
1334: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
1335: from
1336: PJI_PA_PROJ_EVENTS_LOG log,
1337: -- Commenting and adding code for testing 0802
1338: PJI_PJP_WBS_HEADER_T wbs_hdr,
1339: --PJI_PJP_WBS_HEADER wbs_hdr,
1340: PJI_XBS_DENORM_DELTA wbs,

Line 2720: PJI_PA_PROJ_EVENTS_LOG log,

2716: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
2717: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
2718: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
2719: from
2720: PJI_PA_PROJ_EVENTS_LOG log,
2721: PJI_PJP_WBS_HEADER wbs_hdr,
2722: PJI_XBS_DENORM_DELTA wbs,
2723: PJI_XBS_DENORM prg,
2724: PJI_FP_XBS_ACCUM_F fpr,

Line 3306: insert into PJI_PA_PROJ_EVENTS_LOG

3302: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3303:
3304: if (l_extraction_type = 'FULL') then
3305:
3306: insert into PJI_PA_PROJ_EVENTS_LOG
3307: (
3308: WORKER_ID,
3309: LOG_ROWID,
3310: EVENT_TYPE,

Line 3380: from PJI_PA_PROJ_EVENTS_LOG

3376:
3377: delete
3378: from PA_PJI_PROJ_EVENTS_LOG
3379: where ROWID in (select LOG_ROWID
3380: from PJI_PA_PROJ_EVENTS_LOG
3381: where WORKER_ID = p_worker_id);
3382:
3383: elsif (l_extraction_type = 'INCREMENTAL') then
3384:

Line 3387: insert into PJI_PA_PROJ_EVENTS_LOG

3383: elsif (l_extraction_type = 'INCREMENTAL') then
3384:
3385: for c in events(p_worker_id) loop
3386:
3387: insert into PJI_PA_PROJ_EVENTS_LOG
3388: (
3389: WORKER_ID,
3390: LOG_ROWID,
3391: EVENT_TYPE,

Line 3458: insert into PJI_PA_PROJ_EVENTS_LOG

3454: end loop;
3455:
3456: for c in prg_change_events(p_worker_id) loop
3457:
3458: insert into PJI_PA_PROJ_EVENTS_LOG
3459: (
3460: WORKER_ID,
3461: LOG_ROWID,
3462: EVENT_TYPE,

Line 3530: from PJI_PA_PROJ_EVENTS_LOG log1

3526:
3527: -- RBS_PRG events override RBS_ASSOC events
3528:
3529: delete
3530: from PJI_PA_PROJ_EVENTS_LOG log1
3531: where log1.WORKER_ID = p_worker_id and
3532: log1.EVENT_TYPE = 'RBS_ASSOC' and
3533: exists (select 1
3534: from PJI_PA_PROJ_EVENTS_LOG log2

Line 3534: from PJI_PA_PROJ_EVENTS_LOG log2

3530: from PJI_PA_PROJ_EVENTS_LOG log1
3531: where log1.WORKER_ID = p_worker_id and
3532: log1.EVENT_TYPE = 'RBS_ASSOC' and
3533: exists (select 1
3534: from PJI_PA_PROJ_EVENTS_LOG log2
3535: where log2.WORKER_ID = p_worker_id and
3536: log2.EVENT_TYPE = 'RBS_PRG' and
3537: log2.EVENT_OBJECT = log1.EVENT_OBJECT and
3538: log2.ATTRIBUTE1 = log1.ATTRIBUTE1);

Line 3546: from PJI_PA_PROJ_EVENTS_LOG

3542: for c in (select distinct
3543: EVENT_OBJECT RBS_VERSION_ID,
3544: ATTRIBUTE1 PROJECT_ID,
3545: ATTRIBUTE2 RBS_HEADER_ID
3546: from PJI_PA_PROJ_EVENTS_LOG
3547: where WORKER_ID = p_worker_id and
3548: EVENT_TYPE = 'RBS_PRG') loop
3549:
3550: insert into PJI_PA_PROJ_EVENTS_LOG

Line 3550: insert into PJI_PA_PROJ_EVENTS_LOG

3546: from PJI_PA_PROJ_EVENTS_LOG
3547: where WORKER_ID = p_worker_id and
3548: EVENT_TYPE = 'RBS_PRG') loop
3549:
3550: insert into PJI_PA_PROJ_EVENTS_LOG
3551: (
3552: WORKER_ID,
3553: LOG_ROWID,
3554: EVENT_TYPE,

Line 3619: PJI_PA_PROJ_EVENTS_LOG log

3615: from
3616: PA_XBS_DENORM prg,
3617: PA_PROJ_ELEMENTS emt,
3618: PJI_PJP_RBS_HEADER rbs_hdr,
3619: PJI_PA_PROJ_EVENTS_LOG log
3620: where
3621: prg.SUP_PROJECT_ID = c.PROJECT_ID and
3622: (prg.SUB_EMT_ID = prg.SUB_ROLLUP_ID or
3623: prg.SUP_EMT_ID <> prg.SUB_EMT_ID) and

Line 3639: from PJI_PA_PROJ_EVENTS_LOG

3635:
3636: end loop;
3637:
3638: delete
3639: from PJI_PA_PROJ_EVENTS_LOG
3640: where WORKER_ID = p_worker_id and
3641: EVENT_TYPE = 'RBS_PRG';
3642:
3643: elsif (l_extraction_type = 'PARTIAL') then

Line 3717: insert into PJI_PA_PROJ_EVENTS_LOG

3713: for c in rbs_push_events(p_worker_id, l_rbs_header_id) loop
3714:
3715: if (c.ATTRIBUTE2 is not null) then
3716:
3717: insert into PJI_PA_PROJ_EVENTS_LOG
3718: (
3719: WORKER_ID,
3720: LOG_ROWID,
3721: EVENT_TYPE,

Line 3891: insert into PJI_PA_PROJ_EVENTS_LOG

3887: -- get RBS_DELETE events
3888:
3889: for c in rbs_delete_events(p_worker_id, l_rbs_header_id) loop
3890:
3891: insert into PJI_PA_PROJ_EVENTS_LOG
3892: (
3893: WORKER_ID,
3894: LOG_ROWID,
3895: EVENT_TYPE,

Line 3963: from PJI_PA_PROJ_EVENTS_LOG

3959:
3960: -- normalize chains of 'RBS_PUSH' events
3961:
3962: for c in (select EVENT_ID
3963: from PJI_PA_PROJ_EVENTS_LOG
3964: where WORKER_ID = p_worker_id and
3965: EVENT_TYPE = 'RBS_PUSH'
3966: order by EVENT_ID) loop
3967:

Line 3970: from PJI_PA_PROJ_EVENTS_LOG

3966: order by EVENT_ID) loop
3967:
3968: select ATTRIBUTE18
3969: into l_chain_flag
3970: from PJI_PA_PROJ_EVENTS_LOG
3971: where WORKER_ID = p_worker_id and
3972: EVENT_TYPE = 'RBS_PUSH' and
3973: EVENT_ID = c.EVENT_ID;
3974:

Line 3977: update PJI_PA_PROJ_EVENTS_LOG log1

3973: EVENT_ID = c.EVENT_ID;
3974:
3975: if (l_chain_flag is null) then
3976:
3977: update PJI_PA_PROJ_EVENTS_LOG log1
3978: set log1.ATTRIBUTE18 = 'PJI$LIST',
3979: log1.ATTRIBUTE17 = c.EVENT_ID
3980: where log1.WORKER_ID = p_worker_id and
3981: log1.EVENT_TYPE = 'RBS_PUSH' and

Line 3986: PJI_PA_PROJ_EVENTS_LOG log1

3982: log1.EVENT_ID in
3983: (select
3984: log1.EVENT_ID
3985: from
3986: PJI_PA_PROJ_EVENTS_LOG log1
3987: start with
3988: log1.WORKER_ID = p_worker_id and
3989: log1.EVENT_TYPE = 'RBS_PUSH' and
3990: log1.EVENT_ID = c.EVENT_ID and

Line 3997: from PJI_PA_PROJ_EVENTS_LOG log1

3993: log1.ATTRIBUTE2 = prior log1.EVENT_OBJECT);
3994:
3995: select log1.EVENT_OBJECT
3996: into l_last_rbs_link
3997: from PJI_PA_PROJ_EVENTS_LOG log1
3998: where log1.WORKER_ID = p_worker_id and
3999: log1.EVENT_TYPE = 'RBS_PUSH' and
4000: log1.ATTRIBUTE17 = c.EVENT_ID and
4001: log1.ATTRIBUTE18 = 'PJI$LIST' and

Line 4003: from PJI_PA_PROJ_EVENTS_LOG log2

3999: log1.EVENT_TYPE = 'RBS_PUSH' and
4000: log1.ATTRIBUTE17 = c.EVENT_ID and
4001: log1.ATTRIBUTE18 = 'PJI$LIST' and
4002: log1.EVENT_ID in (select max(log2.EVENT_ID)
4003: from PJI_PA_PROJ_EVENTS_LOG log2
4004: where log2.WORKER_ID = p_worker_id and
4005: log2.EVENT_TYPE = 'RBS_PUSH' and
4006: log2.ATTRIBUTE17 = c.EVENT_ID and
4007: log2.ATTRIBUTE18 = 'PJI$LIST');

Line 4009: update PJI_PA_PROJ_EVENTS_LOG

4005: log2.EVENT_TYPE = 'RBS_PUSH' and
4006: log2.ATTRIBUTE17 = c.EVENT_ID and
4007: log2.ATTRIBUTE18 = 'PJI$LIST');
4008:
4009: update PJI_PA_PROJ_EVENTS_LOG
4010: set EVENT_OBJECT = l_last_rbs_link
4011: where WORKER_ID = p_worker_id and
4012: EVENT_TYPE = 'RBS_PUSH' and
4013: ATTRIBUTE17 = c.EVENT_ID and

Line 4022: insert into PJI_PA_PROJ_EVENTS_LOG

4018: end loop;
4019:
4020: -- 'RBS_DELETE' event overrides 'RBS_PUSH' event
4021:
4022: insert into PJI_PA_PROJ_EVENTS_LOG
4023: (
4024: WORKER_ID,
4025: LOG_ROWID,
4026: EVENT_TYPE,

Line 4084: PJI_PA_PROJ_EVENTS_LOG log_del,

4080: log_del.ATTRIBUTE18,
4081: log_del.ATTRIBUTE19,
4082: log_del.ATTRIBUTE20
4083: from
4084: PJI_PA_PROJ_EVENTS_LOG log_del,
4085: PJI_PA_PROJ_EVENTS_LOG log_push
4086: where
4087: log_del.WORKER_ID = p_worker_id and
4088: log_del.EVENT_TYPE = 'RBS_DELETE' and

Line 4085: PJI_PA_PROJ_EVENTS_LOG log_push

4081: log_del.ATTRIBUTE19,
4082: log_del.ATTRIBUTE20
4083: from
4084: PJI_PA_PROJ_EVENTS_LOG log_del,
4085: PJI_PA_PROJ_EVENTS_LOG log_push
4086: where
4087: log_del.WORKER_ID = p_worker_id and
4088: log_del.EVENT_TYPE = 'RBS_DELETE' and
4089: log_push.WORKER_ID = p_worker_id and

Line 4094: from PJI_PA_PROJ_EVENTS_LOG log1

4090: log_push.EVENT_TYPE = 'RBS_PUSH' and
4091: log_push.EVENT_OBJECT = log_del.EVENT_OBJECT;
4092:
4093: delete
4094: from PJI_PA_PROJ_EVENTS_LOG log1
4095: where log1.WORKER_ID = p_worker_id and
4096: log1.EVENT_TYPE = 'RBS_PUSH' and
4097: log1.EVENT_OBJECT in (select log2.EVENT_OBJECT
4098: from PJI_PA_PROJ_EVENTS_LOG log2

Line 4098: from PJI_PA_PROJ_EVENTS_LOG log2

4094: from PJI_PA_PROJ_EVENTS_LOG log1
4095: where log1.WORKER_ID = p_worker_id and
4096: log1.EVENT_TYPE = 'RBS_PUSH' and
4097: log1.EVENT_OBJECT in (select log2.EVENT_OBJECT
4098: from PJI_PA_PROJ_EVENTS_LOG log2
4099: where log2.WORKER_ID = p_worker_id and
4100: log2.EVENT_TYPE = 'RBS_DELETE');
4101:
4102: -- add PROJECT_ID to RBS_PUSH events

Line 4104: insert into PJI_PA_PROJ_EVENTS_LOG

4100: log2.EVENT_TYPE = 'RBS_DELETE');
4101:
4102: -- add PROJECT_ID to RBS_PUSH events
4103: /* Midified this insert for bug#6450097 */
4104: insert into PJI_PA_PROJ_EVENTS_LOG
4105: (
4106: WORKER_ID,
4107: LOG_ROWID,
4108: EVENT_TYPE,

Line 4166: PJI_PA_PROJ_EVENTS_LOG log,

4162: log.ATTRIBUTE18,
4163: rbs_prj.PROJECT_ID ATTRIBUTE19,
4164: log.ATTRIBUTE20
4165: from
4166: PJI_PA_PROJ_EVENTS_LOG log,
4167: PA_RBS_PRJ_ASSIGNMENTS rbs_prj,
4168: PA_RBS_VERSIONS_B rbs
4169: where
4170: log.WORKER_ID = p_worker_id and

Line 4175: insert into PJI_PA_PROJ_EVENTS_LOG -- CBS Change

4171: log.EVENT_TYPE = 'RBS_PUSH' and
4172: rbs.RBS_VERSION_ID = log.ATTRIBUTE2 and
4173: rbs.rbs_header_id = rbs_prj.rbs_header_id;
4174:
4175: insert into PJI_PA_PROJ_EVENTS_LOG -- CBS Change
4176: (
4177: WORKER_ID,
4178: LOG_ROWID,
4179: EVENT_TYPE,

Line 4237: PJI_PA_PROJ_EVENTS_LOG log,

4233: log.ATTRIBUTE18,
4234: prj.PROJECT_ID ATTRIBUTE19,
4235: log.ATTRIBUTE20
4236: from
4237: PJI_PA_PROJ_EVENTS_LOG log,
4238: PA_PROJECTS_ALL prj
4239: where
4240: log.WORKER_ID = p_worker_id and
4241: log.EVENT_TYPE = 'RBS_PUSH' and

Line 4246: from PJI_PA_PROJ_EVENTS_LOG

4242: prj.cbs_version_id = log.ATTRIBUTE2 and
4243: prj.cbs_enable_flag = 'Y';
4244:
4245: delete
4246: from PJI_PA_PROJ_EVENTS_LOG
4247: where WORKER_ID = p_worker_id and
4248: EVENT_TYPE = 'RBS_PUSH' and
4249: ATTRIBUTE16 = 'N';
4250:

Line 4281: PJI_PA_PROJ_EVENTS_LOG

4277: ATTRIBUTE20 RBS_HEADER_ID,
4278: ATTRIBUTE2 OLD_RBS_VERSION_ID,
4279: EVENT_OBJECT NEW_RBS_VERSION_ID
4280: from
4281: PJI_PA_PROJ_EVENTS_LOG
4282: where
4283: WORKER_ID = p_worker_id and
4284: EVENT_TYPE = 'RBS_PUSH';
4285:

Line 4788: from PJI_PA_PROJ_EVENTS_LOG

4784: LAST_UPDATED_BY = l_last_updated_by,
4785: LAST_UPDATE_LOGIN = l_last_update_login
4786: where PLAN_VERSION_ID = -1 and
4787: PROJECT_ID in (select EVENT_OBJECT
4788: from PJI_PA_PROJ_EVENTS_LOG
4789: where WORKER_ID = p_worker_id and
4790: EVENT_TYPE in ('WBS_CHANGE',
4791: 'WBS_PUBLISH'));
4792:

Line 4835: PJI_PA_PROJ_EVENTS_LOG log,

4831: select
4832: distinct
4833: prj_emt.PROJECT_ID
4834: from
4835: PJI_PA_PROJ_EVENTS_LOG log,
4836: PA_PROJ_ELEMENTS prj_emt,
4837: PJI_PJP_WBS_HEADER hdr
4838: where
4839: log.WORKER_ID = p_worker_id and

Line 4890: from PJI_PA_PROJ_EVENTS_LOG log,

4886: (select /*+ use_hash(log, rbs_hdr) ordered */ distinct
4887: rbs_hdr.PROJECT_ID,
4888: rbs_hdr.PLAN_VERSION_ID,
4889: rbs_hdr.RBS_VERSION_ID
4890: from PJI_PA_PROJ_EVENTS_LOG log,
4891: PJI_PJP_RBS_HEADER rbs_hdr
4892: where log.WORKER_ID = p_worker_id
4893: and ( (log.EVENT_TYPE = 'RBS_PUSH' and rbs_hdr.RBS_VERSION_ID = log.ATTRIBUTE2)
4894: or (log.EVENT_TYPE = 'RBS_DELETE' and rbs_hdr.RBS_VERSION_ID = log.EVENT_OBJECT)));

Line 4900: from PJI_PA_PROJ_EVENTS_LOG log,

4896: /*(select distinct
4897: rbs_hdr.PROJECT_ID,
4898: rbs_hdr.PLAN_VERSION_ID,
4899: rbs_hdr.RBS_VERSION_ID
4900: from PJI_PA_PROJ_EVENTS_LOG log,
4901: PJI_PJP_RBS_HEADER rbs_hdr
4902: where log.WORKER_ID = p_worker_id and
4903: log.EVENT_TYPE = 'RBS_PUSH' and
4904: rbs_hdr.RBS_VERSION_ID =

Line 4911: from PJI_PA_PROJ_EVENTS_LOG log,

4907: select distinct
4908: rbs_hdr.PROJECT_ID,
4909: rbs_hdr.PLAN_VERSION_ID,
4910: rbs_hdr.RBS_VERSION_ID
4911: from PJI_PA_PROJ_EVENTS_LOG log,
4912: PJI_PJP_RBS_HEADER rbs_hdr
4913: where log.WORKER_ID = p_worker_id and
4914: log.EVENT_TYPE = 'RBS_DELETE' and
4915: rbs_hdr.RBS_VERSION_ID = log.EVENT_OBJECT); */

Line 4956: PJI_PA_PROJ_EVENTS_LOG log

4952: 'WBS_PUBLISH', -1,
4953: 'PLAN_BASELINE', log.ATTRIBUTE2,
4954: 'PLAN_ORIGINAL', log.ATTRIBUTE2)
4955: from
4956: PJI_PA_PROJ_EVENTS_LOG log
4957: where
4958: log.WORKER_ID = p_worker_id and
4959: log.EVENT_TYPE in ('WBS_CHANGE',
4960: 'WBS_PUBLISH',

Line 4970: from PJI_PA_PROJ_EVENTS_LOG log

4966: delete
4967: from PJI_PJP_RBS_HEADER
4968: where RBS_VERSION_ID in (select distinct
4969: log.EVENT_OBJECT
4970: from PJI_PA_PROJ_EVENTS_LOG log
4971: where log.WORKER_ID = p_worker_id and
4972: log.EVENT_TYPE = 'RBS_DELETE');
4973:
4974: delete

Line 4980: from PJI_PA_PROJ_EVENTS_LOG log

4976: where RBS_VERSION_ID in (select distinct
4977: decode(log.EVENT_TYPE,
4978: 'RBS_PUSH', log.ATTRIBUTE2,
4979: 'RBS_DELETE', log.EVENT_OBJECT)
4980: from PJI_PA_PROJ_EVENTS_LOG log
4981: where log.WORKER_ID = p_worker_id and
4982: log.EVENT_TYPE in ('RBS_PUSH',
4983: 'RBS_DELETE'));
4984:

Line 5080: PJI_PA_PROJ_EVENTS_LOG log

5076: 'Y' REPORTING_USAGE_FLAG,
5077: 'N' FP_USAGE_FLAG,
5078: log.ATTRIBUTE19 UPDATE_HEADER_ONLY_FLAG
5079: from
5080: PJI_PA_PROJ_EVENTS_LOG log
5081: where
5082: log.WORKER_ID = p_worker_id and
5083: log.EVENT_TYPE = 'RBS_ASSOC' and
5084: log.ATTRIBUTE20 = 'CONVERTED_RBS_PRG_EVENT'

Line 5100: PJI_PA_PROJ_EVENTS_LOG log

5096: 'N' PROG_REP_USAGE_FLAG,
5097: 'Y' REPORTING_USAGE_FLAG,
5098: 'N' FP_USAGE_FLAG
5099: from
5100: PJI_PA_PROJ_EVENTS_LOG log
5101: where
5102: log.WORKER_ID = p_worker_id and
5103: log.EVENT_TYPE = 'RBS_ASSOC' and
5104: log.ATTRIBUTE20 is null

Line 5120: PJI_PA_PROJ_EVENTS_LOG log

5116: 'N' PROG_REP_USAGE_FLAG,
5117: 'Y' REPORTING_USAGE_FLAG,
5118: 'N' FP_USAGE_FLAG
5119: from
5120: PJI_PA_PROJ_EVENTS_LOG log
5121: where
5122: log.WORKER_ID = p_worker_id and
5123: log.EVENT_TYPE = 'RBS_PUSH'
5124: order by

Line 5416: insert into PJI_PA_PROJ_EVENTS_LOG

5412: l_last_update_login,
5413: 'A'
5414: );
5415:
5416: insert into PJI_PA_PROJ_EVENTS_LOG
5417: (
5418: WORKER_ID,
5419: EVENT_TYPE,
5420: EVENT_ID,

Line 5453: from PJI_PA_PROJ_EVENTS_LOG

5449:
5450: end if;
5451:
5452: delete
5453: from PJI_PA_PROJ_EVENTS_LOG
5454: where WORKER_ID = p_worker_id and
5455: EVENT_TYPE = 'RBS_ASSOC' and
5456: ATTRIBUTE19 = 'MARK_AS_PROG_REP';
5457:

Line 5533: insert into PJI_PA_PROJ_EVENTS_LOG

5529: l_last_update_login,
5530: 'A'
5531: );
5532:
5533: insert into PJI_PA_PROJ_EVENTS_LOG
5534: (
5535: WORKER_ID,
5536: EVENT_TYPE,
5537: EVENT_ID,

Line 5610: insert into PJI_PA_PROJ_EVENTS_LOG

5606: where PROJECT_ID = c.PROJECT_ID and
5607: RBS_VERSION_ID = c.OLD_RBS_VERSION_ID and
5608: PLAN_VERSION_ID = -1;
5609:
5610: insert into PJI_PA_PROJ_EVENTS_LOG
5611: (
5612: WORKER_ID,
5613: EVENT_TYPE,
5614: EVENT_ID,

Line 5802: PJI_PA_PROJ_EVENTS_LOG log

5798: 'X' RELATIONSHIP_TYPE,
5799: +1 SIGN
5800: from
5801: PA_XBS_DENORM wbs,
5802: PJI_PA_PROJ_EVENTS_LOG log
5803: where
5804: log.WORKER_ID = p_worker_id and
5805: log.EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH') and
5806: wbs.STRUCT_TYPE = 'WBS' and

Line 5832: PJI_PA_PROJ_EVENTS_LOG log

5828: 'X' RELATIONSHIP_TYPE,
5829: -1 SIGN
5830: from
5831: PJI_XBS_DENORM wbs,
5832: PJI_PA_PROJ_EVENTS_LOG log
5833: where
5834: log.WORKER_ID = p_worker_id and
5835: log.EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH') and
5836: wbs.STRUCT_TYPE = 'WBS' and

Line 5862: PJI_PA_PROJ_EVENTS_LOG log

5858: prg.RELATIONSHIP_TYPE,
5859: +1 SIGN
5860: from
5861: PA_XBS_DENORM prg,
5862: PJI_PA_PROJ_EVENTS_LOG log
5863: where
5864: log.WORKER_ID = p_worker_id and
5865: log.EVENT_TYPE = 'PRG_CHANGE' and
5866: log.EVENT_OBJECT <> -1 and

Line 5892: PJI_PA_PROJ_EVENTS_LOG log

5888: prg.RELATIONSHIP_TYPE,
5889: +1 SIGN
5890: from
5891: PA_XBS_DENORM prg,
5892: PJI_PA_PROJ_EVENTS_LOG log
5893: where
5894: log.WORKER_ID = p_worker_id and
5895: log.EVENT_TYPE = 'PRG_CHANGE' and
5896: log.EVENT_OBJECT <> -1 and

Line 5922: PJI_PA_PROJ_EVENTS_LOG log

5918: prg.RELATIONSHIP_TYPE,
5919: -1 SIGN
5920: from
5921: PJI_XBS_DENORM prg,
5922: PJI_PA_PROJ_EVENTS_LOG log
5923: where
5924: log.WORKER_ID = p_worker_id and
5925: log.EVENT_TYPE = 'PRG_CHANGE' and
5926: log.EVENT_OBJECT <> -1 and

Line 5952: PJI_PA_PROJ_EVENTS_LOG log

5948: prg.RELATIONSHIP_TYPE,
5949: -1 SIGN
5950: from
5951: PJI_XBS_DENORM prg,
5952: PJI_PA_PROJ_EVENTS_LOG log
5953: where
5954: log.WORKER_ID = p_worker_id and
5955: log.EVENT_TYPE = 'PRG_CHANGE' and
5956: log.EVENT_OBJECT <> -1 and

Line 5979: insert into PJI_PA_PROJ_EVENTS_LOG

5975: sum(SIGN) <> 0;
5976:
5977: -- push down program RBSs across new links
5978:
5979: insert into PJI_PA_PROJ_EVENTS_LOG
5980: (
5981: WORKER_ID,
5982: LOG_ROWID,
5983: EVENT_TYPE,

Line 6088: PJI_PA_PROJ_EVENTS_LOG log

6084: sub_ver.ELEMENT_VERSION_ID = prg.SUB_ID and
6085: hdr.RBS_VERSION_ID = sup_rbs_hdr.RBS_VERSION_ID
6086: ) evt,
6087: PJI_PJP_RBS_HEADER sub_rbs_hdr,
6088: PJI_PA_PROJ_EVENTS_LOG log
6089: where
6090: evt.ATTRIBUTE1 = sub_rbs_hdr.PROJECT_ID (+) and
6091: -1 = sub_rbs_hdr.PLAN_VERSION_ID (+) and
6092: evt.EVENT_OBJECT = sub_rbs_hdr.RBS_VERSION_ID (+) and

Line 6117: PJI_PA_PROJ_EVENTS_LOG log

6113: 'Y' REPORTING_USAGE_FLAG,
6114: 'N' FP_USAGE_FLAG,
6115: log.ATTRIBUTE19 UPDATE_HEADER_ONLY_FLAG
6116: from
6117: PJI_PA_PROJ_EVENTS_LOG log
6118: where
6119: log.WORKER_ID = p_worker_id and
6120: log.EVENT_TYPE = 'RBS_ASSOC' and
6121: log.ATTRIBUTE20 = 'NEW_CONVERTED_RBS_PRG_EVENT'

Line 6185: insert into PJI_PA_PROJ_EVENTS_LOG

6181: l_last_update_login,
6182: 'A'
6183: );
6184:
6185: insert into PJI_PA_PROJ_EVENTS_LOG
6186: (
6187: WORKER_ID,
6188: EVENT_TYPE,
6189: EVENT_ID,

Line 6409: PJI_PA_PROJ_EVENTS_LOG log

6405: 'X' SUB_LEAF_FLAG,
6406: +1 SIGN
6407: from
6408: PA_RBS_DENORM rbs,
6409: PJI_PA_PROJ_EVENTS_LOG log
6410: where
6411: log.WORKER_ID = p_worker_id and
6412: log.EVENT_TYPE = 'RBS_PUSH' and
6413: rbs.STRUCT_VERSION_ID = log.EVENT_OBJECT

Line 6429: PJI_PA_PROJ_EVENTS_LOG log

6425: 'X' SUB_LEAF_FLAG,
6426: -1 SIGN
6427: from
6428: PJI_RBS_DENORM rbs,
6429: PJI_PA_PROJ_EVENTS_LOG log
6430: where
6431: log.WORKER_ID = p_worker_id and
6432: log.EVENT_TYPE = 'RBS_PUSH' and
6433: rbs.STRUCT_VERSION_ID = log.ATTRIBUTE2

Line 7255: PJI_PA_PROJ_EVENTS_LOG log

7251: distinct
7252: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
7253: to_number(log.ATTRIBUTE1) PROJECT_ID
7254: from
7255: PJI_PA_PROJ_EVENTS_LOG log
7256: where
7257: log.WORKER_ID = p_worker_id and
7258: log.EVENT_TYPE = 'RBS_ASSOC'
7259: ) log

Line 7339: PJI_PA_PROJ_EVENTS_LOG log

7335: distinct
7336: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
7337: to_numbeR(log.ATTRIBUTE1) PROJECT_ID
7338: from
7339: PJI_PA_PROJ_EVENTS_LOG log
7340: where
7341: log.WORKER_ID = p_worker_id and
7342: log.EVENT_TYPE = 'RBS_ASSOC'
7343: ) log

Line 7418: PJI_PA_PROJ_EVENTS_LOG log,

7414: to_number(null) G2_OTH_COMMITTED_COST,
7415: bal.QUANTITY,
7416: bal.BILL_QUANTITY
7417: from
7418: PJI_PA_PROJ_EVENTS_LOG log,
7419: PJI_PJP_PROJ_EXTR_STATUS stat,
7420: PJI_FP_TXN_ACCUM bal
7421: where
7422: l_extraction_type = 'RBS' and

Line 7498: PJI_PA_PROJ_EVENTS_LOG log,

7494: bal.G2_OTH_COMMITTED_COST,
7495: to_number(null) QUANTITY,
7496: to_number(null) BILL_QUANTITY
7497: from
7498: PJI_PA_PROJ_EVENTS_LOG log,
7499: PJI_PJP_PROJ_EXTR_STATUS stat,
7500: PJI_FP_TXN_ACCUM1 bal
7501: where
7502: l_extraction_type = 'RBS' and

Line 10769: PJI_PA_PROJ_EVENTS_LOG log

10765: distinct
10766: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
10767: to_number(log.ATTRIBUTE1) PROJECT_ID
10768: from
10769: PJI_PA_PROJ_EVENTS_LOG log
10770: where
10771: log.WORKER_ID = p_worker_id and
10772: log.EVENT_TYPE = 'RBS_ASSOC'
10773: ) log

Line 10883: PJI_PA_PROJ_EVENTS_LOG log

10879: distinct
10880: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
10881: to_number(log.ATTRIBUTE1) PROJECT_ID
10882: from
10883: PJI_PA_PROJ_EVENTS_LOG log
10884: where
10885: log.WORKER_ID = p_worker_id and
10886: log.EVENT_TYPE = 'RBS_ASSOC'
10887: ) log

Line 14724: PJI_PA_PROJ_EVENTS_LOG log,

14720: wbs.SIGN * acr.CUSTOM13 CUSTOM13,
14721: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
14722: wbs.SIGN * acr.CUSTOM15 CUSTOM15
14723: from
14724: PJI_PA_PROJ_EVENTS_LOG log,
14725: PJI_PJP_WBS_HEADER wbs_hdr,
14726: PJI_XBS_DENORM_DELTA wbs,
14727: PJI_XBS_DENORM prg,
14728: PJI_AC_XBS_ACCUM_F acr,

Line 18549: PJI_PA_PROJ_EVENTS_LOG log,

18545: decode(invert.INVERT_ID,
18546: 1, log.EVENT_OBJECT,
18547: 2, log.ATTRIBUTE1) PRG_GROUP
18548: from
18549: PJI_PA_PROJ_EVENTS_LOG log,
18550: (
18551: select 1 INVERT_ID from DUAL union all
18552: select 2 INVERT_ID from DUAL
18553: ) invert

Line 18560: from PJI_PA_PROJ_EVENTS_LOG log,Pji_pjp_wbs_header ver

18556: log.EVENT_TYPE = 'PRG_CHANGE' and
18557: log.EVENT_OBJECT <> -1)
18558: union all
18559: select ver.wbs_version_id
18560: from PJI_PA_PROJ_EVENTS_LOG log,Pji_pjp_wbs_header ver
18561: where ver.project_id=to_number(log.ATTRIBUTE1) and
18562: log.WORKER_ID = p_worker_id and
18563: log.EVENT_TYPE = 'PRG_CHANGE' and
18564: log.EVENT_OBJECT = -1

Line 18569: from PJI_PA_PROJ_EVENTS_LOG log,

18565: union all
18566: select to_number(decode(invert.INVERT_ID,
18567: 1, log.EVENT_OBJECT,
18568: 2, log.ATTRIBUTE2)) struct_version_id
18569: from PJI_PA_PROJ_EVENTS_LOG log,
18570: (
18571: select 1 INVERT_ID from DUAL union all
18572: select 2 INVERT_ID from DUAL
18573: ) invert

Line 18597: PJI_PA_PROJ_EVENTS_LOG log,

18593: decode(invert.INVERT_ID,
18594: 1, log.EVENT_OBJECT,
18595: 2, log.ATTRIBUTE1) PRG_GROUP
18596: from
18597: PJI_PA_PROJ_EVENTS_LOG log,
18598: (
18599: select 1 INVERT_ID from DUAL union all
18600: select 2 INVERT_ID from DUAL
18601: ) invert

Line 18611: from PJI_PA_PROJ_EVENTS_LOG log

18607: l_count := l_count + sql%rowcount;
18608:
18609: delete from PJI_XBS_DENORM
18610: where SUP_PROJECT_ID in (select log.ATTRIBUTE1
18611: from PJI_PA_PROJ_EVENTS_LOG log
18612: where log.WORKER_ID = p_worker_id and
18613: log.EVENT_TYPE = 'PRG_CHANGE' and
18614: log.EVENT_OBJECT = -1);
18615:

Line 18625: PJI_PA_PROJ_EVENTS_LOG log,

18621: decode(invert.INVERT_ID,
18622: 1, log.EVENT_OBJECT,
18623: 2, log.ATTRIBUTE2)
18624: from
18625: PJI_PA_PROJ_EVENTS_LOG log,
18626: (
18627: select 1 INVERT_ID from DUAL union all
18628: select 2 INVERT_ID from DUAL
18629: ) invert

Line 18695: PJI_PA_PROJ_EVENTS_LOG log,

18691: decode(invert.INVERT_ID,
18692: 1, log.EVENT_OBJECT,
18693: 2, log.ATTRIBUTE1) PRG_GROUP
18694: from
18695: PJI_PA_PROJ_EVENTS_LOG log,
18696: (
18697: select 1 INVERT_ID from DUAL union all
18698: select 2 INVERT_ID from DUAL
18699: ) invert

Line 18706: from PJI_PA_PROJ_EVENTS_LOG log

18702: log.EVENT_TYPE = 'PRG_CHANGE' and
18703: log.EVENT_OBJECT <> -1)
18704: union
18705: select to_number(log.ATTRIBUTE1) PROJECT_ID
18706: from PJI_PA_PROJ_EVENTS_LOG log
18707: where log.WORKER_ID = p_worker_id and
18708: log.EVENT_TYPE = 'PRG_CHANGE' and
18709: log.EVENT_OBJECT = -1)
18710: union all

Line 18739: PJI_PA_PROJ_EVENTS_LOG

18735: distinct
18736: EVENT_OBJECT,
18737: ATTRIBUTE2
18738: from
18739: PJI_PA_PROJ_EVENTS_LOG
18740: where
18741: WORKER_ID = p_worker_id and
18742: EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH')
18743: ) log

Line 19109: from PJI_PA_PROJ_EVENTS_LOG log

19105: /* Added for Bug 9099240 End */
19106:
19107: delete from PJI_RBS_DENORM
19108: where STRUCT_VERSION_ID in (select log.EVENT_OBJECT
19109: from PJI_PA_PROJ_EVENTS_LOG log
19110: where log.WORKER_ID = p_worker_id and
19111: log.EVENT_TYPE = 'PJI_RBS_CHANGE');
19112:
19113: insert into PJI_RBS_DENORM

Line 19148: PJI_PA_PROJ_EVENTS_LOG log

19144: select
19145: distinct
19146: log.EVENT_OBJECT
19147: from
19148: PJI_PA_PROJ_EVENTS_LOG log
19149: where
19150: log.WORKER_ID = p_worker_id and
19151: log.EVENT_TYPE in ('PJI_RBS_CHANGE')
19152: ) log

Line 19169: PJI_PA_PROJ_EVENTS_LOG log,

19165: 1, log.EVENT_OBJECT,
19166: 2, log.ATTRIBUTE2),
19167: 'RBS_DELETE', log.EVENT_OBJECT)
19168: from
19169: PJI_PA_PROJ_EVENTS_LOG log,
19170: (
19171: select 1 INVERT_ID from DUAL union all
19172: select 2 INVERT_ID from DUAL
19173: ) invert

Line 19215: PJI_PA_PROJ_EVENTS_LOG

19211: distinct
19212: EVENT_OBJECT,
19213: ATTRIBUTE2
19214: from
19215: PJI_PA_PROJ_EVENTS_LOG
19216: where
19217: WORKER_ID = p_worker_id and
19218: EVENT_TYPE = 'RBS_PUSH'
19219: ) log

Line 20405: 'PJI_PA_PROJ_EVENTS_LOG',

20401: l_tab15 := 'Y';
20402: end if;
20403: if l_tab16 = 'N' then
20404: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
20405: 'PJI_PA_PROJ_EVENTS_LOG',
20406: 'PARTITION',
20407: 'P' || p_worker_id);
20408: l_tab16 := 'Y';
20409: end if;

Line 20454: -- execute immediate 'alter index '||l_schema||'.'||'PJI_PA_PROJ_EVENTS_LOG_N1 rebuild'; /* Added for bug 9840828 */

20450: /* Added for bug 9736812 */
20451:
20452: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);'); -- Bug#5171542
20453: -- commented below bcoz the global index is modified to local for bug15983044
20454: -- execute immediate 'alter index '||l_schema||'.'||'PJI_PA_PROJ_EVENTS_LOG_N1 rebuild'; /* Added for bug 9840828 */
20455: commit;
20456:
20457: else -- online mode
20458: