APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on ARH_CSU_PKG

Line 1205: arh_csu_pkg.Insert_Row(

1201: close cr_get_primary_bill_to_id;
1202: end if;
1203:
1204: if b_site_use_id is null then
1205: arh_csu_pkg.Insert_Row(
1206: X_Site_Use_Id => b_site_use_id,
1207: X_Last_Update_Date => sysdate,
1208: X_Last_Updated_By => nvl(fnd_global.user_id,1),
1209: X_Creation_Date => sysdate,

Line 1325: arh_csu_pkg.Insert_Row(

1321: END IF;
1322: s_location_id := null;
1323:
1324: -- Create Ship To site use to link to the inventory location and link the bill to location to the bill to site.
1325: arh_csu_pkg.Insert_Row(
1326: X_Site_Use_Id => s_site_use_id,
1327: X_Last_Update_Date => sysdate,
1328: X_Last_Updated_By => nvl(fnd_global.user_id,1),
1329: X_Creation_Date => sysdate,

Line 1997: arh_csu_pkg.Update_Row(

1993: IF l_cust_Bill_to_site_use_csr%FOUND THEN
1994: close l_cust_Bill_to_site_use_csr;
1995:
1996: -- Update site use for ship_to
1997: arh_csu_pkg.Update_Row(
1998: X_Site_Use_Id => l_Bill_to_site_use_id,
1999: X_Last_Update_Date => s_last_update_date,
2000: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
2001: X_Site_Use_Code => s_site_use_code,

Line 2237: arh_csu_pkg.Update_Row(

2233: s_tax_classification;
2234: IF l_cust_site_use_csr%FOUND THEN
2235: close l_cust_site_use_csr;
2236: -- Update site use
2237: arh_csu_pkg.Update_Row(
2238: X_Site_Use_Id => l_site_use_id,
2239: X_Last_Update_Date => s_last_update_date,
2240: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
2241: X_Site_Use_Code => s_site_use_code,

Line 2474: arh_csu_pkg.Update_Row(

2470: IF l_cust_Bill_to_site_use_csr%FOUND THEN
2471: close l_cust_Bill_to_site_use_csr;
2472:
2473: -- Update site use for ship_to
2474: arh_csu_pkg.Update_Row(
2475: X_Site_Use_Id => l_Bill_to_site_use_id,
2476: X_Last_Update_Date => s_last_update_date,
2477: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
2478: X_Site_Use_Code => s_site_use_code,