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.

[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 271: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

267: This function is used to return resource list id of the finplan version
268: ==============================================================================*/
269:
270: Function Get_Resource_List_Id (
271: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
272: RETURN pa_proj_fp_options.all_resource_list_id%TYPE
273: IS
274:
275: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;

Line 272: RETURN pa_proj_fp_options.all_resource_list_id%TYPE

268: ==============================================================================*/
269:
270: Function Get_Resource_List_Id (
271: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
272: RETURN pa_proj_fp_options.all_resource_list_id%TYPE
273: IS
274:
275: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
276:

Line 275: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;

271: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
272: RETURN pa_proj_fp_options.all_resource_list_id%TYPE
273: IS
274:
275: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
276:
277: BEGIN
278:
279: SELECT DECODE(fin_plan_preference_code,

Line 284: FROM pa_proj_fp_options

280: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_resource_list_id,
281: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_resource_list_id,
282: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_resource_list_id)
283: INTO l_resource_list_id
284: FROM pa_proj_fp_options
285: WHERE fin_plan_version_id = p_fin_plan_version_id;
286:
287: RETURN l_resource_list_id;
288:

Line 300: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

296: financial model.
297: ==============================================================================*/
298:
299: FUNCTION Get_Time_Phased_code (
300: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
301: RETURN pa_proj_fp_options.all_time_phased_code%TYPE
302: IS
303:
304: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;

Line 301: RETURN pa_proj_fp_options.all_time_phased_code%TYPE

297: ==============================================================================*/
298:
299: FUNCTION Get_Time_Phased_code (
300: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
301: RETURN pa_proj_fp_options.all_time_phased_code%TYPE
302: IS
303:
304: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
305: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

Line 307: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;

303:
304: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
305: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
306:
307: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
308:
309: BEGIN
310:
311: -- Fetch the budget_entry_method_code of the budget version.

Line 313: -- 2) If its null, fetch the tim pahsing code from the pa_proj_fp_options table.

309: BEGIN
310:
311: -- Fetch the budget_entry_method_code of the budget version.
312: -- 1) If it is not null, then fetch time phasing code from pa_budget_entry_methods table
313: -- 2) If its null, fetch the tim pahsing code from the pa_proj_fp_options table.
314:
315: BEGIN
316: SELECT budget_type_code,
317: budget_entry_method_code

Line 346: FROM pa_proj_fp_options

342: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_time_phased_code,
343: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_time_phased_code,
344: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_time_phased_code)
345: INTO l_time_phased_code
346: FROM pa_proj_fp_options
347: WHERE fin_plan_version_id = p_fin_plan_version_id;
348: EXCEPTION
349: WHEN OTHERS THEN
350: RETURN NULL;

Line 363: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

359: This function is used to return plan level code of the finplan version
360: ==============================================================================*/
361:
362: FUNCTION Get_Fin_Plan_Level_Code(
363: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
364: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE
365: IS
366:
367: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 364: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE

360: ==============================================================================*/
361:
362: FUNCTION Get_Fin_Plan_Level_Code(
363: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
364: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE
365: IS
366:
367: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
368:

Line 367: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

363: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
364: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE
365: IS
366:
367: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
368:
369: BEGIN
370:
371: SELECT DECODE(fin_plan_preference_code,

Line 376: FROM pa_proj_fp_options

372: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_fin_plan_level_code,
373: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_fin_plan_level_code,
374: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_fin_plan_level_code)
375: INTO l_fin_plan_level_code
376: FROM pa_proj_fp_options
377: WHERE fin_plan_version_id = p_fin_plan_version_id;
378:
379: RETURN l_fin_plan_level_code;
380:

Line 389: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

385: This function is used to return multi currency flag for the finplan version
386: ==============================================================================*/
387:
388: FUNCTION Get_Multi_Curr_Flag(
389: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
390: RETURN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
391: IS
392:
393: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 390: RETURN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

386: ==============================================================================*/
387:
388: FUNCTION Get_Multi_Curr_Flag(
389: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
390: RETURN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
391: IS
392:
393: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
394:

Line 393: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

389: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
390: RETURN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
391: IS
392:
393: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
394:
395: BEGIN
396:
397: SELECT PLAN_IN_MULTI_CURR_FLAG

Line 399: FROM pa_proj_fp_options

395: BEGIN
396:
397: SELECT PLAN_IN_MULTI_CURR_FLAG
398: INTO l_multi_curr_flag
399: FROM pa_proj_fp_options
400: WHERE fin_plan_version_id = p_fin_plan_version_id;
401:
402: RETURN l_multi_curr_flag;
403:

Line 415: P_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,

411: Modifying the type of the IN parameter p_element_type
412: below as pa_fp_elements is being obsoleted. */
413:
414: FUNCTION GET_OPTION_PLANNING_LEVEL(
415: P_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
416: /* p_element_type IN pa_fp_elements.element_type%TYPE)
417: Modified as part of Changes for FP.M, Tracking Bug No - 3354518*/
418: p_element_type IN pa_budget_versions.version_type%TYPE)
419: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE

Line 419: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE

415: P_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
416: /* p_element_type IN pa_fp_elements.element_type%TYPE)
417: Modified as part of Changes for FP.M, Tracking Bug No - 3354518*/
418: p_element_type IN pa_budget_versions.version_type%TYPE)
419: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE
420: IS
421: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
422:
423: BEGIN

Line 421: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

417: Modified as part of Changes for FP.M, Tracking Bug No - 3354518*/
418: p_element_type IN pa_budget_versions.version_type%TYPE)
419: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE
420: IS
421: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
422:
423: BEGIN
424:
425: SELECT DECODE(fin_plan_preference_code,

Line 433: FROM pa_proj_fp_options

429: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP,
430: DECODE(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,cost_fin_plan_level_code,
431: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code))
432: INTO l_fin_plan_level_code
433: FROM pa_proj_fp_options
434: WHERE proj_fp_options_id = p_proj_fp_options_id;
435:
436: RETURN l_fin_plan_level_code;
437:

Line 446: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )

442: This function is used to return amount set id of the finplan version
443: ==============================================================================*/
444:
445: FUNCTION Get_Amount_Set_Id(
446: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
447: RETURN pa_proj_fp_options.all_amount_set_id%TYPE
448: IS
449:
450: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

Line 447: RETURN pa_proj_fp_options.all_amount_set_id%TYPE

443: ==============================================================================*/
444:
445: FUNCTION Get_Amount_Set_Id(
446: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
447: RETURN pa_proj_fp_options.all_amount_set_id%TYPE
448: IS
449:
450: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
451:

Line 450: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

446: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
447: RETURN pa_proj_fp_options.all_amount_set_id%TYPE
448: IS
449:
450: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
451:
452: BEGIN
453:
454: SELECT DECODE(fin_plan_preference_code,

Line 459: FROM pa_proj_fp_options

455: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_amount_set_id,
456: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_amount_set_id,
457: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_amount_set_id)
458: INTO l_amount_set_id
459: FROM pa_proj_fp_options
460: WHERE fin_plan_version_id = p_fin_plan_version_id;
461:
462: RETURN l_amount_set_id;
463:

Line 545: x_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;

541: ==============================================================================*/
542: FUNCTION Get_wp_bv_time_phase
543: (p_wp_structure_version_id IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE)
544: RETURN VARCHAR2 IS
545: x_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
546: BEGIN
547: SELECT DECODE(BV.VERSION_TYPE,
548: 'COST', OPT.COST_TIME_PHASED_CODE,
549: 'REVENUE',OPT.REVENUE_TIME_PHASED_CODE,

Line 552: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT

548: 'COST', OPT.COST_TIME_PHASED_CODE,
549: 'REVENUE',OPT.REVENUE_TIME_PHASED_CODE,
550: 'ALL',OPT.ALL_TIME_PHASED_CODE)
551: INTO x_time_phased_code
552: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT
553: WHERE BV.BUDGET_VERSION_ID = OPT.FIN_PLAN_VERSION_ID
554: AND BV.PROJECT_STRUCTURE_VERSION_ID = p_wp_structure_version_id
555: AND NVL(BV.WP_VERSION_FLAG,'N') = 'Y'
556: AND bv.project_id = opt.project_id -- added bug 6892631

Line 609: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895

605: PROCEDURE Get_Baselined_Version_Info(
606: p_project_id IN pa_projects_all.project_id%TYPE
607: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
608: ,p_version_type IN pa_budget_versions.version_type%TYPE
609: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
610: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
611: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
612: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
613: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 610: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

606: p_project_id IN pa_projects_all.project_id%TYPE
607: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
608: ,p_version_type IN pa_budget_versions.version_type%TYPE
609: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
610: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
611: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
612: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
613: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
614: AS

Line 627: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

623: l_debug_mode VARCHAR2(30);
624:
625: --End of variables used for debugging
626:
627: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
628: l_version_type pa_budget_versions.version_type%TYPE;
629: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
630: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
631:

Line 630: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

626:
627: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
628: l_version_type pa_budget_versions.version_type%TYPE;
629: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
630: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
631:
632:
633: BEGIN
634:

Line 682: FROM pa_proj_fp_options

678: END IF;
679:
680: SELECT fin_plan_preference_code
681: INTO l_fp_preference_code
682: FROM pa_proj_fp_options
683: WHERE project_id = p_project_id
684: AND fin_plan_type_id = p_fin_plan_type_id
685: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
686:

Line 757: FROM pa_proj_fp_options

753: END IF;
754:
755: SELECT proj_fp_options_id
756: INTO l_fp_options_id
757: FROM pa_proj_fp_options
758: WHERE fin_plan_version_id = l_baselined_version_id;
759:
760: EXCEPTION
761:

Line 842: -- 2. pa_proj_fp_options

838: -- This has been added as part of code merge
839: -- This procedure deletes the Financial Planning data pertaining
840: -- to the project id given as input parameter from
841: -- 1. pa_fp_txn_currencies
842: -- 2. pa_proj_fp_options
843: -- 3. pa_fp_elements
844: -- 4. pa_proj_period_profiles
845: --==========================================================================
846:

Line 853: -- delete from pa_proj_fp_options table

849: , x_err_code IN OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
850: is
851: begin
852:
853: -- delete from pa_proj_fp_options table
854: delete from pa_proj_fp_options where project_id=p_project_id;
855:
856: -- delete from pa_fp_txn_currencies table
857: delete from pa_fp_txn_currencies where project_id=p_project_id;

Line 854: delete from pa_proj_fp_options where project_id=p_project_id;

850: is
851: begin
852:
853: -- delete from pa_proj_fp_options table
854: delete from pa_proj_fp_options where project_id=p_project_id;
855:
856: -- delete from pa_fp_txn_currencies table
857: delete from pa_fp_txn_currencies where project_id=p_project_id;
858:

Line 918: from pa_proj_fp_options

914: ,p_proj_curr_code IN PA_FP_TXN_CURRENCIES.TXN_CURRENCY_CODE%TYPE)
915: is
916: cursor get_all_fp_options_cur is
917: select proj_fp_options_id
918: from pa_proj_fp_options
919: where project_id = p_project_id;
920:
921: get_all_fp_options_rec get_all_fp_options_cur%ROWTYPE;
922:

Line 948: in pa_proj_fp_options, if the newly entered project currency is different from the

944: and project_currency_flag='N'
945: and proj_fp_options_id = c_proj_fp_options_id;
946:
947: /* Bug 5364011: The following code is introduced to update the plan_in_multi_curr_flag as 'Y'
948: in pa_proj_fp_options, if the newly entered project currency is different from the
949: existing project funtional currency. */
950: TYPE plan_in_multi_curr_tbl IS TABLE OF pa_proj_fp_options.proj_fp_options_id%TYPE
951: INDEX BY BINARY_INTEGER;
952: l_plan_in_multi_curr_tbl plan_in_multi_curr_tbl;

Line 950: TYPE plan_in_multi_curr_tbl IS TABLE OF pa_proj_fp_options.proj_fp_options_id%TYPE

946:
947: /* Bug 5364011: The following code is introduced to update the plan_in_multi_curr_flag as 'Y'
948: in pa_proj_fp_options, if the newly entered project currency is different from the
949: existing project funtional currency. */
950: TYPE plan_in_multi_curr_tbl IS TABLE OF pa_proj_fp_options.proj_fp_options_id%TYPE
951: INDEX BY BINARY_INTEGER;
952: l_plan_in_multi_curr_tbl plan_in_multi_curr_tbl;
953: cnt NUMBER := 0;
954:

Line 1093: in pa_proj_fp_options, if the newly entered project currency is different from the existing

1089: end if; -- trim(l_proj_curr_code) <> trim(p_proj_curr_code)
1090: end if;
1091:
1092: /* Bug 5364011: The following code is introduced to update the plan_in_multi_curr_flag as 'Y'
1093: in pa_proj_fp_options, if the newly entered project currency is different from the existing
1094: project functional currency. */
1095: IF trim(p_proj_curr_code) <> trim(l_projfunc_curr_code) THEN
1096: cnt := cnt+1;
1097: l_plan_in_multi_curr_tbl(cnt) := get_all_fp_options_rec.proj_fp_options_id;

Line 1102: in pa_proj_fp_options, if the newly entered project currency is different from the existing

1098: END IF;
1099:
1100: end loop;
1101: /* Bug 5364011: The following code is introduced to update the plan_in_multi_curr_flag as 'Y'
1102: in pa_proj_fp_options, if the newly entered project currency is different from the existing
1103: project functional currency. */
1104: IF l_plan_in_multi_curr_tbl.COUNT > 0 THEN
1105: FORALL opt IN l_plan_in_multi_curr_tbl.FIRST..l_plan_in_multi_curr_tbl.LAST
1106: UPDATE pa_proj_fp_options

Line 1106: UPDATE pa_proj_fp_options

1102: in pa_proj_fp_options, if the newly entered project currency is different from the existing
1103: project functional currency. */
1104: IF l_plan_in_multi_curr_tbl.COUNT > 0 THEN
1105: FORALL opt IN l_plan_in_multi_curr_tbl.FIRST..l_plan_in_multi_curr_tbl.LAST
1106: UPDATE pa_proj_fp_options
1107: SET plan_in_multi_curr_flag = 'Y',
1108: record_version_number = record_version_number+1
1109: WHERE proj_fp_options_id = l_plan_in_multi_curr_tbl(opt);
1110: END IF;

Line 1133: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895

1129: PROCEDURE Get_Curr_Working_Version_Info(
1130: p_project_id IN pa_projects_all.project_id%TYPE
1131: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
1132: ,p_version_type IN pa_budget_versions.version_type%TYPE
1133: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
1134: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
1135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1136: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1137: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1134: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

1130: p_project_id IN pa_projects_all.project_id%TYPE
1131: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
1132: ,p_version_type IN pa_budget_versions.version_type%TYPE
1133: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
1134: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
1135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1136: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1137: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1138: AS

Line 1153: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

1149:
1150: --End of variables used for debugging
1151:
1152:
1153: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1154: l_version_type pa_budget_versions.version_type%TYPE;
1155: l_current_working_version_id pa_budget_versions.budget_version_id%TYPE;
1156: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1157:

Line 1156: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

1152:
1153: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1154: l_version_type pa_budget_versions.version_type%TYPE;
1155: l_current_working_version_id pa_budget_versions.budget_version_id%TYPE;
1156: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1157:
1158:
1159: BEGIN
1160:

Line 1208: FROM pa_proj_fp_options

1204: END IF;
1205:
1206: SELECT fin_plan_preference_code
1207: INTO l_fp_preference_code
1208: FROM pa_proj_fp_options
1209: WHERE project_id = p_project_id
1210: AND fin_plan_type_id = p_fin_plan_type_id
1211: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
1212:

Line 1283: FROM pa_proj_fp_options

1279: END IF;
1280:
1281: SELECT proj_fp_options_id
1282: INTO l_fp_options_id
1283: FROM pa_proj_fp_options
1284: WHERE fin_plan_version_id = l_current_working_version_id;
1285:
1286: EXCEPTION
1287:

Line 1369: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

1365:
1366:
1367: PROCEDURE Get_Appr_Cost_Plan_Type_Info(
1368: p_project_id IN pa_projects_all.project_id%TYPE
1369: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
1370: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1371: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1372: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1373: AS

Line 1387: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

1383: l_debug_mode VARCHAR2(30);
1384:
1385: --End of variables used for debugging
1386:
1387: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1388:
1389:
1390: BEGIN
1391:

Line 1442: FROM pa_proj_fp_options

1438: END IF;
1439:
1440: SELECT fin_plan_type_id
1441: INTO l_fin_plan_type_id
1442: FROM pa_proj_fp_options
1443: WHERE project_id = p_project_id
1444: AND fin_plan_option_level_code = 'PLAN_TYPE'
1445: AND approved_cost_plan_type_flag = 'Y';
1446:

Line 1525: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

1521: ==============================================================================*/
1522:
1523: PROCEDURE Get_Appr_Rev_Plan_Type_Info(
1524: p_project_id IN pa_projects_all.project_id%TYPE
1525: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
1526: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1527: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1528: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1529: AS

Line 1542: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

1538: l_debug_mode VARCHAR2(30);
1539:
1540: --End of variables used for debugging
1541:
1542: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1543:
1544:
1545: BEGIN
1546:

Line 1597: FROM pa_proj_fp_options

1593: END IF;
1594:
1595: SELECT fin_plan_type_id
1596: INTO l_fin_plan_type_id
1597: FROM pa_proj_fp_options
1598: WHERE project_id = p_project_id
1599: AND fin_plan_option_level_code = 'PLAN_TYPE'
1600: AND approved_rev_plan_type_flag = 'Y';
1601:

Line 1685: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,

1681: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
1682: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
1683: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
1684: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
1685: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
1686: /* Changes for FP.M, Tracking Bug No - 3354518
1687: Adding three new IN parameters p_bill_rate_flag,
1688: p_cost_rate_flag, p_burden_rate below for
1689: new columns in pa_fin_plan_amount_sets */

Line 3175: (p_project_id PA_PROJ_FP_OPTIONS.PROJECT_ID%type)

3171: END check_resource_name_or_id;
3172:
3173:
3174: FUNCTION Check_Proj_Fp_Options_Exists
3175: (p_project_id PA_PROJ_FP_OPTIONS.PROJECT_ID%type)
3176: return NUMBER
3177: IS
3178: l_dummy number;
3179: BEGIN

Line 3191: (select 1 from pa_proj_fp_options pfo, pa_fin_plan_types_b pft -- Added pa_fin_plan_types_b for FP.M changes

3187: This column indicates if a plan type is being
3188: used for workplan or not.
3189: So adding a join to pa_fin_plan_types_b and checking status of use_for_workplan_flag.
3190: Without this check the function would return success status even if WP plantype exists */
3191: (select 1 from pa_proj_fp_options pfo, pa_fin_plan_types_b pft -- Added pa_fin_plan_types_b for FP.M changes
3192: where pfo.project_id = p_project_id
3193: /*Changes for FP.M start here */
3194: and pfo.fin_plan_option_level_code='PLAN_TYPE' /*bug 3224177 added fin_plan_option_level_code check*/
3195: and nvl(pfo.fin_plan_type_id,-99) = pft.fin_plan_type_id

Line 3542: pa_proj_fp_options table has been included to fetch all the options that

3538: BEGIN
3539: /* Bug 3106741
3540: Modified the second exists clause to avoid FT scan on pa_fp_txn_currencies
3541: table. As an index is available on proj_fp_options_id for the above table,
3542: pa_proj_fp_options table has been included to fetch all the options that
3543: belong to a given project.
3544: */
3545:
3546: /* Commenting out the select statment below for FP.M, Tracking Bug No - 3354518

Line 3562: from pa_proj_fp_options pfo,

3558: pa_budget_versions bv
3559: where bl.budget_version_id = bv.budget_version_id
3560: and bv.project_id = p_project_id)
3561: OR exists (Select 'x' -- included for bug 3224177
3562: from pa_proj_fp_options pfo,
3563: pa_projects_all pa where
3564: pfo.project_id = pa.project_id and
3565: pa.project_id = p_project_id and
3566: pfo.fin_plan_option_level_code = 'PLAN_TYPE');

Line 3570: pa_proj_fp_options pfo, -- bug 3106741

3566: pfo.fin_plan_option_level_code = 'PLAN_TYPE');
3567: /* commented for bug 3224177 starts
3568: OR exists (Select 'x'
3569: from pa_fp_txn_currencies fpcurr,
3570: pa_proj_fp_options pfo, -- bug 3106741
3571: pa_projects_all pa
3572: where pa.project_currency_code = fpcurr.txn_currency_code
3573: and pa.project_id = fpcurr.project_id
3574: and fpcurr.project_currency_flag = 'Y'

Line 3592: from pa_proj_fp_options pfo, pa_fin_plan_types_b pft ,

3588: pa_budget_versions bv
3589: where bl.budget_version_id = bv.budget_version_id
3590: and bv.project_id = p_project_id)
3591: OR exists (Select 'x' -- included for bug 3224177
3592: from pa_proj_fp_options pfo, pa_fin_plan_types_b pft ,
3593: pa_projects_all pa
3594: where pfo.project_id = pa.project_id and
3595: pa.project_id = p_project_id and
3596: /* Commented out the below for bug 5364011*/

Line 3615: from pa_proj_fp_options po /* Bug# 2665767 - Plan type option alone can be checked */

3611: (p_project_id IN pa_projects_all.project_id%TYPE)
3612: return VARCHAR2 is
3613: Cursor c1 is
3614: Select 'Y'
3615: from pa_proj_fp_options po /* Bug# 2665767 - Plan type option alone can be checked */
3616: where po.approved_rev_plan_type_flag = 'Y'
3617: and po.fin_plan_preference_code = 'COST_AND_REV_SAME'
3618: and po.fin_plan_option_level_code = 'PLAN_TYPE'
3619: and po.project_id = p_project_id;

Line 4011: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

4007:
4008:
4009: PROCEDURE Is_AC_PT_Attached_After_UPG(
4010: p_project_id IN pa_projects_all.project_id%TYPE
4011: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
4012: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4013: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4014: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4015: AS

Line 4029: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

4025: l_debug_mode VARCHAR2(30);
4026:
4027: --End of variables used for debugging
4028:
4029: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
4030: l_budget_type_code pa_budget_types.budget_type_code%Type;
4031: l_ac_budget_type_code pa_budget_types.budget_type_code%TYPE := 'AC'; --Bug 3764635.
4032:
4033: BEGIN

Line 4194: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

4190: ==============================================================================*/
4191:
4192: PROCEDURE Is_AR_PT_Attached_After_UPG(
4193: p_project_id IN pa_projects_all.project_id%TYPE
4194: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
4195: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4196: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4197: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4198: AS

Line 4211: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

4207: l_debug_mode VARCHAR2(30);
4208:
4209: --End of variables used for debugging
4210:
4211: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
4212: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
4213: l_ar_budget_type_code pa_budget_types.budget_type_code%TYPE := 'AR'; --Bug 3764635.
4214:
4215: BEGIN

Line 4570: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE

4566:
4567: END Get_Max_Budget_Version_Number;
4568:
4569: FUNCTION get_period_start_date (p_input_date IN pa_periods_all.start_date%TYPE,
4570: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE
4571: IS
4572: l_start_date pa_periods_all.start_date%TYPE;
4573: BEGIN
4574: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4605: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE

4601: return NULL;
4602: END;
4603:
4604: FUNCTION get_period_end_date (p_input_date IN pa_periods_all.end_date%TYPE,
4605: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE
4606: IS
4607: l_end_date pa_periods_all.end_date%TYPE;
4608: BEGIN
4609: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4669: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

4665: l_err_code NUMBER;
4666: l_err_stage VARCHAR2(2000);
4667: l_err_stack VARCHAR2(2000);
4668:
4669: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4670: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4671:
4672: l_version_type pa_budget_versions.version_type%TYPE;
4673:

Line 4670: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

4666: l_err_stage VARCHAR2(2000);
4667: l_err_stack VARCHAR2(2000);
4668:
4669: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4670: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4671:
4672: l_version_type pa_budget_versions.version_type%TYPE;
4673:
4674: BEGIN

Line 4731: FROM pa_proj_fp_options

4727:
4728: BEGIN
4729: SELECT fin_plan_preference_code
4730: INTO l_fin_plan_preference_code
4731: FROM pa_proj_fp_options
4732: WHERE project_id = p_project_id
4733: AND fin_plan_type_id = p_fin_plan_type_id
4734: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
4735: EXCEPTION

Line 4869: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

4865: l_err_code NUMBER;
4866: l_err_stage VARCHAR2(2000);
4867: l_err_stack VARCHAR2(2000);
4868:
4869: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4870: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4871:
4872: l_version_type pa_budget_versions.version_type%TYPE;
4873:

Line 4870: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

4866: l_err_stage VARCHAR2(2000);
4867: l_err_stack VARCHAR2(2000);
4868:
4869: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4870: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4871:
4872: l_version_type pa_budget_versions.version_type%TYPE;
4873:
4874: BEGIN

Line 4931: FROM pa_proj_fp_options

4927:
4928: BEGIN
4929: SELECT fin_plan_preference_code
4930: INTO l_fin_plan_preference_code
4931: FROM pa_proj_fp_options
4932: WHERE project_id = p_project_id
4933: AND fin_plan_type_id = p_fin_plan_type_id
4934: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
4935: EXCEPTION

Line 6150: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

6146: are valid or not. This is called from VALIDATE_CURRENCY_ATTRIBUTES when it is called from
6147: AMG
6148: */
6149: PROCEDURE VALIDATE_INPUT_PARAMS
6150: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6151: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6152: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6153: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 6151: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

6147: AMG
6148: */
6149: PROCEDURE VALIDATE_INPUT_PARAMS
6150: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6151: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6152: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6153: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 6152: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

6148: */
6149: PROCEDURE VALIDATE_INPUT_PARAMS
6150: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6151: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6152: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6153: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6156: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 6153: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

6149: PROCEDURE VALIDATE_INPUT_PARAMS
6150: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6151: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6152: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6153: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6156: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6157: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

6150: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6151: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6152: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6153: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6156: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6157: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6158: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

Line 6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

6151: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6152: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6153: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6156: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6157: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6158: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6159: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

Line 6156: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

6152: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6153: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6156: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6157: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6158: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6159: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6160: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

Line 6157: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

6153: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6156: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6157: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6158: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6159: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6160: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
6161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 6342: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

6338: RATE_NULL which indicates that the rate passed is null
6339: */
6340:
6341: PROCEDURE VALIDATE_CONV_ATTRIBUTES
6342: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6343: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6344: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6345: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6346: ,p_amount_type_code IN VARCHAR2

Line 6343: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

6339: */
6340:
6341: PROCEDURE VALIDATE_CONV_ATTRIBUTES
6342: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6343: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6344: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6345: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6346: ,p_amount_type_code IN VARCHAR2
6347: ,p_currency_type_code IN VARCHAR2

Line 6344: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

6340:
6341: PROCEDURE VALIDATE_CONV_ATTRIBUTES
6342: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6343: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6344: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6345: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6346: ,p_amount_type_code IN VARCHAR2
6347: ,p_currency_type_code IN VARCHAR2
6348: ,p_calling_context IN VARCHAR2

Line 6661: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895

6657: AMG_API (for AMG APIs)
6658: */
6659:
6660: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
6661: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6662: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

Line 6662: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

6658: */
6659:
6660: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
6661: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6662: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 6663: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895

6659:
6660: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
6661: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6662: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

Line 6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

6661: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6662: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895

Line 6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

6662: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

6663: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895

Line 6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895

6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6673: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895

Line 6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6673: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6674: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895

6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6673: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6674: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6675: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895

Line 6673: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895

6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6673: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6674: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6675: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6676: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6677: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

Line 6674: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6673: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6674: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6675: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6676: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6677: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6678: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

Line 6675: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895

6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6673: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6674: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6675: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6676: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6677: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6678: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6679: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

Line 6695: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;

6691: l_return_status VARCHAR2(2000);
6692: l_debug_mode VARCHAR2(30);
6693: /*
6694: l_loop_count NUMBER;
6695: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;
6696: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;
6697: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
6698: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
6699: l_validity_code VARCHAR2(30);*/

Line 6696: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;

6692: l_debug_mode VARCHAR2(30);
6693: /*
6694: l_loop_count NUMBER;
6695: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;
6696: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;
6697: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
6698: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
6699: l_validity_code VARCHAR2(30);*/
6700: l_pc_cost_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;

Line 6697: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;

6693: /*
6694: l_loop_count NUMBER;
6695: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;
6696: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;
6697: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
6698: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
6699: l_validity_code VARCHAR2(30);*/
6700: l_pc_cost_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;
6701: l_pc_rev_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;

Line 7141: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

7137: ==================================================================*/
7138:
7139: PROCEDURE GET_PLAN_TYPE_OPTS_FOR_VER
7140: (
7141: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
7142: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
7143: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
7144: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
7145: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 7142: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

7138:
7139: PROCEDURE GET_PLAN_TYPE_OPTS_FOR_VER
7140: (
7141: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
7142: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
7143: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
7144: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
7145: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7146: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7143: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895

7139: PROCEDURE GET_PLAN_TYPE_OPTS_FOR_VER
7140: (
7141: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
7142: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
7143: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
7144: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
7145: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7146: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7147: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 7158: cursor plan_type_cur(c_version_id pa_proj_fp_options.fin_plan_version_id%TYPE) is

7154: l_msg_data VARCHAR2(2000);
7155: l_msg_index_out NUMBER;
7156: l_debug_mode VARCHAR2(1);
7157:
7158: cursor plan_type_cur(c_version_id pa_proj_fp_options.fin_plan_version_id%TYPE) is
7159: select o.fin_plan_type_id,o.proj_fp_options_id,v.version_type
7160: from pa_proj_fp_options o,pa_budget_versions v
7161: where o.fin_plan_type_id = v.fin_plan_type_id
7162: and o.project_id = v.project_id

Line 7160: from pa_proj_fp_options o,pa_budget_versions v

7156: l_debug_mode VARCHAR2(1);
7157:
7158: cursor plan_type_cur(c_version_id pa_proj_fp_options.fin_plan_version_id%TYPE) is
7159: select o.fin_plan_type_id,o.proj_fp_options_id,v.version_type
7160: from pa_proj_fp_options o,pa_budget_versions v
7161: where o.fin_plan_type_id = v.fin_plan_type_id
7162: and o.project_id = v.project_id
7163: and v.budget_version_id = c_version_id
7164: and o.fin_plan_option_level_code = 'PLAN_TYPE';

Line 7416: Added use_for_workplan_flag column from pa_proj_fp_options

7412: l_msg_index_out NUMBER;
7413: l_debug_mode VARCHAR2(1);
7414:
7415: /* Changes for FP.M, Tracking Bug No - 3354518
7416: Added use_for_workplan_flag column from pa_proj_fp_options
7417: in the select statment below
7418: Please note that this API will not be called for Workplan Usage*/
7419:
7420: cursor autobaseline_appr_rev_info_cur is

Line 7423: FROM pa_projects_all pr, pa_proj_fp_options pfo,

7419:
7420: cursor autobaseline_appr_rev_info_cur is
7421: SELECT nvl(pr.baseline_funding_flag,'N') baseline_funding_flag, pfo.approved_rev_plan_type_flag,
7422: pft.use_for_workplan_flag -- Added for FP.M ,Tracking Bug No - 3354518
7423: FROM pa_projects_all pr, pa_proj_fp_options pfo,
7424: pa_fin_plan_types_b pft -- Added for FP.M ,Tracking Bug No - 3354518
7425: WHERE pr.project_id = pfo.project_id
7426: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
7427: AND pfo.fin_plan_type_id = p_fin_plan_type_id

Line 7715: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

7711: --Vesion type should be passed when the preference code of the plan type is
7712: --COST_AND_REV_SEP, else an error will be thrown
7713: PROCEDURE get_version_type
7714: ( p_project_id IN pa_projects_all.project_id%TYPE
7715: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
7716: ,px_version_type IN OUT NOCOPY pa_budget_Versions.version_type%TYPE --File.Sql.39 bug 4440895
7717: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7718: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7719: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 7725: FROM pa_proj_fp_options

7721:
7722: CURSOR l_proj_fp_options_csr
7723: IS
7724: SELECT fin_plan_preference_code
7725: FROM pa_proj_fp_options
7726: WHERE project_id=p_project_id
7727: AND fin_plan_type_id=p_fin_plan_type_id
7728: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
7729:

Line 8013: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

8009: -- If found returns valid budget version id
8010: -- Null is returned other wise
8011: PROCEDURE get_version_id
8012: ( p_project_id IN pa_projects_all.project_id%TYPE
8013: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
8014: ,p_version_type IN pa_budget_Versions.version_type%TYPE
8015: ,p_version_number IN pa_budget_Versions.version_number%TYPE
8016: ,x_budget_version_id OUT NOCOPY pa_budget_Versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
8017: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895

Line 8176: ,pa_proj_fp_options pfo

8172: ,pbv.version_type
8173: ,pfo.approved_rev_plan_type_flag
8174: ,p.baseline_funding_flag
8175: FROM pa_budget_versions pbv
8176: ,pa_proj_fp_options pfo
8177: ,pa_projects_all p
8178: WHERE pbv.budget_version_id=p_budget_version_id
8179: AND pfo.fin_plan_version_id(+)=pbv.budget_version_id
8180: AND p.project_id=pbv.project_id;

Line 9592: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

9588: FUNCTION Get_Budgeted_Amount
9589: (
9590: p_project_id IN pa_projects_all.project_id%TYPE
9591: , p_task_id IN pa_tasks.task_id%TYPE
9592: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
9593: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
9594: , p_amount_type IN VARCHAR2
9595: ) RETURN NUMBER
9596: IS

Line 10011: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895

10007: PROCEDURE Get_Curr_Original_Version_Info(
10008: p_project_id IN pa_projects_all.project_id%TYPE
10009: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
10010: ,p_version_type IN pa_budget_versions.version_type%TYPE
10011: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
10012: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
10013: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10014: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10015: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 10012: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

10008: p_project_id IN pa_projects_all.project_id%TYPE
10009: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
10010: ,p_version_type IN pa_budget_versions.version_type%TYPE
10011: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
10012: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
10013: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10014: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10015: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
10016: AS

Line 10030: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

10026: l_debug_mode VARCHAR2(30);
10027:
10028: --End of variables used for debugging
10029:
10030: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
10031: l_version_type pa_budget_versions.version_type%TYPE;
10032: l_current_original_version_id pa_budget_versions.budget_version_id%TYPE;
10033: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10034:

Line 10033: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

10029:
10030: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
10031: l_version_type pa_budget_versions.version_type%TYPE;
10032: l_current_original_version_id pa_budget_versions.budget_version_id%TYPE;
10033: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10034:
10035: BEGIN
10036:
10037: x_msg_count := 0;

Line 10083: FROM pa_proj_fp_options

10079: END IF;
10080:
10081: SELECT fin_plan_preference_code
10082: INTO l_fp_preference_code
10083: FROM pa_proj_fp_options
10084: WHERE project_id = p_project_id
10085: AND fin_plan_type_id = p_fin_plan_type_id
10086: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
10087:

Line 10158: FROM pa_proj_fp_options

10154: END IF;
10155:
10156: SELECT proj_fp_options_id
10157: INTO l_fp_options_id
10158: FROM pa_proj_fp_options
10159: WHERE fin_plan_version_id = l_current_original_version_id;
10160:
10161: EXCEPTION
10162:

Line 10704: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

10700: ==============================================================================*/
10701:
10702: PROCEDURE IS_PRI_FCST_COST_PT_ATTACHED(
10703: p_project_id IN pa_projects_all.project_id%TYPE
10704: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
10705: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10706: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10707: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
10708: AS

Line 10759: FROM pa_proj_fp_options

10755:
10756: BEGIN
10757: SELECT fin_plan_type_id
10758: INTO x_plan_type_id
10759: FROM pa_proj_fp_options
10760: WHERE project_id = p_project_id
10761: AND fin_plan_option_level_code = 'PLAN_TYPE'
10762: AND nvl(primary_cost_forecast_flag,'N') = 'Y' ;
10763: EXCEPTION

Line 10827: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895

10823: ==============================================================================*/
10824:
10825: PROCEDURE IS_PRI_FCST_REV_PT_ATTACHED(
10826: p_project_id IN pa_projects_all.project_id%TYPE
10827: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
10828: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10829: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10830: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
10831: AS

Line 10881: FROM pa_proj_fp_options

10877:
10878: BEGIN
10879: SELECT fin_plan_type_id
10880: INTO x_plan_type_id
10881: FROM pa_proj_fp_options
10882: WHERE project_id = p_project_id
10883: AND fin_plan_option_level_code = 'PLAN_TYPE'
10884: AND nvl(primary_rev_forecast_flag,'N') = 'Y' ;
10885: EXCEPTION

Line 10952: from pa_proj_fp_options a, pa_fin_plan_types_b b

10948: select 'Y'
10949: into l_wp_resource_list_flag
10950: from dual
10951: where exists (select 'x'
10952: from pa_proj_fp_options a, pa_fin_plan_types_b b
10953: where a.project_id = p_project_id
10954: and a.fin_plan_option_level_code <> 'PROJECT'
10955: and a.fin_plan_type_id = b.fin_plan_type_id
10956: and (a.cost_resource_list_id = p_resource_list_id or

Line 10978: from pa_proj_fp_options a

10974: select 'Y'
10975: into l_fp_resource_list_flag
10976: from dual
10977: where exists (select 'x'
10978: from pa_proj_fp_options a
10979: where a.project_id = p_project_id
10980: and not exists (select 'x'
10981: from pa_fin_plan_types_b b
10982: where a.fin_plan_type_id = b.fin_plan_type_id

Line 11007: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

11003: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11004: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11005: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11006: IS
11007: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
11008: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
11009:
11010: -- Start of variables used for debugging purpose
11011:

Line 11008: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

11004: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11005: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11006: IS
11007: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
11008: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
11009:
11010: -- Start of variables used for debugging purpose
11011:
11012: l_msg_count NUMBER :=0;

Line 11068: FROM pa_proj_fp_options

11064:
11065: BEGIN
11066: SELECT fin_plan_preference_code
11067: INTO l_plan_pref_code
11068: FROM pa_proj_fp_options
11069: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
11070: AND project_id = p_project_id
11071: AND fin_plan_type_id = p_fin_plan_type_id;
11072: EXCEPTION

Line 11216: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code - Bug 3734840 --File.Sql.39 bug 4440895

11212: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11213: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11214: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895
11215: ,X_margin_percent OUT NOCOPY Number -- Margin percent --File.Sql.39 bug 4440895
11216: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code - Bug 3734840 --File.Sql.39 bug 4440895
11217: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11218: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11219: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11220: IS

Line 11221: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

11217: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11218: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11219: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11220: IS
11221: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
11222: l_budget_version_id Pa_budget_versions.budget_version_id%TYPE;
11223:
11224: -- Start of variables used for debugging purpose
11225:

Line 11312: FROM pa_proj_fp_options pfo

11308: IF l_budget_version_id IS NOT NULL THEN
11309: BEGIN
11310: SELECT nvl(pfo.margin_derived_from_code,'B')
11311: INTO l_margin_derived_from_code
11312: FROM pa_proj_fp_options pfo
11313: WHERE pfo.fin_plan_version_id=l_budget_version_id ;
11314: EXCEPTION
11315: WHEN NO_DATA_FOUND THEN
11316: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 11501: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895

11497: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11498: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
11499: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
11500: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
11501: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895
11502: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11503: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11504: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11505: IS

Line 11873: FROM PA_PROJ_FP_OPTIONS

11869: SELECT 'N'
11870: INTO l_delete_ok
11871: FROM DUAL
11872: WHERE EXISTS (SELECT 1
11873: FROM PA_PROJ_FP_OPTIONS
11874: WHERE RES_CLASS_RAW_COST_SCH_ID = p_bill_rate_sch_id OR
11875: RES_CLASS_BILL_RATE_SCH_ID = p_bill_rate_sch_id OR
11876: COST_EMP_RATE_SCH_ID = p_bill_rate_sch_id OR
11877: COST_JOB_RATE_SCH_ID = p_bill_rate_sch_id OR

Line 11935: FROM PA_PROJ_FP_OPTIONS

11931: SELECT 'N'
11932: INTO l_delete_ok
11933: FROM DUAL
11934: WHERE EXISTS (SELECT 1
11935: FROM PA_PROJ_FP_OPTIONS
11936: WHERE COST_BURDEN_RATE_SCH_ID = p_ind_rate_sch_id);
11937:
11938: EXCEPTION
11939: WHEN NO_DATA_FOUND THEN

Line 12898: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE

12894:
12895: FUNCTION Is_source_for_gen_options
12896: (p_project_id IN pa_projects_all.project_id%TYPE
12897: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
12898: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
12899: ) RETURN VARCHAR2 IS
12900:
12901: l_valid_status VARCHAR2(1) := 'S';
12902: l_exists VARCHAR2(1);

Line 12915: FROM PA_PROJ_FP_OPTIONS

12911: a source of generation fot other plan types*/
12912: BEGIN
12913: IF ( p_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
12914: SELECT 1 INTO l_exists FROM dual WHERE EXISTS (SELECT fin_plan_type_id
12915: FROM PA_PROJ_FP_OPTIONS
12916: WHERE Project_id = p_project_id AND
12917: (GEN_SRC_REV_PLAN_TYPE_ID = p_fin_plan_type_id
12918: OR GEN_SRC_COST_PLAN_TYPE_ID= p_fin_plan_type_id
12919: OR GEN_SRC_ALL_PLAN_TYPE_ID = p_fin_plan_type_id));

Line 13145: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

13141: */
13142: FUNCTION get_cached_time_phased_code (bv_id IN pa_budget_versions.budget_version_id%TYPE)
13143: RETURN VARCHAR2
13144: IS
13145: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13146: BEGIN
13147: IF g_fp_wa_time_phased_code IS NOT NULL THEN
13148: l_time_phased_code := g_fp_wa_time_phased_code;
13149: ELSE

Line 13204: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13200: /*Parameters due fin plan model */
13201: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13202: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13203: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13204: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13206: ,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
13207: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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 13205: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13201: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13202: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13203: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13204: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13206: ,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
13207: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 13206: ,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

13202: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13203: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13204: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13206: ,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
13207: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13207: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13203: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13204: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13206: ,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
13207: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13208: ,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

13204: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13206: ,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
13207: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

13205: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13206: ,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
13207: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13206: ,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
13207: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13207: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

13208: ,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
13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13216: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13209: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13216: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13217: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13210: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13216: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13217: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13218: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 13215: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

13211: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13216: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13217: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13218: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13219: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13216: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13212: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13216: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13217: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13218: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13219: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13220: ,p_burdened_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13217: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13213: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13216: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13217: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13218: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13219: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13220: ,p_burdened_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13221: ,p_revenue_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13218: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

13214: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13216: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13217: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13218: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13219: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13220: ,p_burdened_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13221: ,p_revenue_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13222: ,p_cost_qty_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13244: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

13240: l_debug_level5 CONSTANT NUMBER := 5;
13241: l_workflow_started VARCHAR2(1);
13242: --End of variables used for debugging
13243: l_budget_lines_out_tbl pa_budget_pub.budget_line_out_tbl_type;
13244: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
13245: l_version_type pa_budget_versions.version_type%TYPE;
13246: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
13247: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
13248: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

Line 13247: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

13243: l_budget_lines_out_tbl pa_budget_pub.budget_line_out_tbl_type;
13244: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
13245: l_version_type pa_budget_versions.version_type%TYPE;
13246: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
13247: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
13248: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
13249:
13250: -- Bug 8681652
13251: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

Line 13642: (p_project_id IN pa_proj_fp_options.project_id%TYPE,

13638: -- gboomina added for bug 8318932 - start
13639: /* B-F -This function is used to get the
13640: copy_etc_from_plan_flag in the generation options in case of cost forecast*/
13641: FUNCTION get_copy_etc_from_plan_flag
13642: (p_project_id IN pa_proj_fp_options.project_id%TYPE,
13643: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
13644: p_fin_plan_option_code IN pa_proj_fp_options.fin_plan_option_level_code%TYPE,
13645: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
13646: RETURN pa_proj_fp_options.copy_etc_from_plan_flag%type

Line 13643: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,

13639: /* B-F -This function is used to get the
13640: copy_etc_from_plan_flag in the generation options in case of cost forecast*/
13641: FUNCTION get_copy_etc_from_plan_flag
13642: (p_project_id IN pa_proj_fp_options.project_id%TYPE,
13643: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
13644: p_fin_plan_option_code IN pa_proj_fp_options.fin_plan_option_level_code%TYPE,
13645: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
13646: RETURN pa_proj_fp_options.copy_etc_from_plan_flag%type
13647: IS

Line 13644: p_fin_plan_option_code IN pa_proj_fp_options.fin_plan_option_level_code%TYPE,

13640: copy_etc_from_plan_flag in the generation options in case of cost forecast*/
13641: FUNCTION get_copy_etc_from_plan_flag
13642: (p_project_id IN pa_proj_fp_options.project_id%TYPE,
13643: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
13644: p_fin_plan_option_code IN pa_proj_fp_options.fin_plan_option_level_code%TYPE,
13645: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
13646: RETURN pa_proj_fp_options.copy_etc_from_plan_flag%type
13647: IS
13648: l_copy_etc_from_plan_flag pa_proj_fp_options.copy_etc_from_plan_flag%type ;

Line 13646: RETURN pa_proj_fp_options.copy_etc_from_plan_flag%type

13642: (p_project_id IN pa_proj_fp_options.project_id%TYPE,
13643: p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
13644: p_fin_plan_option_code IN pa_proj_fp_options.fin_plan_option_level_code%TYPE,
13645: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
13646: RETURN pa_proj_fp_options.copy_etc_from_plan_flag%type
13647: IS
13648: l_copy_etc_from_plan_flag pa_proj_fp_options.copy_etc_from_plan_flag%type ;
13649: BEGIN
13650: -- Modified to get copy etc from plan flag at plan type level also

Line 13648: l_copy_etc_from_plan_flag pa_proj_fp_options.copy_etc_from_plan_flag%type ;

13644: p_fin_plan_option_code IN pa_proj_fp_options.fin_plan_option_level_code%TYPE,
13645: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
13646: RETURN pa_proj_fp_options.copy_etc_from_plan_flag%type
13647: IS
13648: l_copy_etc_from_plan_flag pa_proj_fp_options.copy_etc_from_plan_flag%type ;
13649: BEGIN
13650: -- Modified to get copy etc from plan flag at plan type level also
13651: IF p_budget_version_id is NOT NULL THEN
13652: select pr.copy_etc_from_plan_flag

Line 13654: from pa_budget_versions bu, pa_proj_fp_options pr

13650: -- Modified to get copy etc from plan flag at plan type level also
13651: IF p_budget_version_id is NOT NULL THEN
13652: select pr.copy_etc_from_plan_flag
13653: into l_copy_etc_from_plan_flag
13654: from pa_budget_versions bu, pa_proj_fp_options pr
13655: where bu.budget_version_id = pr.fin_plan_version_id and
13656: bu.budget_version_id = p_budget_version_id ;
13657: ELSE
13658: select copy_etc_from_plan_flag

Line 13660: from pa_proj_fp_options

13656: bu.budget_version_id = p_budget_version_id ;
13657: ELSE
13658: select copy_etc_from_plan_flag
13659: into l_copy_etc_from_plan_flag
13660: from pa_proj_fp_options
13661: where project_id = p_project_id
13662: and fin_plan_type_id = p_fin_plan_type_id
13663: and fin_plan_option_level_code = p_fin_plan_option_code;
13664: END IF;