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 345: select po_acceptances_s.nextval into l_acceptance_id from dual;

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

Line 375: from dual;

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

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

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

Line 603: from dual;

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