APPS.PJI_PJP_SUM_DENORM dependencies on PJI_FP_AGGR_RBS_T

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

1451: p_worker_id,
1452: 'ONLINE'
1453: );
1454:
1455: -- don't delete contents from PJI_FP_AGGR_RBS_T
1456:
1457: -- Sadiq will call cleanup_xbs_denorm(p_worker_id, 'ONLINE')
1458:
1459:

Line 4908: -- PJI_FP_AGGR_RBS_T

4904: -- PA_RBS_ELEMENTS
4905: --
4906: -- Then, this API populates output values in the following existing
4907: -- table:
4908: -- PJI_FP_AGGR_RBS_T
4909: --
4910: -- -----------------------------------------------------------------------
4911:
4912: -- -----------------------------------------------------

Line 5027: from PJI_FP_AGGR_RBS_T pdt_count

5023: -- then we know that the node is a leaf
5024:
5025: select count(*)
5026: into l_rbs_node_count
5027: from PJI_FP_AGGR_RBS_T pdt_count
5028: where 1=1
5029: and pdt_count.sup_id = RBS_NODE.rbs_element_id
5030: and pdt_count.worker_id = P_WORKER_ID
5031: and rownum = 1;

Line 5066: into PJI_FP_AGGR_RBS_T

5062: end if;
5063:
5064: -- Insert RBS node self --
5065: insert
5066: into PJI_FP_AGGR_RBS_T
5067: (
5068: struct_version_id,
5069: sup_id,
5070: subro_id,

Line 5145: into PJI_FP_AGGR_RBS_T

5141: end if;
5142:
5143: -- Insert RBS node's parent --
5144: insert
5145: into PJI_FP_AGGR_RBS_T
5146: (
5147: struct_version_id,
5148: sup_id,
5149: subro_id,

Line 5183: from PJI_FP_AGGR_RBS_T pdt_child

5179: distinct
5180: pdt_child.sup_id,
5181: pdt_child.sub_id,
5182: pdt_child.sub_leaf_flag_id
5183: from PJI_FP_AGGR_RBS_T pdt_child
5184: where 1=1
5185: and pdt_child.sup_id = RBS_NODE.rbs_element_id
5186: and pdt_child.sup_id <> pdt_child.sub_id
5187: and pdt_child.worker_id = P_WORKER_ID

Line 5193: from PJI_FP_AGGR_RBS_T pdt_child1

5189:
5190: -- l_rbs_temp_level --
5191: select pdt_child1.sub_level
5192: into l_rbs_temp_level
5193: from PJI_FP_AGGR_RBS_T pdt_child1
5194: where 1=1
5195: and pdt_child1.sup_id = RBS_CHILDREN_NODE.sub_id
5196: and pdt_child1.sup_id = pdt_child1.sub_id
5197: and pdt_child1.worker_id = P_WORKER_ID;

Line 5224: into PJI_FP_AGGR_RBS_T

5220: end if;
5221:
5222: -- Insert RBS node's child --
5223: insert
5224: into PJI_FP_AGGR_RBS_T
5225: (
5226: struct_version_id,
5227: sup_id,
5228: subro_id,

Line 5712: from PJI_FP_AGGR_RBS_T interim

5708: l_last_updated_by,
5709: l_creation_date,
5710: l_created_by,
5711: l_last_update_login
5712: from PJI_FP_AGGR_RBS_T interim
5713: where interim.worker_id = p_worker_id;
5714:
5715: -- -------------------------
5716:

Line 5867: from PJI_FP_AGGR_RBS_T

5863: if p_extraction_type = 'ONLINE'
5864:
5865: then
5866: delete
5867: from PJI_FP_AGGR_RBS_T
5868: where worker_id = p_worker_id;
5869:
5870: else -- FULL, INCREMENTAL, PARTIAL, UPGRADE
5871: