APPS.FII_AR_REVENUE_B_C dependencies on FII_CHANGE_LOG

Line 1755: from FII_CHANGE_LOG

1751:
1752: l_lud_to := to_char(g_lud_to_date,'YYYY/MM/DD HH24:MI:SS');
1753:
1754: select to_number(item_value) into l_max_group_id
1755: from FII_CHANGE_LOG
1756: where log_item = 'AR_MAX_GROUP_ID';
1757:
1758: -- if g_debug_flag = 'Y' then
1759: -- fii_util.put_line ('l_gl_from: ' ||l_gl_from);

Line 2214: FROM fii_change_log

2210: -- end if;
2211:
2212: SELECT NVL(item_value, 'N')
2213: INTO l_result
2214: FROM fii_change_log
2215: WHERE log_item = 'AR_RESUMMARIZE';
2216:
2217: IF l_result = 'Y' THEN
2218: -- Bug 4942753: Change to return 1 if any row exists

Line 2241: UPDATE fii_change_log

2237: l_count2 := 0;
2238: END;
2239:
2240: IF (l_count1 = 0 AND l_count2 = 0) then
2241: UPDATE fii_change_log
2242: SET item_value = 'N',
2243: last_update_date = SYSDATE,
2244: last_update_login = g_fii_login_id,
2245: last_updated_by = g_fii_user_id

Line 2288: FROM fii_change_log

2284: -- end if;
2285:
2286: SELECT NVL(item_value, 'N')
2287: INTO l_result
2288: FROM fii_change_log
2289: WHERE log_item = 'AR_PROD_CHANGE';
2290:
2291: IF l_result = 'Y' THEN
2292: -- Bug 4942753: Change to return 1 if any row exists

Line 2315: UPDATE fii_change_log

2311: l_count2 := 0;
2312: END;
2313:
2314: IF (l_count1 = 0 AND l_count2 = 0) then
2315: UPDATE fii_change_log
2316: SET item_value = 'N',
2317: last_update_date = SYSDATE,
2318: last_update_login = g_fii_login_id,
2319: last_updated_by = g_fii_user_id

Line 4186: UPDATE fii_change_log

4182: -- is not necessary since everything is
4183: -- going to be freshly loaded
4184: ---------------------------------------------
4185:
4186: UPDATE fii_change_log
4187: SET item_value = 'N',
4188: last_update_date = SYSDATE,
4189: last_update_login = g_fii_login_id,
4190: last_updated_by = g_fii_user_id

Line 4194: UPDATE fii_change_log

4190: last_updated_by = g_fii_user_id
4191: WHERE log_item = 'AR_RESUMMARIZE'
4192: AND item_value = 'Y';
4193:
4194: UPDATE fii_change_log
4195: SET item_value = 'N',
4196: last_update_date = SYSDATE,
4197: last_update_login = g_fii_login_id,
4198: last_updated_by = g_fii_user_id

Line 4710: -- Record AR_MAX_GROUP_ID in FII_CHANGE_LOG

4706:
4707: CLEAN_UP;
4708:
4709: ----------------------------------------------------------------
4710: -- Record AR_MAX_GROUP_ID in FII_CHANGE_LOG
4711: ----------------------------------------------------------------
4712:
4713: MERGE INTO FII_CHANGE_LOG log
4714: USING ( SELECT 'AR_MAX_GROUP_ID' LOG_ITEM,

Line 4713: MERGE INTO FII_CHANGE_LOG log

4709: ----------------------------------------------------------------
4710: -- Record AR_MAX_GROUP_ID in FII_CHANGE_LOG
4711: ----------------------------------------------------------------
4712:
4713: MERGE INTO FII_CHANGE_LOG log
4714: USING ( SELECT 'AR_MAX_GROUP_ID' LOG_ITEM,
4715: to_char( nvl(max(group_id), -1) ) ITEM_VALUE
4716: FROM xla_ae_headers ) new
4717: ON ( new.LOG_ITEM = log.LOG_ITEM )