DBA Data[Home] [Help]

APPS.FARX_BL dependencies on FA_BALANCES_REP_ITF

Line 2079: h_table_token := 'FA_BALANCES_REP_ITF';

2075: h_short_retirement_type := substrb(h_retirement_type, 1, 499);
2076: -- End of bug fix 5944006
2077:
2078: h_mesg_name := 'FA_SHARED_INSERT_FAILED';
2079: h_table_token := 'FA_BALANCES_REP_ITF';
2080:
2081: -- insert into interface table
2082: insert /*+ noappend */ into fa_balances_rep_itf
2083: (request_id, company, cost_center, account,

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

2078: h_mesg_name := 'FA_SHARED_INSERT_FAILED';
2079: h_table_token := 'FA_BALANCES_REP_ITF';
2080:
2081: -- insert into interface table
2082: insert /*+ noappend */ into fa_balances_rep_itf
2083: (request_id, company, cost_center, account,
2084: cost_account,
2085: inventorial, asset_key, asset_number, tag_number, description,
2086: category, deprn_method,

Line 2142: Update fa_balances_rep_itf

2138: into h_group_asset
2139: from fa_additions
2140: where asset_id=group_asset.group_asset_id;
2141:
2142: Update fa_balances_rep_itf
2143: set cost_begin_balance = h_cost_begin_balance
2144: where request_id = Request_Id
2145: and asset_number = h_group_asset;
2146:

Line 2336: h_table_token := 'FA_BALANCES_REP_ITF';

2332: h_shortconcat_key := substr(h_concat_key,1, 239);
2333:
2334:
2335: h_mesg_name := 'FA_SHARED_INSERT_FAILED';
2336: h_table_token := 'FA_BALANCES_REP_ITF';
2337:
2338: -- Added following code for bug 5944006
2339: h_short_invoice_number := substrb(h_invoice_number, 1, 499);
2340: h_short_invoice_descr := substrb(h_invoice_descr, 1, 499);

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

2342: h_short_retirement_type := substrb(h_retirement_type, 1, 499);
2343: -- End of bug fix 5944006
2344:
2345: --insert into interface table
2346: insert /*+ noappend */ into fa_balances_rep_itf
2347: (request_id, company, cost_center, account,
2348: cost_account, /* StatReq */
2349: asset_key, asset_number, tag_number, description,
2350: inventorial, serial_number,

Line 2419: Update fa_balances_rep_itf

2415: into h_group_asset
2416: from fa_additions
2417: where asset_id=group_asset.group_asset_id;
2418:
2419: Update fa_balances_rep_itf
2420: set cost_begin_balance = h_cost_begin_balance,
2421: begin_balance = h_begin,
2422: additions = h_addition,
2423: capitalizations = h_capitalization,