DBA Data[Home] [Help]

APPS.PA_UTILS2 dependencies on PA_TRANSACTION_SOURCES

Line 1200: pa_transaction_sources tr

1196: ei.projfunc_cost_exchange_rate,
1197: ei.work_type_id
1198: FROM pa_expenditure_items_all ei,
1199: pa_cost_distribution_lines cdl,
1200: pa_transaction_sources tr
1201: WHERE tr.transaction_source(+) = ei.transaction_source
1202: AND ei.expenditure_item_id = cdl.expenditure_item_id
1203: AND CDL.Transfer_Status_Code = 'Y';
1204:

Line 4762: RETURN pa_transaction_sources.allow_burden_flag%TYPE

4758:
4759: -----------------------------------------------------------------------
4760: --Start Bug 3069632
4761: FUNCTION get_ts_allow_burden_flag( p_transaction_source IN pa_expenditure_items_all.transaction_source%TYPE)
4762: RETURN pa_transaction_sources.allow_burden_flag%TYPE
4763: IS
4764: l_allow_burden_flag pa_transaction_sources.allow_burden_flag%TYPE := 'N';
4765: BEGIN
4766: IF ( p_transaction_source IS NOT NULL )

Line 4764: l_allow_burden_flag pa_transaction_sources.allow_burden_flag%TYPE := 'N';

4760: --Start Bug 3069632
4761: FUNCTION get_ts_allow_burden_flag( p_transaction_source IN pa_expenditure_items_all.transaction_source%TYPE)
4762: RETURN pa_transaction_sources.allow_burden_flag%TYPE
4763: IS
4764: l_allow_burden_flag pa_transaction_sources.allow_burden_flag%TYPE := 'N';
4765: BEGIN
4766: IF ( p_transaction_source IS NOT NULL )
4767: THEN
4768: If p_transaction_source = pa_utils2.g_transaction_source Then

Line 4775: from pa_transaction_sources ts

4771: Else
4772:
4773: select ts.allow_burden_flag
4774: into l_allow_burden_flag
4775: from pa_transaction_sources ts
4776: where ts.transaction_source = p_transaction_source;
4777:
4778: pa_utils2.g_ts_allow_burden_flag := l_allow_burden_flag;
4779: pa_utils2.g_transaction_source := p_transaction_source;