DBA Data[Home] [Help]

APPS.FARX_BL dependencies on FA_BALANCES_REP_ITF

Line 1225: h_table_token := 'FA_BALANCES_REP_ITF';

1221: h_short_retirement_type := substrb(h_retirement_type, 1, 499);
1222: -- End of bug fix 5975548
1223:
1224: h_mesg_name := 'FA_SHARED_INSERT_FAILED';
1225: h_table_token := 'FA_BALANCES_REP_ITF';
1226:
1227: -- insert into interface table
1228: insert /*+ noappend */ into fa_balances_rep_itf
1229: (request_id, company, cost_center, account,

Line 1228: insert /*+ noappend */ into fa_balances_rep_itf

1224: h_mesg_name := 'FA_SHARED_INSERT_FAILED';
1225: h_table_token := 'FA_BALANCES_REP_ITF';
1226:
1227: -- insert into interface table
1228: insert /*+ noappend */ into fa_balances_rep_itf
1229: (request_id, company, cost_center, account,
1230: cost_account,
1231: inventorial, asset_key, asset_number, tag_number, description,
1232: category, deprn_method,

Line 1282: Update fa_balances_rep_itf

1278: into h_group_asset
1279: from fa_additions
1280: where asset_id=group_asset.group_asset_id;
1281:
1282: Update fa_balances_rep_itf
1283: set cost_begin_balance = h_cost_begin_balance
1284: where request_id = Request_Id
1285: and asset_number = h_group_asset;
1286:

Line 1431: h_table_token := 'FA_BALANCES_REP_ITF';

1427: h_short_retirement_type := substrb(h_retirement_type, 1, 499);
1428: -- End of bug fix 5975548
1429:
1430: h_mesg_name := 'FA_SHARED_INSERT_FAILED';
1431: h_table_token := 'FA_BALANCES_REP_ITF';
1432:
1433: --insert into interface table
1434: insert /*+ noappend */ into fa_balances_rep_itf
1435: (request_id, company, cost_center, account,

Line 1434: insert /*+ noappend */ into fa_balances_rep_itf

1430: h_mesg_name := 'FA_SHARED_INSERT_FAILED';
1431: h_table_token := 'FA_BALANCES_REP_ITF';
1432:
1433: --insert into interface table
1434: insert /*+ noappend */ into fa_balances_rep_itf
1435: (request_id, company, cost_center, account,
1436: cost_account, /* StatReq */
1437: asset_key, asset_number, tag_number, description,
1438: inventorial, serial_number,

Line 1501: Update fa_balances_rep_itf

1497: into h_group_asset
1498: from fa_additions
1499: where asset_id=group_asset.group_asset_id;
1500:
1501: Update fa_balances_rep_itf
1502: set cost_begin_balance = h_cost_begin_balance,
1503: begin_balance = h_begin,
1504: additions = h_addition,
1505: capitalizations = h_capitalization,