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_FCST_GLOBAL dependencies on PA_FCST_GLOBAL

Line 1: PACKAGE BODY pa_fcst_global as

1: PACKAGE BODY pa_fcst_global as
2: /* $Header: PARFSGLB.pls 120.2 2006/01/11 17:48:18 ramurthy noship $ */
3:
4: PROCEDURE GetDefaultValue(x_start_period OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5: x_show_amount OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 65: pa_fcst_global.Global_proj_fcst_show_amt := 'REVENUE';

61:
62:
63: /* Initializing Global variable */
64:
65: pa_fcst_global.Global_proj_fcst_show_amt := 'REVENUE';
66: pa_fcst_global.Global_view_type := 'PERIODIC';
67: pa_fcst_global.Global_ProbabilityPerFlag := 'N';
68: pa_fcst_global.Global_Period_Set_Name := NULL;
69:

Line 66: pa_fcst_global.Global_view_type := 'PERIODIC';

62:
63: /* Initializing Global variable */
64:
65: pa_fcst_global.Global_proj_fcst_show_amt := 'REVENUE';
66: pa_fcst_global.Global_view_type := 'PERIODIC';
67: pa_fcst_global.Global_ProbabilityPerFlag := 'N';
68: pa_fcst_global.Global_Period_Set_Name := NULL;
69:
70:

Line 67: pa_fcst_global.Global_ProbabilityPerFlag := 'N';

63: /* Initializing Global variable */
64:
65: pa_fcst_global.Global_proj_fcst_show_amt := 'REVENUE';
66: pa_fcst_global.Global_view_type := 'PERIODIC';
67: pa_fcst_global.Global_ProbabilityPerFlag := 'N';
68: pa_fcst_global.Global_Period_Set_Name := NULL;
69:
70:
71: /* Assigning Global variable to Out variables. */

Line 68: pa_fcst_global.Global_Period_Set_Name := NULL;

64:
65: pa_fcst_global.Global_proj_fcst_show_amt := 'REVENUE';
66: pa_fcst_global.Global_view_type := 'PERIODIC';
67: pa_fcst_global.Global_ProbabilityPerFlag := 'N';
68: pa_fcst_global.Global_Period_Set_Name := NULL;
69:
70:
71: /* Assigning Global variable to Out variables. */
72:

Line 73: x_show_amount := pa_fcst_global.Global_proj_fcst_show_amt;

69:
70:
71: /* Assigning Global variable to Out variables. */
72:
73: x_show_amount := pa_fcst_global.Global_proj_fcst_show_amt;
74: x_project_type := null;
75: x_project_status := null;
76: x_view_type := pa_fcst_global.Global_view_type;
77: x_apply_prob_flag := pa_fcst_global.Global_ProbabilityPerFlag;

Line 76: x_view_type := pa_fcst_global.Global_view_type;

72:
73: x_show_amount := pa_fcst_global.Global_proj_fcst_show_amt;
74: x_project_type := null;
75: x_project_status := null;
76: x_view_type := pa_fcst_global.Global_view_type;
77: x_apply_prob_flag := pa_fcst_global.Global_ProbabilityPerFlag;
78:
79:
80: l_period_type := pa_fcst_global.Global_period_type;

Line 77: x_apply_prob_flag := pa_fcst_global.Global_ProbabilityPerFlag;

73: x_show_amount := pa_fcst_global.Global_proj_fcst_show_amt;
74: x_project_type := null;
75: x_project_status := null;
76: x_view_type := pa_fcst_global.Global_view_type;
77: x_apply_prob_flag := pa_fcst_global.Global_ProbabilityPerFlag;
78:
79:
80: l_period_type := pa_fcst_global.Global_period_type;
81:

Line 80: l_period_type := pa_fcst_global.Global_period_type;

76: x_view_type := pa_fcst_global.Global_view_type;
77: x_apply_prob_flag := pa_fcst_global.Global_ProbabilityPerFlag;
78:
79:
80: l_period_type := pa_fcst_global.Global_period_type;
81:
82:
83: /* Added the logic to display the classification and Project owner colum
84: display in the screen */

Line 107: pa_fcst_global.Global_Class_category := l_class_display;

103:
104: END;
105:
106:
107: pa_fcst_global.Global_Class_category := l_class_display;
108: pa_fcst_global.Global_key_member_id := l_prj_owner_display;
109:
110:
111: If l_class_display IS NULL THEN

Line 108: pa_fcst_global.Global_key_member_id := l_prj_owner_display;

104: END;
105:
106:
107: pa_fcst_global.Global_Class_category := l_class_display;
108: pa_fcst_global.Global_key_member_id := l_prj_owner_display;
109:
110:
111: If l_class_display IS NULL THEN
112: x_class_display := 'N';

Line 126: -- Not needed as the value is alreday coming from pa_fcst_global.Global_period_type

122: End If;
123:
124: /* NPE Changes Begin - Added displaying error messages for missing period type profile*/
125:
126: -- Not needed as the value is alreday coming from pa_fcst_global.Global_period_type
127: /* select fnd_profile.value('PA_FORECASTING_PERIOD_TYPE')
128: into l_period_type
129: from dual; */
130:

Line 171: pa_fcst_global.SetPeriodSetName;

167:
168: BEGIN
169:
170: --Calling procedure to initialize Global_Period_Set_Name;
171: pa_fcst_global.SetPeriodSetName;
172:
173: SELECT period_name, start_date, end_date
174: INTO l_start_period, l_start_date, l_end_date
175: FROM pa_fcst_periods_tmp_v

Line 176: WHERE period_type = pa_fcst_global.Global_period_type

172:
173: SELECT period_name, start_date, end_date
174: INTO l_start_period, l_start_date, l_end_date
175: FROM pa_fcst_periods_tmp_v
176: WHERE period_type = pa_fcst_global.Global_period_type
177: AND trunc(sysdate) between start_date and end_date
178: AND to_char(period_year) = to_char(sysdate,'YYYY');
179:
180:

Line 192: WHERE period_type = pa_fcst_global.Global_period_type

188:
189: SELECT period_name, start_date, end_date
190: INTO l_start_period, l_start_date, l_end_date
191: FROM pa_fcst_periods_tmp_v
192: WHERE period_type = pa_fcst_global.Global_period_type
193: and start_date =
194: ( SELECT max(start_date) from pa_fcst_periods_tmp_v
195: WHERE period_type = pa_fcst_global.Global_period_type
196: AND start_date < sysdate

Line 195: WHERE period_type = pa_fcst_global.Global_period_type

191: FROM pa_fcst_periods_tmp_v
192: WHERE period_type = pa_fcst_global.Global_period_type
193: and start_date =
194: ( SELECT max(start_date) from pa_fcst_periods_tmp_v
195: WHERE period_type = pa_fcst_global.Global_period_type
196: AND start_date < sysdate
197: );
198:
199: x_start_period := l_start_period;

Line 273: pa_fcst_global.Global_proj_fcst_start_date := l_start_date;

269:
270: CLOSE C1;
271:
272:
273: pa_fcst_global.Global_proj_fcst_start_date := l_start_date;
274: pa_fcst_global.Global_proj_fcst_end_date := l_csr_end_date;
275:
276:
277: EXCEPTION

Line 274: pa_fcst_global.Global_proj_fcst_end_date := l_csr_end_date;

270: CLOSE C1;
271:
272:
273: pa_fcst_global.Global_proj_fcst_start_date := l_start_date;
274: pa_fcst_global.Global_proj_fcst_end_date := l_csr_end_date;
275:
276:
277: EXCEPTION
278: WHEN OTHERS THEN

Line 282: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',

278: WHEN OTHERS THEN
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: x_msg_count := 1;
281: x_msg_data := SQLERRM;
282: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
283: p_procedure_name => 'GetDefaultValue');
284:
285: END GetDefaultValue;
286:

Line 346: pa_fcst_global.Global_project_type_class := l_project_type_class;

342: NULL;
343:
344: END;
345:
346: pa_fcst_global.Global_project_type_class := l_project_type_class;
347:
348: /* Set the Global variable for Project Id */
349:
350: pa_fcst_global.Global_ProjectId := p_project_id;

Line 350: pa_fcst_global.Global_ProjectId := p_project_id;

346: pa_fcst_global.Global_project_type_class := l_project_type_class;
347:
348: /* Set the Global variable for Project Id */
349:
350: pa_fcst_global.Global_ProjectId := p_project_id;
351:
352: /* Initializing Global variables */
353: IF pa_fcst_global.Global_project_type_class = 'CONTRACT' THEN
354: Global_proj_fcst_show_amt := 'REVENUE';

Line 353: IF pa_fcst_global.Global_project_type_class = 'CONTRACT' THEN

349:
350: pa_fcst_global.Global_ProjectId := p_project_id;
351:
352: /* Initializing Global variables */
353: IF pa_fcst_global.Global_project_type_class = 'CONTRACT' THEN
354: Global_proj_fcst_show_amt := 'REVENUE';
355: ELSE
356: Global_proj_fcst_show_amt := 'COST';
357: END IF;

Line 363: x_show_amount_type := pa_fcst_global.Global_proj_fcst_show_amt;

359: Global_ProbabilityPerFlag := 'N';
360:
361: /* Assigning Global value into output variables */
362:
363: x_show_amount_type := pa_fcst_global.Global_proj_fcst_show_amt;
364: x_apply_prob_per_flag := pa_fcst_global.Global_ProbabilityPerFlag;
365: l_period_type := pa_fcst_global.global_period_type;
366:
367: /* NPE Changes Begin - Added displaying error messages for missing period type profile*/

Line 364: x_apply_prob_per_flag := pa_fcst_global.Global_ProbabilityPerFlag;

360:
361: /* Assigning Global value into output variables */
362:
363: x_show_amount_type := pa_fcst_global.Global_proj_fcst_show_amt;
364: x_apply_prob_per_flag := pa_fcst_global.Global_ProbabilityPerFlag;
365: l_period_type := pa_fcst_global.global_period_type;
366:
367: /* NPE Changes Begin - Added displaying error messages for missing period type profile*/
368: /*

Line 365: l_period_type := pa_fcst_global.global_period_type;

361: /* Assigning Global value into output variables */
362:
363: x_show_amount_type := pa_fcst_global.Global_proj_fcst_show_amt;
364: x_apply_prob_per_flag := pa_fcst_global.Global_ProbabilityPerFlag;
365: l_period_type := pa_fcst_global.global_period_type;
366:
367: /* NPE Changes Begin - Added displaying error messages for missing period type profile*/
368: /*
369: select fnd_profile.value('PA_FORECASTING_PERIOD_TYPE')

Line 426: WHERE period_type = pa_fcst_global.Global_period_type

422:
423: SELECT period_name
424: INTO x_start_period_name
425: FROM pa_fcst_periods_tmp_v
426: WHERE period_type = pa_fcst_global.Global_period_type
427: and start_date =
428: ( SELECT max(start_date) from pa_fcst_periods_tmp_v
429: WHERE period_type = pa_fcst_global.Global_period_type
430: AND start_date < sysdate

Line 429: WHERE period_type = pa_fcst_global.Global_period_type

425: FROM pa_fcst_periods_tmp_v
426: WHERE period_type = pa_fcst_global.Global_period_type
427: and start_date =
428: ( SELECT max(start_date) from pa_fcst_periods_tmp_v
429: WHERE period_type = pa_fcst_global.Global_period_type
430: AND start_date < sysdate
431: );
432: /* NPE Changes Begin - Added displaying error messages for missing calendar */
433: EXCEPTION

Line 486: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',

482: WHEN OTHERS THEN
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: x_msg_count := 1;
485: x_msg_data := SQLERRM;
486: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
487: p_procedure_name => 'pa_fcst_proj_get_default');
488:
489: END pa_fcst_proj_get_default;
490:

Line 541: pa_fcst_global.Global_Page_First_Flag := p_page_first_flag;

537: END IF;
538: /* Populate the Period Temp Table */
539: Populate_Fcst_Periods;
540:
541: pa_fcst_global.Global_Page_First_Flag := p_page_first_flag;
542:
543: IF p_show_amount <> 'X' THEN
544: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;
545: END IF;

Line 544: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;

540:
541: pa_fcst_global.Global_Page_First_Flag := p_page_first_flag;
542:
543: IF p_show_amount <> 'X' THEN
544: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;
545: END IF;
546:
547: IF p_apply_prob_flag <> 'X' THEN
548: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;

Line 548: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;

544: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;
545: END IF;
546:
547: IF p_apply_prob_flag <> 'X' THEN
548: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;
549: END IF;
550:
551: IF p_project_number <> 'X' THEN
552: pa_fcst_global.Global_Project_Number := p_project_number;

Line 552: pa_fcst_global.Global_Project_Number := p_project_number;

548: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;
549: END IF;
550:
551: IF p_project_number <> 'X' THEN
552: pa_fcst_global.Global_Project_Number := p_project_number;
553: ELSE pa_fcst_global.Global_Project_Number :='ALL';
554: END IF;
555:
556: IF p_project_name <> 'X' THEN

Line 553: ELSE pa_fcst_global.Global_Project_Number :='ALL';

549: END IF;
550:
551: IF p_project_number <> 'X' THEN
552: pa_fcst_global.Global_Project_Number := p_project_number;
553: ELSE pa_fcst_global.Global_Project_Number :='ALL';
554: END IF;
555:
556: IF p_project_name <> 'X' THEN
557: pa_fcst_global.Global_Project_Name := p_project_name;

Line 557: pa_fcst_global.Global_Project_Name := p_project_name;

553: ELSE pa_fcst_global.Global_Project_Number :='ALL';
554: END IF;
555:
556: IF p_project_name <> 'X' THEN
557: pa_fcst_global.Global_Project_Name := p_project_name;
558: ELSE pa_fcst_global.Global_Project_Name :='XXXXXXXXXXXXXXX';
559: END IF;
560:
561: IF p_project_type <> 'X' THEN

Line 558: ELSE pa_fcst_global.Global_Project_Name :='XXXXXXXXXXXXXXX';

554: END IF;
555:
556: IF p_project_name <> 'X' THEN
557: pa_fcst_global.Global_Project_Name := p_project_name;
558: ELSE pa_fcst_global.Global_Project_Name :='XXXXXXXXXXXXXXX';
559: END IF;
560:
561: IF p_project_type <> 'X' THEN
562: pa_fcst_global.Global_project_type := p_project_type;

Line 562: pa_fcst_global.Global_project_type := p_project_type;

558: ELSE pa_fcst_global.Global_Project_Name :='XXXXXXXXXXXXXXX';
559: END IF;
560:
561: IF p_project_type <> 'X' THEN
562: pa_fcst_global.Global_project_type := p_project_type;
563: ELSE pa_fcst_global.Global_project_type := 'ALL';
564: END IF;
565:
566: IF p_organization_name <> 'X' THEN

Line 563: ELSE pa_fcst_global.Global_project_type := 'ALL';

559: END IF;
560:
561: IF p_project_type <> 'X' THEN
562: pa_fcst_global.Global_project_type := p_project_type;
563: ELSE pa_fcst_global.Global_project_type := 'ALL';
564: END IF;
565:
566: IF p_organization_name <> 'X' THEN
567: pa_fcst_global.Global_Orgnization_Name := p_organization_name;

Line 567: pa_fcst_global.Global_Orgnization_Name := p_organization_name;

563: ELSE pa_fcst_global.Global_project_type := 'ALL';
564: END IF;
565:
566: IF p_organization_name <> 'X' THEN
567: pa_fcst_global.Global_Orgnization_Name := p_organization_name;
568:
569: select organization_id
570: into l_org_id
571: from hr_all_organization_units_tl

Line 574: pa_fcst_global.Global_Orgnization_Id :=l_org_id;

570: into l_org_id
571: from hr_all_organization_units_tl
572: where name = p_organization_name
573: AND language = userenv('LANG');
574: pa_fcst_global.Global_Orgnization_Id :=l_org_id;
575:
576: ELSE pa_fcst_global.Global_Orgnization_Name :='ALL';
577: END IF;
578:

Line 576: ELSE pa_fcst_global.Global_Orgnization_Name :='ALL';

572: where name = p_organization_name
573: AND language = userenv('LANG');
574: pa_fcst_global.Global_Orgnization_Id :=l_org_id;
575:
576: ELSE pa_fcst_global.Global_Orgnization_Name :='ALL';
577: END IF;
578:
579: IF p_project_status <> 'X' THEN
580: pa_fcst_global.Global_project_status := p_project_status;

Line 580: pa_fcst_global.Global_project_status := p_project_status;

576: ELSE pa_fcst_global.Global_Orgnization_Name :='ALL';
577: END IF;
578:
579: IF p_project_status <> 'X' THEN
580: pa_fcst_global.Global_project_status := p_project_status;
581: ELSE pa_fcst_global.Global_project_status := 'ALL';
582: END IF;
583:
584: IF p_project_manager_name <> 'X' THEN

Line 581: ELSE pa_fcst_global.Global_project_status := 'ALL';

577: END IF;
578:
579: IF p_project_status <> 'X' THEN
580: pa_fcst_global.Global_project_status := p_project_status;
581: ELSE pa_fcst_global.Global_project_status := 'ALL';
582: END IF;
583:
584: IF p_project_manager_name <> 'X' THEN
585: pa_fcst_global.GLobal_Project_Manager_Name := p_project_manager_name;

Line 585: pa_fcst_global.GLobal_Project_Manager_Name := p_project_manager_name;

581: ELSE pa_fcst_global.Global_project_status := 'ALL';
582: END IF;
583:
584: IF p_project_manager_name <> 'X' THEN
585: pa_fcst_global.GLobal_Project_Manager_Name := p_project_manager_name;
586: ELSE pa_fcst_global.GLobal_Project_Manager_Name := 'XXXXXXXXXXXXXXX';
587: END IF;
588:
589: IF p_project_customer_name <> 'X' THEN

Line 586: ELSE pa_fcst_global.GLobal_Project_Manager_Name := 'XXXXXXXXXXXXXXX';

582: END IF;
583:
584: IF p_project_manager_name <> 'X' THEN
585: pa_fcst_global.GLobal_Project_Manager_Name := p_project_manager_name;
586: ELSE pa_fcst_global.GLobal_Project_Manager_Name := 'XXXXXXXXXXXXXXX';
587: END IF;
588:
589: IF p_project_customer_name <> 'X' THEN
590: pa_fcst_global.GLobal_Project_Customer_Name := p_project_customer_name;

Line 590: pa_fcst_global.GLobal_Project_Customer_Name := p_project_customer_name;

586: ELSE pa_fcst_global.GLobal_Project_Manager_Name := 'XXXXXXXXXXXXXXX';
587: END IF;
588:
589: IF p_project_customer_name <> 'X' THEN
590: pa_fcst_global.GLobal_Project_Customer_Name := p_project_customer_name;
591: ELSE pa_fcst_global.GLobal_Project_Customer_Name := 'XXXXXXXXXXXXXXX';
592: END IF;
593:
594: l_period_type := pa_fcst_global.Global_period_type;

Line 591: ELSE pa_fcst_global.GLobal_Project_Customer_Name := 'XXXXXXXXXXXXXXX';

587: END IF;
588:
589: IF p_project_customer_name <> 'X' THEN
590: pa_fcst_global.GLobal_Project_Customer_Name := p_project_customer_name;
591: ELSE pa_fcst_global.GLobal_Project_Customer_Name := 'XXXXXXXXXXXXXXX';
592: END IF;
593:
594: l_period_type := pa_fcst_global.Global_period_type;
595:

Line 594: l_period_type := pa_fcst_global.Global_period_type;

590: pa_fcst_global.GLobal_Project_Customer_Name := p_project_customer_name;
591: ELSE pa_fcst_global.GLobal_Project_Customer_Name := 'XXXXXXXXXXXXXXX';
592: END IF;
593:
594: l_period_type := pa_fcst_global.Global_period_type;
595:
596: BEGIN
597:
598: SELECT

Line 633: pa_fcst_global.Global_proj_fcst_start_date := l_start_date;

629:
630: CLOSE C1;
631:
632:
633: pa_fcst_global.Global_proj_fcst_start_date := l_start_date;
634: pa_fcst_global.Global_proj_fcst_end_date := l_csr_end_date;
635:
636:
637: EXCEPTION

Line 634: pa_fcst_global.Global_proj_fcst_end_date := l_csr_end_date;

630: CLOSE C1;
631:
632:
633: pa_fcst_global.Global_proj_fcst_start_date := l_start_date;
634: pa_fcst_global.Global_proj_fcst_end_date := l_csr_end_date;
635:
636:
637: EXCEPTION
638: WHEN OTHERS THEN

Line 642: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',

638: WHEN OTHERS THEN
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: x_msg_count := 1;
641: x_msg_data := SQLERRM;
642: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
643: p_procedure_name => 'Set_CrossProject_GlobalValue');
644:
645: END Set_CrossProject_GlobalValue;
646:

Line 695: pa_fcst_global.Global_ProjectId := p_project_id;

691: FND_MSG_PUB.initialize;
692: END IF;
693:
694:
695: pa_fcst_global.Global_ProjectId := p_project_id;
696: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;
697: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;
698: pa_fcst_global.Global_ProbabilityPer := p_apply_prob_per;
699: l_period_type := pa_fcst_global.global_period_type;

Line 696: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;

692: END IF;
693:
694:
695: pa_fcst_global.Global_ProjectId := p_project_id;
696: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;
697: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;
698: pa_fcst_global.Global_ProbabilityPer := p_apply_prob_per;
699: l_period_type := pa_fcst_global.global_period_type;
700:

Line 697: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;

693:
694:
695: pa_fcst_global.Global_ProjectId := p_project_id;
696: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;
697: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;
698: pa_fcst_global.Global_ProbabilityPer := p_apply_prob_per;
699: l_period_type := pa_fcst_global.global_period_type;
700:
701:

Line 698: pa_fcst_global.Global_ProbabilityPer := p_apply_prob_per;

694:
695: pa_fcst_global.Global_ProjectId := p_project_id;
696: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;
697: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;
698: pa_fcst_global.Global_ProbabilityPer := p_apply_prob_per;
699: l_period_type := pa_fcst_global.global_period_type;
700:
701:
702: SELECT min(start_date), -- Added for bug# 3620818

Line 699: l_period_type := pa_fcst_global.global_period_type;

695: pa_fcst_global.Global_ProjectId := p_project_id;
696: pa_fcst_global.Global_proj_fcst_show_amt := p_show_amount;
697: pa_fcst_global.Global_ProbabilityPerFlag := p_apply_prob_flag;
698: pa_fcst_global.Global_ProbabilityPer := p_apply_prob_per;
699: l_period_type := pa_fcst_global.global_period_type;
700:
701:
702: SELECT min(start_date), -- Added for bug# 3620818
703: max(end_date)

Line 741: pa_fcst_global.Global_pl_start_date := l_pl_start_date;

737: add_months(sysdate,6));
738:
739: END IF;
740:
741: pa_fcst_global.Global_pl_start_date := l_pl_start_date;
742: pa_fcst_global.Global_pl_end_date := l_pl_end_date;
743:
744: SELECT pr2.project_type_class_code
745: INTO l_project_type_class

Line 742: pa_fcst_global.Global_pl_end_date := l_pl_end_date;

738:
739: END IF;
740:
741: pa_fcst_global.Global_pl_start_date := l_pl_start_date;
742: pa_fcst_global.Global_pl_end_date := l_pl_end_date;
743:
744: SELECT pr2.project_type_class_code
745: INTO l_project_type_class
746: FROM pa_projects_all pr1,

Line 752: pa_fcst_global.Global_project_type_class := l_project_type_class;

748: WHERE pr1.project_id = p_project_id
749: AND pr2.project_type = pr1.project_type
750: AND nvl(pr1.org_id,-99)=nvl(pr2.org_id,-99);
751:
752: pa_fcst_global.Global_project_type_class := l_project_type_class;
753: x_project_type_class := l_project_type_class;
754:
755: BEGIN
756: PA_RATE_PVT_PKG.get_revenue_generation_method(p_project_id=>p_project_id ,

Line 804: pa_fcst_global.Global_proj_fcst_start_date := l_start_date;

800: END LOOP;
801:
802: CLOSE C1;
803:
804: pa_fcst_global.Global_proj_fcst_start_date := l_start_date;
805: pa_fcst_global.Global_proj_fcst_end_date := l_csr_end_date;
806:
807:
808: EXCEPTION

Line 805: pa_fcst_global.Global_proj_fcst_end_date := l_csr_end_date;

801:
802: CLOSE C1;
803:
804: pa_fcst_global.Global_proj_fcst_start_date := l_start_date;
805: pa_fcst_global.Global_proj_fcst_end_date := l_csr_end_date;
806:
807:
808: EXCEPTION
809: WHEN OTHERS THEN

Line 813: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',

809: WHEN OTHERS THEN
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
811: x_msg_count := 1;
812: x_msg_data := SQLERRM;
813: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
814: p_procedure_name => 'Set_Project_GlobalValue');
815:
816: END Set_Project_GlobalValue;
817:

Line 840: FETCH cur_period_set_name INTO pa_fcst_global.Global_Period_Set_Name;

836:
837:
838: BEGIN
839: OPEN cur_period_set_name;
840: FETCH cur_period_set_name INTO pa_fcst_global.Global_Period_Set_Name;
841: CLOSE cur_period_set_name;
842: END SetPeriodSetName;
843:
844:

Line 854: pa_fcst_global.Global_ProjectId := p_project_id;

850: IS
851:
852: BEGIN
853:
854: pa_fcst_global.Global_ProjectId := p_project_id;
855:
856: END Set_Global_Project_Id;
857:
858:

Line 890: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',

886: WHEN OTHERS THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: x_msg_count := 1;
889: x_msg_data := SQLERRM;
890: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FCST_GLOBAL',
891: p_procedure_name => 'Get_Project_Info');
892:
893: END Get_Project_Info;
894:

Line 897: RETURN( pa_fcst_global.Global_Period_Set_Name );

893: END Get_Project_Info;
894:
895: FUNCTION GetPeriodSetName RETURN VARCHAR2 IS
896: BEGIN
897: RETURN( pa_fcst_global.Global_Period_Set_Name );
898: END GetPeriodSetName;
899:
900:
901: FUNCTION GetProjFcstShowAmount RETURN VARCHAR2 IS

Line 903: RETURN (pa_fcst_global.global_proj_fcst_show_amt);

899:
900:
901: FUNCTION GetProjFcstShowAmount RETURN VARCHAR2 IS
902: BEGIN
903: RETURN (pa_fcst_global.global_proj_fcst_show_amt);
904: END GetProjFcstShowAmount;
905:
906:
907: FUNCTION GetProjectId RETURN NUMBER IS

Line 909: RETURN (pa_fcst_global.Global_ProjectId);

905:
906:
907: FUNCTION GetProjectId RETURN NUMBER IS
908: BEGIN
909: RETURN (pa_fcst_global.Global_ProjectId);
910: END GetProjectId;
911:
912: FUNCTION GetProjFcstStartDate RETURN DATE IS
913: BEGIN

Line 943: RETURN pa_fcst_global.Global_project_type;

939: IS
940:
941: BEGIN
942:
943: RETURN pa_fcst_global.Global_project_type;
944:
945: END GetProjType;
946:
947:

Line 954: RETURN pa_fcst_global.Global_project_status;

950: IS
951:
952: BEGIN
953:
954: RETURN pa_fcst_global.Global_project_status;
955:
956: END GetProjStatusCode;
957:
958: FUNCTION GetPageFirstFlag RETURN VARCHAR2

Line 961: RETURN pa_fcst_global.Global_Page_First_Flag;

957:
958: FUNCTION GetPageFirstFlag RETURN VARCHAR2
959: IS
960: BEGIN
961: RETURN pa_fcst_global.Global_Page_First_Flag;
962: END GetPageFirstFlag;
963:
964: FUNCTION GetProjectNumber RETURN VARCHAR2
965: IS

Line 967: RETURN pa_fcst_global.Global_Project_Number;

963:
964: FUNCTION GetProjectNumber RETURN VARCHAR2
965: IS
966: BEGIN
967: RETURN pa_fcst_global.Global_Project_Number;
968: END GetProjectNumber;
969:
970: FUNCTION GetProjectName RETURN VARCHAR2
971: IS

Line 973: RETURN pa_fcst_global.Global_Project_Name;

969:
970: FUNCTION GetProjectName RETURN VARCHAR2
971: IS
972: BEGIN
973: RETURN pa_fcst_global.Global_Project_Name;
974: END GetProjectName;
975:
976: FUNCTION GetProjectOrgId RETURN NUMBER
977: IS

Line 979: RETURN pa_fcst_global.Global_Orgnization_Id;

975:
976: FUNCTION GetProjectOrgId RETURN NUMBER
977: IS
978: BEGIN
979: RETURN pa_fcst_global.Global_Orgnization_Id;
980: END GetProjectOrgId;
981:
982: FUNCTION GetProjectOrgName RETURN VARCHAR2
983: IS

Line 985: RETURN pa_fcst_global.Global_Orgnization_Name;

981:
982: FUNCTION GetProjectOrgName RETURN VARCHAR2
983: IS
984: BEGIN
985: RETURN pa_fcst_global.Global_Orgnization_Name;
986: END GetProjectOrgName;
987:
988: FUNCTION GetProjectStartDate RETURN DATE
989: IS

Line 991: RETURN pa_fcst_global.Global_Project_Start_Date;

987:
988: FUNCTION GetProjectStartDate RETURN DATE
989: IS
990: BEGIN
991: RETURN pa_fcst_global.Global_Project_Start_Date;
992: END GetProjectStartDate;
993:
994:
995: FUNCTION GetProjectStartDateOpt RETURN VARCHAR2

Line 998: RETURN pa_fcst_global.Global_Project_Start_Date_Opt;

994:
995: FUNCTION GetProjectStartDateOpt RETURN VARCHAR2
996: IS
997: BEGIN
998: RETURN pa_fcst_global.Global_Project_Start_Date_Opt;
999: END GetProjectStartDateOpt;
1000:
1001: FUNCTION GetProjectCompDate RETURN DATE
1002: IS

Line 1004: RETURN pa_fcst_global.Global_Project_Comp_Date;

1000:
1001: FUNCTION GetProjectCompDate RETURN DATE
1002: IS
1003: BEGIN
1004: RETURN pa_fcst_global.Global_Project_Comp_Date;
1005: END GetProjectCompDate;
1006:
1007: FUNCTION GetProjectCompDateOpt RETURN VARCHAR2
1008: IS

Line 1010: RETURN pa_fcst_global.Global_Project_Comp_Date_Opt;

1006:
1007: FUNCTION GetProjectCompDateOpt RETURN VARCHAR2
1008: IS
1009: BEGIN
1010: RETURN pa_fcst_global.Global_Project_Comp_Date_Opt;
1011: END GetProjectCompDateOpt;
1012:
1013: FUNCTION GetProjectMangerName RETURN VARCHAR2
1014: IS

Line 1016: RETURN pa_fcst_global.GLobal_Project_Manager_Name;

1012:
1013: FUNCTION GetProjectMangerName RETURN VARCHAR2
1014: IS
1015: BEGIN
1016: RETURN pa_fcst_global.GLobal_Project_Manager_Name;
1017: END GetProjectMangerName;
1018:
1019: FUNCTION GetProjectMangerId RETURN NUMBER
1020: IS

Line 1022: RETURN pa_fcst_global.GLobal_Project_Manager_Id;

1018:
1019: FUNCTION GetProjectMangerId RETURN NUMBER
1020: IS
1021: BEGIN
1022: RETURN pa_fcst_global.GLobal_Project_Manager_Id;
1023: END GetProjectMangerId;
1024:
1025: FUNCTION GetProjectCustomerName RETURN VARCHAR2
1026: IS

Line 1028: RETURN pa_fcst_global.GLobal_Project_Customer_Name;

1024:
1025: FUNCTION GetProjectCustomerName RETURN VARCHAR2
1026: IS
1027: BEGIN
1028: RETURN pa_fcst_global.GLobal_Project_Customer_Name;
1029: END GetProjectCustomerName;
1030:
1031: FUNCTION GetClassCatgory RETURN VARCHAR2
1032: IS

Line 1036: RETURN pa_fcst_global.Global_Class_category;

1032: IS
1033:
1034: BEGIN
1035:
1036: RETURN pa_fcst_global.Global_Class_category;
1037:
1038: END GetClassCatgory;
1039:
1040:

Line 1046: RETURN pa_fcst_global.Global_key_member_id;

1042: IS
1043:
1044: BEGIN
1045:
1046: RETURN pa_fcst_global.Global_key_member_id;
1047:
1048: END GetKeyMemberId;
1049:
1050: FUNCTION GetPlStartDate RETURN DATE

Line 1053: RETURN pa_fcst_global.Global_pl_start_date;

1049:
1050: FUNCTION GetPlStartDate RETURN DATE
1051: IS
1052: BEGIN
1053: RETURN pa_fcst_global.Global_pl_start_date;
1054: END GetPlStartDate;
1055:
1056: FUNCTION GetPlEndDate RETURN DATE
1057: IS

Line 1059: RETURN pa_fcst_global.Global_pl_end_date;

1055:
1056: FUNCTION GetPlEndDate RETURN DATE
1057: IS
1058: BEGIN
1059: RETURN pa_fcst_global.Global_pl_end_date;
1060: END GetPlEndDate;
1061:
1062: FUNCTION GetProjectTypeClass RETURN VARCHAR2
1063: IS

Line 1065: RETURN pa_fcst_global.Global_project_type_class;

1061:
1062: FUNCTION GetProjectTypeClass RETURN VARCHAR2
1063: IS
1064: BEGIN
1065: RETURN pa_fcst_global.Global_project_type_class;
1066: END GetProjectTypeClass;
1067:
1068: FUNCTION find_project_owner(
1069: p_project_id IN NUMBER,

Line 1082: AND prjp.project_role_id = pa_fcst_global.GetKeyMemberId

1078: FROM pa_resources_denorm resd,
1079: pa_project_parties prjp
1080: WHERE resd.person_id = prjp.resource_source_id
1081: AND prjp.project_id = p_project_id
1082: AND prjp.project_role_id = pa_fcst_global.GetKeyMemberId
1083: AND (sysdate between resd.RESOURCE_EFFECTIVE_START_DATE and resd.RESOURCE_EFFECTIVE_END_DATE
1084: OR (p_proj_start_date between resd.RESOURCE_EFFECTIVE_START_DATE and resd.RESOURCE_EFFECTIVE_END_DATE
1085: OR p_proj_end_date between resd.RESOURCE_EFFECTIVE_START_DATE and resd.RESOURCE_EFFECTIVE_END_DATE))
1086: order by resd.resource_name;

Line 1247: END pa_fcst_global;

1243: END IF;
1244: END Populate_Fcst_Periods;
1245: BEGIN
1246: Global_CrossProjectViewUser := SetCrossProjectViewUser;
1247: END pa_fcst_global;