APPS.IGS_HE_EXT_RUN_DTLS_PKG dependencies on IGS_HE_EXT_RUN_DTLS

Line 1: PACKAGE BODY igs_he_ext_run_dtls_pkg AS

1: PACKAGE BODY igs_he_ext_run_dtls_pkg AS
2: /* $Header: IGSWI06B.pls 115.9 2002/12/20 08:46:30 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ext_run_dtls%ROWTYPE;

Line 5: old_references igs_he_ext_run_dtls%ROWTYPE;

1: PACKAGE BODY igs_he_ext_run_dtls_pkg AS
2: /* $Header: IGSWI06B.pls 115.9 2002/12/20 08:46:30 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ext_run_dtls%ROWTYPE;
6: new_references igs_he_ext_run_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ext_run_dtls%ROWTYPE;

2: /* $Header: IGSWI06B.pls 115.9 2002/12/20 08:46:30 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ext_run_dtls%ROWTYPE;
6: new_references igs_he_ext_run_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 44: FROM IGS_HE_EXT_RUN_DTLS

40: */
41:
42: CURSOR cur_old_ref_values IS
43: SELECT *
44: FROM IGS_HE_EXT_RUN_DTLS
45: WHERE rowid = x_rowid;
46:
47: BEGIN
48:

Line 140: igs_he_ext_run_prms_pkg.get_fk_igs_he_ext_run_dtls (

136: || (reverse chronological order - newest change first)
137: */
138: BEGIN
139:
140: igs_he_ext_run_prms_pkg.get_fk_igs_he_ext_run_dtls (
141: old_references.extract_run_id
142: );
143:
144: igs_he_ex_rn_dat_ln_pkg.get_fk_igs_he_ext_run_dtls (

Line 144: igs_he_ex_rn_dat_ln_pkg.get_fk_igs_he_ext_run_dtls (

140: igs_he_ext_run_prms_pkg.get_fk_igs_he_ext_run_dtls (
141: old_references.extract_run_id
142: );
143:
144: igs_he_ex_rn_dat_ln_pkg.get_fk_igs_he_ext_run_dtls (
145: old_references.extract_run_id
146: );
147:
148: END check_child_existance;

Line 165: FROM igs_he_ext_run_dtls

161: || (reverse chronological order - newest change first)
162: */
163: CURSOR cur_rowid IS
164: SELECT rowid
165: FROM igs_he_ext_run_dtls
166: WHERE extract_run_id = x_extract_run_id
167: FOR UPDATE NOWAIT;
168:
169: lv_rowid cur_rowid%RowType;

Line 202: FROM igs_he_ext_run_dtls

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

Line 350: FROM igs_he_ext_run_dtls

346: || (reverse chronological order - newest change first)
347: */
348: CURSOR c IS
349: SELECT rowid
350: FROM igs_he_ext_run_dtls
351: WHERE extract_run_id = x_extract_run_id;
352:
353: x_last_update_date DATE;
354: x_last_updated_by NUMBER;

Line 378: SELECT igs_he_ext_run_dtls_run_id_s.NEXTVAL

374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377:
378: SELECT igs_he_ext_run_dtls_run_id_s.NEXTVAL
379: INTO x_extract_run_id
380: FROM dual;
381:
382: before_dml(

Line 407: INSERT INTO igs_he_ext_run_dtls (

403: x_last_updated_by => x_last_updated_by,
404: x_last_update_login => x_last_update_login
405: );
406:
407: INSERT INTO igs_he_ext_run_dtls (
408: extract_run_id,
409: submission_name,
410: user_return_subclass,
411: return_name,

Line 505: FROM igs_he_ext_run_dtls

501: extract_override,
502: validation_kit_result,
503: hesa_validation_result,
504: student_ext_run_id
505: FROM igs_he_ext_run_dtls
506: WHERE rowid = x_rowid
507: FOR UPDATE NOWAIT;
508:
509: tlinfo c1%ROWTYPE;

Line 630: UPDATE igs_he_ext_run_dtls

626: x_last_updated_by => x_last_updated_by,
627: x_last_update_login => x_last_update_login
628: );
629:
630: UPDATE igs_he_ext_run_dtls
631: SET
632: submission_name = new_references.submission_name,
633: user_return_subclass = new_references.user_return_subclass,
634: return_name = new_references.return_name,

Line 688: FROM igs_he_ext_run_dtls

684: || (reverse chronological order - newest change first)
685: */
686: CURSOR c1 IS
687: SELECT rowid
688: FROM igs_he_ext_run_dtls
689: WHERE extract_run_id = x_extract_run_id;
690:
691: BEGIN
692:

Line 763: DELETE FROM igs_he_ext_run_dtls

759: p_action => 'DELETE',
760: x_rowid => x_rowid
761: );
762:
763: DELETE FROM igs_he_ext_run_dtls
764: WHERE rowid = x_rowid;
765:
766: IF (SQL%NOTFOUND) THEN
767: RAISE NO_DATA_FOUND;

Line 773: END igs_he_ext_run_dtls_pkg;

769:
770: END delete_row;
771:
772:
773: END igs_he_ext_run_dtls_pkg;