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

757: pa_budget_lines pb,
758: pa_resource_assignments pa,
759: pa_tasks pt,
760: pa_resource_list_members rm,
761: pa_budget_versions pbv
762: where pbv.budget_version_id = p_base_budget_version_id
763: and pa.resource_assignment_id = pb.resource_assignment_id
764: and pa.task_id = pt.task_id (+)
765: and pa.budget_version_id = pbv.budget_version_id

Line 905: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

901: l_dual_mode_acct_gen_failed EXCEPTION;
902: l_dual_bc_fc_failed EXCEPTION;
903: l_cbc_not_supported EXCEPTION;
904:
905: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
906: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
907: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
908: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
909: l_rebaseline_flag VARCHAR2(1);

Line 906: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

902: l_dual_bc_fc_failed EXCEPTION;
903: l_cbc_not_supported EXCEPTION;
904:
905: l_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
906: l_cc_draft_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
907: l_total_cc_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
908: l_total_gl_bdgt_amount PA_BUDGET_LINES.burdened_cost%TYPE ;
909: l_rebaseline_flag VARCHAR2(1);
910: l_cc_budget_type_code VARCHAR2(30) ;

Line 916: l_budget_type_code PA_BUDGET_VERSIONS.budget_type_code%TYPE ;

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

Line 947: PA_BUDGET_VERSIONS PBV,

943: SELECT sum(decode(nvl(PBL.burdened_cost,0),
944: 0,nvl(PBL.raw_cost,0),
945: PBL.burdened_cost))
946: FROM PA_BUDGET_LINES PBL,
947: PA_BUDGET_VERSIONS PBV,
948: PA_RESOURCE_ASSIGNMENTS PRA
949: WHERE PBV.project_id = p_project_id
950: AND PBV.budget_version_id = PRA.budget_version_id
951: AND PRA.resource_assignment_id = PBL.resource_assignment_id

Line 965: PA_BUDGET_VERSIONS PBV,

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

Line 1115: from pa_budget_versions pbv

1111:
1112: Begin
1113: Select 'Y'
1114: into g_cost_rebaseline_flag
1115: from pa_budget_versions pbv
1116: where pbv.project_id = p_project_id
1117: and pbv.budget_version_id <> p_budget_version_id -- not the current budget
1118: and pbv.budget_status_code = 'B'
1119: and pbv.budget_type_code = l_budget_type_code

Line 1221: from pa_budget_versions pbv

1217: Begin
1218:
1219: Select pbv.budget_version_id
1220: into l_draft_budget_version_id
1221: from pa_budget_versions pbv
1222: where pbv.project_id = p_project_id
1223: and pbv.budget_status_code = 'S' -- Changed from 'W' to 'S' (UT code fix)
1224: and pbv.budget_type_code = l_budget_type_code;
1225:

Line 1571: from pa_budget_versions

1567: -- ## 3.1 Check if CC Budget exists
1568:
1569: select budget_version_id
1570: into g_cc_current_bvid
1571: from pa_budget_versions
1572: where project_id = p_project_id
1573: and budget_type_code = l_cc_budget_type_code
1574: and budget_status_code = 'B'
1575: and current_flag ='Y';

Line 1712: from pa_budget_versions pbv

1708: Begin
1709:
1710: Select pbv.budget_version_id, budget_entry_method_code
1711: into l_cc_budget_version_id, l_cc_budget_entry_level_code
1712: from pa_budget_versions pbv
1713: where pbv.project_id = p_project_id
1714: and pbv.budget_type_code = l_cc_budget_type_code
1715: and pbv.budget_status_code = 'B'
1716: and pbv.current_flag = 'Y';

Line 2163: FROM PA_BUDGET_VERSIONS

2159: ( p_calling_mode = 'BUDGET' ) );
2160:
2161: CURSOR C_BUDGET_VERSION ( c_budget_type_code VARCHAR ) IS
2162: SELECT budget_version_id
2163: FROM PA_BUDGET_VERSIONS
2164: WHERE project_id = p_project_id
2165: AND budget_type_code = c_budget_type_code
2166: AND budget_status_code = 'B'
2167: AND version_number = (Select MAX(version_number)

Line 2168: FROM PA_BUDGET_VERSIONS

2164: WHERE project_id = p_project_id
2165: AND budget_type_code = c_budget_type_code
2166: AND budget_status_code = 'B'
2167: AND version_number = (Select MAX(version_number)
2168: FROM PA_BUDGET_VERSIONS
2169: WHERE project_id = p_project_id
2170: AND budget_type_code = c_budget_type_code
2171: AND budget_status_code = 'B' );
2172:

Line 2180: l_budget_type_code pa_budget_versions.budget_type_code%TYPE ;

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

Line 2184: l_budget_version_id pa_budget_versions.budget_version_id%TYPE ;

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

Line 2677: l_prev_budget_version_id pa_budget_versions.budget_version_id%TYPE;

2673: p_budget_type_code IN VARCHAR2,
2674: p_curr_budget_status_code IN VARCHAR2)
2675: return NUMBER
2676: Is
2677: l_prev_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2678: Begin
2679: log_message('In function Get_previous_bvid');
2680:
2681: If p_curr_budget_status_code = 'S' then

Line 2686: from pa_budget_versions

2682: -- Draft version is used during "check funds", so get the current
2683: -- baselined version for reversal
2684: Select budget_version_id
2685: into l_prev_budget_version_id
2686: from pa_budget_versions
2687: where project_id = p_project_id
2688: and budget_type_code = p_budget_type_code
2689: and budget_status_code = 'B'
2690: and current_flag = 'Y';

Line 2698: from pa_budget_versions

2694: -- baselined version for reversal
2695:
2696: Select MAX(budget_version_id)
2697: into l_prev_budget_version_id
2698: from pa_budget_versions
2699: where project_id = p_project_id
2700: and budget_type_code = p_budget_type_code
2701: and budget_status_code = 'B'
2702: and current_flag = 'N';

Line 2739: l_data_set_id pa_budget_versions.budget_version_id%TYPE;

2735: P_result_code OUT NOCOPY Varchar2)
2736: IS
2737: l_calling_module VARCHAR2(20);
2738: l_cc_calling_module VARCHAR2(20);
2739: l_data_set_id pa_budget_versions.budget_version_id%TYPE;
2740: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;
2741: l_project_id pa_projects_all.project_id%TYPE;
2742: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;
2743:

Line 2740: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;

2736: IS
2737: l_calling_module VARCHAR2(20);
2738: l_cc_calling_module VARCHAR2(20);
2739: l_data_set_id pa_budget_versions.budget_version_id%TYPE;
2740: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;
2741: l_project_id pa_projects_all.project_id%TYPE;
2742: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;
2743:
2744: l_return_status VARCHAR2(1);

Line 2742: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;

2738: l_cc_calling_module VARCHAR2(20);
2739: l_data_set_id pa_budget_versions.budget_version_id%TYPE;
2740: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;
2741: l_project_id pa_projects_all.project_id%TYPE;
2742: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;
2743:
2744: l_return_status VARCHAR2(1);
2745: l_msg_count NUMBER;
2746: l_msg_data VARCHAR2(4000);

Line 2816: PA_BUDGET_VERSIONS PBV,

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

Line 3122: from pa_budget_versions pbv

3118: Begin
3119:
3120: Select pbv.budget_version_id
3121: into g_draft_bvid
3122: from pa_budget_versions pbv
3123: where pbv.project_id = g_project_id
3124: and pbv.budget_status_code = 'W'
3125: and pbv.budget_type_code = l_budget_type_code;
3126: