16:
17: update fii_change_log
18: set item_value = p_item_value,
19: last_update_date = sysdate,
20: last_updated_by = fnd_global.user_id,
21: last_update_login = fnd_global.user_id
22: where log_item = p_log_item;
23:
24: x_status := FND_API.G_RET_STS_SUCCESS;
17: update fii_change_log
18: set item_value = p_item_value,
19: last_update_date = sysdate,
20: last_updated_by = fnd_global.user_id,
21: last_update_login = fnd_global.user_id
22: where log_item = p_log_item;
23:
24: x_status := FND_API.G_RET_STS_SUCCESS;
25: if g_debug_flag = 'Y' then
52:
53: UPDATE FII_CHANGE_LOG
54: SET item_value = 'Y',
55: last_update_date = sysdate,
56: last_updated_by = fnd_global.user_id,
57: last_update_login = fnd_global.user_id
58: WHERE log_item IN
59: ('GL_RESUMMARIZE',
60: 'AP_RESUMMARIZE',
53: UPDATE FII_CHANGE_LOG
54: SET item_value = 'Y',
55: last_update_date = sysdate,
56: last_updated_by = fnd_global.user_id,
57: last_update_login = fnd_global.user_id
58: WHERE log_item IN
59: ('GL_RESUMMARIZE',
60: 'AP_RESUMMARIZE',
61: 'AR_RESUMMARIZE',
112: last_updated_by)
113: VALUES (p_log_item,
114: p_item_value,
115: sysdate,
116: fnd_global.user_id,
117: sysdate,
118: fnd_global.login_Id,
119: fnd_global.user_id);
120:
114: p_item_value,
115: sysdate,
116: fnd_global.user_id,
117: sysdate,
118: fnd_global.login_Id,
119: fnd_global.user_id);
120:
121: END IF;
122:
115: sysdate,
116: fnd_global.user_id,
117: sysdate,
118: fnd_global.login_Id,
119: fnd_global.user_id);
120:
121: END IF;
122:
123: if g_debug_flag = 'Y' then