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 511: PA_BUDGET_FUND_PKG.get_budget_ctrl_options

507: Elsif p_calling_mode = 'CBC' then
508: l_calling_mode := 'COMMITMENT';
509: End if;
510:
511: PA_BUDGET_FUND_PKG.get_budget_ctrl_options
512: ( p_project_id =>p_project_id
513: ,p_budget_type_code => null
514: ,p_calling_mode =>l_calling_mode
515: ,X_BALANCE_TYPE =>l_balance_type

Line 578: PA_BUDGET_FUND_PKG.get_budget_ctrl_options

574: Elsif p_calling_mode = 'CBC' then
575: l_calling_mode := 'COMMITMENT';
576: End if;
577:
578: PA_BUDGET_FUND_PKG.get_budget_ctrl_options
579: ( p_project_id =>p_project_id
580: ,p_budget_type_code => null
581: ,p_calling_mode =>l_calling_mode
582: ,X_BALANCE_TYPE =>l_balance_type

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

619: -- IN R12, project encumbrance type is no more user enterable in Project
620: -- budgetary control window .This is seeded into gl_encumbrance types
621: -- Hence existing API has been modified to return seeded encumbrance type id
622: -- for BC enabled projects if encumbrance type in pa_budgetary_control_options is NULL
623: -- Also for performance reasons instead of calling PA_BUDGET_FUND_PKG.get_budget_ctrl_options
624: -- have cursor C_BUDGET_CONTROL to fetch required details.
625: -- -------------------------------------------------------------------------------------------+
626:
627: FUNCTION get_encum_type_id

Line 693: PA_BUDGET_FUND_PKG.get_budget_ctrl_options

689: l_calling_mode := 'STANDARD';
690: Elsif p_calling_mode = 'CBC' then
691: l_calling_mode := 'COMMITMENT';
692: End if;
693: PA_BUDGET_FUND_PKG.get_budget_ctrl_options
694: ( p_project_id =>p_project_id
695: ,p_budget_type_code => null
696: ,p_calling_mode =>l_calling_mode
697: ,X_BALANCE_TYPE =>l_balance_type

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

1017: IF P_DEBUG_MODE = 'Y' THEN
1018: pa_fck_util.debug_msg('Is_account_change_allowed: l_budget_entry_level_code['||l_budget_entry_level_code||
1019: ']P_budget_version_id['||P_budget_version_id||']P_resource_assignment_id['||
1020: P_resource_assignment_id||']P_period_name['||l_period_name||
1021: ']pa_budget_fund_pkg.g_processing_mode['||pa_budget_fund_pkg.g_processing_mode||']'
1022: );
1023: END IF;
1024:
1025: -- -----------------------------------------------------------+

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

1247: -- ------------------------------- 'L' ---------------------------------------------------+
1248:
1249: If l_budget_entry_level_code = 'L' then
1250:
1251: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1252: -- CHECK_FUNDS/THROUGH FORM ..this if condition ..
1253: -- BASELINE/YEAR_END ..else part ..
1254:
1255: -- If its Check funds, then we need to look at data from pa_bc_commitments_all

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

1336:
1337: -- ------------------------------- 'T' ---------------------------------------------------+
1338: ElsIf l_budget_entry_level_code = 'T' then
1339:
1340: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1341:
1342: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1343: Begin -- 'T' : pa_bc_packets
1344:

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

1423:
1424: -- ------------------------------- 'P' ---------------------------------------------------+
1425: ElsIf l_budget_entry_level_code = 'P' then
1426:
1427: If (nvl(pa_budget_fund_pkg.g_processing_mode,'CHECK_FUNDS') = 'CHECK_FUNDS') then
1428:
1429: -- If its Check funds, then we need to look at data from pa_bc_commitments_all
1430: Begin -- 'P' : pa_bc_packets
1431:

Line 1945: AND pbv.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid

1941: AND gl.period_name = bc.period_name
1942: AND GL.closing_status = 'C'
1943: AND bc.budget_version_id = pbv.budget_version_id
1944: AND BEM.Budget_Entry_Method_Code = PBV.Budget_Entry_Method_Code
1945: AND pbv.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid
1946: AND l_closed_prd_exists = 'Y';
1947:
1948: -- Driving cursor for updating CDL and bc_commitments budget version and budget line for year end rollover process
1949: -- Note : Sweeper process is run in start of year end rollover process, hence all the data exists in bc_commitments

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

1959: bc.burden_method_code,
1960: BEM.entry_level_code,
1961: p_bud_ver_id budget_version_id,
1962: NULL budget_line_id,
1963: DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',NULL) gl_period_status
1964: from pa_bc_commitments bc,
1965: pa_budget_versions pbv,
1966: pa_budget_entry_methods bem,
1967: gl_period_statuses gl

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

1967: gl_period_statuses gl
1968: WHERE GL.application_id = 101
1969: AND GL.set_of_books_id = bc.set_of_books_id
1970: AND gl.period_name = bc.period_name
1971: AND GL.closing_status = DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',GL.closing_status)
1972: AND bc.budget_version_id = pbv.budget_version_id
1973: AND BEM.Budget_Entry_Method_Code = PBV.Budget_Entry_Method_Code
1974: AND pbv.budget_version_id in (SELECT p_bud_ver_id
1975: FROM dual

Line 1978: SELECT pa_budget_fund_pkg.g_cost_prev_bvid

1974: AND pbv.budget_version_id in (SELECT p_bud_ver_id
1975: FROM dual
1976: UNION ALL
1977: -- Bug 5206341 :Transactions in closed period are picked for latest budget details stamping
1978: SELECT pa_budget_fund_pkg.g_cost_prev_bvid
1979: FROM dual
1980: WHERE l_closed_prd_exists = 'Y');
1981:
1982:

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

2146: SET bccom.budget_version_id = NVL(l_bvidTab(i), bccom.budget_version_id),
2147: bccom.budget_line_id = NVL(l_blidTab(i),bccom.budget_line_id)
2148: WHERE bccom.bc_commitment_id = l_bccomidTab(i)
2149: AND l_glprdstatustab(i) = 'C'
2150: AND bccom.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid;
2151:
2152: IF P_DEBUG_MODE = 'Y' THEN
2153: pa_fck_util.debug_msg( 'Number of pa_bc_commitments_all updated'||SQL%ROWCOUNT);
2154: END IF;