APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on HZ_PARTY_SITE_V2PUB

Line 86: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;

82: l_loc_out_id number;
83:
84: -- Bug 2037659 Fix
85:
86: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
87: l_party_site_id number;
88: l_party_site_number varchar2(2000);
89:
90:

Line 199: hz_party_site_v2pub.create_party_site

195:
196: l_party_site_rec.status := X_status;
197: l_party_site_rec.created_by_module := 'IGI_STP';
198:
199: hz_party_site_v2pub.create_party_site
200: (
201: p_init_msg_list => fnd_api.g_true,
202: p_party_site_rec => l_party_site_rec,
203: x_party_site_id => l_party_site_id,

Line 334: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;

330: AND LOC.LOCATION_ID = PS.LOCATION_ID
331: AND CS.rowid = x_rowid;
332:
333: l_party_site_id number;
334: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
335: cursor c_party is select PS.party_site_id from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES CS
336: WHERE PS.PARTY_SITE_ID = CS.PARTY_SITE_ID
337: AND LOC.LOCATION_ID = PS.LOCATION_ID
338: AND CS.rowid = x_rowid;

Line 449: hz_party_site_v2pub.update_party_site

445: OPEN c_obj_version_site (l_party_site_id);
446: FETCH c_obj_version_site INTO l_object_version_number;
447: CLOSE c_obj_version_site;
448:
449: hz_party_site_v2pub.update_party_site
450: (
451: p_init_msg_list => fnd_api.g_false,
452: p_party_site_rec => l_party_site_rec,
453: p_object_version_number => l_object_version_number,

Line 871: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;

867: where (location_id = p_location_id);
868:
869:
870:
871: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
872: cursor c_party is select PS.party_site_id from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AP_SUPPLIER_SITES_ALL AP
873: WHERE PS.PARTY_SITE_ID = AP.PARTY_SITE_ID
874: AND AP.vendor_site_id = X_vendor_site_id
875: AND AP.ORG_ID = X_org_id;

Line 955: hz_party_site_v2pub.update_party_site

951: FETCH c_obj_version_site INTO l_object_version_number;
952: CLOSE c_obj_version_site;
953:
954:
955: hz_party_site_v2pub.update_party_site
956: (
957: p_init_msg_list => fnd_api.g_false,
958: p_party_site_rec => l_party_site_rec,
959: p_object_version_number => l_object_version_number,