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.IGS_PR_CLASS_STD_PKG dependencies on IGS_PR_CLASS_STD

Line 1: PACKAGE BODY igs_pr_class_std_pkg AS

1: PACKAGE BODY igs_pr_class_std_pkg AS
2: /* $Header: IGSQI29B.pls 115.14 2003/12/05 05:46:34 ckasu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_class_std%ROWTYPE;

Line 5: old_references igs_pr_class_std%ROWTYPE;

1: PACKAGE BODY igs_pr_class_std_pkg AS
2: /* $Header: IGSQI29B.pls 115.14 2003/12/05 05:46:34 ckasu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_class_std%ROWTYPE;
6: new_references igs_pr_class_std%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_class_std%ROWTYPE;

2: /* $Header: IGSQI29B.pls 115.14 2003/12/05 05:46:34 ckasu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_class_std%ROWTYPE;
6: new_references igs_pr_class_std%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 11: x_igs_pr_class_std_id IN NUMBER DEFAULT NULL,

7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,
11: x_igs_pr_class_std_id IN NUMBER DEFAULT NULL,
12: x_class_standing IN VARCHAR2 DEFAULT NULL,
13: x_description IN VARCHAR2 DEFAULT NULL,
14: x_closed_ind IN VARCHAR2 DEFAULT NULL,
15: x_creation_date IN DATE DEFAULT NULL,

Line 33: FROM IGS_PR_CLASS_STD

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

Line 54: new_references.igs_pr_class_std_id := x_igs_pr_class_std_id;

50: END IF;
51: CLOSE cur_old_ref_values;
52:
53: -- Populate New Values.
54: new_references.igs_pr_class_std_id := x_igs_pr_class_std_id;
55: new_references.class_standing := x_class_standing;
56: new_references.description := x_description;
57: new_references.closed_ind := x_closed_ind;
58:

Line 105: || ckasu 04-Dec-2003 Added IGS_EN_SPA_TERMS_PKG.GET_FK_IGS_PR_CLASS_STD

101: || Known limitations, enhancements or remarks :
102: || Change History :
103: || Who When What
104: || (reverse chronological order - newest change first)
105: || ckasu 04-Dec-2003 Added IGS_EN_SPA_TERMS_PKG.GET_FK_IGS_PR_CLASS_STD
106: for Term Records Build Bug# 2829263
107:
108: */
109: BEGIN

Line 111: igs_pr_css_class_std_pkg.get_fk_igs_pr_class_std (

107:
108: */
109: BEGIN
110:
111: igs_pr_css_class_std_pkg.get_fk_igs_pr_class_std (
112: old_references.igs_pr_class_std_id
113: );
114:
115: igs_as_gpc_cls_stndg_pkg.get_ufk_igs_pr_class_std (

Line 112: old_references.igs_pr_class_std_id

108: */
109: BEGIN
110:
111: igs_pr_css_class_std_pkg.get_fk_igs_pr_class_std (
112: old_references.igs_pr_class_std_id
113: );
114:
115: igs_as_gpc_cls_stndg_pkg.get_ufk_igs_pr_class_std (
116: old_references.class_standing

Line 115: igs_as_gpc_cls_stndg_pkg.get_ufk_igs_pr_class_std (

111: igs_pr_css_class_std_pkg.get_fk_igs_pr_class_std (
112: old_references.igs_pr_class_std_id
113: );
114:
115: igs_as_gpc_cls_stndg_pkg.get_ufk_igs_pr_class_std (
116: old_references.class_standing
117: );
118:
119: -- Enhancement bug no 1877222, pmarada

Line 120: igs_en_stdnt_ps_att_pkg.get_fk_igs_pr_class_std (

116: old_references.class_standing
117: );
118:
119: -- Enhancement bug no 1877222, pmarada
120: igs_en_stdnt_ps_att_pkg.get_fk_igs_pr_class_std (
121: old_references.igs_pr_class_std_id
122: );
123:
124: igs_fi_fee_as_rate_pkg.get_ufk_igs_pr_class_std (

Line 121: old_references.igs_pr_class_std_id

117: );
118:
119: -- Enhancement bug no 1877222, pmarada
120: igs_en_stdnt_ps_att_pkg.get_fk_igs_pr_class_std (
121: old_references.igs_pr_class_std_id
122: );
123:
124: igs_fi_fee_as_rate_pkg.get_ufk_igs_pr_class_std (
125: old_references.class_standing

Line 124: igs_fi_fee_as_rate_pkg.get_ufk_igs_pr_class_std (

120: igs_en_stdnt_ps_att_pkg.get_fk_igs_pr_class_std (
121: old_references.igs_pr_class_std_id
122: );
123:
124: igs_fi_fee_as_rate_pkg.get_ufk_igs_pr_class_std (
125: old_references.class_standing
126: );
127:
128: -- Added as a part of Term records build

Line 129: IGS_EN_SPA_TERMS_PKG.get_fk_igs_pr_class_std (

125: old_references.class_standing
126: );
127:
128: -- Added as a part of Term records build
129: IGS_EN_SPA_TERMS_PKG.get_fk_igs_pr_class_std (
130: old_references.igs_pr_class_std_id
131: );
132:
133: -- This Call is Added as part of Enhancement Bug No : 2138644 , ayedubat

Line 130: old_references.igs_pr_class_std_id

126: );
127:
128: -- Added as a part of Term records build
129: IGS_EN_SPA_TERMS_PKG.get_fk_igs_pr_class_std (
130: old_references.igs_pr_class_std_id
131: );
132:
133: -- This Call is Added as part of Enhancement Bug No : 2138644 , ayedubat
134: igs_pr_ru_appl_pkg.get_fk_igs_pr_class_std (

Line 134: igs_pr_ru_appl_pkg.get_fk_igs_pr_class_std (

130: old_references.igs_pr_class_std_id
131: );
132:
133: -- This Call is Added as part of Enhancement Bug No : 2138644 , ayedubat
134: igs_pr_ru_appl_pkg.get_fk_igs_pr_class_std (
135: old_references.igs_pr_class_std_id
136: );
137: END check_child_existance;
138:

Line 135: old_references.igs_pr_class_std_id

131: );
132:
133: -- This Call is Added as part of Enhancement Bug No : 2138644 , ayedubat
134: igs_pr_ru_appl_pkg.get_fk_igs_pr_class_std (
135: old_references.igs_pr_class_std_id
136: );
137: END check_child_existance;
138:
139:

Line 141: x_igs_pr_class_std_id IN NUMBER

137: END check_child_existance;
138:
139:
140: FUNCTION get_pk_for_validation (
141: x_igs_pr_class_std_id IN NUMBER
142: ) RETURN BOOLEAN AS
143: /*
144: || Created By : avenkatr
145: || Created On : 12-JUL-2001

Line 154: FROM igs_pr_class_std

150: || (reverse chronological order - newest change first)
151: */
152: CURSOR cur_rowid IS
153: SELECT rowid
154: FROM igs_pr_class_std
155: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id ;
156:
157: lv_rowid cur_rowid%RowType;
158:

Line 155: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id ;

151: */
152: CURSOR cur_rowid IS
153: SELECT rowid
154: FROM igs_pr_class_std
155: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id ;
156:
157: lv_rowid cur_rowid%RowType;
158:
159: BEGIN

Line 187: FROM igs_pr_class_std

183: || (reverse chronological order - newest change first)
184: */
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM igs_pr_class_std
188: WHERE class_standing = x_class_standing
189: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
190:
191: lv_rowid cur_rowid%RowType;

Line 211: x_igs_pr_class_std_id IN NUMBER DEFAULT NULL,

207:
208: PROCEDURE before_dml (
209: p_action IN VARCHAR2,
210: x_rowid IN VARCHAR2 DEFAULT NULL,
211: x_igs_pr_class_std_id IN NUMBER DEFAULT NULL,
212: x_class_standing IN VARCHAR2 DEFAULT NULL,
213: x_description IN VARCHAR2 DEFAULT NULL,
214: x_closed_ind IN VARCHAR2 DEFAULT NULL,
215: x_creation_date IN DATE DEFAULT NULL,

Line 236: x_igs_pr_class_std_id,

232:
233: set_column_values (
234: p_action,
235: x_rowid,
236: x_igs_pr_class_std_id,
237: x_class_standing,
238: x_description,
239: x_closed_ind,
240: x_creation_date,

Line 250: new_references.igs_pr_class_std_id

246:
247: IF (p_action = 'INSERT') THEN
248: -- Call all the procedures related to Before Insert.
249: IF ( get_pk_for_validation(
250: new_references.igs_pr_class_std_id
251: )
252: ) THEN
253: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
254: igs_ge_msg_stack.add;

Line 267: new_references.igs_pr_class_std_id

263: check_child_existance;
264: ELSIF (p_action = 'VALIDATE_INSERT') THEN
265: -- Call all the procedures related to Before Insert.
266: IF ( get_pk_for_validation (
267: new_references.igs_pr_class_std_id
268: )
269: ) THEN
270: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
271: igs_ge_msg_stack.add;

Line 286: x_igs_pr_class_std_id IN OUT NOCOPY NUMBER,

282:
283:
284: PROCEDURE insert_row (
285: x_rowid IN OUT NOCOPY VARCHAR2,
286: x_igs_pr_class_std_id IN OUT NOCOPY NUMBER,
287: x_class_standing IN VARCHAR2,
288: x_description IN VARCHAR2,
289: x_closed_ind IN VARCHAR2,
290: x_mode IN VARCHAR2 DEFAULT 'R'

Line 303: FROM igs_pr_class_std

299: || (reverse chronological order - newest change first)
300: */
301: CURSOR c IS
302: SELECT rowid
303: FROM igs_pr_class_std
304: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id;
305:
306: x_last_update_date DATE;
307: x_last_updated_by NUMBER;

Line 304: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id;

300: */
301: CURSOR c IS
302: SELECT rowid
303: FROM igs_pr_class_std
304: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id;
305:
306: x_last_update_date DATE;
307: x_last_updated_by NUMBER;
308: x_last_update_login NUMBER;

Line 331: SELECT igs_pr_class_std_s.NEXTVAL

327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330:
331: SELECT igs_pr_class_std_s.NEXTVAL
332: INTO x_igs_pr_class_std_id
333: FROM dual;
334:
335: before_dml(

Line 332: INTO x_igs_pr_class_std_id

328: app_exception.raise_exception;
329: END IF;
330:
331: SELECT igs_pr_class_std_s.NEXTVAL
332: INTO x_igs_pr_class_std_id
333: FROM dual;
334:
335: before_dml(
336: p_action => 'INSERT',

Line 338: x_igs_pr_class_std_id => x_igs_pr_class_std_id,

334:
335: before_dml(
336: p_action => 'INSERT',
337: x_rowid => x_rowid,
338: x_igs_pr_class_std_id => x_igs_pr_class_std_id,
339: x_class_standing => x_class_standing,
340: x_description => x_description,
341: x_closed_ind => x_closed_ind,
342: x_creation_date => x_last_update_date,

Line 349: INSERT INTO igs_pr_class_std (

345: x_last_updated_by => x_last_updated_by,
346: x_last_update_login => x_last_update_login
347: );
348:
349: INSERT INTO igs_pr_class_std (
350: igs_pr_class_std_id,
351: class_standing,
352: description,
353: closed_ind,

Line 350: igs_pr_class_std_id,

346: x_last_update_login => x_last_update_login
347: );
348:
349: INSERT INTO igs_pr_class_std (
350: igs_pr_class_std_id,
351: class_standing,
352: description,
353: closed_ind,
354: creation_date,

Line 360: new_references.igs_pr_class_std_id,

356: last_update_date,
357: last_updated_by,
358: last_update_login
359: ) VALUES (
360: new_references.igs_pr_class_std_id,
361: new_references.class_standing,
362: new_references.description,
363: new_references.closed_ind,
364: x_last_update_date,

Line 384: x_igs_pr_class_std_id IN NUMBER,

380:
381:
382: PROCEDURE lock_row (
383: x_rowid IN VARCHAR2,
384: x_igs_pr_class_std_id IN NUMBER,
385: x_class_standing IN VARCHAR2,
386: x_description IN VARCHAR2,
387: x_closed_ind IN VARCHAR2
388: ) AS

Line 403: FROM igs_pr_class_std

399: SELECT
400: class_standing,
401: description,
402: closed_ind
403: FROM igs_pr_class_std
404: WHERE rowid = x_rowid
405: FOR UPDATE NOWAIT;
406:
407: tlinfo c1%ROWTYPE;

Line 441: x_igs_pr_class_std_id IN NUMBER,

437:
438:
439: PROCEDURE update_row (
440: x_rowid IN VARCHAR2,
441: x_igs_pr_class_std_id IN NUMBER,
442: x_class_standing IN VARCHAR2,
443: x_description IN VARCHAR2,
444: x_closed_ind IN VARCHAR2,
445: x_mode IN VARCHAR2 DEFAULT 'R'

Line 484: x_igs_pr_class_std_id => x_igs_pr_class_std_id,

480:
481: before_dml(
482: p_action => 'UPDATE',
483: x_rowid => x_rowid,
484: x_igs_pr_class_std_id => x_igs_pr_class_std_id,
485: x_class_standing => x_class_standing,
486: x_description => x_description,
487: x_closed_ind => x_closed_ind,
488: x_creation_date => x_last_update_date,

Line 495: UPDATE igs_pr_class_std

491: x_last_updated_by => x_last_updated_by,
492: x_last_update_login => x_last_update_login
493: );
494:
495: UPDATE igs_pr_class_std
496: SET
497: class_standing = new_references.class_standing,
498: description = new_references.description,
499: closed_ind = new_references.closed_ind,

Line 514: x_igs_pr_class_std_id IN OUT NOCOPY NUMBER,

510:
511:
512: PROCEDURE add_row (
513: x_rowid IN OUT NOCOPY VARCHAR2,
514: x_igs_pr_class_std_id IN OUT NOCOPY NUMBER,
515: x_class_standing IN VARCHAR2,
516: x_description IN VARCHAR2,
517: x_closed_ind IN VARCHAR2,
518: x_mode IN VARCHAR2 DEFAULT 'R'

Line 531: FROM igs_pr_class_std

527: || (reverse chronological order - newest change first)
528: */
529: CURSOR c1 IS
530: SELECT rowid
531: FROM igs_pr_class_std
532: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id;
533:
534: BEGIN
535:

Line 532: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id;

528: */
529: CURSOR c1 IS
530: SELECT rowid
531: FROM igs_pr_class_std
532: WHERE igs_pr_class_std_id = x_igs_pr_class_std_id;
533:
534: BEGIN
535:
536: OPEN c1;

Line 543: x_igs_pr_class_std_id,

539: CLOSE c1;
540:
541: insert_row (
542: x_rowid,
543: x_igs_pr_class_std_id,
544: x_class_standing,
545: x_description,
546: x_closed_ind,
547: x_mode

Line 555: x_igs_pr_class_std_id,

551: CLOSE c1;
552:
553: update_row (
554: x_rowid,
555: x_igs_pr_class_std_id,
556: x_class_standing,
557: x_description,
558: x_closed_ind,
559: x_mode

Line 568: END igs_pr_class_std_pkg;

564:
565: /*Removed procedure Delete_row for Records Locking Bug 2784198 */
566:
567:
568: END igs_pr_class_std_pkg;