eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGET_FUND_PKG

Line 590: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'Before calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');

586: End if;
587:
588:
589: IF P_DEBUG_MODE = 'Y' THEN
590: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'Before calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');
591: END IF;
592:
593: PA_BUDGET_FUND_PKG.get_budget_ctrl_options
594: ( p_project_id =>p_project_id

Line 593: PA_BUDGET_FUND_PKG.get_budget_ctrl_options

589: IF P_DEBUG_MODE = 'Y' THEN
590: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'Before calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');
591: END IF;
592:
593: PA_BUDGET_FUND_PKG.get_budget_ctrl_options
594: ( p_project_id =>p_project_id
595: ,p_budget_type_code => null
596: ,p_calling_mode =>l_calling_mode
597: ,X_BALANCE_TYPE =>l_balance_type

Line 608: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'After calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');

604: ,X_Msg_Count =>l_msg_count
605: );
606:
607: IF P_DEBUG_MODE = 'Y' THEN
608: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'After calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');
609: END IF;
610:
611: If l_bdgt_link in ('G','C') then
612: l_bdgt_link := 'Y';

Line 677: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'Before calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');

673: l_calling_mode := 'COMMITMENT';
674: End if;
675:
676: IF P_DEBUG_MODE = 'Y' THEN
677: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'Before calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');
678: END IF;
679:
680: PA_BUDGET_FUND_PKG.get_budget_ctrl_options
681: ( p_project_id =>p_project_id

Line 680: PA_BUDGET_FUND_PKG.get_budget_ctrl_options

676: IF P_DEBUG_MODE = 'Y' THEN
677: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'Before calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');
678: END IF;
679:
680: PA_BUDGET_FUND_PKG.get_budget_ctrl_options
681: ( p_project_id =>p_project_id
682: ,p_budget_type_code => null
683: ,p_calling_mode =>l_calling_mode
684: ,X_BALANCE_TYPE =>l_balance_type

Line 695: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'After calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');

691: ,X_Msg_Count =>l_msg_count
692: );
693:
694: IF P_DEBUG_MODE = 'Y' THEN
695: LOG_MESSAGE('get_fnd_reqd_flag: ' || 'After calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');
696: END IF;
697:
698: If l_bdgt_link in ('G','C') then
699: l_bdgt_link := 'Y';

Line 734: -- Also for performance reasons instead of calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options

730: -- IN R12, project encumbrance type is no more user enterable in Project
731: -- budgetary control window .This is seeded into gl_encumbrance types
732: -- Hence existing API has been modified to return seeded encumbrance type id
733: -- for BC enabled projects if encumbrance type in pa_budgetary_control_options is NULL
734: -- Also for performance reasons instead of calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options
735: -- have cursor C_BUDGET_CONTROL to fetch required details.
736: -- -------------------------------------------------------------------------------------------+
737:
738: FUNCTION get_encum_type_id

Line 834: LOG_MESSAGE('get_bdgt_link: ' || 'Before calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');

830: l_calling_mode := 'COMMITMENT';
831: End if;
832:
833: IF P_DEBUG_MODE = 'Y' THEN
834: LOG_MESSAGE('get_bdgt_link: ' || 'Before calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');
835: END IF;
836:
837: PA_BUDGET_FUND_PKG.get_budget_ctrl_options
838: ( p_project_id =>p_project_id

Line 837: PA_BUDGET_FUND_PKG.get_budget_ctrl_options

833: IF P_DEBUG_MODE = 'Y' THEN
834: LOG_MESSAGE('get_bdgt_link: ' || 'Before calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');
835: END IF;
836:
837: PA_BUDGET_FUND_PKG.get_budget_ctrl_options
838: ( p_project_id =>p_project_id
839: ,p_budget_type_code => null
840: ,p_calling_mode =>l_calling_mode
841: ,X_BALANCE_TYPE =>l_balance_type

Line 852: LOG_MESSAGE('get_bdgt_link: ' || 'After calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');

848: ,X_Msg_Count =>l_msg_count
849: );
850:
851: IF P_DEBUG_MODE = 'Y' THEN
852: LOG_MESSAGE('get_bdgt_link: ' || 'After calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options');
853: END IF;
854:
855: If l_bdgt_link in ('G','C') then
856: l_bdgt_link := 'Y';

Line 1172: ']pa_budget_fund_pkg.g_processing_mode['||pa_budget_fund_pkg.g_processing_mode||']'

1168: IF P_DEBUG_MODE = 'Y' THEN
1169: pa_fck_util.debug_msg('Is_account_change_allowed: l_budget_entry_level_code['||l_budget_entry_level_code||
1170: ']P_budget_version_id['||P_budget_version_id||']P_resource_assignment_id['||
1171: P_resource_assignment_id||']P_period_name['||l_period_name||
1172: ']pa_budget_fund_pkg.g_processing_mode['||pa_budget_fund_pkg.g_processing_mode||']'
1173: );
1174: END IF;
1175:
1176: -- -----------------------------------------------------------+

Line 1402: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then

1398: -- ------------------------------- 'L' ---------------------------------------------------+
1399:
1400: If l_budget_entry_level_code = 'L' then
1401:
1402: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1403: -- CHECK_FUNDS/THROUGH FORM ..this if condition ..
1404: -- BASELINE/YEAR_END ..else part ..
1405:
1406: -- If its Check funds, then we need to look at data from pa_bc_commitments_all

Line 1491: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then

1487:
1488: -- ------------------------------- 'T' ---------------------------------------------------+
1489: ElsIf l_budget_entry_level_code = 'T' then
1490:
1491: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1492:
1493: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1494: Begin -- 'T' : pa_bc_packets
1495:

Line 1578: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then

1574:
1575: -- ------------------------------- 'P' ---------------------------------------------------+
1576: ElsIf l_budget_entry_level_code = 'P' then
1577:
1578: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1579:
1580: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1581: Begin -- 'P' : pa_bc_packets
1582:

Line 2096: AND pbv.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid

2092: AND gl.period_name = bc.period_name
2093: AND GL.closing_status = 'C'
2094: AND bc.budget_version_id = pbv.budget_version_id
2095: AND BEM.Budget_Entry_Method_Code = PBV.Budget_Entry_Method_Code
2096: AND pbv.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid
2097: AND l_closed_prd_exists = 'Y';
2098:
2099: -- Driving cursor for updating CDL and bc_commitments budget version and budget line for year end rollover process
2100: -- Note : Sweeper process is run in start of year end rollover process, hence all the data exists in bc_commitments

Line 2114: DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',NULL) gl_period_status

2110: bc.burden_method_code,
2111: BEM.entry_level_code,
2112: p_bud_ver_id budget_version_id,
2113: NULL budget_line_id,
2114: DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',NULL) gl_period_status
2115: from pa_bc_commitments bc,
2116: pa_budget_versions pbv,
2117: pa_budget_entry_methods bem,
2118: gl_period_statuses gl

Line 2122: AND GL.closing_status = DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',GL.closing_status)

2118: gl_period_statuses gl
2119: WHERE GL.application_id = 101
2120: AND GL.set_of_books_id = bc.set_of_books_id
2121: AND gl.period_name = bc.period_name
2122: AND GL.closing_status = DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',GL.closing_status)
2123: AND bc.budget_version_id = pbv.budget_version_id
2124: AND BEM.Budget_Entry_Method_Code = PBV.Budget_Entry_Method_Code
2125: AND pbv.budget_version_id in (SELECT p_bud_ver_id
2126: FROM dual

Line 2129: SELECT pa_budget_fund_pkg.g_cost_prev_bvid

2125: AND pbv.budget_version_id in (SELECT p_bud_ver_id
2126: FROM dual
2127: UNION ALL
2128: -- Bug 5206341 :Transactions in closed period are picked for latest budget details stamping
2129: SELECT pa_budget_fund_pkg.g_cost_prev_bvid
2130: FROM dual
2131: WHERE l_closed_prd_exists = 'Y');
2132:
2133:

Line 2301: AND bccom.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid;

2297: SET bccom.budget_version_id = NVL(l_bvidTab(i), bccom.budget_version_id),
2298: bccom.budget_line_id = NVL(l_blidTab(i),bccom.budget_line_id)
2299: WHERE bccom.bc_commitment_id = l_bccomidTab(i)
2300: AND l_glprdstatustab(i) = 'C'
2301: AND bccom.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid;
2302:
2303: IF P_DEBUG_MODE = 'Y' THEN
2304: pa_fck_util.debug_msg( 'Number of pa_bc_commitments_all updated'||SQL%ROWCOUNT);
2305: END IF;