APPS.PA_TRX_IMPORT dependencies on PA_FUNDS_CONTROL_UTILS

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

5250: --X_trx_src in ('AP INVOICE', 'AP VARIANCE', 'PO RECEIPT', 'AP NRTAX', 'PO RECEIPT NRTAX') AND
5251: X_acct_raw_cost <> 0 AND
5252: nvl(G_gl_accted_flag,'N') = 'Y' AND
5253: G_SobId = G_RecvrSobId AND
5254: --Pa_Funds_Control_Utils.Get_Fnd_Reqd_Flag(G_project_id, 'STD') = 'Y'
5255: -- REL12 AP Lines Uptake
5256: NVL(p_fc_document_type, 'NOT' ) <> 'NOT' THEN
5257:
5258: IF PG_DEBUG = 'Y' THEN

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

9842: log_message('log_message: ' || pa_debug.G_err_Stage);
9843: END IF;
9844: END IF;
9845:
9846: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
9847:
9848: -- BUG : 4885459 : APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
9849:
9850: l_ExpItemId_temp_Tab.DELETE ;

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

9859:
9860: FORALL j in l_ExpItemId_temp_Tab.first..l_ExpItemId_temp_Tab.last
9861: update pa_cost_distribution_lines_all cdl
9862: set cdl.Budget_CCID = l_budget_ccid ,
9863: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),
9864: cdl.budget_line_id = DECODE(cdl.budget_line_id,NULL,l_budget_line_id,cdl.budget_line_id),
9865: cdl.budget_version_id = DECODE(cdl.budget_version_id,NULL,l_budget_version_id,cdl.budget_version_id)
9866: Where cdl.budget_ccid is null
9867: and cdl.expenditure_item_id = l_ExpItemId_temp_Tab(j) ;

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

9938: log_message('log_message: ' || pa_debug.G_err_Stage);
9939: END IF;
9940: END IF;
9941:
9942: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
9943:
9944: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
9945: l_ExpItemId_temp_Tab.DELETE ;
9946:

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

9955: FORALL j in l_ExpItemId_temp_Tab.first..l_ExpItemId_temp_Tab.last
9956: update pa_cost_distribution_lines_all cdl
9957: set cdl.Budget_CCID = l_budget_ccid ,
9958: -- R12 Funds Management Uptake : Modified and added below columns logic
9959: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),
9960: cdl.budget_line_id = DECODE(cdl.budget_line_id,NULL,l_budget_line_id,cdl.budget_line_id),
9961: cdl.budget_version_id = DECODE(cdl.budget_version_id,NULL,l_budget_version_id,cdl.budget_version_id)
9962: Where cdl.budget_ccid is null
9963: and cdl.expenditure_item_id = l_ExpItemId_temp_Tab(j) ; /*REL12 : AP Lines Uptake changes*/

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

10036: log_message('log_message: ' || pa_debug.G_err_Stage);
10037: END IF;
10038: END IF;
10039:
10040: IF (pa_funds_control_utils.get_bdgt_link(l_Project_Id, 'STD') = 'Y') THEN
10041:
10042: -- BUG : 4885459 APPSPERF:PA:PJC: PA_TRX_IMPORT : PERF. REPOSITORY EXCEPTIONS
10043:
10044: l_ExpItemId_temp_Tab.DELETE ;

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

10053: IF l_ExpItemId_temp_Tab.COUNT > 0 THEN
10054: FORALL j in l_ExpItemId_temp_Tab.first..l_ExpItemId_temp_Tab.last
10055: update pa_cost_distribution_lines_all cdl
10056: set cdl.Budget_CCID = l_budget_ccid ,
10057: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),
10058: -- R12 Funds Management Uptake
10059: cdl.budget_line_id = DECODE(cdl.budget_line_id,NULL,l_budget_line_id,cdl.budget_line_id),
10060: cdl.budget_version_id = DECODE(cdl.budget_version_id,NULL,l_budget_version_id,cdl.budget_version_id)
10061: Where cdl.budget_ccid is null