APPS.IGS_HE_UCAS_IMP_ERR_PKG dependencies on IGS_HE_UCAS_IMP_ERR

Line 1: PACKAGE BODY igs_he_ucas_imp_err_pkg AS

1: PACKAGE BODY igs_he_ucas_imp_err_pkg AS
2: /* $Header: IGSWI32B.pls 115.3 2003/03/05 08:47:15 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ucas_imp_err%ROWTYPE;

Line 5: old_references igs_he_ucas_imp_err%ROWTYPE;

1: PACKAGE BODY igs_he_ucas_imp_err_pkg AS
2: /* $Header: IGSWI32B.pls 115.3 2003/03/05 08:47:15 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ucas_imp_err%ROWTYPE;
6: new_references igs_he_ucas_imp_err%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ucas_imp_err%ROWTYPE;

2: /* $Header: IGSWI32B.pls 115.3 2003/03/05 08:47:15 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ucas_imp_err%ROWTYPE;
6: new_references igs_he_ucas_imp_err%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_he_ucas_imp_err

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM igs_he_ucas_imp_err
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 130: FROM igs_he_ucas_imp_err

126: || (reverse chronological order - newest change first)
127: */
128: CURSOR cur_rowid IS
129: SELECT rowid
130: FROM igs_he_ucas_imp_err
131: WHERE error_interface_id = x_error_interface_id
132: FOR UPDATE NOWAIT;
133:
134: lv_rowid cur_rowid%RowType;

Line 241: SELECT igs_he_ucas_imp_err_s.NEXTVAL

237: || (reverse chronological order - newest change first)
238: */
239:
240: CURSOR c_imp_err IS
241: SELECT igs_he_ucas_imp_err_s.NEXTVAL
242: FROM dual;
243:
244: x_last_update_date DATE;
245: x_last_updated_by NUMBER;

Line 290: INSERT INTO igs_he_ucas_imp_err (

286: x_last_updated_by => x_last_updated_by,
287: x_last_update_login => x_last_update_login
288: );
289:
290: INSERT INTO igs_he_ucas_imp_err (
291: error_interface_id,
292: interface_hesa_id,
293: batch_id,
294: error_code,

Line 340: FROM igs_he_ucas_imp_err

336: interface_hesa_id,
337: batch_id,
338: error_code,
339: error_text
340: FROM igs_he_ucas_imp_err
341: WHERE rowid = x_rowid
342: FOR UPDATE NOWAIT;
343:
344: tlinfo c1%ROWTYPE;

Line 435: UPDATE igs_he_ucas_imp_err

431: x_last_updated_by => x_last_updated_by,
432: x_last_update_login => x_last_update_login
433: );
434:
435: UPDATE igs_he_ucas_imp_err
436: SET
437: interface_hesa_id = new_references.interface_hesa_id,
438: batch_id = new_references.batch_id,
439: error_code = new_references.error_code,

Line 473: FROM igs_he_ucas_imp_err

469: || (reverse chronological order - newest change first)
470: */
471: CURSOR c1 IS
472: SELECT rowid
473: FROM igs_he_ucas_imp_err
474: WHERE error_interface_id = x_error_interface_id;
475:
476: BEGIN
477:

Line 528: DELETE FROM igs_he_ucas_imp_err

524: p_action => 'DELETE',
525: x_rowid => x_rowid
526: );
527:
528: DELETE FROM igs_he_ucas_imp_err
529: WHERE rowid = x_rowid;
530:
531: IF (SQL%NOTFOUND) THEN
532: RAISE NO_DATA_FOUND;

Line 538: END igs_he_ucas_imp_err_pkg;

534:
535: END delete_row;
536:
537:
538: END igs_he_ucas_imp_err_pkg;