APPS.PJI_PJP_SUM_DENORM dependencies on PJI_FP_AGGR_RBS_T

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 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 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 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: