APPS.IGS_HE_EX_RN_DAT_LN_PKG dependencies on IGS_HE_EX_RN_DAT_LN

Line 1: PACKAGE BODY igs_he_ex_rn_dat_ln_pkg AS

1: PACKAGE BODY igs_he_ex_rn_dat_ln_pkg AS
2: /* $Header: IGSWI09B.pls 115.10 2003/08/23 12:03:20 pmarada noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ex_rn_dat_ln%ROWTYPE;

Line 5: old_references igs_he_ex_rn_dat_ln%ROWTYPE;

1: PACKAGE BODY igs_he_ex_rn_dat_ln_pkg AS
2: /* $Header: IGSWI09B.pls 115.10 2003/08/23 12:03:20 pmarada noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ex_rn_dat_ln%ROWTYPE;
6: new_references igs_he_ex_rn_dat_ln%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ex_rn_dat_ln%ROWTYPE;

2: /* $Header: IGSWI09B.pls 115.10 2003/08/23 12:03:20 pmarada noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ex_rn_dat_ln%ROWTYPE;
6: new_references igs_he_ex_rn_dat_ln%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 42: FROM IGS_HE_EX_RN_DAT_LN

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

Line 130: igs_he_ex_rn_dat_fd_pkg.get_fk_igs_he_ex_rn_dat_ln (

126: || (reverse chronological order - newest change first)
127: */
128: BEGIN
129:
130: igs_he_ex_rn_dat_fd_pkg.get_fk_igs_he_ex_rn_dat_ln (
131: old_references.extract_run_id,
132: old_references.line_number
133: );
134:

Line 153: FROM igs_he_ex_rn_dat_ln

149: || (reverse chronological order - newest change first)
150: */
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igs_he_ex_rn_dat_ln
154: WHERE extract_run_id = x_extract_run_id
155: AND line_number = x_line_number
156: FOR UPDATE NOWAIT;
157:

Line 189: FROM igs_he_ex_rn_dat_ln

185: || (reverse chronological order - newest change first)
186: */
187: CURSOR cur_rowid IS
188: SELECT rowid
189: FROM igs_he_ex_rn_dat_ln
190: WHERE ((extract_run_id = x_extract_run_id));
191:
192: lv_rowid cur_rowid%RowType;
193:

Line 331: FROM igs_he_ex_rn_dat_ln

327: || (reverse chronological order - newest change first)
328: */
329: CURSOR c IS
330: SELECT rowid
331: FROM igs_he_ex_rn_dat_ln
332: WHERE extract_run_id = x_extract_run_id
333: AND line_number = x_line_number;
334:
335: x_last_update_date DATE;

Line 362: Select igs_he_ex_rn_dat_ln_s.nextval INTO x_rn_dat_ln_id from dual ;

358: END IF;
359:
360: /* this is added by rgopalan as this key is kept as unique key and not primary key */
361:
362: Select igs_he_ex_rn_dat_ln_s.nextval INTO x_rn_dat_ln_id from dual ;
363:
364: before_dml(
365: p_action => 'INSERT',
366: x_rowid => x_rowid,

Line 387: INSERT INTO igs_he_ex_rn_dat_ln (

383: x_last_updated_by => x_last_updated_by,
384: x_last_update_login => x_last_update_login
385: );
386:
387: INSERT INTO igs_he_ex_rn_dat_ln (
388: rn_dat_ln_id,
389: extract_run_id,
390: record_id,
391: line_number,

Line 476: FROM igs_he_ex_rn_dat_ln

472: student_inst_number,
473: uv_version_number,
474: unit_cd,
475: recalculate_flag
476: FROM igs_he_ex_rn_dat_ln
477: WHERE rowid = x_rowid
478: FOR UPDATE NOWAIT;
479:
480: tlinfo c1%ROWTYPE;

Line 594: UPDATE igs_he_ex_rn_dat_ln

590: x_last_updated_by => x_last_updated_by,
591: x_last_update_login => x_last_update_login
592: );
593:
594: UPDATE igs_he_ex_rn_dat_ln
595: SET
596: rn_dat_ln_id = new_references.rn_dat_ln_id,
597: record_id = new_references.record_id,
598: person_id = new_references.person_id,

Line 647: FROM igs_he_ex_rn_dat_ln

643: || (reverse chronological order - newest change first)
644: */
645: CURSOR c1 IS
646: SELECT rowid
647: FROM igs_he_ex_rn_dat_ln
648: WHERE extract_run_id = x_extract_run_id
649: AND line_number = x_line_number;
650:
651: BEGIN

Line 719: DELETE FROM igs_he_ex_rn_dat_ln

715: p_action => 'DELETE',
716: x_rowid => x_rowid
717: );
718:
719: DELETE FROM igs_he_ex_rn_dat_ln
720: WHERE rowid = x_rowid;
721:
722: IF (SQL%NOTFOUND) THEN
723: RAISE NO_DATA_FOUND;

Line 729: END igs_he_ex_rn_dat_ln_pkg;

725:
726: END delete_row;
727:
728:
729: END igs_he_ex_rn_dat_ln_pkg;