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

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

Line 477: update po_releases_all

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

Line 633: update po_releases_all

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