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_RBS

Line 1463: -- don't delete contents from PJI_FP_AGGR_RBS_T

1459: p_worker_id,
1460: 'ONLINE'
1461: );
1462:
1463: -- don't delete contents from PJI_FP_AGGR_RBS_T
1464:
1465: -- Sadiq will call cleanup_xbs_denorm(p_worker_id, 'ONLINE')
1466:
1467:

Line 4452: -- PJI_FP_AGGR_RBS

4448: -- PA_RBS_ELEMENTS
4449: --
4450: -- Then, this API populates output values in the following existing
4451: -- table:
4452: -- PJI_FP_AGGR_RBS
4453: --
4454: -- -----------------------------------------------------------------------
4455:
4456: -- -----------------------------------------------------

Line 4728: from PJI_FP_AGGR_RBS pdt_count

4724: -- then we know that the node is a leaf
4725:
4726: select count(*)
4727: into l_rbs_node_count
4728: from PJI_FP_AGGR_RBS pdt_count
4729: where 1=1
4730: and pdt_count.sup_id = RBS_NODE.rbs_element_id
4731: and pdt_count.worker_id = P_WORKER_ID
4732: and rownum = 1;

Line 4788: into PJI_FP_AGGR_RBS

4784:
4785: -- Insert RBS node self --
4786: if l_rbs_exists1 = 0 then /* Added for Bug 9099240 */
4787: insert
4788: into PJI_FP_AGGR_RBS
4789: (
4790: struct_version_id,
4791: sup_id,
4792: subro_id,

Line 4889: into PJI_FP_AGGR_RBS

4885:
4886: -- Insert RBS node's parent --
4887: if l_rbs_exists2 = 0 then /* Added for Bug 9099240 */
4888: insert
4889: into PJI_FP_AGGR_RBS
4890: (
4891: struct_version_id,
4892: sup_id,
4893: subro_id,

Line 4928: from PJI_FP_AGGR_RBS pdt_child

4924: distinct
4925: pdt_child.sup_id,
4926: pdt_child.sub_id,
4927: pdt_child.sub_leaf_flag_id
4928: from PJI_FP_AGGR_RBS pdt_child
4929: where 1=1
4930: and pdt_child.sup_id = RBS_NODE.rbs_element_id
4931: and pdt_child.sup_id <> pdt_child.sub_id
4932: and pdt_child.worker_id = P_WORKER_ID

Line 4938: from PJI_FP_AGGR_RBS pdt_child1

4934:
4935: -- l_rbs_temp_level --
4936: select pdt_child1.sub_level
4937: into l_rbs_temp_level
4938: from PJI_FP_AGGR_RBS pdt_child1
4939: where 1=1
4940: and pdt_child1.sup_id = RBS_CHILDREN_NODE.sub_id
4941: and pdt_child1.sup_id = pdt_child1.sub_id
4942: and pdt_child1.worker_id = P_WORKER_ID;

Line 4990: into PJI_FP_AGGR_RBS

4986:
4987: -- Insert RBS node's child --
4988: if l_rbs_exists3 = 0 then /* Added for Bug 9099240 */
4989: insert
4990: into PJI_FP_AGGR_RBS
4991: (
4992: struct_version_id,
4993: sup_id,
4994: subro_id,

Line 5093: -- PJI_FP_AGGR_RBS_T

5089: -- PA_RBS_ELEMENTS
5090: --
5091: -- Then, this API populates output values in the following existing
5092: -- table:
5093: -- PJI_FP_AGGR_RBS_T
5094: --
5095: -- -----------------------------------------------------------------------
5096:
5097: -- -----------------------------------------------------

Line 5256: from PJI_FP_AGGR_RBS_T pdt_count

5252: -- then we know that the node is a leaf
5253:
5254: select count(*)
5255: into l_rbs_node_count
5256: from PJI_FP_AGGR_RBS_T pdt_count
5257: where 1=1
5258: and pdt_count.sup_id = RBS_NODE.rbs_element_id
5259: and pdt_count.worker_id = P_WORKER_ID
5260: and rownum = 1;

Line 5310: into PJI_FP_AGGR_RBS_T

5306:
5307: -- Insert RBS node self --
5308: if l_rbs_exists1 = 0 then /* Added for Bug 9099240 */
5309: insert
5310: into PJI_FP_AGGR_RBS_T
5311: (
5312: struct_version_id,
5313: sup_id,
5314: subro_id,

Line 5405: into PJI_FP_AGGR_RBS_T

5401:
5402: -- Insert RBS node's parent --
5403: if l_rbs_exists2 = 0 then /* Added for Bug 9099240 */
5404: insert
5405: into PJI_FP_AGGR_RBS_T
5406: (
5407: struct_version_id,
5408: sup_id,
5409: subro_id,

Line 5470: from PJI_FP_AGGR_RBS_T pdt_child

5466: distinct
5467: pdt_child.sup_id,
5468: pdt_child.sub_id,
5469: pdt_child.sub_leaf_flag_id
5470: from PJI_FP_AGGR_RBS_T pdt_child
5471: where 1=1
5472: and pdt_child.sup_id = RBS_NODE.rbs_element_id
5473: and pdt_child.sup_id <> pdt_child.sub_id
5474: and pdt_child.worker_id = P_WORKER_ID

Line 5480: from PJI_FP_AGGR_RBS_T pdt_child1

5476:
5477: -- l_rbs_temp_level --
5478: select pdt_child1.sub_level
5479: into l_rbs_temp_level
5480: from PJI_FP_AGGR_RBS_T pdt_child1
5481: where 1=1
5482: and pdt_child1.sup_id = RBS_CHILDREN_NODE.sub_id
5483: and pdt_child1.sup_id = pdt_child1.sub_id
5484: and pdt_child1.worker_id = P_WORKER_ID;

Line 5527: into PJI_FP_AGGR_RBS_T

5523:
5524: -- Insert RBS node's child --
5525: if l_rbs_exists3 = 0 then /* Added for Bug 9099240 */
5526: insert
5527: into PJI_FP_AGGR_RBS_T
5528: (
5529: struct_version_id,
5530: sup_id,
5531: subro_id,

Line 5895: -- (PJI_FP_AGGR_RBS) to the actual denorm table (PA_RBS_DENORM)

5891: -- 19-MAR-2004 aartola Created
5892: --
5893: --
5894: -- *** This procedure merges data from the denorm interim table
5895: -- (PJI_FP_AGGR_RBS) to the actual denorm table (PA_RBS_DENORM)
5896: --
5897: -- After calling this procedure, the contents of the interim table
5898: -- need to be deleted.
5899: --

Line 5972: from PJI_FP_AGGR_RBS interim,

5968: l_last_updated_by,
5969: l_creation_date,
5970: l_created_by,
5971: l_last_update_login
5972: from PJI_FP_AGGR_RBS interim,
5973: PA_RBS_DENORM denorm
5974: where 1=1
5975: and interim.worker_id = p_worker_id
5976: and nvl(interim.struct_version_id, -1) = nvl(denorm.struct_version_id (+), -1)

Line 6020: from PJI_FP_AGGR_RBS_T interim

6016: l_last_updated_by,
6017: l_creation_date,
6018: l_created_by,
6019: l_last_update_login
6020: from PJI_FP_AGGR_RBS_T interim
6021: where interim.worker_id = p_worker_id;
6022:
6023: -- -------------------------
6024:

Line 6056: from PJI_FP_AGGR_RBS interim

6052: l_last_updated_by,
6053: l_creation_date,
6054: l_created_by,
6055: l_last_update_login
6056: from PJI_FP_AGGR_RBS interim
6057: where interim.worker_id = p_worker_id;
6058:
6059: -- -------------------------
6060:

Line 6175: from PJI_FP_AGGR_RBS_T

6171: if p_extraction_type = 'ONLINE'
6172:
6173: then
6174: delete
6175: from PJI_FP_AGGR_RBS_T
6176: where worker_id = p_worker_id;
6177:
6178: else -- FULL, INCREMENTAL, PARTIAL, UPGRADE
6179:

Line 6181: from PJI_FP_AGGR_RBS

6177:
6178: else -- FULL, INCREMENTAL, PARTIAL, UPGRADE
6179:
6180: delete
6181: from PJI_FP_AGGR_RBS
6182: where worker_id = p_worker_id;
6183: end if;
6184:
6185: -- -----------------------------------------------------

Line 6306: from PJI_FP_AGGR_RBS pdt_count

6302:
6303:
6304: select count(*)
6305: into l_rbs_node_count
6306: from PJI_FP_AGGR_RBS pdt_count
6307: where 1=1
6308: and pdt_count.sup_id = RBS_NODE.rbs_element_id
6309: and pdt_count.worker_id = P_WORKER_ID
6310: and rownum = 1;

Line 6345: into PJI_FP_AGGR_RBS

6341: end if;
6342:
6343: -- Insert RBS node self --
6344: insert
6345: into PJI_FP_AGGR_RBS
6346: (
6347: struct_version_id,
6348: sup_id,
6349: subro_id,

Line 6424: into PJI_FP_AGGR_RBS

6420: end if;
6421:
6422: -- Insert RBS node's parent --
6423: insert
6424: into PJI_FP_AGGR_RBS
6425: (
6426: struct_version_id,
6427: sup_id,
6428: subro_id,

Line 6462: from PJI_FP_AGGR_RBS pdt_child

6458: distinct
6459: pdt_child.sup_id,
6460: pdt_child.sub_id,
6461: pdt_child.sub_leaf_flag_id
6462: from PJI_FP_AGGR_RBS pdt_child
6463: where 1=1
6464: and pdt_child.sup_id = RBS_NODE.rbs_element_id
6465: and pdt_child.sup_id <> pdt_child.sub_id
6466: and pdt_child.worker_id = P_WORKER_ID

Line 6472: from PJI_FP_AGGR_RBS pdt_child1

6468:
6469: -- l_rbs_temp_level --
6470: select pdt_child1.sub_level
6471: into l_rbs_temp_level
6472: from PJI_FP_AGGR_RBS pdt_child1
6473: where 1=1
6474: and pdt_child1.sup_id = RBS_CHILDREN_NODE.sub_id
6475: and pdt_child1.sup_id = pdt_child1.sub_id
6476: and pdt_child1.worker_id = P_WORKER_ID;

Line 6503: into PJI_FP_AGGR_RBS

6499: end if;
6500:
6501: -- Insert RBS node's child --
6502: insert
6503: into PJI_FP_AGGR_RBS
6504: (
6505: struct_version_id,
6506: sup_id,
6507: subro_id,