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 441: from pa_bc_balances a, pa_budgetary_control_options pbco, pa_budget_versions pbv

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

Line 921: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;

917: l_funds_chk_rsrv_status VARCHAR2(1);
918: l_calling_module VARCHAR2(20);
919:
920: l_budget_type_code PA_BUDGET_VERSIONS.budget_type_code%TYPE ;
921: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
922: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;
923: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;
924: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;
925: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;

Line 922: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;

918: l_calling_module VARCHAR2(20);
919:
920: l_budget_type_code PA_BUDGET_VERSIONS.budget_type_code%TYPE ;
921: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
922: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;
923: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;
924: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;
925: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;
926: l_budget_amount_code PA_BUDGET_TYPES.Budget_amount_code%TYPE;

Line 923: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;

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

Line 924: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;

920: l_budget_type_code PA_BUDGET_VERSIONS.budget_type_code%TYPE ;
921: l_balance_type PA_BUDGETARY_CONTROL_OPTIONS.Balance_type%TYPE ;
922: l_external_budget_code PA_BUDGETARY_CONTROL_OPTIONS.External_budget_code%TYPE ;
923: l_encumbrance_Type_Id PA_BUDGETARY_CONTROL_OPTIONS.Encumbrance_Type_Id%TYPE ;
924: l_bdgt_cntrl_flag PA_BUDGETARY_CONTROL_OPTIONS.Bdgt_cntrl_flag%TYPE ;
925: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;
926: l_budget_amount_code PA_BUDGET_TYPES.Budget_amount_code%TYPE;
927: l_budget_entry_level_code PA_Budget_Entry_Methods.entry_level_code%TYPE;
928:

Line 925: l_budget_type PA_BUDGETARY_CONTROL_OPTIONS.budget_type_code%TYPE ;

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

Line 970: From PA_BUDGETARY_CONTROL_OPTIONS PBCO ,

966: PBCO.Bdgt_cntrl_flag,
967: PBCO.gl_budget_version_id,
968: PBT.budget_amount_code,
969: BEM.entry_level_code
970: From PA_BUDGETARY_CONTROL_OPTIONS PBCO ,
971: PA_BUDGET_VERSIONS PBV,
972: PA_BUDGET_TYPES PBT,
973: PA_BUDGET_ENTRY_METHODS BEM
974: WHERE PBCO.Project_Id = p_project_id

Line 1076: from pa_budgetary_control_options cc

1072: If l_balance_type = 'E' then
1073: Begin
1074: select 'CC'
1075: into l_cc_budget_type_code
1076: from pa_budgetary_control_options cc
1077: where cc.project_id = p_project_id
1078: and cc.external_budget_code = 'CC';
1079: Exception
1080: When no_data_found then

Line 1508: from pa_budgetary_control_options

1504:
1505: BEGIN
1506: Select budget_type_code, encumbrance_type_id
1507: into l_cc_budget_type_code, l_cc_encumbrance_type_id
1508: from pa_budgetary_control_options
1509: where project_id = p_project_id
1510: and external_budget_code = 'CC' ;
1511: EXCEPTION
1512: WHEN NO_DATA_FOUND THEN

Line 2216: FROM PA_BUDGETARY_CONTROL_OPTIONS

2212: encumbrance_type_id,
2213: external_budget_code,
2214: balance_type,
2215: bdgt_cntrl_flag
2216: FROM PA_BUDGETARY_CONTROL_OPTIONS
2217: WHERE project_id = p_project_id
2218: AND ( ( p_calling_mode = 'STANDARD' AND
2219: ( nvl(external_budget_code,'-1') IN ('GL','-1') ) )
2220: OR

Line 2265: l_balance_type pa_budgetary_control_options.balance_type%TYPE ;

2261:
2262: l_encumbrance_type_id NUMBER ;
2263:
2264: l_budget_type_code pa_budget_versions.budget_type_code%TYPE ;
2265: l_balance_type pa_budgetary_control_options.balance_type%TYPE ;
2266: l_bdgt_cntrl_flag pa_budgetary_control_options.bdgt_cntrl_flag%TYPE ;
2267: l_external_budget_code pa_budgetary_control_options.external_budget_code%TYPE ;
2268: l_budget_version_id pa_budget_versions.budget_version_id%TYPE ;
2269: l_msg_index_out NUMBER;

Line 2266: l_bdgt_cntrl_flag pa_budgetary_control_options.bdgt_cntrl_flag%TYPE ;

2262: l_encumbrance_type_id NUMBER ;
2263:
2264: l_budget_type_code pa_budget_versions.budget_type_code%TYPE ;
2265: l_balance_type pa_budgetary_control_options.balance_type%TYPE ;
2266: l_bdgt_cntrl_flag pa_budgetary_control_options.bdgt_cntrl_flag%TYPE ;
2267: l_external_budget_code pa_budgetary_control_options.external_budget_code%TYPE ;
2268: l_budget_version_id pa_budget_versions.budget_version_id%TYPE ;
2269: l_msg_index_out NUMBER;
2270:

Line 2267: l_external_budget_code pa_budgetary_control_options.external_budget_code%TYPE ;

2263:
2264: l_budget_type_code pa_budget_versions.budget_type_code%TYPE ;
2265: l_balance_type pa_budgetary_control_options.balance_type%TYPE ;
2266: l_bdgt_cntrl_flag pa_budgetary_control_options.bdgt_cntrl_flag%TYPE ;
2267: l_external_budget_code pa_budgetary_control_options.external_budget_code%TYPE ;
2268: l_budget_version_id pa_budget_versions.budget_version_id%TYPE ;
2269: l_msg_index_out NUMBER;
2270:
2271: l_rel_status NUMBER;

Line 2507: FROM PA_BUDGETARY_CONTROL_OPTIONS PBA

2503: SELECT 'X'
2504: FROM DUAL
2505: WHERE EXISTS
2506: ( SELECT 'x'
2507: FROM PA_BUDGETARY_CONTROL_OPTIONS PBA
2508: WHERE PBA.project_id = p_project_id
2509: AND ( ( p_mode ='A' )
2510: OR
2511: ( p_mode <> 'A' AND

Line 2550: log_message('Inserting records in PA_BUDGETARY_CONTROL_OPTIONS table');

2546:
2547: x_return_status := FND_API.G_RET_STS_SUCCESS;
2548:
2549: log_message('Inside copy_budgetary_controls');
2550: log_message('Inserting records in PA_BUDGETARY_CONTROL_OPTIONS table');
2551: insert into PA_BUDGETARY_CONTROL_OPTIONS
2552: (
2553: PROJECT_TYPE,
2554: PROJECT_ID,

Line 2551: insert into PA_BUDGETARY_CONTROL_OPTIONS

2547: x_return_status := FND_API.G_RET_STS_SUCCESS;
2548:
2549: log_message('Inside copy_budgetary_controls');
2550: log_message('Inserting records in PA_BUDGETARY_CONTROL_OPTIONS table');
2551: insert into PA_BUDGETARY_CONTROL_OPTIONS
2552: (
2553: PROJECT_TYPE,
2554: PROJECT_ID,
2555: BALANCE_TYPE,

Line 2596: from PA_BUDGETARY_CONTROL_OPTIONS

2592: -1 ,
2593: SYSDATE ,
2594: -1 ,
2595: -1
2596: from PA_BUDGETARY_CONTROL_OPTIONS
2597: where PROJECT_ID = p_from_project_id;
2598:
2599: EXCEPTION
2600: WHEN NO_DATA_FOUND THEN

Line 2923: from PA_BUDGETARY_CONTROL_OPTIONS PBCO ,

2919: into g_balance_type,
2920: g_budget_amount_code,
2921: l_project_id,
2922: l_budget_type_code
2923: from PA_BUDGETARY_CONTROL_OPTIONS PBCO ,
2924: PA_BUDGET_VERSIONS PBV,
2925: PA_BUDGET_TYPES PBT
2926: where PBV.Budget_version_id = p_budget_version_id
2927: and PBCO.Budget_Type_Code = PBV.Budget_Type_Code