APPS.PO_UDA_AUTOCREATE_PKG dependencies on DUAL

Line 323: FROM dual;*/

319: /*x_priorities_tbl.extend();
320: SELECT Decode (p_src_doc_type,'REQ', 'PR'
321: ,'OFFER','OFR')
322: INTO x_priorities_tbl(1)
323: FROM dual;*/
324: NULL;
325: END;
326:
327:

Line 435: FROM dual;

431:
432: IF x_group_property_tbl.Count = 0 THEN
433: SELECT NULL
434: BULK COLLECT INTO x_group_property_tbl
435: FROM dual;
436: END IF;
437:
438:
439: IF g_debug_stmt THEN

Line 1378: FROM dual;

1374: l_progress := '010';
1375:
1376: SELECT p_attr_group
1377: BULK COLLECT INTO l_attr_group_tbl
1378: FROM dual;
1379:
1380: FOR i IN 1.. p_priorities_tbl.Count
1381: LOOP
1382: IF g_debug_stmt THEN

Line 2185: FROM DUAL;

2181:
2182: l_progress := '050';
2183: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
2184: INTO l_row_identifier
2185: FROM DUAL;
2186:
2187: l_attributes_row_table.EXTEND(1);
2188: l_attributes_row_table(1) := ego_user_attr_row_obj
2189: (

Line 2217: FROM DUAL;

2213:
2214: l_progress := '110';
2215: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
2216: INTO l_user_row_identifier
2217: FROM DUAL;
2218:
2219: l_attr_name_value_pairs.EXTEND(1);
2220:
2221: IF l_attr_col = 'C_EXT_ATTR39' THEN

Line 2501: FROM dual;

2497: WHERE b.ROW_IDENTIFIER =p_extension_id;
2498:
2499: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
2500: INTO l_new_extension_id
2501: FROM dual;
2502:
2503: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(ego_col_name_value_pair_obj('UDA_TEMPLATE_ID',g_tar_header_uda_template_id ||'' ));
2504:
2505: l_process_attr_row_tbl(1).ATTR_GROUP_ID := get_ag_id('PO_HEADER_EXT_ATTRS','addresses');