APPS.OKS_AUTH_UTIL_PVT dependencies on HZ_PARTY_SITES

Line 697: IF(l_install_loc_type='HZ_PARTY_SITES') THEN

693:
694: SELECT INSTALL_LOCATION_TYPE_CODE INTO l_install_loc_type FROM csi_item_instances WHERE instance_id=p_instance_id;
695:
696:
697: IF(l_install_loc_type='HZ_PARTY_SITES') THEN
698:
699: OPEN l_site_name_csr;
700: FETCH l_site_name_csr INTO l_install_site_name;
701: CLOSE l_site_name_csr;

Line 6225: FROM HZ_PARTY_SITES

6221:
6222: CURSOR l_csr_Get_party_sites(p_party_id IN NUMBER)
6223: IS
6224: SELECT party_site_id
6225: FROM HZ_PARTY_SITES
6226: WHERE party_id = p_party_id
6227: AND identifying_address_flag = 'Y';
6228:
6229: -- Get customer account id

Line 6271: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;

6267: l_inv_organization_id NUMBER;
6268: l_dnz_chr_id NUMBER;
6269: l_party_id NUMBER;
6270: l_uom OKC_K_ITEMS.uom_code%TYPE;
6271: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
6272: l_rgp_id OKC_RULE_GROUPS_B.id%TYPE;
6273: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
6274:
6275:

Line 6398: p_instance_rec.location_type_code := 'HZ_PARTY_SITES';

6394: p_instance_rec.active_start_date := '';
6395: p_instance_rec.active_end_date := '';
6396:
6397: p_instance_rec.in_transit_order_line_id := NULL;
6398: p_instance_rec.location_type_code := 'HZ_PARTY_SITES';
6399: p_instance_rec.location_id := NVL(ship_to(p_cle_id), l_party_site_id ) ;
6400:
6401:
6402: