APPS.FA_TAX_UPLOAD_PKG dependencies on FA_TAX_INTERFACE

Line 291: from fa_tax_interface ti,

287: ti.prior_basic_rate,
288: ti.prior_adjusted_rate,
289: ti.prior_life_in_months,
290: ti.prior_deprn_limit_type -- Changes made as per the ER No.s 6606548 and 6606552 by Vkukutam End
291: from fa_tax_interface ti,
292: fa_books bk
293: where ti.book_type_code = p_book_type_code
294: and ti.posting_status = 'POST'
295: and ti.tax_request_id = p_parent_request_id

Line 983: update fa_tax_interface

979: raise data_error;
980: end if;
981:
982: -- flag interface record as posted
983: update fa_tax_interface
984: set posting_status = 'POSTED',
985: tax_request_id = l_request_id
986: where rowid = l_tax_rowid(l_loop_count);
987:

Line 1013: update fa_tax_interface

1009:
1010: rollback to savepoint taxup_savepoint;
1011:
1012: -- flag interface record as failed
1013: update fa_tax_interface
1014: set posting_status = 'ERROR',
1015: tax_request_id = l_request_id
1016: where rowid = l_tax_rowid(l_loop_count);
1017: when others then

Line 1032: update fa_tax_interface

1028:
1029: rollback to savepoint taxup_savepoint;
1030:
1031: -- flag interface record as failed
1032: update fa_tax_interface
1033: set posting_status = 'ERROR',
1034: tax_request_id = l_request_id
1035: where rowid = l_tax_rowid(l_loop_count);
1036:

Line 1142: from fa_tax_interface tax,

1138: cursor c_group_asset is
1139: select tax.rowid,
1140: nvl(tax.group_asset_id,
1141: bk.group_asset_id)
1142: from fa_tax_interface tax,
1143: fa_additions_b ad,
1144: fa_books bk
1145: where tax.book_type_code = p_book_type_code
1146: and tax.posting_status = 'POST'

Line 1158: from fa_tax_interface tax,

1154: mod(nvl(tax.group_asset_id,
1155: nvl(ad.asset_id, 1)), p_total_requests) + 1,
1156: nvl(ad.asset_id, 1),
1157: ad.asset_type
1158: from fa_tax_interface tax,
1159: fa_additions_b ad
1160: where tax.book_type_code = p_book_type_code
1161: and tax.posting_status = 'POST'
1162: and ad.asset_number(+) = tax.asset_number;

Line 1209: update fa_tax_interface

1205: exit;
1206: end if;
1207:
1208: forall i in 1..l_rowid_tbl.count
1209: update fa_tax_interface
1210: set group_asset_id = l_group_asset_id_tbl(i)
1211: where rowid = l_rowid_tbl(i);
1212:
1213: end loop;

Line 1235: update fa_tax_interface

1231: exit;
1232: end if;
1233:
1234: forall i in 1..l_rowid_tbl.count
1235: update fa_tax_interface
1236: set asset_id = l_asset_id_tbl(i),
1237: asset_type = l_asset_type_tbl(i),
1238: worker_id = l_worker_id_tbl(i),
1239: tax_request_id = p_parent_request_id

Line 1252: fa_debug_pkg.add(l_calling_fn, 'rows updated into fa_tax_interface', sql%rowcount);

1248:
1249: close c_tax_interface;
1250:
1251: if (g_log_level_rec.statement_level) then
1252: fa_debug_pkg.add(l_calling_fn, 'rows updated into fa_tax_interface', sql%rowcount);
1253: end if;
1254:
1255: FND_CONCURRENT.AF_COMMIT;
1256: