APPS.OKL_ACTIVATE_IB_PVT dependencies on HZ_PARTY_SITES

Line 23: G_INSTALL_LOC_TYPE_CODE Varchar2(30) := 'HZ_PARTY_SITES';

19: G_APPROVED_STS_CODE VARCHAR2(100) := 'APPROVED';
20: G_LEASE_SCS_CODE VARCHAR2(30) := 'LEASE';
21: G_MFG_SERIAL_NUMBER_FLAG Varchar2(1) := 'N';
22: G_LOC_TYPE_CODE Varchar2(30) := 'HZ_LOCATIONS';
23: G_INSTALL_LOC_TYPE_CODE Varchar2(30) := 'HZ_PARTY_SITES';
24: G_UOM_CODE Varchar2(10) := 'Ea';
25: G_IB_BKNG_TXN_TYPE Varchar2(30) := 'OKL_BOOK';
26: G_CUST_ACCT_RULE Varchar2(30) := 'CAN';
27: G_CUST_ACCT_RULE_GROUP Varchar2(30) := 'LACAN';

Line 1496: FROM HZ_PARTY_SITE_USES HPSU, HZ_PARTY_SITES HPS

1492: --cursor to fetch party location id
1493: CURSOR instance_loc_csr (p_site_use_id1 IN VARCHAR2) is
1494: SELECT HPS.location_id,
1495: HPS.party_site_id
1496: FROM HZ_PARTY_SITE_USES HPSU, HZ_PARTY_SITES HPS
1497: WHERE HPS.party_site_id = HPSU.party_site_id
1498: AND HPSU.party_site_use_id = p_site_use_id1;
1499:
1500: --rkuttiya added for IB Link User story 22-jan-2008 sprint 7

Line 2514: from hz_party_sites hps,

2510: -------------------------------------------------------------------------
2511: Cursor l_party_site_csr (p_site_use_id in number) is
2512: Select hps.location_id,
2513: hpsu.party_site_id
2514: from hz_party_sites hps,
2515: hz_party_site_uses hpsu
2516: where hps.party_site_id = hpsu.party_site_id
2517: and hpsu.party_site_use_id = p_site_use_id;
2518:

Line 2692: Elsif nvl(l_instance_header_rec.location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' then

2688: If l_party_site_rec.location_id <> l_instance_header_rec.location_id then
2689: l_update_required := 'Y';
2690: l_instance_rec.location_id := l_party_site_rec.location_id;
2691: End If;
2692: Elsif nvl(l_instance_header_rec.location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' then
2693: if l_party_site_rec.party_site_id <> l_instance_header_rec.location_id then
2694: l_update_required := 'Y';
2695: l_instance_rec.location_id := l_party_site_rec.party_site_id;
2696: end If;

Line 2704: Elsif nvl(l_instance_header_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' then

2700: If l_party_site_rec.location_id <> l_instance_header_rec.install_location_id then
2701: l_update_required := 'Y';
2702: l_instance_rec.install_location_id := l_party_site_rec.location_id;
2703: End If;
2704: Elsif nvl(l_instance_header_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' then
2705: if l_party_site_rec.party_site_id <> l_instance_header_rec.install_location_id then
2706: l_update_required := 'Y';
2707: l_instance_rec.install_location_id := l_party_site_rec.party_site_id;
2708: end If;