DBA Data[Home] [Help]

APPS.PA_RBS_UTILS dependencies on PA_RBS_ELEMENT_IDENTIFIER_S

Line 2994: SELECT PA_RBS_ELEMENT_IDENTIFIER_S.nextval

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;
2996:
2997:
2998: SELECT rbs_element_name_id INTO l_element_name_id

Line 3060: SELECT PA_RBS_ELEMENT_IDENTIFIER_S.nextval

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;
3062:
3063: --dbms_output.put_line('Getting Parent Exp Rev');
3064: --dbms_output.put_line('group_res_type is ' || l_list.group_res_type);

Line 3192: SELECT PA_RBS_ELEMENT_IDENTIFIER_S.nextval

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;
3194:
3195: OPEN get_res_type_id(l_members.resource_type_id);
3196: FETCH get_res_type_id into l_res_type_id, l_res_type_code;