APPS.IGS_EN_SPLACEMENTS_API dependencies on HZ_PARTIES

Line 43: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

39: AND employment_history_id=c_emp_hist_id;
40:
41: Cursor cur_c2 IS SELECT *
42: FROM IGS_PE_CONTACTS_V
43: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
44: AND OWNER_TABLE_ID = P_PERSON_ID
45: AND CONTACT_POINT_ID = P_PHONE_ID
46: AND CONTACT_POINT_TYPE = 'PHONE'
47: FOR UPDATE NOWAIT;

Line 51: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

47: FOR UPDATE NOWAIT;
48:
49: Cursor cur_c3 IS SELECT *
50: FROM IGS_PE_CONTACTS_V
51: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
52: AND OWNER_TABLE_ID = P_PERSON_ID
53: AND CONTACT_POINT_ID = P_EMAIL_ID
54: AND CONTACT_POINT_TYPE = 'EMAIL'
55: FOR UPDATE NOWAIT;

Line 58: FROM HZ_PARTIES

54: AND CONTACT_POINT_TYPE = 'EMAIL'
55: FOR UPDATE NOWAIT;
56:
57: Cursor cur_c4(c_person_id IN NUMBER) IS SELECT party_number
58: FROM HZ_PARTIES
59: WHERE HZ_PARTIES.PARTY_ID=c_person_id;
60:
61: l_profile_id VARCHAR2(60) :=NULL;
62: l_dup_found VARCHAR2(1) :=NULL;

Line 59: WHERE HZ_PARTIES.PARTY_ID=c_person_id;

55: FOR UPDATE NOWAIT;
56:
57: Cursor cur_c4(c_person_id IN NUMBER) IS SELECT party_number
58: FROM HZ_PARTIES
59: WHERE HZ_PARTIES.PARTY_ID=c_person_id;
60:
61: l_profile_id VARCHAR2(60) :=NULL;
62: l_dup_found VARCHAR2(1) :=NULL;
63: l_dup_where_clause VARCHAR2(2000) :=NULL;

Line 71: l_hz_parties_ovn NUMBER(10);

67: l_msg_count NUMBER :=NULL;
68: l_return_status VARCHAR2(10) :=NULL;
69: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE :=P_PERSON_ID;
70: l_person_number IGS_PE_PERSON.PERSON_NUMBER%TYPE :=NULL;
71: l_hz_parties_ovn NUMBER(10);
72: l_last_update_date HZ_CONTACT_POINTS.LAST_UPDATE_DATE%TYPE :=NULL;
73: l_contact_point_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE :=NULL;
74: l_contact_point_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE :=NULL;
75: l_phone HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE := P_PHONE;

Line 144: X_HZ_PARTIES_OVN => l_hz_parties_ovn,

140: X_EMAIL_ADDR => NULL,
141: X_LEVEL_OF_QUAL_ID => NULL,
142: X_MILITARY_SERVICE_REG => NULL,
143: X_VETERAN => NULL,
144: X_HZ_PARTIES_OVN => l_hz_parties_ovn,
145: X_ATTRIBUTE_CATEGORY => NULL,
146: X_ATTRIBUTE1 => NULL,
147: X_ATTRIBUTE2 => NULL,
148: X_ATTRIBUTE3 => NULL,

Line 187: P_OWNER_TABLE_NAME => 'HZ_PARTIES',

183: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(
184: P_ACTION => 'INSERT',
185: P_ROWID => l_rowid,
186: P_STATUS => 'A',
187: P_OWNER_TABLE_NAME => 'HZ_PARTIES',
188: P_OWNER_TABLE_ID => L_PERSON_ID,
189: P_PRIMARY_FLAG => 'Y',
190: P_PHONE_COUNTRY_CODE => NULL,
191: P_PHONE_AREA_CODE => NULL,

Line 245: P_OWNER_TABLE_NAME => 'HZ_PARTIES',

241: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP (
242: P_ACTION =>'UPDATE',
243: P_ROWID => V_PHONE_UPDATE_REC.ROW_ID,
244: P_STATUS => 'A',
245: P_OWNER_TABLE_NAME => 'HZ_PARTIES',
246: P_OWNER_TABLE_ID => P_PERSON_ID,
247: P_PRIMARY_FLAG => 'Y',
248: P_PHONE_COUNTRY_CODE => V_PHONE_UPDATE_REC.PHONE_COUNTRY_CODE,
249: P_PHONE_AREA_CODE => V_PHONE_UPDATE_REC.PHONE_AREA_CODE,

Line 294: P_OWNER_TABLE_NAME => 'HZ_PARTIES',

290: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
291: P_ACTION =>'INSERT',
292: P_ROWID => l_rowid,
293: P_STATUS => 'A',
294: P_OWNER_TABLE_NAME => 'HZ_PARTIES',
295: P_OWNER_TABLE_ID => L_PERSON_ID,
296: P_PRIMARY_FLAG => 'Y',
297: P_EMAIL_FORMAT => 'MAILTEXT',
298: P_EMAIL_ADDRESS => P_EMAIL_ADDRESS,

Line 354: P_OWNER_TABLE_NAME => 'HZ_PARTIES',

350: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
351: P_ACTION => 'UPDATE',
352: P_ROWID => V_EMAIL_UPDATE_REC.ROW_ID,
353: P_STATUS => 'A',
354: P_OWNER_TABLE_NAME => 'HZ_PARTIES',
355: P_OWNER_TABLE_ID => P_PERSON_ID,
356: P_PRIMARY_FLAG => 'Y',
357: P_EMAIL_FORMAT => V_EMAIL_UPDATE_REC.EMAIL_FORMAT,
358: P_EMAIL_ADDRESS => l_EMAIL_ADDRESS,