APPS.POS_ACK_PO dependencies on DUAL

Line 180: into l_accp_res from dual;

176: end if;
177: l_progress := '2';
178: if l_po_accept_reject = 'Y' then
179: select fnd_message.get_string('POS','POS_PO_ACCEPTED')
180: into l_accp_res from dual;
181: else
182: select fnd_message.get_string('POS','POS_PO_REJECTED')
183: into l_accp_res from dual;
184: end if;

Line 183: into l_accp_res from dual;

179: select fnd_message.get_string('POS','POS_PO_ACCEPTED')
180: into l_accp_res from dual;
181: else
182: select fnd_message.get_string('POS','POS_PO_REJECTED')
183: into l_accp_res from dual;
184: end if;
185:
186: if l_nid is not null then
187: l_progress := '3';

Line 346: select po_acceptances_s.nextval into l_acceptance_id from dual;

342: --Bug 6772960 - End
343:
344: --dbms_output.put_line('No Notification found ');
345: l_progress := '4';
346: select po_acceptances_s.nextval into l_acceptance_id from dual;
347:
348: if l_po_release_id is null then
349: l_doc := l_po_header_id;
350: x_po_header_id := l_po_header_id;

Line 376: from dual;

372: l_progress := '5';
373: l_role := null;
374: select pos_party_management_pkg.get_job_title_for_user( l_user_id)
375: into l_role
376: from dual;
377:
378: l_progress := '6';
379: /*BINDING IMPACT */
380: if (l_pending_signature_flag = 'Y') then

Line 497: select po_wf_itemkey_s.nextval into l_seq_val from dual;

493: l_progress := '10';
494:
495: --dbms_output.put_line('Calling Workflow');
496: -- call workflow to send the notification
497: select po_wf_itemkey_s.nextval into l_seq_val from dual;
498:
499: l_item_key := 'POSACKNT_' || l_doc || '_' || to_char(l_seq_val);
500:
501: --dbms_output.put_line('Item Key is ' ||l_item_key);

Line 604: from dual;

600: l_doc := pos_po_release_id;
601: end if;
602:
603: select po_wf_itemkey_s.nextval into l_seq_val
604: from dual;
605:
606: l_item_key := 'POS_PODATE_CHG_' || l_doc || '_' || to_char(l_seq_val);
607: pos_item_type := l_item_type;
608: pos_item_key := l_item_key;