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 19061: FROM po_vendor_sites_all

19057: RETURN NUMBER IS
19058: CURSOR paygroup_csr (p_paysite_id NUMBER,
19059: p_org_id NUMBER) IS
19060: SELECT pay_group_lookup_code
19061: FROM po_vendor_sites_all
19062: WHERE vendor_site_id = p_vendor_paysite_id
19063: AND org_id = p_auth_org_id;
19064:
19065: l_paygroup po_vendor_sites_all.pay_group_lookup_code%TYPE;

Line 19065: l_paygroup po_vendor_sites_all.pay_group_lookup_code%TYPE;

19061: FROM po_vendor_sites_all
19062: WHERE vendor_site_id = p_vendor_paysite_id
19063: AND org_id = p_auth_org_id;
19064:
19065: l_paygroup po_vendor_sites_all.pay_group_lookup_code%TYPE;
19066: BEGIN
19067:
19068: x_return_status := OKL_API.G_RET_STS_SUCCESS;
19069:

Line 19272: l_paygroup_code po_vendor_sites_all.pay_group_lookup_code%TYPE;

19268: l_vend_invoice_format_id NUMBER;
19269: l_vend_invoice_format_name VARCHAR2(450);
19270:
19271: -- pass through
19272: l_paygroup_code po_vendor_sites_all.pay_group_lookup_code%TYPE;
19273: l_base_pmnt_dtls_rec ppydv_rec_type;
19274: l_evg_pmnt_dtls_rec ppydv_rec_type;
19275: l_pmnt_dtls_tbl_in ppydv_tbl_type;
19276: l_pmnt_dtls_tbl_out ppydv_tbl_type;

Line 25913: from po_vendor_sites_all

25909: p_site_id NUMBER,
25910: p_site_code VARCHAR2,
25911: p_auth_org_id NUMBER) IS
25912: select vendor_site_id
25913: from po_vendor_sites_all
25914: where ( (vendor_site_id = p_site_id
25915: AND
25916: p_site_id IS NOT NULL)
25917: OR

Line 25926: l_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE;

25922: and org_id = p_auth_org_id
25923: and vendor_id = p_vendor_id;
25924:
25925: l_vendor_id po_vendors.vendor_id%TYPE;
25926: l_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE;
25927: l_ppydv_rec ppydv_rec_type;
25928: x_ppydv_rec ppydv_rec_type;
25929:
25930: lessee_failed EXCEPTION;

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

26903: FROM okl_subsidies_b
26904: WHERE name = p_name
26905: AND org_id = p_org;
26906:
26907: CURSOR paysite_csr (p_code po_vendor_sites_all.vendor_site_code%TYPE,
26908: p_ven_id NUMBER,
26909: p_org NUMBER) IS
26910: SELECT vendor_site_id
26911: FROM po_vendor_sites_all

Line 26911: FROM po_vendor_sites_all

26907: CURSOR paysite_csr (p_code po_vendor_sites_all.vendor_site_code%TYPE,
26908: p_ven_id NUMBER,
26909: p_org NUMBER) IS
26910: SELECT vendor_site_id
26911: FROM po_vendor_sites_all
26912: WHERE vendor_site_code = p_code
26913: AND vendor_id = p_ven_id
26914: AND org_id = p_org;
26915: