eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_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:

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

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

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

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

Line 625: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

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

Line 628: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

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

Line 680: FROM pa_proj_fp_options

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

Line 755: FROM pa_proj_fp_options

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

Line 840: -- 2. pa_proj_fp_options

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

Line 851: -- delete from pa_proj_fp_options table

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

Line 852: delete from pa_proj_fp_options where project_id=p_project_id;

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

Line 916: from pa_proj_fp_options

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

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

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

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

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

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

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

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

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

Line 1104: UPDATE pa_proj_fp_options

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

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

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

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

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

Line 1151: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

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

Line 1154: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

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

Line 1206: FROM pa_proj_fp_options

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

Line 1281: FROM pa_proj_fp_options

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

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

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

Line 1385: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

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

Line 1440: FROM pa_proj_fp_options

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

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

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

Line 1540: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

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

Line 1595: FROM pa_proj_fp_options

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

Line 1683: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,

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

Line 3173: (p_project_id PA_PROJ_FP_OPTIONS.PROJECT_ID%type)

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

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

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

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

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

Line 3560: from pa_proj_fp_options pfo,

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

Line 3568: pa_proj_fp_options pfo, -- bug 3106741

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

Line 3590: from pa_proj_fp_options pfo, pa_fin_plan_types_b pft ,

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

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

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

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

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

Line 4027: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

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

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

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

Line 4209: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

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

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

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

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

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

Line 4667: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

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

Line 4668: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

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

Line 4729: FROM pa_proj_fp_options

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

Line 4867: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

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

Line 4868: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

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

Line 4929: FROM pa_proj_fp_options

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

Line 6144: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

6140: are valid or not. This is called from VALIDATE_CURRENCY_ATTRIBUTES when it is called from
6141: AMG
6142: */
6143: PROCEDURE VALIDATE_INPUT_PARAMS
6144: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6145: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6146: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6147: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6148: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 6145: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

6141: AMG
6142: */
6143: PROCEDURE VALIDATE_INPUT_PARAMS
6144: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6145: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6146: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6147: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6148: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6149: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 6146: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

6142: */
6143: PROCEDURE VALIDATE_INPUT_PARAMS
6144: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6145: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6146: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6147: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6148: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6149: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6150: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 6147: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

6143: PROCEDURE VALIDATE_INPUT_PARAMS
6144: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6145: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6146: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6147: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6148: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6149: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6150: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6151: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 6148: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

6144: (p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
6145: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6146: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6147: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6148: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6149: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6150: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6151: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6152: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

Line 6149: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

6145: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
6146: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6147: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6148: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6149: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6150: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6151: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6152: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6153: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

Line 6150: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

6146: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
6147: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6148: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6149: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6150: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6151: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6152: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6153: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6154: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

Line 6151: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

6147: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
6148: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6149: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
6150: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6151: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6152: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6153: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6154: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
6155: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

6332: RATE_NULL which indicates that the rate passed is null
6333: */
6334:
6335: PROCEDURE VALIDATE_CONV_ATTRIBUTES
6336: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6337: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6338: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6339: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6340: ,p_amount_type_code IN VARCHAR2

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

6333: */
6334:
6335: PROCEDURE VALIDATE_CONV_ATTRIBUTES
6336: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6337: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6338: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6339: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6340: ,p_amount_type_code IN VARCHAR2
6341: ,p_currency_type_code IN VARCHAR2

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

6334:
6335: PROCEDURE VALIDATE_CONV_ATTRIBUTES
6336: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6337: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6338: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6339: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6340: ,p_amount_type_code IN VARCHAR2
6341: ,p_currency_type_code IN VARCHAR2
6342: ,p_calling_context IN VARCHAR2

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

6651: AMG_API (for AMG APIs)
6652: */
6653:
6654: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
6655: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6656: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6657: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6658: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6659: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

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

6652: */
6653:
6654: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
6655: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6656: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6657: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6658: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6659: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6660: ,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 6657: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895

6653:
6654: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
6655: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6656: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6657: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6658: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6659: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6660: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

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

6655: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6656: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6657: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6658: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6659: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6660: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6662: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895

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

6656: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6657: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6658: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6659: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6660: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6662: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6664: ,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 6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

6657: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6658: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6659: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6660: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6662: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895

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

6659: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6660: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6662: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6666: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895

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

6660: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6662: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6666: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6668: ,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 6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895

6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6662: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6666: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6669: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895

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

6663: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6666: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6669: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6670: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6671: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

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

6664: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6666: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6669: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6670: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6671: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6672: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

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

6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6666: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6669: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6670: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6671: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6672: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6673: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

Line 6689: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;

6685: l_return_status VARCHAR2(2000);
6686: l_debug_mode VARCHAR2(30);
6687: /*
6688: l_loop_count NUMBER;
6689: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;
6690: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;
6691: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
6692: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
6693: l_validity_code VARCHAR2(30);*/

Line 6690: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;

6686: l_debug_mode VARCHAR2(30);
6687: /*
6688: l_loop_count NUMBER;
6689: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;
6690: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;
6691: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
6692: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
6693: l_validity_code VARCHAR2(30);*/
6694: l_pc_cost_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;

Line 6691: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;

6687: /*
6688: l_loop_count NUMBER;
6689: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;
6690: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;
6691: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
6692: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
6693: l_validity_code VARCHAR2(30);*/
6694: l_pc_cost_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;
6695: l_pc_rev_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;

Line 7135: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

7131: ==================================================================*/
7132:
7133: PROCEDURE GET_PLAN_TYPE_OPTS_FOR_VER
7134: (
7135: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
7136: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
7137: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
7138: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
7139: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

7132:
7133: PROCEDURE GET_PLAN_TYPE_OPTS_FOR_VER
7134: (
7135: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
7136: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
7137: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
7138: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
7139: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7140: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

7133: PROCEDURE GET_PLAN_TYPE_OPTS_FOR_VER
7134: (
7135: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
7136: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
7137: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
7138: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
7139: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7140: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7141: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

7148: l_msg_data VARCHAR2(2000);
7149: l_msg_index_out NUMBER;
7150: l_debug_mode VARCHAR2(1);
7151:
7152: cursor plan_type_cur(c_version_id pa_proj_fp_options.fin_plan_version_id%TYPE) is
7153: select o.fin_plan_type_id,o.proj_fp_options_id,v.version_type
7154: from pa_proj_fp_options o,pa_budget_versions v
7155: where o.fin_plan_type_id = v.fin_plan_type_id
7156: and o.project_id = v.project_id

Line 7154: from pa_proj_fp_options o,pa_budget_versions v

7150: l_debug_mode VARCHAR2(1);
7151:
7152: cursor plan_type_cur(c_version_id pa_proj_fp_options.fin_plan_version_id%TYPE) is
7153: select o.fin_plan_type_id,o.proj_fp_options_id,v.version_type
7154: from pa_proj_fp_options o,pa_budget_versions v
7155: where o.fin_plan_type_id = v.fin_plan_type_id
7156: and o.project_id = v.project_id
7157: and v.budget_version_id = c_version_id
7158: and o.fin_plan_option_level_code = 'PLAN_TYPE';

Line 7410: Added use_for_workplan_flag column from pa_proj_fp_options

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

Line 7417: FROM pa_projects_all pr, pa_proj_fp_options pfo,

7413:
7414: cursor autobaseline_appr_rev_info_cur is
7415: SELECT nvl(pr.baseline_funding_flag,'N') baseline_funding_flag, pfo.approved_rev_plan_type_flag,
7416: pft.use_for_workplan_flag -- Added for FP.M ,Tracking Bug No - 3354518
7417: FROM pa_projects_all pr, pa_proj_fp_options pfo,
7418: pa_fin_plan_types_b pft -- Added for FP.M ,Tracking Bug No - 3354518
7419: WHERE pr.project_id = pfo.project_id
7420: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
7421: AND pfo.fin_plan_type_id = p_fin_plan_type_id

Line 7709: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

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

Line 7719: FROM pa_proj_fp_options

7715:
7716: CURSOR l_proj_fp_options_csr
7717: IS
7718: SELECT fin_plan_preference_code
7719: FROM pa_proj_fp_options
7720: WHERE project_id=p_project_id
7721: AND fin_plan_type_id=p_fin_plan_type_id
7722: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
7723:

Line 8007: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

8003: -- If found returns valid budget version id
8004: -- Null is returned other wise
8005: PROCEDURE get_version_id
8006: ( p_project_id IN pa_projects_all.project_id%TYPE
8007: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
8008: ,p_version_type IN pa_budget_Versions.version_type%TYPE
8009: ,p_version_number IN pa_budget_Versions.version_number%TYPE
8010: ,x_budget_version_id OUT NOCOPY pa_budget_Versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
8011: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895

Line 8170: ,pa_proj_fp_options pfo

8166: ,pbv.version_type
8167: ,pfo.approved_rev_plan_type_flag
8168: ,p.baseline_funding_flag
8169: FROM pa_budget_versions pbv
8170: ,pa_proj_fp_options pfo
8171: ,pa_projects_all p
8172: WHERE pbv.budget_version_id=p_budget_version_id
8173: AND pfo.fin_plan_version_id(+)=pbv.budget_version_id
8174: AND p.project_id=pbv.project_id;

Line 9586: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

9582: FUNCTION Get_Budgeted_Amount
9583: (
9584: p_project_id IN pa_projects_all.project_id%TYPE
9585: , p_task_id IN pa_tasks.task_id%TYPE
9586: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
9587: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
9588: , p_amount_type IN VARCHAR2
9589: ) RETURN NUMBER
9590: IS

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

10001: PROCEDURE Get_Curr_Original_Version_Info(
10002: p_project_id IN pa_projects_all.project_id%TYPE
10003: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
10004: ,p_version_type IN pa_budget_versions.version_type%TYPE
10005: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
10006: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
10007: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10008: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10009: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

10002: p_project_id IN pa_projects_all.project_id%TYPE
10003: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
10004: ,p_version_type IN pa_budget_versions.version_type%TYPE
10005: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
10006: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
10007: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10008: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10009: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
10010: AS

Line 10024: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

10020: l_debug_mode VARCHAR2(30);
10021:
10022: --End of variables used for debugging
10023:
10024: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
10025: l_version_type pa_budget_versions.version_type%TYPE;
10026: l_current_original_version_id pa_budget_versions.budget_version_id%TYPE;
10027: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10028:

Line 10027: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

10023:
10024: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
10025: l_version_type pa_budget_versions.version_type%TYPE;
10026: l_current_original_version_id pa_budget_versions.budget_version_id%TYPE;
10027: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10028:
10029: BEGIN
10030:
10031: x_msg_count := 0;

Line 10077: FROM pa_proj_fp_options

10073: END IF;
10074:
10075: SELECT fin_plan_preference_code
10076: INTO l_fp_preference_code
10077: FROM pa_proj_fp_options
10078: WHERE project_id = p_project_id
10079: AND fin_plan_type_id = p_fin_plan_type_id
10080: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
10081:

Line 10152: FROM pa_proj_fp_options

10148: END IF;
10149:
10150: SELECT proj_fp_options_id
10151: INTO l_fp_options_id
10152: FROM pa_proj_fp_options
10153: WHERE fin_plan_version_id = l_current_original_version_id;
10154:
10155: EXCEPTION
10156:

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

10694: ==============================================================================*/
10695:
10696: PROCEDURE IS_PRI_FCST_COST_PT_ATTACHED(
10697: p_project_id IN pa_projects_all.project_id%TYPE
10698: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
10699: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10700: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10701: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
10702: AS

Line 10753: FROM pa_proj_fp_options

10749:
10750: BEGIN
10751: SELECT fin_plan_type_id
10752: INTO x_plan_type_id
10753: FROM pa_proj_fp_options
10754: WHERE project_id = p_project_id
10755: AND fin_plan_option_level_code = 'PLAN_TYPE'
10756: AND nvl(primary_cost_forecast_flag,'N') = 'Y' ;
10757: EXCEPTION

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

10817: ==============================================================================*/
10818:
10819: PROCEDURE IS_PRI_FCST_REV_PT_ATTACHED(
10820: p_project_id IN pa_projects_all.project_id%TYPE
10821: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
10822: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10823: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10824: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
10825: AS

Line 10875: FROM pa_proj_fp_options

10871:
10872: BEGIN
10873: SELECT fin_plan_type_id
10874: INTO x_plan_type_id
10875: FROM pa_proj_fp_options
10876: WHERE project_id = p_project_id
10877: AND fin_plan_option_level_code = 'PLAN_TYPE'
10878: AND nvl(primary_rev_forecast_flag,'N') = 'Y' ;
10879: EXCEPTION

Line 10946: from pa_proj_fp_options a, pa_fin_plan_types_b b

10942: select 'Y'
10943: into l_wp_resource_list_flag
10944: from dual
10945: where exists (select 'x'
10946: from pa_proj_fp_options a, pa_fin_plan_types_b b
10947: where a.project_id = p_project_id
10948: and a.fin_plan_option_level_code <> 'PROJECT'
10949: and a.fin_plan_type_id = b.fin_plan_type_id
10950: and (a.cost_resource_list_id = p_resource_list_id or

Line 10972: from pa_proj_fp_options a

10968: select 'Y'
10969: into l_fp_resource_list_flag
10970: from dual
10971: where exists (select 'x'
10972: from pa_proj_fp_options a
10973: where a.project_id = p_project_id
10974: and not exists (select 'x'
10975: from pa_fin_plan_types_b b
10976: where a.fin_plan_type_id = b.fin_plan_type_id

Line 11001: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

10997: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
10998: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
10999: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11000: IS
11001: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
11002: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
11003:
11004: -- Start of variables used for debugging purpose
11005:

Line 11002: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

10998: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
10999: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11000: IS
11001: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
11002: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
11003:
11004: -- Start of variables used for debugging purpose
11005:
11006: l_msg_count NUMBER :=0;

Line 11062: FROM pa_proj_fp_options

11058:
11059: BEGIN
11060: SELECT fin_plan_preference_code
11061: INTO l_plan_pref_code
11062: FROM pa_proj_fp_options
11063: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
11064: AND project_id = p_project_id
11065: AND fin_plan_type_id = p_fin_plan_type_id;
11066: EXCEPTION

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

11206: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11207: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11208: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895
11209: ,X_margin_percent OUT NOCOPY Number -- Margin percent --File.Sql.39 bug 4440895
11210: ,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
11211: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11212: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11213: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11214: IS

Line 11215: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

11211: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11212: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11213: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11214: IS
11215: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
11216: l_budget_version_id Pa_budget_versions.budget_version_id%TYPE;
11217:
11218: -- Start of variables used for debugging purpose
11219:

Line 11306: FROM pa_proj_fp_options pfo

11302: IF l_budget_version_id IS NOT NULL THEN
11303: BEGIN
11304: SELECT nvl(pfo.margin_derived_from_code,'B')
11305: INTO l_margin_derived_from_code
11306: FROM pa_proj_fp_options pfo
11307: WHERE pfo.fin_plan_version_id=l_budget_version_id ;
11308: EXCEPTION
11309: WHEN NO_DATA_FOUND THEN
11310: IF P_PA_DEBUG_MODE = 'Y' THEN

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

11491: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11492: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
11493: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
11494: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
11495: ,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
11496: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11497: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11498: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11499: IS

Line 11867: FROM PA_PROJ_FP_OPTIONS

11863: SELECT 'N'
11864: INTO l_delete_ok
11865: FROM DUAL
11866: WHERE EXISTS (SELECT 1
11867: FROM PA_PROJ_FP_OPTIONS
11868: WHERE RES_CLASS_RAW_COST_SCH_ID = p_bill_rate_sch_id OR
11869: RES_CLASS_BILL_RATE_SCH_ID = p_bill_rate_sch_id OR
11870: COST_EMP_RATE_SCH_ID = p_bill_rate_sch_id OR
11871: COST_JOB_RATE_SCH_ID = p_bill_rate_sch_id OR

Line 11929: FROM PA_PROJ_FP_OPTIONS

11925: SELECT 'N'
11926: INTO l_delete_ok
11927: FROM DUAL
11928: WHERE EXISTS (SELECT 1
11929: FROM PA_PROJ_FP_OPTIONS
11930: WHERE COST_BURDEN_RATE_SCH_ID = p_ind_rate_sch_id);
11931:
11932: EXCEPTION
11933: WHEN NO_DATA_FOUND THEN

Line 12892: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE

12888:
12889: FUNCTION Is_source_for_gen_options
12890: (p_project_id IN pa_projects_all.project_id%TYPE
12891: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
12892: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
12893: ) RETURN VARCHAR2 IS
12894:
12895: l_valid_status VARCHAR2(1) := 'S';
12896: l_exists VARCHAR2(1);

Line 12909: FROM PA_PROJ_FP_OPTIONS

12905: a source of generation fot other plan types*/
12906: BEGIN
12907: IF ( p_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
12908: SELECT 1 INTO l_exists FROM dual WHERE EXISTS (SELECT fin_plan_type_id
12909: FROM PA_PROJ_FP_OPTIONS
12910: WHERE Project_id = p_project_id AND
12911: (GEN_SRC_REV_PLAN_TYPE_ID = p_fin_plan_type_id
12912: OR GEN_SRC_COST_PLAN_TYPE_ID= p_fin_plan_type_id
12913: OR GEN_SRC_ALL_PLAN_TYPE_ID = p_fin_plan_type_id));

Line 13139: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

13135: */
13136: FUNCTION get_cached_time_phased_code (bv_id IN pa_budget_versions.budget_version_id%TYPE)
13137: RETURN VARCHAR2
13138: IS
13139: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13140: BEGIN
13141: IF g_fp_wa_time_phased_code IS NOT NULL THEN
13142: l_time_phased_code := g_fp_wa_time_phased_code;
13143: ELSE

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

13194: /*Parameters due fin plan model */
13195: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13196: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13197: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13198: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13199: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13200: ,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
13201: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13202: ,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 13199: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13195: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13196: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13197: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13198: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13199: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13200: ,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
13201: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13202: ,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
13203: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

13196: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13197: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13198: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13199: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13200: ,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
13201: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13202: ,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
13203: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13204: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

13197: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13198: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13199: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13200: ,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
13201: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13202: ,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
13203: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13204: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,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 13202: ,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

13198: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13199: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13200: ,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
13201: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13202: ,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
13203: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13204: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,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
13206: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

13199: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13200: ,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
13201: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13202: ,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
13203: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13204: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,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
13206: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13207: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

13200: ,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
13201: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13202: ,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
13203: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13204: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,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
13206: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13207: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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 13205: ,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

13201: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13202: ,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
13203: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13204: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,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
13206: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13207: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

13202: ,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
13203: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13204: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,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
13206: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13207: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

13203: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13204: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,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
13206: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13207: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,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 13208: ,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

13204: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13205: ,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
13206: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13207: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,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
13212: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

13205: ,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
13206: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13207: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,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
13212: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

13206: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13207: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,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
13212: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_burdened_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

13207: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13208: ,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
13209: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,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
13212: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_burdened_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_revenue_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

13208: ,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
13209: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13210: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13211: ,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
13212: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
13213: ,p_raw_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13214: ,p_burdened_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13215: ,p_revenue_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13216: ,p_cost_qty_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13238: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

13234: l_debug_level5 CONSTANT NUMBER := 5;
13235: l_workflow_started VARCHAR2(1);
13236: --End of variables used for debugging
13237: l_budget_lines_out_tbl pa_budget_pub.budget_line_out_tbl_type;
13238: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
13239: l_version_type pa_budget_versions.version_type%TYPE;
13240: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
13241: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
13242: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

Line 13241: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

13237: l_budget_lines_out_tbl pa_budget_pub.budget_line_out_tbl_type;
13238: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
13239: l_version_type pa_budget_versions.version_type%TYPE;
13240: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
13241: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
13242: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
13243:
13244: BEGIN
13245: