APPS.IGS_HE_STDNT_DLHE_PKG dependencies on IGS_HE_STDNT_DLHE

Line 1: PACKAGE BODY igs_he_stdnt_dlhe_pkg AS

1: PACKAGE BODY igs_he_stdnt_dlhe_pkg AS
2: /* $Header: IGSWI38B.pls 120.1 2005/08/31 22:52:29 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_stdnt_dlhe%ROWTYPE;

Line 5: old_references igs_he_stdnt_dlhe%ROWTYPE;

1: PACKAGE BODY igs_he_stdnt_dlhe_pkg AS
2: /* $Header: IGSWI38B.pls 120.1 2005/08/31 22:52:29 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_stdnt_dlhe%ROWTYPE;
6: new_references igs_he_stdnt_dlhe%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_stdnt_dlhe%ROWTYPE;

2: /* $Header: IGSWI38B.pls 120.1 2005/08/31 22:52:29 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_stdnt_dlhe%ROWTYPE;
6: new_references igs_he_stdnt_dlhe%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 110: FROM igs_he_stdnt_dlhe

106: */
107:
108: CURSOR cur_old_ref_values IS
109: SELECT *
110: FROM igs_he_stdnt_dlhe
111: WHERE rowid = x_rowid;
112:
113: BEGIN
114:

Line 279: FROM igs_he_stdnt_dlhe

275: || (reverse chronological order - newest change first)
276: */
277: CURSOR cur_rowid IS
278: SELECT rowid
279: FROM igs_he_stdnt_dlhe
280: WHERE submission_name = x_submission_name
281: AND return_name = x_return_name
282: AND person_id = x_person_id
283: FOR UPDATE NOWAIT;

Line 319: FROM igs_he_stdnt_dlhe

315: || (reverse chronological order - newest change first)
316: */
317: CURSOR cur_rowid IS
318: SELECT rowid
319: FROM igs_he_stdnt_dlhe
320: WHERE ((qual_period_code = x_qual_period_code) AND
321: (return_name = x_return_name) AND
322: (submission_name = x_submission_name) AND
323: (user_return_subclass = x_user_return_subclass));

Line 685: fnd_message.set_token ('ROUTINE', 'IGS_HE_STDNT_DLHE_PKG.INSERT_ROW');

681: x_last_update_login := -1;
682: END IF;
683: ELSE
684: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
685: fnd_message.set_token ('ROUTINE', 'IGS_HE_STDNT_DLHE_PKG.INSERT_ROW');
686: igs_ge_msg_stack.add;
687: app_exception.raise_exception;
688: END IF;
689:

Line 781: INSERT INTO igs_he_stdnt_dlhe (

777: x_last_updated_by => x_last_updated_by,
778: x_last_update_login => x_last_update_login
779: );
780:
781: INSERT INTO igs_he_stdnt_dlhe (
782: person_id,
783: submission_name,
784: user_return_subclass,
785: return_name,

Line 1133: FROM igs_he_stdnt_dlhe

1129: employer_support3,
1130: employer_support4,
1131: employer_support5,
1132: popdlhe_flag
1133: FROM igs_he_stdnt_dlhe
1134: WHERE rowid = x_rowid
1135: FOR UPDATE NOWAIT;
1136:
1137: tlinfo c1%ROWTYPE;

Line 1359: fnd_message.set_token ('ROUTINE', 'IGS_HE_STDNT_DLHE_PKG.UPDATE_ROW');

1355: x_last_update_login := -1;
1356: END IF;
1357: ELSE
1358: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1359: fnd_message.set_token ('ROUTINE', 'IGS_HE_STDNT_DLHE_PKG.UPDATE_ROW');
1360: igs_ge_msg_stack.add;
1361: app_exception.raise_exception;
1362: END IF;
1363:

Line 1455: UPDATE igs_he_stdnt_dlhe

1451: x_last_updated_by => x_last_updated_by,
1452: x_last_update_login => x_last_update_login
1453: );
1454:
1455: UPDATE igs_he_stdnt_dlhe
1456: SET
1457: user_return_subclass = new_references.user_return_subclass,
1458: qual_period_code = new_references.qual_period_code,
1459: dlhe_record_status = new_references.dlhe_record_status,

Line 1643: FROM igs_he_stdnt_dlhe

1639: || (reverse chronological order - newest change first)
1640: */
1641: CURSOR c1 IS
1642: SELECT rowid
1643: FROM igs_he_stdnt_dlhe
1644: WHERE submission_name = x_submission_name
1645: AND return_name = x_return_name
1646: AND person_id = x_person_id;
1647:

Line 1852: DELETE FROM igs_he_stdnt_dlhe

1848: p_action => 'DELETE',
1849: x_rowid => x_rowid
1850: );
1851:
1852: DELETE FROM igs_he_stdnt_dlhe
1853: WHERE rowid = x_rowid;
1854:
1855: IF (SQL%NOTFOUND) THEN
1856: RAISE NO_DATA_FOUND;

Line 1862: END igs_he_stdnt_dlhe_pkg;

1858:
1859: END delete_row;
1860:
1861:
1862: END igs_he_stdnt_dlhe_pkg;