DBA Data[Home] [Help]

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on ARH_CSU_PKG

Line 703: arh_csu_pkg.Insert_Row(

699:
700: s_location_id := null;
701:
702: -- Create Bill To site use first for billing purpose.
703: arh_csu_pkg.Insert_Row(
704: X_Site_Use_Id => b_site_use_id,
705: X_Last_Update_Date => sysdate,
706: X_Last_Updated_By => nvl(fnd_global.user_id,1),
707: X_Creation_Date => sysdate,

Line 823: arh_csu_pkg.Insert_Row(

819:
820: s_location_id := null;
821:
822: -- Create Ship To site use to link to the inventory location and link the bill to location to the bill to site.
823: arh_csu_pkg.Insert_Row(
824: X_Site_Use_Id => s_site_use_id,
825: X_Last_Update_Date => sysdate,
826: X_Last_Updated_By => nvl(fnd_global.user_id,1),
827: X_Creation_Date => sysdate,

Line 1495: arh_csu_pkg.Update_Row(

1491: IF l_cust_Bill_to_site_use_csr%FOUND THEN
1492: close l_cust_Bill_to_site_use_csr;
1493:
1494: -- Update site use for ship_to
1495: arh_csu_pkg.Update_Row(
1496: X_Site_Use_Id => l_Bill_to_site_use_id,
1497: X_Last_Update_Date => s_last_update_date,
1498: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
1499: X_Site_Use_Code => s_site_use_code,

Line 1735: arh_csu_pkg.Update_Row(

1731: s_tax_classification;
1732: IF l_cust_site_use_csr%FOUND THEN
1733: close l_cust_site_use_csr;
1734: -- Update site use
1735: arh_csu_pkg.Update_Row(
1736: X_Site_Use_Id => l_site_use_id,
1737: X_Last_Update_Date => s_last_update_date,
1738: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
1739: X_Site_Use_Code => s_site_use_code,

Line 1972: arh_csu_pkg.Update_Row(

1968: IF l_cust_Bill_to_site_use_csr%FOUND THEN
1969: close l_cust_Bill_to_site_use_csr;
1970:
1971: -- Update site use for ship_to
1972: arh_csu_pkg.Update_Row(
1973: X_Site_Use_Id => l_Bill_to_site_use_id,
1974: X_Last_Update_Date => s_last_update_date,
1975: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
1976: X_Site_Use_Code => s_site_use_code,