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_PUB dependencies on PA_BUDGET_VERSIONS

Line 111: ,p_version_type IN pa_budget_versions.version_type%TYPE

107:
108: /*Parameters due fin plan model */
109: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
110: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
111: ,p_version_type IN pa_budget_versions.version_type%TYPE
112: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
113: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
115: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

Line 146: FROM pa_budget_versions

142: ,c_budget_type_code VARCHAR2 )
143: IS
144: SELECT budget_version_id
145: ,budget_status_code
146: FROM pa_budget_versions
147: WHERE project_id = c_project_id
148: AND budget_type_code = c_budget_type_code
149: AND budget_status_code IN ('W','S')
150: AND ci_id IS NULL; -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 159: FROM pa_budget_versions bv

155: --Cursor to lock the budget version .
156: CURSOR l_lock_old_budget_csr( c_budget_version_id NUMBER )
157: IS
158: SELECT 'x'
159: FROM pa_budget_versions bv
160: ,pa_resource_assignments ra
161: ,pa_budget_lines bl
162: WHERE bv.budget_version_id = c_budget_version_id
163: AND bv.budget_version_id = ra.budget_version_id (+)

Line 175: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

171: l_return_status VARCHAR2(1);
172:
173: l_project_id pa_projects_all.project_id%TYPE;
174: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
175: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
176: l_err_code NUMBER;
177: l_err_stage VARCHAR2(120);
178: l_err_stack VARCHAR2(630);
179: i NUMBER;

Line 202: l_pm_budget_reference pa_budget_versions.pm_budget_reference%type; --Bug 3231587

198: l_attribute12 VARCHAR2(150);
199: l_attribute13 VARCHAR2(150);
200: l_attribute14 VARCHAR2(150);
201: l_attribute15 VARCHAR2(150);
202: l_pm_budget_reference pa_budget_versions.pm_budget_reference%type; --Bug 3231587
203: l_change_reason_code pa_budget_versions.change_reason_code%type;
204: l_budget_version_name VARCHAR2(60);
205: l_budget_rlmid NUMBER;
206: l_budget_alias VARCHAR2(80); --bug 3711693

Line 203: l_change_reason_code pa_budget_versions.change_reason_code%type;

199: l_attribute13 VARCHAR2(150);
200: l_attribute14 VARCHAR2(150);
201: l_attribute15 VARCHAR2(150);
202: l_pm_budget_reference pa_budget_versions.pm_budget_reference%type; --Bug 3231587
203: l_change_reason_code pa_budget_versions.change_reason_code%type;
204: l_budget_version_name VARCHAR2(60);
205: l_budget_rlmid NUMBER;
206: l_budget_alias VARCHAR2(80); --bug 3711693
207:

Line 210: l_version_type pa_budget_versions.version_type%TYPE ;

206: l_budget_alias VARCHAR2(80); --bug 3711693
207:
208: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
209: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
210: l_version_type pa_budget_versions.version_type%TYPE ;
211: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
212: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
214: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

Line 262: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;

258: l_debug_level3 CONSTANT NUMBER := 3;
259: l_debug_level5 CONSTANT NUMBER := 5;
260: j NUMBER;
261: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
262: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
263: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
264: l_user_id NUMBER := 0;
265: l_resp_id NUMBER := 0;
266: l_using_resource_lists_flag VARCHAR2(1);

Line 263: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;

259: l_debug_level5 CONSTANT NUMBER := 5;
260: j NUMBER;
261: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
262: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
263: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
264: l_user_id NUMBER := 0;
265: l_resp_id NUMBER := 0;
266: l_using_resource_lists_flag VARCHAR2(1);
267: l_refresh_required_flag VARCHAR2(1) := NULL;

Line 270: -- l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE; --3569883

266: l_using_resource_lists_flag VARCHAR2(1);
267: l_refresh_required_flag VARCHAR2(1) := NULL;
268: l_request_id NUMBER(15) := NULL;
269: l_process_code VARCHAR2(30) := NULL;
270: -- l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE; --3569883
271: -- l_old_model VARCHAR2(1):=null; --3569883
272:
273: -- added for bug Bug 3986129: FP.M Web ADI Dev changes
274: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 278: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

274: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
275: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
276: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
277:
278: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
279:
280: l_cbs_enabled_project varchar2(1) :='N'; -- Added for CBS 16604257
281:
282: BEGIN

Line 924: -- SELECT pa_budget_versions_s.currval --because x_budget_version_id in procedure

920: END IF;
921:
922: -- Commenting out this select as the create draft now returns the id of hte
923: -- newly created version
924: -- SELECT pa_budget_versions_s.currval --because x_budget_version_id in procedure
925: -- INTO l_budget_version_id --PA_BUDGET_UTILS.create_draft returns nothing: BUG.
926: -- FROM SYS.DUAL;
927:
928: IF l_debug_mode = 'Y' THEN

Line 1153: from pa_budget_versions

1149: /** Bug 3709462
1150: --3569883 start
1151: select fin_plan_type_id
1152: into l_fp_type_id
1153: from pa_budget_versions
1154: where budget_version_id = l_budget_version_id;
1155:
1156: select DECODE(l_fp_type_id, null, 'Y','N') into l_old_model from dual;
1157: --3569883 end

Line 1220: UPDATE pa_budget_versions

1216:
1217: /*
1218: -- Not necessary now since the same is passed as parameters to create_draft
1219: --add the pm_budget_reference and pm_product_code to the just created budget
1220: UPDATE pa_budget_versions
1221: SET pm_budget_reference = p_pm_budget_reference
1222: , pm_product_code = p_pm_product_code
1223: WHERE budget_version_id = l_budget_version_id;
1224: */

Line 1593: from pa_budget_versions

1589: /** Bug 3709462
1590: --3569883 start
1591: select fin_plan_type_id
1592: into l_fp_type_id
1593: from pa_budget_versions
1594: where budget_version_id = l_budget_version_id;
1595:
1596: select DECODE(l_fp_type_id, null, 'Y','N') into l_old_model from dual;
1597: --3569883 end

Line 2069: into l_locked_by_person_id from pa_budget_versions

2065: -- Comment END
2066: -- Bug # 3507156 : Patchset M: B and F impact changes : AMG
2067:
2068: select locked_by_person_id
2069: into l_locked_by_person_id from pa_budget_versions
2070: where budget_version_id = l_CW_version_id;
2071:
2072: --Get the record version number of the current working version
2073: l_CW_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_CW_version_id);

Line 2285: --summarizing the totals in the table pa_budget_versions

2281: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2282: END IF;
2283:
2284:
2285: --summarizing the totals in the table pa_budget_versions
2286:
2287: /*Summarizing of totals should be done only in the buget model*/
2288: IF (p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR and p_budget_type_code IS NOT NULL) THEN
2289:

Line 2885: ,p_version_type IN pa_budget_versions.version_type%TYPE

2881:
2882: --Added the following parameters for changes in AMG due to finplan model
2883: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
2884: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2885: ,p_version_type IN pa_budget_versions.version_type%TYPE
2886: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2887: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2889: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

Line 3299: ,p_version_type IN pa_budget_versions.version_type%TYPE)

3295:
3296: --Parameters due to Fin Plan Model
3297: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3298: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3299: ,p_version_type IN pa_budget_versions.version_type%TYPE)
3300:
3301: IS
3302:
3303: CURSOR l_budget_types_csr

Line 3333: FROM pa_budget_versions

3329: ,c_budget_type_code VARCHAR2)
3330:
3331: IS
3332: SELECT budget_version_id
3333: FROM pa_budget_versions
3334: WHERE project_id = c_project_id
3335: AND budget_type_code = c_budget_type_code
3336: AND budget_status_code = 'W'
3337: AND ci_id IS NULL; -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 3349: FROM pa_budget_versions

3345: ,c_budget_type_code VARCHAR2 )
3346:
3347: IS
3348: SELECT budget_version_id
3349: FROM pa_budget_versions
3350: WHERE project_id = c_project_id
3351: AND budget_type_code = c_budget_type_code
3352: AND budget_status_code = 'B'
3353: AND ci_id IS NULL; -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 3368: pa_budget_versions v

3364: SELECT v.resource_list_id,
3365: t.project_type_class_code
3366: FROM pa_project_types t,
3367: pa_projects p,
3368: pa_budget_versions v
3369: WHERE v.budget_version_id = p_draft_version_id
3370: AND v.project_id = p.project_id
3371: AND p.project_type = t.project_type
3372: AND v.ci_id IS NULL; -- -- Added an extra clause v.ci_id IS NULL--Bug # 3507156

Line 3382: FROM pa_budget_versions

3378:
3379: CURSOR l_lock_budget_csr (p_budget_version_id NUMBER)
3380: IS
3381: SELECT 'x'
3382: FROM pa_budget_versions
3383: WHERE budget_version_id = p_budget_version_id
3384: AND ci_id IS NULL -- -- Added an extra clause ci_id IS NULL--Bug # 3507156
3385: FOR UPDATE NOWAIT;
3386:

Line 3396: l_mark_as_original pa_budget_versions.current_original_flag%TYPE;

3392: l_return_status VARCHAR2(1);
3393: l_project_id NUMBER;
3394:
3395: l_budget_version_id NUMBER;
3396: l_mark_as_original pa_budget_versions.current_original_flag%TYPE;
3397:
3398: l_err_code NUMBER;
3399: l_err_stage VARCHAR2(120);
3400: l_err_stack VARCHAR2(630);

Line 3442: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,

3438:
3439: -- Needed to get the version id and record version number of the original baselined version
3440: CURSOR l_orig_baselined_ver_csr
3441: (c_project_id pa_projects_all.project_id%TYPE,
3442: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
3443: c_version_type pa_budget_versions.version_type%TYPE)
3444: IS
3445: SELECT budget_version_id
3446: ,record_version_number

Line 3443: c_version_type pa_budget_versions.version_type%TYPE)

3439: -- Needed to get the version id and record version number of the original baselined version
3440: CURSOR l_orig_baselined_ver_csr
3441: (c_project_id pa_projects_all.project_id%TYPE,
3442: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
3443: c_version_type pa_budget_versions.version_type%TYPE)
3444: IS
3445: SELECT budget_version_id
3446: ,record_version_number
3447: FROM pa_budget_versions

Line 3447: FROM pa_budget_versions

3443: c_version_type pa_budget_versions.version_type%TYPE)
3444: IS
3445: SELECT budget_version_id
3446: ,record_version_number
3447: FROM pa_budget_versions
3448: WHERE project_id=c_project_id
3449: AND fin_plan_type_id=c_fin_plan_type_id
3450: AND version_type=c_version_type
3451: AND current_original_flag='Y'

Line 3473: l_version_type pa_budget_Versions.version_type%TYPE;

3469: l_debug_level2 CONSTANT NUMBER := 2;
3470: l_debug_level3 CONSTANT NUMBER := 3;
3471: l_debug_level4 CONSTANT NUMBER := 4;
3472: l_debug_level5 CONSTANT NUMBER := 5;
3473: l_version_type pa_budget_Versions.version_type%TYPE;
3474: l_security_ret_code VARCHAR2(1);
3475: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3476: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3477: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 3476: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;

3472: l_debug_level5 CONSTANT NUMBER := 5;
3473: l_version_type pa_budget_Versions.version_type%TYPE;
3474: l_security_ret_code VARCHAR2(1);
3475: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3476: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3477: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3478: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3479: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3480: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;

Line 3478: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;

3474: l_security_ret_code VARCHAR2(1);
3475: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3476: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3477: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3478: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3479: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3480: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;
3481: l_any_error_occurred_flag VARCHAR2(1);
3482: l_data VARCHAR2(2000);

Line 3479: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;

3475: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3476: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3477: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3478: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3479: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3480: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;
3481: l_any_error_occurred_flag VARCHAR2(1);
3482: l_data VARCHAR2(2000);
3483: l_msg_index_out NUMBER;

Line 3480: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;

3476: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3477: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3478: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3479: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3480: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;
3481: l_any_error_occurred_flag VARCHAR2(1);
3482: l_data VARCHAR2(2000);
3483: l_msg_index_out NUMBER;
3484: l_dummy VARCHAR2(1);

Line 3491: l_targ_request_id pa_budget_versions.request_id%TYPE;

3487: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3488: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3489: l_fc_version_created_flag VARCHAR2(1);
3490: l_final_plan_prc_code VARCHAR2(10);
3491: l_targ_request_id pa_budget_versions.request_id%TYPE;
3492: BEGIN
3493:
3494: --Standard begin of API savepoint
3495:

Line 4663: UPDATE pa_budget_versions

4659: -- by the baseliner as part of the workflow process.
4660:
4661: /* -- dbms_output.put_line('WORKFLOW USED...Update Draft to Submitted, IN_ROUTE'); */
4662:
4663: UPDATE pa_budget_versions
4664: SET budget_status_code = 'S', WF_status_code = 'IN_ROUTE'
4665: WHERE budget_version_id = l_curr_working_version_id;
4666:
4667: /* -- dbms_output.put_line('WORKFLOW USED...START_BUDGET_WF API'); */

Line 4724: UPDATE pa_budget_versions

4720:
4721: -- STRAIGHT BASELINE, NO Workflow
4722:
4723:
4724: UPDATE pa_budget_versions
4725: SET budget_status_code = 'S', WF_status_code = NULL
4726: WHERE budget_version_id = l_curr_working_version_id;
4727:
4728:

Line 4827: UPDATE pa_budget_versions

4823:
4824: -- after calling BASELINE, set the budget_status_code back to 'W' (Working)
4825: -- the concept of submitting budget is not available in the public API's!
4826:
4827: UPDATE pa_budget_versions
4828: SET budget_status_code = 'W'
4829: WHERE budget_version_id = l_curr_working_version_id;
4830:
4831: ELSE--Fin Plan Model. Call the baseline api in fin plan pub

Line 5181: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;

5177: l_project_id NUMBER := p_pa_project_id;
5178: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
5179: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
5180: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
5181: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
5182: l_budget_version_id NUMBER;
5183: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5184: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5185: l_budget_amount_code pa_budget_types.budget_amount_code%type;

Line 5190: l_record_version_number pa_budget_versions.record_version_number%TYPE;

5186: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5187: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5188: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5189: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5190: l_record_version_number pa_budget_versions.record_version_number%TYPE;
5191:
5192: l_resource_name VARCHAR2(80); --bug 3711693
5193:
5194: l_budget_lines_in budget_line_in_tbl_type;

Line 5477: --summarizing the totals in the table pa_budget_versions

5473:
5474: END IF;
5475:
5476:
5477: --summarizing the totals in the table pa_budget_versions
5478: PA_BUDGET_UTILS.summerize_project_totals
5479: ( x_budget_version_id => l_budget_version_id
5480: , x_err_code => l_err_code
5481: , x_err_stage => l_err_stage

Line 6142: ,p_version_number IN pa_budget_versions.version_number%TYPE

6138:
6139: -- Parameters required for Fin Plan Model
6140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
6141: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
6142: ,p_version_number IN pa_budget_versions.version_number%TYPE
6143: ,p_version_type IN pa_budget_versions.version_type%TYPE
6144: )
6145:
6146: IS

Line 6143: ,p_version_type IN pa_budget_versions.version_type%TYPE

6139: -- Parameters required for Fin Plan Model
6140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
6141: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
6142: ,p_version_number IN pa_budget_versions.version_number%TYPE
6143: ,p_version_type IN pa_budget_versions.version_type%TYPE
6144: )
6145:
6146: IS
6147:

Line 6153: FROM pa_budget_versions

6149: ( p_project_id NUMBER
6150: , p_budget_type_code VARCHAR2 )
6151: IS
6152: SELECT budget_version_id
6153: FROM pa_budget_versions
6154: WHERE project_id = p_project_id
6155: AND budget_type_code = p_budget_type_code
6156: AND budget_status_code = 'W'
6157: AND ci_id IS NULL; -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 6183: FROM pa_budget_versions bv

6179:
6180: CURSOR l_lock_budget_csr( p_budget_version_id NUMBER )
6181: IS
6182: SELECT 'x'
6183: FROM pa_budget_versions bv
6184: , pa_resource_assignments ra
6185: , pa_budget_lines bl
6186: WHERE bv.budget_version_id = p_budget_version_id
6187: AND bv.budget_version_id = ra.budget_version_id (+)

Line 6202: l_ci_id pa_budget_versions.ci_id%TYPE;

6198: l_err_stage VARCHAR2(120);
6199: l_err_stack VARCHAR2(630);
6200: l_dummy NUMBER :=0;
6201: l_budget_version_id NUMBER;
6202: l_ci_id pa_budget_versions.ci_id%TYPE;
6203: l_project_id NUMBER;
6204: l_budget_type_code VARCHAR2(30);
6205: l_msg_count NUMBER ;
6206: l_msg_data VARCHAR2(2000);

Line 6235: l_version_type pa_budget_versions.version_type%TYPE;

6231: l_debug_level3 CONSTANT NUMBER := 3;
6232: l_debug_level5 CONSTANT NUMBER := 5;
6233: l_security_ret_code VARCHAR2(1);
6234: l_fin_plan_type_id NUMBER;
6235: l_version_type pa_budget_versions.version_type%TYPE;
6236: l_proj_fp_options_id NUMBER;
6237: l_result VARCHAR2(1);
6238: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6239: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 6238: l_record_version_number pa_budget_versions.record_version_number%TYPE;

6234: l_fin_plan_type_id NUMBER;
6235: l_version_type pa_budget_versions.version_type%TYPE;
6236: l_proj_fp_options_id NUMBER;
6237: l_result VARCHAR2(1);
6238: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6239: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6240: --Added by Xin Liu. 28-APR-03
6241: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6242: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 6243: ll_version_type pa_budget_versions.version_type%TYPE;

6239: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6240: --Added by Xin Liu. 28-APR-03
6241: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6242: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6243: ll_version_type pa_budget_versions.version_type%TYPE;
6244: ll_version_number pa_budget_versions.version_number%TYPE;
6245:
6246: BEGIN
6247:

Line 6244: ll_version_number pa_budget_versions.version_number%TYPE;

6240: --Added by Xin Liu. 28-APR-03
6241: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6242: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6243: ll_version_type pa_budget_versions.version_type%TYPE;
6244: ll_version_number pa_budget_versions.version_number%TYPE;
6245:
6246: BEGIN
6247:
6248: -- Standard begin of API savepoint

Line 6974: --we do a dummy update in pa_budget_versions also for the

6970: AND gen_src_all_plan_version_id = l_budget_version_id;
6971: END IF;
6972:
6973: --if any record had been updated in pa_proj_fp_options then
6974: --we do a dummy update in pa_budget_versions also for the
6975: --budget version that is being updated to increase the record version number
6976: IF SQL%ROWCOUNT > 0 THEN
6977: UPDATE pa_budget_versions
6978: SET record_version_number = record_version_number + 1,

Line 6977: UPDATE pa_budget_versions

6973: --if any record had been updated in pa_proj_fp_options then
6974: --we do a dummy update in pa_budget_versions also for the
6975: --budget version that is being updated to increase the record version number
6976: IF SQL%ROWCOUNT > 0 THEN
6977: UPDATE pa_budget_versions
6978: SET record_version_number = record_version_number + 1,
6979: last_update_date = SYSDATE,
6980: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6981: last_update_login = FND_GLOBAL.LOGIN_ID

Line 7138: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

7134: ,p_return_status OUT NOCOPY VARCHAR2
7135: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7136: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7137: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7138: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7139: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7141: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7142: ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 7141: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

7137: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7138: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7139: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7141: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7142: ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7143: )
7144:
7145: IS

Line 7142: ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7138: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7139: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7141: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7142: ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7143: )
7144:
7145: IS
7146:

Line 7160: FROM pa_budget_versions

7156: IS
7157: SELECT budget_version_id
7158: ,current_flag
7159: ,current_original_flag
7160: FROM pa_budget_versions
7161: WHERE project_id = p_project_id
7162: AND budget_type_code = p_budget_type_code
7163: AND version_number = p_version_number
7164: AND budget_status_code = 'B';

Line 7180: FROM pa_budget_versions

7176: , p_version_type VARCHAR2
7177: , p_version_number NUMBER )
7178: IS
7179: SELECT budget_version_id
7180: FROM pa_budget_versions
7181: WHERE project_id = p_project_id
7182: AND fin_plan_type_id = p_fin_plan_type_id
7183: AND version_type = p_version_type
7184: AND version_number = p_version_number

Line 7240: l_record_version_number pa_budget_versions.record_version_number%TYPE;

7236: l_debug_level5 CONSTANT NUMBER := 5;
7237:
7238: l_security_ret_code VARCHAR2(1);
7239: l_function_name VARCHAR2(80);
7240: l_record_version_number pa_budget_versions.record_version_number%TYPE;
7241:
7242: l_project_id NUMBER;
7243: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
7244: l_budget_version_id NUMBER;

Line 7243: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

7239: l_function_name VARCHAR2(80);
7240: l_record_version_number pa_budget_versions.record_version_number%TYPE;
7241:
7242: l_project_id NUMBER;
7243: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
7244: l_budget_version_id NUMBER;
7245: l_fin_plan_type_id NUMBER;
7246: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;
7247: l_version_type pa_budget_versions.version_type%TYPE;

Line 7247: l_version_type pa_budget_versions.version_type%TYPE;

7243: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
7244: l_budget_version_id NUMBER;
7245: l_fin_plan_type_id NUMBER;
7246: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;
7247: l_version_type pa_budget_versions.version_type%TYPE;
7248: l_version_number NUMBER;
7249: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
7250:
7251: ll_fin_plan_type_id NUMBER; --Added for bug 13968843

Line 7887: --we do a dummy update in pa_budget_versions also for the

7883: AND gen_src_all_plan_version_id = l_budget_version_id;
7884: END IF;
7885:
7886: --if any record had been updated in pa_proj_fp_options then
7887: --we do a dummy update in pa_budget_versions also for the
7888: --budget version that is being updated to increase the record version number
7889: IF SQL%ROWCOUNT > 0 THEN
7890: UPDATE pa_budget_versions
7891: SET record_version_number = record_version_number + 1,

Line 7890: UPDATE pa_budget_versions

7886: --if any record had been updated in pa_proj_fp_options then
7887: --we do a dummy update in pa_budget_versions also for the
7888: --budget version that is being updated to increase the record version number
7889: IF SQL%ROWCOUNT > 0 THEN
7890: UPDATE pa_budget_versions
7891: SET record_version_number = record_version_number + 1,
7892: last_update_date = SYSDATE,
7893: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7894: last_update_login = FND_GLOBAL.LOGIN_ID

Line 8183: FROM pa_budget_versions bv,

8179: CURSOR budget_version_info_cur (c_budget_version_id IN NUMBER)
8180: IS
8181: SELECT pt.plan_class_code
8182: ,bv.etc_start_date
8183: FROM pa_budget_versions bv,
8184: pa_fin_plan_types_b pt
8185: WHERE bv.budget_version_id = c_budget_version_id
8186: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
8187:

Line 8189: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

8185: WHERE bv.budget_version_id = c_budget_version_id
8186: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
8187:
8188: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
8189: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
8190:
8191: i NUMBER := 0;
8192: l_dummy NUMBER;
8193:

Line 8207: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;

8203: l_project_id NUMBER := p_pa_project_id;
8204: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
8205: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
8206: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
8207: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
8208: l_budget_version_id NUMBER;
8209: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8210: l_resource_list_id NUMBER;
8211: l_budget_amount_code pa_budget_types.budget_amount_code%type;

Line 8839: --summarizing the totals in the table pa_budget_versions

8835: END IF;
8836:
8837: IF l_budget_type_code IS NOT NULL --old budgets model
8838: THEN
8839: --summarizing the totals in the table pa_budget_versions
8840: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id
8841: , x_err_code => l_err_code
8842: , x_err_stage => l_err_stage
8843: , x_err_stack => l_err_stack );

Line 9173: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9169: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9170: ,p_budget_lines_in IN budget_line_in_tbl_type
9171: ,p_budget_lines_out OUT NOCOPY budget_line_out_tbl_type
9172: --Added for the bug 3453650
9173: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9174: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9175: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9176: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9174: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9170: ,p_budget_lines_in IN budget_line_in_tbl_type
9171: ,p_budget_lines_out OUT NOCOPY budget_line_out_tbl_type
9172: --Added for the bug 3453650
9173: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9174: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9175: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9176: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650

Line 9175: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9171: ,p_budget_lines_out OUT NOCOPY budget_line_out_tbl_type
9172: --Added for the bug 3453650
9173: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9174: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9175: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9176: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 9176: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9172: --Added for the bug 3453650
9173: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9174: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9175: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9176: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9173: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9174: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9175: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9176: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650

9174: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9175: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9176: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9175: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9176: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9244: FROM pa_budget_versions

9240: , budget_entry_method_code
9241: , resource_list_id
9242: , change_reason_code
9243: , description
9244: FROM pa_budget_versions
9245: WHERE project_id = p_project_id
9246: AND budget_type_code = p_budget_type_code
9247: AND budget_status_code = 'W';
9248:

Line 9336: FROM pa_budget_versions bv

9332:
9333: CURSOR l_lock_budget_csr( p_budget_version_id NUMBER )
9334: IS
9335: SELECT 'x'
9336: FROM pa_budget_versions bv
9337: , pa_resource_assignments ra
9338: , pa_budget_lines bl
9339: WHERE bv.budget_version_id = p_budget_version_id
9340: AND bv.budget_version_id = ra.budget_version_id (+)

Line 9420: FROM PA_BUDGET_VERSIONS

9416: CURSOR l_budget_attrs_csr(p_budget_type_code VARCHAR2,p_project_id number)
9417: IS
9418: SELECT BUDGET_VERSION_ID,version_name,budget_entry_method_code,
9419: RESOURCE_LIST_ID,CHANGE_REASON_CODE,DESCRIPTION
9420: FROM PA_BUDGET_VERSIONS
9421: --WHERE VERSION_NAME=p_budget_version_number
9422: Where budget_type_code=p_budget_type_code
9423: and project_id = p_project_id
9424: and budget_status_code = 'W';

Line 9431: FROM PA_BUDGET_VERSIONS

9427: CURSOR l_finplan_attrs_csr(c_budget_version_id NUMBER)
9428: IS
9429: SELECT version_name,CURRENT_WORKING_FLAG,
9430: RESOURCE_LIST_ID,CHANGE_REASON_CODE,DESCRIPTION,version_type
9431: FROM PA_BUDGET_VERSIONS
9432: WHERE budget_version_id = c_budget_version_id;
9433:
9434: CURSOR l_finplan_type_name_csr(p_finplan_type_id NUMBER)
9435: IS

Line 9451: from pa_budget_versions

9447:
9448: CURSOR get_status_code_csr(p_budget_version_id NUMBER)
9449: IS
9450: select budget_status_code
9451: from pa_budget_versions
9452: where budget_version_id = p_budget_version_id;
9453:
9454: CURSOR l_finplan_line_csr
9455: (p_resource_assigment_id NUMBER

Line 9484: from pa_budget_versions

9480: attribute12,
9481: attribute13,
9482: attribute14,
9483: attribute15
9484: from pa_budget_versions
9485: where budget_version_id = p_budget_version_id;
9486: /*End of code for Bug 6417360*/
9487:
9488: l_budget_version_name pa_budget_versions.version_name%TYPE := null;

Line 9488: l_budget_version_name pa_budget_versions.version_name%TYPE := null;

9484: from pa_budget_versions
9485: where budget_version_id = p_budget_version_id;
9486: /*End of code for Bug 6417360*/
9487:
9488: l_budget_version_name pa_budget_versions.version_name%TYPE := null;
9489: l_fin_plan_type_id number;
9490: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9491: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9492: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;

Line 9491: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;

9487:
9488: l_budget_version_name pa_budget_versions.version_name%TYPE := null;
9489: l_fin_plan_type_id number;
9490: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9491: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9492: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9493: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9494: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9495:

Line 9492: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;

9488: l_budget_version_name pa_budget_versions.version_name%TYPE := null;
9489: l_fin_plan_type_id number;
9490: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9491: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9492: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9493: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9494: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9495:
9496: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

Line 9493: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

9489: l_fin_plan_type_id number;
9490: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9491: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9492: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9493: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9494: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9495:
9496: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
9497: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=null;

Line 9494: l_record_version_number pa_budget_versions.record_version_number%TYPE;

9490: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9491: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9492: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9493: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9494: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9495:
9496: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
9497: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=null;
9498: l_person_id per_all_people_f.person_id%TYPE;

Line 9502: l_version_type pa_budget_versions.version_type%TYPE;

9498: l_person_id per_all_people_f.person_id%TYPE;
9499: l_resource_id per_all_people_f.person_id%TYPE;
9500: l_baselined_version_id NUMBER;
9501: l_debug_mode VARCHAR2(1);
9502: l_version_type pa_budget_versions.version_type%TYPE;
9503: l_curr_work_version_id VARCHAR2(15);
9504: l_debug_level5 CONSTANT NUMBER :=5;
9505: l_baselined_Ver_options_id VARCHAR2(15);
9506: l_budget_lines_in budget_line_in_tbl_type;

Line 9517: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

9513: -- Bug Fix: 4569365. Removed MRC code.
9514: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
9515: l_calling_context VARCHAR2(30);
9516:
9517: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
9518:
9519: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9520: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9521: lx_version_type pa_budget_versions.version_type%TYPE := null;

Line 9519: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;

9515: l_calling_context VARCHAR2(30);
9516:
9517: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
9518:
9519: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9520: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9521: lx_version_type pa_budget_versions.version_type%TYPE := null;
9522: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;

Line 9520: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;

9516:
9517: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
9518:
9519: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9520: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9521: lx_version_type pa_budget_versions.version_type%TYPE := null;
9522: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;

Line 9521: lx_version_type pa_budget_versions.version_type%TYPE := null;

9517: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
9518:
9519: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9520: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9521: lx_version_type pa_budget_versions.version_type%TYPE := null;
9522: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

Line 9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;

9520: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9521: lx_version_type pa_budget_versions.version_type%TYPE := null;
9522: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9526: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9527: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9528: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

9521: lx_version_type pa_budget_versions.version_type%TYPE := null;
9522: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9526: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9527: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9528: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;
9529: lx_resource_list_name pa_resource_lists_all_bg.Name%TYPE := null;

Line 9526: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;

9522: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9526: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9527: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9528: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;
9529: lx_resource_list_name pa_resource_lists_all_bg.Name%TYPE := null;
9530: lx_raw_cost_flag VARCHAR2(1) ;

Line 9575: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;

9571: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9572: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9573: l_amg_project_number pa_projects_all.segment1%TYPE;
9574: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9575: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9576: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
9577: l_allow_qty_flag VARCHAR2(1);
9578: l_conv_attrs_to_be_validated VARCHAR2(30);
9579: l_is_rate_type_valid BOOLEAN;

Line 9576: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;

9572: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9573: l_amg_project_number pa_projects_all.segment1%TYPE;
9574: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9575: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9576: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
9577: l_allow_qty_flag VARCHAR2(1);
9578: l_conv_attrs_to_be_validated VARCHAR2(30);
9579: l_is_rate_type_valid BOOLEAN;
9580: l_call_validate_curr_api_flg VARCHAR2(1);

Line 9600: l_attribute_category pa_budget_versions.attribute_category%type;

9596: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9597:
9598:
9599: /*Added local variables for Bug 6417360*/
9600: l_attribute_category pa_budget_versions.attribute_category%type;
9601: l_attribute1 pa_budget_versions.attribute1%type;
9602: l_attribute2 pa_budget_versions.attribute2%type;
9603: l_attribute3 pa_budget_versions.attribute3%type;
9604: l_attribute4 pa_budget_versions.attribute4%type;

Line 9601: l_attribute1 pa_budget_versions.attribute1%type;

9597:
9598:
9599: /*Added local variables for Bug 6417360*/
9600: l_attribute_category pa_budget_versions.attribute_category%type;
9601: l_attribute1 pa_budget_versions.attribute1%type;
9602: l_attribute2 pa_budget_versions.attribute2%type;
9603: l_attribute3 pa_budget_versions.attribute3%type;
9604: l_attribute4 pa_budget_versions.attribute4%type;
9605: l_attribute5 pa_budget_versions.attribute5%type;

Line 9602: l_attribute2 pa_budget_versions.attribute2%type;

9598:
9599: /*Added local variables for Bug 6417360*/
9600: l_attribute_category pa_budget_versions.attribute_category%type;
9601: l_attribute1 pa_budget_versions.attribute1%type;
9602: l_attribute2 pa_budget_versions.attribute2%type;
9603: l_attribute3 pa_budget_versions.attribute3%type;
9604: l_attribute4 pa_budget_versions.attribute4%type;
9605: l_attribute5 pa_budget_versions.attribute5%type;
9606: l_attribute6 pa_budget_versions.attribute6%type;

Line 9603: l_attribute3 pa_budget_versions.attribute3%type;

9599: /*Added local variables for Bug 6417360*/
9600: l_attribute_category pa_budget_versions.attribute_category%type;
9601: l_attribute1 pa_budget_versions.attribute1%type;
9602: l_attribute2 pa_budget_versions.attribute2%type;
9603: l_attribute3 pa_budget_versions.attribute3%type;
9604: l_attribute4 pa_budget_versions.attribute4%type;
9605: l_attribute5 pa_budget_versions.attribute5%type;
9606: l_attribute6 pa_budget_versions.attribute6%type;
9607: l_attribute7 pa_budget_versions.attribute7%type;

Line 9604: l_attribute4 pa_budget_versions.attribute4%type;

9600: l_attribute_category pa_budget_versions.attribute_category%type;
9601: l_attribute1 pa_budget_versions.attribute1%type;
9602: l_attribute2 pa_budget_versions.attribute2%type;
9603: l_attribute3 pa_budget_versions.attribute3%type;
9604: l_attribute4 pa_budget_versions.attribute4%type;
9605: l_attribute5 pa_budget_versions.attribute5%type;
9606: l_attribute6 pa_budget_versions.attribute6%type;
9607: l_attribute7 pa_budget_versions.attribute7%type;
9608: l_attribute8 pa_budget_versions.attribute8%type;

Line 9605: l_attribute5 pa_budget_versions.attribute5%type;

9601: l_attribute1 pa_budget_versions.attribute1%type;
9602: l_attribute2 pa_budget_versions.attribute2%type;
9603: l_attribute3 pa_budget_versions.attribute3%type;
9604: l_attribute4 pa_budget_versions.attribute4%type;
9605: l_attribute5 pa_budget_versions.attribute5%type;
9606: l_attribute6 pa_budget_versions.attribute6%type;
9607: l_attribute7 pa_budget_versions.attribute7%type;
9608: l_attribute8 pa_budget_versions.attribute8%type;
9609: l_attribute9 pa_budget_versions.attribute9%type;

Line 9606: l_attribute6 pa_budget_versions.attribute6%type;

9602: l_attribute2 pa_budget_versions.attribute2%type;
9603: l_attribute3 pa_budget_versions.attribute3%type;
9604: l_attribute4 pa_budget_versions.attribute4%type;
9605: l_attribute5 pa_budget_versions.attribute5%type;
9606: l_attribute6 pa_budget_versions.attribute6%type;
9607: l_attribute7 pa_budget_versions.attribute7%type;
9608: l_attribute8 pa_budget_versions.attribute8%type;
9609: l_attribute9 pa_budget_versions.attribute9%type;
9610: l_attribute10 pa_budget_versions.attribute10%type;

Line 9607: l_attribute7 pa_budget_versions.attribute7%type;

9603: l_attribute3 pa_budget_versions.attribute3%type;
9604: l_attribute4 pa_budget_versions.attribute4%type;
9605: l_attribute5 pa_budget_versions.attribute5%type;
9606: l_attribute6 pa_budget_versions.attribute6%type;
9607: l_attribute7 pa_budget_versions.attribute7%type;
9608: l_attribute8 pa_budget_versions.attribute8%type;
9609: l_attribute9 pa_budget_versions.attribute9%type;
9610: l_attribute10 pa_budget_versions.attribute10%type;
9611: l_attribute11 pa_budget_versions.attribute11%type;

Line 9608: l_attribute8 pa_budget_versions.attribute8%type;

9604: l_attribute4 pa_budget_versions.attribute4%type;
9605: l_attribute5 pa_budget_versions.attribute5%type;
9606: l_attribute6 pa_budget_versions.attribute6%type;
9607: l_attribute7 pa_budget_versions.attribute7%type;
9608: l_attribute8 pa_budget_versions.attribute8%type;
9609: l_attribute9 pa_budget_versions.attribute9%type;
9610: l_attribute10 pa_budget_versions.attribute10%type;
9611: l_attribute11 pa_budget_versions.attribute11%type;
9612: l_attribute12 pa_budget_versions.attribute12%type;

Line 9609: l_attribute9 pa_budget_versions.attribute9%type;

9605: l_attribute5 pa_budget_versions.attribute5%type;
9606: l_attribute6 pa_budget_versions.attribute6%type;
9607: l_attribute7 pa_budget_versions.attribute7%type;
9608: l_attribute8 pa_budget_versions.attribute8%type;
9609: l_attribute9 pa_budget_versions.attribute9%type;
9610: l_attribute10 pa_budget_versions.attribute10%type;
9611: l_attribute11 pa_budget_versions.attribute11%type;
9612: l_attribute12 pa_budget_versions.attribute12%type;
9613: l_attribute13 pa_budget_versions.attribute13%type;

Line 9610: l_attribute10 pa_budget_versions.attribute10%type;

9606: l_attribute6 pa_budget_versions.attribute6%type;
9607: l_attribute7 pa_budget_versions.attribute7%type;
9608: l_attribute8 pa_budget_versions.attribute8%type;
9609: l_attribute9 pa_budget_versions.attribute9%type;
9610: l_attribute10 pa_budget_versions.attribute10%type;
9611: l_attribute11 pa_budget_versions.attribute11%type;
9612: l_attribute12 pa_budget_versions.attribute12%type;
9613: l_attribute13 pa_budget_versions.attribute13%type;
9614: l_attribute14 pa_budget_versions.attribute14%type;

Line 9611: l_attribute11 pa_budget_versions.attribute11%type;

9607: l_attribute7 pa_budget_versions.attribute7%type;
9608: l_attribute8 pa_budget_versions.attribute8%type;
9609: l_attribute9 pa_budget_versions.attribute9%type;
9610: l_attribute10 pa_budget_versions.attribute10%type;
9611: l_attribute11 pa_budget_versions.attribute11%type;
9612: l_attribute12 pa_budget_versions.attribute12%type;
9613: l_attribute13 pa_budget_versions.attribute13%type;
9614: l_attribute14 pa_budget_versions.attribute14%type;
9615: l_attribute15 pa_budget_versions.attribute15%type;

Line 9612: l_attribute12 pa_budget_versions.attribute12%type;

9608: l_attribute8 pa_budget_versions.attribute8%type;
9609: l_attribute9 pa_budget_versions.attribute9%type;
9610: l_attribute10 pa_budget_versions.attribute10%type;
9611: l_attribute11 pa_budget_versions.attribute11%type;
9612: l_attribute12 pa_budget_versions.attribute12%type;
9613: l_attribute13 pa_budget_versions.attribute13%type;
9614: l_attribute14 pa_budget_versions.attribute14%type;
9615: l_attribute15 pa_budget_versions.attribute15%type;
9616:

Line 9613: l_attribute13 pa_budget_versions.attribute13%type;

9609: l_attribute9 pa_budget_versions.attribute9%type;
9610: l_attribute10 pa_budget_versions.attribute10%type;
9611: l_attribute11 pa_budget_versions.attribute11%type;
9612: l_attribute12 pa_budget_versions.attribute12%type;
9613: l_attribute13 pa_budget_versions.attribute13%type;
9614: l_attribute14 pa_budget_versions.attribute14%type;
9615: l_attribute15 pa_budget_versions.attribute15%type;
9616:
9617: l_validate_status varchar2(1);

Line 9614: l_attribute14 pa_budget_versions.attribute14%type;

9610: l_attribute10 pa_budget_versions.attribute10%type;
9611: l_attribute11 pa_budget_versions.attribute11%type;
9612: l_attribute12 pa_budget_versions.attribute12%type;
9613: l_attribute13 pa_budget_versions.attribute13%type;
9614: l_attribute14 pa_budget_versions.attribute14%type;
9615: l_attribute15 pa_budget_versions.attribute15%type;
9616:
9617: l_validate_status varchar2(1);
9618: /*End of code for Bug 6417360*/

Line 9615: l_attribute15 pa_budget_versions.attribute15%type;

9611: l_attribute11 pa_budget_versions.attribute11%type;
9612: l_attribute12 pa_budget_versions.attribute12%type;
9613: l_attribute13 pa_budget_versions.attribute13%type;
9614: l_attribute14 pa_budget_versions.attribute14%type;
9615: l_attribute15 pa_budget_versions.attribute15%type;
9616:
9617: l_validate_status varchar2(1);
9618: /*End of code for Bug 6417360*/
9619:

Line 10009: l_statement := ' UPDATE PA_BUDGET_VERSIONS SET ';

10005:
10006: /* -- Changes made by Xin Liu for using of SQL BIND VARIABLE 12-MAY-2003 */
10007: --building the dynamic SQL statement
10008:
10009: l_statement := ' UPDATE PA_BUDGET_VERSIONS SET ';
10010:
10011: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_description IS NULL)
10012: AND nvl(p_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> nvl(l_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
10013: THEN

Line 10116: --Validate PA_BUDGET_VERSIONS_DESC_FLEX

10112: l_attribute14,
10113: l_attribute15;
10114: close c_dff_values;
10115:
10116: --Validate PA_BUDGET_VERSIONS_DESC_FLEX
10117:
10118: -- 6188316 Adding double quotes for all 15 attributes and category values being appended to Update Query String
10119:
10120: if ((p_attribute_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 10385: p_desc_flex_name => 'PA_BUDGET_VERSIONS_DESC_FLEX'

10381: dbms_output.put_line('l_attribute15 '||l_attribute15);*/
10382:
10383:
10384: pa_task_utils.validate_flex_fields(
10385: p_desc_flex_name => 'PA_BUDGET_VERSIONS_DESC_FLEX'
10386: ,p_attribute_category => l_attribute_category
10387: ,p_attribute1 => l_attribute1
10388: ,p_attribute2 => l_attribute2
10389: ,p_attribute3 => l_attribute3

Line 12658: --summarizing the totals in the table pa_budget_versions

12654: IF p_multiple_task_msg = 'F' THEN
12655: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12656: END IF;
12657:
12658: --summarizing the totals in the table pa_budget_versions
12659: /*Added the below if condition for the bug 3453650*/
12660: IF l_budget_type_code IS NOT NULL THEN
12661:
12662: -- check for overlapping dates

Line 12892: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12888: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12889: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12890: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12891: --Added for the bug 3453650
12892: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12893: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12894: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12895: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12893: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12889: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12890: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12891: --Added for the bug 3453650
12892: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12893: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12894: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12895: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 12894: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12890: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12891: --Added for the bug 3453650
12892: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12893: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12894: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12895: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12895: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12891: --Added for the bug 3453650
12892: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12893: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12894: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12895: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12892: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12893: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12894: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12895: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12893: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12894: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12895: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12896: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12897: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12898: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13260: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;

13256: l_project_id NUMBER := p_pa_project_id;
13257: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
13258: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
13259: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
13260: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
13261: l_budget_version_id NUMBER;
13262: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13263: l_resource_list_id NUMBER;
13264: l_budget_amount_code pa_budget_types.budget_amount_code%type;

Line 13269: l_record_version_number pa_budget_versions.record_version_number%TYPE;

13265: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13266: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13267: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13268: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13269: l_record_version_number pa_budget_versions.record_version_number%TYPE;
13270:
13271: l_budget_lines_in budget_line_in_tbl_type;
13272: l_budget_lines_out_tbl budget_line_out_tbl_type;
13273: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 13917: --summarizing the totals in the table pa_budget_versions

13913: THEN
13914: RAISE FND_API.G_EXC_ERROR;
13915: END IF;
13916:
13917: --summarizing the totals in the table pa_budget_versions
13918: PA_BUDGET_UTILS.summerize_project_totals
13919: (x_budget_version_id => l_budget_version_id
13920: ,x_err_code => l_err_code
13921: ,x_err_stage => l_err_stage

Line 14326: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

14322: ,p_calc_revenue_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14323: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14324: ,p_calc_budget_lines_out OUT NOCOPY calc_budget_line_out_tbl_type
14325: -- Bug 2863564 Parameters added for new Fin Plan Model
14326: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14327: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14328: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14329: ,p_version_type IN pa_budget_versions.version_type%TYPE
14330: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE

Line 14329: ,p_version_type IN pa_budget_versions.version_type%TYPE

14325: -- Bug 2863564 Parameters added for new Fin Plan Model
14326: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14327: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14328: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14329: ,p_version_type IN pa_budget_versions.version_type%TYPE
14330: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
14331: ) IS
14332:
14333: CURSOR l_budget_type_csr

Line 14330: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE

14326: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14327: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14328: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14329: ,p_version_type IN pa_budget_versions.version_type%TYPE
14330: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
14331: ) IS
14332:
14333: CURSOR l_budget_type_csr
14334: (p_budget_type_code VARCHAR2 )

Line 14432: FROM pa_budget_versions v

14428: /* added for 2207723 */
14429: CURSOR l_get_entry_level_csr (c_budget_version_id IN NUMBER)
14430: IS
14431: SELECT m.entry_level_code
14432: FROM pa_budget_versions v
14433: ,pa_budget_entry_methods m
14434: WHERE v.budget_version_id = c_budget_version_id
14435: AND v.budget_entry_method_code = m.budget_entry_method_code
14436: AND v.ci_id IS NULL; -- -- Added an extra clause v.ci_id IS NULL--Bug # 3507156

Line 14482: l_version_type pa_budget_versions.version_type%TYPE;

14478: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14479: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14480: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14481:
14482: l_version_type pa_budget_versions.version_type%TYPE;
14483: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14484: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14485: l_ci_id pa_budget_versions.ci_id%TYPE;
14486:

Line 14483: l_record_version_number pa_budget_versions.record_version_number%TYPE;

14479: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14480: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14481:
14482: l_version_type pa_budget_versions.version_type%TYPE;
14483: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14484: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14485: l_ci_id pa_budget_versions.ci_id%TYPE;
14486:
14487: l_debug_mode VARCHAR2(30):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 14484: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

14480: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14481:
14482: l_version_type pa_budget_versions.version_type%TYPE;
14483: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14484: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14485: l_ci_id pa_budget_versions.ci_id%TYPE;
14486:
14487: l_debug_mode VARCHAR2(30):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
14488: l_debug_level3 CONSTANT NUMBER := 3;

Line 14485: l_ci_id pa_budget_versions.ci_id%TYPE;

14481:
14482: l_version_type pa_budget_versions.version_type%TYPE;
14483: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14484: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14485: l_ci_id pa_budget_versions.ci_id%TYPE;
14486:
14487: l_debug_mode VARCHAR2(30):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
14488: l_debug_level3 CONSTANT NUMBER := 3;
14489: l_debug_level5 CONSTANT NUMBER := 5;

Line 14498: ll_version_type pa_budget_versions.version_type%TYPE;

14494:
14495:
14496: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14497: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14498: ll_version_type pa_budget_versions.version_type%TYPE;
14499: ll_version_number pa_budget_versions.version_number%TYPE;
14500: --needed to get the field values associated to a AMG message
14501:
14502: --Added baseline_funding flag and querying from pa_projects_all and not from pa_projects

Line 14499: ll_version_number pa_budget_versions.version_number%TYPE;

14495:
14496: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14497: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14498: ll_version_type pa_budget_versions.version_type%TYPE;
14499: ll_version_number pa_budget_versions.version_number%TYPE;
14500: --needed to get the field values associated to a AMG message
14501:
14502: --Added baseline_funding flag and querying from pa_projects_all and not from pa_projects
14503: CURSOR l_amg_project_csr

Line 14542: FROM pa_budget_versions bv,

14538: ,pt.plan_class_code
14539: ,bv.etc_start_date
14540: ,nvl(bv.wp_version_flag,'N') wp_version_flag
14541: ,bv.plan_processing_code
14542: FROM pa_budget_versions bv,
14543: pa_fin_plan_types_vl pt
14544: WHERE bv.budget_version_id = c_budget_version_id
14545: AND pt.fin_plan_type_id(+) = bv.fin_plan_type_id
14546: AND bv.ci_id IS NULL; -- -- Added an extra clause bv.ci_id IS NULL--Bug # 3507156

Line 14552: c_project_id pa_budget_versions.project_id%TYPE

14548:
14549: budget_version_info_rec budget_version_info_cur%ROWTYPE;
14550:
14551: CURSOR draft_version_cur(
14552: c_project_id pa_budget_versions.project_id%TYPE
14553: ,c_budget_type_code pa_budget_versions.budget_type_code%TYPE)
14554: IS
14555: SELECT budget_version_id
14556: FROM pa_budget_versions

Line 14553: ,c_budget_type_code pa_budget_versions.budget_type_code%TYPE)

14549: budget_version_info_rec budget_version_info_cur%ROWTYPE;
14550:
14551: CURSOR draft_version_cur(
14552: c_project_id pa_budget_versions.project_id%TYPE
14553: ,c_budget_type_code pa_budget_versions.budget_type_code%TYPE)
14554: IS
14555: SELECT budget_version_id
14556: FROM pa_budget_versions
14557: WHERE project_id = c_project_id

Line 14556: FROM pa_budget_versions

14552: c_project_id pa_budget_versions.project_id%TYPE
14553: ,c_budget_type_code pa_budget_versions.budget_type_code%TYPE)
14554: IS
14555: SELECT budget_version_id
14556: FROM pa_budget_versions
14557: WHERE project_id = c_project_id
14558: AND budget_type_code = c_budget_type_code
14559: AND budget_status_code = 'W'
14560: AND ci_id IS NULL; -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 14594: l_targ_request_id pa_budget_versions.request_id%TYPE;

14590:
14591: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
14592: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
14593: l_bdgt_lines_skip_flag varchar2(1);
14594: l_targ_request_id pa_budget_versions.request_id%TYPE;
14595:
14596: --This variable will be used to call pa_resource_asgn_curr maintenance api - IPM Arch Enhancement
14597: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
14598:

Line 16522: --Summarizing the totals in the table pa_budget_versions

16518: END IF;
16519: RAISE FND_API.G_EXC_ERROR;
16520: END IF;
16521: */
16522: --Summarizing the totals in the table pa_budget_versions
16523:
16524: PA_BUDGET_UTILS.summerize_project_totals
16525: (x_budget_version_id => l_budget_version_id,
16526: x_err_code => l_err_code,

Line 16976: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

16972: ,p_calc_burdened_cost_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16973: ,p_calc_revenue_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16974: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16975: -- Bug 2863564 Parameters required for new Fin Plan Model
16976: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16977: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16978: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16979: ,p_version_type IN pa_budget_versions.version_type%TYPE
16980: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE

Line 16979: ,p_version_type IN pa_budget_versions.version_type%TYPE

16975: -- Bug 2863564 Parameters required for new Fin Plan Model
16976: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16977: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16978: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16979: ,p_version_type IN pa_budget_versions.version_type%TYPE
16980: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
16981: ) IS
16982:
16983: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Calculate_Amounts';

Line 16980: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE

16976: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16977: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16978: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16979: ,p_version_type IN pa_budget_versions.version_type%TYPE
16980: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
16981: ) IS
16982:
16983: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Calculate_Amounts';
16984: --Bug 2863564 l_return_status VARCHAR2(1);

Line 17366: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17362: PROCEDURE CREATE_DRAFT_FINPLAN
17363: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17364: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17365: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
17366: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17367: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17368: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17369: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 17367: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17363: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17364: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17365: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
17366: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17367: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17368: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17369: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17369: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

17365: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
17366: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17367: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17368: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17369: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

17366: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17367: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17368: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17369: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17374: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17368: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17369: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17374: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17374: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17377: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17378: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17378: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17374: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17377: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17378: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17377: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17378: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17383: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17376: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17377: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17378: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17379: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17380: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17381: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17382: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17383: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17384: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17391: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17387: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17388: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17389: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
17390: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab
17391: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17392: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17393: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17394: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17392: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17388: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17389: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
17390: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab
17391: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17392: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17393: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17394: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17393: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17389: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
17390: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab
17391: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17392: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17393: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17394: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17394: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17390: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab
17391: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17392: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17393: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17394: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17391: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17392: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17393: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17394: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17392: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17393: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17394: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17393: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17394: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17394: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17395: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17403: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17396: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17403: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17404: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17397: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17403: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17404: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17405: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17398: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17403: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17404: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17405: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17406: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17403: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17399: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17403: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17404: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17405: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17406: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17407: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 17404: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17400: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17403: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17404: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17405: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17406: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17407: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
17408: ,x_return_status OUT NOCOPY VARCHAR2

Line 17405: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17401: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17403: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17404: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17405: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17406: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17407: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
17408: ,x_return_status OUT NOCOPY VARCHAR2
17409: ,x_msg_count OUT NOCOPY NUMBER

Line 17406: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17402: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17403: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17404: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17405: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17406: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17407: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
17408: ,x_return_status OUT NOCOPY VARCHAR2
17409: ,x_msg_count OUT NOCOPY NUMBER
17410: ,x_msg_data OUT NOCOPY VARCHAR2

Line 17418: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

17414:
17415: /* SCALAR VARIABLES */
17416: l_task_number pa_tasks.task_number%TYPE;
17417: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17418: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17419: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17420: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17421: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17422: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 17419: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;

17415: /* SCALAR VARIABLES */
17416: l_task_number pa_tasks.task_number%TYPE;
17417: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17418: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17419: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17420: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17421: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17422: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17423: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 17425: l_created_version_id pa_budget_versions.budget_version_id%TYPE;

17421: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17422: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17423: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17424: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17425: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17426: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17427: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
17428: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
17429: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

Line 17435: l_record_version_number pa_budget_versions.record_version_number%TYPE;

17431: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE := PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT;
17432: l_calling_context VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT;
17433:
17434: l_plan_tran_context VARCHAR2(30);
17435: l_record_version_number pa_budget_versions.record_version_number%TYPE;
17436: l_mixed_resource_planned_flag VARCHAR2(1);
17437: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17438: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17439: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 17438: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;

17434: l_plan_tran_context VARCHAR2(30);
17435: l_record_version_number pa_budget_versions.record_version_number%TYPE;
17436: l_mixed_resource_planned_flag VARCHAR2(1);
17437: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17438: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17439: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17440: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17441:
17442: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

Line 17439: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;

17435: l_record_version_number pa_budget_versions.record_version_number%TYPE;
17436: l_mixed_resource_planned_flag VARCHAR2(1);
17437: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17438: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17439: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17440: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17441:
17442: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17443: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;

Line 17440: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;

17436: l_mixed_resource_planned_flag VARCHAR2(1);
17437: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17438: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17439: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17440: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17441:
17442: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17443: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17444: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;

Line 17446: l_description PA_BUDGET_VERSIONS.description%Type;

17442: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17443: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17444: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17445:
17446: l_description PA_BUDGET_VERSIONS.description%Type;
17447: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17448: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17449: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17447: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;

17443: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17444: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17445:
17446: l_description PA_BUDGET_VERSIONS.description%Type;
17447: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17448: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17449: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17448: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;

17444: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17445:
17446: l_description PA_BUDGET_VERSIONS.description%Type;
17447: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17448: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17449: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17449: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;

17445:
17446: l_description PA_BUDGET_VERSIONS.description%Type;
17447: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17448: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17449: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;

17446: l_description PA_BUDGET_VERSIONS.description%Type;
17447: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17448: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17449: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;

17447: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17448: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17449: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;

17448: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17449: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;

17449: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;

17450: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;

17451: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;

17452: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;

17453: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;

17454: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;

17455: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17463: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;

Line 17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;

17456: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17463: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17464: l_change_reason_code pa_budget_versions.change_reason_code%type;

Line 17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;

17457: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17463: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17464: l_change_reason_code pa_budget_versions.change_reason_code%type;
17465: l_budget_version_name pa_budget_versions.version_name%type;

Line 17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;

17458: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17463: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17464: l_change_reason_code pa_budget_versions.change_reason_code%type;
17465: l_budget_version_name pa_budget_versions.version_name%type;
17466: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;

Line 17463: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;

17459: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17463: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17464: l_change_reason_code pa_budget_versions.change_reason_code%type;
17465: l_budget_version_name pa_budget_versions.version_name%type;
17466: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17467: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;

Line 17464: l_change_reason_code pa_budget_versions.change_reason_code%type;

17460: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17463: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17464: l_change_reason_code pa_budget_versions.change_reason_code%type;
17465: l_budget_version_name pa_budget_versions.version_name%type;
17466: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17467: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17468: l_version_type pa_budget_versions.version_type%TYPE ;

Line 17465: l_budget_version_name pa_budget_versions.version_name%type;

17461: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17463: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17464: l_change_reason_code pa_budget_versions.change_reason_code%type;
17465: l_budget_version_name pa_budget_versions.version_name%type;
17466: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17467: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17468: l_version_type pa_budget_versions.version_type%TYPE ;
17469: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;

Line 17468: l_version_type pa_budget_versions.version_type%TYPE ;

17464: l_change_reason_code pa_budget_versions.change_reason_code%type;
17465: l_budget_version_name pa_budget_versions.version_name%type;
17466: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17467: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17468: l_version_type pa_budget_versions.version_type%TYPE ;
17469: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
17470: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
17471:
17472: L_RAW_COST_FLAG VARCHAR2(1);

Line 18977: P_PM_PRODUCT_CODE PA_BUDGET_VERSIONS.PM_PRODUCT_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

18973:
18974: END CREATE_DRAFT_FINPLAN;
18975:
18976: PROCEDURE load_resource_info(
18977: P_PM_PRODUCT_CODE PA_BUDGET_VERSIONS.PM_PRODUCT_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18978: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18979: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18980: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18981: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19141: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19137: PROCEDURE EXECUTE_CREATE_DRAFT_FINPLAN
19138: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19139: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
19140: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19141: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19142: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19143: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19144: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 19142: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19138: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19139: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
19140: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19141: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19142: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19143: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19144: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19144: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

19140: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19141: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19142: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19143: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19144: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

19141: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19142: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19143: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19144: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19149: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19143: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19144: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19149: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19149: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19152: ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19153: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19153: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19149: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19152: ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19153: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19152: ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19153: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19151: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19152: ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19153: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19154: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19155: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19156: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19157: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19158: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19159: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19160: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19161: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19162: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19163: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19164: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19165: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19166: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19174: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19167: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19174: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19175: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19168: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19174: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19175: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19176: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19169: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19174: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19175: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19176: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19177: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19174: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19170: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19174: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19175: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19176: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19177: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19178: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19175: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19171: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19174: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19175: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19176: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19177: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19178: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19179: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19176: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19172: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19174: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19175: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19176: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19177: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19178: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19179: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19180: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'

Line 19177: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19173: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19174: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19175: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19176: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19177: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19178: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19179: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19180: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
19181: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 19373: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

19369: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19370: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19371: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19372: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19373: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19374: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19375: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19376: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19377: ,p_planning_element_rec_tbl IN planning_element_rec_tbl_type

Line 19375: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

19371: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19372: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19373: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19374: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19375: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19376: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19377: ,p_planning_element_rec_tbl IN planning_element_rec_tbl_type
19378: ,p_distribute_amounts IN VARCHAR2 DEFAULT 'Y' -- Bug 9610380
19379: ,x_msg_count OUT NOCOPY NUMBER

Line 19376: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19372: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19373: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19374: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19375: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19376: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19377: ,p_planning_element_rec_tbl IN planning_element_rec_tbl_type
19378: ,p_distribute_amounts IN VARCHAR2 DEFAULT 'Y' -- Bug 9610380
19379: ,x_msg_count OUT NOCOPY NUMBER
19380: ,x_msg_data OUT NOCOPY VARCHAR2

Line 19384: CURSOR c_get_plan_class_code(c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE) is

19380: ,x_msg_data OUT NOCOPY VARCHAR2
19381: ,x_return_status OUT NOCOPY VARCHAR2)
19382: IS
19383:
19384: CURSOR c_get_plan_class_code(c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE) is
19385: SELECT plan_class_code
19386: FROM pa_fin_plan_types_b
19387: WHERE fin_plan_type_id=c_fin_plan_type_id;
19388:

Line 19405: l_version_type pa_budget_versions.version_type%TYPE;

19401: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
19402: l_fin_plan_type_id NUMBER;
19403: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
19404: l_fin_plan_class_code varchar2(30);
19405: l_version_type pa_budget_versions.version_type%TYPE;
19406: l_budget_version_id NUMBER;
19407: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
19408: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19409: l_budget_amount_code pa_budget_types.budget_amount_code%type;