APPS.POS_COMMON_APIS dependencies on PO_HEADERS

Line 50: l_document_id po_headers.po_header_id%TYPE;

46: l_session_id NUMBER;
47: l_responsibility_id NUMBER;
48: l_item_type wf_items.item_type%TYPE;
49: l_item_key wf_items.item_key%TYPE;
50: l_document_id po_headers.po_header_id%TYPE;
51: l_document_num VARCHAR2(500);
52: l_header_msg VARCHAR2(500);
53: l_document VARCHAR2(32000) := '';
54: NL VARCHAR2(1) := fnd_global.newline;

Line 89: where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'

85:
86: /* select rowidtochar(ROWID)
87: into p_rowid
88: from AK_FLOW_REGION_RELATIONS
89: where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
90: and FROM_REGION_APPL_ID = 178
91: and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
92: and FROM_PAGE_APPL_ID = 178
93: and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'

Line 91: and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'

87: into p_rowid
88: from AK_FLOW_REGION_RELATIONS
89: where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
90: and FROM_REGION_APPL_ID = 178
91: and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
92: and FROM_PAGE_APPL_ID = 178
93: and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'
94: and TO_PAGE_APPL_ID = 178
95: and FLOW_CODE = 'ICX_INQUIRIES'

Line 93: and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'

89: where FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
90: and FROM_REGION_APPL_ID = 178
91: and FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
92: and FROM_PAGE_APPL_ID = 178
93: and TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'
94: and TO_PAGE_APPL_ID = 178
95: and FLOW_CODE = 'ICX_INQUIRIES'
96: and FLOW_APPLICATION_ID = 178;
97:

Line 309: from po_headers_all

305:
306: begin
307: x_progress := '001';
308: select vendor_id into x_vendor_id
309: from po_headers_all
310: where po_header_id = x_document_id;
311:
312: x_progress := '002';
313: exception

Line 323: from po_headers_all

319: begin
320: x_progress := '003';
321: select vendor_id
322: into x_vendor_id
323: from po_headers_all
324: where po_header_id = (select po_header_id from po_releases_all
325: where po_release_id = x_document_id);
326:
327: x_progress := '004';

Line 379: from po_headers

375: -- abort any outstanding acceptance notifications for any previous revision of the document.
376:
377: select nvl(revision_num, 0)
378: into x_doc_revision
379: from po_headers
380: where po_header_id = x_document_id;
381:
382: while x_doc_revision >= 0 loop
383: