DBA Data[Home] [Help]

APPS.PA_RBS_UTILS dependencies on PA_RBS_ELEMENTS_S

Line 2991: SELECT PA_RBS_ELEMENTS_S.nextval

2987: ELSE
2988: --dbms_output.put_line('Populate_RBS_Element_Name Success');
2989: -- Continue by creating RBS elements.
2990: -- First create top node for the version:
2991: SELECT PA_RBS_ELEMENTS_S.nextval
2992: INTO l_top_node_id from dual;
2993:
2994: SELECT PA_RBS_ELEMENT_IDENTIFIER_S.nextval
2995: INTO l_rbs_identifier_id from dual;

Line 3057: SELECT PA_RBS_ELEMENTS_S.nextval

3053:
3054: l_outline_number := to_char(to_number(l_outline_number)
3055: + 1);
3056:
3057: SELECT PA_RBS_ELEMENTS_S.nextval
3058: INTO l_rbs_element_id from dual;
3059:
3060: SELECT PA_RBS_ELEMENT_IDENTIFIER_S.nextval
3061: INTO l_rbs_identifier_id from dual;

Line 3189: SELECT PA_RBS_ELEMENTS_S.nextval

3185: l_revenue_category_id := NULL;
3186: l_event_type_id := NULL;
3187: l_expenditure_type_id := NULL;
3188:
3189: SELECT PA_RBS_ELEMENTS_S.nextval
3190: INTO l_rbs_element_id from dual;
3191:
3192: SELECT PA_RBS_ELEMENT_IDENTIFIER_S.nextval
3193: INTO l_rbs_identifier_id from dual;

Line 3394: Pa_Rbs_Elements_S.NextVal,

3390: Old_Element_Id,
3391: Old_Parent_Element_Id,
3392: New_Parent_Element_Id )
3393: (Select
3394: Pa_Rbs_Elements_S.NextVal,
3395: Rbs_Element_Id,
3396: Parent_Element_Id,
3397: Null
3398: From

Line 3678: Pa_Rbs_Elements_S.NextVal,

3674: Old_Element_Id,
3675: Old_Parent_Element_Id,
3676: New_Parent_Element_Id )
3677: (Select
3678: Pa_Rbs_Elements_S.NextVal,
3679: Rbs_Element_Id,
3680: Parent_Element_Id,
3681: Null
3682: From