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_BUDGET_VERSIONS

Line 36: g_draft_bvid pa_budget_versions.budget_version_id%type;

32: g_packet_id pa_bc_packets.packet_id%TYPE;
33: g_msg_data VARCHAR2(1000);
34: g_procedure_name VARCHAR2(30);
35: g_debug_mode VARCHAR2(10);
36: g_draft_bvid pa_budget_versions.budget_version_id%type;
37: g_project_id pa_projects_all.project_id%type;
38: g_org_id pa_implementations_all.org_id%type; --Bug 6524116
39:
40: -- This is an autonomous procedure ...

Line 199: pa_budget_versions bv

195: --Bug 6524116
196: select segment1
197: into l_project_num
198: from pa_projects_all p,
199: pa_budget_versions bv
200: where p.project_id = bv.project_id
201: and bv.budget_version_id = p_budget_version_id;
202:
203: log_message('inserting into table IGC_CC_INTERFACE ..... ');

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 765: pa_budget_versions pbv

761: pa_budget_lines pb,
762: pa_resource_assignments pa,
763: pa_tasks pt,
764: pa_resource_list_members rm,
765: pa_budget_versions pbv
766: where pbv.budget_version_id = p_base_budget_version_id
767: and pa.resource_assignment_id = pb.resource_assignment_id
768: and pa.task_id = pt.task_id (+)
769: and pa.budget_version_id = pbv.budget_version_id

Line 909: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

905: l_dual_mode_acct_gen_failed EXCEPTION;
906: l_dual_bc_fc_failed EXCEPTION;
907: l_cbc_not_supported EXCEPTION;
908:
909: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
910: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
911: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
912: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
913: l_rebaseline_flag VARCHAR2(1);

Line 910: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

906: l_dual_bc_fc_failed EXCEPTION;
907: l_cbc_not_supported EXCEPTION;
908:
909: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
910: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
911: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
912: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
913: l_rebaseline_flag VARCHAR2(1);
914: l_cc_budget_type_code VARCHAR2(30) ;

Line 920: l_budget_type_code PA_BUDGET_VERSIONS.budget_type_code%TYPE ;

916:
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 ;

Line 953: PA_BUDGET_VERSIONS PBV,

949: SELECT sum(decode(nvl(PBL.burdened_cost,0),
950: 0,nvl(PBL.raw_cost,0),
951: PBL.burdened_cost))
952: FROM PA_BUDGET_LINES PBL,
953: PA_BUDGET_VERSIONS PBV,
954: PA_RESOURCE_ASSIGNMENTS PRA
955: WHERE PBV.project_id = p_project_id
956: AND PBV.budget_version_id = PRA.budget_version_id
957: AND PRA.resource_assignment_id = PBL.resource_assignment_id

Line 971: PA_BUDGET_VERSIONS PBV,

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
975: AND PBV.Budget_version_id = p_Budget_version_id

Line 1121: from pa_budget_versions pbv

1117:
1118: Begin
1119: Select 'Y'
1120: into g_cost_rebaseline_flag
1121: from pa_budget_versions pbv
1122: where pbv.project_id = p_project_id
1123: and pbv.budget_version_id <> p_budget_version_id -- not the current budget
1124: and pbv.budget_status_code = 'B'
1125: and pbv.budget_type_code = l_budget_type_code

Line 1235: from pa_budget_versions pbv

1231: Begin
1232:
1233: Select pbv.budget_version_id
1234: into l_draft_budget_version_id
1235: from pa_budget_versions pbv
1236: where pbv.project_id = p_project_id
1237: and pbv.budget_status_code = 'S' -- Changed from 'W' to 'S' (UT code fix)
1238: and pbv.budget_type_code = l_budget_type_code;
1239:

Line 1634: from pa_budget_versions

1630: -- ## 3.1 Check if CC Budget exists
1631:
1632: select budget_version_id
1633: into g_cc_current_bvid
1634: from pa_budget_versions
1635: where project_id = p_project_id
1636: and budget_type_code = l_cc_budget_type_code
1637: and budget_status_code = 'B'
1638: and current_flag ='Y';

Line 1783: from pa_budget_versions pbv

1779: Begin
1780:
1781: Select pbv.budget_version_id, budget_entry_method_code
1782: into l_cc_budget_version_id, l_cc_budget_entry_level_code
1783: from pa_budget_versions pbv
1784: where pbv.project_id = p_project_id
1785: and pbv.budget_type_code = l_cc_budget_type_code
1786: and pbv.budget_status_code = 'B'
1787: and pbv.current_flag = 'Y';

Line 2247: FROM PA_BUDGET_VERSIONS

2243: ( p_calling_mode = 'BUDGET' ) );
2244:
2245: CURSOR C_BUDGET_VERSION ( c_budget_type_code VARCHAR ) IS
2246: SELECT budget_version_id
2247: FROM PA_BUDGET_VERSIONS
2248: WHERE project_id = p_project_id
2249: AND budget_type_code = c_budget_type_code
2250: AND budget_status_code = 'B'
2251: AND version_number = (Select MAX(version_number)

Line 2252: FROM PA_BUDGET_VERSIONS

2248: WHERE project_id = p_project_id
2249: AND budget_type_code = c_budget_type_code
2250: AND budget_status_code = 'B'
2251: AND version_number = (Select MAX(version_number)
2252: FROM PA_BUDGET_VERSIONS
2253: WHERE project_id = p_project_id
2254: AND budget_type_code = c_budget_type_code
2255: AND budget_status_code = 'B' );
2256:

Line 2264: l_budget_type_code pa_budget_versions.budget_type_code%TYPE ;

2260:
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 ;

Line 2268: l_budget_version_id pa_budget_versions.budget_version_id%TYPE ;

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;
2272: BEGIN

Line 2784: l_prev_budget_version_id pa_budget_versions.budget_version_id%TYPE;

2780: p_budget_type_code IN VARCHAR2,
2781: p_curr_budget_status_code IN VARCHAR2)
2782: return NUMBER
2783: Is
2784: l_prev_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2785: Begin
2786: log_message('In function Get_previous_bvid');
2787: log_message('Value of p_curr_budget_status_code is '||p_curr_budget_status_code);
2788:

Line 2794: from pa_budget_versions

2790: -- Draft version is used during "check funds", so get the current
2791: -- baselined version for reversal
2792: Select budget_version_id
2793: into l_prev_budget_version_id
2794: from pa_budget_versions
2795: where project_id = p_project_id
2796: and budget_type_code = p_budget_type_code
2797: and budget_status_code = 'B'
2798: and current_flag = 'Y';

Line 2806: from pa_budget_versions

2802: -- baselined version for reversal
2803:
2804: Select MAX(budget_version_id)
2805: into l_prev_budget_version_id
2806: from pa_budget_versions
2807: where project_id = p_project_id
2808: and budget_type_code = p_budget_type_code
2809: and budget_status_code = 'B'
2810: and current_flag = 'N';

Line 2847: l_data_set_id pa_budget_versions.budget_version_id%TYPE;

2843: P_result_code OUT NOCOPY Varchar2)
2844: IS
2845: l_calling_module VARCHAR2(20);
2846: l_cc_calling_module VARCHAR2(20);
2847: l_data_set_id pa_budget_versions.budget_version_id%TYPE;
2848: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;
2849: l_project_id pa_projects_all.project_id%TYPE;
2850: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;
2851:

Line 2848: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;

2844: IS
2845: l_calling_module VARCHAR2(20);
2846: l_cc_calling_module VARCHAR2(20);
2847: l_data_set_id pa_budget_versions.budget_version_id%TYPE;
2848: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;
2849: l_project_id pa_projects_all.project_id%TYPE;
2850: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;
2851:
2852: l_return_status VARCHAR2(1);

Line 2850: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;

2846: l_cc_calling_module VARCHAR2(20);
2847: l_data_set_id pa_budget_versions.budget_version_id%TYPE;
2848: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;
2849: l_project_id pa_projects_all.project_id%TYPE;
2850: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;
2851:
2852: l_return_status VARCHAR2(1);
2853: l_msg_count NUMBER;
2854: l_msg_data VARCHAR2(4000);

Line 2924: PA_BUDGET_VERSIONS PBV,

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
2928: and PBCO.project_id = PBV.project_id

Line 3230: from pa_budget_versions pbv

3226: Begin
3227:
3228: Select pbv.budget_version_id
3229: into g_draft_bvid
3230: from pa_budget_versions pbv
3231: where pbv.project_id = g_project_id
3232: and pbv.budget_status_code = 'W'
3233: and pbv.budget_type_code = l_budget_type_code;
3234: