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 OKX_PARTY_SITE_USES_V

Line 18553: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,

18549: x_msg_data OUT NOCOPY VARCHAR2,
18550: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18551: p_line_number IN okc_k_lines_v.line_number%TYPE,
18552: p_auth_org_id IN NUMBER,
18553: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18554: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,
18555: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE
18556: ) IS
18557:

Line 18554: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,

18550: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18551: p_line_number IN okc_k_lines_v.line_number%TYPE,
18552: p_auth_org_id IN NUMBER,
18553: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18554: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,
18555: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE
18556: ) IS
18557:
18558: CURSOR ship_csr (p_site_id NUMBER,

Line 18555: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE

18551: p_line_number IN okc_k_lines_v.line_number%TYPE,
18552: p_auth_org_id IN NUMBER,
18553: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18554: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,
18555: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE
18556: ) IS
18557:
18558: CURSOR ship_csr (p_site_id NUMBER,
18559: p_site_number VARCHAR2,

Line 18562: FROM okx_party_site_uses_v

18558: CURSOR ship_csr (p_site_id NUMBER,
18559: p_site_number VARCHAR2,
18560: p_customer_id NUMBER) IS
18561: SELECT party_site_id
18562: FROM okx_party_site_uses_v
18563: WHERE ((party_site_number = p_site_number
18564: AND
18565: p_site_number IS NOT NULL)
18566: OR

Line 23372: l_id1 okx_party_site_uses_v.id1%TYPE;

23368: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23369: ) IS
23370: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';
23371: install_failed EXCEPTION;
23372: l_id1 okx_party_site_uses_v.id1%TYPE;
23373:
23374: CURSOR install_csr (p_install_site_name okx_party_site_uses_v.name%TYPE,
23375: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS
23376: SELECT id1

Line 23374: CURSOR install_csr (p_install_site_name okx_party_site_uses_v.name%TYPE,

23370: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';
23371: install_failed EXCEPTION;
23372: l_id1 okx_party_site_uses_v.id1%TYPE;
23373:
23374: CURSOR install_csr (p_install_site_name okx_party_site_uses_v.name%TYPE,
23375: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS
23376: SELECT id1
23377: FROM okx_party_site_uses_v
23378: WHERE ((party_site_number = p_install_site_name

Line 23375: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS

23371: install_failed EXCEPTION;
23372: l_id1 okx_party_site_uses_v.id1%TYPE;
23373:
23374: CURSOR install_csr (p_install_site_name okx_party_site_uses_v.name%TYPE,
23375: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS
23376: SELECT id1
23377: FROM okx_party_site_uses_v
23378: WHERE ((party_site_number = p_install_site_name
23379: AND

Line 23377: FROM okx_party_site_uses_v

23373:
23374: CURSOR install_csr (p_install_site_name okx_party_site_uses_v.name%TYPE,
23375: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS
23376: SELECT id1
23377: FROM okx_party_site_uses_v
23378: WHERE ((party_site_number = p_install_site_name
23379: AND
23380: p_install_site_number IS NOT NULL)
23381: OR

Line 26886: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;

26882: x_cplv_rec cplv_rec_type;
26883: l_kplv_rec kplv_rec_type;
26884: x_kplv_rec kplv_rec_type;
26885:
26886: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;
26887: p_sidv_rec sidv_rec_type;
26888: x_sidv_rec sidv_rec_type;
26889:
26890: CURSOR addon_csr (p_contract_number VARCHAR2,

Line 27562: x_install_site_id okx_party_site_uses_v.id1%TYPE;

27558: x_pmnt_freq_id okx_tuom_v.id1%TYPE;
27559: x_uom_code okx_tuom_v.uom_code%TYPE;
27560: l_mult_factor NUMBER;
27561: l_current_start_date DATE;
27562: x_install_site_id okx_party_site_uses_v.id1%TYPE;
27563: l_rule_create_flag VARCHAR2(1) := 'Y';
27564:
27565: x_inv_item_id_prev NUMBER;
27566: p_inv_item_id_prev NUMBER;

Line 27568: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;

27564:
27565: x_inv_item_id_prev NUMBER;
27566: p_inv_item_id_prev NUMBER;
27567: p_line_type_prev VARCHAR2(35);
27568: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;
27569: l_rg_id NUMBER;
27570:
27571: x_cle_id okc_k_lines_v.id%TYPE;
27572: p_cle_id okc_k_lines_v.id%TYPE;