APPS.IGS_HE_SUB_RTN_QUAL_PKG dependencies on IGS_HE_SUB_RTN_QUAL

Line 1: PACKAGE BODY igs_he_sub_rtn_qual_pkg AS

1: PACKAGE BODY igs_he_sub_rtn_qual_pkg AS
2: /* $Header: IGSWI37B.pls 115.0 2003/04/29 09:14:41 pmarada noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sub_rtn_qual%ROWTYPE;

Line 5: old_references igs_he_sub_rtn_qual%ROWTYPE;

1: PACKAGE BODY igs_he_sub_rtn_qual_pkg AS
2: /* $Header: IGSWI37B.pls 115.0 2003/04/29 09:14:41 pmarada noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sub_rtn_qual%ROWTYPE;
6: new_references igs_he_sub_rtn_qual%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_sub_rtn_qual%ROWTYPE;

2: /* $Header: IGSWI37B.pls 115.0 2003/04/29 09:14:41 pmarada noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_sub_rtn_qual%ROWTYPE;
6: new_references igs_he_sub_rtn_qual%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 41: FROM igs_he_sub_rtn_qual

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

Line 134: igs_he_stdnt_dlhe_pkg.get_fk_igs_he_sub_rtn_qual (

130: || (reverse chronological order - newest change first)
131: */
132: BEGIN
133:
134: igs_he_stdnt_dlhe_pkg.get_fk_igs_he_sub_rtn_qual (
135: old_references.submission_name,
136: old_references.user_return_subclass,
137: old_references.return_name,
138: old_references.qual_period_code

Line 161: FROM igs_he_sub_rtn_qual

157: || (reverse chronological order - newest change first)
158: */
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM igs_he_sub_rtn_qual
162: WHERE submission_name = x_submission_name
163: AND user_return_subclass = x_user_return_subclass
164: AND return_name = x_return_name
165: AND qual_period_code = x_qual_period_code

Line 201: FROM igs_he_sub_rtn_qual

197: || (reverse chronological order - newest change first)
198: */
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM igs_he_sub_rtn_qual
202: WHERE ((return_name = x_return_name) AND
203: (submission_name = x_submission_name) AND
204: (user_return_subclass = x_user_return_subclass));
205:

Line 366: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUB_RTN_QUAL_PKG.INSERT_ROW');

362: x_last_update_login := -1;
363: END IF;
364: ELSE
365: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
366: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUB_RTN_QUAL_PKG.INSERT_ROW');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370:

Line 393: INSERT INTO igs_he_sub_rtn_qual (

389: x_last_updated_by => x_last_updated_by,
390: x_last_update_login => x_last_update_login
391: );
392:
393: INSERT INTO igs_he_sub_rtn_qual (
394: submission_name,
395: user_return_subclass,
396: return_name,
397: qual_period_code,

Line 468: FROM igs_he_sub_rtn_qual

464: census_date,
465: survey_start_date,
466: survey_end_date,
467: closed_ind
468: FROM igs_he_sub_rtn_qual
469: WHERE rowid = x_rowid
470: FOR UPDATE NOWAIT;
471:
472: tlinfo c1%ROWTYPE;

Line 555: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUB_RTN_QUAL_PKG.UPDATE_ROW');

551: x_last_update_login := -1;
552: END IF;
553: ELSE
554: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
555: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUB_RTN_QUAL_PKG.UPDATE_ROW');
556: igs_ge_msg_stack.add;
557: app_exception.raise_exception;
558: END IF;
559:

Line 582: UPDATE igs_he_sub_rtn_qual

578: x_last_updated_by => x_last_updated_by,
579: x_last_update_login => x_last_update_login
580: );
581:
582: UPDATE igs_he_sub_rtn_qual
583: SET
584: qual_period_desc = new_references.qual_period_desc,
585: qual_period_type = new_references.qual_period_type,
586: qual_period_start_date = new_references.qual_period_start_date,

Line 631: FROM igs_he_sub_rtn_qual

627: || (reverse chronological order - newest change first)
628: */
629: CURSOR c1 IS
630: SELECT rowid
631: FROM igs_he_sub_rtn_qual
632: WHERE submission_name = x_submission_name
633: AND user_return_subclass = x_user_return_subclass
634: AND return_name = x_return_name
635: AND qual_period_code = x_qual_period_code;

Line 703: DELETE FROM igs_he_sub_rtn_qual

699: p_action => 'DELETE',
700: x_rowid => x_rowid
701: );
702:
703: DELETE FROM igs_he_sub_rtn_qual
704: WHERE rowid = x_rowid;
705:
706: IF (SQL%NOTFOUND) THEN
707: RAISE NO_DATA_FOUND;

Line 713: END igs_he_sub_rtn_qual_pkg;

709:
710: END delete_row;
711:
712:
713: END igs_he_sub_rtn_qual_pkg;