APPS.PA_RBS_UTILS dependencies on DUAL

Line 2659: INTO l_rbs_header_id from dual;

2655: -- can be rolled back if it errors.
2656: savepoint l_resource_list_savepoint;
2657:
2658: SELECT PA_RBS_HEADERS_S.nextval
2659: INTO l_rbs_header_id from dual;
2660:
2661: INSERT INTO PA_RBS_HEADERS_B
2662: (RBS_HEADER_ID,
2663: EFFECTIVE_FROM_DATE,

Line 2756: INTO l_rbs_version_id from dual;

2752:
2753: l_outline_number := '0';
2754:
2755: SELECT PA_RBS_VERSIONS_S.nextval
2756: INTO l_rbs_version_id from dual;
2757: l_Rbs_Version_From_Id := l_rbs_version_id;
2758:
2759: INSERT INTO PA_RBS_VERSIONS_B (
2760: RBS_VERSION_ID,

Line 2992: INTO l_top_node_id from dual;

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;
2996:

Line 2995: INTO l_rbs_identifier_id from dual;

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
2999: FROM pa_rbs_element_names_b

Line 3058: INTO l_rbs_element_id from dual;

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;
3062:

Line 3061: INTO l_rbs_identifier_id from dual;

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);
3065:

Line 3098: FROM dual;

3094: l_expenditure_category_id,
3095: decode(l_list.group_res_type, 'REVENUE_CATEGORY',
3096: l_revenue_category_id, NULL)))
3097: INTO l_resource_source_id
3098: FROM dual;
3099:
3100: --dbms_output.put_line('l_resource_source_id is: ' || l_resource_source_id);
3101:
3102: BEGIN

Line 3190: INTO l_rbs_element_id from dual;

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;
3194:

Line 3193: INTO l_rbs_identifier_id from dual;

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;
3197: CLOSE get_res_type_id;

Line 3292: FROM dual;

3288: l_members.project_role_id,
3289: decode(l_res_type_code,'SUPPLIER',
3290: l_members.vendor_id, NULL)))))))))
3291: INTO l_resource_source_id
3292: FROM dual;
3293:
3294: BEGIN
3295: SELECT rbs_element_name_id INTO l_element_name_id
3296: FROM pa_rbs_element_names_b

Line 3603: INTO l_rbs_version_id from dual;

3599: -- Create Working Version and elements.
3600: l_outline_number := '0';
3601:
3602: SELECT PA_RBS_VERSIONS_S.nextval
3603: INTO l_rbs_version_id from dual;
3604:
3605: INSERT INTO PA_RBS_VERSIONS_B (
3606: RBS_VERSION_ID,
3607: VERSION_NUMBER,