APPS.FII_PARTY_MKT_CLASS_C dependencies on FII_CHANGE_LOG

Line 263: g_phase := 'Populating IND_MAX_BATCH_PARTY_ID in fii_change_log';

259:
260: BEGIN
261: l_fii_schema := 'FII';
262:
263: g_phase := 'Populating IND_MAX_BATCH_PARTY_ID in fii_change_log';
264: FII_UTIL.Write_Log(g_phase);
265:
266: select nvl(max(batch_party_id), -1)
267: into l_max_batch_party_id

Line 273: INSERT INTO fii_change_log

269: hz_merge_dictionary d
270: where m.merge_dict_id = d.merge_dict_id
271: and d.entity_name = 'HZ_PARTIES';
272:
273: INSERT INTO fii_change_log
274: (log_item, item_value, CREATION_DATE, CREATED_BY,
275: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
276: (SELECT 'IND_MAX_BATCH_PARTY_ID',
277: l_max_batch_party_id,

Line 285: (select 1 from fii_change_log

281: g_user_id, --LAST_UPDATED_BY,
282: g_login_id --LAST_UPDATE_LOGIN
283: FROM DUAL
284: WHERE NOT EXISTS
285: (select 1 from fii_change_log
286: where log_item = 'IND_MAX_BATCH_PARTY_ID'));
287:
288: IF (SQL%ROWCOUNT = 0) THEN
289: UPDATE fii_change_log

Line 289: UPDATE fii_change_log

285: (select 1 from fii_change_log
286: where log_item = 'IND_MAX_BATCH_PARTY_ID'));
287:
288: IF (SQL%ROWCOUNT = 0) THEN
289: UPDATE fii_change_log
290: SET item_value = l_max_batch_party_id,
291: last_update_date = sysdate,
292: last_update_login = g_login_id,
293: last_updated_by = g_user_id

Line 412: g_phase := 'Getting maximum batch_party_id from fii_change_log table';

408:
409: BEGIN
410: l_fii_schema := 'FII';
411:
412: g_phase := 'Getting maximum batch_party_id from fii_change_log table';
413: FII_UTIL.Write_Log (g_phase);
414:
415: select item_value
416: into l_max_batch_party_id

Line 417: from fii_change_log

413: FII_UTIL.Write_Log (g_phase);
414:
415: select item_value
416: into l_max_batch_party_id
417: from fii_change_log
418: where log_item = 'IND_MAX_BATCH_PARTY_ID';
419:
420: FII_UTIL.Write_Log ('IND_MAX_BATCH_PARTY_ID = '||l_max_batch_party_id);
421:

Line 434: g_phase := 'Logging maximum batch_party_id into fii_change_log table';

430: where m.merge_dict_id = d.merge_dict_id
431: and d.entity_name = 'HZ_PARTIES'
432: and batch_party_id > l_max_batch_party_id);
433:
434: g_phase := 'Logging maximum batch_party_id into fii_change_log table';
435: FII_UTIL.Write_Log (g_phase);
436:
437: select nvl(max(batch_party_id), -1)
438: into l_max_batch_party_id

Line 444: INSERT INTO fii_change_log

440: hz_merge_dictionary d
441: where m.merge_dict_id = d.merge_dict_id
442: and d.entity_name = 'HZ_PARTIES';
443:
444: INSERT INTO fii_change_log
445: (log_item, item_value, CREATION_DATE, CREATED_BY,
446: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
447: (SELECT 'IND_MAX_BATCH_PARTY_ID',
448: l_max_batch_party_id,

Line 456: (select 1 from fii_change_log

452: g_user_id, --LAST_UPDATED_BY,
453: g_login_id --LAST_UPDATE_LOGIN
454: FROM DUAL
455: WHERE NOT EXISTS
456: (select 1 from fii_change_log
457: where log_item = 'IND_MAX_BATCH_PARTY_ID'));
458:
459: IF (SQL%ROWCOUNT = 0) THEN
460: UPDATE fii_change_log

Line 460: UPDATE fii_change_log

456: (select 1 from fii_change_log
457: where log_item = 'IND_MAX_BATCH_PARTY_ID'));
458:
459: IF (SQL%ROWCOUNT = 0) THEN
460: UPDATE fii_change_log
461: SET item_value = l_max_batch_party_id,
462: last_update_date = sysdate,
463: last_update_login = g_login_id,
464: last_updated_by = g_user_id

Line 696: from fii_change_log

692: return 'INIT';
693: ELSE
694: --Check if log_item = 'IND_MAX_BATCH_PARTY_ID' exists for party merge functionality.
695: select count(*) into l_count_party_marge
696: from fii_change_log
697: where log_item = 'IND_MAX_BATCH_PARTY_ID';
698:
699: IF (l_count_party_marge = 0) THEN
700: return 'INIT';