APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_CUST_ACCOUNT_SITE_V2PUB

Line 5815: v_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;

5811: ) IS
5812: l_module_name VARCHAR2(100) := 'csp.plsql.csp_ship_to_address_pvt.copy_hz_cust_site';
5813: l_current_org_id NUMBER;
5814: l_msg varchar2(2000);
5815: v_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
5816: x_cust_acct_site_id NUMBER;
5817: l_cust_acct_site_use_id NUMBER;
5818: v_cust_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
5819: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

Line 5818: v_cust_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;

5814: l_msg varchar2(2000);
5815: v_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
5816: x_cust_acct_site_id NUMBER;
5817: l_cust_acct_site_use_id NUMBER;
5818: v_cust_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
5819: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
5820: v_ship_bill_site number;
5821: v_bill_site_id number;
5822: l_existing_bill_to number;

Line 5823: v_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;

5819: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
5820: v_ship_bill_site number;
5821: v_bill_site_id number;
5822: l_existing_bill_to number;
5823: v_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
5824: x_bill_acct_site_id number;
5825: l_bill_acct_site_use_id number;
5826: v_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
5827: v_bill_cust_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

Line 5826: v_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;

5822: l_existing_bill_to number;
5823: v_bill_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
5824: x_bill_acct_site_id number;
5825: l_bill_acct_site_use_id number;
5826: v_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
5827: v_bill_cust_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
5828: x_site_use_id NUMBER;
5829: temp_ship_to_use_id number;
5830:

Line 5880: hz_cust_account_site_v2pub.get_cust_acct_site_rec (

5876: end if;
5877:
5878: -- get cust_site record in src ou
5879: po_moac_utils_pvt.set_org_context(p_src_org_id);
5880: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
5881: p_init_msg_list => FND_API.G_TRUE,
5882: p_cust_acct_site_id => p_cust_site_id,
5883: x_cust_acct_site_rec => v_cust_acct_site_rec,
5884: x_return_status => x_return_status,

Line 5915: hz_cust_account_site_v2pub.create_cust_acct_site (

5911: v_cust_acct_site_rec.org_id := p_dest_org_id;
5912:
5913: -- now create same site in source ou
5914: po_moac_utils_pvt.set_org_context(p_dest_org_id);
5915: hz_cust_account_site_v2pub.create_cust_acct_site (
5916: p_init_msg_list => FND_API.G_TRUE,
5917: p_cust_acct_site_rec => v_cust_acct_site_rec,
5918: x_cust_acct_site_id => x_cust_acct_site_id,
5919: x_return_status => x_return_status,

Line 5949: hz_cust_account_site_v2pub.get_cust_site_use_rec (

5945: FETCH get_cust_acct_site_uses into l_cust_acct_site_use_id;
5946: EXIT WHEN get_cust_acct_site_uses%NOTFOUND;
5947:
5948: po_moac_utils_pvt.set_org_context(p_src_org_id);
5949: hz_cust_account_site_v2pub.get_cust_site_use_rec (
5950: p_init_msg_list => FND_API.G_TRUE,
5951: p_site_use_id => l_cust_acct_site_use_id,
5952: x_cust_site_use_rec => v_cust_site_use_rec,
5953: x_customer_profile_rec => v_customer_profile_rec,

Line 6007: hz_cust_account_site_v2pub.get_cust_acct_site_rec (

6003: if l_existing_bill_to is null then
6004:
6005: -- do lots of stuff here
6006: po_moac_utils_pvt.set_org_context(p_src_org_id);
6007: hz_cust_account_site_v2pub.get_cust_acct_site_rec (
6008: p_init_msg_list => FND_API.G_TRUE,
6009: p_cust_acct_site_id => v_bill_site_id,
6010: x_cust_acct_site_rec => v_bill_acct_site_rec,
6011: x_return_status => x_return_status,

Line 6042: hz_cust_account_site_v2pub.create_cust_acct_site (

6038: v_bill_acct_site_rec.org_id := p_dest_org_id;
6039:
6040: -- now create same site in source ou
6041: po_moac_utils_pvt.set_org_context(p_dest_org_id);
6042: hz_cust_account_site_v2pub.create_cust_acct_site (
6043: p_init_msg_list => FND_API.G_TRUE,
6044: p_cust_acct_site_rec => v_bill_acct_site_rec,
6045: x_cust_acct_site_id => x_bill_acct_site_id,
6046: x_return_status => x_return_status,

Line 6072: hz_cust_account_site_v2pub.get_cust_site_use_rec (

6068:
6069: l_bill_acct_site_use_id := v_ship_bill_site;
6070:
6071: po_moac_utils_pvt.set_org_context(p_src_org_id);
6072: hz_cust_account_site_v2pub.get_cust_site_use_rec (
6073: p_init_msg_list => FND_API.G_TRUE,
6074: p_site_use_id => l_bill_acct_site_use_id,
6075: x_cust_site_use_rec => v_bill_site_use_rec,
6076: x_customer_profile_rec => v_bill_cust_profile_rec,

Line 6107: hz_cust_account_site_v2pub.create_cust_site_use (

6103: v_bill_site_use_rec.org_id := p_dest_org_id;
6104: v_bill_site_use_rec.cust_acct_site_id := x_bill_acct_site_id;
6105:
6106: po_moac_utils_pvt.set_org_context(p_dest_org_id);
6107: hz_cust_account_site_v2pub.create_cust_site_use (
6108: p_init_msg_list => FND_API.G_TRUE,
6109: p_cust_site_use_rec => v_bill_site_use_rec,
6110: p_customer_profile_rec => v_bill_cust_profile_rec,
6111: p_create_profile => FND_API.G_FALSE,

Line 6157: hz_cust_account_site_v2pub.create_cust_site_use (

6153: || ', v_cust_site_use_rec.bill_to_site_use_id=' || v_cust_site_use_rec.bill_to_site_use_id);
6154: end if;
6155:
6156: po_moac_utils_pvt.set_org_context(p_dest_org_id);
6157: hz_cust_account_site_v2pub.create_cust_site_use (
6158: p_init_msg_list => FND_API.G_TRUE,
6159: p_cust_site_use_rec => v_cust_site_use_rec,
6160: p_customer_profile_rec => v_customer_profile_rec,
6161: p_create_profile => FND_API.G_FALSE,