DBA Data[Home] [Help]

APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on FND_GLOBAL

Line 28: G_Last_Update_Login NUMBER(15) := FND_GLOBAL.LOGIN_ID;

24: G_Itc_Recapture_Id fa_retirements.Itc_Recapture_Id%TYPE;
25: G_Current_Units fa_asset_history.Units%TYPE;
26: G_Asset_Number fa_additions_b.asset_number%TYPE;
27: G_period_counter_fully_retired Number;
28: G_Last_Update_Login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
29: G_Precision NUMBER;
30: G_Ext_Precision NUMBER;
31: G_Min_Acct_Unit NUMBER;
32: G_Today_Datetime DATE := SYSDATE;

Line 42: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;

38: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
39: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
40: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;
41: G_Recursion_Level VARCHAR2(1);
42: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;
43: G_Creation_Date DATE := SYSDATE;
44: G_Varchar2_Dummy VARCHAR2(80);
45: G_Number_Dummy NUMBER(15);
46: G_Date_Dummy Date;

Line 1239: last_updated_by = fnd_global.user_id,

1235: SET review_status = 'POSTED',
1236: -- bugfix 2442439 retirement_id = lv_ret_id
1237: retirement_id = l_asset_retire_rec.retirement_id,
1238: last_update_date = sysdate,
1239: last_updated_by = fnd_global.user_id,
1240: last_update_login = fnd_global.login_id
1241: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1242:
1243: Commit;

Line 1240: last_update_login = fnd_global.login_id

1236: -- bugfix 2442439 retirement_id = lv_ret_id
1237: retirement_id = l_asset_retire_rec.retirement_id,
1238: last_update_date = sysdate,
1239: last_updated_by = fnd_global.user_id,
1240: last_update_login = fnd_global.login_id
1241: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1242:
1243: Commit;
1244:

Line 1266: last_updated_by = fnd_global.user_id,

1262:
1263: UPDATE fa_mass_Ext_retirements
1264: SET review_status = 'ERROR',
1265: last_update_date = sysdate,
1266: last_updated_by = fnd_global.user_id,
1267: last_update_login = fnd_global.login_id
1268: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1269:
1270: -- non-fatal

Line 1267: last_update_login = fnd_global.login_id

1263: UPDATE fa_mass_Ext_retirements
1264: SET review_status = 'ERROR',
1265: last_update_date = sysdate,
1266: last_updated_by = fnd_global.user_id,
1267: last_update_login = fnd_global.login_id
1268: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1269:
1270: -- non-fatal
1271: write_message(

Line 1299: last_updated_by = fnd_global.user_id,

1295:
1296: UPDATE fa_mass_Ext_retirements
1297: SET review_status = 'ERROR',
1298: last_update_date = sysdate,
1299: last_updated_by = fnd_global.user_id,
1300: last_update_login = fnd_global.login_id
1301: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1302:
1303: if lv_message = '' then

Line 1300: last_update_login = fnd_global.login_id

1296: UPDATE fa_mass_Ext_retirements
1297: SET review_status = 'ERROR',
1298: last_update_date = sysdate,
1299: last_updated_by = fnd_global.user_id,
1300: last_update_login = fnd_global.login_id
1301: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1302:
1303: if lv_message = '' then
1304: write_message(

Line 1342: last_updated_by = fnd_global.user_id,

1338:
1339: UPDATE fa_mass_Ext_retirements
1340: SET review_status = 'ERROR',
1341: last_update_date = sysdate,
1342: last_updated_by = fnd_global.user_id,
1343: last_update_login = fnd_global.login_id
1344: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1345:
1346: write_message(

Line 1343: last_update_login = fnd_global.login_id

1339: UPDATE fa_mass_Ext_retirements
1340: SET review_status = 'ERROR',
1341: last_update_date = sysdate,
1342: last_updated_by = fnd_global.user_id,
1343: last_update_login = fnd_global.login_id
1344: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1345:
1346: write_message(
1347: p_asset_number => g_asset_number,

Line 1373: last_updated_by = fnd_global.user_id,

1369:
1370: UPDATE fa_mass_Ext_retirements
1371: SET review_status = 'ERROR',
1372: last_update_date = sysdate,
1373: last_updated_by = fnd_global.user_id,
1374: last_update_login = fnd_global.login_id
1375: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1376:
1377: write_message(

Line 1374: last_update_login = fnd_global.login_id

1370: UPDATE fa_mass_Ext_retirements
1371: SET review_status = 'ERROR',
1372: last_update_date = sysdate,
1373: last_updated_by = fnd_global.user_id,
1374: last_update_login = fnd_global.login_id
1375: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1376:
1377: write_message(
1378: p_asset_number => g_asset_number,

Line 1439: last_updated_by = fnd_global.user_id,

1435:
1436: UPDATE fa_mass_Ext_retirements
1437: SET review_status = 'ERROR',
1438: last_update_date = sysdate,
1439: last_updated_by = fnd_global.user_id,
1440: last_update_login = fnd_global.login_id
1441: WHERE batch_name = nvl(px_batch_name,batch_name)
1442: AND book_type_code = p_book_type_code;
1443:

Line 1440: last_update_login = fnd_global.login_id

1436: UPDATE fa_mass_Ext_retirements
1437: SET review_status = 'ERROR',
1438: last_update_date = sysdate,
1439: last_updated_by = fnd_global.user_id,
1440: last_update_login = fnd_global.login_id
1441: WHERE batch_name = nvl(px_batch_name,batch_name)
1442: AND book_type_code = p_book_type_code;
1443:
1444: write_message(