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 2487: from hz_party_sites hps,

2483: -------------------------------------------------------------------------
2484: Cursor l_party_site_csr (p_site_use_id in number) is
2485: Select hps.location_id,
2486: hpsu.party_site_id
2487: from hz_party_sites hps,
2488: hz_party_site_uses hpsu
2489: where hps.party_site_id = hpsu.party_site_id
2490: and hpsu.party_site_use_id = p_site_use_id;
2491:

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

2661: If l_party_site_rec.location_id <> l_instance_header_rec.location_id then
2662: l_update_required := 'Y';
2663: l_instance_rec.location_id := l_party_site_rec.location_id;
2664: End If;
2665: Elsif nvl(l_instance_header_rec.location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' then
2666: if l_party_site_rec.party_site_id <> l_instance_header_rec.location_id then
2667: l_update_required := 'Y';
2668: l_instance_rec.location_id := l_party_site_rec.party_site_id;
2669: end If;

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

2673: If l_party_site_rec.location_id <> l_instance_header_rec.install_location_id then
2674: l_update_required := 'Y';
2675: l_instance_rec.install_location_id := l_party_site_rec.location_id;
2676: End If;
2677: Elsif nvl(l_instance_header_rec.install_location_type_code,OKL_API.G_MISS_CHAR) = 'HZ_PARTY_SITES' then
2678: if l_party_site_rec.party_site_id <> l_instance_header_rec.install_location_id then
2679: l_update_required := 'Y';
2680: l_instance_rec.install_location_id := l_party_site_rec.party_site_id;
2681: end If;