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 354: from po_headers_all

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

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

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

Line 485: update po_headers_all

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

Line 629: update po_headers_all

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