APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on HZ_LOCATION_V2PUB

Line 77: l_location_rec hz_location_v2pub.location_rec_type;

73: x_msg_data VARCHAR2(2000);
74:
75: -- Bug 2037659 Fix
76:
77: l_location_rec hz_location_v2pub.location_rec_type;
78: l_return_status varchar2(3);
79: l_msg_count number;
80: l_msg_data varchar2(2000);
81: l_loc_id number;

Line 132: hz_location_v2pub.create_location

128: l_cust_acct_site_rec.ece_tp_location_code := X_ece_tp_location_code;
129: l_cust_acct_site_rec.created_by_module := 'IGI_STP';
130:
131:
132: hz_location_v2pub.create_location
133: (
134: p_init_msg_list => fnd_api.g_false,
135: p_location_rec => l_location_rec,
136: x_location_id => l_loc_id,

Line 321: l_location_rec hz_location_v2pub.location_rec_type;

317: X_stp_site_inactive_date DATE,
318: X_last_update_login NUMBER,
319: X_last_update_date DATE,
320: X_last_updated_by NUMBER) IS
321: l_location_rec hz_location_v2pub.location_rec_type;
322: l_return_status varchar2(3);
323: l_msg_count number;
324: l_msg_data varchar2(2000);
325:

Line 422: hz_location_v2pub.update_location

418:
419:
420:
421:
422: hz_location_v2pub.update_location
423: (
424: p_init_msg_list => fnd_api.g_false,
425: p_location_rec => l_location_rec,
426: p_object_version_number => l_object_version_number,

Line 855: l_location_rec hz_location_v2pub.location_rec_type;

851: l_party_site_id HZ_PARTY_SITES.party_site_id %TYPE;
852: l_location_id HZ_LOCATIONS.location_id%type;
853:
854:
855: l_location_rec hz_location_v2pub.location_rec_type;
856: l_object_version_number number;
857: cursor c_loc is select LOC.LOCATION_ID from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC,AP_SUPPLIER_SITES_ALL AP
858: WHERE PS.PARTY_SITE_ID = AP.PARTY_SITE_ID
859: AND LOC.LOCATION_ID = PS.LOCATION_ID

Line 928: hz_location_v2pub.update_location

924: FETCH c_obj_version_loc INTO l_object_version_number;
925: CLOSE c_obj_version_loc;
926:
927:
928: hz_location_v2pub.update_location
929: (
930: 'T',
931: l_location_rec,
932: l_object_version_number,