DBA Data[Home] [Help]

APPS.POS_ACK_SEARCH dependencies on DUAL

Line 1930: from dual;

1926: IF pos_ack_acc_type_code(l_counter) <> '-99999' then
1927:
1928: l_rows_inserted := l_rows_inserted + 1;
1929: select po_acceptances_s.nextval into l_acceptance_id
1930: from dual;
1931:
1932: select revision_num,org_id into l_revision_num , l_org_id
1933: from po_headers_all
1934: where po_header_id = pos_ack_po_header_id(l_counter);

Line 1987: from dual;

1983:
1984: -- Call the workflow for sending notification to the Buyer
1985: select po_wf_itemkey_s.nextval
1986: into l_seq_val
1987: from dual;
1988:
1989: l_item_key := 'POS_PO_ACK_' || l_doc_id || '_' || to_char(l_seq_val);
1990:
1991: wf_engine.createProcess(ItemType => l_item_type,

Line 2187: select sysdate from dual;

2183: PROCEDURE DISPLAY_LOG
2184: IS
2185: debug_string VARCHAR2(2000);
2186: CURSOR debug_cursor IS
2187: select sysdate from dual;
2188: BEGIN
2189: open debug_cursor;
2190: htp.htmlOpen;
2191: htp.headOpen;