APPS.PJI_PJP_SUM_DENORM dependencies on PJI_FP_AGGR_RBS

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

4382: -- PA_RBS_ELEMENTS
4383: --
4384: -- Then, this API populates output values in the following existing
4385: -- table:
4386: -- PJI_FP_AGGR_RBS
4387: --
4388: -- -----------------------------------------------------------------------
4389:
4390: -- -----------------------------------------------------

Line 4613: from PJI_FP_AGGR_RBS pdt_count

4609: -- then we know that the node is a leaf
4610:
4611: select count(*)
4612: into l_rbs_node_count
4613: from PJI_FP_AGGR_RBS pdt_count
4614: where 1=1
4615: and pdt_count.sup_id = RBS_NODE.rbs_element_id
4616: and pdt_count.worker_id = P_WORKER_ID
4617: and rownum = 1;

Line 4652: into PJI_FP_AGGR_RBS

4648: end if;
4649:
4650: -- Insert RBS node self --
4651: insert
4652: into PJI_FP_AGGR_RBS
4653: (
4654: struct_version_id,
4655: sup_id,
4656: subro_id,

Line 4731: into PJI_FP_AGGR_RBS

4727: end if;
4728:
4729: -- Insert RBS node's parent --
4730: insert
4731: into PJI_FP_AGGR_RBS
4732: (
4733: struct_version_id,
4734: sup_id,
4735: subro_id,

Line 4769: from PJI_FP_AGGR_RBS pdt_child

4765: distinct
4766: pdt_child.sup_id,
4767: pdt_child.sub_id,
4768: pdt_child.sub_leaf_flag_id
4769: from PJI_FP_AGGR_RBS pdt_child
4770: where 1=1
4771: and pdt_child.sup_id = RBS_NODE.rbs_element_id
4772: and pdt_child.sup_id <> pdt_child.sub_id
4773: and pdt_child.worker_id = P_WORKER_ID

Line 4779: from PJI_FP_AGGR_RBS pdt_child1

4775:
4776: -- l_rbs_temp_level --
4777: select pdt_child1.sub_level
4778: into l_rbs_temp_level
4779: from PJI_FP_AGGR_RBS pdt_child1
4780: where 1=1
4781: and pdt_child1.sup_id = RBS_CHILDREN_NODE.sub_id
4782: and pdt_child1.sup_id = pdt_child1.sub_id
4783: and pdt_child1.worker_id = P_WORKER_ID;

Line 4810: into PJI_FP_AGGR_RBS

4806: end if;
4807:
4808: -- Insert RBS node's child --
4809: insert
4810: into PJI_FP_AGGR_RBS
4811: (
4812: struct_version_id,
4813: sup_id,
4814: subro_id,

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 5587: -- (PJI_FP_AGGR_RBS) to the actual denorm table (PA_RBS_DENORM)

5583: -- 19-MAR-2004 aartola Created
5584: --
5585: --
5586: -- *** This procedure merges data from the denorm interim table
5587: -- (PJI_FP_AGGR_RBS) to the actual denorm table (PA_RBS_DENORM)
5588: --
5589: -- After calling this procedure, the contents of the interim table
5590: -- need to be deleted.
5591: --

Line 5664: from PJI_FP_AGGR_RBS interim,

5660: l_last_updated_by,
5661: l_creation_date,
5662: l_created_by,
5663: l_last_update_login
5664: from PJI_FP_AGGR_RBS interim,
5665: PA_RBS_DENORM denorm
5666: where 1=1
5667: and interim.worker_id = p_worker_id
5668: and nvl(interim.struct_version_id, -1) = nvl(denorm.struct_version_id (+), -1)

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 5748: from PJI_FP_AGGR_RBS interim

5744: l_last_updated_by,
5745: l_creation_date,
5746: l_created_by,
5747: l_last_update_login
5748: from PJI_FP_AGGR_RBS interim
5749: where interim.worker_id = p_worker_id;
5750:
5751: -- -------------------------
5752:

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:

Line 5873: from PJI_FP_AGGR_RBS

5869:
5870: else -- FULL, INCREMENTAL, PARTIAL, UPGRADE
5871:
5872: delete
5873: from PJI_FP_AGGR_RBS
5874: where worker_id = p_worker_id;
5875: end if;
5876:
5877: -- -----------------------------------------------------