APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PO_HEADERS_ALL

Line 1867: FROM po_headers_all po

1863:
1864: CURSOR c_po_dist_type (p_po_header_id NUMBER,
1865: p_po_release_id NUMBER) IS
1866: SELECT type_lookup_code
1867: FROM po_headers_all po
1868: WHERE po.po_header_id = p_po_header_id
1869: AND p_po_release_id IS NULL
1870: UNION
1871: SELECT release_type

Line 3274: FROM po_headers_all poh

3270: -- Cursor to fetch Vendor and organization details for PO line
3271: CURSOR cur_po_vend_org_details (p_header_id NUMBER )IS
3272: SELECT poh.vendor_id,
3273: poh.org_id
3274: FROM po_headers_all poh
3275: WHERE poh.po_header_id = p_header_id;
3276:
3277:
3278: CURSOR c_count_success_recs(p_packet_id NUMBER) IS

Line 3302: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;

3298: l_index NUMBER;
3299: l_count_success_rec NUMBER;
3300:
3301: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3302: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3303: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3304: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3305: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3306: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;

Line 3303: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;

3299: l_count_success_rec NUMBER;
3300:
3301: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3302: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3303: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3304: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3305: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3306: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3307: l_packet_id pa_bc_packets.packet_id%TYPE;

Line 3304: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;

3300:
3301: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3302: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3303: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3304: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3305: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3306: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3307: l_packet_id pa_bc_packets.packet_id%TYPE;
3308: l_prepay_exists VARCHAR2(1);

Line 3305: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;

3301: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3302: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3303: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3304: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3305: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3306: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3307: l_packet_id pa_bc_packets.packet_id%TYPE;
3308: l_prepay_exists VARCHAR2(1);
3309: l_stdinvoice_exists VARCHAR2(1);

Line 3306: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;

3302: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3303: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3304: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3305: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3306: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3307: l_packet_id pa_bc_packets.packet_id%TYPE;
3308: l_prepay_exists VARCHAR2(1);
3309: l_stdinvoice_exists VARCHAR2(1);
3310: