APPS.IGF_AW_FISAP_II_H_PKG dependencies on IGF_AW_FISAP_II_H

Line 1: PACKAGE BODY igf_aw_fisap_ii_h_pkg AS

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

Line 5: old_references igf_aw_fisap_ii_h%ROWTYPE;

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

Line 6: new_references igf_aw_fisap_ii_h%ROWTYPE;

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

Line 40: FROM IGF_AW_FISAP_II_H

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

Line 128: FROM igf_aw_fisap_ii_h

124: || (reverse chronological order - newest change first)
125: */
126: CURSOR cur_rowid IS
127: SELECT rowid
128: FROM igf_aw_fisap_ii_h
129: WHERE fisap_id = x_fisap_id
130: FOR UPDATE NOWAIT;
131:
132: lv_rowid cur_rowid%RowType;

Line 163: FROM igf_aw_fisap_ii_h

159: || (reverse chronological order - newest change first)
160: */
161: CURSOR cur_rowid IS
162: SELECT rowid
163: FROM igf_aw_fisap_ii_h
164: WHERE ((category_id = x_category_id));
165:
166: lv_rowid cur_rowid%RowType;
167:

Line 292: FROM igf_aw_fisap_ii_h

288: || (reverse chronological order - newest change first)
289: */
290: CURSOR c IS
291: SELECT rowid
292: FROM igf_aw_fisap_ii_h
293: WHERE fisap_id = x_fisap_id;
294:
295: x_last_update_date DATE;
296: x_last_updated_by NUMBER;

Line 320: SELECT igf_aw_fisap_ii_h_s.NEXTVAL

316: igs_ge_msg_stack.add;
317: app_exception.raise_exception;
318: END IF;
319:
320: SELECT igf_aw_fisap_ii_h_s.NEXTVAL
321: INTO x_fisap_id
322: FROM dual;
323:
324: before_dml(

Line 345: INSERT INTO igf_aw_fisap_ii_h (

341: x_last_updated_by => x_last_updated_by,
342: x_last_update_login => x_last_update_login
343: );
344:
345: INSERT INTO igf_aw_fisap_ii_h (
346: fisap_id,
347: category_id,
348: fisap_section,
349: depend_stat,

Line 427: FROM igf_aw_fisap_ii_h

423: minvalue,
424: maxvalue,
425: ci_cal_type,
426: ci_sequence_number
427: FROM igf_aw_fisap_ii_h
428: WHERE rowid = x_rowid
429: FOR UPDATE NOWAIT;
430:
431: tlinfo c1%ROWTYPE;

Line 540: UPDATE igf_aw_fisap_ii_h

536: x_last_updated_by => x_last_updated_by,
537: x_last_update_login => x_last_update_login
538: );
539:
540: UPDATE igf_aw_fisap_ii_h
541: SET
542: category_id = new_references.category_id,
543: fisap_section = new_references.fisap_section,
544: depend_stat = new_references.depend_stat,

Line 590: FROM igf_aw_fisap_ii_h

586: || (reverse chronological order - newest change first)
587: */
588: CURSOR c1 IS
589: SELECT rowid
590: FROM igf_aw_fisap_ii_h
591: WHERE fisap_id = x_fisap_id;
592:
593: BEGIN
594:

Line 657: DELETE FROM igf_aw_fisap_ii_h

653: p_action => 'DELETE',
654: x_rowid => x_rowid
655: );
656:
657: DELETE FROM igf_aw_fisap_ii_h
658: WHERE rowid = x_rowid;
659:
660: IF (SQL%NOTFOUND) THEN
661: RAISE NO_DATA_FOUND;

Line 667: END igf_aw_fisap_ii_h_pkg;

663:
664: END delete_row;
665:
666:
667: END igf_aw_fisap_ii_h_pkg;