APPS.IGS_AD_HZ_EMP_DTL_PKG dependencies on IGS_AD_HZ_EMP_DTL

Line 1: PACKAGE BODY igs_ad_hz_emp_dtl_pkg AS

1: PACKAGE BODY igs_ad_hz_emp_dtl_pkg AS
2: /* $Header: IGSAIB8B.pls 120.1 2005/06/28 04:30:42 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_hz_emp_dtl%ROWTYPE;

Line 5: old_references igs_ad_hz_emp_dtl%ROWTYPE;

1: PACKAGE BODY igs_ad_hz_emp_dtl_pkg AS
2: /* $Header: IGSAIB8B.pls 120.1 2005/06/28 04:30:42 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_hz_emp_dtl%ROWTYPE;
6: new_references igs_ad_hz_emp_dtl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_hz_emp_dtl%ROWTYPE;

2: /* $Header: IGSAIB8B.pls 120.1 2005/06/28 04:30:42 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_hz_emp_dtl%ROWTYPE;
6: new_references igs_ad_hz_emp_dtl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM IGS_AD_HZ_EMP_DTL

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_AD_HZ_EMP_DTL
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 128: FROM igs_ad_hz_emp_dtl

124: || (reverse chronological order - newest change first)
125: */
126: CURSOR cur_rowid IS
127: SELECT rowid
128: FROM igs_ad_hz_emp_dtl
129: WHERE hz_emp_dtl_id = x_hz_emp_dtl_id
130: FOR UPDATE NOWAIT;
131:
132: lv_rowid cur_rowid%RowType;

Line 162: FROM igs_ad_hz_emp_dtl

158: || (reverse chronological order - newest change first)
159: */
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM igs_ad_hz_emp_dtl
163: WHERE ((employment_history_id = x_employment_history_id));
164:
165: lv_rowid cur_rowid%RowType;
166:

Line 286: FROM igs_ad_hz_emp_dtl

282: || (reverse chronological order - newest change first)
283: */
284: CURSOR c IS
285: SELECT rowid
286: FROM igs_ad_hz_emp_dtl
287: WHERE hz_emp_dtl_id = x_hz_emp_dtl_id ;
288:
289: x_last_update_date DATE;
290: x_last_updated_by NUMBER;

Line 336: INSERT INTO igs_ad_hz_emp_dtl (

332:
333: IF (x_mode = 'S') THEN
334: igs_sc_gen_001.set_ctx('R');
335: END IF;
336: INSERT INTO igs_ad_hz_emp_dtl (
337: hz_emp_dtl_id,
338: employment_history_id,
339: type_of_employment,
340: fracion_of_employment,

Line 351: IGS_AD_HZ_EMP_DTL_S.NEXTVAL,

347: last_update_date,
348: last_updated_by,
349: last_update_login
350: ) VALUES (
351: IGS_AD_HZ_EMP_DTL_S.NEXTVAL,
352: new_references.employment_history_id,
353: new_references.type_of_employment,
354: new_references.fracion_of_employment,
355: new_references.tenure_of_employment,

Line 424: FROM igs_ad_hz_emp_dtl

420: -- tenure_of_employment,
421: occupational_title_code
422: -- weekly_work_hours,
423: -- comments
424: FROM igs_ad_hz_emp_dtl
425: WHERE rowid = x_rowid
426: FOR UPDATE NOWAIT;
427:
428: tlinfo c1%ROWTYPE;

Line 527: UPDATE igs_ad_hz_emp_dtl

523:
524: IF (x_mode = 'S') THEN
525: igs_sc_gen_001.set_ctx('R');
526: END IF;
527: UPDATE igs_ad_hz_emp_dtl
528: SET
529: hz_emp_dtl_id = new_references.hz_emp_dtl_id,
530: employment_history_id = new_references.employment_history_id,
531: type_of_employment = new_references.type_of_employment,

Line 592: FROM igs_ad_hz_emp_dtl

588: || (reverse chronological order - newest change first)
589: */
590: CURSOR c1 IS
591: SELECT rowid
592: FROM igs_ad_hz_emp_dtl
593: WHERE hz_emp_dtl_id = x_hz_emp_dtl_id;
594:
595: BEGIN
596:

Line 659: DELETE FROM igs_ad_hz_emp_dtl

655:
656: IF (x_mode = 'S') THEN
657: igs_sc_gen_001.set_ctx('R');
658: END IF;
659: DELETE FROM igs_ad_hz_emp_dtl
660: WHERE rowid = x_rowid;
661:
662: IF (SQL%NOTFOUND) THEN
663: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 677: END igs_ad_hz_emp_dtl_pkg;

673: null;
674: END delete_row;
675:
676:
677: END igs_ad_hz_emp_dtl_pkg;