eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PO_HEADERS_ALL

Line 1821: FROM po_headers_all po

1817:
1818: CURSOR c_po_dist_type (p_po_header_id NUMBER,
1819: p_po_release_id NUMBER) IS
1820: SELECT type_lookup_code
1821: FROM po_headers_all po
1822: WHERE po.po_header_id = p_po_header_id
1823: AND p_po_release_id IS NULL
1824: UNION
1825: SELECT release_type

Line 3002: FROM po_headers_all poh

2998: -- Cursor to fetch Vendor and organization details for PO line
2999: CURSOR cur_po_vend_org_details (p_header_id NUMBER )IS
3000: SELECT poh.vendor_id,
3001: poh.org_id
3002: FROM po_headers_all poh
3003: WHERE poh.po_header_id = p_header_id;
3004:
3005:
3006: CURSOR c_count_success_recs(p_packet_id NUMBER) IS

Line 3030: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;

3026: l_index NUMBER;
3027: l_count_success_rec NUMBER;
3028:
3029: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3030: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3031: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3032: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3033: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3034: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;

Line 3031: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;

3027: l_count_success_rec NUMBER;
3028:
3029: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3030: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3031: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3032: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3033: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3034: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3035: l_packet_id pa_bc_packets.packet_id%TYPE;

Line 3032: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;

3028:
3029: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3030: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3031: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3032: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3033: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3034: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3035: l_packet_id pa_bc_packets.packet_id%TYPE;
3036: l_prepay_exists VARCHAR2(1);

Line 3033: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;

3029: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3030: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3031: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3032: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3033: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3034: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3035: l_packet_id pa_bc_packets.packet_id%TYPE;
3036: l_prepay_exists VARCHAR2(1);
3037: l_stdinvoice_exists VARCHAR2(1);

Line 3034: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;

3030: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3031: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3032: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3033: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3034: l_po_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3035: l_packet_id pa_bc_packets.packet_id%TYPE;
3036: l_prepay_exists VARCHAR2(1);
3037: l_stdinvoice_exists VARCHAR2(1);
3038: