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_GENERATE_FORECAST_PUB dependencies on PA_FORECAST_GLOBAL

Line 84: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;

80: FROM PA_BUDGET_VERSIONS
81: WHERE PROJECT_ID = p_project_id AND
82: BUDGET_TYPE_CODE = 'FORECASTING_BUDGET_TYPE';
83: l_ret_status VARCHAR2(100);
84: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
85: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
86: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
87: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
88: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;

Line 85: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;

81: WHERE PROJECT_ID = p_project_id AND
82: BUDGET_TYPE_CODE = 'FORECASTING_BUDGET_TYPE';
83: l_ret_status VARCHAR2(100);
84: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
85: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
86: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
87: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
88: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
89: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;

Line 86: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;

82: BUDGET_TYPE_CODE = 'FORECASTING_BUDGET_TYPE';
83: l_ret_status VARCHAR2(100);
84: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
85: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
86: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
87: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
88: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
89: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
90:

Line 87: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;

83: l_ret_status VARCHAR2(100);
84: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
85: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
86: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
87: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
88: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
89: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
90:
91: l_fcst_def_bem PA_BUDGET_VERSIONS.BUDGET_ENTRY_METHOD_CODE%TYPE;

Line 88: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;

84: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
85: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
86: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
87: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
88: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
89: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
90:
91: l_fcst_def_bem PA_BUDGET_VERSIONS.BUDGET_ENTRY_METHOD_CODE%TYPE;
92: l_fcst_res_list PA_RESOURCE_LISTS_ALL_BG.RESOURCE_LIST_ID%TYPE;

Line 89: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;

85: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
86: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
87: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
88: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
89: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
90:
91: l_fcst_def_bem PA_BUDGET_VERSIONS.BUDGET_ENTRY_METHOD_CODE%TYPE;
92: l_fcst_res_list PA_RESOURCE_LISTS_ALL_BG.RESOURCE_LIST_ID%TYPE;
93: l_fcst_period_type VARCHAR2(30);

Line 107: PA_FORECAST_GLOBAL.Initialize_Global(

103: BEGIN
104: PA_DEBUG.set_err_stack('Maintain_Budget_Version');
105: l_ret_status := FND_API.G_RET_STS_SUCCESS;
106:
107: PA_FORECAST_GLOBAL.Initialize_Global(
108: x_msg_count => x_msg_count,
109: x_msg_data => l_msg_data,
110: x_ret_status => l_ret_status );
111: -- l_msg_count := x_msg_count;

Line 128: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;

124: PA_DEBUG.reset_err_stack;
125: RETURN;
126: END IF;
127:
128: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;
129: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;
130: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
131:
132: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;

Line 129: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;

125: RETURN;
126: END IF;
127:
128: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;
129: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;
130: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
131:
132: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
133: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;

Line 130: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;

126: END IF;
127:
128: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;
129: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;
130: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
131:
132: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
133: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
134: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;

Line 132: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;

128: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;
129: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;
130: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
131:
132: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
133: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
134: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
135: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
136: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;

Line 133: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;

129: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;
130: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
131:
132: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
133: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
134: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
135: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
136: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
137: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;

Line 134: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;

130: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
131:
132: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
133: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
134: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
135: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
136: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
137: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
138:

Line 135: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;

131:
132: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
133: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
134: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
135: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
136: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
137: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
138:
139: OPEN BUDGET_VERSION;

Line 136: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;

132: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
133: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
134: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
135: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
136: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
137: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
138:
139: OPEN BUDGET_VERSION;
140: FETCH BUDGET_VERSION INTO

Line 137: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;

133: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
134: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
135: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
136: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
137: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
138:
139: OPEN BUDGET_VERSION;
140: FETCH BUDGET_VERSION INTO
141: x_budget_version_id,

Line 532: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;

528: l_rowid ROWID;
529: l_counter NUMBER := 1 ;
530: l_cost_cnt NUMBER := 1 ;
531:
532: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
533: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
534: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
535: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
536: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;

Line 533: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;

529: l_counter NUMBER := 1 ;
530: l_cost_cnt NUMBER := 1 ;
531:
532: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
533: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
534: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
535: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
536: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
537: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;

Line 534: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;

530: l_cost_cnt NUMBER := 1 ;
531:
532: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
533: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
534: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
535: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
536: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
537: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
538:

Line 535: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;

531:
532: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
533: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
534: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
535: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
536: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
537: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
538:
539: l_period_name_flag varchar2(1);

Line 536: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;

532: l_created_by NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
533: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
534: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
535: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
536: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
537: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
538:
539: l_period_name_flag varchar2(1);
540: l_period_name_tot_flag varchar2(1);

Line 537: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;

533: l_request_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
534: l_program_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
535: l_program_application_id NUMBER(15) := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
536: l_creation_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
537: l_program_update_date DATE := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
538:
539: l_period_name_flag varchar2(1);
540: l_period_name_tot_flag varchar2(1);
541: l_current_index PLS_INTEGER;

Line 633: PA_FORECAST_GLOBAL.Initialize_Global(

629: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
630: l_commit_size := l_commit_size + 1;
631:
632: BEGIN
633: PA_FORECAST_GLOBAL.Initialize_Global(
634: x_msg_count => x_msg_count,
635: x_msg_data => x_msg_data,
636: x_ret_status => x_return_status);
637: EXCEPTION

Line 662: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;

658: RETURN;
659: END IF;
660:
661:
662: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;
663: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;
664: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
665: l_fcst_opt_jobcostrate_sch_id:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_cost_rate_sch_id;
666:

Line 663: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;

659: END IF;
660:
661:
662: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;
663: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;
664: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
665: l_fcst_opt_jobcostrate_sch_id:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_cost_rate_sch_id;
666:
667:

Line 664: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;

660:
661:
662: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;
663: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;
664: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
665: l_fcst_opt_jobcostrate_sch_id:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_cost_rate_sch_id;
666:
667:
668: PA_DEBUG.g_err_stage := '205: Project ID :'||p_project_id;

Line 665: l_fcst_opt_jobcostrate_sch_id:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_cost_rate_sch_id;

661:
662: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;
663: l_fcst_res_list:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_res_list;
664: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
665: l_fcst_opt_jobcostrate_sch_id:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_cost_rate_sch_id;
666:
667:
668: PA_DEBUG.g_err_stage := '205: Project ID :'||p_project_id;
669: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 677: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;

673: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
674: PA_DEBUG.g_err_stage := '230: Forecasting Period Type :'||l_fcst_period_type;
675: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
676:
677: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
678: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
679: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
680: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
681: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;

Line 678: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;

674: PA_DEBUG.g_err_stage := '230: Forecasting Period Type :'||l_fcst_period_type;
675: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
676:
677: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
678: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
679: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
680: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
681: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
682: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;

Line 679: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;

675: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
676:
677: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
678: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
679: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
680: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
681: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
682: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
683: PA_DEBUG.g_err_stage := '300: before fetching project cursor';

Line 680: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;

676:
677: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
678: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
679: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
680: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
681: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
682: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
683: PA_DEBUG.g_err_stage := '300: before fetching project cursor';
684: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 681: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;

677: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
678: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
679: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
680: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
681: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
682: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
683: PA_DEBUG.g_err_stage := '300: before fetching project cursor';
684: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
685: /* l_role_error_code_flag is used here for only checking whether to

Line 682: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;

678: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
679: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
680: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
681: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
682: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
683: PA_DEBUG.g_err_stage := '300: before fetching project cursor';
684: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
685: /* l_role_error_code_flag is used here for only checking whether to
686: continue with forecasting process or not */