APPS.FA_MASSCP_PKG dependencies on FA_NUM15_TBL_TYPE

Line 64: fa_asset_id_fail_tab fa_num15_tbl_type;

60: l_cip_in_tax_add number;
61: l_string varchar2(250);
62: l_orig_src_trx_header_id number;
63:
64: fa_asset_id_fail_tab fa_num15_tbl_type;
65: l_process_status v30_tbl;
66:
67: done_exc EXCEPTION;
68: masscp_err EXCEPTION;

Line 387: fa_asset_id_fail_tab := fa_num15_tbl_type();

383: FND_CONCURRENT.AF_COMMIT;
384:
385: -- now insert all failures into the error table for subsequent runs
386:
387: fa_asset_id_fail_tab := fa_num15_tbl_type();
388:
389: for i in 1..g_asset_error1_tbl.count loop
390:
391: fa_asset_id_fail_tab.EXTEND;

Line 401: from TABLE(CAST(fa_asset_id_fail_tab AS fa_num15_tbl_type)) trx

397: -- loops, we are using minus here to insure we don't raise ora-1
398:
399: insert into fa_asset_failures_gt (asset_id)
400: select distinct column_value
401: from TABLE(CAST(fa_asset_id_fail_tab AS fa_num15_tbl_type)) trx
402: minus
403: select asset_id
404: from fa_asset_failures_gt;
405: