APPS.IGS_EN_SPLACEMENTS_API dependencies on IGS_AD_EMP_DTL

Line 37: Cursor cur_c1(c_person_id IN NUMBER, c_emp_hist_id IN NUMBER) IS SELECT * FROM IGS_AD_EMP_DTL

33: -- Description: Added ATTRIBUTES 21 TO 24 TO STORE ADDITIONAL INFORMATION
34: ---------------------------------------------------------------------
35:
36:
37: Cursor cur_c1(c_person_id IN NUMBER, c_emp_hist_id IN NUMBER) IS SELECT * FROM IGS_AD_EMP_DTL
38: WHERE person_id=c_person_id
39: AND employment_history_id=c_emp_hist_id;
40:
41: Cursor cur_c2 IS SELECT *

Line 81: l_employment_history_id IGS_AD_EMP_DTL.EMPLOYMENT_HISTORY_ID%TYPE := P_EMPLOYMENT_HISTORY_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;
85: v_phone_update_rec cur_c2%ROWTYPE;

Line 83: l_emp_obj_ver_no IGS_AD_EMP_DTL.OBJECT_VERSION_NUMBER%TYPE;

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;
85: v_phone_update_rec cur_c2%ROWTYPE;
86: v_email_update_rec cur_c3%ROWTYPE;
87: BEGIN

Line 402: IGS_AD_EMP_DTL_PKG.UPDATE_ROW (

398: OPEN cur_c1(l_person_id,p_employment_history_id);
399: FETCH cur_c1 INTO v_emp_hist_rec;
400:
401: IF cur_c1%FOUND THEN
402: IGS_AD_EMP_DTL_PKG.UPDATE_ROW (
403: X_ROWID => V_EMP_HIST_REC.ROW_ID,
404: X_EMPLOYMENT_HISTORY_ID => V_EMP_HIST_REC.EMPLOYMENT_HISTORY_ID,
405: X_PERSON_ID => l_PERSON_ID,
406: X_START_DT => V_EMP_HIST_REC.START_DT,

Line 433: IGS_AD_EMP_DTL_PKG.INSERT_ROW (

429: p_employment_history_id :=v_emp_hist_rec.EMPLOYMENT_HISTORY_ID;
430: CLOSE cur_c1;
431:
432: ELSE
433: IGS_AD_EMP_DTL_PKG.INSERT_ROW (
434: X_ROWID => L_ROWID,
435: X_EMPLOYMENT_HISTORY_ID => l_EMPLOYMENT_HISTORY_ID,
436: X_PERSON_ID => l_PERSON_ID,
437: X_START_DT => SYSDATE,