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

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

37: FII_MESSAGE.Func_Ent(l_calling_fn);
38: End if;
39:
40: If g_debug_flag = 'Y' then
41: FII_UTIL.Write_Log('Inserting DBI log items into FII_CHANGE_LOG');
42: End if;
43:
44: ---------------------------------------------
45: -- Populate FII_CHANGE_LOG with inital set up

Line 45: -- Populate FII_CHANGE_LOG with inital set up

41: FII_UTIL.Write_Log('Inserting DBI log items into FII_CHANGE_LOG');
42: End if;
43:
44: ---------------------------------------------
45: -- Populate FII_CHANGE_LOG with inital set up
46: -- entries if it hasn't been set up already
47: ---------------------------------------------
48: INSERT INTO FII_CHANGE_LOG (
49: log_item,

Line 48: INSERT INTO FII_CHANGE_LOG (

44: ---------------------------------------------
45: -- Populate FII_CHANGE_LOG with inital set up
46: -- entries if it hasn't been set up already
47: ---------------------------------------------
48: INSERT INTO FII_CHANGE_LOG (
49: log_item,
50: item_value,
51: creation_date,
52: created_by,

Line 66: FROM FII_CHANGE_LOG

62: g_fii_user_id
63: FROM DUAL
64: WHERE NOT EXISTS
65: (SELECT 1
66: FROM FII_CHANGE_LOG
67: WHERE log_item = 'MAX_ASSET_CAT_ID');
68:
69: If g_debug_flag = 'Y' then
70: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' log items into FII_CHANGE_LOG');

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

66: FROM FII_CHANGE_LOG
67: WHERE log_item = 'MAX_ASSET_CAT_ID');
68:
69: If g_debug_flag = 'Y' then
70: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' log items into FII_CHANGE_LOG');
71: End if;
72:
73: If g_debug_flag = 'Y' then
74: FII_MESSAGE.Func_Succ(l_calling_fn);

Line 813: g_phase := 'UPDATE fii_change_log';

809: if g_new_max_cat_id < l_tmp_max_cat_id then
810: g_new_max_cat_id := l_tmp_max_cat_id;
811: end if;
812:
813: g_phase := 'UPDATE fii_change_log';
814:
815: -- we also update PROD_CAT_SET_ID here
816: UPDATE fii_change_log
817: SET item_value = to_char(g_new_max_cat_id),

Line 816: UPDATE fii_change_log

812:
813: g_phase := 'UPDATE fii_change_log';
814:
815: -- we also update PROD_CAT_SET_ID here
816: UPDATE fii_change_log
817: SET item_value = to_char(g_new_max_cat_id),
818: last_update_date = SYSDATE,
819: last_update_login = g_fii_login_id,
820: last_updated_by = g_fii_user_id

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

820: last_updated_by = g_fii_user_id
821: WHERE log_item = 'MAX_ASSET_CAT_ID';
822:
823: If g_debug_flag = 'Y' then
824: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_change_log');
825: End if;
826:
827: If g_debug_flag = 'Y' then
828: FII_UTIL.stop_timer;

Line 873: FROM fii_change_log

869: End if;
870:
871: SELECT item_value
872: INTO g_max_cat_id
873: FROM fii_change_log
874: WHERE log_item = 'MAX_ASSET_CAT_ID';
875:
876: If g_debug_flag = 'Y' then
877: FII_UTIL.Write_Log(l_calling_fn || ': g_max_cat_id: ' || to_char(g_max_cat_id));

Line 956: FROM fii_change_log

952: End if;
953:
954: SELECT item_value
955: INTO g_max_cat_id
956: FROM fii_change_log
957: WHERE log_item = 'MAX_ASSET_CAT_ID';
958:
959: If g_debug_flag = 'Y' then
960: FII_UTIL.Write_Log(l_calling_fn || ': g_max_cat_id: ' || to_char(g_max_cat_id));

Line 981: --Update FII_CHANGE_LOG to reset MAX_CAT_ID

977: g_phase := 'TRUNCATE FII_FA_CAT_DIMENSIONS';
978:
979: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_DIMENSIONS',g_fii_schema,g_retcode);
980:
981: --Update FII_CHANGE_LOG to reset MAX_CAT_ID
982:
983: g_phase := 'UPDATE fii_change_log';
984:
985: UPDATE fii_change_log

Line 983: g_phase := 'UPDATE fii_change_log';

979: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_DIMENSIONS',g_fii_schema,g_retcode);
980:
981: --Update FII_CHANGE_LOG to reset MAX_CAT_ID
982:
983: g_phase := 'UPDATE fii_change_log';
984:
985: UPDATE fii_change_log
986: SET item_value = '0',
987: last_update_date = sysdate,

Line 985: UPDATE fii_change_log

981: --Update FII_CHANGE_LOG to reset MAX_CAT_ID
982:
983: g_phase := 'UPDATE fii_change_log';
984:
985: UPDATE fii_change_log
986: SET item_value = '0',
987: last_update_date = sysdate,
988: last_update_login = g_fii_login_id,
989: last_updated_by = g_fii_user_id

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

989: last_updated_by = g_fii_user_id
990: WHERE log_item = 'MAX_ASSET_CAT_ID';
991:
992: If g_debug_flag = 'Y' then
993: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_change_log');
994: End if;
995:
996: g_max_cat_id := 0;
997:

Line 1100: UPDATE fii_change_log

1096: --program is run in Initial Load mode, truncate the table and reset LOG
1097:
1098: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_DIMENSIONS',g_fii_schema,g_retcode);
1099:
1100: UPDATE fii_change_log
1101: SET item_value = '0',
1102: last_update_date = sysdate,
1103: last_update_login = g_fii_login_id,
1104: last_updated_by = g_fii_user_id

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

1298: ---------------------------------------------------
1299: -- FII_UTIL.TRUNCATE_TABLE ('FII_FA_CAT_PROD_INT', g_fii_schema, g_retcode);
1300:
1301: ---------------------------------------------------
1302: -- Inserting the basic items into FII_CHANGE_LOG if
1303: -- they have not been inserted
1304: ---------------------------------------------------
1305: g_phase := 'Call INIT_DBI_CHANGE_LOG';
1306:

Line 1358: -- removing the update for reload item in fii_change_log

1354: -- Bug 3401590
1355: --
1356: -- Since FA doesn't allow for multiple flex structures
1357: -- and because the setup shouldn't be changed, we are
1358: -- removing the update for reload item in fii_change_log
1359: -- See GLCCID if ever this is deemed required
1360: ----------------------------------------------------
1361:
1362: ---------------------------------------------------