DBA Data[Home] [Help]

APPS.PA_UTILS2 dependencies on PA_TRANSACTION_SOURCES

Line 1216: pa_transaction_sources tr

1212: ei.projfunc_cost_exchange_rate,
1213: ei.work_type_id
1214: FROM pa_expenditure_items_all ei,
1215: pa_cost_distribution_lines cdl,
1216: pa_transaction_sources tr
1217: WHERE tr.transaction_source(+) = ei.transaction_source
1218: AND ei.expenditure_item_id = cdl.expenditure_item_id
1219: AND CDL.Transfer_Status_Code = 'Y';
1220:

Line 4800: RETURN pa_transaction_sources.allow_burden_flag%TYPE

4796:
4797: -----------------------------------------------------------------------
4798: --Start Bug 3069632
4799: FUNCTION get_ts_allow_burden_flag( p_transaction_source IN pa_expenditure_items_all.transaction_source%TYPE)
4800: RETURN pa_transaction_sources.allow_burden_flag%TYPE
4801: IS
4802: l_allow_burden_flag pa_transaction_sources.allow_burden_flag%TYPE := 'N';
4803: BEGIN
4804: IF ( p_transaction_source IS NOT NULL )

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

4798: --Start Bug 3069632
4799: FUNCTION get_ts_allow_burden_flag( p_transaction_source IN pa_expenditure_items_all.transaction_source%TYPE)
4800: RETURN pa_transaction_sources.allow_burden_flag%TYPE
4801: IS
4802: l_allow_burden_flag pa_transaction_sources.allow_burden_flag%TYPE := 'N';
4803: BEGIN
4804: IF ( p_transaction_source IS NOT NULL )
4805: THEN
4806: If p_transaction_source = pa_utils2.g_transaction_source Then

Line 4813: from pa_transaction_sources ts

4809: Else
4810:
4811: select ts.allow_burden_flag
4812: into l_allow_burden_flag
4813: from pa_transaction_sources ts
4814: where ts.transaction_source = p_transaction_source;
4815:
4816: pa_utils2.g_ts_allow_burden_flag := l_allow_burden_flag;
4817: pa_utils2.g_transaction_source := p_transaction_source;