APPS.FII_AR_REVENUE_B_C dependencies on FII_GLOBAL_START_DATES

Line 3697: -- Update table FII_GLOBAL_START_DATES if necessary:

3693: END CHECK_GLOBAL_VARIABLES;
3694:
3695: -----------------------------------------------------------
3696: -- FUNCTION UPDATE_GLOBAL_START_DATE_TBL
3697: -- Update table FII_GLOBAL_START_DATES if necessary:
3698: -- 1. The table does not have exactly one row
3699: -- OR
3700: -- 2. The table has exactly one row,
3701: -- but it is different from p_glbl_strt_dt

Line 3711: from FII_GLOBAL_START_DATES;

3707: BEGIN
3708: l_updated := 0;
3709:
3710: select count(*) into l_count
3711: from FII_GLOBAL_START_DATES;
3712:
3713: if l_count = 1 then
3714: select GLOBAL_START_DATE into l_glbl_strt_dt
3715: from FII_GLOBAL_START_DATES;

Line 3715: from FII_GLOBAL_START_DATES;

3711: from FII_GLOBAL_START_DATES;
3712:
3713: if l_count = 1 then
3714: select GLOBAL_START_DATE into l_glbl_strt_dt
3715: from FII_GLOBAL_START_DATES;
3716:
3717: if l_glbl_strt_dt <> p_glbl_strt_dt then
3718: update FII_GLOBAL_START_DATES
3719: set GLOBAL_START_DATE = p_glbl_strt_dt,

Line 3718: update FII_GLOBAL_START_DATES

3714: select GLOBAL_START_DATE into l_glbl_strt_dt
3715: from FII_GLOBAL_START_DATES;
3716:
3717: if l_glbl_strt_dt <> p_glbl_strt_dt then
3718: update FII_GLOBAL_START_DATES
3719: set GLOBAL_START_DATE = p_glbl_strt_dt,
3720: LAST_UPDATE_DATE = sysdate,
3721: LAST_UPDATED_BY = g_fii_user_id,
3722: LAST_UPDATE_LOGIN = g_fii_login_id;

Line 3728: TRUNCATE_TABLE('FII_GLOBAL_START_DATES');

3724: l_updated := 1;
3725: end if;
3726: else
3727: if l_count > 1 then
3728: TRUNCATE_TABLE('FII_GLOBAL_START_DATES');
3729: end if;
3730:
3731: insert into FII_GLOBAL_START_DATES(
3732: GLOBAL_START_DATE,

Line 3731: insert into FII_GLOBAL_START_DATES(

3727: if l_count > 1 then
3728: TRUNCATE_TABLE('FII_GLOBAL_START_DATES');
3729: end if;
3730:
3731: insert into FII_GLOBAL_START_DATES(
3732: GLOBAL_START_DATE,
3733: CREATION_DATE, CREATED_BY,
3734: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
3735: )

Line 3937: tabname => 'FII_GLOBAL_START_DATES');

3933: sysdate + 7 ) ) + 1 - ONE_SECOND;
3934:
3935: l_count := UPDATE_GLOBAL_START_DATE_TBL( g_gl_from_date );
3936: FND_STATS.gather_table_stats (ownname => g_fii_schema,
3937: tabname => 'FII_GLOBAL_START_DATES');
3938:
3939: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
3940:
3941: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');