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_EN_SPLACEMENTS_API dependencies on HZ_CONTACT_POINTS

Line 72: l_last_update_date HZ_CONTACT_POINTS.LAST_UPDATE_DATE%TYPE :=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;
76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;

Line 73: l_contact_point_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE :=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;
76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;
77: l_phone_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_PHONE_OVN;

Line 74: l_contact_point_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE :=NULL;

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;
76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;
77: l_phone_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_PHONE_OVN;
78: l_email_address IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ADDRESS;

Line 75: l_phone HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE := P_PHONE;

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;
76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;
77: l_phone_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_PHONE_OVN;
78: l_email_address IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ADDRESS;
79: l_email_id IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ID;

Line 76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;

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;
76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;
77: l_phone_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_PHONE_OVN;
78: l_email_address IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ADDRESS;
79: l_email_id IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ID;
80: l_email_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_EMAIL_OVN;

Line 77: l_phone_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_PHONE_OVN;

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;
76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;
77: l_phone_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_PHONE_OVN;
78: l_email_address IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ADDRESS;
79: l_email_id IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ID;
80: l_email_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_EMAIL_OVN;
81: l_employment_history_id IGS_AD_EMP_DTL.EMPLOYMENT_HISTORY_ID%TYPE := P_EMPLOYMENT_HISTORY_ID;

Line 80: l_email_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_EMAIL_OVN;

76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;
77: l_phone_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_PHONE_OVN;
78: l_email_address IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ADDRESS;
79: l_email_id IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ID;
80: l_email_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_EMAIL_OVN;
81: l_employment_history_id IGS_AD_EMP_DTL.EMPLOYMENT_HISTORY_ID%TYPE := P_EMPLOYMENT_HISTORY_ID;
82:
83: l_emp_obj_ver_no IGS_AD_EMP_DTL.OBJECT_VERSION_NUMBER%TYPE;
84: v_emp_hist_rec cur_c1%ROWTYPE;

Line 183: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(

179: END IF;
180:
181: -- if phone number is not null but phone_id is null, new entry insert
182: IF P_PHONE IS NOT NULL AND P_PHONE_ID IS NULL THEN
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',

Line 239: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP with the action as updated

235: END IF;
236: END IF;
237:
238:
239: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP with the action as updated
240: IF cur_c2%FOUND AND (nvl(v_phone_update_rec.phone_number,'null')<>nvl(p_phone,'null')) THEN
241: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP (
242: P_ACTION =>'UPDATE',
243: P_ROWID => V_PHONE_UPDATE_REC.ROW_ID,

Line 241: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP (

237:
238:
239: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP with the action as updated
240: IF cur_c2%FOUND AND (nvl(v_phone_update_rec.phone_number,'null')<>nvl(p_phone,'null')) THEN
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',

Line 290: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(

286:
287: -- if email address is not null but email id is null, new record - insert
288: IF P_EMAIL_ADDRESS IS NOT NULL AND P_EMAIL_ID IS NULL THEN
289:
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',

Line 348: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE with the action as updated

344: ELSE
345: l_email_address:=p_email_address;
346: END IF;
347:
348: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE with the action as updated
349: IF cur_c3%FOUND AND (nvl(v_email_update_rec.email_address,'null')<>nvl(l_email_address,'null')) THEN
350: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
351: P_ACTION => 'UPDATE',
352: P_ROWID => V_EMAIL_UPDATE_REC.ROW_ID,

Line 350: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(

346: END IF;
347:
348: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE with the action as updated
349: IF cur_c3%FOUND AND (nvl(v_email_update_rec.email_address,'null')<>nvl(l_email_address,'null')) THEN
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',