DBA Data[Home] [Help]

APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on FND_GLOBAL

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

30: G_Recapture_Reserve_Flag fa_retirements.recapture_reserve_flag%Type;
31: G_Limit_Proceeds_Flag fa_retirements.limit_proceeds_flag%Type;
32: G_Terminal_Gain_Loss fa_retirements.terminal_gain_loss%Type;
33: /* Bug 8483118(R12) and 8206076(11i) - End */
34: G_Last_Update_Login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
35: G_Precision NUMBER;
36: G_Ext_Precision NUMBER;
37: G_Min_Acct_Unit NUMBER;
38: G_Today_Datetime DATE := SYSDATE;

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

44: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
45: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
46: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;
47: G_Recursion_Level VARCHAR2(1);
48: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;
49: G_Creation_Date DATE := SYSDATE;
50: G_Varchar2_Dummy VARCHAR2(80);
51: G_Number_Dummy NUMBER(15);
52: G_Date_Dummy Date;

Line 1296: last_updated_by = fnd_global.user_id,

1292: SET review_status = 'POSTED',
1293: -- bugfix 2442439 retirement_id = lv_ret_id
1294: retirement_id = l_asset_retire_rec.retirement_id,
1295: last_update_date = sysdate,
1296: last_updated_by = fnd_global.user_id,
1297: last_update_login = fnd_global.login_id
1298: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1299:
1300: Commit;

Line 1297: last_update_login = fnd_global.login_id

1293: -- bugfix 2442439 retirement_id = lv_ret_id
1294: retirement_id = l_asset_retire_rec.retirement_id,
1295: last_update_date = sysdate,
1296: last_updated_by = fnd_global.user_id,
1297: last_update_login = fnd_global.login_id
1298: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1299:
1300: Commit;
1301:

Line 1323: last_updated_by = fnd_global.user_id,

1319:
1320: UPDATE fa_mass_Ext_retirements
1321: SET review_status = 'ERROR',
1322: last_update_date = sysdate,
1323: last_updated_by = fnd_global.user_id,
1324: last_update_login = fnd_global.login_id
1325: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1326:
1327: -- non-fatal

Line 1324: last_update_login = fnd_global.login_id

1320: UPDATE fa_mass_Ext_retirements
1321: SET review_status = 'ERROR',
1322: last_update_date = sysdate,
1323: last_updated_by = fnd_global.user_id,
1324: last_update_login = fnd_global.login_id
1325: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1326:
1327: -- non-fatal
1328: write_message(

Line 1355: last_updated_by = fnd_global.user_id,

1351:
1352: UPDATE fa_mass_Ext_retirements
1353: SET review_status = 'ERROR',
1354: last_update_date = sysdate,
1355: last_updated_by = fnd_global.user_id,
1356: last_update_login = fnd_global.login_id
1357: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1358:
1359:

Line 1356: last_update_login = fnd_global.login_id

1352: UPDATE fa_mass_Ext_retirements
1353: SET review_status = 'ERROR',
1354: last_update_date = sysdate,
1355: last_updated_by = fnd_global.user_id,
1356: last_update_login = fnd_global.login_id
1357: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1358:
1359:
1360: if lv_message = '' then

Line 1398: last_updated_by = fnd_global.user_id,

1394:
1395: UPDATE fa_mass_Ext_retirements
1396: SET review_status = 'ERROR',
1397: last_update_date = sysdate,
1398: last_updated_by = fnd_global.user_id,
1399: last_update_login = fnd_global.login_id
1400: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1401:
1402: write_message(

Line 1399: last_update_login = fnd_global.login_id

1395: UPDATE fa_mass_Ext_retirements
1396: SET review_status = 'ERROR',
1397: last_update_date = sysdate,
1398: last_updated_by = fnd_global.user_id,
1399: last_update_login = fnd_global.login_id
1400: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1401:
1402: write_message(
1403: p_asset_number => g_asset_number,

Line 1428: last_updated_by = fnd_global.user_id,

1424:
1425: UPDATE fa_mass_Ext_retirements
1426: SET review_status = 'ERROR',
1427: last_update_date = sysdate,
1428: last_updated_by = fnd_global.user_id,
1429: last_update_login = fnd_global.login_id
1430: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1431:
1432: write_message(

Line 1429: last_update_login = fnd_global.login_id

1425: UPDATE fa_mass_Ext_retirements
1426: SET review_status = 'ERROR',
1427: last_update_date = sysdate,
1428: last_updated_by = fnd_global.user_id,
1429: last_update_login = fnd_global.login_id
1430: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1431:
1432: write_message(
1433: p_asset_number => g_asset_number,

Line 1494: last_updated_by = fnd_global.user_id,

1490:
1491: UPDATE fa_mass_Ext_retirements
1492: SET review_status = 'ERROR',
1493: last_update_date = sysdate,
1494: last_updated_by = fnd_global.user_id,
1495: last_update_login = fnd_global.login_id
1496: WHERE batch_name = nvl(px_batch_name,batch_name)
1497: AND book_type_code = p_book_type_code;
1498:

Line 1495: last_update_login = fnd_global.login_id

1491: UPDATE fa_mass_Ext_retirements
1492: SET review_status = 'ERROR',
1493: last_update_date = sysdate,
1494: last_updated_by = fnd_global.user_id,
1495: last_update_login = fnd_global.login_id
1496: WHERE batch_name = nvl(px_batch_name,batch_name)
1497: AND book_type_code = p_book_type_code;
1498:
1499: write_message(