APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on HZ_CUST_ACCOUNT_SITE_V2PUB

Line 68: p_cust_site_use_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;

64: c_location_id number(15);
65: c1_party_site_id number(15);
66: c3_address_id number(15);
67:
68: p_cust_site_use_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;
69: p_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
70: x_site_use_id NUMBER;
71: x_return_status VARCHAR2(2000);
72: x_msg_count NUMBER;

Line 92: l_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;

88: l_party_site_number varchar2(2000);
89:
90:
91: l_application_id number;
92: l_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
93: l_cust_acct_site_id number;
94: l_profile_value varchar2(100); -- For capturing the value returned from fnd_profile.get
95:
96: v_cnt number;

Line 219: hz_cust_account_site_v2pub.create_cust_acct_site

215: END IF;
216: CLOSE C1;
217:
218:
219: hz_cust_account_site_v2pub.create_cust_acct_site
220: (
221: p_init_msg_list => fnd_api.g_false,
222: p_cust_acct_site_rec => l_cust_acct_site_rec,
223: x_cust_acct_site_id => l_cust_acct_site_id,

Line 240: hz_cust_account_site_v2pub.create_cust_site_use(

236:
237: /* p_cust_site_use_rec.cust_acct_site_id := l_cust_acct_site_id;
238: p_cust_site_use_rec.site_use_code := 'BILL_TO';
239: p_cust_site_use_rec.created_by_module := 'IGI_STP';
240: hz_cust_account_site_v2pub.create_cust_site_use(
241: 'T',
242: p_cust_site_use_rec,
243: p_customer_profile_rec,
244: '',

Line 340: l_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;

336: WHERE PS.PARTY_SITE_ID = CS.PARTY_SITE_ID
337: AND LOC.LOCATION_ID = PS.LOCATION_ID
338: AND CS.rowid = x_rowid;
339:
340: l_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
341: l_cust_acct_site_id number;
342: cursor c_cust_acct is select cust_acct_site_id from hz_cust_acct_sites
343: where rowid = X_rowid;
344:

Line 467: hz_cust_account_site_v2pub.update_cust_acct_site

463: OPEN c_obj_version_cust_acct (l_cust_acct_site_id);
464: FETCH c_obj_version_cust_acct INTO l_object_version_number;
465: CLOSE c_obj_version_cust_acct;
466:
467: hz_cust_account_site_v2pub.update_cust_acct_site
468: (
469: p_init_msg_list => fnd_api.g_false,
470: p_cust_acct_site_rec => l_cust_acct_site_rec,
471: p_object_version_number => l_object_version_number,