APPS.PA_TRX_IMPORT dependencies on PA_FUNDS_CONTROL_UTILS

Line 5696: --Pa_Funds_Control_Utils.Get_Fnd_Reqd_Flag(G_project_id, 'STD') = 'Y'

5692: --X_trx_src in ('AP INVOICE', 'AP VARIANCE', 'PO RECEIPT', 'AP NRTAX', 'PO RECEIPT NRTAX') AND
5693: X_acct_raw_cost <> 0 AND
5694: nvl(G_gl_accted_flag,'N') = 'Y' AND
5695: G_SobId = G_RecvrSobId AND
5696: --Pa_Funds_Control_Utils.Get_Fnd_Reqd_Flag(G_project_id, 'STD') = 'Y'
5697: -- REL12 AP Lines Uptake
5698: NVL(p_fc_document_type, 'NOT' ) <> 'NOT' THEN
5699:
5700: IF PG_DEBUG = 'Y' THEN

Line 10664: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN

10660: log_message('log_message: ' || pa_debug.G_err_Stage);
10661: END IF;
10662: END IF;
10663:
10664: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
10665:
10666: -- BUG : 4885459 : APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
10667:
10668: l_ExpItemId_temp_Tab.DELETE ;

Line 10681: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),

10677:
10678: FORALL j in l_ExpItemId_temp_Tab.first..l_ExpItemId_temp_Tab.last
10679: update pa_cost_distribution_lines_all cdl
10680: set cdl.Budget_CCID = l_budget_ccid ,
10681: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),
10682: cdl.budget_line_id = DECODE(cdl.budget_line_id,NULL,l_budget_line_id,cdl.budget_line_id),
10683: cdl.budget_version_id = DECODE(cdl.budget_version_id,NULL,l_budget_version_id,cdl.budget_version_id)
10684: Where cdl.budget_ccid is null
10685: and cdl.expenditure_item_id = l_ExpItemId_temp_Tab(j) ;

Line 10760: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN

10756: log_message('log_message: ' || pa_debug.G_err_Stage);
10757: END IF;
10758: END IF;
10759:
10760: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
10761:
10762: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
10763: l_ExpItemId_temp_Tab.DELETE ;
10764:

Line 10777: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),

10773: FORALL j in l_ExpItemId_temp_Tab.first..l_ExpItemId_temp_Tab.last
10774: update pa_cost_distribution_lines_all cdl
10775: set cdl.Budget_CCID = l_budget_ccid ,
10776: -- R12 Funds Management Uptake : Modified and added below columns logic
10777: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),
10778: cdl.budget_line_id = DECODE(cdl.budget_line_id,NULL,l_budget_line_id,cdl.budget_line_id),
10779: cdl.budget_version_id = DECODE(cdl.budget_version_id,NULL,l_budget_version_id,cdl.budget_version_id)
10780: Where cdl.budget_ccid is null
10781: and cdl.expenditure_item_id = l_ExpItemId_temp_Tab(j) ; /*REL12 : AP Lines Uptake changes*/

Line 10858: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN

10854: log_message('log_message: ' || pa_debug.G_err_Stage);
10855: END IF;
10856: END IF;
10857:
10858: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
10859:
10860: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
10861:
10862: l_ExpItemId_temp_Tab.DELETE ;

Line 10875: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),

10871: IF l_ExpItemId_temp_Tab.COUNT > 0 THEN
10872: FORALL j in l_ExpItemId_temp_Tab.first..l_ExpItemId_temp_Tab.last
10873: update pa_cost_distribution_lines_all cdl
10874: set cdl.Budget_CCID = l_budget_ccid ,
10875: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),
10876: -- R12 Funds Management Uptake
10877: cdl.budget_line_id = DECODE(cdl.budget_line_id,NULL,l_budget_line_id,cdl.budget_line_id),
10878: cdl.budget_version_id = DECODE(cdl.budget_version_id,NULL,l_budget_version_id,cdl.budget_version_id)
10879: Where cdl.budget_ccid is null