APPS.IGS_AD_EMP_DTL_PKG dependencies on IGS_AD_HZ_EMP_DTL

Line 11: Called the igs_ad_hz_emp_dtl_pkg.add_row instead of update_row as per value in

7:
8: ssawhney 7 may 2002 Bug 2338473 -- allow for more than one HZ error to appear.
9: gmaheswa 6 Nov 2003 HZ.K Impact Changes.
10: pkpatel 14 Jul 2005 Bug 4327807 (Person SS Enhancement)
11: Called the igs_ad_hz_emp_dtl_pkg.add_row instead of update_row as per value in
12: Occupitional Title Code
13: */
14: l_rowid VARCHAR2(25);
15: l_msg_data VARCHAR2(25);

Line 61: x_hz_emp_dtl_id igs_ad_hz_emp_dtl.hz_emp_dtl_id%TYPE;

57: X_LAST_UPDATE_DATE DATE ;
58: X_LAST_UPDATED_BY NUMBER ;
59: X_LAST_UPDATE_LOGIN NUMBER ;
60:
61: x_hz_emp_dtl_id igs_ad_hz_emp_dtl.hz_emp_dtl_id%TYPE;
62: x_rowid1 VARCHAR2(25);
63: l_emp_history_rec HZ_PERSON_INFO_V2PUB.employment_history_rec_type;
64: l_msg_count NUMBER;
65: lrow_id varchar2(30);

Line 185: igs_ad_hz_emp_dtl_pkg.insert_row(

181: x_object_version_number := 1;
182:
183: --Type_pf_employment,fraction_of_employment,tenure_of_employment,weekly_work_hours,comments are mde obsolete
184: -- as they are passed to HZ_API's
185: igs_ad_hz_emp_dtl_pkg.insert_row(
186: X_ROWID => lrow_id,
187: X_HZ_EMP_DTL_ID => x_hz_emp_dtl_id,
188: X_EMPLOYMENT_HISTORY_ID => x_employment_history_id,
189: X_TYPE_OF_EMPLOYMENT => null,

Line 232: l_hz_emp_dtl_id igs_ad_hz_emp_dtl.hz_emp_dtl_id%TYPE;

228: x_reason_for_leaving IN VARCHAR2,
229: X_MODE in VARCHAR2 default 'R'
230: ) AS
231:
232: l_hz_emp_dtl_id igs_ad_hz_emp_dtl.hz_emp_dtl_id%TYPE;
233: l_LAST_UPDATED_BY NUMBER ;
234: l_LAST_UPDATE_LOGIN NUMBER ;
235: l_msg_count NUMBER;
236: l_emp_history_rec HZ_PERSON_INFO_V2PUB.employment_history_rec_type;

Line 245: FROM igs_ad_hz_emp_dtl

241: tmp_var VARCHAR2(2000);
242:
243: CURSOR C2 is
244: SELECT rowid,hz_emp_dtl_id, occupational_title_code
245: FROM igs_ad_hz_emp_dtl
246: WHERE employment_history_id = x_employment_history_id;
247:
248: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
249: WHERE party_id = x_person_id AND effective_end_Date is null;

Line 342: igs_ad_hz_emp_dtl_pkg.add_row(

338:
339: --Type_pf_employment,fraction_of_employment,tenure_of_employment,weekly_work_hours,comments are mde obsolete
340: -- as they are passed to HZ_API's
341: IF NVL(l_occupational_title_code, '-1') <> NVL(x_occupational_title_code, '-1') THEN
342: igs_ad_hz_emp_dtl_pkg.add_row(
343: X_ROWID => lv_rowid,
344: X_HZ_EMP_DTL_ID => l_hz_emp_dtl_id,
345: X_EMPLOYMENT_HISTORY_ID => x_employment_history_id,
346: X_TYPE_OF_EMPLOYMENT => null, --x_type_of_employment,

Line 375: igs_ad_hz_emp_dtl_pkg.delete_row(x_rowid);

371: procedure DELETE_ROW (
372: X_ROWID in VARCHAR2
373: ) AS
374: Begin
375: igs_ad_hz_emp_dtl_pkg.delete_row(x_rowid);
376: end DELETE_ROW;
377:
378:
379: END igs_ad_emp_dtl_pkg;