APPS.IGF_AW_FISAP_VI_H_PKG dependencies on IGF_AW_FISAP_VI_H

Line 1: PACKAGE BODY igf_aw_fisap_vi_h_pkg AS

1: PACKAGE BODY igf_aw_fisap_vi_h_pkg AS
2: /* $Header: IGFWI43B.pls 115.5 2002/11/28 14:42:39 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fisap_vi_h%ROWTYPE;

Line 5: old_references igf_aw_fisap_vi_h%ROWTYPE;

1: PACKAGE BODY igf_aw_fisap_vi_h_pkg AS
2: /* $Header: IGFWI43B.pls 115.5 2002/11/28 14:42:39 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fisap_vi_h%ROWTYPE;
6: new_references igf_aw_fisap_vi_h%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_fisap_vi_h%ROWTYPE;

2: /* $Header: IGFWI43B.pls 115.5 2002/11/28 14:42:39 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fisap_vi_h%ROWTYPE;
6: new_references igf_aw_fisap_vi_h%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 46: FROM IGF_AW_FISAP_VI_H

42: */
43:
44: CURSOR cur_old_ref_values IS
45: SELECT *
46: FROM IGF_AW_FISAP_VI_H
47: WHERE rowid = x_rowid;
48:
49: BEGIN
50:

Line 140: FROM igf_aw_fisap_vi_h

136: || (reverse chronological order - newest change first)
137: */
138: CURSOR cur_rowid IS
139: SELECT rowid
140: FROM igf_aw_fisap_vi_h
141: WHERE fisap_id = x_fisap_id
142: FOR UPDATE NOWAIT;
143:
144: lv_rowid cur_rowid%RowType;

Line 175: FROM igf_aw_fisap_vi_h

171: || (reverse chronological order - newest change first)
172: */
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM igf_aw_fisap_vi_h
176: WHERE ((category_id = x_category_id));
177:
178: lv_rowid cur_rowid%RowType;
179:

Line 322: FROM igf_aw_fisap_vi_h

318: || (reverse chronological order - newest change first)
319: */
320: CURSOR c IS
321: SELECT rowid
322: FROM igf_aw_fisap_vi_h
323: WHERE fisap_id = x_fisap_id;
324:
325: x_last_update_date DATE;
326: x_last_updated_by NUMBER;

Line 350: SELECT igf_aw_fisap_vi_h_s.NEXTVAL

346: igs_ge_msg_stack.add;
347: app_exception.raise_exception;
348: END IF;
349:
350: SELECT igf_aw_fisap_vi_h_s.NEXTVAL
351: INTO x_fisap_id
352: FROM dual;
353:
354: before_dml(

Line 381: INSERT INTO igf_aw_fisap_vi_h (

377: x_last_updated_by => x_last_updated_by,
378: x_last_update_login => x_last_update_login
379: );
380:
381: INSERT INTO igf_aw_fisap_vi_h (
382: fisap_id,
383: category_id,
384: fisap_section,
385: depend_stat,

Line 487: FROM igf_aw_fisap_vi_h

483: fseog_fund_total,
484: fws_std_count,
485: fws_fund_total,
486: unduplicated_std_count
487: FROM igf_aw_fisap_vi_h
488: WHERE rowid = x_rowid
489: FOR UPDATE NOWAIT;
490:
491: tlinfo c1%ROWTYPE;

Line 618: UPDATE igf_aw_fisap_vi_h

614: x_last_updated_by => x_last_updated_by,
615: x_last_update_login => x_last_update_login
616: );
617:
618: UPDATE igf_aw_fisap_vi_h
619: SET
620: category_id = new_references.category_id,
621: fisap_section = new_references.fisap_section,
622: depend_stat = new_references.depend_stat,

Line 680: FROM igf_aw_fisap_vi_h

676: || (reverse chronological order - newest change first)
677: */
678: CURSOR c1 IS
679: SELECT rowid
680: FROM igf_aw_fisap_vi_h
681: WHERE fisap_id = x_fisap_id;
682:
683: BEGIN
684:

Line 759: DELETE FROM igf_aw_fisap_vi_h

755: p_action => 'DELETE',
756: x_rowid => x_rowid
757: );
758:
759: DELETE FROM igf_aw_fisap_vi_h
760: WHERE rowid = x_rowid;
761:
762: IF (SQL%NOTFOUND) THEN
763: RAISE NO_DATA_FOUND;

Line 769: END igf_aw_fisap_vi_h_pkg;

765:
766: END delete_row;
767:
768:
769: END igf_aw_fisap_vi_h_pkg;