APPS.IGS_PE_NONIMG_EMPL_PKG dependencies on IGS_PE_NONIMG_EMPL

Line 1: PACKAGE BODY igs_pe_nonimg_empl_pkg AS

1: PACKAGE BODY igs_pe_nonimg_empl_pkg AS
2: /* $Header: IGSNIA8B.pls 120.2 2006/02/17 06:57:01 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_nonimg_empl%ROWTYPE;

Line 5: old_references igs_pe_nonimg_empl%ROWTYPE;

1: PACKAGE BODY igs_pe_nonimg_empl_pkg AS
2: /* $Header: IGSNIA8B.pls 120.2 2006/02/17 06:57:01 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_nonimg_empl%ROWTYPE;
6: new_references igs_pe_nonimg_empl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_nonimg_empl%ROWTYPE;

2: /* $Header: IGSNIA8B.pls 120.2 2006/02/17 06:57:01 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_nonimg_empl%ROWTYPE;
6: new_references igs_pe_nonimg_empl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 42: FROM igs_pe_nonimg_empl

38: */
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM igs_pe_nonimg_empl
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 127: FROM igs_pe_nonimg_empl

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

Line 162: FROM igs_pe_nonimg_empl

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

Line 341: INSERT INTO igs_pe_nonimg_empl (

337:
338: IF (x_mode = 'S') THEN
339: igs_sc_gen_001.set_ctx('R');
340: END IF;
341: INSERT INTO igs_pe_nonimg_empl (
342: nonimg_empl_id,
343: nonimg_form_id,
344: empl_type,
345: recommend_empl,

Line 361: igs_pe_nonimg_empl_s.NEXTVAL,

357: last_update_login,
358: action_code,
359: print_flag
360: ) VALUES (
361: igs_pe_nonimg_empl_s.NEXTVAL,
362: new_references.nonimg_form_id,
363: new_references.empl_type,
364: new_references.recommend_empl,
365: new_references.rescind_empl,

Line 440: FROM igs_pe_nonimg_empl

436: empl_time,
437: empl_party_id,
438: action_code,
439: print_flag
440: FROM igs_pe_nonimg_empl
441: WHERE rowid = x_rowid
442: FOR UPDATE NOWAIT;
443:
444: tlinfo c1%ROWTYPE;

Line 562: UPDATE igs_pe_nonimg_empl

558:
559: IF (x_mode = 'S') THEN
560: igs_sc_gen_001.set_ctx('R');
561: END IF;
562: UPDATE igs_pe_nonimg_empl
563: SET
564: nonimg_form_id = new_references.nonimg_form_id,
565: empl_type = new_references.empl_type,
566: recommend_empl = new_references.recommend_empl,

Line 636: FROM igs_pe_nonimg_empl

632: || (reverse chronological order - newest change first)
633: */
634: CURSOR c1 IS
635: SELECT rowid
636: FROM igs_pe_nonimg_empl
637: WHERE nonimg_empl_id = x_nonimg_empl_id;
638:
639: BEGIN
640:

Line 711: DELETE FROM igs_pe_nonimg_empl

707:
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.set_ctx('R');
710: END IF;
711: DELETE FROM igs_pe_nonimg_empl
712: WHERE rowid = x_rowid;
713:
714: IF (SQL%NOTFOUND) THEN
715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 728: END igs_pe_nonimg_empl_pkg;

724:
725: END delete_row;
726:
727:
728: END igs_pe_nonimg_empl_pkg;