APPS.PO_UDA_DATA_UTIL dependencies on DUAL

Line 210: FROM DUAL;

206: BEGIN
207: d_progress := 10;
208: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
209: INTO l_row_identifier
210: FROM DUAL;
211:
212: d_progress := 20;
213: SELECT DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
214: INTO l_attr_group_type, l_attr_group_name

Line 258: FROM DUAL;

254:
255: d_progress := 70;
256: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
257: INTO l_user_row_identifier
258: FROM DUAL;
259:
260: d_progress := 80;
261: x_attr_name_value_pairs.EXTEND(1);
262: x_attr_name_value_pairs(x_attr_name_value_pairs.COUNT) := ego_user_attr_data_obj

Line 488: FROM sys.dual;

484: d_progress := 30;
485:
486: SELECT EGO_ASSOCS_S.NEXTVAL
487: INTO x_association_id
488: FROM sys.dual;
489:
490:
491: PO_UDA_TEMPLATES_UTIL.Create_Association (
492: p_api_version => 1.0

Line 2171: FROM sys.dual;

2167:
2168: -- Updating the required information.
2169: SELECT EGO_EXTFWK_S.NEXTVAL
2170: INTO amd_address_rows(row_b).extension_id
2171: FROM sys.dual;
2172:
2173: amd_address_rows(row_b).requisition_header_id := x_requisition_header_id;
2174: amd_address_rows(row_b).c_ext_attr40 := 'PR_UDA_ADDRESS_TYPES';
2175:

Line 2263: FROM sys.dual;

2259:
2260: -- Updating the required information.
2261: SELECT EGO_EXTFWK_S.NEXTVAL
2262: INTO po_address_rows(row_b).extension_id
2263: FROM sys.dual;
2264:
2265: po_address_rows(row_b).po_header_id := p_po_header_id;
2266: po_address_rows(row_b).draft_id := -1;
2267: po_address_rows(row_b).c_ext_attr40 := 'PO_UDA_ADDRESS_TYPES';