APPS.PJI_PJP_SUM_DENORM dependencies on PA_RBS_MAPPING

Line 4662: and ( pvt_nodes2.rbs_element_id between PA_RBS_MAPPING.g_max_rbs_id1 and PA_RBS_MAPPING.g_max_rbs_id2

4658: and pvt_nodes2.rbs_version_id = log11.event_object
4659: and pvt_nodes2.rbs_level = l_rbs_level_id
4660: /* Added for Bug 9099240 Start */
4661: and l_rbs_level_id = l_max_rbs_level_id
4662: and ( pvt_nodes2.rbs_element_id between PA_RBS_MAPPING.g_max_rbs_id1 and PA_RBS_MAPPING.g_max_rbs_id2
4663: or (PA_RBS_MAPPING.g_max_rbs_id1 is null
4664: and PA_RBS_MAPPING.g_max_rbs_id2 is null)) --Added for 10181391
4665: UNION ALL
4666: select

Line 4663: or (PA_RBS_MAPPING.g_max_rbs_id1 is null

4659: and pvt_nodes2.rbs_level = l_rbs_level_id
4660: /* Added for Bug 9099240 Start */
4661: and l_rbs_level_id = l_max_rbs_level_id
4662: and ( pvt_nodes2.rbs_element_id between PA_RBS_MAPPING.g_max_rbs_id1 and PA_RBS_MAPPING.g_max_rbs_id2
4663: or (PA_RBS_MAPPING.g_max_rbs_id1 is null
4664: and PA_RBS_MAPPING.g_max_rbs_id2 is null)) --Added for 10181391
4665: UNION ALL
4666: select
4667: distinct

Line 4664: and PA_RBS_MAPPING.g_max_rbs_id2 is null)) --Added for 10181391

4660: /* Added for Bug 9099240 Start */
4661: and l_rbs_level_id = l_max_rbs_level_id
4662: and ( pvt_nodes2.rbs_element_id between PA_RBS_MAPPING.g_max_rbs_id1 and PA_RBS_MAPPING.g_max_rbs_id2
4663: or (PA_RBS_MAPPING.g_max_rbs_id1 is null
4664: and PA_RBS_MAPPING.g_max_rbs_id2 is null)) --Added for 10181391
4665: UNION ALL
4666: select
4667: distinct
4668: pvt_nodes2.rbs_version_id,

Line 5056: PA_RBS_MAPPING.g_max_rbs_id1 := PA_RBS_MAPPING.g_max_rbs_id2 + 1;

5052: );
5053: end if;
5054: -- -----------------------------------------
5055: /* Added for Bug 9099240 Start */
5056: PA_RBS_MAPPING.g_max_rbs_id1 := PA_RBS_MAPPING.g_max_rbs_id2 + 1;
5057: PA_RBS_MAPPING.g_max_rbs_id2 := 0;
5058: /* Added for Bug 9099240 End */
5059:
5060: end rbs_denorm;

Line 5057: PA_RBS_MAPPING.g_max_rbs_id2 := 0;

5053: end if;
5054: -- -----------------------------------------
5055: /* Added for Bug 9099240 Start */
5056: PA_RBS_MAPPING.g_max_rbs_id1 := PA_RBS_MAPPING.g_max_rbs_id2 + 1;
5057: PA_RBS_MAPPING.g_max_rbs_id2 := 0;
5058: /* Added for Bug 9099240 End */
5059:
5060: end rbs_denorm;
5061:

Line 5138: l_rbs_id1 := NVL(PA_RBS_MAPPING.g_max_rbs_id1,0); -- Fix for Bug 13107900

5134: );
5135: end if;
5136:
5137: /* Added for Bug 9099240 Start */
5138: l_rbs_id1 := NVL(PA_RBS_MAPPING.g_max_rbs_id1,0); -- Fix for Bug 13107900
5139: l_rbs_id2 := PA_RBS_MAPPING.g_max_rbs_id2;
5140: l_rbs_exists1 := 0;
5141: l_rbs_exists2 := 0;
5142: l_rbs_exists3 := 0;

Line 5139: l_rbs_id2 := PA_RBS_MAPPING.g_max_rbs_id2;

5135: end if;
5136:
5137: /* Added for Bug 9099240 Start */
5138: l_rbs_id1 := NVL(PA_RBS_MAPPING.g_max_rbs_id1,0); -- Fix for Bug 13107900
5139: l_rbs_id2 := PA_RBS_MAPPING.g_max_rbs_id2;
5140: l_rbs_exists1 := 0;
5141: l_rbs_exists2 := 0;
5142: l_rbs_exists3 := 0;
5143: /* Added for Bug 9099240 End */

Line 5593: PA_RBS_MAPPING.g_max_rbs_id1 := PA_RBS_MAPPING.g_max_rbs_id2 + 1;

5589: );
5590: end if;
5591: -- -------------------------------------------------
5592: /* Added for Bug 9099240 Start */
5593: PA_RBS_MAPPING.g_max_rbs_id1 := PA_RBS_MAPPING.g_max_rbs_id2 + 1;
5594: PA_RBS_MAPPING.g_max_rbs_id2 := 0;
5595: /* Added for Bug 9099240 End */
5596:
5597: end rbs_denorm_online;

Line 5594: PA_RBS_MAPPING.g_max_rbs_id2 := 0;

5590: end if;
5591: -- -------------------------------------------------
5592: /* Added for Bug 9099240 Start */
5593: PA_RBS_MAPPING.g_max_rbs_id1 := PA_RBS_MAPPING.g_max_rbs_id2 + 1;
5594: PA_RBS_MAPPING.g_max_rbs_id2 := 0;
5595: /* Added for Bug 9099240 End */
5596:
5597: end rbs_denorm_online;
5598: