APPS.HZ_PURGE dependencies on HZ_PURGE_GEN

Line 68: HZ_GEN_PLSQL.new('HZ_PURGE_GEN', 'PACKAGE BODY');

64:
65: -- initialize API return status to success.
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: /* Beginnig of the dynamic package generation*/
68: HZ_GEN_PLSQL.new('HZ_PURGE_GEN', 'PACKAGE BODY');
69: HZ_GEN_PLSQL.add_line('CREATE OR REPLACE PACKAGE BODY HZ_PURGE_GEN AS');
70: HZ_GEN_PLSQL.add_line('PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,

Line 69: HZ_GEN_PLSQL.add_line('CREATE OR REPLACE PACKAGE BODY HZ_PURGE_GEN AS');

65: -- initialize API return status to success.
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: /* Beginnig of the dynamic package generation*/
68: HZ_GEN_PLSQL.new('HZ_PURGE_GEN', 'PACKAGE BODY');
69: HZ_GEN_PLSQL.add_line('CREATE OR REPLACE PACKAGE BODY HZ_PURGE_GEN AS');
70: HZ_GEN_PLSQL.add_line('PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,

Line 224: HZ_GEN_PLSQL.add_line('END HZ_PURGE_GEN;');

220: HZ_GEN_PLSQL.add_line('RAISE FND_API.G_EXC_ERROR;');
221:
222: HZ_GEN_PLSQL.add_line('END IDENTIFY_CANDIDATES;');
223:
224: HZ_GEN_PLSQL.add_line('END HZ_PURGE_GEN;');
225: HZ_GEN_PLSQL.compile_code;
226:
227:
228: -- standard call to get message count and if count is 1, get message info.

Line 305: where object_type='PACKAGE BODY' and status='VALID'and object_name='HZ_PURGE_GEN';

301: select h.party_id, p.party_name from hz_purge_gt h, hz_parties p where h.party_id=p.party_id;
302:
303: cursor time_stmp is
304: select to_date(timestamp,'YYYY-MM-DD:HH24:MI:SS') from sys.user_objects
305: where object_type='PACKAGE BODY' and status='VALID'and object_name='HZ_PURGE_GEN';
306:
307: cursor dict_update_date is
308: select max(last_update_date) from hz_merge_dictionary;
309:

Line 342: /* Generate the body of the Package HZ_PURGE_GEN if last_update_date of hz_merge_dictionary

338: open dict_update_date;
339: fetch dict_update_date into mergedict_update_date;
340: close dict_update_date;
341:
342: /* Generate the body of the Package HZ_PURGE_GEN if last_update_date of hz_merge_dictionary
343: is greater than the package generation date*/
344:
345:
346: if (mergedict_update_date is null or time_stamp is null or mergedict_update_date>time_stamp) then

Line 347: hz_purge.generate_body(p_init_msg_list, x_return_status, x_msg_count, x_msg_data);

343: is greater than the package generation date*/
344:
345:
346: if (mergedict_update_date is null or time_stamp is null or mergedict_update_date>time_stamp) then
347: hz_purge.generate_body(p_init_msg_list, x_return_status, x_msg_count, x_msg_data);
348: log('Start Time ='||sysdate,conc_prg);
349: end if;
350:
351: open b1;

Line 370: hz_purge_gen.identify_candidates(p_init_msg_list, x_return_status, x_msg_count, x_msg_data, false, conc_prg, regid_flag);

366: regid_flag := true;
367: end if;
368: end if;
369:
370: hz_purge_gen.identify_candidates(p_init_msg_list, x_return_status, x_msg_count, x_msg_data, false, conc_prg, regid_flag);
371:
372: /* Insert into the hz_purge_candidates table */
373: /* insert into hz_purge_candidates(BATCH_ID,CANDIDATE_PARTY_ID,PARTY_NAME,PARTY_NUMBER,ADDRESSES,PHONE_NUMBERS,COUNTRY,STATUS,CREATION_DATE,
374: LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATED_BY)

Line 489: hz_purge_gen.identify_candidates(p_init_msg_list, x_return_status, x_msg_count, x_msg_data, true, false);

485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486:
487: delete from hz_purge_gt;
488: insert into hz_purge_gt(party_id) select party_id from hz_parties where party_id=partyid;
489: hz_purge_gen.identify_candidates(p_init_msg_list, x_return_status, x_msg_count, x_msg_data, true, false);
490: open party;
491: fetch party into party_count;
492: if party_count>0 then
493: allow_purge:='false';