DBA Data[Home] [Help]

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on ARH_ADDR_PKG

Line 3891: arh_addr_pkg.update_row (

3887: select last_update_date into t_last_update_date from hz_cust_acct_sites where CUST_ACCT_SITE_ID = t_cust_acct_site_id;
3888:
3889:
3890: -- Update the site location and related tables.
3891: arh_addr_pkg.update_row (
3892: X_Address_Id => t_cust_acct_site_id,
3893: X_Last_Update_Date => t_last_update_date,
3894: X_party_site_Last_Update_Date => t_party_site_last_update_date,
3895: X_loc_Last_Update_Date => t_loc_last_update_date,

Line 3991: arh_addr_pkg.update_row (

3987: FND_MSG_PUB.ADD;*/
3988: RAISE EXCP_USER_DEFINED;
3989: END IF;
3990: ELSE
3991: arh_addr_pkg.update_row (
3992: X_Address_Id => t_cust_acct_site_id,
3993: X_Last_Update_Date => t_last_update_date,
3994: X_party_site_Last_Update_Date => t_party_site_last_update_date,
3995: X_loc_Last_Update_Date => t_loc_last_update_date,

Line 4154: arh_addr_pkg.insert_row(

4150:
4151: mo_global.set_policy_context('S', l_org_id);
4152:
4153: -- create sites
4154: arh_addr_pkg.insert_row(
4155: X_Address_Id => s_cust_acct_site_id,
4156: X_Last_Update_Date => sysdate,
4157: X_Last_Updated_By => nvl(fnd_global.user_id,1),
4158: X_Creation_Date => sysdate,