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_FP_VIEW_PLANS_TXN_PUB dependencies on PA_FP_VIEW_PLANS_TXN_PUB

Line 1: PACKAGE BODY pa_fp_view_plans_txn_pub as

1: PACKAGE BODY pa_fp_view_plans_txn_pub as
2: /* $Header: PAFPVPNB.pls 120.1 2005/08/19 16:31:28 mwasowic noship $
3: Start of Comments
4: Package name : pa_fp_view_plans_txn_pub
5: Purpose : API's for Financial Planning: View Plans Non-Hgrid Page

Line 4: Package name : pa_fp_view_plans_txn_pub

1: PACKAGE BODY pa_fp_view_plans_txn_pub as
2: /* $Header: PAFPVPNB.pls 120.1 2005/08/19 16:31:28 mwasowic noship $
3: Start of Comments
4: Package name : pa_fp_view_plans_txn_pub
5: Purpose : API's for Financial Planning: View Plans Non-Hgrid Page
6: History :
7: NOTE :
8: End of Comments

Line 16: return pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;

12: g_plsql_max_array_size NUMBER := 200;
13:
14: function Get_Multicurrency_Flag return VARCHAR2 is
15: BEGIN
16: return pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
17: END Get_Multicurrency_Flag;
18:
19: function Get_Plan_Type_Id return NUMBER is
20: BEGIN

Line 21: return pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID;

17: END Get_Multicurrency_Flag;
18:
19: function Get_Plan_Type_Id return NUMBER is
20: BEGIN
21: return pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID;
22: END Get_Plan_Type_Id;
23:
24: function Get_Cost_Version_Id return NUMBER is
25: BEGIN

Line 26: return pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;

22: END Get_Plan_Type_Id;
23:
24: function Get_Cost_Version_Id return NUMBER is
25: BEGIN
26: return pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
27: END Get_Cost_Version_Id;
28:
29: function Get_Rev_Version_Id return NUMBER is
30: BEGIN

Line 31: return pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;

27: END Get_Cost_Version_Id;
28:
29: function Get_Rev_Version_Id return NUMBER is
30: BEGIN
31: return pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
32: END Get_Rev_Version_Id;
33:
34: function Get_Single_Version_Id return NUMBER is
35: BEGIN

Line 36: return pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID;

32: END Get_Rev_Version_Id;
33:
34: function Get_Single_Version_Id return NUMBER is
35: BEGIN
36: return pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID;
37: END Get_Single_Version_Id;
38:
39: function Get_Cost_Resource_List_Id return NUMBER is
40: BEGIN

Line 41: return pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID;

37: END Get_Single_Version_Id;
38:
39: function Get_Cost_Resource_List_Id return NUMBER is
40: BEGIN
41: return pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID;
42: END Get_Cost_Resource_List_Id;
43:
44: function Get_Revenue_Resource_List_Id return NUMBER is
45: BEGIN

Line 46: return pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID;

42: END Get_Cost_Resource_List_Id;
43:
44: function Get_Revenue_Resource_List_Id return NUMBER is
45: BEGIN
46: return pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID;
47: END Get_Revenue_Resource_List_Id;
48:
49: function Get_Report_Labor_Hrs_From_Code return VARCHAR2 is
50: BEGIN

Line 51: return pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;

47: END Get_Revenue_Resource_List_Id;
48:
49: function Get_Report_Labor_Hrs_From_Code return VARCHAR2 is
50: BEGIN
51: return pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
52: END Get_Report_Labor_Hrs_From_Code;
53:
54: function Get_Derive_Margin_From_Code return VARCHAR2 is
55: BEGIN

Line 56: return pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE;

52: END Get_Report_Labor_Hrs_From_Code;
53:
54: function Get_Derive_Margin_From_Code return VARCHAR2 is
55: BEGIN
56: return pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE;
57: END Get_Derive_Margin_From_Code;
58:
59: function Get_Display_From return VARCHAR2 is
60: BEGIN

Line 61: return pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;

57: END Get_Derive_Margin_From_Code;
58:
59: function Get_Display_From return VARCHAR2 is
60: BEGIN
61: return pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
62: END;
63:
64: function Get_Cost_Version_Grouping return VARCHAR2 is
65: BEGIN

Line 66: return pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING;

62: END;
63:
64: function Get_Cost_Version_Grouping return VARCHAR2 is
65: BEGIN
66: return pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING;
67: END;
68:
69: function Get_Rev_Version_Grouping return VARCHAR2 is
70: BEGIN

Line 71: return pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING;

67: END;
68:
69: function Get_Rev_Version_Grouping return VARCHAR2 is
70: BEGIN
71: return pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING;
72: END;
73:
74: function Get_Cost_RV_Num return NUMBER is
75: BEGIN

Line 76: return pa_fp_view_plans_txn_pub.G_COST_RECORD_VERSION_NUM;

72: END;
73:
74: function Get_Cost_RV_Num return NUMBER is
75: BEGIN
76: return pa_fp_view_plans_txn_pub.G_COST_RECORD_VERSION_NUM;
77: END;
78:
79: function Get_Rev_RV_Num return NUMBER is
80: BEGIN

Line 81: return pa_fp_view_plans_txn_pub.G_REV_RECORD_VERSION_NUM;

77: END;
78:
79: function Get_Rev_RV_Num return NUMBER is
80: BEGIN
81: return pa_fp_view_plans_txn_pub.G_REV_RECORD_VERSION_NUM;
82: END;
83:
84: --
85: -- BUG FIX 2615852: need to recognize if all txn currencies entered for a ra

Line 283: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '100: entered procedure', 2);

279: l_module_name VARCHAR2(100);
280: l_msg_index_out NUMBER;
281:
282: BEGIN
283: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '100: entered procedure', 2);
284: x_msg_count := 0;
285: l_module_name:='pa_fp_view_plans_txn_pub';
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287: pa_debug.set_err_stack('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize');

Line 285: l_module_name:='pa_fp_view_plans_txn_pub';

281:
282: BEGIN
283: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '100: entered procedure', 2);
284: x_msg_count := 0;
285: l_module_name:='pa_fp_view_plans_txn_pub';
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287: pa_debug.set_err_stack('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize');
288: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
289: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 287: pa_debug.set_err_stack('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize');

283: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '100: entered procedure', 2);
284: x_msg_count := 0;
285: l_module_name:='pa_fp_view_plans_txn_pub';
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287: pa_debug.set_err_stack('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize');
288: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
289: l_debug_mode := NVL(l_debug_mode, 'Y');
290: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
291: IF ( p_cost_version_id IS NULL

Line 320: pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID := l_version_id;

316: l_version_id :=p_rev_version_id;
317: END IF;
318:
319:
320: pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID := l_version_id;
321:
322: SELECT nvl(bv.approved_cost_plan_type_flag, 'N'),
323: nvl(bv.approved_rev_plan_type_flag, 'N')
324: INTO l_ac_flag,

Line 339: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJFUNC';

335: select projfunc_currency_code
336: into x_project_currency
337: from pa_projects_all
338: where project_id = p_project_id;
339: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJFUNC';
340: else
341: -- NOT APPROVED REVENUE: go with Project Currency
342: x_ar_ac_flag := 'N';
343: -- get PROJECT CURRENCY

Line 348: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJECT';

344: select project_currency_code
345: into x_project_currency
346: from pa_projects_all
347: where project_id = p_project_id;
348: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJECT';
349: end if; -- approved revenue flag
350:
351: select fin_plan_type_id,
352: NVL(plan_in_multi_curr_flag, 'N'),

Line 375: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;

371: from pa_proj_fp_options
372: where project_id = p_project_id and
373: fin_plan_type_id = l_fin_plan_type_id and
374: fin_plan_option_level_code = 'PLAN_TYPE';
375: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;
376: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := l_multi_curr_flag;
377:
378: -- get PLAN TYPE NAME
379: select name

Line 376: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := l_multi_curr_flag;

372: where project_id = p_project_id and
373: fin_plan_type_id = l_fin_plan_type_id and
374: fin_plan_option_level_code = 'PLAN_TYPE';
375: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;
376: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := l_multi_curr_flag;
377:
378: -- get PLAN TYPE NAME
379: select name
380: into x_plan_type_name

Line 394: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;

390: from pa_proj_fp_options
391: where project_id = p_project_id and
392: fin_plan_type_id = l_fin_plan_type_id and
393: fin_plan_option_level_code = 'PLAN_TYPE';
394: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
395: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
396:
397:
398: /*Fix for bug 2699644 starts*/

Line 395: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;

391: where project_id = p_project_id and
392: fin_plan_type_id = l_fin_plan_type_id and
393: fin_plan_option_level_code = 'PLAN_TYPE';
394: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
395: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
396:
397:
398: /*Fix for bug 2699644 starts*/
399: /*Get the values for the revenue version id and populate the global variables with those

Line 424: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_cost_version_id;

420: WHERE bv.budget_version_id = p_cost_version_id and
421: bv.resource_list_id = rl.resource_list_id;
422:
423:
424: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_cost_version_id;
425: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
426: IF l_fp_preference_code = 'COST_AND_REV_SAME' THEN
427: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
428: ELSE

Line 425: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;

421: bv.resource_list_id = rl.resource_list_id;
422:
423:
424: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_cost_version_id;
425: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
426: IF l_fp_preference_code = 'COST_AND_REV_SAME' THEN
427: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
428: ELSE
429: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';

Line 427: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';

423:
424: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_cost_version_id;
425: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
426: IF l_fp_preference_code = 'COST_AND_REV_SAME' THEN
427: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
428: ELSE
429: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
430: END IF;
431:

Line 429: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';

425: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
426: IF l_fp_preference_code = 'COST_AND_REV_SAME' THEN
427: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
428: ELSE
429: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
430: END IF;
431:
432: x_cost_rv_number := l_rv_number;
433: x_cost_rl_id := l_resource_list_id;

Line 437: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;

433: x_cost_rl_id := l_resource_list_id;
434:
435: ELSE
436:
437: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
438: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
439: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := null;
440: l_grouping_type:=null;
441: x_cost_rv_number := -1;

Line 438: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';

434:
435: ELSE
436:
437: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
438: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
439: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := null;
440: l_grouping_type:=null;
441: x_cost_rv_number := -1;
442: x_cost_rl_id := -1;

Line 439: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := null;

435: ELSE
436:
437: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
438: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
439: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := null;
440: l_grouping_type:=null;
441: x_cost_rv_number := -1;
442: x_cost_rl_id := -1;
443: END IF;

Line 467: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_rev_version_id;

463: WHERE bv.budget_version_id = p_rev_version_id and
464: bv.resource_list_id = rl.resource_list_id;
465:
466:
467: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_rev_version_id;
468: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
469: IF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'COST') THEN
470:
471: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

Line 468: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;

464: bv.resource_list_id = rl.resource_list_id;
465:
466:
467: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_rev_version_id;
468: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
469: IF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'COST') THEN
470:
471: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
472:

Line 469: IF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'COST') THEN

465:
466:
467: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_rev_version_id;
468: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
469: IF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'COST') THEN
470:
471: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
472:
473: ELSE

Line 471: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

467: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_rev_version_id;
468: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
469: IF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'COST') THEN
470:
471: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
472:
473: ELSE
474: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
475: END IF;

Line 474: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';

470:
471: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
472:
473: ELSE
474: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
475: END IF;
476:
477: x_rev_rv_number := l_compl_rv_number;
478: x_rev_rl_id := l_compl_resource_list_id;

Line 482: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;

478: x_rev_rl_id := l_compl_resource_list_id;
479:
480: ELSE
481:
482: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
483: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
484: x_rev_rv_number := -1;
485: x_rev_rl_id := -1;
486: l_compl_grouping_type:=null;

Line 483: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';

479:
480: ELSE
481:
482: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
483: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
484: x_rev_rv_number := -1;
485: x_rev_rl_id := -1;
486: l_compl_grouping_type:=null;
487:

Line 518: IF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH') THEN

514: x_grouping_type := 'NONGROUPED';
515: END IF;
516: END IF;
517:
518: IF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH') THEN
519:
520: -- planning level code for cost version: P, T, L, or M
521: SELECT cost_fin_plan_level_code
522: INTO l_cost_planning_level

Line 539: ELSIF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'ANY') THEN

535: ELSE
536: x_planning_level := l_cost_planning_level;
537: END IF;
538:
539: ELSIF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'ANY') THEN
540:
541: SELECT all_fin_plan_level_code
542: INTO l_cost_planning_level
543: FROM pa_proj_fp_options

Line 548: ELSIF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'REVENUE') THEN

544: WHERE fin_plan_version_id = p_cost_version_id;
545:
546: x_planning_level := l_cost_planning_level;
547:
548: ELSIF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'REVENUE') THEN
549:
550: SELECT revenue_fin_plan_level_code
551: INTO l_rev_planning_level
552: FROM pa_proj_fp_options

Line 557: ELSIF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'COST') THEN

553: WHERE fin_plan_version_id = p_rev_version_id;
554:
555: x_planning_level := l_rev_planning_level;
556:
557: ELSIF (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'COST') THEN
558:
559: SELECT cost_fin_plan_level_code
560: INTO l_cost_planning_level
561: FROM pa_proj_fp_options

Line 568: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;

564: x_planning_level := l_cost_planning_level;
565:
566: END IF;
567:
568: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
569: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
570: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
571: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
572: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;

Line 569: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;

565:
566: END IF;
567:
568: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
569: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
570: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
571: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
572: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
573:

Line 570: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;

566: END IF;
567:
568: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
569: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
570: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
571: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
572: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
573:
574: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;

Line 571: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;

567:
568: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
569: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
570: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
571: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
572: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
573:
574: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
575: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;

Line 572: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;

568: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
569: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
570: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
571: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
572: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
573:
574: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
575: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
576:

Line 574: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;

570: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
571: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
572: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
573:
574: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
575: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
576:
577:
578: if (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH' and

Line 575: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;

571: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
572: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
573:
574: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
575: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
576:
577:
578: if (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH' and
579: l_uncategorized_flag = 'Y' and l_compl_uncategorized_flag = 'Y') or

Line 578: if (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH' and

574: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
575: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
576:
577:
578: if (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH' and
579: l_uncategorized_flag = 'Y' and l_compl_uncategorized_flag = 'Y') or
580: (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM <> 'BOTH' and
581: l_uncategorized_flag = 'Y') then
582: x_planned_resources_flag := 'N';

Line 580: (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM <> 'BOTH' and

576:
577:
578: if (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH' and
579: l_uncategorized_flag = 'Y' and l_compl_uncategorized_flag = 'Y') or
580: (pa_fp_view_plans_txn_pub.G_DISPLAY_FROM <> 'BOTH' and
581: l_uncategorized_flag = 'Y') then
582: x_planned_resources_flag := 'N';
583: else
584: x_planned_resources_flag := 'Y';

Line 593: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

589: -- x_grouping_type and x_planned_resources_flag
590: if x_display_from = 'ANY' then
591: pa_fin_plan_utils.Check_Locked_By_User
592: (p_user_id => p_user_id,
593: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
594: x_is_locked_by_userid => l_is_cost_locked_by_user,
595: x_locked_by_person_id => l_cost_locked_by_person_id,
596: x_return_status => l_return_status,
597: x_msg_count => l_msg_count,

Line 613: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

609: x_rev_locked_name := 'SELF';
610: end if; -- is_cost_locked_by_user
611:
612: pa_fp_view_plans_util.get_plan_version_res_level
613: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
614: p_entered_amts_only_flag => 'N',
615: x_resource_level => l_resource_level,
616: x_return_status => l_return_status,
617: x_msg_count => l_msg_count,

Line 649: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

645:
646: elsif x_display_from = 'COST' then
647: pa_fin_plan_utils.Check_Locked_By_User
648: (p_user_id => p_user_id,
649: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
650: x_is_locked_by_userid => l_is_cost_locked_by_user,
651: x_locked_by_person_id => l_cost_locked_by_person_id,
652: x_return_status => l_return_status,
653: x_msg_count => l_msg_count,

Line 666: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

662: x_cost_locked_name := 'SELF';
663: end if; -- is_cost_locked_by_user
664:
665: pa_fp_view_plans_util.get_plan_version_res_level
666: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
667: p_entered_amts_only_flag => 'Y',
668: x_resource_level => l_resource_level,
669: x_return_status => l_return_status,
670: x_msg_count => l_msg_count,

Line 702: p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,

698:
699: elsif x_display_from = 'REVENUE' then
700: pa_fin_plan_utils.Check_Locked_By_User
701: (p_user_id => p_user_id,
702: p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,
703: x_is_locked_by_userid => l_is_rev_locked_by_user,
704: x_locked_by_person_id => l_rev_locked_by_person_id,
705: x_return_status => l_return_status,
706: x_msg_count => l_msg_count,

Line 719: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,

715: x_rev_locked_name := 'SELF';
716: end if; -- is_rev_locked_by_user
717:
718: pa_fp_view_plans_util.get_plan_version_res_level
719: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,
720: p_entered_amts_only_flag => 'Y',
721: x_resource_level => l_resource_level,
722: x_return_status => l_return_status,
723: x_msg_count => l_msg_count,

Line 757: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

753:
754: -- FOR COST VERSION
755: pa_fin_plan_utils.Check_Locked_By_User
756: (p_user_id => p_user_id,
757: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
758: x_is_locked_by_userid => l_is_cost_locked_by_user,
759: x_locked_by_person_id => l_cost_locked_by_person_id,
760: x_return_status => l_return_status,
761: x_msg_count => l_msg_count,

Line 774: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

770: x_cost_locked_name := 'SELF';
771: end if; -- is_cost_locked_by_user
772:
773: pa_fp_view_plans_util.get_plan_version_res_level
774: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
775: p_entered_amts_only_flag => 'Y',
776: x_resource_level => l_cost_resource_level,
777: x_return_status => l_return_status,
778: x_msg_count => l_msg_count,

Line 796: p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,

792:
793: -- FOR REVENUE VERSION
794: pa_fin_plan_utils.Check_Locked_By_User
795: (p_user_id => p_user_id,
796: p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,
797: x_is_locked_by_userid => l_is_rev_locked_by_user,
798: x_locked_by_person_id => l_rev_locked_by_person_id,
799: x_return_status => l_return_status,
800: x_msg_count => l_msg_count,

Line 813: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,

809: x_rev_locked_name := 'SELF';
810: end if; -- is_cost_locked_by_user
811:
812: pa_fp_view_plans_util.get_plan_version_res_level
813: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,
814: p_entered_amts_only_flag => 'Y',
815: x_resource_level => l_revenue_resource_level,
816: x_return_status => l_return_status,
817: x_msg_count => l_msg_count,

Line 844: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '1000: exited procedure', 2);

840: end if;
841:
842: end if;
843:
844: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '1000: exited procedure', 2);
845: END nonhgrid_view_initialize;
846: /* ------------------------------------------------------------- */
847:
848: /* ---------------------- CHANGE HISTORY ----------------------- */

Line 925: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '100: entered procedure', 2);

921: l_msg_data VARCHAR2(2000);
922: l_msg_index_out NUMBER(10);
923:
924: BEGIN
925: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '100: entered procedure', 2);
926: x_msg_count := 0;
927: x_return_status := FND_API.G_RET_STS_SUCCESS;
928:
929: -- get AUTO BASELINED FLAG

Line 964: pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID := p_budget_version_id;

960: from pa_budget_versions bv,
961: pa_resource_lists_all_bg rl
962: where bv.budget_version_id = p_budget_version_id and
963: bv.resource_list_id = rl.resource_list_id;
964: pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID := p_budget_version_id;
965: -- >>>>> BUG FIX 2602849: need to check only AR flag <<<<<
966: -- >>>> BUG FIX 2650878: project or projfunc, depending on AR flag <<<<
967: if l_ar_flag = 'Y' then
968: -- APPROVED REVENUE: go with Project Functional Currency

Line 991: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJFUNC';

987: if l_agreement_currency_code <> 'ANY' then
988: x_project_currency := l_agreement_currency_code;
989: end if;
990: end if; -- ci_id is not null
991: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJFUNC';
992: else
993: -- NOT APPROVED REVENUE: go with Project Currency
994: x_ar_ac_flag := 'N';
995: -- get PROJECT CURRENCY

Line 1000: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJECT';

996: select project_currency_code
997: into x_project_currency
998: from pa_projects_all
999: where project_id = p_project_id;
1000: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJECT';
1001: end if; -- approved revenue flag
1002:
1003: select fin_plan_type_id,
1004: NVL(plan_in_multi_curr_flag, 'N'),

Line 1030: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;

1026: where project_id = p_project_id and
1027: fin_plan_type_id = l_fin_plan_type_id and
1028: fin_plan_option_level_code = 'PLAN_TYPE';
1029:
1030: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
1031: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;
1032: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := l_multi_curr_flag;
1033: -- retrieve report_labor_hrs, margin_derived codes from PLAN TYPE entry
1034: select report_labor_hrs_from_code,

Line 1031: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;

1027: fin_plan_type_id = l_fin_plan_type_id and
1028: fin_plan_option_level_code = 'PLAN_TYPE';
1029:
1030: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
1031: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;
1032: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := l_multi_curr_flag;
1033: -- retrieve report_labor_hrs, margin_derived codes from PLAN TYPE entry
1034: select report_labor_hrs_from_code,
1035: margin_derived_from_code

Line 1032: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := l_multi_curr_flag;

1028: fin_plan_option_level_code = 'PLAN_TYPE';
1029:
1030: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
1031: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;
1032: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := l_multi_curr_flag;
1033: -- retrieve report_labor_hrs, margin_derived codes from PLAN TYPE entry
1034: select report_labor_hrs_from_code,
1035: margin_derived_from_code
1036: into l_report_labor_hrs_from_code,

Line 1042: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;

1038: from pa_proj_fp_options
1039: where project_id = p_project_id and
1040: fin_plan_type_id = l_fin_plan_type_id and
1041: fin_plan_option_level_code = 'PLAN_TYPE';
1042: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
1043: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
1044: -- get PLAN TYPE NAME
1045:
1046: select name

Line 1043: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;

1039: where project_id = p_project_id and
1040: fin_plan_type_id = l_fin_plan_type_id and
1041: fin_plan_option_level_code = 'PLAN_TYPE';
1042: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
1043: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
1044: -- get PLAN TYPE NAME
1045:
1046: select name
1047: into x_plan_type_name

Line 1054: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '200: pref = COST_AND_REV_SAME', 1);

1050: language = USERENV('LANG');
1051:
1052:
1053: if l_fp_preference_code = 'COST_AND_REV_SAME' then
1054: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '200: pref = COST_AND_REV_SAME', 1);
1055: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1056: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1057: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1058: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

Line 1055: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;

1051:
1052:
1053: if l_fp_preference_code = 'COST_AND_REV_SAME' then
1054: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '200: pref = COST_AND_REV_SAME', 1);
1055: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1056: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1057: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1058: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1059: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';

Line 1056: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;

1052:
1053: if l_fp_preference_code = 'COST_AND_REV_SAME' then
1054: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '200: pref = COST_AND_REV_SAME', 1);
1055: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1056: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1057: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1058: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1059: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
1060:

Line 1057: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;

1053: if l_fp_preference_code = 'COST_AND_REV_SAME' then
1054: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '200: pref = COST_AND_REV_SAME', 1);
1055: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1056: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1057: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1058: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1059: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
1060:
1061: x_grouping_type := l_grouping_type;

Line 1058: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

1054: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '200: pref = COST_AND_REV_SAME', 1);
1055: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1056: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1057: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1058: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1059: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
1060:
1061: x_grouping_type := l_grouping_type;
1062: -- set planning level code for page: P, T, L, or M

Line 1059: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';

1055: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1056: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1057: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1058: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1059: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
1060:
1061: x_grouping_type := l_grouping_type;
1062: -- set planning level code for page: P, T, L, or M
1063: select all_fin_plan_level_code

Line 1072: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '300: pref = COST_ONLY', 1);

1068: x_cost_rl_id := l_resource_list_id;
1069: x_rev_rl_id := l_resource_list_id;
1070:
1071: elsif l_fp_preference_code = 'COST_ONLY' then
1072: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '300: pref = COST_ONLY', 1);
1073: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1074: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1075: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1076: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';

Line 1073: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;

1069: x_rev_rl_id := l_resource_list_id;
1070:
1071: elsif l_fp_preference_code = 'COST_ONLY' then
1072: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '300: pref = COST_ONLY', 1);
1073: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1074: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1075: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1076: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1077: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';

Line 1074: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;

1070:
1071: elsif l_fp_preference_code = 'COST_ONLY' then
1072: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '300: pref = COST_ONLY', 1);
1073: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1074: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1075: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1076: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1077: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
1078: x_grouping_type := l_grouping_type;

Line 1075: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;

1071: elsif l_fp_preference_code = 'COST_ONLY' then
1072: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '300: pref = COST_ONLY', 1);
1073: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1074: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1075: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1076: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1077: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
1078: x_grouping_type := l_grouping_type;
1079: -- set planning level code for page: P, T, L, or M

Line 1076: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';

1072: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '300: pref = COST_ONLY', 1);
1073: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1074: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1075: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1076: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1077: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
1078: x_grouping_type := l_grouping_type;
1079: -- set planning level code for page: P, T, L, or M
1080: select cost_fin_plan_level_code

Line 1077: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';

1073: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1074: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1075: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1076: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1077: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
1078: x_grouping_type := l_grouping_type;
1079: -- set planning level code for page: P, T, L, or M
1080: select cost_fin_plan_level_code
1081: into l_cost_planning_level

Line 1089: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '400: pref = REVENUE_ONLY', 1);

1085: x_cost_rl_id := l_resource_list_id;
1086: x_rev_rl_id := -1;
1087:
1088: elsif l_fp_preference_code = 'REVENUE_ONLY' then
1089: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '400: pref = REVENUE_ONLY', 1);
1090: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1091: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1092: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1093: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

Line 1090: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;

1086: x_rev_rl_id := -1;
1087:
1088: elsif l_fp_preference_code = 'REVENUE_ONLY' then
1089: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '400: pref = REVENUE_ONLY', 1);
1090: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1091: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1092: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1093: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1094: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';

Line 1091: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;

1087:
1088: elsif l_fp_preference_code = 'REVENUE_ONLY' then
1089: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '400: pref = REVENUE_ONLY', 1);
1090: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1091: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1092: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1093: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1094: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
1095: x_grouping_type := l_grouping_type;

Line 1092: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';

1088: elsif l_fp_preference_code = 'REVENUE_ONLY' then
1089: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '400: pref = REVENUE_ONLY', 1);
1090: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1091: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1092: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1093: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1094: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
1095: x_grouping_type := l_grouping_type;
1096: -- set planning level code for page: P, T, L, or M

Line 1093: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

1089: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '400: pref = REVENUE_ONLY', 1);
1090: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1091: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1092: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1093: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1094: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
1095: x_grouping_type := l_grouping_type;
1096: -- set planning level code for page: P, T, L, or M
1097: select revenue_fin_plan_level_code

Line 1094: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';

1090: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1091: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1092: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1093: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1094: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
1095: x_grouping_type := l_grouping_type;
1096: -- set planning level code for page: P, T, L, or M
1097: select revenue_fin_plan_level_code
1098: into l_rev_planning_level

Line 1106: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '500: pref = COST_AND_REV_SEP', 1);

1102: x_cost_rl_id := -1;
1103: x_rev_rl_id := l_resource_list_id;
1104:
1105: elsif l_fp_preference_code = 'COST_AND_REV_SEP' then
1106: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '500: pref = COST_AND_REV_SEP', 1);
1107: -- this is a cost/revenue version that's part of a cost-revenue pairing
1108: -- we need to find out which one it is
1109: select version_type
1110: into l_version_type

Line 1115: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;

1111: from pa_budget_versions
1112: where budget_version_id = p_budget_version_id;
1113: if l_version_type = 'COST' then
1114: -- COST VERSION: treat as if COST_ONLY
1115: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1116: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1117: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1118: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1119: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';

Line 1116: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;

1112: where budget_version_id = p_budget_version_id;
1113: if l_version_type = 'COST' then
1114: -- COST VERSION: treat as if COST_ONLY
1115: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1116: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1117: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1118: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1119: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
1120: x_grouping_type := l_grouping_type;

Line 1117: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;

1113: if l_version_type = 'COST' then
1114: -- COST VERSION: treat as if COST_ONLY
1115: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1116: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1117: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1118: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1119: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
1120: x_grouping_type := l_grouping_type;
1121: -- set planning level code for page: P, T, L, or M

Line 1118: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';

1114: -- COST VERSION: treat as if COST_ONLY
1115: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1116: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1117: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1118: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1119: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
1120: x_grouping_type := l_grouping_type;
1121: -- set planning level code for page: P, T, L, or M
1122: select cost_fin_plan_level_code

Line 1119: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';

1115: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;
1116: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
1117: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
1118: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := '';
1119: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
1120: x_grouping_type := l_grouping_type;
1121: -- set planning level code for page: P, T, L, or M
1122: select cost_fin_plan_level_code
1123: into l_cost_planning_level

Line 1131: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;

1127: x_cost_rl_id := l_resource_list_id;
1128: x_rev_rl_id := -1;
1129: else
1130: -- REVENUE VERSION: treat as if REVENUE_ONLY
1131: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1132: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1133: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1134: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1135: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';

Line 1132: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;

1128: x_rev_rl_id := -1;
1129: else
1130: -- REVENUE VERSION: treat as if REVENUE_ONLY
1131: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1132: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1133: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1134: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1135: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
1136: x_grouping_type := l_grouping_type;

Line 1133: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';

1129: else
1130: -- REVENUE VERSION: treat as if REVENUE_ONLY
1131: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1132: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1133: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1134: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1135: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
1136: x_grouping_type := l_grouping_type;
1137: -- set planning level code for page: P, T, L, or M

Line 1134: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

1130: -- REVENUE VERSION: treat as if REVENUE_ONLY
1131: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1132: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1133: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1134: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1135: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
1136: x_grouping_type := l_grouping_type;
1137: -- set planning level code for page: P, T, L, or M
1138: select revenue_fin_plan_level_code

Line 1135: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';

1131: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
1132: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := p_budget_version_id;
1133: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := '';
1134: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
1135: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
1136: x_grouping_type := l_grouping_type;
1137: -- set planning level code for page: P, T, L, or M
1138: select revenue_fin_plan_level_code
1139: into l_rev_planning_level

Line 1148: --pa_debug.write('pa_fp_view_plans_txn_pub.hgrid_edit_initialize', '600: invalid value for FIN_PLAN_PREFERENCE_CODE', 1);

1144: x_rev_rl_id := l_resource_list_id;
1145: end if; -- l_version_type
1146:
1147: else
1148: --pa_debug.write('pa_fp_view_plans_txn_pub.hgrid_edit_initialize', '600: invalid value for FIN_PLAN_PREFERENCE_CODE', 1);
1149: return;
1150: end if; -- l_fp_preference_code
1151:
1152: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;

Line 1152: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;

1148: --pa_debug.write('pa_fp_view_plans_txn_pub.hgrid_edit_initialize', '600: invalid value for FIN_PLAN_PREFERENCE_CODE', 1);
1149: return;
1150: end if; -- l_fp_preference_code
1151:
1152: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
1153: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
1154: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
1155: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
1156: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;

Line 1153: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;

1149: return;
1150: end if; -- l_fp_preference_code
1151:
1152: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
1153: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
1154: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
1155: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
1156: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
1157: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;

Line 1154: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;

1150: end if; -- l_fp_preference_code
1151:
1152: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
1153: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
1154: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
1155: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
1156: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
1157: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
1158: if (l_uncategorized_flag = 'Y') then

Line 1155: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;

1151:
1152: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
1153: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
1154: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
1155: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
1156: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
1157: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
1158: if (l_uncategorized_flag = 'Y') then
1159: x_planned_resources_flag := 'N';

Line 1156: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;

1152: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
1153: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
1154: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
1155: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
1156: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
1157: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
1158: if (l_uncategorized_flag = 'Y') then
1159: x_planned_resources_flag := 'N';
1160: else

Line 1157: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;

1153: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
1154: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
1155: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
1156: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
1157: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
1158: if (l_uncategorized_flag = 'Y') then
1159: x_planned_resources_flag := 'N';
1160: else
1161: x_planned_resources_flag := 'Y';

Line 1205: pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '1000: exited procedure', 2);

1201: return;
1202: end if;
1203:
1204: IF P_PA_DEBUG_MODE = 'Y' THEN
1205: pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_edit_initialize', '1000: exited procedure', 2);
1206: END IF;
1207: END nonhgrid_edit_initialize;
1208: /* ------------------------------------------------------------- */
1209:

Line 1248: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type, -- used in wrapper view to decide how to handle

1244: ra_cost.task_id,
1245: ra_cost.resource_list_member_id,
1246: bl_cost.resource_assignment_id,
1247: -1 as compl_resource_assignment_id,
1248: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type, -- used in wrapper view to decide how to handle
1249: -- parent_member_id = null cases
1250: bl_cost.txn_currency_code,
1251: decode((NVL(ra_cost.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) AS UNIT_OF_MEASURE, -- ra_cost.unit_of_measure, bug 3463685
1252: SUM(nvl(bl_cost.quantity,0)) as quantity,

Line 1277: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1273: from pa_resource_list_members
1274: where resource_list_member_id = p_filter_resource_id))) and
1275: /*
1276: (p_filter_resource_id = -1 or
1277: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1278: rlm.parent_member_id = p_filter_resource_id) or
1279: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1280: rlm.parent_member_id is null and
1281: rlm.resource_id = p_filter_resource_id)) and

Line 1279: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1275: /*
1276: (p_filter_resource_id = -1 or
1277: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1278: rlm.parent_member_id = p_filter_resource_id) or
1279: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1280: rlm.parent_member_id is null and
1281: rlm.resource_id = p_filter_resource_id)) and
1282: */
1283: (p_filter_rlm_id = -1 or

Line 1284: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1280: rlm.parent_member_id is null and
1281: rlm.resource_id = p_filter_resource_id)) and
1282: */
1283: (p_filter_rlm_id = -1 or
1284: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1285: rlm.parent_member_id is null and
1286: rlm.resource_id = p_filter_rlm_id and
1287: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1288: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

Line 1287: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1283: (p_filter_rlm_id = -1 or
1284: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1285: rlm.parent_member_id is null and
1286: rlm.resource_id = p_filter_rlm_id and
1287: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1288: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1289: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1290: rlm.parent_member_id is not null and
1291: rlm.resource_id = p_filter_rlm_id and

Line 1288: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

1284: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1285: rlm.parent_member_id is null and
1286: rlm.resource_id = p_filter_rlm_id and
1287: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1288: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1289: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1290: rlm.parent_member_id is not null and
1291: rlm.resource_id = p_filter_rlm_id and
1292: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1289: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1285: rlm.parent_member_id is null and
1286: rlm.resource_id = p_filter_rlm_id and
1287: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1288: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1289: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1290: rlm.parent_member_id is not null and
1291: rlm.resource_id = p_filter_rlm_id and
1292: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1293: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

Line 1292: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1288: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1289: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1290: rlm.parent_member_id is not null and
1291: rlm.resource_id = p_filter_rlm_id and
1292: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1293: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1294: (p_filter_txncurrency = 'ALL' or bl_cost.txn_currency_code = p_filter_txncurrency)
1295: --(bl_cost.txn_raw_cost is not null or bl_cost.txn_burdened_cost is not null)
1296: group by ra_cost.project_id,

Line 1293: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

1289: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1290: rlm.parent_member_id is not null and
1291: rlm.resource_id = p_filter_rlm_id and
1292: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1293: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1294: (p_filter_txncurrency = 'ALL' or bl_cost.txn_currency_code = p_filter_txncurrency)
1295: --(bl_cost.txn_raw_cost is not null or bl_cost.txn_burdened_cost is not null)
1296: group by ra_cost.project_id,
1297: ra_cost.task_id,

Line 1308: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,

1304: ra.task_id,
1305: ra.resource_list_member_id,
1306: ra.resource_assignment_id,
1307: -1 as compl_resource_assignment_id,
1308: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,
1309: ftc.txn_currency_code as txn_currency_code,
1310: DECODE((NVL(ra.track_as_labor_flag,'N')), 'Y' , 'HOURS' , pr.unit_of_measure) as UNIT_OF_MEASURE, -- ra.unit_of_measure, bug 3463685
1311: ra.total_plan_quantity as quantity,
1312: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

Line 1312: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1308: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,
1309: ftc.txn_currency_code as txn_currency_code,
1310: DECODE((NVL(ra.track_as_labor_flag,'N')), 'Y' , 'HOURS' , pr.unit_of_measure) as UNIT_OF_MEASURE, -- ra.unit_of_measure, bug 3463685
1311: ra.total_plan_quantity as quantity,
1312: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1313: 'PROJECT', ra.total_project_burdened_cost,
1314: ra.total_plan_burdened_cost) as burdened_cost,
1315: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1316: 'PROJECT', ra.total_project_raw_cost,

Line 1315: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1311: ra.total_plan_quantity as quantity,
1312: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1313: 'PROJECT', ra.total_project_burdened_cost,
1314: ra.total_plan_burdened_cost) as burdened_cost,
1315: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1316: 'PROJECT', ra.total_project_raw_cost,
1317: ra.total_plan_raw_cost) as raw_cost,
1318: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1319: 'PROJECT', ra.total_project_revenue,

Line 1318: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1314: ra.total_plan_burdened_cost) as burdened_cost,
1315: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1316: 'PROJECT', ra.total_project_raw_cost,
1317: ra.total_plan_raw_cost) as raw_cost,
1318: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1319: 'PROJECT', ra.total_project_revenue,
1320: ra.total_plan_revenue) as revenue, -- null
1321: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1322: 'PROJECT', ra.total_project_revenue - ra.total_project_raw_cost,

Line 1321: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1317: ra.total_plan_raw_cost) as raw_cost,
1318: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1319: 'PROJECT', ra.total_project_revenue,
1320: ra.total_plan_revenue) as revenue, -- null
1321: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1322: 'PROJECT', ra.total_project_revenue - ra.total_project_raw_cost,
1323: ra.total_plan_revenue - ra.total_plan_raw_cost) as margin, -- null
1324: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1325: 'PROJECT',

Line 1324: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1320: ra.total_plan_revenue) as revenue, -- null
1321: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1322: 'PROJECT', ra.total_project_revenue - ra.total_project_raw_cost,
1323: ra.total_plan_revenue - ra.total_plan_raw_cost) as margin, -- null
1324: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1325: 'PROJECT',
1326: DECODE(ra.total_project_revenue,
1327: 0, 0,
1328: (ra.total_project_revenue - ra.total_project_raw_cost)/

Line 1353: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1349: from pa_resource_list_members
1350: where resource_list_member_id = p_filter_resource_id))) and
1351: /*
1352: (p_filter_resource_id = -1 or
1353: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1354: rlm.parent_member_id = p_filter_resource_id) or
1355: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1356: rlm.parent_member_id is null and
1357: rlm.resource_id = p_filter_resource_id)) and

Line 1355: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1351: /*
1352: (p_filter_resource_id = -1 or
1353: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1354: rlm.parent_member_id = p_filter_resource_id) or
1355: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1356: rlm.parent_member_id is null and
1357: rlm.resource_id = p_filter_resource_id)) and
1358: */
1359: (p_filter_rlm_id = -1 or

Line 1360: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1356: rlm.parent_member_id is null and
1357: rlm.resource_id = p_filter_resource_id)) and
1358: */
1359: (p_filter_rlm_id = -1 or
1360: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1361: rlm.parent_member_id is null and
1362: rlm.resource_id = p_filter_rlm_id and
1363: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1364: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

Line 1363: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1359: (p_filter_rlm_id = -1 or
1360: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1361: rlm.parent_member_id is null and
1362: rlm.resource_id = p_filter_rlm_id and
1363: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1364: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1365: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1366: rlm.parent_member_id is not null and
1367: rlm.resource_id = p_filter_rlm_id and

Line 1364: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

1360: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1361: rlm.parent_member_id is null and
1362: rlm.resource_id = p_filter_rlm_id and
1363: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1364: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1365: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1366: rlm.parent_member_id is not null and
1367: rlm.resource_id = p_filter_rlm_id and
1368: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1365: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1361: rlm.parent_member_id is null and
1362: rlm.resource_id = p_filter_rlm_id and
1363: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1364: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1365: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1366: rlm.parent_member_id is not null and
1367: rlm.resource_id = p_filter_rlm_id and
1368: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1369: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

Line 1368: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1364: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1365: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1366: rlm.parent_member_id is not null and
1367: rlm.resource_id = p_filter_rlm_id and
1368: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1369: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1370: ftc.default_cost_curr_flag = 'Y' and
1371: (p_filter_txncurrency = 'ALL' or
1372: ftc.txn_currency_code = p_filter_txncurrency) and -- bug fix 2697775

Line 1369: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

1365: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1366: rlm.parent_member_id is not null and
1367: rlm.resource_id = p_filter_rlm_id and
1368: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1369: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1370: ftc.default_cost_curr_flag = 'Y' and
1371: (p_filter_txncurrency = 'ALL' or
1372: ftc.txn_currency_code = p_filter_txncurrency) and -- bug fix 2697775
1373: not exists(select bl.resource_assignment_id from pa_budget_lines bl

Line 1382: pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping as grouping_type,

1378: select ra_revenue.project_id,
1379: ra_revenue.task_id,
1380: ra_revenue.resource_list_member_id,
1381: bl_revenue.resource_assignment_id,
1382: pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping as grouping_type,
1383: bl_revenue.txn_currency_code,
1384: DECODE((NVL(ra_revenue.track_as_labor_flag,'N')), 'Y' , 'HOURS' , pr.unit_of_measure) as UNIT_OF_MEASURE, -- ra_revenue.unit_of_measure, bug 3463685
1385: SUM(nvl(bl_revenue.quantity,0)) as quantity,
1386: -- 0 as burdened_cost,

Line 1410: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and

1406: from pa_resource_list_members
1407: where resource_list_member_id = p_filter_resource_id))) and
1408: /*
1409: (p_filter_resource_id = -1 or
1410: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and
1411: rlm.parent_member_id = p_filter_resource_id) or
1412: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and
1413: rlm.parent_member_id is null and
1414: rlm.resource_id = p_filter_resource_id)) and

Line 1412: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and

1408: /*
1409: (p_filter_resource_id = -1 or
1410: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and
1411: rlm.parent_member_id = p_filter_resource_id) or
1412: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and
1413: rlm.parent_member_id is null and
1414: rlm.resource_id = p_filter_resource_id)) and
1415: */
1416: (p_filter_rlm_id = -1 or

Line 1417: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and /* Bug 2843566 - changed cost function to rev function */

1413: rlm.parent_member_id is null and
1414: rlm.resource_id = p_filter_resource_id)) and
1415: */
1416: (p_filter_rlm_id = -1 or
1417: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and /* Bug 2843566 - changed cost function to rev function */
1418: rlm.parent_member_id is null and
1419: rlm.resource_id = p_filter_rlm_id and
1420: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1421: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

Line 1420: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1416: (p_filter_rlm_id = -1 or
1417: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and /* Bug 2843566 - changed cost function to rev function */
1418: rlm.parent_member_id is null and
1419: rlm.resource_id = p_filter_rlm_id and
1420: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1421: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1422: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev
1423: function */
1424: rlm.parent_member_id is not null and

Line 1421: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

1417: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and /* Bug 2843566 - changed cost function to rev function */
1418: rlm.parent_member_id is null and
1419: rlm.resource_id = p_filter_rlm_id and
1420: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1421: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1422: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev
1423: function */
1424: rlm.parent_member_id is not null and
1425: rlm.resource_id = p_filter_rlm_id and

Line 1422: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev

1418: rlm.parent_member_id is null and
1419: rlm.resource_id = p_filter_rlm_id and
1420: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1421: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1422: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev
1423: function */
1424: rlm.parent_member_id is not null and
1425: rlm.resource_id = p_filter_rlm_id and
1426: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1426: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1422: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev
1423: function */
1424: rlm.parent_member_id is not null and
1425: rlm.resource_id = p_filter_rlm_id and
1426: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1427: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1428: (p_filter_txncurrency = 'ALL' or bl_revenue.txn_currency_code = p_filter_txncurrency)
1429: --bl_revenue.txn_revenue is not null
1430: group by ra_revenue.project_id,

Line 1427: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

1423: function */
1424: rlm.parent_member_id is not null and
1425: rlm.resource_id = p_filter_rlm_id and
1426: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1427: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1428: (p_filter_txncurrency = 'ALL' or bl_revenue.txn_currency_code = p_filter_txncurrency)
1429: --bl_revenue.txn_revenue is not null
1430: group by ra_revenue.project_id,
1431: ra_revenue.task_id,

Line 1441: pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping as grouping_type,

1437: select ra.project_id,
1438: ra.task_id,
1439: ra.resource_list_member_id,
1440: ra.resource_assignment_id,
1441: pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping as grouping_type,
1442: ftc.txn_currency_code as txn_currency_code,
1443: DECODE((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) as unit_of_measure, -- ra.unit_of_measure, bug 3463685
1444: ra.total_plan_quantity as quantity,
1445: -- 0 as burdened_cost,

Line 1447: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1443: DECODE((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) as unit_of_measure, -- ra.unit_of_measure, bug 3463685
1444: ra.total_plan_quantity as quantity,
1445: -- 0 as burdened_cost,
1446: -- 0 as raw_cost,
1447: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1448: 'PROJECT', ra.total_project_revenue,
1449: ra.total_plan_revenue) as revenue -- null
1450: -- 0 as margin,
1451: -- 0 as margin_percent

Line 1470: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1466: from pa_resource_list_members
1467: where resource_list_member_id = p_filter_resource_id))) and
1468: /*
1469: (p_filter_resource_id = -1 or
1470: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1471: rlm.parent_member_id = p_filter_resource_id) or
1472: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1473: rlm.parent_member_id is null and
1474: rlm.resource_id = p_filter_resource_id)) and

Line 1472: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1468: /*
1469: (p_filter_resource_id = -1 or
1470: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1471: rlm.parent_member_id = p_filter_resource_id) or
1472: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1473: rlm.parent_member_id is null and
1474: rlm.resource_id = p_filter_resource_id)) and
1475: */
1476: (p_filter_rlm_id = -1 or

Line 1477: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and /* Bug 2843566 - changed cost function to rev

1473: rlm.parent_member_id is null and
1474: rlm.resource_id = p_filter_resource_id)) and
1475: */
1476: (p_filter_rlm_id = -1 or
1477: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and /* Bug 2843566 - changed cost function to rev
1478: function */
1479: rlm.parent_member_id is null and
1480: rlm.resource_id = p_filter_rlm_id and
1481: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1481: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1477: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and /* Bug 2843566 - changed cost function to rev
1478: function */
1479: rlm.parent_member_id is null and
1480: rlm.resource_id = p_filter_rlm_id and
1481: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1482: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1483: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev
1484: function */
1485: rlm.parent_member_id is not null and

Line 1482: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

1478: function */
1479: rlm.parent_member_id is null and
1480: rlm.resource_id = p_filter_rlm_id and
1481: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1482: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1483: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev
1484: function */
1485: rlm.parent_member_id is not null and
1486: rlm.resource_id = p_filter_rlm_id and

Line 1483: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev

1479: rlm.parent_member_id is null and
1480: rlm.resource_id = p_filter_rlm_id and
1481: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1482: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1483: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev
1484: function */
1485: rlm.parent_member_id is not null and
1486: rlm.resource_id = p_filter_rlm_id and
1487: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1487: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1483: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and /* Bug 2843566 - changed cost function to rev
1484: function */
1485: rlm.parent_member_id is not null and
1486: rlm.resource_id = p_filter_rlm_id and
1487: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1488: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1489: ra.budget_version_id = ftc.fin_plan_version_id and
1490: ftc.default_rev_curr_flag = 'Y' and
1491: (p_filter_txncurrency = 'ALL' or

Line 1488: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

1484: function */
1485: rlm.parent_member_id is not null and
1486: rlm.resource_id = p_filter_rlm_id and
1487: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1488: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1489: ra.budget_version_id = ftc.fin_plan_version_id and
1490: ftc.default_rev_curr_flag = 'Y' and
1491: (p_filter_txncurrency = 'ALL' or
1492: ftc.txn_currency_code = p_filter_txncurrency) and -- bug fix 2697775

Line 1502: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,

1498: select ra.project_id,
1499: ra.task_id,
1500: ra.resource_list_member_id,
1501: bl.resource_assignment_id,
1502: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,
1503: bl.txn_currency_code,
1504: DECODE((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) as unit_of_measure, -- ra.unit_of_measure, bug 3463685
1505: SUM(nvl(bl.quantity,0)) as quantity,
1506: SUM(nvl(bl.txn_burdened_cost,0)) as burdened_cost,

Line 1509: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,

1505: SUM(nvl(bl.quantity,0)) as quantity,
1506: SUM(nvl(bl.txn_burdened_cost,0)) as burdened_cost,
1507: SUM(nvl(bl.txn_raw_cost,0)) as raw_cost,
1508: SUM(nvl(bl.txn_revenue,0)) as revenue,
1509: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1510: 'R', SUM(nvl(bl.txn_revenue,0)) - SUM(nvl(bl.txn_raw_cost,0)),
1511: SUM(nvl(bl.txn_revenue,0)) - SUM(nvl(bl.txn_burdened_cost,0))) as margin,
1512: DECODE(SUM(nvl(bl.txn_revenue,0)),
1513: 0, 0,

Line 1515: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,

1511: SUM(nvl(bl.txn_revenue,0)) - SUM(nvl(bl.txn_burdened_cost,0))) as margin,
1512: DECODE(SUM(nvl(bl.txn_revenue,0)),
1513: 0, 0,
1514: null, 0,
1515: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1516: 'R', (SUM(nvl(bl.txn_revenue,0)) - SUM(nvl(bl.txn_raw_cost,0)))/
1517: SUM(nvl(bl.txn_revenue,0)),
1518: (SUM(nvl(bl.txn_revenue,0)) - SUM(nvl(bl.txn_burdened_cost,0)))/
1519: SUM(nvl(bl.txn_revenue,0)))) as margin_percent

Line 1539: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1535: from pa_resource_list_members
1536: where resource_list_member_id = p_filter_resource_id))) and
1537: /*
1538: (p_filter_resource_id = -1 or
1539: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1540: rlm.parent_member_id = p_filter_resource_id) or
1541: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1542: rlm.parent_member_id is null and
1543: rlm.resource_id = p_filter_resource_id)) and

Line 1541: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1537: /*
1538: (p_filter_resource_id = -1 or
1539: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1540: rlm.parent_member_id = p_filter_resource_id) or
1541: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1542: rlm.parent_member_id is null and
1543: rlm.resource_id = p_filter_resource_id)) and
1544: */
1545: (p_filter_rlm_id = -1 or

Line 1546: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1542: rlm.parent_member_id is null and
1543: rlm.resource_id = p_filter_resource_id)) and
1544: */
1545: (p_filter_rlm_id = -1 or
1546: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1547: rlm.parent_member_id is null and
1548: rlm.resource_id = p_filter_rlm_id and
1549: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1550: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

Line 1549: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1545: (p_filter_rlm_id = -1 or
1546: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1547: rlm.parent_member_id is null and
1548: rlm.resource_id = p_filter_rlm_id and
1549: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1550: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1551: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1552: rlm.parent_member_id is not null and
1553: rlm.resource_id = p_filter_rlm_id and

Line 1550: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

1546: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1547: rlm.parent_member_id is null and
1548: rlm.resource_id = p_filter_rlm_id and
1549: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1550: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1551: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1552: rlm.parent_member_id is not null and
1553: rlm.resource_id = p_filter_rlm_id and
1554: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1551: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1547: rlm.parent_member_id is null and
1548: rlm.resource_id = p_filter_rlm_id and
1549: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1550: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1551: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1552: rlm.parent_member_id is not null and
1553: rlm.resource_id = p_filter_rlm_id and
1554: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1555: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

Line 1554: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1550: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1551: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1552: rlm.parent_member_id is not null and
1553: rlm.resource_id = p_filter_rlm_id and
1554: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1555: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1556: (p_filter_txncurrency = 'ALL' or bl.txn_currency_code = p_filter_txncurrency)
1557: group by ra.project_id,
1558: ra.task_id,

Line 1555: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

1551: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1552: rlm.parent_member_id is not null and
1553: rlm.resource_id = p_filter_rlm_id and
1554: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1555: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1556: (p_filter_txncurrency = 'ALL' or bl.txn_currency_code = p_filter_txncurrency)
1557: group by ra.project_id,
1558: ra.task_id,
1559: ra.resource_list_member_id,

Line 1568: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,

1564: select ra.project_id,
1565: ra.task_id,
1566: ra.resource_list_member_id,
1567: ra.resource_assignment_id,
1568: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,
1569: ftc.txn_currency_code as txn_currency_code,
1570: DECODE((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) AS unit_of_measure, -- ra.unit_of_measure, bug 3463685
1571: ra.total_plan_quantity as quantity,
1572: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

Line 1572: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1568: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,
1569: ftc.txn_currency_code as txn_currency_code,
1570: DECODE((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) AS unit_of_measure, -- ra.unit_of_measure, bug 3463685
1571: ra.total_plan_quantity as quantity,
1572: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1573: 'PROJECT', ra.total_project_burdened_cost,
1574: ra.total_plan_burdened_cost) as burdened_cost, -- null
1575: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1576: 'PROJECT', ra.total_project_raw_cost,

Line 1575: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1571: ra.total_plan_quantity as quantity,
1572: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1573: 'PROJECT', ra.total_project_burdened_cost,
1574: ra.total_plan_burdened_cost) as burdened_cost, -- null
1575: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1576: 'PROJECT', ra.total_project_raw_cost,
1577: ra.total_plan_raw_cost) as raw_cost, -- null
1578: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1579: 'PROJECT', ra.total_project_revenue,

Line 1578: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1574: ra.total_plan_burdened_cost) as burdened_cost, -- null
1575: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1576: 'PROJECT', ra.total_project_raw_cost,
1577: ra.total_plan_raw_cost) as raw_cost, -- null
1578: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1579: 'PROJECT', ra.total_project_revenue,
1580: ra.total_plan_revenue) as revenue, -- null
1581: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1582: 'PROJECT', ra.total_project_revenue - ra.total_project_raw_cost,

Line 1581: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1577: ra.total_plan_raw_cost) as raw_cost, -- null
1578: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1579: 'PROJECT', ra.total_project_revenue,
1580: ra.total_plan_revenue) as revenue, -- null
1581: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1582: 'PROJECT', ra.total_project_revenue - ra.total_project_raw_cost,
1583: ra.total_plan_revenue - total_plan_raw_cost) as margin, -- null
1584: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1585: 'PROJECT',

Line 1584: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1580: ra.total_plan_revenue) as revenue, -- null
1581: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1582: 'PROJECT', ra.total_project_revenue - ra.total_project_raw_cost,
1583: ra.total_plan_revenue - total_plan_raw_cost) as margin, -- null
1584: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1585: 'PROJECT',
1586: DECODE(ra.total_project_revenue,
1587: 0, 0,
1588: (ra.total_project_revenue - ra.total_project_raw_cost)/

Line 1612: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1608: from pa_resource_list_members
1609: where resource_list_member_id = p_filter_resource_id))) and
1610: /*
1611: (p_filter_resource_id = -1 or
1612: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1613: rlm.parent_member_id = p_filter_resource_id) or
1614: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1615: rlm.parent_member_id is null and
1616: rlm.resource_id = p_filter_resource_id)) and

Line 1614: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1610: /*
1611: (p_filter_resource_id = -1 or
1612: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1613: rlm.parent_member_id = p_filter_resource_id) or
1614: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1615: rlm.parent_member_id is null and
1616: rlm.resource_id = p_filter_resource_id)) and
1617: */
1618: (p_filter_rlm_id = -1 or

Line 1619: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1615: rlm.parent_member_id is null and
1616: rlm.resource_id = p_filter_resource_id)) and
1617: */
1618: (p_filter_rlm_id = -1 or
1619: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1620: rlm.parent_member_id is null and
1621: rlm.resource_id = p_filter_rlm_id and
1622: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1623: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

Line 1622: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1618: (p_filter_rlm_id = -1 or
1619: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1620: rlm.parent_member_id is null and
1621: rlm.resource_id = p_filter_rlm_id and
1622: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1623: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1624: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1625: rlm.parent_member_id is not null and
1626: rlm.resource_id = p_filter_rlm_id and

Line 1623: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

1619: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1620: rlm.parent_member_id is null and
1621: rlm.resource_id = p_filter_rlm_id and
1622: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1623: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1624: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1625: rlm.parent_member_id is not null and
1626: rlm.resource_id = p_filter_rlm_id and
1627: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1624: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1620: rlm.parent_member_id is null and
1621: rlm.resource_id = p_filter_rlm_id and
1622: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1623: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1624: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1625: rlm.parent_member_id is not null and
1626: rlm.resource_id = p_filter_rlm_id and
1627: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1628: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

Line 1627: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1623: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1624: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1625: rlm.parent_member_id is not null and
1626: rlm.resource_id = p_filter_rlm_id and
1627: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1628: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1629: ra.budget_version_id = ftc.fin_plan_version_id and
1630: ftc.default_all_curr_flag = 'Y' and
1631: (p_filter_txncurrency = 'ALL' or

Line 1628: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

1624: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1625: rlm.parent_member_id is not null and
1626: rlm.resource_id = p_filter_rlm_id and
1627: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1628: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1629: ra.budget_version_id = ftc.fin_plan_version_id and
1630: ftc.default_all_curr_flag = 'Y' and
1631: (p_filter_txncurrency = 'ALL' or
1632: ftc.txn_currency_code = p_filter_txncurrency) and -- bug fix 2697775

Line 1644: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,

1640: ra.task_id,
1641: ra.resource_list_member_id,
1642: ra.resource_assignment_id,
1643: -1 as compl_resource_assignment_id,
1644: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,
1645: p_project_currency as txn_currency_code,
1646: DECODE((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) AS unit_of_measure, -- ra.unit_of_measure, bug 3463685
1647: ra.total_plan_quantity as quantity,
1648: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

Line 1648: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1644: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,
1645: p_project_currency as txn_currency_code,
1646: DECODE((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) AS unit_of_measure, -- ra.unit_of_measure, bug 3463685
1647: ra.total_plan_quantity as quantity,
1648: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1649: 'PROJECT', ra.total_project_burdened_cost,
1650: ra.total_plan_burdened_cost) as burdened_cost,
1651: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1652: 'PROJECT', ra.total_project_raw_cost,

Line 1651: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1647: ra.total_plan_quantity as quantity,
1648: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1649: 'PROJECT', ra.total_project_burdened_cost,
1650: ra.total_plan_burdened_cost) as burdened_cost,
1651: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1652: 'PROJECT', ra.total_project_raw_cost,
1653: ra.total_plan_raw_cost) as raw_cost,
1654: 0 as revenue,
1655: 0 as margin,

Line 1674: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1670: from pa_resource_list_members
1671: where resource_list_member_id = p_filter_resource_id))) and
1672: /*
1673: (p_filter_resource_id = -1 or
1674: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1675: rlm.parent_member_id = p_filter_resource_id) or
1676: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1677: rlm.parent_member_id is null and
1678: rlm.resource_id = p_filter_resource_id)) and

Line 1676: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1672: /*
1673: (p_filter_resource_id = -1 or
1674: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1675: rlm.parent_member_id = p_filter_resource_id) or
1676: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1677: rlm.parent_member_id is null and
1678: rlm.resource_id = p_filter_resource_id)) and
1679: */
1680: (p_filter_rlm_id = -1 or

Line 1681: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1677: rlm.parent_member_id is null and
1678: rlm.resource_id = p_filter_resource_id)) and
1679: */
1680: (p_filter_rlm_id = -1 or
1681: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1682: rlm.parent_member_id is null and
1683: rlm.resource_id = p_filter_rlm_id and
1684: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1685: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

Line 1684: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1680: (p_filter_rlm_id = -1 or
1681: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1682: rlm.parent_member_id is null and
1683: rlm.resource_id = p_filter_rlm_id and
1684: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1685: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1686: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1687: rlm.parent_member_id is not null and
1688: rlm.resource_id = p_filter_rlm_id and

Line 1685: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

1681: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1682: rlm.parent_member_id is null and
1683: rlm.resource_id = p_filter_rlm_id and
1684: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1685: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1686: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1687: rlm.parent_member_id is not null and
1688: rlm.resource_id = p_filter_rlm_id and
1689: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1686: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1682: rlm.parent_member_id is null and
1683: rlm.resource_id = p_filter_rlm_id and
1684: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1685: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1686: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1687: rlm.parent_member_id is not null and
1688: rlm.resource_id = p_filter_rlm_id and
1689: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1690: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

Line 1689: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1685: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1686: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1687: rlm.parent_member_id is not null and
1688: rlm.resource_id = p_filter_rlm_id and
1689: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1690: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1691: exists (select 1 from pa_budget_lines bl where bl.budget_version_id = ra.budget_version_id and
1692: bl.resource_assignment_id = ra.resource_assignment_id
1693: union

Line 1690: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

1686: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1687: rlm.parent_member_id is not null and
1688: rlm.resource_id = p_filter_rlm_id and
1689: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1690: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1691: exists (select 1 from pa_budget_lines bl where bl.budget_version_id = ra.budget_version_id and
1692: bl.resource_assignment_id = ra.resource_assignment_id
1693: union
1694: select 1 from dual where p_page_mode = c_edit_mode); /* exists condition included for bug 2710844 */

Line 1701: pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping as grouping_type,

1697: select ra.project_id,
1698: ra.task_id,
1699: ra.resource_list_member_id,
1700: ra.resource_assignment_id,
1701: pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping as grouping_type,
1702: p_project_currency as txn_currency_code,
1703: decode((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) AS UNIT_OF_MEASURE, -- ra.unit_of_measure, bug 3463685
1704: total_plan_quantity as quantity,
1705: -- 0 as burdened_cost,

Line 1707: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1703: decode((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) AS UNIT_OF_MEASURE, -- ra.unit_of_measure, bug 3463685
1704: total_plan_quantity as quantity,
1705: -- 0 as burdened_cost,
1706: -- 0 as raw_cost,
1707: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1708: 'PROJECT', ra.total_project_revenue,
1709: ra.total_plan_revenue) as revenue
1710: -- 0 as margin,
1711: -- 0 as margin_percent

Line 1729: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and

1725: from pa_resource_list_members
1726: where resource_list_member_id = p_filter_resource_id))) and
1727: /*
1728: (p_filter_resource_id = -1 or
1729: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and
1730: rlm.parent_member_id = p_filter_resource_id) or
1731: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and
1732: rlm.parent_member_id is null and
1733: rlm.resource_id = p_filter_resource_id)) and

Line 1731: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and

1727: /*
1728: (p_filter_resource_id = -1 or
1729: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'GROUPED' and
1730: rlm.parent_member_id = p_filter_resource_id) or
1731: (pa_fp_view_plans_txn_pub.Get_Rev_Version_Grouping = 'NONGROUPED' and
1732: rlm.parent_member_id is null and
1733: rlm.resource_id = p_filter_resource_id)) and
1734: */
1735: (p_filter_rlm_id = -1 or

Line 1736: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1732: rlm.parent_member_id is null and
1733: rlm.resource_id = p_filter_resource_id)) and
1734: */
1735: (p_filter_rlm_id = -1 or
1736: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1737: rlm.parent_member_id is null and
1738: rlm.resource_id = p_filter_rlm_id and
1739: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1740: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

Line 1739: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1735: (p_filter_rlm_id = -1 or
1736: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1737: rlm.parent_member_id is null and
1738: rlm.resource_id = p_filter_rlm_id and
1739: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1740: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1741: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1742: rlm.parent_member_id is not null and
1743: rlm.resource_id = p_filter_rlm_id and

Line 1740: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

1736: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1737: rlm.parent_member_id is null and
1738: rlm.resource_id = p_filter_rlm_id and
1739: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1740: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1741: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1742: rlm.parent_member_id is not null and
1743: rlm.resource_id = p_filter_rlm_id and
1744: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1741: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1737: rlm.parent_member_id is null and
1738: rlm.resource_id = p_filter_rlm_id and
1739: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1740: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1741: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1742: rlm.parent_member_id is not null and
1743: rlm.resource_id = p_filter_rlm_id and
1744: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1745: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

Line 1744: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1740: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1741: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1742: rlm.parent_member_id is not null and
1743: rlm.resource_id = p_filter_rlm_id and
1744: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1745: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1746: exists (select 1 from pa_budget_lines bl where bl.budget_version_id = ra.budget_version_id and
1747: bl.resource_assignment_id = ra.resource_assignment_id
1748: union

Line 1745: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

1741: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1742: rlm.parent_member_id is not null and
1743: rlm.resource_id = p_filter_rlm_id and
1744: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1745: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1746: exists (select 1 from pa_budget_lines bl where bl.budget_version_id = ra.budget_version_id and
1747: bl.resource_assignment_id = ra.resource_assignment_id
1748: union
1749: select 1 from dual where p_page_mode = c_edit_mode); /* exists condition included for bug 2710844 */

Line 1756: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,

1752: select ra.project_id,
1753: ra.task_id,
1754: ra.resource_list_member_id,
1755: ra.resource_assignment_id,
1756: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,
1757: p_project_currency as txn_currency_code,
1758: decode((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) AS UNIT_OF_MEASURE, -- ra.unit_of_measure, bug 3463685
1759: ra.total_plan_quantity as quantity,
1760: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

Line 1760: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1756: pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping as grouping_type,
1757: p_project_currency as txn_currency_code,
1758: decode((NVL(ra.track_as_labor_flag,'N')),'Y','HOURS',pr.unit_of_measure) AS UNIT_OF_MEASURE, -- ra.unit_of_measure, bug 3463685
1759: ra.total_plan_quantity as quantity,
1760: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1761: 'PROJECT', ra.total_project_burdened_cost,
1762: ra.total_plan_burdened_cost) as burdened_cost,
1763: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1764: 'PROJECT', ra.total_project_raw_cost,

Line 1763: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1759: ra.total_plan_quantity as quantity,
1760: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1761: 'PROJECT', ra.total_project_burdened_cost,
1762: ra.total_plan_burdened_cost) as burdened_cost,
1763: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1764: 'PROJECT', ra.total_project_raw_cost,
1765: ra.total_plan_raw_cost) as raw_cost,
1766: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1767: 'PROJECT', ra.total_project_revenue,

Line 1766: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1762: ra.total_plan_burdened_cost) as burdened_cost,
1763: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1764: 'PROJECT', ra.total_project_raw_cost,
1765: ra.total_plan_raw_cost) as raw_cost,
1766: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1767: 'PROJECT', ra.total_project_revenue,
1768: ra.total_plan_revenue) as revenue,
1769: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1770: 'PROJECT',

Line 1769: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1765: ra.total_plan_raw_cost) as raw_cost,
1766: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1767: 'PROJECT', ra.total_project_revenue,
1768: ra.total_plan_revenue) as revenue,
1769: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1770: 'PROJECT',
1771: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1772: 'R', ra.total_project_revenue - ra.total_project_raw_cost,
1773: ra.total_project_revenue - ra.total_project_burdened_cost),

Line 1771: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,

1767: 'PROJECT', ra.total_project_revenue,
1768: ra.total_plan_revenue) as revenue,
1769: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1770: 'PROJECT',
1771: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1772: 'R', ra.total_project_revenue - ra.total_project_raw_cost,
1773: ra.total_project_revenue - ra.total_project_burdened_cost),
1774: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1775: 'R', ra.total_plan_revenue - ra.total_plan_raw_cost,

Line 1774: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,

1770: 'PROJECT',
1771: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1772: 'R', ra.total_project_revenue - ra.total_project_raw_cost,
1773: ra.total_project_revenue - ra.total_project_burdened_cost),
1774: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1775: 'R', ra.total_plan_revenue - ra.total_plan_raw_cost,
1776: ra.total_plan_revenue - ra.total_plan_burdened_cost)) as margin,
1777: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1778: 'PROJECT',

Line 1777: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,

1773: ra.total_project_revenue - ra.total_project_burdened_cost),
1774: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1775: 'R', ra.total_plan_revenue - ra.total_plan_raw_cost,
1776: ra.total_plan_revenue - ra.total_plan_burdened_cost)) as margin,
1777: DECODE(pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE,
1778: 'PROJECT',
1779: DECODE(ra.total_project_revenue,
1780: null, null,
1781: 0, 0,

Line 1782: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,

1778: 'PROJECT',
1779: DECODE(ra.total_project_revenue,
1780: null, null,
1781: 0, 0,
1782: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1783: 'R', (ra.total_project_revenue - ra.total_project_raw_cost)/
1784: ra.total_project_revenue,
1785: (ra.total_project_revenue - ra.total_project_burdened_cost)/
1786: ra.total_project_revenue)),

Line 1790: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,

1786: ra.total_project_revenue)),
1787: DECODE(ra.total_project_revenue,
1788: null, null,
1789: 0, 0,
1790: DECODE(pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code,
1791: 'R', (ra.total_plan_revenue - ra.total_plan_raw_cost)/
1792: ra.total_plan_revenue,
1793: (ra.total_plan_revenue - ra.total_plan_burdened_cost)/
1794: ra.total_plan_revenue))) as margin_percent

Line 1812: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1808: from pa_resource_list_members
1809: where resource_list_member_id = p_filter_resource_id))) and
1810: /*
1811: (p_filter_resource_id = -1 or
1812: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1813: rlm.parent_member_id = p_filter_resource_id) or
1814: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1815: rlm.parent_member_id is null and
1816: rlm.resource_id = p_filter_resource_id)) and

Line 1814: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1810: /*
1811: (p_filter_resource_id = -1 or
1812: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1813: rlm.parent_member_id = p_filter_resource_id) or
1814: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1815: rlm.parent_member_id is null and
1816: rlm.resource_id = p_filter_resource_id)) and
1817: */
1818: (p_filter_rlm_id = -1 or

Line 1819: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and

1815: rlm.parent_member_id is null and
1816: rlm.resource_id = p_filter_resource_id)) and
1817: */
1818: (p_filter_rlm_id = -1 or
1819: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1820: rlm.parent_member_id is null and
1821: rlm.resource_id = p_filter_rlm_id and
1822: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1823: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

Line 1822: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1818: (p_filter_rlm_id = -1 or
1819: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1820: rlm.parent_member_id is null and
1821: rlm.resource_id = p_filter_rlm_id and
1822: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1823: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1824: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1825: rlm.parent_member_id is not null and
1826: rlm.resource_id = p_filter_rlm_id and

Line 1823: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or

1819: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'NONGROUPED' and
1820: rlm.parent_member_id is null and
1821: rlm.resource_id = p_filter_rlm_id and
1822: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1823: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1824: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1825: rlm.parent_member_id is not null and
1826: rlm.resource_id = p_filter_rlm_id and
1827: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

Line 1824: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and

1820: rlm.parent_member_id is null and
1821: rlm.resource_id = p_filter_rlm_id and
1822: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1823: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1824: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1825: rlm.parent_member_id is not null and
1826: rlm.resource_id = p_filter_rlm_id and
1827: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1828: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

Line 1827: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or

1823: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id)) or
1824: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1825: rlm.parent_member_id is not null and
1826: rlm.resource_id = p_filter_rlm_id and
1827: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1828: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1829: exists (select 1 from pa_budget_lines bl where bl.budget_version_id = ra.budget_version_id and
1830: bl.resource_assignment_id = ra.resource_assignment_id
1831: union

Line 1828: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and

1824: (pa_fp_view_plans_txn_pub.Get_Cost_Version_Grouping = 'GROUPED' and
1825: rlm.parent_member_id is not null and
1826: rlm.resource_id = p_filter_rlm_id and
1827: (rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Cost_Resource_List_Id or
1828: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1829: exists (select 1 from pa_budget_lines bl where bl.budget_version_id = ra.budget_version_id and
1830: bl.resource_assignment_id = ra.resource_assignment_id
1831: union
1832: select 1 from dual where p_page_mode = c_edit_mode); /* exists condition included for bug 2710844 */

Line 1837: l_c_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;

1833:
1834:
1835: -- PL/SQL tables
1836:
1837: l_c_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1838: l_c_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1839: l_c_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1840: l_c_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id

Line 1838: l_c_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;

1834:
1835: -- PL/SQL tables
1836:
1837: l_c_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1838: l_c_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1839: l_c_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1840: l_c_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id
1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;

Line 1839: l_c_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;

1835: -- PL/SQL tables
1836:
1837: l_c_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1838: l_c_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1839: l_c_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1840: l_c_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id
1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;

Line 1840: l_c_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;

1836:
1837: l_c_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1838: l_c_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1839: l_c_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1840: l_c_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id
1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;

Line 1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id

1837: l_c_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1838: l_c_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1839: l_c_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1840: l_c_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id
1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;

Line 1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;

1838: l_c_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1839: l_c_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1840: l_c_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id
1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;

Line 1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;

1839: l_c_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1840: l_c_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id
1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1847: l_c_burdened_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_burdened_cost_tab;

Line 1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;

1840: l_c_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id
1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1847: l_c_burdened_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_burdened_cost_tab;
1848: l_c_raw_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;

Line 1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;

1841: l_cr_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab; -- for compl res_asignment_id
1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1847: l_c_burdened_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_burdened_cost_tab;
1848: l_c_raw_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1849: l_c_margin_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;

Line 1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;

1842: l_c_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1847: l_c_burdened_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_burdened_cost_tab;
1848: l_c_raw_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1849: l_c_margin_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1850: l_c_margin_pct_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;

Line 1847: l_c_burdened_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_burdened_cost_tab;

1843: l_c_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1847: l_c_burdened_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_burdened_cost_tab;
1848: l_c_raw_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1849: l_c_margin_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1850: l_c_margin_pct_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1851:

Line 1848: l_c_raw_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;

1844: l_c_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1847: l_c_burdened_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_burdened_cost_tab;
1848: l_c_raw_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1849: l_c_margin_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1850: l_c_margin_pct_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1851:
1852: l_r_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;

Line 1849: l_c_margin_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;

1845: l_c_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1847: l_c_burdened_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_burdened_cost_tab;
1848: l_c_raw_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1849: l_c_margin_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1850: l_c_margin_pct_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1851:
1852: l_r_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1853: l_r_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;

Line 1850: l_c_margin_pct_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;

1846: l_c_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1847: l_c_burdened_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_burdened_cost_tab;
1848: l_c_raw_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1849: l_c_margin_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1850: l_c_margin_pct_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1851:
1852: l_r_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1853: l_r_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1854: l_r_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;

Line 1852: l_r_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;

1848: l_c_raw_cost_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1849: l_c_margin_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1850: l_c_margin_pct_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1851:
1852: l_r_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1853: l_r_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1854: l_r_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1855: l_r_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;

Line 1853: l_r_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;

1849: l_c_margin_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1850: l_c_margin_pct_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1851:
1852: l_r_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1853: l_r_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1854: l_r_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1855: l_r_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1857: l_r_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;

Line 1854: l_r_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;

1850: l_c_margin_pct_tab pa_fp_view_plans_txn_pub.vptxn_txn_raw_cost_tab;
1851:
1852: l_r_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1853: l_r_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1854: l_r_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1855: l_r_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1857: l_r_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1858: l_r_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;

Line 1855: l_r_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;

1851:
1852: l_r_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1853: l_r_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1854: l_r_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1855: l_r_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1857: l_r_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1858: l_r_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1859: l_r_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;

Line 1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;

1852: l_r_project_id_tab pa_fp_view_plans_txn_pub.vptxn_project_id_tab;
1853: l_r_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1854: l_r_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1855: l_r_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1857: l_r_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1858: l_r_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1859: l_r_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1860: l_r_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;

Line 1857: l_r_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;

1853: l_r_task_id_tab pa_fp_view_plans_txn_pub.vptxn_task_id_tab;
1854: l_r_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1855: l_r_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1857: l_r_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1858: l_r_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1859: l_r_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1860: l_r_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1861:

Line 1858: l_r_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;

1854: l_r_res_list_member_id_tab pa_fp_view_plans_txn_pub.vptxn_res_list_member_id_tab;
1855: l_r_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1857: l_r_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1858: l_r_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1859: l_r_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1860: l_r_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1861:
1862: l_cost_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 1859: l_r_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;

1855: l_r_res_assignment_id_tab pa_fp_view_plans_txn_pub.vptxn_res_assignment_id_tab;
1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1857: l_r_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1858: l_r_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1859: l_r_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1860: l_r_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1861:
1862: l_cost_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1863: l_rev_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 1860: l_r_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;

1856: l_r_grouping_tab pa_fp_view_plans_txn_pub.vptxn_grouping_type_tab;
1857: l_r_txn_currency_code_tab pa_fp_view_plans_txn_pub.vptxn_txn_currency_code_tab;
1858: l_r_unit_of_measure_tab pa_fp_view_plans_txn_pub.vptxn_unit_of_measure_tab;
1859: l_r_quantity_tab pa_fp_view_plans_txn_pub.vptxn_quantity_tab;
1860: l_r_revenue_tab pa_fp_view_plans_txn_pub.vptxn_txn_revenue_tab;
1861:
1862: l_cost_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1863: l_rev_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1864: l_both_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 2214: if pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code = 'R' then

2210: l_compl_found := true;
2211: l_c_revenue_tab(i) := l_r_revenue_tab(j);
2212: l_cr_res_assignment_id_tab(i) := l_r_res_assignment_id_tab(j);
2213: -- use Get_Derive_Margin_From_Code to calculate margin
2214: if pa_fp_view_plans_txn_pub.Get_Derive_Margin_From_Code = 'R' then
2215: l_c_margin_tab(i) := l_c_revenue_tab(i) - l_c_raw_cost_tab(i);
2216: else
2217: l_c_margin_tab(i) := l_c_revenue_tab(i) - l_c_burdened_cost_tab(i);
2218: end if;

Line 2226: if pa_fp_view_plans_txn_pub.Get_Report_Labor_Hrs_From_Code = 'REVENUE' then

2222: else
2223: l_c_margin_pct_tab(i) := l_c_margin_tab(i) / l_c_revenue_tab(i);
2224: end if;
2225: -- stamp QUANTITY and UNIT OF MEASURE based on the correct source
2226: if pa_fp_view_plans_txn_pub.Get_Report_Labor_Hrs_From_Code = 'REVENUE' then
2227: l_c_quantity_tab(i) := l_r_quantity_tab(j);
2228: l_c_unit_of_measure_tab(i) := l_r_unit_of_measure_tab(j);
2229: end if;
2230: /*

Line 2346: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_view_plans_txn_pub',

2342: rollback to PA_FIN_PLAN_VIEWPLANS_TXN;
2343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2344: x_msg_count := 1;
2345: x_msg_data := SQLERRM;
2346: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_view_plans_txn_pub',
2347: p_procedure_name => 'view_plans_txn_populate_tmp');
2348: pa_debug.reset_err_stack;
2349: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2350: END view_plans_txn_populate_tmp;

Line 2453: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '100: entered procedure', 2);

2449: l_msg_data VARCHAR2(2000);
2450: l_msg_index_out NUMBER;
2451:
2452: BEGIN
2453: --pa_debug.write('pa_fp_view_plans_txn_pub.nonhgrid_view_initialize', '100: entered procedure', 2);
2454: --hr_utility.trace_on(null, 'dlai');
2455: x_msg_count := 0;
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:

Line 2478: pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID := l_ci_budget_version_id;

2474:
2475: --- >>>> PROCESSING FOR FIRST ROW <<<< ---
2476: if l_ci_row_index = 1 then
2477: l_ci_budget_version_id := ci_rec.budget_version_id;
2478: pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID := l_ci_budget_version_id;
2479: select fin_plan_type_id,
2480: proj_fp_options_id
2481: into l_fin_plan_type_id,
2482: l_proj_fp_options_id

Line 2541: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJFUNC';

2537: select projfunc_currency_code
2538: into x_project_currency
2539: from pa_projects_all
2540: where project_id = p_project_id;
2541: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJFUNC';
2542:
2543: end if; -- ci_id is not null
2544:
2545: else

Line 2553: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJECT';

2549: select project_currency_code
2550: into x_project_currency
2551: from pa_projects_all
2552: where project_id = p_project_id;
2553: pa_fp_view_plans_txn_pub.G_DISPLAY_CURRENCY_TYPE := 'PROJECT';
2554: end if; -- approved revenue flag
2555:
2556: if l_uncategorized_flag = 'Y' then
2557: x_planned_resources_flag := 'N';

Line 2580: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;

2576: from pa_proj_fp_options
2577: where project_id = p_project_id and
2578: fin_plan_type_id = l_fin_plan_type_id and
2579: fin_plan_option_level_code = 'PLAN_TYPE';
2580: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
2581: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;
2582: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := ci_rec.plan_in_multi_curr_flag;
2583:
2584: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;

Line 2581: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;

2577: where project_id = p_project_id and
2578: fin_plan_type_id = l_fin_plan_type_id and
2579: fin_plan_option_level_code = 'PLAN_TYPE';
2580: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
2581: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;
2582: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := ci_rec.plan_in_multi_curr_flag;
2583:
2584: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
2585:

Line 2582: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := ci_rec.plan_in_multi_curr_flag;

2578: fin_plan_type_id = l_fin_plan_type_id and
2579: fin_plan_option_level_code = 'PLAN_TYPE';
2580: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
2581: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;
2582: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := ci_rec.plan_in_multi_curr_flag;
2583:
2584: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
2585:
2586: if l_fp_preference_code = 'COST_AND_REV_SAME' then

Line 2584: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;

2580: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := l_report_labor_hrs_from_code;
2581: pa_fp_view_plans_txn_pub.G_PLAN_TYPE_ID := l_fin_plan_type_id;
2582: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := ci_rec.plan_in_multi_curr_flag;
2583:
2584: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
2585:
2586: if l_fp_preference_code = 'COST_AND_REV_SAME' then
2587: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2588: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;

Line 2587: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;

2583:
2584: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
2585:
2586: if l_fp_preference_code = 'COST_AND_REV_SAME' then
2587: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2588: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2589: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2590: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2591: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';

Line 2588: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;

2584: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
2585:
2586: if l_fp_preference_code = 'COST_AND_REV_SAME' then
2587: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2588: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2589: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2590: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2591: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
2592: x_grouping_type := l_grouping_type;

Line 2589: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;

2585:
2586: if l_fp_preference_code = 'COST_AND_REV_SAME' then
2587: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2588: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2589: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2590: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2591: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
2592: x_grouping_type := l_grouping_type;
2593: -- set planning level code for page: P, T, L, or M

Line 2590: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

2586: if l_fp_preference_code = 'COST_AND_REV_SAME' then
2587: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2588: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2589: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2590: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2591: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
2592: x_grouping_type := l_grouping_type;
2593: -- set planning level code for page: P, T, L, or M
2594: select all_fin_plan_level_code

Line 2591: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';

2587: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2588: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2589: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2590: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2591: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'ANY';
2592: x_grouping_type := l_grouping_type;
2593: -- set planning level code for page: P, T, L, or M
2594: select all_fin_plan_level_code
2595: into l_cost_planning_level

Line 2605: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;

2601: x_cost_rl_id := l_resource_list_id;
2602: x_rev_rl_id := l_resource_list_id;
2603:
2604: elsif l_fp_preference_code = 'COST_ONLY' then
2605: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2606: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
2607: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2608: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2609: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';

Line 2606: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;

2602: x_rev_rl_id := l_resource_list_id;
2603:
2604: elsif l_fp_preference_code = 'COST_ONLY' then
2605: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2606: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
2607: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2608: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2609: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
2610: x_grouping_type := l_grouping_type;

Line 2607: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;

2603:
2604: elsif l_fp_preference_code = 'COST_ONLY' then
2605: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2606: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
2607: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2608: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2609: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
2610: x_grouping_type := l_grouping_type;
2611: -- set planning level code for page: P, T, L, or M

Line 2608: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

2604: elsif l_fp_preference_code = 'COST_ONLY' then
2605: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2606: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
2607: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2608: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2609: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
2610: x_grouping_type := l_grouping_type;
2611: -- set planning level code for page: P, T, L, or M
2612: select cost_fin_plan_level_code

Line 2609: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';

2605: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2606: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := -1;
2607: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2608: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2609: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'COST';
2610: x_grouping_type := l_grouping_type;
2611: -- set planning level code for page: P, T, L, or M
2612: select cost_fin_plan_level_code
2613: into l_cost_planning_level

Line 2623: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;

2619: x_cost_rl_id := l_resource_list_id;
2620: x_rev_rl_id := -1;
2621:
2622: elsif l_fp_preference_code = 'REVENUE_ONLY' then
2623: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
2624: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2625: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2626: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2627: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';

Line 2624: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;

2620: x_rev_rl_id := -1;
2621:
2622: elsif l_fp_preference_code = 'REVENUE_ONLY' then
2623: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
2624: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2625: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2626: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2627: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
2628: x_grouping_type := l_grouping_type;

Line 2625: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;

2621:
2622: elsif l_fp_preference_code = 'REVENUE_ONLY' then
2623: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
2624: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2625: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2626: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2627: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
2628: x_grouping_type := l_grouping_type;
2629: -- set planning level code for page: P, T, L, or M

Line 2626: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

2622: elsif l_fp_preference_code = 'REVENUE_ONLY' then
2623: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
2624: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2625: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2626: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2627: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
2628: x_grouping_type := l_grouping_type;
2629: -- set planning level code for page: P, T, L, or M
2630: select revenue_fin_plan_level_code

Line 2627: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';

2623: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := -1;
2624: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2625: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2626: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2627: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'REVENUE';
2628: x_grouping_type := l_grouping_type;
2629: -- set planning level code for page: P, T, L, or M
2630: select revenue_fin_plan_level_code
2631: into l_rev_planning_level

Line 2684: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;

2680: from pa_budget_versions bv,
2681: pa_resource_lists_all_bg rl
2682: where bv.budget_version_id = ci_rec.budget_version_id and
2683: bv.resource_list_id = rl.resource_list_id;
2684: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2685: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2686: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2687: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2688: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

Line 2685: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;

2681: pa_resource_lists_all_bg rl
2682: where bv.budget_version_id = ci_rec.budget_version_id and
2683: bv.resource_list_id = rl.resource_list_id;
2684: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2685: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2686: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2687: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2688: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2689: if l_grouping_type = 'GROUPED' then

Line 2686: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;

2682: where bv.budget_version_id = ci_rec.budget_version_id and
2683: bv.resource_list_id = rl.resource_list_id;
2684: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2685: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2686: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2687: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2688: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2689: if l_grouping_type = 'GROUPED' then
2690: if l_compl_grouping_type = 'GROUPED' then

Line 2687: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;

2683: bv.resource_list_id = rl.resource_list_id;
2684: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2685: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2686: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2687: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2688: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2689: if l_grouping_type = 'GROUPED' then
2690: if l_compl_grouping_type = 'GROUPED' then
2691: x_grouping_type := 'GROUPED';

Line 2688: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

2684: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2685: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2686: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2687: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2688: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2689: if l_grouping_type = 'GROUPED' then
2690: if l_compl_grouping_type = 'GROUPED' then
2691: x_grouping_type := 'GROUPED';
2692: else

Line 2722: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then

2718: x_planning_level := 'P';
2719: else
2720: x_planning_level := l_cost_planning_level;
2721: end if;
2722: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then
2723: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2724: end if;
2725:
2726: elsif l_fp_preference_code = 'REVENUE_ONLY' then

Line 2723: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';

2719: else
2720: x_planning_level := l_cost_planning_level;
2721: end if;
2722: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then
2723: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2724: end if;
2725:
2726: elsif l_fp_preference_code = 'REVENUE_ONLY' then
2727: -- this second row must be the complementary COST version

Line 2742: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;

2738: from pa_budget_versions bv,
2739: pa_resource_lists_all_bg rl
2740: where bv.budget_version_id = ci_rec.budget_version_id and
2741: bv.resource_list_id = rl.resource_list_id;
2742: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2743: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2744: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2745: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2746: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

Line 2743: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;

2739: pa_resource_lists_all_bg rl
2740: where bv.budget_version_id = ci_rec.budget_version_id and
2741: bv.resource_list_id = rl.resource_list_id;
2742: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2743: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2744: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2745: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2746: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2747: if l_grouping_type = 'GROUPED' then

Line 2744: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;

2740: where bv.budget_version_id = ci_rec.budget_version_id and
2741: bv.resource_list_id = rl.resource_list_id;
2742: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2743: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2744: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2745: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2746: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2747: if l_grouping_type = 'GROUPED' then
2748: if l_compl_grouping_type = 'GROUPED' then

Line 2745: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

2741: bv.resource_list_id = rl.resource_list_id;
2742: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2743: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2744: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2745: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2746: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2747: if l_grouping_type = 'GROUPED' then
2748: if l_compl_grouping_type = 'GROUPED' then
2749: x_grouping_type := 'GROUPED';

Line 2746: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

2742: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2743: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2744: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2745: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2746: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2747: if l_grouping_type = 'GROUPED' then
2748: if l_compl_grouping_type = 'GROUPED' then
2749: x_grouping_type := 'GROUPED';
2750: else

Line 2780: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then

2776: x_planning_level := 'P';
2777: else
2778: x_planning_level := l_rev_planning_level;
2779: end if;
2780: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then
2781: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2782: end if;
2783: -- ** if the second row is COST version, then its pref codes take precedence **
2784: if l_margin_derived_code is not null then

Line 2781: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';

2777: else
2778: x_planning_level := l_rev_planning_level;
2779: end if;
2780: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then
2781: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2782: end if;
2783: -- ** if the second row is COST version, then its pref codes take precedence **
2784: if l_margin_derived_code is not null then
2785: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;

Line 2785: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;

2781: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2782: end if;
2783: -- ** if the second row is COST version, then its pref codes take precedence **
2784: if l_margin_derived_code is not null then
2785: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
2786: end if;
2787: if l_fin_plan_type_id <> l_fin_plan_type_id2 then
2788: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := 'COST';
2789: end if;

Line 2788: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := 'COST';

2784: if l_margin_derived_code is not null then
2785: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
2786: end if;
2787: if l_fin_plan_type_id <> l_fin_plan_type_id2 then
2788: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := 'COST';
2789: end if;
2790:
2791:
2792: elsif l_fp_preference_code = 'COST_AND_REV_SEP' then

Line 2809: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;

2805: from pa_budget_versions bv,
2806: pa_resource_lists_all_bg rl
2807: where bv.budget_version_id = ci_rec.budget_version_id and
2808: bv.resource_list_id = rl.resource_list_id;
2809: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2810: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2811: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2812: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2813: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

Line 2810: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;

2806: pa_resource_lists_all_bg rl
2807: where bv.budget_version_id = ci_rec.budget_version_id and
2808: bv.resource_list_id = rl.resource_list_id;
2809: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2810: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2811: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2812: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2813: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2814: if l_grouping_type = 'GROUPED' then

Line 2811: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;

2807: where bv.budget_version_id = ci_rec.budget_version_id and
2808: bv.resource_list_id = rl.resource_list_id;
2809: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2810: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2811: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2812: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2813: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2814: if l_grouping_type = 'GROUPED' then
2815: if l_compl_grouping_type = 'GROUPED' then

Line 2812: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;

2808: bv.resource_list_id = rl.resource_list_id;
2809: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2810: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2811: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2812: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2813: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2814: if l_grouping_type = 'GROUPED' then
2815: if l_compl_grouping_type = 'GROUPED' then
2816: x_grouping_type := 'GROUPED';

Line 2813: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

2809: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2810: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;
2811: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_compl_grouping_type;
2812: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_grouping_type;
2813: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2814: if l_grouping_type = 'GROUPED' then
2815: if l_compl_grouping_type = 'GROUPED' then
2816: x_grouping_type := 'GROUPED';
2817: else

Line 2847: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then

2843: x_planning_level := 'P';
2844: else
2845: x_planning_level := l_rev_planning_level;
2846: end if;
2847: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then
2848: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2849: end if;
2850: -- ** if the second row is COST version, then its pref codes take precedence **
2851: if l_margin_derived_code is not null then

Line 2848: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';

2844: else
2845: x_planning_level := l_rev_planning_level;
2846: end if;
2847: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then
2848: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2849: end if;
2850: -- ** if the second row is COST version, then its pref codes take precedence **
2851: if l_margin_derived_code is not null then
2852: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;

Line 2852: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;

2848: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2849: end if;
2850: -- ** if the second row is COST version, then its pref codes take precedence **
2851: if l_margin_derived_code is not null then
2852: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
2853: end if;
2854: if l_fin_plan_type_id <> l_fin_plan_type_id2 then
2855: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := 'COST';
2856: end if;

Line 2855: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := 'COST';

2851: if l_margin_derived_code is not null then
2852: pa_fp_view_plans_txn_pub.G_DERIVE_MARGIN_FROM_CODE := l_margin_derived_code;
2853: end if;
2854: if l_fin_plan_type_id <> l_fin_plan_type_id2 then
2855: pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE := 'COST';
2856: end if;
2857:
2858:
2859: else

Line 2875: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;

2871: from pa_budget_versions bv,
2872: pa_resource_lists_all_bg rl
2873: where bv.budget_version_id = ci_rec.budget_version_id and
2874: bv.resource_list_id = rl.resource_list_id;
2875: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2876: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2877: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2878: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2879: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

Line 2876: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;

2872: pa_resource_lists_all_bg rl
2873: where bv.budget_version_id = ci_rec.budget_version_id and
2874: bv.resource_list_id = rl.resource_list_id;
2875: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2876: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2877: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2878: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2879: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2880: if l_grouping_type = 'GROUPED' then

Line 2877: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;

2873: where bv.budget_version_id = ci_rec.budget_version_id and
2874: bv.resource_list_id = rl.resource_list_id;
2875: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2876: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2877: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2878: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2879: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2880: if l_grouping_type = 'GROUPED' then
2881: if l_compl_grouping_type = 'GROUPED' then

Line 2878: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;

2874: bv.resource_list_id = rl.resource_list_id;
2875: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2876: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2877: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2878: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2879: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2880: if l_grouping_type = 'GROUPED' then
2881: if l_compl_grouping_type = 'GROUPED' then
2882: x_grouping_type := 'GROUPED';

Line 2879: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';

2875: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2876: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;
2877: pa_fp_view_plans_txn_pub.G_COST_VERSION_GROUPING := l_grouping_type;
2878: pa_fp_view_plans_txn_pub.G_REV_VERSION_GROUPING := l_compl_grouping_type;
2879: pa_fp_view_plans_txn_pub.G_DISPLAY_FROM := 'BOTH';
2880: if l_grouping_type = 'GROUPED' then
2881: if l_compl_grouping_type = 'GROUPED' then
2882: x_grouping_type := 'GROUPED';
2883: else

Line 2913: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then

2909: x_planning_level := 'P';
2910: else
2911: x_planning_level := l_cost_planning_level;
2912: end if;
2913: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then
2914: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2915: end if;
2916: end if;
2917:

Line 2914: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';

2910: else
2911: x_planning_level := l_cost_planning_level;
2912: end if;
2913: if pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG = 'N' or ci_rec.plan_in_multi_curr_flag = 'N' then
2914: pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG := 'N';
2915: end if;
2916: end if;
2917:
2918:

Line 2926: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;

2922: close ci_csr;
2923:
2924:
2925: x_fin_plan_type_id := l_fin_plan_type_id;
2926: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
2927: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
2928: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
2929: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
2930:

Line 2927: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;

2923:
2924:
2925: x_fin_plan_type_id := l_fin_plan_type_id;
2926: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
2927: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
2928: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
2929: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
2930:
2931: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;

Line 2928: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;

2924:
2925: x_fin_plan_type_id := l_fin_plan_type_id;
2926: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
2927: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
2928: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
2929: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
2930:
2931: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
2932: if ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH') and

Line 2929: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;

2925: x_fin_plan_type_id := l_fin_plan_type_id;
2926: x_display_from := pa_fp_view_plans_txn_pub.G_DISPLAY_FROM;
2927: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
2928: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
2929: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
2930:
2931: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
2932: if ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH') and
2933: ((l_uncategorized_flag = 'Y') and (l_compl_uncategorized_flag = 'Y'))) or

Line 2931: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;

2927: x_multicurrency_flag := pa_fp_view_plans_txn_pub.G_MULTI_CURR_FLAG;
2928: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
2929: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
2930:
2931: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
2932: if ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH') and
2933: ((l_uncategorized_flag = 'Y') and (l_compl_uncategorized_flag = 'Y'))) or
2934: ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM <> 'BOTH') and
2935: (l_uncategorized_flag = 'Y')) then

Line 2932: if ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH') and

2928: x_cost_version_id := pa_fp_view_plans_txn_pub.G_COST_VERSION_ID;
2929: x_rev_version_id := pa_fp_view_plans_txn_pub.G_REV_VERSION_ID;
2930:
2931: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
2932: if ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH') and
2933: ((l_uncategorized_flag = 'Y') and (l_compl_uncategorized_flag = 'Y'))) or
2934: ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM <> 'BOTH') and
2935: (l_uncategorized_flag = 'Y')) then
2936: x_planned_resources_flag := 'N';

Line 2934: ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM <> 'BOTH') and

2930:
2931: x_labor_hrs_from_code := pa_fp_view_plans_txn_pub.G_REPORT_LABOR_HRS_FROM_CODE;
2932: if ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM = 'BOTH') and
2933: ((l_uncategorized_flag = 'Y') and (l_compl_uncategorized_flag = 'Y'))) or
2934: ((pa_fp_view_plans_txn_pub.G_DISPLAY_FROM <> 'BOTH') and
2935: (l_uncategorized_flag = 'Y')) then
2936: x_planned_resources_flag := 'N';
2937: else
2938: x_planned_resources_flag := 'Y';

Line 2945: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

2941: -- determine locked status of budget version(s)
2942: if x_display_from = 'ANY' then
2943: pa_fin_plan_utils.Check_Locked_By_User
2944: (p_user_id => p_user_id,
2945: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
2946: x_is_locked_by_userid => l_is_cost_locked_by_user,
2947: x_locked_by_person_id => l_cost_locked_by_person_id,
2948: x_return_status => l_return_status,
2949: x_msg_count => l_msg_count,

Line 2967: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

2963:
2964: /***** BUG 2813661: use pa_fp_view_plans_util.get_plan_version_res_level to set
2965: x_grouping_type and x_planned_resources_flag *****/
2966: pa_fp_view_plans_util.get_plan_version_res_level
2967: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
2968: p_entered_amts_only_flag => 'Y',
2969: x_resource_level => l_resource_level,
2970: x_return_status => l_return_status,
2971: x_msg_count => l_msg_count,

Line 3003: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

2999:
3000: elsif x_display_from = 'COST' then
3001: pa_fin_plan_utils.Check_Locked_By_User
3002: (p_user_id => p_user_id,
3003: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
3004: x_is_locked_by_userid => l_is_cost_locked_by_user,
3005: x_locked_by_person_id => l_cost_locked_by_person_id,
3006: x_return_status => l_return_status,
3007: x_msg_count => l_msg_count,

Line 3020: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

3016: x_cost_locked_name := 'SELF';
3017: end if; -- is_cost_locked_by_user
3018:
3019: pa_fp_view_plans_util.get_plan_version_res_level
3020: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
3021: p_entered_amts_only_flag => 'Y',
3022: x_resource_level => l_resource_level,
3023: x_return_status => l_return_status,
3024: x_msg_count => l_msg_count,

Line 3056: p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,

3052:
3053: elsif x_display_from = 'REVENUE' then
3054: pa_fin_plan_utils.Check_Locked_By_User
3055: (p_user_id => p_user_id,
3056: p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,
3057: x_is_locked_by_userid => l_is_rev_locked_by_user,
3058: x_locked_by_person_id => l_rev_locked_by_person_id,
3059: x_return_status => l_return_status,
3060: x_msg_count => l_msg_count,

Line 3073: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,

3069: x_rev_locked_name := 'SELF';
3070: end if; -- is_rev_locked_by_user
3071:
3072: pa_fp_view_plans_util.get_plan_version_res_level
3073: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,
3074: p_entered_amts_only_flag => 'Y',
3075: x_resource_level => l_resource_level,
3076: x_return_status => l_return_status,
3077: x_msg_count => l_msg_count,

Line 3110: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

3106: elsif x_display_from = 'BOTH' then
3107: -- FOR COST VERSION
3108: pa_fin_plan_utils.Check_Locked_By_User
3109: (p_user_id => p_user_id,
3110: p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
3111: x_is_locked_by_userid => l_is_cost_locked_by_user,
3112: x_locked_by_person_id => l_cost_locked_by_person_id,
3113: x_return_status => l_return_status,
3114: x_msg_count => l_msg_count,

Line 3127: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,

3123: x_cost_locked_name := 'SELF';
3124: end if; -- is_cost_locked_by_user
3125:
3126: pa_fp_view_plans_util.get_plan_version_res_level
3127: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_COST_VERSION_ID,
3128: p_entered_amts_only_flag => 'Y',
3129: x_resource_level => l_cost_resource_level,
3130: x_return_status => l_return_status,
3131: x_msg_count => l_msg_count,

Line 3149: p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,

3145:
3146: -- FOR REVENUE VERSION
3147: pa_fin_plan_utils.Check_Locked_By_User
3148: (p_user_id => p_user_id,
3149: p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,
3150: x_is_locked_by_userid => l_is_rev_locked_by_user,
3151: x_locked_by_person_id => l_rev_locked_by_person_id,
3152: x_return_status => l_return_status,
3153: x_msg_count => l_msg_count,

Line 3165: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,

3161: else
3162: x_rev_locked_name := 'SELF';
3163: end if; -- is_cost_locked_by_user
3164: pa_fp_view_plans_util.get_plan_version_res_level
3165: (p_budget_version_id => pa_fp_view_plans_txn_pub.G_REV_VERSION_ID,
3166: p_entered_amts_only_flag => 'Y',
3167: x_resource_level => l_revenue_resource_level,
3168: x_return_status => l_return_status,
3169: x_msg_count => l_msg_count,

Line 3194: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;

3190: x_display_res_flag := 'Y';
3191: x_display_resgp_flag := 'Y';
3192: end if;
3193: end if;
3194: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
3195: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
3196:
3197: END nonhgrid_view_initialize_ci;
3198:

Line 3195: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;

3191: x_display_resgp_flag := 'Y';
3192: end if;
3193: end if;
3194: pa_fp_view_plans_txn_pub.G_COST_RESOURCE_LIST_ID := x_cost_rl_id;
3195: pa_fp_view_plans_txn_pub.G_REVENUE_RESOURCE_LIST_ID := x_rev_rl_id;
3196:
3197: END nonhgrid_view_initialize_ci;
3198:
3199:

Line 3217: l_module_name VARCHAR2(50) := 'pa.plsql.PA_FP_VIEW_PLANS_TXN_PUB';

3213: l_data VARCHAR2(2000);
3214: l_msg_data VARCHAR2(2000);
3215: l_msg_index_out NUMBER;
3216: l_debug_mode VARCHAR2(1);
3217: l_module_name VARCHAR2(50) := 'pa.plsql.PA_FP_VIEW_PLANS_TXN_PUB';
3218:
3219: l_debug_level2 CONSTANT NUMBER := 2;
3220: l_debug_level3 CONSTANT NUMBER := 3;
3221: l_debug_level4 CONSTANT NUMBER := 4;

Line 3518: ( p_pkg_name => 'pa_fp_view_plans_txn_pub'

3514: CLOSE cur_sel_bud_line;
3515: END IF;
3516:
3517: FND_MSG_PUB.add_exc_msg
3518: ( p_pkg_name => 'pa_fp_view_plans_txn_pub'
3519: ,p_procedure_name => 'CALCULATE_AMOUNTS_FOR_VERSION'
3520: ,p_error_text => x_msg_data);
3521:
3522: IF l_debug_mode = 'Y' THEN

Line 3531: end pa_fp_view_plans_txn_pub;

3527: pa_debug.reset_curr_function;
3528: RAISE;
3529: END CALCULATE_AMOUNTS_FOR_VERSION;
3530:
3531: end pa_fp_view_plans_txn_pub;