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 1208: X_Last_Updated_By => nvl(fnd_global.user_id,1),

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

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

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,
1210: X_Created_By => nvl(fnd_global.user_id,1),
1211: X_Site_Use_Code => 'BILL_TO',
1212: x_customer_id => p_customer_id,
1213: X_Address_Id => p_address_id,
1214: X_Primary_Flag => 'N',

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

1213: X_Address_Id => p_address_id,
1214: X_Primary_Flag => 'N',
1215: X_Status => 'A',
1216: X_Location => s_location_id,
1217: X_Last_Update_Login => nvl(fnd_global.user_id,1),
1218: X_Contact_Id => null,
1219: X_Bill_To_Site_Use_Id => null,
1220: X_Sic_Code => null,
1221: X_Payment_Term_Id => null,

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

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

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

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,
1330: X_Created_By => nvl(fnd_global.user_id,1),
1331: X_Site_Use_Code => 'SHIP_TO',
1332: x_customer_id => p_customer_id,
1333: X_Address_Id => p_address_id,
1334: X_Primary_Flag => s_primary_flag,

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

1333: X_Address_Id => p_address_id,
1334: X_Primary_Flag => s_primary_flag,
1335: X_Status => s_status,
1336: X_Location => s_location_id,
1337: X_Last_Update_Login => nvl(fnd_global.user_id,1),
1338: X_Contact_Id => null,
1339: -- X_Bill_To_Site_Use_Id => null,
1340: X_Bill_To_Site_Use_Id => b_site_use_id,
1341: X_Sic_Code => null,

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

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,
2002: X_customer_id => p_customer_id,
2003: X_Address_Id => s_cust_acct_site_id,
2004: X_Primary_Flag => p_primary_flag,

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

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,
2242: X_customer_id => p_customer_id,
2243: X_Address_Id => s_cust_acct_site_id,
2244: X_Primary_Flag => p_primary_flag,

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

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,
2479: X_customer_id => p_customer_id,
2480: X_Address_Id => s_cust_acct_site_id,
2481: X_Primary_Flag => p_primary_flag,

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

2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2890: s_State hz_locations.State%TYPE := NULL;
2891: s_Province hz_locations.Province%TYPE := NULL;
2892: s_County hz_locations.County%TYPE := NULL;
2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2895: s_Language hz_locations.Language%TYPE := NULL;
2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;

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

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,
3896: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
3897: X_Status => t_status,
3898: X_Orig_System_Reference => t_orig_system_reference,
3899: X_Country => s_country,
3900: X_Address1 => s_address1,

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

3905: X_Postal_Code => s_postal_code,
3906: X_State => s_state,
3907: X_Province => s_province,
3908: X_County => s_county,
3909: X_Last_Update_Login => nvl(fnd_global.user_id,1),
3910: X_Address_Key => s_address_key,
3911: X_Language => null,--s_language,
3912: X_Attribute_Category => l_attribute_category,
3913: X_Attribute1 => l_attribute1,

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

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,
3996: X_Last_Updated_By => nvl(fnd_global.user_id, 1),
3997: X_Status => t_status,
3998: X_Orig_System_Reference => t_orig_system_reference,
3999: X_Country => s_country,
4000: X_Address1 => s_address1,

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

4005: X_Postal_Code => s_postal_code,
4006: X_State => s_state,
4007: X_Province => s_province,
4008: X_County => s_county,
4009: X_Last_Update_Login => nvl(fnd_global.user_id,1),
4010: X_Address_Key => s_address_key,
4011: X_Language => null,--s_language,
4012: X_Attribute_Category => l_attribute_category,
4013: X_Attribute1 => l_attribute1,

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

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,
4159: X_Created_By => nvl(fnd_global.user_id,1),
4160: X_Status => s_status,
4161: X_Orig_System_Reference => s_orig_system_reference,

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

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,
4159: X_Created_By => nvl(fnd_global.user_id,1),
4160: X_Status => s_status,
4161: X_Orig_System_Reference => s_orig_system_reference,
4162: X_Country => s_country,
4163: X_Address1 => s_address1,

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

4168: X_Postal_Code => s_postal_code,
4169: X_State => s_state,
4170: X_Province => s_province,
4171: X_County => s_county,
4172: X_Last_Update_Login => nvl(fnd_global.user_id,1),
4173: X_Address_Key => s_address_key,
4174: X_Language => null,--s_language,
4175: X_Attribute_Category => null,
4176: X_Attribute1 => null,