APPS.IGS_PE_EIT_PKG dependencies on IGS_PE_EIT

Line 1: PACKAGE BODY igs_pe_eit_pkg AS

1: PACKAGE BODY igs_pe_eit_pkg AS
2: /* $Header: IGSNI87B.pls 120.4 2005/10/17 02:21:58 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_eit%ROWTYPE;

Line 5: old_references igs_pe_eit%ROWTYPE;

1: PACKAGE BODY igs_pe_eit_pkg AS
2: /* $Header: IGSNI87B.pls 120.4 2005/10/17 02:21:58 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_eit%ROWTYPE;
6: new_references igs_pe_eit%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_eit%ROWTYPE;

2: /* $Header: IGSNI87B.pls 120.4 2005/10/17 02:21:58 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_eit%ROWTYPE;
6: new_references igs_pe_eit%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 39: FROM igs_pe_eit

35: */
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM igs_pe_eit
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 162: FROM igs_pe_eit

158: || (reverse chronological order - newest change first)
159: */
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM igs_pe_eit
163: WHERE pe_eit_id = x_pe_eit_id
164: FOR UPDATE NOWAIT;
165:
166: lv_rowid cur_rowid%RowType;

Line 199: FROM igs_pe_eit

195: || (reverse chronological order - newest change first)
196: */
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igs_pe_eit
200: WHERE person_id = x_person_id
201: AND information_type = x_information_type
202: AND start_date = x_start_date
203: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 236: FROM igs_pe_eit

232: || (reverse chronological order - newest change first)
233: */
234: CURSOR cur_rowid IS
235: SELECT rowid
236: FROM igs_pe_eit
237: WHERE ((person_id = x_party_id));
238:
239: lv_rowid cur_rowid%RowType;
240:

Line 286: FROM igs_pe_eit

282:
283: CURSOR validate_dt_overlap(cp_person_id NUMBER, cp_pe_eit_id NUMBER, cp_information_type VARCHAR2,
284: cp_start_date DATE, cp_end_date DATE) IS
285: SELECT 'X'
286: FROM igs_pe_eit
287: WHERE person_id= cp_person_id
288: AND information_type = cp_information_type
289: AND cp_pe_eit_id <> pe_eit_id
290: AND (cp_start_date between start_date AND NVL(end_date,l_default_date)

Line 462: FROM igs_pe_eit

458: || (reverse chronological order - newest change first)
459: */
460: CURSOR c IS
461: SELECT rowid
462: FROM igs_pe_eit
463: WHERE pe_eit_id = x_pe_eit_id;
464:
465: x_last_update_date DATE;
466: x_last_updated_by NUMBER;

Line 490: SELECT igs_pe_eit_s.NEXTVAL

486: igs_ge_msg_stack.add;
487: app_exception.raise_exception;
488: END IF;
489:
490: SELECT igs_pe_eit_s.NEXTVAL
491: INTO x_pe_eit_id
492: FROM dual;
493:
494: before_dml(

Line 517: INSERT INTO igs_pe_eit (

513:
514: IF (x_mode = 'S') THEN
515: igs_sc_gen_001.set_ctx('R');
516: END IF;
517: INSERT INTO igs_pe_eit (
518: pe_eit_id,
519: person_id,
520: information_type,
521: pei_information1,

Line 612: FROM igs_pe_eit

608: pei_information4,
609: pei_information5,
610: start_date,
611: end_date
612: FROM igs_pe_eit
613: WHERE rowid = x_rowid
614: FOR UPDATE NOWAIT;
615:
616: tlinfo c1%ROWTYPE;

Line 725: UPDATE igs_pe_eit

721:
722: IF (x_mode = 'S') THEN
723: igs_sc_gen_001.set_ctx('R');
724: END IF;
725: UPDATE igs_pe_eit
726: SET
727: person_id = new_references.person_id,
728: information_type = new_references.information_type,
729: pei_information1 = new_references.pei_information1,

Line 793: FROM igs_pe_eit

789: || (reverse chronological order - newest change first)
790: */
791: CURSOR c1 IS
792: SELECT rowid
793: FROM igs_pe_eit
794: WHERE pe_eit_id = x_pe_eit_id;
795:
796: BEGIN
797:

Line 862: DELETE FROM igs_pe_eit

858:
859: IF (x_mode = 'S') THEN
860: igs_sc_gen_001.set_ctx('R');
861: END IF;
862: DELETE FROM igs_pe_eit
863: WHERE rowid = x_rowid;
864:
865: IF (SQL%NOTFOUND) THEN
866: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 879: END igs_pe_eit_pkg;

875:
876: END delete_row;
877:
878:
879: END igs_pe_eit_pkg;