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_GL_CCID_C dependencies on FII_CHANGE_LOG

Line 51: FII_UTIL.Write_Log('Inserting DBI log items into FII_CHANGE_LOG');

47: FII_MESSAGE.Func_Ent('FII_GL_CCID_C.INIT_DBI_CHANGE_LOG');
48: End if;
49:
50: If g_debug_flag = 'Y' then
51: FII_UTIL.Write_Log('Inserting DBI log items into FII_CHANGE_LOG');
52: End if;
53: ---------------------------------------------
54: -- Populate FII_CHANGE_LOG with inital set up
55: -- entries if it hasn't been set up already

Line 54: -- Populate FII_CHANGE_LOG with inital set up

50: If g_debug_flag = 'Y' then
51: FII_UTIL.Write_Log('Inserting DBI log items into FII_CHANGE_LOG');
52: End if;
53: ---------------------------------------------
54: -- Populate FII_CHANGE_LOG with inital set up
55: -- entries if it hasn't been set up already
56: ---------------------------------------------
57: INSERT INTO FII_CHANGE_LOG (
58: log_item,

Line 57: INSERT INTO FII_CHANGE_LOG (

53: ---------------------------------------------
54: -- Populate FII_CHANGE_LOG with inital set up
55: -- entries if it hasn't been set up already
56: ---------------------------------------------
57: INSERT INTO FII_CHANGE_LOG (
58: log_item,
59: item_value,
60: creation_date,
61: created_by,

Line 93: FROM FII_CHANGE_LOG

89: FROM GL_ROW_MULTIPLIERS glrm
90: WHERE glrm.multiplier between 1 and 8
91: AND NOT EXISTS
92: (SELECT 1
93: FROM FII_CHANGE_LOG
94: WHERE log_item = DECODE(glrm.multiplier,
95: 1, 'AR_RESUMMARIZE',
96: 2, 'GL_RESUMMARIZE',
97: 3, 'AP_RESUMMARIZE',

Line 105: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' log items into FII_CHANGE_LOG');

101: 7, 'GL_PROD_CHANGE',
102: 8, 'AR_PROD_CHANGE'));
103:
104: If g_debug_flag = 'Y' then
105: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' log items into FII_CHANGE_LOG');
106: End if;
107:
108: If g_debug_flag = 'Y' then
109: FII_MESSAGE.Func_Succ('FII_GL_CCID_C.INIT_DBI_CHANGE_LOG');

Line 755: g_phase := 'UPDATE fii_change_log';

751: if g_new_max_ccid < l_tmp_max_ccid then
752: g_new_max_ccid := l_tmp_max_ccid;
753: end if;
754:
755: g_phase := 'UPDATE fii_change_log';
756:
757: -- we also update PROD_CAT_SET_ID here
758: UPDATE fii_change_log
759: SET item_value = decode (log_item, 'MAX_CCID', to_char(g_new_max_ccid),

Line 758: UPDATE fii_change_log

754:
755: g_phase := 'UPDATE fii_change_log';
756:
757: -- we also update PROD_CAT_SET_ID here
758: UPDATE fii_change_log
759: SET item_value = decode (log_item, 'MAX_CCID', to_char(g_new_max_ccid),
760: 'PROD_CAT_SET_ID', g_prod_cat_set_id),
761: last_update_date = SYSDATE,
762: last_update_login = g_fii_login_id,

Line 768: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_change_log');

764: WHERE log_item = 'MAX_CCID'
765: OR (log_item = 'PROD_CAT_SET_ID' and g_prod_cat_set_id is not null);
766:
767: If g_debug_flag = 'Y' then
768: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_change_log');
769: End if;
770:
771: If g_debug_flag = 'Y' then
772: FII_UTIL.stop_timer;

Line 815: FROM fii_change_log

811: -- Bug 4152799.
812: g_log_item := 'MAX_CCID';
813:
814: SELECT item_value INTO g_max_ccid
815: FROM fii_change_log
816: WHERE log_item = g_log_item;
817:
818: g_phase := 'Identifying current Max CCID in GL';
819: If g_debug_flag = 'Y' then

Line 930: FROM fii_change_log

926: -- Bug 4152799.
927: g_log_item := 'MAX_CCID';
928:
929: SELECT item_value INTO g_max_ccid
930: FROM fii_change_log
931: WHERE log_item = g_log_item;
932:
933: g_phase := 'Identifying current Max CCID in GL';
934: If g_debug_flag = 'Y' then

Line 962: --Update FII_CHANGE_LOG to reset MAX_CCID

958: --* last_updated_by = g_fii_user_id
959: --* WHERE dimension_short_name = 'ENI_ITEM_VBH_CAT';
960: --------------------------------------------------------------------------
961:
962: --Update FII_CHANGE_LOG to reset MAX_CCID
963:
964: g_phase := 'UPDATE fii_change_log';
965:
966: -- Bug 4152799.

Line 964: g_phase := 'UPDATE fii_change_log';

960: --------------------------------------------------------------------------
961:
962: --Update FII_CHANGE_LOG to reset MAX_CCID
963:
964: g_phase := 'UPDATE fii_change_log';
965:
966: -- Bug 4152799.
967:
968: UPDATE fii_change_log

Line 968: UPDATE fii_change_log

964: g_phase := 'UPDATE fii_change_log';
965:
966: -- Bug 4152799.
967:
968: UPDATE fii_change_log
969: SET item_value = '0',
970: last_update_date = sysdate,
971: last_update_login = g_fii_login_id,
972: last_updated_by = g_fii_user_id

Line 976: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_change_log');

972: last_updated_by = g_fii_user_id
973: WHERE log_item = g_log_item;
974:
975: If g_debug_flag = 'Y' then
976: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_change_log');
977: End if;
978:
979: g_max_ccid := 0;
980:

Line 1159: UPDATE fii_change_log

1155:
1156: -- Bug 4152799.
1157: g_log_item := 'MAX_CCID';
1158:
1159: UPDATE fii_change_log
1160: SET item_value = '0',
1161: last_update_date = sysdate,
1162: last_update_login = g_fii_login_id,
1163: last_updated_by = g_fii_user_id

Line 1735: g_phase:= 'Updating FII_CHANGE_LOG to indicate resummarization is needed';

1731: END LOOP;
1732:
1733: IF (l_resummarization_needed = 'TRUE') THEN
1734:
1735: g_phase:= 'Updating FII_CHANGE_LOG to indicate resummarization is needed';
1736: If g_debug_flag = 'Y' then
1737: FII_UTIL.Write_Log(g_phase);
1738: End if;
1739:

Line 1742: UPDATE FII_CHANGE_LOG

1738: End if;
1739:
1740: --Bug 3234044: should not require AP Resummarization --> remove AP_RESUMMARIZE
1741: --Bug 3401590: use 2 new log items for GL, AR reload (initial)
1742: UPDATE FII_CHANGE_LOG
1743: SET item_value = 'Y',
1744: last_update_date = SYSDATE,
1745: last_update_login = g_fii_login_id,
1746: last_updated_by = g_fii_user_id

Line 1750: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CHANGE_LOG');

1746: last_updated_by = g_fii_user_id
1747: WHERE log_item IN ('AR_PROD_CHANGE', 'GL_PROD_CHANGE');
1748:
1749: If g_debug_flag = 'Y' then
1750: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CHANGE_LOG');
1751: End if;
1752:
1753: g_phase:= 'Updating FII_DIM_MAPPING_RULES to indicate product assignments are now current';
1754: If g_debug_flag = 'Y' then

Line 2013: --processed product category in FII_CHANGE_LOG with the current

2009: end;
2010:
2011: ----------------------------------------------------------------------
2012: --If the program is run in Incremental mode, check the last
2013: --processed product category in FII_CHANGE_LOG with the current
2014: --one G_PROD_CAT_SET_ID from ENI. If they are not same, error out
2015: --with message asking user to either run the program in Initial mode;
2016: --or revert the Product Catalog to the old one.
2017: ----------------------------------------------------------------------

Line 2030: FROM fii_change_log

2026: -- Bug 4152799.
2027: g_log_item := 'PROD_CAT_SET_ID';
2028:
2029: SELECT item_value INTO l_old_prod_cat
2030: FROM fii_change_log
2031: WHERE log_item = g_log_item;
2032: exception
2033: when others then
2034: l_old_prod_cat := NULL;

Line 2167: FROM fii_change_log

2163:
2164: -- Bug 4152799.
2165: g_log_item := 'CCID_RELOAD';
2166: SELECT item_value INTO l_reload
2167: FROM fii_change_log
2168: WHERE log_item = g_log_item;
2169:
2170: IF (l_reload = 'Y') THEN
2171:

Line 2199: UPDATE fii_change_log

2195:
2196: -- Bug 4152799.
2197: g_log_item := 'MAX_CCID';
2198:
2199: UPDATE fii_change_log
2200: SET item_value = '0',
2201: last_update_date = sysdate,
2202: last_update_login = g_fii_login_id,
2203: last_updated_by = g_fii_user_id

Line 2218: UPDATE fii_change_log

2214:
2215: -- Bug 4152799.
2216: g_log_item := 'CCID_RELOAD';
2217:
2218: UPDATE fii_change_log
2219: SET item_value = 'N',
2220: last_update_date = sysdate,
2221: last_update_login = g_fii_login_id,
2222: last_updated_by = g_fii_user_id

Line 2293: -- Inserting the basic items into FII_CHANGE_LOG if

2289: ---------------------------------------------------
2290: FII_UTIL.TRUNCATE_TABLE ('FII_GL_CCID_PROD_INT', g_fii_schema, g_retcode);
2291:
2292: ---------------------------------------------------
2293: -- Inserting the basic items into FII_CHANGE_LOG if
2294: -- they have not been inserted
2295: ---------------------------------------------------
2296: g_phase := 'Call INIT_DBI_CHANGE_LOG';
2297:

Line 2358: g_phase := 'UPDATE fii_change_log';

2354: -- Set CCID_RELOAD flag to 'N' after an initial load
2355: -- Bug 3401590
2356: ----------------------------------------------------
2357: if (g_mode = 'L') then
2358: g_phase := 'UPDATE fii_change_log';
2359:
2360: -- Bug 4152799.
2361: g_log_item := 'CCID_RELOAD';
2362:

Line 2363: UPDATE fii_change_log

2359:
2360: -- Bug 4152799.
2361: g_log_item := 'CCID_RELOAD';
2362:
2363: UPDATE fii_change_log
2364: SET item_value = 'N',
2365: last_update_date = sysdate,
2366: last_update_login = g_fii_login_id,
2367: last_updated_by = g_fii_user_id

Line 2372: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_change_log');

2368: WHERE log_item = g_log_item
2369: AND item_value = 'Y';
2370:
2371: If g_debug_flag = 'Y' then
2372: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_change_log');
2373: End if;
2374:
2375: end if;
2376: