APPS.FII_AR_COLLECTORS_PKG dependencies on FII_CHANGE_LOG

Line 122: g_phase := 'Populating COLL_BATCH_PARTY_ID in fii_change_log';

118: return;
119: END IF;
120:
121:
122: g_phase := 'Populating COLL_BATCH_PARTY_ID in fii_change_log';
123: IF (FIIDIM_Debug) THEN
124: FII_UTIL.Write_Log(g_phase);
125: End if;
126:

Line 134: INSERT INTO fii_change_log

130: hz_merge_dictionary d
131: where m.merge_dict_id = d.merge_dict_id
132: and d.entity_name = 'HZ_PARTIES';
133:
134: INSERT INTO fii_change_log
135: (log_item, item_value, CREATION_DATE, CREATED_BY,
136: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
137: (SELECT 'COLL_MAX_BATCH_PARTY_ID',
138: l_max_batch_party_id,

Line 146: (select 1 from fii_change_log

142: fii_user_id, --LAST_UPDATED_BY,
143: fii_login_id --LAST_UPDATE_LOGIN
144: FROM DUAL
145: WHERE NOT EXISTS
146: (select 1 from fii_change_log
147: where log_item = 'COLL_MAX_BATCH_PARTY_ID'));
148:
149: IF (SQL%ROWCOUNT = 0) THEN
150: UPDATE fii_change_log

Line 150: UPDATE fii_change_log

146: (select 1 from fii_change_log
147: where log_item = 'COLL_MAX_BATCH_PARTY_ID'));
148:
149: IF (SQL%ROWCOUNT = 0) THEN
150: UPDATE fii_change_log
151: SET item_value = l_max_batch_party_id,
152: last_update_date = sysdate,
153: last_update_login = fii_login_id,
154: last_updated_by = fii_user_id

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

332: --First do the initialization
333:
334: Initialize;
335:
336: g_phase := 'Getting maximum batch_party_id from fii_change_log table';
337: IF (FIIDIM_Debug) THEN
338: FII_UTIL.Write_Log (g_phase);
339: END IF;
340:

Line 343: from fii_change_log

339: END IF;
340:
341: select item_value
342: into l_max_batch_party_id
343: from fii_change_log
344: where log_item = 'COLL_MAX_BATCH_PARTY_ID';
345:
346: FII_UTIL.Write_Log ('COLL_MAX_BATCH_PARTY_ID = '||l_max_batch_party_id);
347:

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

358: where m.merge_dict_id = d.merge_dict_id
359: and d.entity_name = 'HZ_PARTIES'
360: and batch_party_id > l_max_batch_party_id);
361:
362: g_phase := 'Logging maximum batch_party_id into fii_change_log table';
363: IF (FIIDIM_Debug) THEN
364: FII_UTIL.Write_Log (g_phase);
365: END IF;
366:

Line 376: INSERT INTO fii_change_log

372: and d.entity_name = 'HZ_PARTIES';
373:
374:
375:
376: INSERT INTO fii_change_log
377: (log_item, item_value, CREATION_DATE, CREATED_BY,
378: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
379: (SELECT 'COLL_MAX_BATCH_PARTY_ID',
380: l_max_batch_party_id,

Line 388: (select 1 from fii_change_log

384: fii_user_id, --LAST_UPDATED_BY,
385: fii_login_id --LAST_UPDATE_LOGIN
386: FROM DUAL
387: WHERE NOT EXISTS
388: (select 1 from fii_change_log
389: where log_item = 'COLL_MAX_BATCH_PARTY_ID'));
390:
391: IF (SQL%ROWCOUNT = 0) THEN
392: UPDATE fii_change_log

Line 392: UPDATE fii_change_log

388: (select 1 from fii_change_log
389: where log_item = 'COLL_MAX_BATCH_PARTY_ID'));
390:
391: IF (SQL%ROWCOUNT = 0) THEN
392: UPDATE fii_change_log
393: SET item_value = l_max_batch_party_id,
394: last_update_date = sysdate,
395: last_update_login = fii_login_id,
396: last_updated_by = fii_user_id