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.

APPS.IGF_AW_AWD_RVSN_RSN_PKG dependencies on IGF_AW_AWD_RVSN_RSN

Line 1: PACKAGE BODY igf_aw_awd_rvsn_rsn_pkg AS

1: PACKAGE BODY igf_aw_awd_rvsn_rsn_pkg AS
2: /* $Header: IGFWI32B.pls 115.7 2002/11/28 14:41:05 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_rvsn_rsn_all%ROWTYPE;

Line 5: old_references igf_aw_awd_rvsn_rsn_all%ROWTYPE;

1: PACKAGE BODY igf_aw_awd_rvsn_rsn_pkg AS
2: /* $Header: IGFWI32B.pls 115.7 2002/11/28 14:41:05 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_rvsn_rsn_all%ROWTYPE;
6: new_references igf_aw_awd_rvsn_rsn_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_awd_rvsn_rsn_all%ROWTYPE;

2: /* $Header: IGFWI32B.pls 115.7 2002/11/28 14:41:05 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_rvsn_rsn_all%ROWTYPE;
6: new_references igf_aw_awd_rvsn_rsn_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGF_AW_AWD_RVSN_RSN_ALL

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

Line 111: igf_aw_award_pkg.get_fk_igf_aw_awd_rvsn_rsn (

107: || (reverse chronological order - newest change first)
108: */
109: BEGIN
110:
111: igf_aw_award_pkg.get_fk_igf_aw_awd_rvsn_rsn (
112: old_references.rvsn_id
113: );
114:
115: igf_aw_awd_disb_pkg.get_fk_igf_aw_awd_rvsn_rsn (

Line 115: igf_aw_awd_disb_pkg.get_fk_igf_aw_awd_rvsn_rsn (

111: igf_aw_award_pkg.get_fk_igf_aw_awd_rvsn_rsn (
112: old_references.rvsn_id
113: );
114:
115: igf_aw_awd_disb_pkg.get_fk_igf_aw_awd_rvsn_rsn (
116: old_references.rvsn_id
117: );
118:
119: END check_child_existance;

Line 136: FROM igf_aw_awd_rvsn_rsn_all

132: || (reverse chronological order - newest change first)
133: */
134: CURSOR cur_rowid IS
135: SELECT rowid
136: FROM igf_aw_awd_rvsn_rsn_all
137: WHERE rvsn_id = x_rvsn_id
138: FOR UPDATE NOWAIT;
139:
140: lv_rowid cur_rowid%RowType;

Line 169: || vvutukur 18-feb-20022 modified org_id check in cur_rowid cursor and selected from igf_aw_awd_rvsn_rsn instead

165: || Purpose : Validates the Unique Keys of the table.
166: || Known limitations, enhancements or remarks :
167: || Change History :
168: || Who When What
169: || vvutukur 18-feb-20022 modified org_id check in cur_rowid cursor and selected from igf_aw_awd_rvsn_rsn instead
170: || of igf_aw_aed_rvsn_rsn_all for bug : 2222272 as part of SWSCR006 Build.
171: || adhawan 23-feb-02' made the primary key incasesensitive by adding the UPPER clause
172: || 2168913
173: || (reverse chronological order - newest change first)

Line 176: l_org_id igf_aw_awd_rvsn_rsn_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

172: || 2168913
173: || (reverse chronological order - newest change first)
174: */
175:
176: l_org_id igf_aw_awd_rvsn_rsn_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
177:
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM igf_aw_awd_rvsn_rsn

Line 180: FROM igf_aw_awd_rvsn_rsn

176: l_org_id igf_aw_awd_rvsn_rsn_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
177:
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM igf_aw_awd_rvsn_rsn
181: WHERE UPPER(rvsn_code) = UPPER(x_rvsn_code) -- BUG 2168913
182: AND NVL(org_id,NVL(l_org_id,-99)) = NVL(l_org_id,-99) --bug 2222272
183: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
184:

Line 297: FROM igf_aw_awd_rvsn_rsn_all

293: || (reverse chronological order - newest change first)
294: */
295: CURSOR c IS
296: SELECT rowid
297: FROM igf_aw_awd_rvsn_rsn_all
298: WHERE rvsn_id = x_rvsn_id;
299:
300: x_last_update_date DATE;
301: x_last_updated_by NUMBER;

Line 325: SELECT igf_aw_awd_rvsn_rsn_s.NEXTVAL

321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: END IF;
324:
325: SELECT igf_aw_awd_rvsn_rsn_s.NEXTVAL
326: INTO x_rvsn_id
327: FROM dual;
328:
329: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 345: INSERT INTO igf_aw_awd_rvsn_rsn_all (

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_awd_rvsn_rsn_all (
346: rvsn_id,
347: rvsn_code,
348: descp,
349: active,

Line 401: FROM igf_aw_awd_rvsn_rsn_all

397: SELECT
398: rvsn_code,
399: descp,
400: active
401: FROM igf_aw_awd_rvsn_rsn_all
402: WHERE rowid = x_rowid
403: FOR UPDATE NOWAIT;
404:
405: tlinfo c1%ROWTYPE;

Line 493: UPDATE igf_aw_awd_rvsn_rsn_all

489: x_last_updated_by => x_last_updated_by,
490: x_last_update_login => x_last_update_login
491: );
492:
493: UPDATE igf_aw_awd_rvsn_rsn_all
494: SET
495: rvsn_code = new_references.rvsn_code,
496: descp = new_references.descp,
497: active = new_references.active,

Line 529: FROM igf_aw_awd_rvsn_rsn_all

525: || (reverse chronological order - newest change first)
526: */
527: CURSOR c1 IS
528: SELECT rowid
529: FROM igf_aw_awd_rvsn_rsn_all
530: WHERE rvsn_id = x_rvsn_id;
531:
532: BEGIN
533:

Line 582: DELETE FROM igf_aw_awd_rvsn_rsn_all

578: p_action => 'DELETE',
579: x_rowid => x_rowid
580: );
581:
582: DELETE FROM igf_aw_awd_rvsn_rsn_all
583: WHERE rowid = x_rowid;
584:
585: IF (SQL%NOTFOUND) THEN
586: RAISE NO_DATA_FOUND;

Line 592: END igf_aw_awd_rvsn_rsn_pkg;

588:
589: END delete_row;
590:
591:
592: END igf_aw_awd_rvsn_rsn_pkg;