eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_008 dependencies on IGS_AD_RELATIONS_INT

Line 54: FROM igs_ad_relations_int_all mi, igs_ad_interface_all i

50: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
51:
52: CURSOR per_rel(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
53: SELECT mi.*,i.person_id
54: FROM igs_ad_relations_int_all mi, igs_ad_interface_all i
55: WHERE mi.interface_run_id = cp_interface_run_id
56: AND mi.interface_id = i.interface_id
57: AND i.interface_run_id = cp_interface_run_id
58: AND mi.status = '2';

Line 69: cp_rel_person_id igs_ad_relations_int_all.rel_person_id%TYPE,

65: AND SOURCE_TYPE_ID = p_src_typ_id;
66:
67: -- Cursor to check whether the relationship exists for the person
68: CURSOR c_rel_count (cp_person_id igs_ad_interface_all.person_id%TYPE,
69: cp_rel_person_id igs_ad_relations_int_all.rel_person_id%TYPE,
70: cp_relationship_type igs_ad_relations_int_all.relationship_type%TYPE,
71: cp_relationship_code igs_ad_relations_int_all.relationship_code%TYPE) IS
72: SELECT count(*)
73: FROM HZ_RELATIONSHIPS

Line 70: cp_relationship_type igs_ad_relations_int_all.relationship_type%TYPE,

66:
67: -- Cursor to check whether the relationship exists for the person
68: CURSOR c_rel_count (cp_person_id igs_ad_interface_all.person_id%TYPE,
69: cp_rel_person_id igs_ad_relations_int_all.rel_person_id%TYPE,
70: cp_relationship_type igs_ad_relations_int_all.relationship_type%TYPE,
71: cp_relationship_code igs_ad_relations_int_all.relationship_code%TYPE) IS
72: SELECT count(*)
73: FROM HZ_RELATIONSHIPS
74: WHERE subject_id = cp_person_Id

Line 71: cp_relationship_code igs_ad_relations_int_all.relationship_code%TYPE) IS

67: -- Cursor to check whether the relationship exists for the person
68: CURSOR c_rel_count (cp_person_id igs_ad_interface_all.person_id%TYPE,
69: cp_rel_person_id igs_ad_relations_int_all.rel_person_id%TYPE,
70: cp_relationship_type igs_ad_relations_int_all.relationship_type%TYPE,
71: cp_relationship_code igs_ad_relations_int_all.relationship_code%TYPE) IS
72: SELECT count(*)
73: FROM HZ_RELATIONSHIPS
74: WHERE subject_id = cp_person_Id
75: AND object_id = cp_rel_person_id

Line 140: CURSOR Rel_person_exists_cur(p_rel_person_id IGS_AD_RELATIONS_INT.REL_PERSON_ID%TYPE) IS

136: lk.VIEW_APPLICATION_ID = cp_appl_id AND
137: lk.language = USERENV('LANG') AND
138: lk.security_group_id = cp_security_group_id;
139:
140: CURSOR Rel_person_exists_cur(p_rel_person_id IGS_AD_RELATIONS_INT.REL_PERSON_ID%TYPE) IS
141: SELECT 'Y'
142: FROM HZ_PARTIES
143: WHERE party_id = p_rel_person_id ;
144:

Line 150: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

146:
147:
148: l_rel_person_exists VARCHAR2(1);
149: l_Count NUMBER;
150: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
151: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
152: l_msg_count NUMBER ;
153: l_last_update_date DATE;
154: l_msg_data VARCHAR2(2000);

Line 151: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;

147:
148: l_rel_person_exists VARCHAR2(1);
149: l_Count NUMBER;
150: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
151: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
152: l_msg_count NUMBER ;
153: l_last_update_date DATE;
154: l_msg_data VARCHAR2(2000);
155: l_party_id NUMBER;

Line 189: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E171','IGS_AD_RELATIONS_INT_ALL');

185: -- RELATIONSHIP_CODE should be NOT NULL
186: -- ssawhney 2203778 HZ F relationship model changes
187: IF P_Relations_Rec.RELATIONSHIP_CODE IS NULL THEN
188: IF l_enable_log = 'Y' THEN
189: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E171','IGS_AD_RELATIONS_INT_ALL');
190: END IF;
191:
192: UPDATE IGS_AD_RELATIONS_INT_ALL
193: SET ERROR_CODE = 'E171',

Line 192: UPDATE IGS_AD_RELATIONS_INT_ALL

188: IF l_enable_log = 'Y' THEN
189: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E171','IGS_AD_RELATIONS_INT_ALL');
190: END IF;
191:
192: UPDATE IGS_AD_RELATIONS_INT_ALL
193: SET ERROR_CODE = 'E171',
194: STATUS = l_Status
195: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
196: RETURN;

Line 205: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E239','IGS_AD_RELATIONS_INT_ALL');

201: P_Relations_Rec.RELATIONSHIP_CODE,p_relations_rec.RELATIONSHIP_TYPE,0);
202: FETCH Relationship_Type_C INTO l_Count;
203: IF l_Count = 0 THEN
204: IF l_enable_log = 'Y' THEN
205: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E239','IGS_AD_RELATIONS_INT_ALL');
206: END IF;
207: UPDATE IGS_AD_RELATIONS_INT_ALL
208: SET ERROR_CODE = 'E239',
209: STATUS = l_Status

Line 207: UPDATE IGS_AD_RELATIONS_INT_ALL

203: IF l_Count = 0 THEN
204: IF l_enable_log = 'Y' THEN
205: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E239','IGS_AD_RELATIONS_INT_ALL');
206: END IF;
207: UPDATE IGS_AD_RELATIONS_INT_ALL
208: SET ERROR_CODE = 'E239',
209: STATUS = l_Status
210: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
211:

Line 224: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E240','IGS_AD_RELATIONS_INT_ALL');

220: -- Validate Oth_Relationship_Type
221: IF P_Relations_Rec.Oth_Relationship_Type IS NOT NULL THEN
222: IF NOT(igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_RELATIONS_TYPE',P_Relations_Rec.oth_relationship_type,222)) THEN
223: IF l_enable_log = 'Y' THEN
224: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E240','IGS_AD_RELATIONS_INT_ALL');
225: END IF;
226: UPDATE igs_ad_relations_int_all
227: SET ERROR_CODE = 'E240',
228: STATUS = l_Status

Line 226: UPDATE igs_ad_relations_int_all

222: IF NOT(igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_RELATIONS_TYPE',P_Relations_Rec.oth_relationship_type,222)) THEN
223: IF l_enable_log = 'Y' THEN
224: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E240','IGS_AD_RELATIONS_INT_ALL');
225: END IF;
226: UPDATE igs_ad_relations_int_all
227: SET ERROR_CODE = 'E240',
228: STATUS = l_Status
229: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
230: RETURN;

Line 245: UPDATE igs_ad_relations_int_all

241: -- if or not to pass the person_number is decided.(Tray, Bug#1849225,02-07-2001)
242: l_generate_party_number := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
243: IF (l_generate_party_number = 'N') THEN
244: IF (P_Relations_Rec.person_number IS NULL) THEN
245: UPDATE igs_ad_relations_int_all
246: SET STATUS = '3',ERROR_CODE = 'E204'
247: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.INTERFACE_RELATIONS_ID;
248: -- Call Log detail
249: IF l_enable_log = 'Y' THEN

Line 250: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E204','IGS_AD_RELATIONS_INT_ALL');

246: SET STATUS = '3',ERROR_CODE = 'E204'
247: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.INTERFACE_RELATIONS_ID;
248: -- Call Log detail
249: IF l_enable_log = 'Y' THEN
250: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E204','IGS_AD_RELATIONS_INT_ALL');
251: FND_MESSAGE.SET_NAME('IGS','IGS_AD_REL_FAIL_PER_NO');
252: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
253: END IF;
254: RETURN;

Line 264: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E201','IGS_AD_RELATIONS_INT_ALL');

260: -- Validate the title
261: IF P_Relations_Rec.pre_name_adjunct IS NOT NULL THEN
262: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('CONTACT_TITLE',P_Relations_Rec.pre_name_adjunct,222)) THEN
263: IF l_enable_log = 'Y' THEN
264: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E201','IGS_AD_RELATIONS_INT_ALL');
265: END IF;
266: UPDATE igs_ad_relations_int_all
267: SET ERROR_CODE = 'E201',
268: STATUS = l_Status

Line 266: UPDATE igs_ad_relations_int_all

262: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('CONTACT_TITLE',P_Relations_Rec.pre_name_adjunct,222)) THEN
263: IF l_enable_log = 'Y' THEN
264: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E201','IGS_AD_RELATIONS_INT_ALL');
265: END IF;
266: UPDATE igs_ad_relations_int_all
267: SET ERROR_CODE = 'E201',
268: STATUS = l_Status
269: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
270: RETURN;

Line 277: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E202','IGS_AD_RELATIONS_INT_ALL');

273: -- Validate Sex.
274: IF P_Relations_Rec.sex IS NOT NULL THEN
275: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_GENDER',P_Relations_Rec.sex,222)) THEN
276: IF l_enable_log = 'Y' THEN
277: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E202','IGS_AD_RELATIONS_INT_ALL');
278: END IF;
279: UPDATE igs_ad_relations_int_all
280: SET ERROR_CODE = 'E202',
281: STATUS = l_Status

Line 279: UPDATE igs_ad_relations_int_all

275: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_GENDER',P_Relations_Rec.sex,222)) THEN
276: IF l_enable_log = 'Y' THEN
277: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E202','IGS_AD_RELATIONS_INT_ALL');
278: END IF;
279: UPDATE igs_ad_relations_int_all
280: SET ERROR_CODE = 'E202',
281: STATUS = l_Status
282: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
283: RETURN;

Line 291: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E203','IGS_AD_RELATIONS_INT_ALL');

287: -- Validate birth_dt, deceased_dt.
288: IF ((P_Relations_Rec.birth_dt IS NOT NULL) AND (P_Relations_Rec.birth_dt > SYSDATE)) THEN
289: l_err_cd := 'E203';
290: IF l_enable_log = 'Y' THEN
291: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E203','IGS_AD_RELATIONS_INT_ALL');
292: END IF;
293: UPDATE igs_ad_relations_int_all
294: SET ERROR_CODE = l_err_cd,
295: STATUS = l_Status

Line 293: UPDATE igs_ad_relations_int_all

289: l_err_cd := 'E203';
290: IF l_enable_log = 'Y' THEN
291: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E203','IGS_AD_RELATIONS_INT_ALL');
292: END IF;
293: UPDATE igs_ad_relations_int_all
294: SET ERROR_CODE = l_err_cd,
295: STATUS = l_Status
296: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
297: RETURN;

Line 301: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E451','IGS_AD_RELATIONS_INT_ALL');

297: RETURN;
298: ELSIF ( (NVL(P_Relations_Rec.deceased,'N') = 'Y') AND (P_Relations_Rec.deceased_date > SYSDATE)) THEN
299: l_err_cd := 'E451';
300: IF l_enable_log = 'Y' THEN
301: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E451','IGS_AD_RELATIONS_INT_ALL');
302: END IF;
303: UPDATE igs_ad_relations_int_all
304: SET ERROR_CODE = l_err_cd,
305: STATUS = l_Status

Line 303: UPDATE igs_ad_relations_int_all

299: l_err_cd := 'E451';
300: IF l_enable_log = 'Y' THEN
301: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E451','IGS_AD_RELATIONS_INT_ALL');
302: END IF;
303: UPDATE igs_ad_relations_int_all
304: SET ERROR_CODE = l_err_cd,
305: STATUS = l_Status
306: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
307: RETURN;

Line 389: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E452','IGS_AD_RELATIONS_INT_ALL');

385:
386:
387: IF l_return_status IN ('E','U') THEN
388: IF l_enable_log = 'Y' THEN
389: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E452','IGS_AD_RELATIONS_INT_ALL');
390: END IF;
391: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
392: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E452';
393: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

Line 403: UPDATE igs_ad_relations_int_all

399: l_debug_str, NULL,
400: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
401: );
402: END IF;
403: UPDATE igs_ad_relations_int_all
404: SET ERROR_CODE = 'E452',
405: status = l_status
406: WHERE interface_relations_id = P_Relations_Rec.Interface_Relations_Id;
407: RETURN;

Line 415: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E289','IGS_AD_RELATIONS_INT_ALL');

411: -- ssawhney 2203778 using IGS wrapper now.
412: ELSIF p_match_found = 'Y' THEN
413: l_status := '3';
414: IF l_enable_log = 'Y' THEN
415: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E289','IGS_AD_RELATIONS_INT_ALL');
416: END IF;
417: UPDATE igs_ad_relations_int_all
418: SET ERROR_CODE = 'E289',
419: STATUS = l_Status

Line 417: UPDATE igs_ad_relations_int_all

413: l_status := '3';
414: IF l_enable_log = 'Y' THEN
415: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E289','IGS_AD_RELATIONS_INT_ALL');
416: END IF;
417: UPDATE igs_ad_relations_int_all
418: SET ERROR_CODE = 'E289',
419: STATUS = l_Status
420: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
421: RETURN;

Line 449: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E172','IGS_AD_RELATIONS_INT_ALL');

445: p_object_version_number => l_object_verson_number) ;
446:
447: IF l_return_status IN ('E','U') THEN
448: IF l_enable_log = 'Y' THEN
449: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E172','IGS_AD_RELATIONS_INT_ALL');
450: END IF;
451:
452: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
453: l_label := 'igs.plsql.igs_ad_imp_008.crt_rel.exception '||'E172';

Line 464: UPDATE igs_ad_relations_int_all

460: l_debug_str, NULL,
461: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
462: );
463: END IF;
464: UPDATE igs_ad_relations_int_all
465: SET ERROR_CODE = 'E172',
466: STATUS = '3'
467: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
468: RETURN;

Line 470: UPDATE igs_ad_relations_int_all

466: STATUS = '3'
467: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
468: RETURN;
469: ELSE
470: UPDATE igs_ad_relations_int_all
471: SET rel_person_id = l_person_id,
472: status = '1',
473: ERROR_CODE = NULL
474: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;

Line 483: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E290','IGS_AD_RELATIONS_INT_ALL');

479: ROLLBACK TO before_creatupdate;
480: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
481: IF l_message_name = ('IGS_PE_PERS_ID_PRD_OVRLP') THEN
482: IF l_enable_log = 'Y' THEN
483: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E290','IGS_AD_RELATIONS_INT_ALL');
484: END IF;
485: UPDATE igs_ad_relations_int_all
486: SET ERROR_CODE = 'E290',
487: STATUS = '3'

Line 485: UPDATE igs_ad_relations_int_all

481: IF l_message_name = ('IGS_PE_PERS_ID_PRD_OVRLP') THEN
482: IF l_enable_log = 'Y' THEN
483: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E290','IGS_AD_RELATIONS_INT_ALL');
484: END IF;
485: UPDATE igs_ad_relations_int_all
486: SET ERROR_CODE = 'E290',
487: STATUS = '3'
488: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
489: RETURN;

Line 556: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E518','IGS_AD_RELATIONS_INT_ALL');

552: );
553: END IF;
554:
555: IF l_enable_log = 'Y' THEN
556: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E518','IGS_AD_RELATIONS_INT_ALL');
557: END IF;
558:
559: UPDATE igs_ad_relations_int_all
560: SET ERROR_CODE = 'E518',

Line 559: UPDATE igs_ad_relations_int_all

555: IF l_enable_log = 'Y' THEN
556: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E518','IGS_AD_RELATIONS_INT_ALL');
557: END IF;
558:
559: UPDATE igs_ad_relations_int_all
560: SET ERROR_CODE = 'E518',
561: STATUS = l_Status
562: WHERE INTERFACE_RELATIONS_ID = P_Relations_Rec.Interface_Relations_Id;
563: END crt_rel;

Line 624: UPDATE igs_ad_relations_int_all

620: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
621: );
622: END IF;
623:
624: UPDATE igs_ad_relations_int_all
625: SET status = '1',
626: error_code = NULL
627: WHERE interface_relations_id = relations_rec.interface_relations_id;
628: OPEN c_category_included('RELATIONS_CONTACTS',p_source_type_id);

Line 679: igs_ad_imp_001.logerrormessage(Relations_Rec.Interface_Relations_Id,'E518','IGS_AD_RELATIONS_INT_ALL');

675: );
676: END IF;
677:
678: IF l_enable_log = 'Y' THEN
679: igs_ad_imp_001.logerrormessage(Relations_Rec.Interface_Relations_Id,'E518','IGS_AD_RELATIONS_INT_ALL');
680: END IF;
681: UPDATE igs_ad_relations_int_all
682: SET status = '3', error_code = 'E518'
683: WHERE interface_relations_id = relations_rec.interface_relations_id;

Line 681: UPDATE igs_ad_relations_int_all

677:
678: IF l_enable_log = 'Y' THEN
679: igs_ad_imp_001.logerrormessage(Relations_Rec.Interface_Relations_Id,'E518','IGS_AD_RELATIONS_INT_ALL');
680: END IF;
681: UPDATE igs_ad_relations_int_all
682: SET status = '3', error_code = 'E518'
683: WHERE interface_relations_id = relations_rec.interface_relations_id;
684: END;
685: IF l_processed_records = 100 THEN

Line 760: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;

756: l_party_site_number VARCHAR2(2000);
757: l_party_site_use_id HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID%TYPE;
758: l_site1 igs_ad_reladdr_int.site_use_code_1%TYPE;
759: l_site2 igs_ad_reladdr_int.site_use_code_2%TYPE;
760: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
761: l_msg_count NUMBER;
762: l_msg_data VARCHAR2(2000);
763: l_Count NUMBER;
764: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

Line 764: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

760: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
761: l_msg_count NUMBER;
762: l_msg_data VARCHAR2(2000);
763: l_Count NUMBER;
764: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
765: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
766: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
767: l_last_update_date DATE;
768: l_site_use_last_update_date DATE;

Line 765: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;

761: l_msg_count NUMBER;
762: l_msg_data VARCHAR2(2000);
763: l_Count NUMBER;
764: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
765: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
766: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
767: l_last_update_date DATE;
768: l_site_use_last_update_date DATE;
769: l_profile_last_update_date DATE;

Line 790: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

786: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
787: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
788: l_party_site_use_id HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID%TYPE;
789: l_row_id VARCHAR2(30);
790: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
791: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
792: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
793: l_msg_data VARCHAR2(2000);
794: l_last_update_date DATE;

Line 791: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;

787: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
788: l_party_site_use_id HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID%TYPE;
789: l_row_id VARCHAR2(30);
790: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
791: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
792: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
793: l_msg_data VARCHAR2(2000);
794: l_last_update_date DATE;
795: l_site_use_last_update_date DATE;

Line 792: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;

788: l_party_site_use_id HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID%TYPE;
789: l_row_id VARCHAR2(30);
790: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
791: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
792: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
793: l_msg_data VARCHAR2(2000);
794: l_last_update_date DATE;
795: l_site_use_last_update_date DATE;
796: l_profile_last_update_date DATE;

Line 1056: l_Status igs_ad_relations_int.status%TYPE;

1052: SELECT birth_date
1053: FROM igs_pe_person_base_v
1054: WHERE person_id = cp_person_id;
1055:
1056: l_Status igs_ad_relations_int.status%TYPE;
1057: l_Error_Code igs_ad_relations_int.error_code%TYPE;
1058: l_birth_date DATE;
1059: BEGIN
1060: l_Status := '3';

Line 1057: l_Error_Code igs_ad_relations_int.error_code%TYPE;

1053: FROM igs_pe_person_base_v
1054: WHERE person_id = cp_person_id;
1055:
1056: l_Status igs_ad_relations_int.status%TYPE;
1057: l_Error_Code igs_ad_relations_int.error_code%TYPE;
1058: l_birth_date DATE;
1059: BEGIN
1060: l_Status := '3';
1061: IF (reladdr_rec.site_use_code_1 IS NOT NULL) THEN

Line 1659: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;

1655: WHERE contact_point_id = c_contact_point_id;
1656:
1657: l_obj_ver hz_contact_points.object_version_number%TYPE;
1658:
1659: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
1660: l_msg_count NUMBER;
1661: l_msg_data VARCHAR2(2000);
1662: l_Count NUMBER;
1663: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

Line 1663: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

1659: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
1660: l_msg_count NUMBER;
1661: l_msg_data VARCHAR2(2000);
1662: l_Count NUMBER;
1663: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
1664: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
1665: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
1666:
1667: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

Line 1664: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;

1660: l_msg_count NUMBER;
1661: l_msg_data VARCHAR2(2000);
1662: l_Count NUMBER;
1663: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
1664: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
1665: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
1666:
1667: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1668: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;

Line 1681: l_return_status igs_ad_relations_int.status%TYPE;

1677: tmp_var VARCHAR2(2000);
1678: -- Start Of Local Procedure prc_rel_con.
1679: PROCEDURE prc_rel_con (p_rel_con_rec relcon_rec_c%ROWTYPE) AS
1680:
1681: l_return_status igs_ad_relations_int.status%TYPE;
1682: l_msg_count NUMBER;
1683: l_msg_data VARCHAR2(2000);
1684: l_Status igs_ad_relations_int.status%TYPE;
1685: l_Error_Code igs_ad_relations_int.error_code%TYPE;

Line 1684: l_Status igs_ad_relations_int.status%TYPE;

1680:
1681: l_return_status igs_ad_relations_int.status%TYPE;
1682: l_msg_count NUMBER;
1683: l_msg_data VARCHAR2(2000);
1684: l_Status igs_ad_relations_int.status%TYPE;
1685: l_Error_Code igs_ad_relations_int.error_code%TYPE;
1686: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1687: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1688: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

Line 1685: l_Error_Code igs_ad_relations_int.error_code%TYPE;

1681: l_return_status igs_ad_relations_int.status%TYPE;
1682: l_msg_count NUMBER;
1683: l_msg_data VARCHAR2(2000);
1684: l_Status igs_ad_relations_int.status%TYPE;
1685: l_Error_Code igs_ad_relations_int.error_code%TYPE;
1686: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1687: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1688: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1689: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;

Line 2413: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;

2409:
2410: l_row_id IGS_AD_ACAD_HISTORY_V.ROW_ID%TYPE;--VARCHAR2(30);
2411: l_education_id NUMBER;
2412: l_object_version_number HZ_EDUCATION.OBJECT_VERSION_NUMBER%TYPE;
2413: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
2414: l_msg_count NUMBER;
2415: l_msg_data VARCHAR2(2000);
2416: l_peron_interest_id NUMBER;
2417: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

Line 2417: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

2413: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
2414: l_msg_count NUMBER;
2415: l_msg_data VARCHAR2(2000);
2416: l_peron_interest_id NUMBER;
2417: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
2418: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
2419: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
2420: l_check VARCHAR2(30);
2421: l_count NUMBER;

Line 2418: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;

2414: l_msg_count NUMBER;
2415: l_msg_data VARCHAR2(2000);
2416: l_peron_interest_id NUMBER;
2417: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
2418: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
2419: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
2420: l_check VARCHAR2(30);
2421: l_count NUMBER;
2422: l_match_ind VARCHAR2(2);

Line 2459: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

2455: FROM igs_pe_person_base_v
2456: WHERE person_id = cp_person_id;
2457:
2458:
2459: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
2460: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
2461: birth_date_rec birth_date_cur%ROWTYPE;
2462:
2463: BEGIN

Line 2460: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;

2456: WHERE person_id = cp_person_id;
2457:
2458:
2459: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
2460: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
2461: birth_date_rec birth_date_cur%ROWTYPE;
2462:
2463: BEGIN
2464: