DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_FUNDS_CONTROL_UTILS

Line 4881: l_acct_level_bal := pa_funds_control_utils.Get_Acct_Line_Balance(

4877: ']p_start_date ['||p_start_date||']p_end_date ['||p_end_date||
4878: ']budget_ccid [ '||p_record.budget_ccid||']' );
4879: End if;
4880:
4881: l_acct_level_bal := pa_funds_control_utils.Get_Acct_Line_Balance(
4882: p_budget_version_id => p_record.budget_version_id,
4883: p_start_date => p_start_date,
4884: p_end_date => p_end_date,
4885: p_budget_ccid => p_record.budget_ccid);

Line 7287: PA_FUNDS_CONTROL_UTILS.Get_Budget_CCID (

7283: ']p_top_task_id ['||p_top_task_id||'budgt by ['||p_bdgt_entry_level||
7284: ']rlmi ['||p_resource_list_member_id||']p_budget_version_id ['||p_budget_version_id ||']' );
7285: End if;
7286:
7287: PA_FUNDS_CONTROL_UTILS.Get_Budget_CCID (
7288: p_project_id => p_project_id,
7289: p_task_id => p_task_id,
7290: p_res_list_mem_id => p_resource_list_member_id,
7291: --p_period_name => p_period_name,

Line 8010: l_fc_utils2_cwk_rlmi := pa_funds_control_utils2.get_CWK_RLMI

8006: END IF;
8007:
8008: FOR i IN g_tab_bc_packet_id.FIRST .. g_tab_bc_packet_id.LAST LOOP
8009: l_fc_utils2_cwk_rlmi := NULL;
8010: l_fc_utils2_cwk_rlmi := pa_funds_control_utils2.get_CWK_RLMI
8011: (g_tab_project_id(i)
8012: ,g_tab_task_id(i)
8013: ,g_tab_budget_version_id(i)
8014: ,g_tab_doc_header_id(i)

Line 8487: l_ext_bdgt_link := pa_funds_control_utils.get_bdgt_link

8483: --check whether the project is linked or not if linked with std
8484: -- budget then derive all the encumbrance details
8485: l_ext_bdgt_link := 'N';
8486: IF l_pre_project_id is NULL or l_pre_project_id <> g_tab_project_id(i) then
8487: l_ext_bdgt_link := pa_funds_control_utils.get_bdgt_link
8488: ( p_project_id =>g_tab_project_id(i),
8489: p_calling_mode => l_ext_bdgt_type);
8490: l_pre_ext_bdgt_link := l_ext_bdgt_link;
8491: Else

Line 8615: l_encum_type_id := pa_funds_control_utils.Get_encum_type_id

8611: --- get the encum_type_id from api get_budget_control_options for
8612: --- the given project_id
8613: IF l_pre_project_id is NULL or l_pre_project_id <> g_tab_project_id(i) then
8614: If P_mode NOT IN ('B','S') then
8615: l_encum_type_id := pa_funds_control_utils.Get_encum_type_id
8616: ( p_project_id => g_tab_project_id(i),
8617: p_calling_mode => l_ext_bdgt_type);
8618: if l_encum_type_id is null and l_ext_bdgt_link = 'Y' then
8619: --Error msg : 'F135 = Transaction failed due to Encumbrance type is null';

Line 9904: l_ext_bdgt_link := PA_FUNDS_CONTROL_UTILS.get_bdgt_link(

9900: <> g_tab_project_id(i)) OR
9901: (l_pre_ext_bdgt_type is NULL or l_pre_ext_bdgt_type <>
9902: l_ext_bdgt_type ) then
9903:
9904: l_ext_bdgt_link := PA_FUNDS_CONTROL_UTILS.get_bdgt_link(
9905: p_project_id => g_tab_project_id(i),
9906: p_calling_mode => l_ext_bdgt_type );
9907:
9908:

Line 10353: AND pa_funds_control_utils.get_bdgt_link(

10349: WHERE pbc.packet_id = p_packet_id
10350: AND pbc.document_header_id = igc.cc_header_id
10351: AND pbc.document_distribution_id = igc.cc_acct_line_id
10352: AND pbc.document_type in ('CC_C_CO','CC_P_CO')
10353: AND pa_funds_control_utils.get_bdgt_link(
10354: pbc.project_id,decode(pbc.document_type,'CC_C_CO','CBC',
10355: 'CC_P_CO','CBC',
10356: 'STD')) = 'Y'
10357: AND pbc.status_code NOT IN ('Z','T','V','B')

Line 11593: l_yr_end_rollover_flag := PA_FUNDS_CONTROL_UTILS.

11589: l_bdgt_type := 'CBC';
11590: Else
11591: l_bdgt_type := 'STD';
11592: End if;
11593: l_yr_end_rollover_flag := PA_FUNDS_CONTROL_UTILS.
11594: get_fnd_reqd_flag(g_tab_project_id(i),
11595: l_bdgt_type);
11596: IF l_yr_end_rollover_flag = 'R' then
11597: /** Year End Rollover process is in progress

Line 11990: PA_FUNDS_CONTROL_UTILS.init_util_variables;

11986: g_return_status := 'S';
11987:
11988:
11989: --Initialize the funds control util package global variables
11990: PA_FUNDS_CONTROL_UTILS.init_util_variables;
11991:
11992: --Inialize the the local global variables
11993: Initialize_globals;
11994:

Line 14594: AND PA_FUNDS_CONTROL_UTILS.CLOSED_PERIODS_EXISTS_IN_BUDG(p_current_bvid) ='Y' ;

14590: where pbl.budget_version_id = p_current_bvid
14591: group by pbl.budget_version_id,pbl.code_combination_id
14592: having sum(nvl(pbl.Curr_Ver_Available_Amount,0)) < 0
14593: )
14594: AND PA_FUNDS_CONTROL_UTILS.CLOSED_PERIODS_EXISTS_IN_BUDG(p_current_bvid) ='Y' ;
14595:
14596: --and pbl.Curr_Ver_Available_Amount < 0;
14597: -- Draft has Jan and txn for Dec.. YTD/Y, in that case, Jan should have failure too
14598:

Line 15285: log_message(p_msg_token1=>l_program_name||': Calling pa_funds_control_utils.is_Account_change_allowed2');

15281:
15282: If (t_prev_ver_ccid(x) <> t_ccid(x))
15283: then
15284: If g_debug_mode = 'Y' then
15285: log_message(p_msg_token1=>l_program_name||': Calling pa_funds_control_utils.is_Account_change_allowed2');
15286: End If;
15287:
15288: IF pa_funds_control_utils.is_Account_change_allowed2
15289: (p_budget_version_id => l_bvid_for_acct_changed_API,

Line 15288: IF pa_funds_control_utils.is_Account_change_allowed2

15284: If g_debug_mode = 'Y' then
15285: log_message(p_msg_token1=>l_program_name||': Calling pa_funds_control_utils.is_Account_change_allowed2');
15286: End If;
15287:
15288: IF pa_funds_control_utils.is_Account_change_allowed2
15289: (p_budget_version_id => l_bvid_for_acct_changed_API,
15290: p_project_id => t_project_id(x),
15291: p_top_task_id => t_top_task_id(x),
15292: p_task_id => t_task_id(x),