APPS.IGS_PE_FUND_EXCL_PKG dependencies on IGS_PE_FUND_EXCL

Line 1: PACKAGE BODY igs_pe_fund_excl_pkg AS

1: PACKAGE BODY igs_pe_fund_excl_pkg AS
2: /* $Header: IGSNI98B.pls 115.4 2002/11/29 01:37:42 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_fund_excl%ROWTYPE;

Line 5: old_references igs_pe_fund_excl%ROWTYPE;

1: PACKAGE BODY igs_pe_fund_excl_pkg AS
2: /* $Header: IGSNI98B.pls 115.4 2002/11/29 01:37:42 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_fund_excl%ROWTYPE;
6: new_references igs_pe_fund_excl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_fund_excl%ROWTYPE;

2: /* $Header: IGSNI98B.pls 115.4 2002/11/29 01:37:42 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_fund_excl%ROWTYPE;
6: new_references igs_pe_fund_excl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 39: FROM igs_pe_fund_excl

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

Line 183: FROM igs_pe_fund_excl

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igs_pe_fund_excl
184: WHERE fund_excl_id = x_fund_excl_id
185: FOR UPDATE NOWAIT;
186:
187: lv_rowid cur_rowid%RowType;

Line 225: FROM igs_pe_fund_excl

221: || (reverse chronological order - newest change first)
222: */
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM igs_pe_fund_excl
226: WHERE person_id = x_person_id
227: AND encumbrance_type = x_encumbrance_type
228: AND pen_start_dt = x_pen_start_dt
229: AND s_encmb_effect_type = x_s_encmb_effect_type

Line 267: FROM igs_pe_fund_excl

263: || (reverse chronological order - newest change first)
264: */
265: CURSOR cur_rowid IS
266: SELECT rowid
267: FROM igs_pe_fund_excl
268: WHERE ((fund_code = x_fund_code));
269:
270: lv_rowid cur_rowid%RowType;
271:

Line 307: FROM igs_pe_fund_excl

303: || (reverse chronological order - newest change first)
304: */
305: CURSOR cur_rowid IS
306: SELECT rowid
307: FROM igs_pe_fund_excl
308: WHERE ((encumbrance_type = x_encumbrance_type) AND
309: (pee_sequence_number = x_sequence_number) AND
310: (pee_start_dt = x_pee_start_dt) AND
311: (pen_start_dt = x_pen_start_dt) AND

Line 415: FROM igs_pe_fund_excl

411: l_check VARCHAR2(1);
412:
413: CURSOR fund_exclusion_cur IS
414: SELECT 'X'
415: FROM igs_pe_fund_excl
416: WHERE person_id = new_references.person_id AND
417: encumbrance_type = new_references.encumbrance_type AND
418: pen_start_dt = new_references.pen_start_dt AND
419: s_encmb_effect_type = new_references.s_encmb_effect_type AND

Line 431: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_FUND_EXCL_OPEN');

427: OPEN fund_exclusion_cur;
428: FETCH fund_exclusion_cur INTO l_check;
429: IF fund_exclusion_cur%FOUND THEN
430: CLOSE fund_exclusion_cur;
431: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_FUND_EXCL_OPEN');
432: IGS_GE_MSG_STACK.ADD;
433: APP_EXCEPTION.RAISE_EXCEPTION;
434: END IF;
435: CLOSE fund_exclusion_cur;

Line 642: INSERT INTO igs_pe_fund_excl (

638: x_last_updated_by => x_last_updated_by,
639: x_last_update_login => x_last_update_login
640: );
641:
642: INSERT INTO igs_pe_fund_excl (
643: fund_excl_id,
644: person_id,
645: encumbrance_type,
646: pen_start_dt,

Line 659: igs_pe_fund_excl_s.NEXTVAL,

655: last_update_date,
656: last_updated_by,
657: last_update_login
658: ) VALUES (
659: igs_pe_fund_excl_s.NEXTVAL,
660: new_references.person_id,
661: new_references.encumbrance_type,
662: new_references.pen_start_dt,
663: new_references.s_encmb_effect_type,

Line 720: FROM igs_pe_fund_excl

716: pee_sequence_number,
717: fund_code,
718: pfe_start_dt,
719: expiry_dt
720: FROM igs_pe_fund_excl
721: WHERE rowid = x_rowid
722: FOR UPDATE NOWAIT;
723:
724: tlinfo c1%ROWTYPE;

Line 830: UPDATE igs_pe_fund_excl

826: x_last_updated_by => x_last_updated_by,
827: x_last_update_login => x_last_update_login
828: );
829:
830: UPDATE igs_pe_fund_excl
831: SET
832: person_id = new_references.person_id,
833: encumbrance_type = new_references.encumbrance_type,
834: pen_start_dt = new_references.pen_start_dt,

Line 882: FROM igs_pe_fund_excl

878: || (reverse chronological order - newest change first)
879: */
880: CURSOR c1 IS
881: SELECT rowid
882: FROM igs_pe_fund_excl
883: WHERE fund_excl_id = x_fund_excl_id;
884:
885: BEGIN
886:

Line 947: DELETE FROM igs_pe_fund_excl

943: p_action => 'DELETE',
944: x_rowid => x_rowid
945: );
946:
947: DELETE FROM igs_pe_fund_excl
948: WHERE rowid = x_rowid;
949:
950: IF (SQL%NOTFOUND) THEN
951: RAISE NO_DATA_FOUND;

Line 957: END igs_pe_fund_excl_pkg;

953:
954: END delete_row;
955:
956:
957: END igs_pe_fund_excl_pkg;