DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_FUNDS_CONTROL_UTILS

Line 4977: l_acct_level_bal := pa_funds_control_utils.Get_Acct_Line_Balance(

4973: ']p_start_date ['||p_start_date||']p_end_date ['||p_end_date||
4974: ']budget_ccid [ '||p_record.budget_ccid||']' );
4975: End if;
4976:
4977: l_acct_level_bal := pa_funds_control_utils.Get_Acct_Line_Balance(
4978: p_budget_version_id => p_record.budget_version_id,
4979: p_start_date => p_start_date,
4980: p_end_date => p_end_date,
4981: p_budget_ccid => p_record.budget_ccid);

Line 7485: PA_FUNDS_CONTROL_UTILS.Get_Budget_CCID (

7481: ']p_top_task_id ['||p_top_task_id||'budgt by ['||p_bdgt_entry_level||
7482: ']rlmi ['||p_resource_list_member_id||']p_budget_version_id ['||p_budget_version_id ||']' );
7483: End if;
7484:
7485: PA_FUNDS_CONTROL_UTILS.Get_Budget_CCID (
7486: p_project_id => p_project_id,
7487: p_task_id => p_task_id,
7488: p_res_list_mem_id => p_resource_list_member_id,
7489: --p_period_name => p_period_name,

Line 8231: l_fc_utils2_cwk_rlmi := pa_funds_control_utils2.get_CWK_RLMI

8227: END IF;
8228:
8229: FOR i IN g_tab_bc_packet_id.FIRST .. g_tab_bc_packet_id.LAST LOOP
8230: l_fc_utils2_cwk_rlmi := NULL;
8231: l_fc_utils2_cwk_rlmi := pa_funds_control_utils2.get_CWK_RLMI
8232: (g_tab_project_id(i)
8233: ,g_tab_task_id(i)
8234: ,g_tab_budget_version_id(i)
8235: ,g_tab_doc_header_id(i)

Line 8715: l_ext_bdgt_link := pa_funds_control_utils.get_bdgt_link

8711: --check whether the project is linked or not if linked with std
8712: -- budget then derive all the encumbrance details
8713: l_ext_bdgt_link := 'N';
8714: IF l_pre_project_id is NULL or l_pre_project_id <> g_tab_project_id(i) then
8715: l_ext_bdgt_link := pa_funds_control_utils.get_bdgt_link
8716: ( p_project_id =>g_tab_project_id(i),
8717: p_calling_mode => l_ext_bdgt_type);
8718: l_pre_ext_bdgt_link := l_ext_bdgt_link;
8719: Else

Line 8843: l_encum_type_id := pa_funds_control_utils.Get_encum_type_id

8839: --- get the encum_type_id from api get_budget_control_options for
8840: --- the given project_id
8841: IF l_pre_project_id is NULL or l_pre_project_id <> g_tab_project_id(i) then
8842: If P_mode NOT IN ('B','S') then
8843: l_encum_type_id := pa_funds_control_utils.Get_encum_type_id
8844: ( p_project_id => g_tab_project_id(i),
8845: p_calling_mode => l_ext_bdgt_type);
8846: if l_encum_type_id is null and l_ext_bdgt_link = 'Y' then
8847: --Error msg : 'F135 = Transaction failed due to Encumbrance type is null';

Line 10161: l_ext_bdgt_link := PA_FUNDS_CONTROL_UTILS.get_bdgt_link(

10157: <> g_tab_project_id(i)) OR
10158: (l_pre_ext_bdgt_type is NULL or l_pre_ext_bdgt_type <>
10159: l_ext_bdgt_type ) then
10160:
10161: l_ext_bdgt_link := PA_FUNDS_CONTROL_UTILS.get_bdgt_link(
10162: p_project_id => g_tab_project_id(i),
10163: p_calling_mode => l_ext_bdgt_type );
10164:
10165:

Line 10613: AND pa_funds_control_utils.get_bdgt_link(

10609: WHERE pbc.packet_id = p_packet_id
10610: AND pbc.document_header_id = igc.cc_header_id
10611: AND pbc.document_distribution_id = igc.cc_acct_line_id
10612: AND pbc.document_type in ('CC_C_CO','CC_P_CO')
10613: AND pa_funds_control_utils.get_bdgt_link(
10614: pbc.project_id,decode(pbc.document_type,'CC_C_CO','CBC',
10615: 'CC_P_CO','CBC',
10616: 'STD')) = 'Y'
10617: AND pbc.status_code NOT IN ('Z','T','V','B')

Line 11863: l_yr_end_rollover_flag := PA_FUNDS_CONTROL_UTILS.

11859: l_bdgt_type := 'CBC';
11860: Else
11861: l_bdgt_type := 'STD';
11862: End if;
11863: l_yr_end_rollover_flag := PA_FUNDS_CONTROL_UTILS.
11864: get_fnd_reqd_flag(g_tab_project_id(i),
11865: l_bdgt_type);
11866: IF l_yr_end_rollover_flag = 'R' then
11867: /** Year End Rollover process is in progress

Line 12263: log_message(p_msg_token1 => 'Before PA_FUNDS_CONTROL_UTILS.init_util_variables call' );

12259: g_return_status := 'S';
12260:
12261:
12262: If g_debug_mode = 'Y' then
12263: log_message(p_msg_token1 => 'Before PA_FUNDS_CONTROL_UTILS.init_util_variables call' );
12264: End if;
12265: --Initialize the funds control util package global variables
12266: PA_FUNDS_CONTROL_UTILS.init_util_variables;
12267:

Line 12266: PA_FUNDS_CONTROL_UTILS.init_util_variables;

12262: If g_debug_mode = 'Y' then
12263: log_message(p_msg_token1 => 'Before PA_FUNDS_CONTROL_UTILS.init_util_variables call' );
12264: End if;
12265: --Initialize the funds control util package global variables
12266: PA_FUNDS_CONTROL_UTILS.init_util_variables;
12267:
12268: If g_debug_mode = 'Y' then
12269: log_message(p_msg_token1 => 'After PA_FUNDS_CONTROL_UTILS.init_util_variables call' );
12270: log_message(p_msg_token1 => 'Before Initialize_globals call' );

Line 12269: log_message(p_msg_token1 => 'After PA_FUNDS_CONTROL_UTILS.init_util_variables call' );

12265: --Initialize the funds control util package global variables
12266: PA_FUNDS_CONTROL_UTILS.init_util_variables;
12267:
12268: If g_debug_mode = 'Y' then
12269: log_message(p_msg_token1 => 'After PA_FUNDS_CONTROL_UTILS.init_util_variables call' );
12270: log_message(p_msg_token1 => 'Before Initialize_globals call' );
12271: End if;
12272: --Inialize the the local global variables
12273: Initialize_globals;

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

15012: where pbl.budget_version_id = p_current_bvid
15013: group by pbl.budget_version_id,pbl.code_combination_id
15014: having sum(nvl(pbl.Curr_Ver_Available_Amount,0)) < 0
15015: )
15016: AND PA_FUNDS_CONTROL_UTILS.CLOSED_PERIODS_EXISTS_IN_BUDG(p_current_bvid) ='Y' ;
15017:
15018: --and pbl.Curr_Ver_Available_Amount < 0;
15019: -- Draft has Jan and txn for Dec.. YTD/Y, in that case, Jan should have failure too
15020:

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

15712:
15713: If (t_prev_ver_ccid(x) <> t_ccid(x))
15714: then
15715: If g_debug_mode = 'Y' then
15716: log_message(p_msg_token1=>l_program_name||': Calling pa_funds_control_utils.is_Account_change_allowed2');
15717: End If;
15718:
15719: IF pa_funds_control_utils.is_Account_change_allowed2
15720: (p_budget_version_id => l_bvid_for_acct_changed_API,

Line 15719: IF pa_funds_control_utils.is_Account_change_allowed2

15715: If g_debug_mode = 'Y' then
15716: log_message(p_msg_token1=>l_program_name||': Calling pa_funds_control_utils.is_Account_change_allowed2');
15717: End If;
15718:
15719: IF pa_funds_control_utils.is_Account_change_allowed2
15720: (p_budget_version_id => l_bvid_for_acct_changed_API,
15721: p_project_id => t_project_id(x),
15722: p_top_task_id => t_top_task_id(x),
15723: p_task_id => t_task_id(x),