APPS.POS_ACK_PO dependencies on PO_RELEASES_ALL

Line 93: FROM PO_RELEASES_ALL

89: poRec PO_CSR%ROWTYPE;
90:
91: CURSOR REL_CSR(p_po_release_id in number) IS
92: SELECT last_update_date
93: FROM PO_RELEASES_ALL
94: WHERE PO_RELEASE_ID = p_po_release_id
95: FOR UPDATE of last_update_date NOWAIT;
96:
97: relRec REL_CSR%ROWTYPE;

Line 138: from wf_notifications a,po_releases_all por,

134: begin
135: --dbms_output.put_line('For Std PO');
136: select a.notification_id,por.wf_item_type,por.wf_item_key
137: INTO l_nid,l_po_item_type,l_po_item_key
138: from wf_notifications a,po_releases_all por,
139: wf_item_activity_statuses wa
140: where por.po_release_id=l_po_release_id
141: and por.wf_item_key=wa.item_key
142: and por.wf_item_type=wa.item_type

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 368: from po_releases_all

364: x_po_header_id := null;
365: l_doc_subtype := 'RELEASE';
366:
367: select revision_num into l_revision_num
368: from po_releases_all
369: where po_release_id = to_number(l_po_release_id);
370: end if;
371: l_progress := '5';
372: l_role := null;

Line 476: update po_releases_all

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',
478: LAST_UPDATE_DATE = SYSDATE,
479: acceptance_due_date=''
480: where po_release_id = l_po_release_id;

Line 632: update po_releases_all

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
633: set authorization_status = 'IN PROCESS'
634: where po_release_id = to_number(pos_po_release_id);
635: end if;
636: