DBA Data[Home] [Help]

APPS.PO_WAGE_DETERMINATION_ONLINE dependencies on DUAL

Line 106: /*SELECT po_wdol_evnt_s.NEXTVAL INTO l_event_key FROM dual;

102:
103:
104: BEGIN
105:
106: /*SELECT po_wdol_evnt_s.NEXTVAL INTO l_event_key FROM dual;
107: l_event_key := 'WDOL'||l_event_key;
108: l_event_name := 'oracle.apps.po.integration.wagedetermination';
109: l_message := wf_event.test(l_event_name);
110:

Line 159: FROM dual;

155: END IF;
156:
157: SELECT fnd_attached_documents_s.nextval
158: INTO x_attached_document_id
159: FROM dual;
160:
161: open c_get_max_attach_seq;
162: fetch c_get_max_attach_seq into l_seq_num;
163: close c_get_max_attach_seq;

Line 167: select decode(p_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;

163: close c_get_max_attach_seq;
164:
165: l_seq_num := l_seq_num + 1;
166:
167: select decode(p_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;
168:
169: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
170: X_attached_document_id => x_attached_document_id,
171: X_document_id => X_document_id,

Line 362: FROM dual;

358: END IF;
359:
360: SELECT fnd_attached_documents_s.nextval
361: INTO x_attached_document_id
362: FROM dual;
363:
364: open c_get_max_attach_seq;
365: fetch c_get_max_attach_seq into l_seq_num;
366: close c_get_max_attach_seq;

Line 370: select decode(l_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;

366: close c_get_max_attach_seq;
367:
368: l_seq_num := l_seq_num + 1;
369:
370: select decode(l_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;
371:
372:
373: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
374: X_attached_document_id => x_attached_document_id,