DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on HZ_LOCATIONS

Line 4683: csi.location_id, --hz_locations

4679: CURSOR ib_loc_csr (p_tal_id IN NUMBER) IS
4680: SELECT txlb.kle_id fa_cle_id,
4681: ib_cle.id ib_cle_id,
4682: txlb.tas_id,
4683: csi.location_id, --hz_locations
4684: csi.install_location_id,
4685: --Bug# 3569441
4686: csi.install_location_type_code, --hz_party_sites, hz_locations
4687: csi.instance_number

Line 4686: csi.install_location_type_code, --hz_party_sites, hz_locations

4682: txlb.tas_id,
4683: csi.location_id, --hz_locations
4684: csi.install_location_id,
4685: --Bug# 3569441
4686: csi.install_location_type_code, --hz_party_sites, hz_locations
4687: csi.instance_number
4688: FROM csi_item_instances csi,
4689: csi_instance_statuses csi_inst_sts,
4690: okc_k_items ib_cim,

Line 4748: FROM hz_locations hl,

4744:
4745: --Cursor to get address for error
4746: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
4747: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
4748: FROM hz_locations hl,
4749: hz_party_sites ps
4750: WHERE hl.location_id = ps.location_id
4751: AND ps.party_site_id = pty_site_id;
4752:

Line 4755: FROM hz_locations hl

4751: AND ps.party_site_id = pty_site_id;
4752:
4753: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
4754: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
4755: FROM hz_locations hl
4756: WHERE hl.location_id = loc_id;
4757:
4758: l_address VARCHAR2(80);
4759: --END BUG# 3569441

Line 4834: IF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN

4830: END IF;
4831: CLOSE ib_loc_csr;
4832:
4833: --BUG# 3569441
4834: IF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN
4835: --RAISE ERROR
4836: OKL_API.Set_Message(p_app_name => G_APP_NAME,
4837: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,
4838: p_token1 => G_LOCATION_TYPE_TOKEN,

Line 4843: p_token3_value => 'HZ_LOCATIONS');

4839: p_token1_value => l_location_type_code,
4840: p_token2 => G_LOC_TYPE1_TOKEN,
4841: p_token2_value => 'HZ_PARTY_SITES',
4842: p_token3 => G_LOC_TYPE2_TOKEN,
4843: p_token3_value => 'HZ_LOCATIONS');
4844: x_return_status := OKL_API.G_RET_STS_ERROR;
4845: RAISE OKL_API.G_EXCEPTION_ERROR;
4846:
4847: ELSIF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

Line 4870: ELSIF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN

4866: RAISE OKL_API.G_EXCEPTION_ERROR;
4867: END IF;
4868: CLOSE inst_site_csr;
4869:
4870: ELSIF NVL(l_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN
4871:
4872: --get site use id
4873: OPEN inst_loc_csr(loc_id => l_install_location_id);
4874: FETCH inst_loc_csr INTO l_party_site_use_id;

Line 5254: csi.location_id, --hz_locations

5250: csi.inv_master_organization_id,
5251: csi.unit_of_measure,
5252: csi.quantity,
5253: csi.instance_status_id,
5254: csi.location_id, --hz_locations
5255: csi.install_location_id,
5256: --BUG# 3569441
5257: csi.install_location_type_code --hz_party_sites OR hz_loactions
5258: FROM csi_item_instances csi,

Line 5297: csi.location_id, --hz_locations

5293: csi.inv_master_organization_id,
5294: csi.unit_of_measure,
5295: csi.quantity,
5296: csi.instance_status_id,
5297: csi.location_id, --hz_locations
5298: csi.install_location_id,
5299: --BUG# 3569441
5300: csi.install_location_type_code --hz_party_sites OR hz_locations
5301: FROM csi_item_instances csi,

Line 5300: csi.install_location_type_code --hz_party_sites OR hz_locations

5296: csi.instance_status_id,
5297: csi.location_id, --hz_locations
5298: csi.install_location_id,
5299: --BUG# 3569441
5300: csi.install_location_type_code --hz_party_sites OR hz_locations
5301: FROM csi_item_instances csi,
5302: okc_k_items ib_cim,
5303: okc_k_lines_b ib_cle,
5304: okc_line_styles_b ib_lse,

Line 5349: FROM hz_locations hl,

5345: AND ps.location_id = loc_id;
5346:
5347: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
5348: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
5349: FROM hz_locations hl,
5350: hz_party_sites ps
5351: WHERE hl.location_id = ps.location_id
5352: AND ps.party_site_id = pty_site_id;
5353:

Line 5356: FROM hz_locations hl

5352: AND ps.party_site_id = pty_site_id;
5353:
5354: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
5355: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
5356: FROM hz_locations hl
5357: WHERE hl.location_id = loc_id;
5358:
5359: l_address VARCHAR2(80);
5360: --END BUG# 3569441

Line 5456: IF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN

5452:
5453: --fetch party site use id
5454: l_pty_site_use_id := NULL;
5455: --BUG# 3569441 :
5456: IF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN
5457:
5458: --Raise Error
5459: OKL_API.Set_Message(p_app_name => G_APP_NAME,
5460: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,

Line 5466: p_token3_value => 'HZ_LOCATIONS');

5462: p_token1_value => srl_num_rec2.install_location_type_code,
5463: p_token2 => G_LOC_TYPE1_TOKEN,
5464: p_token2_value => 'HZ_PARTY_SITES',
5465: p_token3 => G_LOC_TYPE2_TOKEN,
5466: p_token3_value => 'HZ_LOCATIONS');
5467: x_return_status := OKL_API.G_RET_STS_ERROR;
5468: RAISE OKL_API.G_EXCEPTION_ERROR;
5469:
5470: ELSIF NVL(srl_num_rec2.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

Line 5493: ELSIF NVL(srl_num_rec2.install_location_type_code, OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN

5489: --l_pty_site_use_id := '-1';
5490: END IF;
5491: CLOSE inst_site_csr;
5492:
5493: ELSIF NVL(srl_num_rec2.install_location_type_code, OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN
5494:
5495: OPEN inst_loc_csr(srl_num_rec2.install_location_id);
5496: FETCH inst_loc_csr INTO l_pty_site_use_id;
5497: IF inst_loc_csr%NOTFOUND THEN

Line 5555: IF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN

5551:
5552: --fetch party site use id
5553: l_pty_site_use_id := NULL;
5554: --BUG# 3569441
5555: IF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_LOCATIONS','HZ_PARTY_SITES') THEN
5556:
5557: --Raise Error
5558: OKL_API.Set_Message(p_app_name => G_APP_NAME,
5559: p_msg_name => G_INVALID_INSTALL_LOC_TYPE,

Line 5565: p_token3_value => 'HZ_LOCATIONS');

5561: p_token1_value => srl_num_rec.install_location_type_code,
5562: p_token2 => G_LOC_TYPE1_TOKEN,
5563: p_token2_value => 'HZ_PARTY_SITES',
5564: p_token3 => G_LOC_TYPE2_TOKEN,
5565: p_token3_value => 'HZ_LOCATIONS');
5566: x_return_status := OKL_API.G_RET_STS_ERROR;
5567: RAISE OKL_API.G_EXCEPTION_ERROR;
5568:
5569: ELSIF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' THEN

Line 5591: ELSIF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN

5587: RAISE OKL_API.G_EXCEPTION_ERROR;
5588: END IF;
5589:
5590: CLOSE inst_site_csr;
5591: ELSIF NVL(srl_num_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_LOCATIONS' THEN
5592:
5593: OPEN inst_loc_csr(srl_num_rec.install_location_id);
5594: FETCH inst_loc_csr INTO l_pty_site_use_id;
5595: IF inst_loc_csr%NOTFOUND THEN