DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FA_CHAR30_TBL_TYPE

Line 2428: fa_trx_types_tab fa_char30_tbl_type;

2424: l_child_process_order num_tbl;
2425:
2426: l_group_increment number := 0;
2427: l_date_effective date; -- bug fix 5925965
2428: fa_trx_types_tab fa_char30_tbl_type;
2429:
2430: masscp_err exception;
2431:
2432: BEGIN

Line 2472: fa_trx_types_tab := fa_char30_tbl_type();

2468: ) then
2469: raise masscp_err;
2470: end if;
2471:
2472: fa_trx_types_tab := fa_char30_tbl_type();
2473:
2474: if (fa_cache_pkg.fazcbc_record.copy_additions_flag = 'YES') then
2475: fa_trx_types_tab.EXTEND;
2476: fa_trx_types_tab(fa_trx_types_tab.last) := 'ADDITION';

Line 2727: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx

2723: from fa_additions_b ad,
2724: fa_transaction_headers corp_th,
2725: fa_books corp_bk,
2726: fa_books corp_bk_old,
2727: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx
2728: where corp_th.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
2729: and corp_th.transaction_type_code = trx.column_value
2730: and corp_th.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)
2731: and corp_th.date_effective >= l_corp_period_rec.period_open_date