APPS.POS_ACK_PO dependencies on PO_HEADERS_ALL

Line 47: l_pending_signature_flag PO_HEADERS_ALL.pending_signature_flag%type;

43: l_supp_username VARCHAR2(100);
44: l_supplier_displayname VARCHAR2(100);
45: l_action VARCHAR2(20);
46: x_vendor VARCHAR2(240);
47: l_pending_signature_flag PO_HEADERS_ALL.pending_signature_flag%type;
48: x_row_id varchar2(30);
49: x_Acceptance_id number;
50: x_Last_Update_Date date ;
51: x_Last_Updated_By number;

Line 81: l_last_upd_date po_headers_all.last_update_date%type;

77: --Bug 6772960 - Start
78: /*Added the l_last_upd_date variables to check the concurrency.
79: Added the cursors to get the latest last_update_date which is there in the database.
80: */
81: l_last_upd_date po_headers_all.last_update_date%type;
82:
83: CURSOR PO_CSR(p_po_header_id in number) IS
84: SELECT last_update_date
85: FROM PO_HEADERS_ALL

Line 85: FROM PO_HEADERS_ALL

81: l_last_upd_date po_headers_all.last_update_date%type;
82:
83: CURSOR PO_CSR(p_po_header_id in number) IS
84: SELECT last_update_date
85: FROM PO_HEADERS_ALL
86: WHERE PO_HEADER_ID = p_po_header_id
87: FOR UPDATE of last_update_date NOWAIT;
88:
89: poRec PO_CSR%ROWTYPE;

Line 121: from wf_notifications a,po_headers_all poh,

117: --dbms_output.put_line('For Releases');
118: begin
119: select a.notification_id,poh.wf_item_type,poh.wf_item_key, a.message_name
120: INTO l_nid,l_po_item_type,l_po_item_key, l_message_name
121: from wf_notifications a,po_headers_all poh,
122: wf_item_activity_statuses wa
123: where poh.po_header_id=l_po_header_id
124: and poh.wf_item_key=wa.item_key
125: and poh.wf_item_type=wa.item_type

Line 166: from po_vendors pov,po_headers_all poh

162: -- Get the Vendor Name
163: if l_po_release_id is null then
164: select pov.vendor_name
165: into x_vendor
166: from po_vendors pov,po_headers_all poh
167: where pov.vendor_id = poh.vendor_id
168: and poh.po_header_id=l_po_header_id;
169: else
170: select pov.vendor_name

Line 172: from po_releases_all por,po_headers_all poh,po_vendors pov

168: and poh.po_header_id=l_po_header_id;
169: else
170: select pov.vendor_name
171: into x_vendor
172: from po_releases_all por,po_headers_all poh,po_vendors pov
173: where por.po_release_id = l_po_release_id
174: and por.po_header_id = poh.po_header_id
175: and poh.vendor_id = pov.vendor_id;
176: end if;

Line 353: from po_headers_all

349: x_po_header_id := l_po_header_id;
350:
351: select revision_num ,nvl(pending_signature_flag,'N'),type_lookup_code
352: into l_revision_num,l_pending_signature_flag,l_doc_subtype
353: from po_headers_all
354: where po_header_id = to_number(l_po_header_id);
355:
356: if (l_doc_subtype in ('STANDARD','PLANNED')) then
357: l_doc_type := 'PO';

Line 473: -- Update the last update date when po_headers_all table is updated.

469: l_progress := '9';
470:
471: -- Reset the Acceptance required Flag
472: --Bug 6772960 - Start
473: -- Update the last update date when po_headers_all table is updated.
474:
475: if l_po_release_id is not null then
476: update po_releases_all
477: set acceptance_required_flag = 'N',

Line 484: update po_headers_all

480: where po_release_id = l_po_release_id;
481: else
482: -- Do not reset the acceptance_required Flag for signatures
483: if (l_pending_signature_flag = 'N') then
484: update po_headers_all
485: set acceptance_required_flag = 'N',
486: LAST_UPDATE_DATE = SYSDATE,
487: acceptance_due_date=''
488: where po_header_id = l_po_header_id;

Line 628: update po_headers_all

624: avalue => to_number(l_doc)
625: );
626:
627: if pos_po_release_id is null then
628: update po_headers_all
629: set authorization_status = 'IN PROCESS'
630: where po_header_id = to_number(pos_po_header_id);
631: else
632: update po_releases_all