APPS.PA_RBS_PUB dependencies on PA_RBS_NODES_TEMP

Line 677: Pa_Rbs_Nodes_Temp;

673: Cursor c1 Is
674: Select
675: Max(Rbs_Level)
676: From
677: Pa_Rbs_Nodes_Temp;
678:
679: Cursor c2 (P_Rbs_Level IN Number) Is
680: Select
681: Rbs_Version_Id,

Line 695: Pa_Rbs_Nodes_Temp

691: Parent_Ref_Element_Id,
692: Rbs_Ref_Element_Id,
693: Record_Index
694: From
695: Pa_Rbs_Nodes_Temp
696: Where
697: Rbs_Level = P_Rbs_Level
698: Order By
699: Rbs_Ref_Element_Id;

Line 707: Pa_Rbs_Nodes_Temp

703: Cursor c3 Is
704: Select
705: Count(*)
706: From
707: Pa_Rbs_Nodes_Temp
708: Where
709: Rbs_Level = 1;
710:
711: Begin

Line 908: Pa_Debug.G_Stage := 'Insert record into pa_rbs_nodes_temp table for further processing.';

904: Raise l_ERROR;
905:
906: End If;
907:
908: Pa_Debug.G_Stage := 'Insert record into pa_rbs_nodes_temp table for further processing.';
909: Insert into Pa_Rbs_Nodes_Temp (
910: Rbs_Version_Id,
911: Rbs_Element_Id,
912: Parent_Element_Id,

Line 909: Insert into Pa_Rbs_Nodes_Temp (

905:
906: End If;
907:
908: Pa_Debug.G_Stage := 'Insert record into pa_rbs_nodes_temp table for further processing.';
909: Insert into Pa_Rbs_Nodes_Temp (
910: Rbs_Version_Id,
911: Rbs_Element_Id,
912: Parent_Element_Id,
913: Resource_Type_Id,

Line 1055: Pa_Debug.G_Stage := 'Update the rbs_element_id in the pa_rbs_nodes_temp table.';

1051:
1052: End If;
1053:
1054: -- now need to update the temp recs with the element id just created
1055: Pa_Debug.G_Stage := 'Update the rbs_element_id in the pa_rbs_nodes_temp table.';
1056: Update Pa_Rbs_Nodes_Temp
1057: Set
1058: Rbs_Element_Id = l_Rbs_Element_Id
1059: Where

Line 1056: Update Pa_Rbs_Nodes_Temp

1052: End If;
1053:
1054: -- now need to update the temp recs with the element id just created
1055: Pa_Debug.G_Stage := 'Update the rbs_element_id in the pa_rbs_nodes_temp table.';
1056: Update Pa_Rbs_Nodes_Temp
1057: Set
1058: Rbs_Element_Id = l_Rbs_Element_Id
1059: Where
1060: Rbs_Ref_Element_Id = Element_Rec.Rbs_Ref_Element_Id;

Line 1062: Pa_Debug.G_Stage := 'Update the parent_element_id in the pa_rbs_nodes_temp table where needed.';

1058: Rbs_Element_Id = l_Rbs_Element_Id
1059: Where
1060: Rbs_Ref_Element_Id = Element_Rec.Rbs_Ref_Element_Id;
1061:
1062: Pa_Debug.G_Stage := 'Update the parent_element_id in the pa_rbs_nodes_temp table where needed.';
1063: Update Pa_Rbs_Nodes_Temp
1064: Set
1065: Parent_Element_Id = l_Rbs_Element_Id
1066: Where

Line 1063: Update Pa_Rbs_Nodes_Temp

1059: Where
1060: Rbs_Ref_Element_Id = Element_Rec.Rbs_Ref_Element_Id;
1061:
1062: Pa_Debug.G_Stage := 'Update the parent_element_id in the pa_rbs_nodes_temp table where needed.';
1063: Update Pa_Rbs_Nodes_Temp
1064: Set
1065: Parent_Element_Id = l_Rbs_Element_Id
1066: Where
1067: Parent_Ref_Element_Id = Element_Rec.Rbs_Ref_Element_Id;

Line 1185: Pa_Rbs_Nodes_Temp;

1181: Cursor c1 Is
1182: Select
1183: Max(Rbs_Level)
1184: From
1185: Pa_Rbs_Nodes_Temp;
1186:
1187: Cursor c2 (P_Rbs_Level IN Number,
1188: P_Process_Type IN Varchar2) Is
1189: Select

Line 1204: Pa_Rbs_Nodes_Temp

1200: Parent_Ref_Element_Id,
1201: Rbs_Ref_Element_Id,
1202: Record_Index
1203: From
1204: Pa_Rbs_Nodes_Temp
1205: Where
1206: Rbs_Level = P_Rbs_Level
1207: And Process_Type = P_Process_Type
1208: Order By

Line 1217: Pa_Rbs_Nodes_Temp

1213: Cursor c3 Is
1214: Select
1215: Count(*)
1216: From
1217: Pa_Rbs_Nodes_Temp
1218: Where
1219: Rbs_Level = 1;
1220:
1221: Cursor rbs_header_cursor (P_header_id In Number) Is

Line 1696: Pa_Debug.G_Stage := 'Insert record into pa_rbs_nodes_temp table for further processing.';

1692:
1693: END IF;
1694: --End of Bug 3964469.
1695:
1696: Pa_Debug.G_Stage := 'Insert record into pa_rbs_nodes_temp table for further processing.';
1697: Insert into Pa_Rbs_Nodes_Temp (
1698: Rbs_Version_Id,
1699: Rbs_Element_Id,
1700: Parent_Element_Id,

Line 1697: Insert into Pa_Rbs_Nodes_Temp (

1693: END IF;
1694: --End of Bug 3964469.
1695:
1696: Pa_Debug.G_Stage := 'Insert record into pa_rbs_nodes_temp table for further processing.';
1697: Insert into Pa_Rbs_Nodes_Temp (
1698: Rbs_Version_Id,
1699: Rbs_Element_Id,
1700: Parent_Element_Id,
1701: Resource_Type_Id,

Line 1874: Update Pa_Rbs_Nodes_Temp

1870: If l_Process_Type = 'A' Then
1871:
1872: -- This should always update at least one record
1873: Pa_Debug.G_Stage := 'Update rbs_element_id based on temp rbs element id.';
1874: Update Pa_Rbs_Nodes_Temp
1875: Set
1876: Rbs_Element_Id = l_Rbs_Element_Id
1877: Where
1878: Rbs_Ref_Element_Id = Element_Rec.Rbs_Ref_Element_Id;

Line 1882: Update Pa_Rbs_Nodes_Temp

1878: Rbs_Ref_Element_Id = Element_Rec.Rbs_Ref_Element_Id;
1879:
1880: -- This may or may not update records
1881: Pa_Debug.G_Stage := 'Update parent_element_id based on temp parent id.';
1882: Update Pa_Rbs_Nodes_Temp
1883: Set
1884: Parent_Element_Id = l_Rbs_Element_Id
1885: Where
1886: Parent_Ref_Element_Id = Element_Rec.Rbs_Ref_Element_Id