APPS.PA_RBS_PUB dependencies on PA_RBS_ELEMENTS

Line 396: From pa_rbs_elements a ,

392: b.resource_name Resource_Source_Code,
393: a.Rbs_Level,
394: a.Record_Version_Number,
395: a.Order_Number
396: From pa_rbs_elements a ,
397: pa_rbs_element_map b
398: Where rbs_element_id=P_Rbs_Element_Id
399: and a.resource_source_id =b.resource_id(+) ;
400:

Line 1010: Pa_Rbs_Elements_Utils.GetResSourceId(

1006: Pa_Debug.G_Stage := 'Check if resource source id is null.';
1007: If Element_Rec.Resource_Source_Id is Null Then
1008:
1009: Pa_Debug.G_Stage := 'Get Resource Source Id using source code.';
1010: Pa_Rbs_Elements_Utils.GetResSourceId(
1011: P_Resource_Type_Id => Element_Rec.Resource_Type_Id,
1012: P_Resource_Source_Code => Element_Rec.Resource_Source_Code,
1013: X_Resource_Source_Id => l_Resource_Source_Id);
1014:

Line 1029: Pa_Rbs_Elements_Pvt.Process_Rbs_Element(

1025:
1026: End If;
1027:
1028: Pa_Debug.G_Stage := 'Call Process_Rbs_Elements() procedure.';
1029: Pa_Rbs_Elements_Pvt.Process_Rbs_Element(
1030: P_RBS_Version_Id => Element_Rec.Rbs_Version_Id,
1031: P_Parent_Element_Id => Element_Rec.Parent_Element_Id,
1032: P_Element_Id => Element_Rec.Rbs_Element_Id,
1033: P_Resource_Type_Id => Element_Rec.Resource_Type_Id,

Line 1615: FROM pa_rbs_elements

1611: BEGIN
1612:
1613: SELECT 'Y'
1614: INTO l_validate
1615: FROM pa_rbs_elements
1616: WHERE rbs_version_id = l_Elements_Tbl(i).Rbs_Version_Id
1617: AND rbs_element_id = l_Elements_Tbl(i).Rbs_Element_Id;
1618:
1619: If l_validate = 'Y' Then

Line 1644: FROM pa_rbs_elements

1640: BEGIN
1641:
1642: SELECT 'Y'
1643: INTO l_validate
1644: FROM pa_rbs_elements
1645: WHERE rbs_version_id = l_Elements_Tbl(i).Rbs_Version_Id
1646: AND rbs_element_id = l_Elements_Tbl(i).Parent_Element_Id;
1647:
1648: If l_validate = 'Y' Then

Line 1674: FROM pa_rbs_elements

1670: BEGIN
1671:
1672: SELECT 'Y'
1673: INTO l_validate
1674: FROM pa_rbs_elements
1675: WHERE parent_element_id = l_Elements_Tbl(i).Parent_Element_Id
1676: AND rbs_element_id = l_Elements_Tbl(i).Rbs_Element_Id;
1677:
1678: If l_validate = 'Y' Then

Line 1822: Pa_Rbs_Elements_Utils.GetResSourceId(

1818: Pa_Debug.G_Stage := 'Check if resource source id is null.';
1819: If Element_Rec.Resource_Source_Id is Null Then
1820:
1821: Pa_Debug.G_Stage := 'Get Resource Source Id using source code.';
1822: Pa_Rbs_Elements_Utils.GetResSourceId(
1823: P_Resource_Type_Id => Element_Rec.Resource_Type_Id,
1824: P_Resource_Source_Code => Element_Rec.Resource_Source_Code,
1825: X_Resource_Source_Id => l_Resource_Source_Id);
1826:

Line 1841: Pa_Rbs_Elements_Pvt.Process_Rbs_Element(

1837:
1838: End If;
1839:
1840: Pa_Debug.G_Stage := 'Call Process_Rbs_Elements() procedure.';
1841: Pa_Rbs_Elements_Pvt.Process_Rbs_Element(
1842: P_RBS_Version_Id => Element_Rec.Rbs_Version_Id,
1843: P_Parent_Element_Id => Element_Rec.Parent_Element_Id,
1844: P_Element_Id => Element_Rec.Rbs_Element_Id,
1845: P_Resource_Type_Id => Element_Rec.Resource_Type_Id,

Line 3151: Pa_Rbs_Elements

3147: Cursor c2(P_Id IN Number) Is
3148: Select
3149: Outline_Number
3150: From
3151: Pa_Rbs_Elements
3152: Where
3153: Rbs_Element_Id = P_Id;
3154:
3155: Begin