DBA Data[Home] [Help]

APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on FND_GLOBAL

Line 118: p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 1),

114: p_RESOURCE_ID => p_resource_id,
115: p_CUSTOMER_ID => p_customer_id,
116: p_CREATED_BY => l_created_by,
117: p_CREATION_DATE => l_creation_date,
118: p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 1),
119: p_LAST_UPDATE_DATE => sysdate,
120: p_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, 1),
121: p_ATTRIBUTE_CATEGORY => l_attribute_category,
122: p_ATTRIBUTE1 => l_attribute1,

Line 120: p_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, 1),

116: p_CREATED_BY => l_created_by,
117: p_CREATION_DATE => l_creation_date,
118: p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 1),
119: p_LAST_UPDATE_DATE => sysdate,
120: p_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, 1),
121: p_ATTRIBUTE_CATEGORY => l_attribute_category,
122: p_ATTRIBUTE1 => l_attribute1,
123: p_ATTRIBUTE2 => l_attribute2,
124: p_ATTRIBUTE3 => l_attribute3,

Line 145: p_CREATED_BY => nvl(fnd_global.user_id, 1),

141: px_RS_CUST_RELATION_ID => l_rs_cust_relation_id,
142: p_RESOURCE_TYPE => p_resource_type,
143: p_RESOURCE_ID => p_resource_id,
144: p_CUSTOMER_ID => p_customer_id,
145: p_CREATED_BY => nvl(fnd_global.user_id, 1),
146: p_CREATION_DATE => sysdate,
147: p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 1),
148: p_LAST_UPDATE_DATE => sysdate,
149: p_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, 1),

Line 147: p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 1),

143: p_RESOURCE_ID => p_resource_id,
144: p_CUSTOMER_ID => p_customer_id,
145: p_CREATED_BY => nvl(fnd_global.user_id, 1),
146: p_CREATION_DATE => sysdate,
147: p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 1),
148: p_LAST_UPDATE_DATE => sysdate,
149: p_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, 1),
150: p_ATTRIBUTE_CATEGORY => NULL,
151: p_ATTRIBUTE1 => NULL,

Line 149: p_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, 1),

145: p_CREATED_BY => nvl(fnd_global.user_id, 1),
146: p_CREATION_DATE => sysdate,
147: p_LAST_UPDATED_BY => nvl(fnd_global.user_id, 1),
148: p_LAST_UPDATE_DATE => sysdate,
149: p_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, 1),
150: p_ATTRIBUTE_CATEGORY => NULL,
151: p_ATTRIBUTE1 => NULL,
152: p_ATTRIBUTE2 => NULL,
153: p_ATTRIBUTE3 => NULL,

Line 706: X_Last_Updated_By => nvl(fnd_global.user_id,1),

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,
708: X_Created_By => nvl(fnd_global.user_id,1),
709: X_Site_Use_Code => 'BILL_TO',
710: x_customer_id => p_customer_id,

Line 708: X_Created_By => nvl(fnd_global.user_id,1),

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,
708: X_Created_By => nvl(fnd_global.user_id,1),
709: X_Site_Use_Code => 'BILL_TO',
710: x_customer_id => p_customer_id,
711: X_Address_Id => p_address_id,
712: X_Primary_Flag => 'N',

Line 715: X_Last_Update_Login => nvl(fnd_global.user_id,1),

711: X_Address_Id => p_address_id,
712: X_Primary_Flag => 'N',
713: X_Status => 'A',
714: X_Location => s_location_id,
715: X_Last_Update_Login => nvl(fnd_global.user_id,1),
716: X_Contact_Id => null,
717: X_Bill_To_Site_Use_Id => null,
718: X_Sic_Code => null,
719: X_Payment_Term_Id => null,

Line 826: X_Last_Updated_By => nvl(fnd_global.user_id,1),

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,
828: X_Created_By => nvl(fnd_global.user_id,1),
829: X_Site_Use_Code => 'SHIP_TO',
830: x_customer_id => p_customer_id,

Line 828: X_Created_By => nvl(fnd_global.user_id,1),

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,
828: X_Created_By => nvl(fnd_global.user_id,1),
829: X_Site_Use_Code => 'SHIP_TO',
830: x_customer_id => p_customer_id,
831: X_Address_Id => p_address_id,
832: X_Primary_Flag => s_primary_flag,

Line 835: X_Last_Update_Login => nvl(fnd_global.user_id,1),

831: X_Address_Id => p_address_id,
832: X_Primary_Flag => s_primary_flag,
833: X_Status => s_status,
834: X_Location => s_location_id,
835: X_Last_Update_Login => nvl(fnd_global.user_id,1),
836: X_Contact_Id => null,
837: -- X_Bill_To_Site_Use_Id => null,
838: X_Bill_To_Site_Use_Id => b_site_use_id,
839: X_Sic_Code => null,

Line 1498: X_Last_Updated_By => nvl(fnd_global.user_id, 1),

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,
1500: X_customer_id => p_customer_id,
1501: X_Address_Id => s_cust_acct_site_id,
1502: X_Primary_Flag => p_primary_flag,

Line 1738: X_Last_Updated_By => nvl(fnd_global.user_id, 1),

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,
1740: X_customer_id => p_customer_id,
1741: X_Address_Id => s_cust_acct_site_id,
1742: X_Primary_Flag => p_primary_flag,

Line 1975: X_Last_Updated_By => nvl(fnd_global.user_id, 1),

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,
1977: X_customer_id => p_customer_id,
1978: X_Address_Id => s_cust_acct_site_id,
1979: X_Primary_Flag => p_primary_flag,

Line 2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);

2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2384: s_State hz_locations.State%TYPE := NULL;
2385: s_Province hz_locations.Province%TYPE := NULL;
2386: s_County hz_locations.County%TYPE := NULL;
2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2389: s_Language hz_locations.Language%TYPE := NULL;
2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;

Line 3324: X_Last_Updated_By => nvl(fnd_global.user_id, 1),

3320: X_Address_Id => t_cust_acct_site_id,
3321: X_Last_Update_Date => t_last_update_date,
3322: X_party_site_Last_Update_Date => t_party_site_last_update_date,
3323: X_loc_Last_Update_Date => t_loc_last_update_date,
3324: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
3325: X_Status => t_status,
3326: X_Orig_System_Reference => t_orig_system_reference,
3327: X_Country => s_country,
3328: X_Address1 => s_address1,

Line 3337: X_Last_Update_Login => nvl(fnd_global.user_id,1),

3333: X_Postal_Code => s_postal_code,
3334: X_State => s_state,
3335: X_Province => s_province,
3336: X_County => s_county,
3337: X_Last_Update_Login => nvl(fnd_global.user_id,1),
3338: X_Address_Key => s_address_key,
3339: X_Language => null,--s_language,
3340: X_Attribute_Category => null,
3341: X_Attribute1 => null,

Line 3424: X_Last_Updated_By => nvl(fnd_global.user_id, 1),

3420: X_Address_Id => t_cust_acct_site_id,
3421: X_Last_Update_Date => t_last_update_date,
3422: X_party_site_Last_Update_Date => t_party_site_last_update_date,
3423: X_loc_Last_Update_Date => t_loc_last_update_date,
3424: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
3425: X_Status => t_status,
3426: X_Orig_System_Reference => t_orig_system_reference,
3427: X_Country => s_country,
3428: X_Address1 => s_address1,

Line 3437: X_Last_Update_Login => nvl(fnd_global.user_id,1),

3433: X_Postal_Code => s_postal_code,
3434: X_State => s_state,
3435: X_Province => s_province,
3436: X_County => s_county,
3437: X_Last_Update_Login => nvl(fnd_global.user_id,1),
3438: X_Address_Key => s_address_key,
3439: X_Language => null,--s_language,
3440: X_Attribute_Category => null,
3441: X_Attribute1 => null,

Line 3576: X_Last_Updated_By => nvl(fnd_global.user_id,1),

3572: -- create sites
3573: arh_addr_pkg.insert_row(
3574: X_Address_Id => s_cust_acct_site_id,
3575: X_Last_Update_Date => sysdate,
3576: X_Last_Updated_By => nvl(fnd_global.user_id,1),
3577: X_Creation_Date => sysdate,
3578: X_Created_By => nvl(fnd_global.user_id,1),
3579: X_Status => s_status,
3580: X_Orig_System_Reference => s_orig_system_reference,

Line 3578: X_Created_By => nvl(fnd_global.user_id,1),

3574: X_Address_Id => s_cust_acct_site_id,
3575: X_Last_Update_Date => sysdate,
3576: X_Last_Updated_By => nvl(fnd_global.user_id,1),
3577: X_Creation_Date => sysdate,
3578: X_Created_By => nvl(fnd_global.user_id,1),
3579: X_Status => s_status,
3580: X_Orig_System_Reference => s_orig_system_reference,
3581: X_Country => s_country,
3582: X_Address1 => s_address1,

Line 3591: X_Last_Update_Login => nvl(fnd_global.user_id,1),

3587: X_Postal_Code => s_postal_code,
3588: X_State => s_state,
3589: X_Province => s_province,
3590: X_County => s_county,
3591: X_Last_Update_Login => nvl(fnd_global.user_id,1),
3592: X_Address_Key => s_address_key,
3593: X_Language => null,--s_language,
3594: X_Attribute_Category => null,
3595: X_Attribute1 => null,