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.FII_SETUP_VAL_C dependencies on GL_PERIODS

Line 455: from gl_periods

451: l_lookup_type VARCHAR2(30);
452:
453: CURSOR ent_period_cur (day date) IS
454: select 1
455: from gl_periods
456: where adjustment_period_flag = 'N'
457: and period_set_name = l_period_set_name
458: and period_type = l_period_type
459: and day between start_date and end_date;

Line 463: from gl_periods a

459: and day between start_date and end_date;
460:
461: CURSOR fiscal_year_cur (year number) IS
462: select min(a.start_date), max(end_date)
463: from gl_periods a
464: where a.period_set_name = l_period_set_name
465: and a.period_type = l_period_type
466: and a.adjustment_period_flag = 'N'
467: and a.period_year = year;

Line 977: -- Check for GL Periods:

973: ----------------------------------------------------------------------
974: -- Generic Setup Validations
975: ----------------------------------------------------------------------
976: ----------------------------------------------------------------------
977: -- Check for GL Periods:
978: -- 1. Make sure one year before Global Start Date to sysdate have all
979: -- defined in Enterprise Calendar.
980: ----------------------------------------------------------------------
981: fii_util.put_line(' ');

Line 984: fii_util.put_line('Performing Check for: GL Periods');

980: ----------------------------------------------------------------------
981: fii_util.put_line(' ');
982: fii_util.put_line(
983: '+---------------------------------------------------------------------+');
984: fii_util.put_line('Performing Check for: GL Periods');
985: fii_util.put_line(
986: '+---------------------------------------------------------------------+');
987: fii_util.put_line(
988: 'START CHECK: Looking for GL Periods not defined within start and end range.');

Line 988: 'START CHECK: Looking for GL Periods not defined within start and end range.');

984: fii_util.put_line('Performing Check for: GL Periods');
985: fii_util.put_line(
986: '+---------------------------------------------------------------------+');
987: fii_util.put_line(
988: 'START CHECK: Looking for GL Periods not defined within start and end range.');
989: fii_util.put_line(' ');
990:
991: l_day := to_date(l_global_start_date, 'MM/DD/YYYY');
992: l_cnt := 0;

Line 998: FROM gl_periods a

994: BEGIN
995: -- Find out the period year of the global start date
996: SELECT period_year
997: INTO l_year
998: FROM gl_periods a
999: WHERE a.period_set_name = l_period_set_name
1000: AND a.period_type = l_period_type
1001: AND a.adjustment_period_flag = 'N'
1002: AND l_day between a.start_date and a.end_date;

Line 1013: FROM gl_periods

1009:
1010: BEGIN
1011: SELECT start_date
1012: INTO l_day
1013: FROM gl_periods
1014: WHERE period_set_name = l_period_set_name
1015: AND period_type = l_period_type
1016: AND period_num = 1
1017: AND period_year = l_year - 1;

Line 1053: fii_util.put_line('All GL Periods between '||to_char(l_start_day, 'DD/MM/YYYY') ||

1049: fii_util.put_line(' ');
1050: IF (l_cnt = 0) THEN
1051: -- All days between one year prior to global start date and sysdate have
1052: -- been defined in the Enterprise Calendar
1053: fii_util.put_line('All GL Periods between '||to_char(l_start_day, 'DD/MM/YYYY') ||
1054: ' and '||to_char(l_sys_date, 'DD/MM/YYYY') ||
1055: ' have been defined. ');
1056: fii_util.put_line('DIAGNOSIS: GL Periods are valid');
1057: fii_util.put_line('DIAGNOSIS: NO ACTION is needed.');

Line 1056: fii_util.put_line('DIAGNOSIS: GL Periods are valid');

1052: -- been defined in the Enterprise Calendar
1053: fii_util.put_line('All GL Periods between '||to_char(l_start_day, 'DD/MM/YYYY') ||
1054: ' and '||to_char(l_sys_date, 'DD/MM/YYYY') ||
1055: ' have been defined. ');
1056: fii_util.put_line('DIAGNOSIS: GL Periods are valid');
1057: fii_util.put_line('DIAGNOSIS: NO ACTION is needed.');
1058:
1059: ELSE
1060: -- Print a message asking customer to define missing dates found

Line 1066: fii_util.put_line('END CHECK: Looking for GL Periods not defined.');

1062: 'DIAGNOSIS: Please define the above dates in your Enterprise Calendar.');
1063: END IF;
1064:
1065: fii_util.put_line(' ');
1066: fii_util.put_line('END CHECK: Looking for GL Periods not defined.');
1067: fii_util.put_line(
1068: '+---------------------------------------------------------------------+');
1069:
1070: ----------------------------------------------------------------------

Line 1071: -- Check for GL Periods:

1067: fii_util.put_line(
1068: '+---------------------------------------------------------------------+');
1069:
1070: ----------------------------------------------------------------------
1071: -- Check for GL Periods:
1072: -- 2. Also check that Fiscal Year are defined correctly
1073: ----------------------------------------------------------------------
1074: fii_util.put_line(
1075: 'START CHECK: Fiscal Year contains valid number of weeks.');

Line 1083: FROM gl_periods

1079: BEGIN
1080:
1081: SELECT year_start_date
1082: INTO l_min_start_date
1083: FROM gl_periods
1084: WHERE period_set_name = l_period_set_name
1085: AND period_type = l_period_type
1086: AND period_year = l_year - 1
1087: AND period_num = 1