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_DENORM dependencies on PJI_FP_AGGR_XBS_T

Line 228: -- don't delete contents from PJI_FP_AGGR_XBS_T

224: p_worker_id,
225: 'ONLINE'
226: );
227:
228: -- don't delete contents from PJI_FP_AGGR_XBS_T
229:
230: -- Sadiq will call cleanup_xbs_denorm(p_worker_id, 'ONLINE')
231:
232:

Line 3304: from PJI_FP_AGGR_XBS_T pdt_count

3300: -- then we know that the node is a leaf
3301:
3302: select count(*)
3303: into l_prg_node_count
3304: from PJI_FP_AGGR_XBS_T pdt_count
3305: where 1=1
3306: and pdt_count.sup_id = PRG_NODE.element_version_id
3307: and pdt_count.worker_id = P_WORKER_ID
3308: and rownum = 1;

Line 3344: into PJI_FP_AGGR_XBS_T

3340:
3341:
3342: -- Insert PRG node self --
3343: insert
3344: into PJI_FP_AGGR_XBS_T
3345: (
3346: struct_type,
3347: prg_group,
3348: struct_version_id,

Line 3500: into PJI_FP_AGGR_XBS_T

3496:
3497:
3498: -- Insert PRG node's parent --
3499: insert
3500: into PJI_FP_AGGR_XBS_T
3501: (
3502: struct_type,
3503: prg_group,
3504: struct_version_id,

Line 3552: from PJI_FP_AGGR_XBS_T pdt_child

3548: distinct
3549: pdt_child.sup_id,
3550: pdt_child.sub_id,
3551: pdt_child.sub_leaf_flag_id
3552: from PJI_FP_AGGR_XBS_T pdt_child
3553: where 1=1
3554: and pdt_child.sup_id = PRG_NODE.element_version_id
3555: and pdt_child.sup_id <> pdt_child.sub_id
3556: and pdt_child.worker_id = P_WORKER_ID

Line 3562: from PJI_FP_AGGR_XBS_T pdt_child1

3558:
3559: -- l_prg_temp_level --
3560: select pdt_child1.sub_level
3561: into l_prg_temp_level
3562: from PJI_FP_AGGR_XBS_T pdt_child1
3563: where 1=1
3564: --and pdt_child1.struct_type = 'PRG'
3565: and pdt_child1.sup_id = PRG_CHILDREN_NODE.sub_id
3566: and pdt_child1.sub_id = PRG_CHILDREN_NODE.sub_id

Line 3623: into PJI_FP_AGGR_XBS_T

3619: end if;
3620:
3621: -- Insert PRG node's child --
3622: insert
3623: into PJI_FP_AGGR_XBS_T
3624: (
3625: struct_type,
3626: prg_group,
3627: struct_version_id,

Line 3728: -- PJI_FP_AGGR_XBS_T

3724: -- PA_OBJECT_RELATIONSHIPS
3725: --
3726: -- Then, this API populates output values in the following existing
3727: -- table:
3728: -- PJI_FP_AGGR_XBS_T
3729: --
3730: -- -----------------------------------------------------------------------
3731:
3732: -- -----------------------------------------------------

Line 3855: from pji_fp_aggr_xbs_t

3851: select
3852: distinct
3853: sup_emt_id
3854: into l_struct_emt_id
3855: from pji_fp_aggr_xbs_t
3856: where 1=1
3857: and struct_type = 'PRG'
3858: and sup_id = P_WBS_VERSION_ID
3859: and worker_id = P_WORKER_ID;

Line 3935: from PJI_FP_AGGR_XBS_T wdt_count

3931: -- then we know that the node is a leaf
3932:
3933: select count(*)
3934: into l_wbs_node_count
3935: from PJI_FP_AGGR_XBS_T wdt_count
3936: where wdt_count.sup_id = WBS_NODE.element_version_id
3937: and wdt_count.worker_id = P_WORKER_ID
3938: and rownum = 1;
3939:

Line 3974: into PJI_FP_AGGR_XBS_T

3970:
3971:
3972: -- Insert WBS node self --
3973: insert
3974: into PJI_FP_AGGR_XBS_T
3975: (
3976: struct_type,
3977: prg_group,
3978: struct_emt_id,

Line 4109: into PJI_FP_AGGR_XBS_T

4105: end if;
4106:
4107: -- Insert WBS node's parent --
4108: insert
4109: into PJI_FP_AGGR_XBS_T
4110: (
4111: struct_type,
4112: prg_group,
4113: struct_emt_id,

Line 4164: SELECT /+ index(wdt_child PJI_FP_AGGR_XBS_T_N1) / --9796902

4160: -- Filter nodes to see if the node has children
4161:
4162: FOR WBS_CHILDREN_NODE IN
4163: (
4164: SELECT /*+ index(wdt_child PJI_FP_AGGR_XBS_T_N1) */ --9796902
4165: wdt_child.sup_id,
4166: wdt_child.sub_id,
4167: wdt_child.sub_leaf_flag_id,
4168: wdt_child.relationship_type

Line 4169: from PJI_FP_AGGR_XBS_T wdt_child

4165: wdt_child.sup_id,
4166: wdt_child.sub_id,
4167: wdt_child.sub_leaf_flag_id,
4168: wdt_child.relationship_type
4169: from PJI_FP_AGGR_XBS_T wdt_child
4170: where 1=1
4171: and wdt_child.sup_id = WBS_NODE.element_version_id
4172: and wdt_child.sup_id <> wdt_child.sub_id
4173: and wdt_child.worker_id = P_WORKER_ID

Line 4179: from PJI_FP_AGGR_XBS_T wdt_child1

4175:
4176: -- l_wbs_temp_level --
4177: select wdt_child1.sub_level
4178: into l_wbs_temp_level
4179: from PJI_FP_AGGR_XBS_T wdt_child1
4180: where 1=1
4181: and wdt_child1.sup_id = WBS_CHILDREN_NODE.sub_id
4182: and wdt_child1.sup_id = wdt_child1.sub_id
4183: and wdt_child1.worker_id = P_WORKER_ID;

Line 4225: into PJI_FP_AGGR_XBS_T

4221:
4222:
4223: -- Insert WBS node's child --
4224: insert
4225: into PJI_FP_AGGR_XBS_T
4226: (
4227: struct_type,
4228: prg_group,
4229: struct_emt_id,

Line 4336: into PJI_FP_AGGR_XBS_T

4332: end if;
4333:
4334: -- Insert XBS node --
4335: insert
4336: into PJI_FP_AGGR_XBS_T
4337: (
4338: struct_type,
4339: prg_group,
4340: struct_version_id,

Line 5770: select /+ index(interim PJI_FP_AGGR_XBS_T_N1) / -- Performance fix for bug 13109678

5766: CREATION_DATE,
5767: CREATED_BY,
5768: LAST_UPDATE_LOGIN
5769: )
5770: select /*+ index(interim PJI_FP_AGGR_XBS_T_N1) */ -- Performance fix for bug 13109678
5771: distinct
5772: interim.struct_type,
5773: interim.prg_group,
5774: interim.struct_emt_id,

Line 5792: from PJI_FP_AGGR_XBS_T interim

5788: l_last_updated_by,
5789: l_creation_date,
5790: l_created_by,
5791: l_last_update_login
5792: from PJI_FP_AGGR_XBS_T interim
5793: where interim.worker_id = p_worker_id
5794: order by
5795: interim.struct_version_id,
5796: interim.sup_id,

Line 6113: from PJI_FP_AGGR_XBS_T

6109: if p_extraction_type = 'ONLINE'
6110:
6111: then
6112: delete
6113: from PJI_FP_AGGR_XBS_T
6114: where worker_id = p_worker_id;
6115:
6116: else -- FULL, INCREMENTAL, PARTIAL, UPGRADE
6117: