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: BEGIN
281:
282: --Standard begin of API savepoint

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

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

Line 1142: from pa_budget_versions

1138: /** Bug 3709462
1139: --3569883 start
1140: select fin_plan_type_id
1141: into l_fp_type_id
1142: from pa_budget_versions
1143: where budget_version_id = l_budget_version_id;
1144:
1145: select DECODE(l_fp_type_id, null, 'Y','N') into l_old_model from dual;
1146: --3569883 end

Line 1209: UPDATE pa_budget_versions

1205:
1206: /*
1207: -- Not necessary now since the same is passed as parameters to create_draft
1208: --add the pm_budget_reference and pm_product_code to the just created budget
1209: UPDATE pa_budget_versions
1210: SET pm_budget_reference = p_pm_budget_reference
1211: , pm_product_code = p_pm_product_code
1212: WHERE budget_version_id = l_budget_version_id;
1213: */

Line 1572: from pa_budget_versions

1568: /** Bug 3709462
1569: --3569883 start
1570: select fin_plan_type_id
1571: into l_fp_type_id
1572: from pa_budget_versions
1573: where budget_version_id = l_budget_version_id;
1574:
1575: select DECODE(l_fp_type_id, null, 'Y','N') into l_old_model from dual;
1576: --3569883 end

Line 2044: into l_locked_by_person_id from pa_budget_versions

2040: -- Comment END
2041: -- Bug # 3507156 : Patchset M: B and F impact changes : AMG
2042:
2043: select locked_by_person_id
2044: into l_locked_by_person_id from pa_budget_versions
2045: where budget_version_id = l_CW_version_id;
2046:
2047: --Get the record version number of the current working version
2048: l_CW_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_CW_version_id);

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

2255: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2256: END IF;
2257:
2258:
2259: --summarizing the totals in the table pa_budget_versions
2260:
2261: /*Summarizing of totals should be done only in the buget model*/
2262: IF (p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR and p_budget_type_code IS NOT NULL) THEN
2263:

Line 2821: ,p_version_type IN pa_budget_versions.version_type%TYPE

2817:
2818: --Added the following parameters for changes in AMG due to finplan model
2819: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
2820: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2821: ,p_version_type IN pa_budget_versions.version_type%TYPE
2822: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2823: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2824: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2825: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

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

3231:
3232: --Parameters due to Fin Plan Model
3233: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3234: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3235: ,p_version_type IN pa_budget_versions.version_type%TYPE)
3236:
3237: IS
3238:
3239: CURSOR l_budget_types_csr

Line 3261: FROM pa_budget_versions

3257: ,c_budget_type_code VARCHAR2)
3258:
3259: IS
3260: SELECT budget_version_id
3261: FROM pa_budget_versions
3262: WHERE project_id = c_project_id
3263: AND budget_type_code = c_budget_type_code
3264: AND budget_status_code = 'W'
3265: AND ci_id IS NULL; -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 3277: FROM pa_budget_versions

3273: ,c_budget_type_code VARCHAR2 )
3274:
3275: IS
3276: SELECT budget_version_id
3277: FROM pa_budget_versions
3278: WHERE project_id = c_project_id
3279: AND budget_type_code = c_budget_type_code
3280: AND budget_status_code = 'B'
3281: AND ci_id IS NULL; -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 3296: pa_budget_versions v

3292: SELECT v.resource_list_id,
3293: t.project_type_class_code
3294: FROM pa_project_types t,
3295: pa_projects p,
3296: pa_budget_versions v
3297: WHERE v.budget_version_id = p_draft_version_id
3298: AND v.project_id = p.project_id
3299: AND p.project_type = t.project_type
3300: AND v.ci_id IS NULL; -- -- Added an extra clause v.ci_id IS NULL--Bug # 3507156

Line 3310: FROM pa_budget_versions

3306:
3307: CURSOR l_lock_budget_csr (p_budget_version_id NUMBER)
3308: IS
3309: SELECT 'x'
3310: FROM pa_budget_versions
3311: WHERE budget_version_id = p_budget_version_id
3312: AND ci_id IS NULL -- -- Added an extra clause ci_id IS NULL--Bug # 3507156
3313: FOR UPDATE NOWAIT;
3314:

Line 3324: l_mark_as_original pa_budget_versions.current_original_flag%TYPE;

3320: l_return_status VARCHAR2(1);
3321: l_project_id NUMBER;
3322:
3323: l_budget_version_id NUMBER;
3324: l_mark_as_original pa_budget_versions.current_original_flag%TYPE;
3325:
3326: l_err_code NUMBER;
3327: l_err_stage VARCHAR2(120);
3328: l_err_stack VARCHAR2(630);

Line 3370: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,

3366:
3367: -- Needed to get the version id and record version number of the original baselined version
3368: CURSOR l_orig_baselined_ver_csr
3369: (c_project_id pa_projects_all.project_id%TYPE,
3370: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
3371: c_version_type pa_budget_versions.version_type%TYPE)
3372: IS
3373: SELECT budget_version_id
3374: ,record_version_number

Line 3371: c_version_type pa_budget_versions.version_type%TYPE)

3367: -- Needed to get the version id and record version number of the original baselined version
3368: CURSOR l_orig_baselined_ver_csr
3369: (c_project_id pa_projects_all.project_id%TYPE,
3370: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
3371: c_version_type pa_budget_versions.version_type%TYPE)
3372: IS
3373: SELECT budget_version_id
3374: ,record_version_number
3375: FROM pa_budget_versions

Line 3375: FROM pa_budget_versions

3371: c_version_type pa_budget_versions.version_type%TYPE)
3372: IS
3373: SELECT budget_version_id
3374: ,record_version_number
3375: FROM pa_budget_versions
3376: WHERE project_id=c_project_id
3377: AND fin_plan_type_id=c_fin_plan_type_id
3378: AND version_type=c_version_type
3379: AND current_original_flag='Y'

Line 3401: l_version_type pa_budget_Versions.version_type%TYPE;

3397: l_debug_level2 CONSTANT NUMBER := 2;
3398: l_debug_level3 CONSTANT NUMBER := 3;
3399: l_debug_level4 CONSTANT NUMBER := 4;
3400: l_debug_level5 CONSTANT NUMBER := 5;
3401: l_version_type pa_budget_Versions.version_type%TYPE;
3402: l_security_ret_code VARCHAR2(1);
3403: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3404: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3405: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 3404: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;

3400: l_debug_level5 CONSTANT NUMBER := 5;
3401: l_version_type pa_budget_Versions.version_type%TYPE;
3402: l_security_ret_code VARCHAR2(1);
3403: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3404: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3405: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3406: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3407: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3408: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;

Line 3406: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;

3402: l_security_ret_code VARCHAR2(1);
3403: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3404: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3405: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3406: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3407: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3408: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;
3409: l_any_error_occurred_flag VARCHAR2(1);
3410: l_data VARCHAR2(2000);

Line 3407: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;

3403: l_baselined_Ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3404: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3405: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3406: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3407: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3408: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;
3409: l_any_error_occurred_flag VARCHAR2(1);
3410: l_data VARCHAR2(2000);
3411: l_msg_index_out NUMBER;

Line 3408: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;

3404: l_baselined_version_id pa_budget_Versions.budget_version_id%TYPE;
3405: l_CW_ver_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3406: l_curr_working_version_id pa_budget_Versions.budget_version_id%TYPE;
3407: l_CB_record_version_number pa_budget_Versions.record_version_number%TYPE;
3408: l_CW_record_version_number pa_budget_Versions.record_version_number%TYPE;
3409: l_any_error_occurred_flag VARCHAR2(1);
3410: l_data VARCHAR2(2000);
3411: l_msg_index_out NUMBER;
3412: l_dummy VARCHAR2(1);

Line 3419: l_targ_request_id pa_budget_versions.request_id%TYPE;

3415: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3416: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3417: l_fc_version_created_flag VARCHAR2(1);
3418: l_final_plan_prc_code VARCHAR2(10);
3419: l_targ_request_id pa_budget_versions.request_id%TYPE;
3420: BEGIN
3421:
3422: --Standard begin of API savepoint
3423:

Line 4557: UPDATE pa_budget_versions

4553: -- by the baseliner as part of the workflow process.
4554:
4555: /* -- dbms_output.put_line('WORKFLOW USED...Update Draft to Submitted, IN_ROUTE'); */
4556:
4557: UPDATE pa_budget_versions
4558: SET budget_status_code = 'S', WF_status_code = 'IN_ROUTE'
4559: WHERE budget_version_id = l_curr_working_version_id;
4560:
4561: /* -- dbms_output.put_line('WORKFLOW USED...START_BUDGET_WF API'); */

Line 4618: UPDATE pa_budget_versions

4614:
4615: -- STRAIGHT BASELINE, NO Workflow
4616:
4617:
4618: UPDATE pa_budget_versions
4619: SET budget_status_code = 'S', WF_status_code = NULL
4620: WHERE budget_version_id = l_curr_working_version_id;
4621:
4622:

Line 4721: UPDATE pa_budget_versions

4717:
4718: -- after calling BASELINE, set the budget_status_code back to 'W' (Working)
4719: -- the concept of submitting budget is not available in the public API's!
4720:
4721: UPDATE pa_budget_versions
4722: SET budget_status_code = 'W'
4723: WHERE budget_version_id = l_curr_working_version_id;
4724:
4725: ELSE--Fin Plan Model. Call the baseline api in fin plan pub

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

5067: l_project_id NUMBER := p_pa_project_id;
5068: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
5069: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
5070: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
5071: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
5072: l_budget_version_id NUMBER;
5073: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5074: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5075: l_budget_amount_code pa_budget_types.budget_amount_code%type;

Line 5080: l_record_version_number pa_budget_versions.record_version_number%TYPE;

5076: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5077: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5078: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5079: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5080: l_record_version_number pa_budget_versions.record_version_number%TYPE;
5081:
5082: l_resource_name VARCHAR2(80); --bug 3711693
5083:
5084: l_budget_lines_in budget_line_in_tbl_type;

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

5336:
5337: END IF;
5338:
5339:
5340: --summarizing the totals in the table pa_budget_versions
5341: PA_BUDGET_UTILS.summerize_project_totals
5342: ( x_budget_version_id => l_budget_version_id
5343: , x_err_code => l_err_code
5344: , x_err_stage => l_err_stage

Line 5990: ,p_version_number IN pa_budget_versions.version_number%TYPE

5986:
5987: -- Parameters required for Fin Plan Model
5988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
5989: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5990: ,p_version_number IN pa_budget_versions.version_number%TYPE
5991: ,p_version_type IN pa_budget_versions.version_type%TYPE
5992: )
5993:
5994: IS

Line 5991: ,p_version_type IN pa_budget_versions.version_type%TYPE

5987: -- Parameters required for Fin Plan Model
5988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
5989: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5990: ,p_version_number IN pa_budget_versions.version_number%TYPE
5991: ,p_version_type IN pa_budget_versions.version_type%TYPE
5992: )
5993:
5994: IS
5995:

Line 6001: FROM pa_budget_versions

5997: ( p_project_id NUMBER
5998: , p_budget_type_code VARCHAR2 )
5999: IS
6000: SELECT budget_version_id
6001: FROM pa_budget_versions
6002: WHERE project_id = p_project_id
6003: AND budget_type_code = p_budget_type_code
6004: AND budget_status_code = 'W'
6005: AND ci_id IS NULL; -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 6031: FROM pa_budget_versions bv

6027:
6028: CURSOR l_lock_budget_csr( p_budget_version_id NUMBER )
6029: IS
6030: SELECT 'x'
6031: FROM pa_budget_versions bv
6032: , pa_resource_assignments ra
6033: , pa_budget_lines bl
6034: WHERE bv.budget_version_id = p_budget_version_id
6035: AND bv.budget_version_id = ra.budget_version_id (+)

Line 6050: l_ci_id pa_budget_versions.ci_id%TYPE;

6046: l_err_stage VARCHAR2(120);
6047: l_err_stack VARCHAR2(630);
6048: l_dummy NUMBER :=0;
6049: l_budget_version_id NUMBER;
6050: l_ci_id pa_budget_versions.ci_id%TYPE;
6051: l_project_id NUMBER;
6052: l_budget_type_code VARCHAR2(30);
6053: l_msg_count NUMBER ;
6054: l_msg_data VARCHAR2(2000);

Line 6083: l_version_type pa_budget_versions.version_type%TYPE;

6079: l_debug_level3 CONSTANT NUMBER := 3;
6080: l_debug_level5 CONSTANT NUMBER := 5;
6081: l_security_ret_code VARCHAR2(1);
6082: l_fin_plan_type_id NUMBER;
6083: l_version_type pa_budget_versions.version_type%TYPE;
6084: l_proj_fp_options_id NUMBER;
6085: l_result VARCHAR2(1);
6086: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6087: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 6086: l_record_version_number pa_budget_versions.record_version_number%TYPE;

6082: l_fin_plan_type_id NUMBER;
6083: l_version_type pa_budget_versions.version_type%TYPE;
6084: l_proj_fp_options_id NUMBER;
6085: l_result VARCHAR2(1);
6086: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6087: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6088: --Added by Xin Liu. 28-APR-03
6089: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6090: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 6091: ll_version_type pa_budget_versions.version_type%TYPE;

6087: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6088: --Added by Xin Liu. 28-APR-03
6089: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6090: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6091: ll_version_type pa_budget_versions.version_type%TYPE;
6092: ll_version_number pa_budget_versions.version_number%TYPE;
6093:
6094: BEGIN
6095:

Line 6092: ll_version_number pa_budget_versions.version_number%TYPE;

6088: --Added by Xin Liu. 28-APR-03
6089: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6090: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6091: ll_version_type pa_budget_versions.version_type%TYPE;
6092: ll_version_number pa_budget_versions.version_number%TYPE;
6093:
6094: BEGIN
6095:
6096: -- Standard begin of API savepoint

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

6818: AND gen_src_all_plan_version_id = l_budget_version_id;
6819: END IF;
6820:
6821: --if any record had been updated in pa_proj_fp_options then
6822: --we do a dummy update in pa_budget_versions also for the
6823: --budget version that is being updated to increase the record version number
6824: IF SQL%ROWCOUNT > 0 THEN
6825: UPDATE pa_budget_versions
6826: SET record_version_number = record_version_number + 1,

Line 6825: UPDATE pa_budget_versions

6821: --if any record had been updated in pa_proj_fp_options then
6822: --we do a dummy update in pa_budget_versions also for the
6823: --budget version that is being updated to increase the record version number
6824: IF SQL%ROWCOUNT > 0 THEN
6825: UPDATE pa_budget_versions
6826: SET record_version_number = record_version_number + 1,
6827: last_update_date = SYSDATE,
6828: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6829: last_update_login = FND_GLOBAL.LOGIN_ID

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

6982: ,p_return_status OUT NOCOPY VARCHAR2
6983: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6984: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6985: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6986: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6987: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6989: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6990: ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

6985: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6986: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6987: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6989: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6990: ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6991: )
6992:
6993: IS

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

6986: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6987: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6989: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6990: ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6991: )
6992:
6993: IS
6994:

Line 7008: FROM pa_budget_versions

7004: IS
7005: SELECT budget_version_id
7006: ,current_flag
7007: ,current_original_flag
7008: FROM pa_budget_versions
7009: WHERE project_id = p_project_id
7010: AND budget_type_code = p_budget_type_code
7011: AND version_number = p_version_number
7012: AND budget_status_code = 'B';

Line 7028: FROM pa_budget_versions

7024: , p_version_type VARCHAR2
7025: , p_version_number NUMBER )
7026: IS
7027: SELECT budget_version_id
7028: FROM pa_budget_versions
7029: WHERE project_id = p_project_id
7030: AND fin_plan_type_id = p_fin_plan_type_id
7031: AND version_type = p_version_type
7032: AND version_number = p_version_number

Line 7088: l_record_version_number pa_budget_versions.record_version_number%TYPE;

7084: l_debug_level5 CONSTANT NUMBER := 5;
7085:
7086: l_security_ret_code VARCHAR2(1);
7087: l_function_name VARCHAR2(80);
7088: l_record_version_number pa_budget_versions.record_version_number%TYPE;
7089:
7090: l_project_id NUMBER;
7091: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
7092: l_budget_version_id NUMBER;

Line 7091: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

7087: l_function_name VARCHAR2(80);
7088: l_record_version_number pa_budget_versions.record_version_number%TYPE;
7089:
7090: l_project_id NUMBER;
7091: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
7092: l_budget_version_id NUMBER;
7093: l_fin_plan_type_id NUMBER;
7094: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;
7095: l_version_type pa_budget_versions.version_type%TYPE;

Line 7095: l_version_type pa_budget_versions.version_type%TYPE;

7091: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
7092: l_budget_version_id NUMBER;
7093: l_fin_plan_type_id NUMBER;
7094: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;
7095: l_version_type pa_budget_versions.version_type%TYPE;
7096: l_version_number NUMBER;
7097: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
7098:
7099:

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

7729: AND gen_src_all_plan_version_id = l_budget_version_id;
7730: END IF;
7731:
7732: --if any record had been updated in pa_proj_fp_options then
7733: --we do a dummy update in pa_budget_versions also for the
7734: --budget version that is being updated to increase the record version number
7735: IF SQL%ROWCOUNT > 0 THEN
7736: UPDATE pa_budget_versions
7737: SET record_version_number = record_version_number + 1,

Line 7736: UPDATE pa_budget_versions

7732: --if any record had been updated in pa_proj_fp_options then
7733: --we do a dummy update in pa_budget_versions also for the
7734: --budget version that is being updated to increase the record version number
7735: IF SQL%ROWCOUNT > 0 THEN
7736: UPDATE pa_budget_versions
7737: SET record_version_number = record_version_number + 1,
7738: last_update_date = SYSDATE,
7739: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7740: last_update_login = FND_GLOBAL.LOGIN_ID

Line 8023: FROM pa_budget_versions bv,

8019: CURSOR budget_version_info_cur (c_budget_version_id IN NUMBER)
8020: IS
8021: SELECT pt.plan_class_code
8022: ,bv.etc_start_date
8023: FROM pa_budget_versions bv,
8024: pa_fin_plan_types_b pt
8025: WHERE bv.budget_version_id = c_budget_version_id
8026: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
8027:

Line 8029: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

8025: WHERE bv.budget_version_id = c_budget_version_id
8026: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
8027:
8028: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
8029: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
8030:
8031: i NUMBER := 0;
8032: l_dummy NUMBER;
8033:

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

8043: l_project_id NUMBER := p_pa_project_id;
8044: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
8045: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
8046: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
8047: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
8048: l_budget_version_id NUMBER;
8049: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8050: l_resource_list_id NUMBER;
8051: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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

8656: END IF;
8657:
8658: IF l_budget_type_code IS NOT NULL --old budgets model
8659: THEN
8660: --summarizing the totals in the table pa_budget_versions
8661: PA_BUDGET_UTILS.summerize_project_totals( x_budget_version_id => l_budget_version_id
8662: , x_err_code => l_err_code
8663: , x_err_stage => l_err_stage
8664: , x_err_stack => l_err_stack );

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

8990: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8991: ,p_budget_lines_in IN budget_line_in_tbl_type
8992: ,p_budget_lines_out OUT NOCOPY budget_line_out_tbl_type
8993: --Added for the bug 3453650
8994: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8995: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8996: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8997: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8998: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

8991: ,p_budget_lines_in IN budget_line_in_tbl_type
8992: ,p_budget_lines_out OUT NOCOPY budget_line_out_tbl_type
8993: --Added for the bug 3453650
8994: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8995: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8996: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8997: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8998: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650

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

8992: ,p_budget_lines_out OUT NOCOPY budget_line_out_tbl_type
8993: --Added for the bug 3453650
8994: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8995: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8996: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8997: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8998: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9000: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

8993: --Added for the bug 3453650
8994: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8995: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8996: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8997: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8998: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9000: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9001: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

8994: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8995: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8996: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8997: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8998: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9000: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9001: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9002: ,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 8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650

8995: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8996: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8997: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8998: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9000: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9001: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9002: ,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
9003: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

8996: -- ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8997: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8998: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9000: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9001: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9002: ,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
9003: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9004: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9065: FROM pa_budget_versions

9061: , budget_entry_method_code
9062: , resource_list_id
9063: , change_reason_code
9064: , description
9065: FROM pa_budget_versions
9066: WHERE project_id = p_project_id
9067: AND budget_type_code = p_budget_type_code
9068: AND budget_status_code = 'W';
9069:

Line 9155: FROM pa_budget_versions bv

9151:
9152: CURSOR l_lock_budget_csr( p_budget_version_id NUMBER )
9153: IS
9154: SELECT 'x'
9155: FROM pa_budget_versions bv
9156: , pa_resource_assignments ra
9157: , pa_budget_lines bl
9158: WHERE bv.budget_version_id = p_budget_version_id
9159: AND bv.budget_version_id = ra.budget_version_id (+)

Line 9237: FROM PA_BUDGET_VERSIONS

9233: CURSOR l_budget_attrs_csr(p_budget_type_code VARCHAR2,p_project_id number)
9234: IS
9235: SELECT BUDGET_VERSION_ID,version_name,budget_entry_method_code,
9236: RESOURCE_LIST_ID,CHANGE_REASON_CODE,DESCRIPTION
9237: FROM PA_BUDGET_VERSIONS
9238: --WHERE VERSION_NAME=p_budget_version_number
9239: Where budget_type_code=p_budget_type_code
9240: and project_id = p_project_id
9241: and budget_status_code = 'W';

Line 9248: FROM PA_BUDGET_VERSIONS

9244: CURSOR l_finplan_attrs_csr(c_budget_version_id NUMBER)
9245: IS
9246: SELECT version_name,CURRENT_WORKING_FLAG,
9247: RESOURCE_LIST_ID,CHANGE_REASON_CODE,DESCRIPTION,version_type
9248: FROM PA_BUDGET_VERSIONS
9249: WHERE budget_version_id = c_budget_version_id;
9250:
9251: CURSOR l_finplan_type_name_csr(p_finplan_type_id NUMBER)
9252: IS

Line 9268: from pa_budget_versions

9264:
9265: CURSOR get_status_code_csr(p_budget_version_id NUMBER)
9266: IS
9267: select budget_status_code
9268: from pa_budget_versions
9269: where budget_version_id = p_budget_version_id;
9270:
9271: CURSOR l_finplan_line_csr
9272: (p_resource_assigment_id NUMBER

Line 9301: from pa_budget_versions

9297: attribute12,
9298: attribute13,
9299: attribute14,
9300: attribute15
9301: from pa_budget_versions
9302: where budget_version_id = p_budget_version_id;
9303: /*End of code for Bug 6417360*/
9304:
9305: l_budget_version_name pa_budget_versions.version_name%TYPE := null;

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

9301: from pa_budget_versions
9302: where budget_version_id = p_budget_version_id;
9303: /*End of code for Bug 6417360*/
9304:
9305: l_budget_version_name pa_budget_versions.version_name%TYPE := null;
9306: l_fin_plan_type_id number;
9307: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9308: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9309: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;

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

9304:
9305: l_budget_version_name pa_budget_versions.version_name%TYPE := null;
9306: l_fin_plan_type_id number;
9307: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9308: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9309: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9310: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9311: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9312:

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

9305: l_budget_version_name pa_budget_versions.version_name%TYPE := null;
9306: l_fin_plan_type_id number;
9307: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9308: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9309: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9310: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9311: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9312:
9313: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

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

9306: l_fin_plan_type_id number;
9307: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9308: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9309: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9310: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9311: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9312:
9313: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
9314: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=null;

Line 9311: l_record_version_number pa_budget_versions.record_version_number%TYPE;

9307: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9308: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9309: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9310: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9311: l_record_version_number pa_budget_versions.record_version_number%TYPE;
9312:
9313: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
9314: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=null;
9315: l_person_id per_all_people_f.person_id%TYPE;

Line 9319: l_version_type pa_budget_versions.version_type%TYPE;

9315: l_person_id per_all_people_f.person_id%TYPE;
9316: l_resource_id per_all_people_f.person_id%TYPE;
9317: l_baselined_version_id NUMBER;
9318: l_debug_mode VARCHAR2(1);
9319: l_version_type pa_budget_versions.version_type%TYPE;
9320: l_curr_work_version_id VARCHAR2(15);
9321: l_debug_level5 CONSTANT NUMBER :=5;
9322: l_baselined_Ver_options_id VARCHAR2(15);
9323: l_budget_lines_in budget_line_in_tbl_type;

Line 9334: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

9330: -- Bug Fix: 4569365. Removed MRC code.
9331: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
9332: l_calling_context VARCHAR2(30);
9333:
9334: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
9335:
9336: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9337: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9338: lx_version_type pa_budget_versions.version_type%TYPE := null;

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

9332: l_calling_context VARCHAR2(30);
9333:
9334: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
9335:
9336: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9337: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9338: lx_version_type pa_budget_versions.version_type%TYPE := null;
9339: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9340: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;

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

9333:
9334: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
9335:
9336: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9337: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9338: lx_version_type pa_budget_versions.version_type%TYPE := null;
9339: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9340: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9341: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;

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

9334: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
9335:
9336: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9337: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9338: lx_version_type pa_budget_versions.version_type%TYPE := null;
9339: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9340: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9341: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9342: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

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

9337: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9338: lx_version_type pa_budget_versions.version_type%TYPE := null;
9339: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9340: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9341: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9342: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9343: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9344: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9345: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 9342: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

9338: lx_version_type pa_budget_versions.version_type%TYPE := null;
9339: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9340: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9341: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9342: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9343: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9344: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9345: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;
9346: lx_resource_list_name pa_resource_lists_all_bg.Name%TYPE := null;

Line 9343: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;

9339: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9340: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9341: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9342: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9343: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9344: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
9345: lx_time_phased_type_code pa_proj_fp_options.cost_time_phased_code%TYPE;
9346: lx_resource_list_name pa_resource_lists_all_bg.Name%TYPE := null;
9347: lx_raw_cost_flag VARCHAR2(1) ;

Line 9392: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;

9388: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9389: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9390: l_amg_project_number pa_projects_all.segment1%TYPE;
9391: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9392: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9393: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
9394: l_allow_qty_flag VARCHAR2(1);
9395: l_conv_attrs_to_be_validated VARCHAR2(30);
9396: l_is_rate_type_valid BOOLEAN;

Line 9393: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;

9389: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9390: l_amg_project_number pa_projects_all.segment1%TYPE;
9391: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9392: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9393: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
9394: l_allow_qty_flag VARCHAR2(1);
9395: l_conv_attrs_to_be_validated VARCHAR2(30);
9396: l_is_rate_type_valid BOOLEAN;
9397: l_call_validate_curr_api_flg VARCHAR2(1);

Line 9417: l_attribute_category pa_budget_versions.attribute_category%type;

9413: l_proj_fp_options_id_new pa_proj_fp_options.proj_fp_options_id%TYPE;
9414:
9415:
9416: /*Added local variables for Bug 6417360*/
9417: l_attribute_category pa_budget_versions.attribute_category%type;
9418: l_attribute1 pa_budget_versions.attribute1%type;
9419: l_attribute2 pa_budget_versions.attribute2%type;
9420: l_attribute3 pa_budget_versions.attribute3%type;
9421: l_attribute4 pa_budget_versions.attribute4%type;

Line 9418: l_attribute1 pa_budget_versions.attribute1%type;

9414:
9415:
9416: /*Added local variables for Bug 6417360*/
9417: l_attribute_category pa_budget_versions.attribute_category%type;
9418: l_attribute1 pa_budget_versions.attribute1%type;
9419: l_attribute2 pa_budget_versions.attribute2%type;
9420: l_attribute3 pa_budget_versions.attribute3%type;
9421: l_attribute4 pa_budget_versions.attribute4%type;
9422: l_attribute5 pa_budget_versions.attribute5%type;

Line 9419: l_attribute2 pa_budget_versions.attribute2%type;

9415:
9416: /*Added local variables for Bug 6417360*/
9417: l_attribute_category pa_budget_versions.attribute_category%type;
9418: l_attribute1 pa_budget_versions.attribute1%type;
9419: l_attribute2 pa_budget_versions.attribute2%type;
9420: l_attribute3 pa_budget_versions.attribute3%type;
9421: l_attribute4 pa_budget_versions.attribute4%type;
9422: l_attribute5 pa_budget_versions.attribute5%type;
9423: l_attribute6 pa_budget_versions.attribute6%type;

Line 9420: l_attribute3 pa_budget_versions.attribute3%type;

9416: /*Added local variables for Bug 6417360*/
9417: l_attribute_category pa_budget_versions.attribute_category%type;
9418: l_attribute1 pa_budget_versions.attribute1%type;
9419: l_attribute2 pa_budget_versions.attribute2%type;
9420: l_attribute3 pa_budget_versions.attribute3%type;
9421: l_attribute4 pa_budget_versions.attribute4%type;
9422: l_attribute5 pa_budget_versions.attribute5%type;
9423: l_attribute6 pa_budget_versions.attribute6%type;
9424: l_attribute7 pa_budget_versions.attribute7%type;

Line 9421: l_attribute4 pa_budget_versions.attribute4%type;

9417: l_attribute_category pa_budget_versions.attribute_category%type;
9418: l_attribute1 pa_budget_versions.attribute1%type;
9419: l_attribute2 pa_budget_versions.attribute2%type;
9420: l_attribute3 pa_budget_versions.attribute3%type;
9421: l_attribute4 pa_budget_versions.attribute4%type;
9422: l_attribute5 pa_budget_versions.attribute5%type;
9423: l_attribute6 pa_budget_versions.attribute6%type;
9424: l_attribute7 pa_budget_versions.attribute7%type;
9425: l_attribute8 pa_budget_versions.attribute8%type;

Line 9422: l_attribute5 pa_budget_versions.attribute5%type;

9418: l_attribute1 pa_budget_versions.attribute1%type;
9419: l_attribute2 pa_budget_versions.attribute2%type;
9420: l_attribute3 pa_budget_versions.attribute3%type;
9421: l_attribute4 pa_budget_versions.attribute4%type;
9422: l_attribute5 pa_budget_versions.attribute5%type;
9423: l_attribute6 pa_budget_versions.attribute6%type;
9424: l_attribute7 pa_budget_versions.attribute7%type;
9425: l_attribute8 pa_budget_versions.attribute8%type;
9426: l_attribute9 pa_budget_versions.attribute9%type;

Line 9423: l_attribute6 pa_budget_versions.attribute6%type;

9419: l_attribute2 pa_budget_versions.attribute2%type;
9420: l_attribute3 pa_budget_versions.attribute3%type;
9421: l_attribute4 pa_budget_versions.attribute4%type;
9422: l_attribute5 pa_budget_versions.attribute5%type;
9423: l_attribute6 pa_budget_versions.attribute6%type;
9424: l_attribute7 pa_budget_versions.attribute7%type;
9425: l_attribute8 pa_budget_versions.attribute8%type;
9426: l_attribute9 pa_budget_versions.attribute9%type;
9427: l_attribute10 pa_budget_versions.attribute10%type;

Line 9424: l_attribute7 pa_budget_versions.attribute7%type;

9420: l_attribute3 pa_budget_versions.attribute3%type;
9421: l_attribute4 pa_budget_versions.attribute4%type;
9422: l_attribute5 pa_budget_versions.attribute5%type;
9423: l_attribute6 pa_budget_versions.attribute6%type;
9424: l_attribute7 pa_budget_versions.attribute7%type;
9425: l_attribute8 pa_budget_versions.attribute8%type;
9426: l_attribute9 pa_budget_versions.attribute9%type;
9427: l_attribute10 pa_budget_versions.attribute10%type;
9428: l_attribute11 pa_budget_versions.attribute11%type;

Line 9425: l_attribute8 pa_budget_versions.attribute8%type;

9421: l_attribute4 pa_budget_versions.attribute4%type;
9422: l_attribute5 pa_budget_versions.attribute5%type;
9423: l_attribute6 pa_budget_versions.attribute6%type;
9424: l_attribute7 pa_budget_versions.attribute7%type;
9425: l_attribute8 pa_budget_versions.attribute8%type;
9426: l_attribute9 pa_budget_versions.attribute9%type;
9427: l_attribute10 pa_budget_versions.attribute10%type;
9428: l_attribute11 pa_budget_versions.attribute11%type;
9429: l_attribute12 pa_budget_versions.attribute12%type;

Line 9426: l_attribute9 pa_budget_versions.attribute9%type;

9422: l_attribute5 pa_budget_versions.attribute5%type;
9423: l_attribute6 pa_budget_versions.attribute6%type;
9424: l_attribute7 pa_budget_versions.attribute7%type;
9425: l_attribute8 pa_budget_versions.attribute8%type;
9426: l_attribute9 pa_budget_versions.attribute9%type;
9427: l_attribute10 pa_budget_versions.attribute10%type;
9428: l_attribute11 pa_budget_versions.attribute11%type;
9429: l_attribute12 pa_budget_versions.attribute12%type;
9430: l_attribute13 pa_budget_versions.attribute13%type;

Line 9427: l_attribute10 pa_budget_versions.attribute10%type;

9423: l_attribute6 pa_budget_versions.attribute6%type;
9424: l_attribute7 pa_budget_versions.attribute7%type;
9425: l_attribute8 pa_budget_versions.attribute8%type;
9426: l_attribute9 pa_budget_versions.attribute9%type;
9427: l_attribute10 pa_budget_versions.attribute10%type;
9428: l_attribute11 pa_budget_versions.attribute11%type;
9429: l_attribute12 pa_budget_versions.attribute12%type;
9430: l_attribute13 pa_budget_versions.attribute13%type;
9431: l_attribute14 pa_budget_versions.attribute14%type;

Line 9428: l_attribute11 pa_budget_versions.attribute11%type;

9424: l_attribute7 pa_budget_versions.attribute7%type;
9425: l_attribute8 pa_budget_versions.attribute8%type;
9426: l_attribute9 pa_budget_versions.attribute9%type;
9427: l_attribute10 pa_budget_versions.attribute10%type;
9428: l_attribute11 pa_budget_versions.attribute11%type;
9429: l_attribute12 pa_budget_versions.attribute12%type;
9430: l_attribute13 pa_budget_versions.attribute13%type;
9431: l_attribute14 pa_budget_versions.attribute14%type;
9432: l_attribute15 pa_budget_versions.attribute15%type;

Line 9429: l_attribute12 pa_budget_versions.attribute12%type;

9425: l_attribute8 pa_budget_versions.attribute8%type;
9426: l_attribute9 pa_budget_versions.attribute9%type;
9427: l_attribute10 pa_budget_versions.attribute10%type;
9428: l_attribute11 pa_budget_versions.attribute11%type;
9429: l_attribute12 pa_budget_versions.attribute12%type;
9430: l_attribute13 pa_budget_versions.attribute13%type;
9431: l_attribute14 pa_budget_versions.attribute14%type;
9432: l_attribute15 pa_budget_versions.attribute15%type;
9433:

Line 9430: l_attribute13 pa_budget_versions.attribute13%type;

9426: l_attribute9 pa_budget_versions.attribute9%type;
9427: l_attribute10 pa_budget_versions.attribute10%type;
9428: l_attribute11 pa_budget_versions.attribute11%type;
9429: l_attribute12 pa_budget_versions.attribute12%type;
9430: l_attribute13 pa_budget_versions.attribute13%type;
9431: l_attribute14 pa_budget_versions.attribute14%type;
9432: l_attribute15 pa_budget_versions.attribute15%type;
9433:
9434: l_validate_status varchar2(1);

Line 9431: l_attribute14 pa_budget_versions.attribute14%type;

9427: l_attribute10 pa_budget_versions.attribute10%type;
9428: l_attribute11 pa_budget_versions.attribute11%type;
9429: l_attribute12 pa_budget_versions.attribute12%type;
9430: l_attribute13 pa_budget_versions.attribute13%type;
9431: l_attribute14 pa_budget_versions.attribute14%type;
9432: l_attribute15 pa_budget_versions.attribute15%type;
9433:
9434: l_validate_status varchar2(1);
9435: /*End of code for Bug 6417360*/

Line 9432: l_attribute15 pa_budget_versions.attribute15%type;

9428: l_attribute11 pa_budget_versions.attribute11%type;
9429: l_attribute12 pa_budget_versions.attribute12%type;
9430: l_attribute13 pa_budget_versions.attribute13%type;
9431: l_attribute14 pa_budget_versions.attribute14%type;
9432: l_attribute15 pa_budget_versions.attribute15%type;
9433:
9434: l_validate_status varchar2(1);
9435: /*End of code for Bug 6417360*/
9436:

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

9822:
9823: /* -- Changes made by Xin Liu for using of SQL BIND VARIABLE 12-MAY-2003 */
9824: --building the dynamic SQL statement
9825:
9826: l_statement := ' UPDATE PA_BUDGET_VERSIONS SET ';
9827:
9828: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_description IS NULL)
9829: AND nvl(p_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <> nvl(l_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
9830: THEN

Line 9933: --Validate PA_BUDGET_VERSIONS_DESC_FLEX

9929: l_attribute14,
9930: l_attribute15;
9931: close c_dff_values;
9932:
9933: --Validate PA_BUDGET_VERSIONS_DESC_FLEX
9934:
9935: -- 6188316 Adding double quotes for all 15 attributes and category values being appended to Update Query String
9936:
9937: if ((p_attribute_category <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 10202: p_desc_flex_name => 'PA_BUDGET_VERSIONS_DESC_FLEX'

10198: dbms_output.put_line('l_attribute15 '||l_attribute15);*/
10199:
10200:
10201: pa_task_utils.validate_flex_fields(
10202: p_desc_flex_name => 'PA_BUDGET_VERSIONS_DESC_FLEX'
10203: ,p_attribute_category => l_attribute_category
10204: ,p_attribute1 => l_attribute1
10205: ,p_attribute2 => l_attribute2
10206: ,p_attribute3 => l_attribute3

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

12437: IF p_multiple_task_msg = 'F' THEN
12438: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12439: END IF;
12440:
12441: --summarizing the totals in the table pa_budget_versions
12442: /*Added the below if condition for the bug 3453650*/
12443: IF l_budget_type_code IS NOT NULL THEN
12444:
12445: -- check for overlapping dates

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

12671: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12672: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12673: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12674: --Added for the bug 3453650
12675: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12676: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12677: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12678: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12679: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

12672: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12673: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12674: --Added for the bug 3453650
12675: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12676: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12677: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12678: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12679: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12680: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

12673: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12674: --Added for the bug 3453650
12675: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12676: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12677: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12678: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12679: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12680: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12681: ,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 12678: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

12674: --Added for the bug 3453650
12675: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12676: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12677: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12678: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12679: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12680: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12681: ,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
12682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

12675: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12676: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12677: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12678: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12679: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12680: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12681: ,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
12682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12683: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

12676: ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12677: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12678: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12679: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12680: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12681: ,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
12682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12683: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12684: ,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 13037: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;

13033: l_project_id NUMBER := p_pa_project_id;
13034: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
13035: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
13036: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
13037: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
13038: l_budget_version_id NUMBER;
13039: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13040: l_resource_list_id NUMBER;
13041: l_budget_amount_code pa_budget_types.budget_amount_code%type;

Line 13046: l_record_version_number pa_budget_versions.record_version_number%TYPE;

13042: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13043: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13044: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13045: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13046: l_record_version_number pa_budget_versions.record_version_number%TYPE;
13047:
13048: l_budget_lines_in budget_line_in_tbl_type;
13049: l_budget_lines_out_tbl budget_line_out_tbl_type;
13050: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

13668: THEN
13669: RAISE FND_API.G_EXC_ERROR;
13670: END IF;
13671:
13672: --summarizing the totals in the table pa_budget_versions
13673: PA_BUDGET_UTILS.summerize_project_totals
13674: (x_budget_version_id => l_budget_version_id
13675: ,x_err_code => l_err_code
13676: ,x_err_stage => l_err_stage

Line 14080: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

14076: ,p_calc_revenue_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14077: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14078: ,p_calc_budget_lines_out OUT NOCOPY calc_budget_line_out_tbl_type
14079: -- Bug 2863564 Parameters added for new Fin Plan Model
14080: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14081: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14082: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14083: ,p_version_type IN pa_budget_versions.version_type%TYPE
14084: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE

Line 14083: ,p_version_type IN pa_budget_versions.version_type%TYPE

14079: -- Bug 2863564 Parameters added for new Fin Plan Model
14080: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14081: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14082: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14083: ,p_version_type IN pa_budget_versions.version_type%TYPE
14084: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
14085: ) IS
14086:
14087: CURSOR l_budget_type_csr

Line 14084: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE

14080: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14081: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14082: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14083: ,p_version_type IN pa_budget_versions.version_type%TYPE
14084: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
14085: ) IS
14086:
14087: CURSOR l_budget_type_csr
14088: (p_budget_type_code VARCHAR2 )

Line 14186: FROM pa_budget_versions v

14182: /* added for 2207723 */
14183: CURSOR l_get_entry_level_csr (c_budget_version_id IN NUMBER)
14184: IS
14185: SELECT m.entry_level_code
14186: FROM pa_budget_versions v
14187: ,pa_budget_entry_methods m
14188: WHERE v.budget_version_id = c_budget_version_id
14189: AND v.budget_entry_method_code = m.budget_entry_method_code
14190: AND v.ci_id IS NULL; -- -- Added an extra clause v.ci_id IS NULL--Bug # 3507156

Line 14236: l_version_type pa_budget_versions.version_type%TYPE;

14232: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14233: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14234: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14235:
14236: l_version_type pa_budget_versions.version_type%TYPE;
14237: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14238: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14239: l_ci_id pa_budget_versions.ci_id%TYPE;
14240:

Line 14237: l_record_version_number pa_budget_versions.record_version_number%TYPE;

14233: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14234: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14235:
14236: l_version_type pa_budget_versions.version_type%TYPE;
14237: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14238: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14239: l_ci_id pa_budget_versions.ci_id%TYPE;
14240:
14241: l_debug_mode VARCHAR2(30):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 14238: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

14234: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14235:
14236: l_version_type pa_budget_versions.version_type%TYPE;
14237: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14238: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14239: l_ci_id pa_budget_versions.ci_id%TYPE;
14240:
14241: l_debug_mode VARCHAR2(30):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
14242: l_debug_level3 CONSTANT NUMBER := 3;

Line 14239: l_ci_id pa_budget_versions.ci_id%TYPE;

14235:
14236: l_version_type pa_budget_versions.version_type%TYPE;
14237: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14238: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
14239: l_ci_id pa_budget_versions.ci_id%TYPE;
14240:
14241: l_debug_mode VARCHAR2(30):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
14242: l_debug_level3 CONSTANT NUMBER := 3;
14243: l_debug_level5 CONSTANT NUMBER := 5;

Line 14252: ll_version_type pa_budget_versions.version_type%TYPE;

14248:
14249:
14250: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14251: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14252: ll_version_type pa_budget_versions.version_type%TYPE;
14253: ll_version_number pa_budget_versions.version_number%TYPE;
14254: --needed to get the field values associated to a AMG message
14255:
14256: --Added baseline_funding flag and querying from pa_projects_all and not from pa_projects

Line 14253: ll_version_number pa_budget_versions.version_number%TYPE;

14249:
14250: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14251: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14252: ll_version_type pa_budget_versions.version_type%TYPE;
14253: ll_version_number pa_budget_versions.version_number%TYPE;
14254: --needed to get the field values associated to a AMG message
14255:
14256: --Added baseline_funding flag and querying from pa_projects_all and not from pa_projects
14257: CURSOR l_amg_project_csr

Line 14296: FROM pa_budget_versions bv,

14292: ,pt.plan_class_code
14293: ,bv.etc_start_date
14294: ,nvl(bv.wp_version_flag,'N') wp_version_flag
14295: ,bv.plan_processing_code
14296: FROM pa_budget_versions bv,
14297: pa_fin_plan_types_vl pt
14298: WHERE bv.budget_version_id = c_budget_version_id
14299: AND pt.fin_plan_type_id(+) = bv.fin_plan_type_id
14300: AND bv.ci_id IS NULL; -- -- Added an extra clause bv.ci_id IS NULL--Bug # 3507156

Line 14306: c_project_id pa_budget_versions.project_id%TYPE

14302:
14303: budget_version_info_rec budget_version_info_cur%ROWTYPE;
14304:
14305: CURSOR draft_version_cur(
14306: c_project_id pa_budget_versions.project_id%TYPE
14307: ,c_budget_type_code pa_budget_versions.budget_type_code%TYPE)
14308: IS
14309: SELECT budget_version_id
14310: FROM pa_budget_versions

Line 14307: ,c_budget_type_code pa_budget_versions.budget_type_code%TYPE)

14303: budget_version_info_rec budget_version_info_cur%ROWTYPE;
14304:
14305: CURSOR draft_version_cur(
14306: c_project_id pa_budget_versions.project_id%TYPE
14307: ,c_budget_type_code pa_budget_versions.budget_type_code%TYPE)
14308: IS
14309: SELECT budget_version_id
14310: FROM pa_budget_versions
14311: WHERE project_id = c_project_id

Line 14310: FROM pa_budget_versions

14306: c_project_id pa_budget_versions.project_id%TYPE
14307: ,c_budget_type_code pa_budget_versions.budget_type_code%TYPE)
14308: IS
14309: SELECT budget_version_id
14310: FROM pa_budget_versions
14311: WHERE project_id = c_project_id
14312: AND budget_type_code = c_budget_type_code
14313: AND budget_status_code = 'W'
14314: AND ci_id IS NULL; -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 14348: l_targ_request_id pa_budget_versions.request_id%TYPE;

14344:
14345: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
14346: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
14347: l_bdgt_lines_skip_flag varchar2(1);
14348: l_targ_request_id pa_budget_versions.request_id%TYPE;
14349:
14350: --This variable will be used to call pa_resource_asgn_curr maintenance api - IPM Arch Enhancement
14351: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
14352:

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

16269: END IF;
16270: RAISE FND_API.G_EXC_ERROR;
16271: END IF;
16272: */
16273: --Summarizing the totals in the table pa_budget_versions
16274:
16275: PA_BUDGET_UTILS.summerize_project_totals
16276: (x_budget_version_id => l_budget_version_id,
16277: x_err_code => l_err_code,

Line 16727: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

16723: ,p_calc_burdened_cost_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16724: ,p_calc_revenue_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16725: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16726: -- Bug 2863564 Parameters required for new Fin Plan Model
16727: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16728: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16729: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16730: ,p_version_type IN pa_budget_versions.version_type%TYPE
16731: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE

Line 16730: ,p_version_type IN pa_budget_versions.version_type%TYPE

16726: -- Bug 2863564 Parameters required for new Fin Plan Model
16727: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16728: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16729: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16730: ,p_version_type IN pa_budget_versions.version_type%TYPE
16731: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
16732: ) IS
16733:
16734: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Calculate_Amounts';

Line 16731: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE

16727: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16728: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16729: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16730: ,p_version_type IN pa_budget_versions.version_type%TYPE
16731: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
16732: ) IS
16733:
16734: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Calculate_Amounts';
16735: --Bug 2863564 l_return_status VARCHAR2(1);

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

17103: PROCEDURE CREATE_DRAFT_FINPLAN
17104: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17106: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
17107: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17108: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17109: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17110: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17111: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

17104: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17106: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
17107: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17108: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17109: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17110: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17111: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17112: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17106: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
17107: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17108: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17109: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17110: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17111: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17112: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17113: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17114: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17107: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17108: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17109: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17110: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17111: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17112: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17113: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17114: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17115: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17109: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17110: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17111: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17112: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17113: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17114: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17115: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17116: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17117: ,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 17116: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

17112: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17113: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17114: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17115: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17116: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17117: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17118: ,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
17119: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17120: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17115: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17116: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17117: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17118: ,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
17119: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17120: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17121: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17122: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17123: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17116: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17117: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17118: ,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
17119: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17120: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17121: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17122: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17123: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17124: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17117: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17118: ,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
17119: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17120: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17121: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17122: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17123: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17124: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17125: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17128: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17129: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17130: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
17131: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab
17132: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17133: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17134: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17135: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17136: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17129: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17130: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
17131: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab
17132: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17133: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17134: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17135: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17136: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17137: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17130: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
17131: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab
17132: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17133: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17134: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17135: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17136: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17137: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17138: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17131: ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab
17132: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17133: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17134: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17135: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17136: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17137: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17138: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17139: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17132: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17133: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17134: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17135: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17136: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17137: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17138: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17139: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17140: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17133: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17134: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17135: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17136: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17137: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17138: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17139: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17140: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17141: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17134: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17135: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17136: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17137: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17138: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17139: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17140: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17141: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17142: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17135: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17136: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17137: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17138: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17139: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17140: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17141: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17142: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17143: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17136: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17137: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17138: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17139: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17140: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17141: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17142: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17143: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17144: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17137: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17138: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17139: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17140: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17141: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17142: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17143: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17144: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17145: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17138: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17139: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17140: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17141: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17142: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17143: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17144: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17145: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17146: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17139: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17140: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17141: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17142: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17143: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17144: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17145: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17146: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17147: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

17140: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17141: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17142: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17143: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17144: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17145: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17146: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17147: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17148: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

17141: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17142: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17143: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17144: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17145: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17146: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17147: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17148: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
17149: ,x_return_status OUT NOCOPY VARCHAR2

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

17142: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17143: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17144: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17145: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17146: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17147: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17148: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
17149: ,x_return_status OUT NOCOPY VARCHAR2
17150: ,x_msg_count OUT NOCOPY NUMBER

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

17143: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17144: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17145: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17146: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17147: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17148: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
17149: ,x_return_status OUT NOCOPY VARCHAR2
17150: ,x_msg_count OUT NOCOPY NUMBER
17151: ,x_msg_data OUT NOCOPY VARCHAR2

Line 17159: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

17155:
17156: /* SCALAR VARIABLES */
17157: l_task_number pa_tasks.task_number%TYPE;
17158: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17159: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17160: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17161: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17162: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17163: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 17160: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;

17156: /* SCALAR VARIABLES */
17157: l_task_number pa_tasks.task_number%TYPE;
17158: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17159: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17160: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17161: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17162: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17163: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17164: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 17166: l_created_version_id pa_budget_versions.budget_version_id%TYPE;

17162: l_struct_elem_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
17163: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17164: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17165: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
17166: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
17167: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
17168: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
17169: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
17170: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

Line 17176: l_record_version_number pa_budget_versions.record_version_number%TYPE;

17172: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE := PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT;
17173: l_calling_context VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT;
17174:
17175: l_plan_tran_context VARCHAR2(30);
17176: l_record_version_number pa_budget_versions.record_version_number%TYPE;
17177: l_mixed_resource_planned_flag VARCHAR2(1);
17178: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17179: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17180: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 17179: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;

17175: l_plan_tran_context VARCHAR2(30);
17176: l_record_version_number pa_budget_versions.record_version_number%TYPE;
17177: l_mixed_resource_planned_flag VARCHAR2(1);
17178: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17179: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17180: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17181: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17182:
17183: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

Line 17180: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;

17176: l_record_version_number pa_budget_versions.record_version_number%TYPE;
17177: l_mixed_resource_planned_flag VARCHAR2(1);
17178: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17179: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17180: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17181: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17182:
17183: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17184: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;

Line 17181: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;

17177: l_mixed_resource_planned_flag VARCHAR2(1);
17178: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17179: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17180: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17181: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17182:
17183: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17184: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17185: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;

Line 17187: l_description PA_BUDGET_VERSIONS.description%Type;

17183: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17184: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17185: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17186:
17187: l_description PA_BUDGET_VERSIONS.description%Type;
17188: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17189: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17190: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17188: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;

17184: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17185: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17186:
17187: l_description PA_BUDGET_VERSIONS.description%Type;
17188: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17189: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17190: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17189: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;

17185: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17186:
17187: l_description PA_BUDGET_VERSIONS.description%Type;
17188: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17189: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17190: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17190: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;

17186:
17187: l_description PA_BUDGET_VERSIONS.description%Type;
17188: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17189: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17190: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;

17187: l_description PA_BUDGET_VERSIONS.description%Type;
17188: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17189: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17190: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;

17188: l_attribute_category PA_BUDGET_VERSIONS.attribute_category%Type;
17189: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17190: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;

17189: l_attribute1 PA_BUDGET_VERSIONS.attribute1%Type;
17190: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;

17190: l_attribute2 PA_BUDGET_VERSIONS.attribute2%Type;
17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;

17191: l_attribute3 PA_BUDGET_VERSIONS.attribute2%Type;
17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;

17192: l_attribute4 PA_BUDGET_VERSIONS.attribute2%Type;
17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;

17193: l_attribute5 PA_BUDGET_VERSIONS.attribute2%Type;
17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;

17194: l_attribute6 PA_BUDGET_VERSIONS.attribute2%Type;
17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;

17195: l_attribute7 PA_BUDGET_VERSIONS.attribute2%Type;
17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;

Line 17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;

17196: l_attribute8 PA_BUDGET_VERSIONS.attribute2%Type;
17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17204: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;

Line 17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;

17197: l_attribute9 PA_BUDGET_VERSIONS.attribute2%Type;
17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17204: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17205: l_change_reason_code pa_budget_versions.change_reason_code%type;

Line 17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;

17198: l_attribute10 PA_BUDGET_VERSIONS.attribute2%Type;
17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17204: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17205: l_change_reason_code pa_budget_versions.change_reason_code%type;
17206: l_budget_version_name pa_budget_versions.version_name%type;

Line 17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;

17199: l_attribute11 PA_BUDGET_VERSIONS.attribute2%Type;
17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17204: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17205: l_change_reason_code pa_budget_versions.change_reason_code%type;
17206: l_budget_version_name pa_budget_versions.version_name%type;
17207: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;

Line 17204: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;

17200: l_attribute12 PA_BUDGET_VERSIONS.attribute2%Type;
17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17204: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17205: l_change_reason_code pa_budget_versions.change_reason_code%type;
17206: l_budget_version_name pa_budget_versions.version_name%type;
17207: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17208: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;

Line 17205: l_change_reason_code pa_budget_versions.change_reason_code%type;

17201: l_attribute13 PA_BUDGET_VERSIONS.attribute2%Type;
17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17204: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17205: l_change_reason_code pa_budget_versions.change_reason_code%type;
17206: l_budget_version_name pa_budget_versions.version_name%type;
17207: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17208: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17209: l_version_type pa_budget_versions.version_type%TYPE ;

Line 17206: l_budget_version_name pa_budget_versions.version_name%type;

17202: l_attribute14 PA_BUDGET_VERSIONS.attribute2%Type;
17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17204: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17205: l_change_reason_code pa_budget_versions.change_reason_code%type;
17206: l_budget_version_name pa_budget_versions.version_name%type;
17207: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17208: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17209: l_version_type pa_budget_versions.version_type%TYPE ;
17210: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;

Line 17209: l_version_type pa_budget_versions.version_type%TYPE ;

17205: l_change_reason_code pa_budget_versions.change_reason_code%type;
17206: l_budget_version_name pa_budget_versions.version_name%type;
17207: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17208: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17209: l_version_type pa_budget_versions.version_type%TYPE ;
17210: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
17211: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
17212:
17213: L_RAW_COST_FLAG VARCHAR2(1);

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

18701:
18702: END CREATE_DRAFT_FINPLAN;
18703:
18704: PROCEDURE load_resource_info(
18705: P_PM_PRODUCT_CODE PA_BUDGET_VERSIONS.PM_PRODUCT_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18706: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18707: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18708: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18709: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18852: PROCEDURE EXECUTE_CREATE_DRAFT_FINPLAN
18853: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18854: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18855: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18856: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18857: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18858: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18859: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18860: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

18853: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18854: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18855: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18856: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18857: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18858: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18859: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18860: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18861: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18855: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18856: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18857: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18858: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18859: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18860: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18861: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18862: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18863: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18856: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18857: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18858: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18859: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18860: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18861: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18862: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18863: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18864: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18858: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18859: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18860: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18861: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18862: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18863: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18864: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18865: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18866: ,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 18865: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

18861: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18862: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18863: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18864: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18865: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18866: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18867: ,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
18868: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18869: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18864: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18865: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18866: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18867: ,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
18868: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18869: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18870: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18871: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18872: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18865: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18866: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18867: ,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
18868: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18869: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18870: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18871: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18872: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18873: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18866: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18867: ,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
18868: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18869: ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18870: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18871: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18872: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18873: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18874: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18873: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18874: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18875: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18876: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18877: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18878: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18879: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18880: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18881: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18874: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18875: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18876: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18877: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18878: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18879: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18880: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18881: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18882: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18875: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18876: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18877: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18878: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18879: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18880: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18881: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18882: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18883: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18876: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18877: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18878: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18879: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18880: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18881: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18882: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18883: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18884: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18877: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18878: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18879: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18880: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18881: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18882: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18883: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18884: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18885: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18878: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18879: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18880: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18881: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18882: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18883: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18884: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18885: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18886: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18879: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18880: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18881: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18882: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18883: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18884: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18885: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18886: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18887: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18880: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18881: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18882: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18883: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18884: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18885: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18886: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18887: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18888: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18881: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18882: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18883: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18884: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18885: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18886: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18887: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18888: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18889: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18882: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18883: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18884: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18885: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18886: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18887: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18888: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18889: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18890: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18883: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18884: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18885: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18886: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18887: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18888: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18889: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18890: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18891: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18884: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18885: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18886: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18887: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18888: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18889: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18890: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18891: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18892: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18885: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18886: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18887: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18888: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18889: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18890: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18891: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18892: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18893: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18886: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18887: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18888: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18889: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18890: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18891: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18892: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18893: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18894: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18887: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18888: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18889: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18890: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18891: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18892: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18893: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18894: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18895: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'

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

18888: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18889: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18890: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18891: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18892: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18893: ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18894: ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18895: ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
18896: ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

19076: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19077: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19078: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19079: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19080: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19081: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19082: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19083: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19084: ,p_planning_element_rec_tbl IN planning_element_rec_tbl_type

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

19078: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19079: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19080: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19081: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19082: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19083: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19084: ,p_planning_element_rec_tbl IN planning_element_rec_tbl_type
19085: ,x_msg_count OUT NOCOPY NUMBER
19086: ,x_msg_data OUT NOCOPY VARCHAR2

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

19079: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19080: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19081: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19082: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19083: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19084: ,p_planning_element_rec_tbl IN planning_element_rec_tbl_type
19085: ,x_msg_count OUT NOCOPY NUMBER
19086: ,x_msg_data OUT NOCOPY VARCHAR2
19087: ,x_return_status OUT NOCOPY VARCHAR2)

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

19086: ,x_msg_data OUT NOCOPY VARCHAR2
19087: ,x_return_status OUT NOCOPY VARCHAR2)
19088: IS
19089:
19090: CURSOR c_get_plan_class_code(c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE) is
19091: SELECT plan_class_code
19092: FROM pa_fin_plan_types_b
19093: WHERE fin_plan_type_id=c_fin_plan_type_id;
19094:

Line 19111: l_version_type pa_budget_versions.version_type%TYPE;

19107: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
19108: l_fin_plan_type_id NUMBER;
19109: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
19110: l_fin_plan_class_code varchar2(30);
19111: l_version_type pa_budget_versions.version_type%TYPE;
19112: l_budget_version_id NUMBER;
19113: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
19114: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19115: l_budget_amount_code pa_budget_types.budget_amount_code%type;