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_FORECAST_GRC_PVT dependencies on PA_REP_UTIL_GLOB

Line 258: -- l_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;

254: l_exp_orgz_id NUMBER;
255: l_person_id NUMBER;
256: l_balance_type_code VARCHAR2(30);
257: l_period_type VARCHAR2(30);
258: -- l_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
259: l_gl_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019
260: l_pa_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- bug 3434019
261: l_period_name VARCHAR2(30);
262: l_GE_end_date DATE;

Line 259: l_gl_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019

255: l_person_id NUMBER;
256: l_balance_type_code VARCHAR2(30);
257: l_period_type VARCHAR2(30);
258: -- l_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
259: l_gl_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019
260: l_pa_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- bug 3434019
261: l_period_name VARCHAR2(30);
262: l_GE_end_date DATE;
263: l_resource_capacity NUMBER;

Line 260: l_pa_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- bug 3434019

256: l_balance_type_code VARCHAR2(30);
257: l_period_type VARCHAR2(30);
258: -- l_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
259: l_gl_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- bug 3434019
260: l_pa_period_set_name VARCHAR2(30):=PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- bug 3434019
261: l_period_name VARCHAR2(30);
262: l_GE_end_date DATE;
263: l_resource_capacity NUMBER;
264: l_period_balance NUMBER;

Line 270: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;

266: l_msg_count NUMBER;
267: l_msg_data VARCHAR2(80);
268: i NUMBER;
269:
270: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
271: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
272: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
273: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
274: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;

Line 271: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;

267: l_msg_data VARCHAR2(80);
268: i NUMBER;
269:
270: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
271: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
272: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
273: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
274: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
275:

Line 272: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;

268: i NUMBER;
269:
270: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
271: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
272: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
273: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
274: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
275:
276: -- l_global_week_start_day PLS_INTEGER := pa_rep_util_glob.G_global_week_start_day;

Line 273: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;

269:
270: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
271: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
272: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
273: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
274: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
275:
276: -- l_global_week_start_day PLS_INTEGER := pa_rep_util_glob.G_global_week_start_day;
277:

Line 274: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;

270: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
271: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
272: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
273: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
274: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
275:
276: -- l_global_week_start_day PLS_INTEGER := pa_rep_util_glob.G_global_week_start_day;
277:
278: j NUMBER := 0;

Line 276: -- l_global_week_start_day PLS_INTEGER := pa_rep_util_glob.G_global_week_start_day;

272: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
273: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
274: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
275:
276: -- l_global_week_start_day PLS_INTEGER := pa_rep_util_glob.G_global_week_start_day;
277:
278: j NUMBER := 0;
279: jj NUMBER := 0;
280:

Line 435: and bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C

431: from pa_objects obj,
432: pa_summ_balances bal
433: where obj.object_id = bal.object_id
434: and bal.version_id = -1
435: and bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
436: and bal.period_type = l_pa_period_type
437: -- and bal.period_set_name = l_period_set_name
438: and bal.period_set_name = l_pa_period_set_name -- bug 3434019
439: and bal.period_name = pa_periods_cur_rec.PERIOD_NAME

Line 440: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C

436: and bal.period_type = l_pa_period_type
437: -- and bal.period_set_name = l_period_set_name
438: and bal.period_set_name = l_pa_period_set_name -- bug 3434019
439: and bal.period_name = pa_periods_cur_rec.PERIOD_NAME
440: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
441: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
442: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
443: and obj.balance_type_code = l_balance_type_code
444: and obj.project_org_id = -1

Line 441: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id

437: -- and bal.period_set_name = l_period_set_name
438: and bal.period_set_name = l_pa_period_set_name -- bug 3434019
439: and bal.period_name = pa_periods_cur_rec.PERIOD_NAME
440: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
441: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
442: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
443: and obj.balance_type_code = l_balance_type_code
444: and obj.project_org_id = -1
445: and obj.project_organization_id = -1

Line 442: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C

438: and bal.period_set_name = l_pa_period_set_name -- bug 3434019
439: and bal.period_name = pa_periods_cur_rec.PERIOD_NAME
440: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
441: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
442: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
443: and obj.balance_type_code = l_balance_type_code
444: and obj.project_org_id = -1
445: and obj.project_organization_id = -1
446: and obj.project_id = -1

Line 466: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C;

462:
463: x_resource_capacity_tab(j) := l_resource_capacity - l_period_balance;
464: x_exp_orgz_id_tab(j) := l_exp_orgz_id;
465: x_person_id_tab(j) := l_person_id;
466: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C;
467: x_period_name_tab(j) := pa_periods_cur_rec.PERIOD_NAME;
468: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;
469: x_period_year_tab(j) := pa_periods_cur_rec.PERIOD_YEAR;
470: x_qm_number_tab(j) := pa_periods_cur_rec.PERIOD_QUARTER;

Line 468: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;

464: x_exp_orgz_id_tab(j) := l_exp_orgz_id;
465: x_person_id_tab(j) := l_person_id;
466: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C;
467: x_period_name_tab(j) := pa_periods_cur_rec.PERIOD_NAME;
468: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;
469: x_period_year_tab(j) := pa_periods_cur_rec.PERIOD_YEAR;
470: x_qm_number_tab(j) := pa_periods_cur_rec.PERIOD_QUARTER;
471: x_period_num_tab(j) := pa_periods_cur_rec.PERIOD_NUM;
472:

Line 529: and bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C

525: from pa_objects obj,
526: pa_summ_balances bal
527: where obj.object_id = bal.object_id
528: and bal.version_id = -1
529: and bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
530: and bal.period_type = l_gl_period_type
531: -- and bal.period_set_name = l_period_set_name
532: and bal.period_set_name = l_gl_period_set_name -- bug 3434019
533: and bal.period_name = gl_periods_cur_rec.PERIOD_NAME

Line 534: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C

530: and bal.period_type = l_gl_period_type
531: -- and bal.period_set_name = l_period_set_name
532: and bal.period_set_name = l_gl_period_set_name -- bug 3434019
533: and bal.period_name = gl_periods_cur_rec.PERIOD_NAME
534: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
535: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
536: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
537: and obj.balance_type_code = l_balance_type_code
538: and obj.project_org_id = -1

Line 535: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id

531: -- and bal.period_set_name = l_period_set_name
532: and bal.period_set_name = l_gl_period_set_name -- bug 3434019
533: and bal.period_name = gl_periods_cur_rec.PERIOD_NAME
534: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
535: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
536: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
537: and obj.balance_type_code = l_balance_type_code
538: and obj.project_org_id = -1
539: and obj.project_organization_id = -1

Line 536: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C

532: and bal.period_set_name = l_gl_period_set_name -- bug 3434019
533: and bal.period_name = gl_periods_cur_rec.PERIOD_NAME
534: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
535: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
536: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
537: and obj.balance_type_code = l_balance_type_code
538: and obj.project_org_id = -1
539: and obj.project_organization_id = -1
540: and obj.project_id = -1

Line 560: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;

556:
557: x_resource_capacity_tab(j) := l_resource_capacity - l_period_balance;
558: x_exp_orgz_id_tab(j) := l_exp_orgz_id;
559: x_person_id_tab(j) := l_person_id;
560: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;
561: x_period_name_tab(j) := gl_periods_cur_rec.PERIOD_NAME;
562: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;
563: x_period_year_tab(j) := gl_periods_cur_rec.PERIOD_YEAR;
564: x_qm_number_tab(j) := gl_periods_cur_rec.PERIOD_QUARTER;

Line 562: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;

558: x_exp_orgz_id_tab(j) := l_exp_orgz_id;
559: x_person_id_tab(j) := l_person_id;
560: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;
561: x_period_name_tab(j) := gl_periods_cur_rec.PERIOD_NAME;
562: x_global_exp_date_tab(j) := PA_REP_UTIL_GLOB.GetDummyDate;
563: x_period_year_tab(j) := gl_periods_cur_rec.PERIOD_YEAR;
564: x_qm_number_tab(j) := gl_periods_cur_rec.PERIOD_QUARTER;
565: x_period_num_tab(j) := gl_periods_cur_rec.PERIOD_NUM;
566:

Line 624: and bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C

620: from pa_objects obj,
621: pa_summ_balances bal
622: where obj.object_id = bal.object_id
623: and bal.version_id = -1
624: and bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
625: and bal.period_type = 'GE'
626: -- and bal.period_set_name = l_period_set_name
627: and bal.period_set_name = PA_REP_UTIL_GLOB.G_DUMMY_C --bug 3434019
628: and bal.period_name = PA_REP_UTIL_GLOB.G_DUMMY_C

Line 627: and bal.period_set_name = PA_REP_UTIL_GLOB.G_DUMMY_C --bug 3434019

623: and bal.version_id = -1
624: and bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
625: and bal.period_type = 'GE'
626: -- and bal.period_set_name = l_period_set_name
627: and bal.period_set_name = PA_REP_UTIL_GLOB.G_DUMMY_C --bug 3434019
628: and bal.period_name = PA_REP_UTIL_GLOB.G_DUMMY_C
629: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
630: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
631: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C

Line 628: and bal.period_name = PA_REP_UTIL_GLOB.G_DUMMY_C

624: and bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
625: and bal.period_type = 'GE'
626: -- and bal.period_set_name = l_period_set_name
627: and bal.period_set_name = PA_REP_UTIL_GLOB.G_DUMMY_C --bug 3434019
628: and bal.period_name = PA_REP_UTIL_GLOB.G_DUMMY_C
629: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
630: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
631: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
632: and obj.balance_type_code = l_balance_type_code

Line 629: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C

625: and bal.period_type = 'GE'
626: -- and bal.period_set_name = l_period_set_name
627: and bal.period_set_name = PA_REP_UTIL_GLOB.G_DUMMY_C --bug 3434019
628: and bal.period_name = PA_REP_UTIL_GLOB.G_DUMMY_C
629: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
630: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
631: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
632: and obj.balance_type_code = l_balance_type_code
633: and obj.project_org_id = -1

Line 630: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id

626: -- and bal.period_set_name = l_period_set_name
627: and bal.period_set_name = PA_REP_UTIL_GLOB.G_DUMMY_C --bug 3434019
628: and bal.period_name = PA_REP_UTIL_GLOB.G_DUMMY_C
629: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
630: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
631: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
632: and obj.balance_type_code = l_balance_type_code
633: and obj.project_org_id = -1
634: and obj.project_organization_id = -1

Line 631: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C

627: and bal.period_set_name = PA_REP_UTIL_GLOB.G_DUMMY_C --bug 3434019
628: and bal.period_name = PA_REP_UTIL_GLOB.G_DUMMY_C
629: and bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
630: and bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
631: and obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
632: and obj.balance_type_code = l_balance_type_code
633: and obj.project_org_id = -1
634: and obj.project_organization_id = -1
635: and obj.project_id = -1

Line 655: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GE_C;

651:
652: x_resource_capacity_tab(j) := l_resource_capacity - l_period_balance;
653: x_exp_orgz_id_tab(j) := l_exp_orgz_id;
654: x_person_id_tab(j) := l_person_id;
655: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GE_C;
656: x_period_name_tab(j) := PA_REP_UTIL_GLOB.G_DUMMY_C;
657: x_global_exp_date_tab(j) := ge_periods_cur_rec.GE_DATE;
658: x_period_year_tab(j) := ge_periods_cur_rec.PERIOD_YEAR;
659: x_qm_number_tab(j) := ge_periods_cur_rec.PERIOD_MONTH;

Line 656: x_period_name_tab(j) := PA_REP_UTIL_GLOB.G_DUMMY_C;

652: x_resource_capacity_tab(j) := l_resource_capacity - l_period_balance;
653: x_exp_orgz_id_tab(j) := l_exp_orgz_id;
654: x_person_id_tab(j) := l_person_id;
655: x_period_type_tab(j) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GE_C;
656: x_period_name_tab(j) := PA_REP_UTIL_GLOB.G_DUMMY_C;
657: x_global_exp_date_tab(j) := ge_periods_cur_rec.GE_DATE;
658: x_period_year_tab(j) := ge_periods_cur_rec.PERIOD_YEAR;
659: x_qm_number_tab(j) := ge_periods_cur_rec.PERIOD_MONTH;
660: x_period_num_tab(j) := -1;