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 18372: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,

18368: x_msg_data OUT NOCOPY VARCHAR2,
18369: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18370: p_line_number IN okc_k_lines_v.line_number%TYPE,
18371: p_auth_org_id IN NUMBER,
18372: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18373: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,
18374: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE
18375: ) IS
18376:

Line 18373: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,

18369: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18370: p_line_number IN okc_k_lines_v.line_number%TYPE,
18371: p_auth_org_id IN NUMBER,
18372: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18373: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,
18374: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE
18375: ) IS
18376:
18377: CURSOR ship_csr (p_site_id NUMBER,

Line 18374: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE

18370: p_line_number IN okc_k_lines_v.line_number%TYPE,
18371: p_auth_org_id IN NUMBER,
18372: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18373: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,
18374: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE
18375: ) IS
18376:
18377: CURSOR ship_csr (p_site_id NUMBER,
18378: p_site_number VARCHAR2,

Line 18381: FROM okx_party_site_uses_v

18377: CURSOR ship_csr (p_site_id NUMBER,
18378: p_site_number VARCHAR2,
18379: p_customer_id NUMBER) IS
18380: SELECT party_site_id
18381: FROM okx_party_site_uses_v
18382: WHERE ((party_site_number = p_site_number
18383: AND
18384: p_site_number IS NOT NULL)
18385: OR

Line 23183: l_id1 okx_party_site_uses_v.id1%TYPE;

23179: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23180: ) IS
23181: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';
23182: install_failed EXCEPTION;
23183: l_id1 okx_party_site_uses_v.id1%TYPE;
23184:
23185: CURSOR install_csr (p_install_site_name okx_party_site_uses_v.name%TYPE,
23186: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS
23187: SELECT id1

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

23181: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';
23182: install_failed EXCEPTION;
23183: l_id1 okx_party_site_uses_v.id1%TYPE;
23184:
23185: CURSOR install_csr (p_install_site_name okx_party_site_uses_v.name%TYPE,
23186: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS
23187: SELECT id1
23188: FROM okx_party_site_uses_v
23189: WHERE ((party_site_number = p_install_site_name

Line 23186: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS

23182: install_failed EXCEPTION;
23183: l_id1 okx_party_site_uses_v.id1%TYPE;
23184:
23185: CURSOR install_csr (p_install_site_name okx_party_site_uses_v.name%TYPE,
23186: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS
23187: SELECT id1
23188: FROM okx_party_site_uses_v
23189: WHERE ((party_site_number = p_install_site_name
23190: AND

Line 23188: FROM okx_party_site_uses_v

23184:
23185: CURSOR install_csr (p_install_site_name okx_party_site_uses_v.name%TYPE,
23186: p_install_site_id okx_party_site_uses_v.id1%TYPE) IS
23187: SELECT id1
23188: FROM okx_party_site_uses_v
23189: WHERE ((party_site_number = p_install_site_name
23190: AND
23191: p_install_site_number IS NOT NULL)
23192: OR

Line 26614: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;

26610: x_cplv_rec cplv_rec_type;
26611: l_kplv_rec kplv_rec_type;
26612: x_kplv_rec kplv_rec_type;
26613:
26614: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;
26615: p_sidv_rec sidv_rec_type;
26616: x_sidv_rec sidv_rec_type;
26617:
26618: CURSOR addon_csr (p_contract_number VARCHAR2,

Line 27290: x_install_site_id okx_party_site_uses_v.id1%TYPE;

27286: x_pmnt_freq_id okx_tuom_v.id1%TYPE;
27287: x_uom_code okx_tuom_v.uom_code%TYPE;
27288: l_mult_factor NUMBER;
27289: l_current_start_date DATE;
27290: x_install_site_id okx_party_site_uses_v.id1%TYPE;
27291: l_rule_create_flag VARCHAR2(1) := 'Y';
27292:
27293: x_inv_item_id_prev NUMBER;
27294: p_inv_item_id_prev NUMBER;

Line 27296: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;

27292:
27293: x_inv_item_id_prev NUMBER;
27294: p_inv_item_id_prev NUMBER;
27295: p_line_type_prev VARCHAR2(35);
27296: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;
27297: l_rg_id NUMBER;
27298:
27299: x_cle_id okc_k_lines_v.id%TYPE;
27300: p_cle_id okc_k_lines_v.id%TYPE;