eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_AW_FISAP_REPSET_PKG dependencies on IGF_AW_FISAP_REPSET

Line 1: PACKAGE BODY igf_aw_fisap_repset_pkg AS

1: PACKAGE BODY igf_aw_fisap_repset_pkg AS
2: /* $Header: IGFWI45B.pls 115.5 2002/11/28 12:17:01 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fisap_repset%ROWTYPE;

Line 5: old_references igf_aw_fisap_repset%ROWTYPE;

1: PACKAGE BODY igf_aw_fisap_repset_pkg AS
2: /* $Header: IGFWI45B.pls 115.5 2002/11/28 12:17:01 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fisap_repset%ROWTYPE;
6: new_references igf_aw_fisap_repset%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_fisap_repset%ROWTYPE;

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

Line 35: FROM IGF_AW_FISAP_REPSET

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

Line 147: igf_aw_fisap_ii_h_pkg.get_fk_igf_aw_fisap_repset (

143: || (reverse chronological order - newest change first)
144: */
145: BEGIN
146:
147: igf_aw_fisap_ii_h_pkg.get_fk_igf_aw_fisap_repset (
148: old_references.category_id
149: );
150:
151: igf_aw_fisap_vi_h_pkg.get_fk_igf_aw_fisap_repset (

Line 151: igf_aw_fisap_vi_h_pkg.get_fk_igf_aw_fisap_repset (

147: igf_aw_fisap_ii_h_pkg.get_fk_igf_aw_fisap_repset (
148: old_references.category_id
149: );
150:
151: igf_aw_fisap_vi_h_pkg.get_fk_igf_aw_fisap_repset (
152: old_references.category_id
153: );
154:
155: igf_aw_fi_inc_level_pkg.get_fk_igf_aw_fisap_repset (

Line 155: igf_aw_fi_inc_level_pkg.get_fk_igf_aw_fisap_repset (

151: igf_aw_fisap_vi_h_pkg.get_fk_igf_aw_fisap_repset (
152: old_references.category_id
153: );
154:
155: igf_aw_fi_inc_level_pkg.get_fk_igf_aw_fisap_repset (
156: old_references.category_id
157: );
158:
159: END check_child_existance;

Line 176: FROM igf_aw_fisap_repset

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

Line 215: FROM igf_aw_fisap_repset

211: || (reverse chronological order - newest change first)
212: */
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM igf_aw_fisap_repset
216: WHERE depend_stat = x_depend_stat
217: AND class_standing = x_class_standing
218: AND ci_cal_type = x_ci_cal_type
219: AND ci_sequence_number = x_ci_sequence_number

Line 255: FROM igf_aw_fisap_repset

251: || (reverse chronological order - newest change first)
252: */
253: CURSOR cur_rowid IS
254: SELECT rowid
255: FROM igf_aw_fisap_repset
256: WHERE ((ci_cal_type = x_cal_type) AND
257: (ci_sequence_number = x_sequence_number));
258:
259: lv_rowid cur_rowid%RowType;

Line 380: FROM igf_aw_fisap_repset

376: || (reverse chronological order - newest change first)
377: */
378: CURSOR c IS
379: SELECT rowid
380: FROM igf_aw_fisap_repset
381: WHERE category_id = x_category_id;
382:
383: x_last_update_date DATE;
384: x_last_updated_by NUMBER;

Line 408: SELECT igf_aw_fisap_repset_s.NEXTVAL

404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
408: SELECT igf_aw_fisap_repset_s.NEXTVAL
409: INTO x_category_id
410: FROM dual;
411:
412: before_dml(

Line 428: INSERT INTO igf_aw_fisap_repset (

424: x_last_updated_by => x_last_updated_by,
425: x_last_update_login => x_last_update_login
426: );
427:
428: INSERT INTO igf_aw_fisap_repset (
429: category_id,
430: fisap_section,
431: depend_stat,
432: class_standing,

Line 490: FROM igf_aw_fisap_repset

486: depend_stat,
487: class_standing,
488: ci_cal_type,
489: ci_sequence_number
490: FROM igf_aw_fisap_repset
491: WHERE rowid = x_rowid
492: FOR UPDATE NOWAIT;
493:
494: tlinfo c1%ROWTYPE;

Line 588: UPDATE igf_aw_fisap_repset

584: x_last_updated_by => x_last_updated_by,
585: x_last_update_login => x_last_update_login
586: );
587:
588: UPDATE igf_aw_fisap_repset
589: SET
590: fisap_section = new_references.fisap_section,
591: depend_stat = new_references.depend_stat,
592: class_standing = new_references.class_standing,

Line 628: FROM igf_aw_fisap_repset

624: || (reverse chronological order - newest change first)
625: */
626: CURSOR c1 IS
627: SELECT rowid
628: FROM igf_aw_fisap_repset
629: WHERE category_id = x_category_id;
630:
631: BEGIN
632:

Line 685: DELETE FROM igf_aw_fisap_repset

681: p_action => 'DELETE',
682: x_rowid => x_rowid
683: );
684:
685: DELETE FROM igf_aw_fisap_repset
686: WHERE rowid = x_rowid;
687:
688: IF (SQL%NOTFOUND) THEN
689: RAISE NO_DATA_FOUND;

Line 695: END igf_aw_fisap_repset_pkg;

691:
692: END delete_row;
693:
694:
695: END igf_aw_fisap_repset_pkg;