APPS.FII_GL_JE_B_C dependencies on FII_CHANGE_LOG

Line 442: FROM fii_change_log

438: end if;
439:
440: SELECT DECODE(item_value, 'Y', 'TRUE', 'FALSE')
441: INTO l_slg_chg
442: FROM fii_change_log
443: WHERE log_item = 'GL_RESUMMARIZE';
444:
445: IF l_slg_chg = 'TRUE' THEN
446:

Line 470: g_phase := 'Updating fii_change_log for log_item GL_RESUMMARIZE';

466: l_count2 := 0;
467: end;
468:
469: IF (l_count1 = 0 AND l_count2 = 0) then
470: g_phase := 'Updating fii_change_log for log_item GL_RESUMMARIZE';
471: UPDATE fii_change_log
472: SET item_value = 'N',
473: last_update_date = SYSDATE,
474: last_update_login = g_fii_login_id,

Line 471: UPDATE fii_change_log

467: end;
468:
469: IF (l_count1 = 0 AND l_count2 = 0) then
470: g_phase := 'Updating fii_change_log for log_item GL_RESUMMARIZE';
471: UPDATE fii_change_log
472: SET item_value = 'N',
473: last_update_date = SYSDATE,
474: last_update_login = g_fii_login_id,
475: last_updated_by = g_fii_user_id

Line 517: FROM fii_change_log

513: end if;
514:
515: SELECT DECODE(item_value, 'Y', 'TRUE', 'FALSE')
516: INTO l_prd_chg
517: FROM fii_change_log
518: WHERE log_item = 'GL_PROD_CHANGE';
519:
520: IF l_prd_chg = 'TRUE' THEN
521:

Line 545: g_phase := 'Updating fii_change_log for log_item GL_PROD_CHANGE';

541: l_count2 := 0;
542: end;
543:
544: IF (l_count1 = 0 AND l_count2 = 0) then
545: g_phase := 'Updating fii_change_log for log_item GL_PROD_CHANGE';
546: UPDATE fii_change_log
547: SET item_value = 'N',
548: last_update_date = SYSDATE,
549: last_update_login = g_fii_login_id,

Line 546: UPDATE fii_change_log

542: end;
543:
544: IF (l_count1 = 0 AND l_count2 = 0) then
545: g_phase := 'Updating fii_change_log for log_item GL_PROD_CHANGE';
546: UPDATE fii_change_log
547: SET item_value = 'N',
548: last_update_date = SYSDATE,
549: last_update_login = g_fii_login_id,
550: last_updated_by = g_fii_user_id

Line 3382: g_phase := 'Update fii_change_log if we are running in Inital Load';

3378: -- change log to indicate that resummarization
3379: -- is not necessary since everything is
3380: -- going to be freshly loaded
3381: ---------------------------------------------
3382: g_phase := 'Update fii_change_log if we are running in Inital Load';
3383:
3384: UPDATE fii_change_log
3385: SET item_value = 'N',
3386: last_update_date = SYSDATE,

Line 3384: UPDATE fii_change_log

3380: -- going to be freshly loaded
3381: ---------------------------------------------
3382: g_phase := 'Update fii_change_log if we are running in Inital Load';
3383:
3384: UPDATE fii_change_log
3385: SET item_value = 'N',
3386: last_update_date = SYSDATE,
3387: last_update_login = g_fii_login_id,
3388: last_updated_by = g_fii_user_id

Line 3392: UPDATE fii_change_log

3388: last_updated_by = g_fii_user_id
3389: WHERE log_item = 'GL_RESUMMARIZE'
3390: AND item_value = 'Y';
3391:
3392: UPDATE fii_change_log
3393: SET item_value = 'N',
3394: last_update_date = SYSDATE,
3395: last_update_login = g_fii_login_id,
3396: last_updated_by = g_fii_user_id