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.OKL_OPEN_INTERFACE_PVT dependencies on PO_VENDOR_SITES_ALL

Line 19243: FROM po_vendor_sites_all

19239: RETURN VARCHAR2 IS /* 13924672 */
19240: CURSOR paygroup_csr (p_paysite_id NUMBER,
19241: p_org_id NUMBER) IS
19242: SELECT pay_group_lookup_code
19243: FROM po_vendor_sites_all
19244: WHERE vendor_site_id = p_vendor_paysite_id
19245: AND org_id = p_auth_org_id;
19246:
19247: l_paygroup po_vendor_sites_all.pay_group_lookup_code%TYPE;

Line 19247: l_paygroup po_vendor_sites_all.pay_group_lookup_code%TYPE;

19243: FROM po_vendor_sites_all
19244: WHERE vendor_site_id = p_vendor_paysite_id
19245: AND org_id = p_auth_org_id;
19246:
19247: l_paygroup po_vendor_sites_all.pay_group_lookup_code%TYPE;
19248: BEGIN
19249:
19250: x_return_status := OKL_API.G_RET_STS_SUCCESS;
19251:

Line 19454: l_paygroup_code po_vendor_sites_all.pay_group_lookup_code%TYPE;

19450: l_vend_invoice_format_id NUMBER;
19451: l_vend_invoice_format_name VARCHAR2(450);
19452:
19453: -- pass through
19454: l_paygroup_code po_vendor_sites_all.pay_group_lookup_code%TYPE;
19455: l_base_pmnt_dtls_rec ppydv_rec_type;
19456: l_evg_pmnt_dtls_rec ppydv_rec_type;
19457: l_pmnt_dtls_tbl_in ppydv_tbl_type;
19458: l_pmnt_dtls_tbl_out ppydv_tbl_type;

Line 26163: from po_vendor_sites_all

26159: p_site_id NUMBER,
26160: p_site_code VARCHAR2,
26161: p_auth_org_id NUMBER) IS
26162: select vendor_site_id
26163: from po_vendor_sites_all
26164: where ( (vendor_site_id = p_site_id
26165: AND
26166: p_site_id IS NOT NULL)
26167: OR

Line 26176: l_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE;

26172: and org_id = p_auth_org_id
26173: and vendor_id = p_vendor_id;
26174:
26175: l_vendor_id po_vendors.vendor_id%TYPE;
26176: l_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE;
26177: l_ppydv_rec ppydv_rec_type;
26178: x_ppydv_rec ppydv_rec_type;
26179:
26180: lessee_failed EXCEPTION;

Line 27179: CURSOR paysite_csr (p_code po_vendor_sites_all.vendor_site_code%TYPE,

27175: FROM okl_subsidies_b
27176: WHERE name = p_name
27177: AND org_id = p_org;
27178:
27179: CURSOR paysite_csr (p_code po_vendor_sites_all.vendor_site_code%TYPE,
27180: p_ven_id NUMBER,
27181: p_org NUMBER) IS
27182: SELECT vendor_site_id
27183: FROM po_vendor_sites_all

Line 27183: FROM po_vendor_sites_all

27179: CURSOR paysite_csr (p_code po_vendor_sites_all.vendor_site_code%TYPE,
27180: p_ven_id NUMBER,
27181: p_org NUMBER) IS
27182: SELECT vendor_site_id
27183: FROM po_vendor_sites_all
27184: WHERE vendor_site_code = p_code
27185: AND vendor_id = p_ven_id
27186: AND org_id = p_org;
27187: