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_BUDGET_FUND_PKG dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 437: from pa_bc_balances a, pa_budgetary_control_options pbco, pa_budget_versions pbv

433: --cursor to delete all versions prior to the latest baselined balance records if the
434: --budget has been baselined before.
435: cursor c_delbal(p_bdgt_ctrl_type in varchar2, p_bdgt_ver in number) is
436: select a.rowid
437: from pa_bc_balances a, pa_budgetary_control_options pbco, pa_budget_versions pbv
438: where pbv.budget_version_id <> p_bdgt_ver
439: and a.project_id = pbco.project_id
440: and a.project_id = pbv.project_id
441: and a.budget_version_id = pbv.budget_version_id

Line 917: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;

913: l_funds_chk_rsrv_status VARCHAR2(1);
914: l_calling_module VARCHAR2(20);
915:
916: l_budget_type_code PA_BUDGET_VERSIONS.budget_type_code%TYPE ;
917: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
918: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;
919: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;
920: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;
921: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;

Line 918: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;

914: l_calling_module VARCHAR2(20);
915:
916: l_budget_type_code PA_BUDGET_VERSIONS.budget_type_code%TYPE ;
917: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
918: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;
919: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;
920: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;
921: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;
922: l_budget_amount_code PA_BUDGET_TYPES.Budget_amount_code%TYPE;

Line 919: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;

915:
916: l_budget_type_code PA_BUDGET_VERSIONS.budget_type_code%TYPE ;
917: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
918: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;
919: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;
920: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;
921: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;
922: l_budget_amount_code PA_BUDGET_TYPES.Budget_amount_code%TYPE;
923: l_budget_entry_level_code PA_Budget_Entry_Methods.entry_level_code%TYPE;

Line 920: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;

916: l_budget_type_code PA_BUDGET_VERSIONS.budget_type_code%TYPE ;
917: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
918: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;
919: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;
920: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;
921: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;
922: l_budget_amount_code PA_BUDGET_TYPES.Budget_amount_code%TYPE;
923: l_budget_entry_level_code PA_Budget_Entry_Methods.entry_level_code%TYPE;
924:

Line 921: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;

917: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
918: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;
919: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;
920: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;
921: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;
922: l_budget_amount_code PA_BUDGET_TYPES.Budget_amount_code%TYPE;
923: l_budget_entry_level_code PA_Budget_Entry_Methods.entry_level_code%TYPE;
924:
925: l_dual_bdgt_cntrl_flag VARCHAR2(1);

Line 964: From PA_BUDGETARY_CONTROL_OPTIONS PBCO ,

960: PBCO.Bdgt_cntrl_flag,
961: PBCO.gl_budget_version_id,
962: PBT.budget_amount_code,
963: BEM.entry_level_code
964: From PA_BUDGETARY_CONTROL_OPTIONS PBCO ,
965: PA_BUDGET_VERSIONS PBV,
966: PA_BUDGET_TYPES PBT,
967: PA_BUDGET_ENTRY_METHODS BEM
968: WHERE PBCO.Project_Id = p_project_id

Line 1070: from pa_budgetary_control_options cc

1066: If l_balance_type = 'E' then
1067: Begin
1068: select 'CC'
1069: into l_cc_budget_type_code
1070: from pa_budgetary_control_options cc
1071: where cc.project_id = p_project_id
1072: and cc.external_budget_code = 'CC';
1073: Exception
1074: When no_data_found then

Line 1449: from pa_budgetary_control_options

1445:
1446: BEGIN
1447: Select budget_type_code, encumbrance_type_id
1448: into l_cc_budget_type_code, l_cc_encumbrance_type_id
1449: from pa_budgetary_control_options
1450: where project_id = p_project_id
1451: and external_budget_code = 'CC' ;
1452: EXCEPTION
1453: WHEN NO_DATA_FOUND THEN

Line 2132: FROM PA_BUDGETARY_CONTROL_OPTIONS

2128: encumbrance_type_id,
2129: external_budget_code,
2130: balance_type,
2131: bdgt_cntrl_flag
2132: FROM PA_BUDGETARY_CONTROL_OPTIONS
2133: WHERE project_id = p_project_id
2134: AND ( ( p_calling_mode = 'STANDARD' AND
2135: ( nvl(external_budget_code,'-1') IN ('GL','-1') ) )
2136: OR

Line 2181: l_balance_type pa_budgetary_control_options.balance_type%TYPE ;

2177:
2178: l_encumbrance_type_id NUMBER ;
2179:
2180: l_budget_type_code pa_budget_versions.budget_type_code%TYPE ;
2181: l_balance_type pa_budgetary_control_options.balance_type%TYPE ;
2182: l_bdgt_cntrl_flag pa_budgetary_control_options.bdgt_cntrl_flag%TYPE ;
2183: l_external_budget_code pa_budgetary_control_options.external_budget_code%TYPE ;
2184: l_budget_version_id pa_budget_versions.budget_version_id%TYPE ;
2185: l_msg_index_out NUMBER;

Line 2182: l_bdgt_cntrl_flag pa_budgetary_control_options.bdgt_cntrl_flag%TYPE ;

2178: l_encumbrance_type_id NUMBER ;
2179:
2180: l_budget_type_code pa_budget_versions.budget_type_code%TYPE ;
2181: l_balance_type pa_budgetary_control_options.balance_type%TYPE ;
2182: l_bdgt_cntrl_flag pa_budgetary_control_options.bdgt_cntrl_flag%TYPE ;
2183: l_external_budget_code pa_budgetary_control_options.external_budget_code%TYPE ;
2184: l_budget_version_id pa_budget_versions.budget_version_id%TYPE ;
2185: l_msg_index_out NUMBER;
2186:

Line 2183: l_external_budget_code pa_budgetary_control_options.external_budget_code%TYPE ;

2179:
2180: l_budget_type_code pa_budget_versions.budget_type_code%TYPE ;
2181: l_balance_type pa_budgetary_control_options.balance_type%TYPE ;
2182: l_bdgt_cntrl_flag pa_budgetary_control_options.bdgt_cntrl_flag%TYPE ;
2183: l_external_budget_code pa_budgetary_control_options.external_budget_code%TYPE ;
2184: l_budget_version_id pa_budget_versions.budget_version_id%TYPE ;
2185: l_msg_index_out NUMBER;
2186:
2187: l_rel_status NUMBER;

Line 2414: FROM PA_BUDGETARY_CONTROL_OPTIONS PBA

2410: SELECT 'X'
2411: FROM DUAL
2412: WHERE EXISTS
2413: ( SELECT 'x'
2414: FROM PA_BUDGETARY_CONTROL_OPTIONS PBA
2415: WHERE PBA.project_id = p_project_id
2416: AND ( ( p_mode ='A' )
2417: OR
2418: ( p_mode <> 'A' AND

Line 2454: insert into PA_BUDGETARY_CONTROL_OPTIONS

2450: BEGIN
2451:
2452: x_return_status := FND_API.G_RET_STS_SUCCESS;
2453:
2454: insert into PA_BUDGETARY_CONTROL_OPTIONS
2455: (
2456: PROJECT_TYPE,
2457: PROJECT_ID,
2458: BALANCE_TYPE,

Line 2499: from PA_BUDGETARY_CONTROL_OPTIONS

2495: -1 ,
2496: SYSDATE ,
2497: -1 ,
2498: -1
2499: from PA_BUDGETARY_CONTROL_OPTIONS
2500: where PROJECT_ID = p_from_project_id;
2501:
2502: EXCEPTION
2503: WHEN NO_DATA_FOUND THEN

Line 2815: from PA_BUDGETARY_CONTROL_OPTIONS PBCO ,

2811: into g_balance_type,
2812: g_budget_amount_code,
2813: l_project_id,
2814: l_budget_type_code
2815: from PA_BUDGETARY_CONTROL_OPTIONS PBCO ,
2816: PA_BUDGET_VERSIONS PBV,
2817: PA_BUDGET_TYPES PBT
2818: where PBV.Budget_version_id = p_budget_version_id
2819: and PBCO.Budget_Type_Code = PBV.Budget_Type_Code