APPS.IGF_AW_CAL_REL_PKG dependencies on IGF_AW_CAL_REL

Line 1: PACKAGE BODY igf_aw_cal_rel_pkg AS

1: PACKAGE BODY igf_aw_cal_rel_pkg AS
2: /* $Header: IGFWI27B.pls 115.7 2002/11/28 14:40:02 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_cal_rel_all%ROWTYPE;

Line 5: old_references igf_aw_cal_rel_all%ROWTYPE;

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

Line 6: new_references igf_aw_cal_rel_all%ROWTYPE;

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

Line 34: FROM IGF_AW_CAL_REL_ALL

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

Line 145: FROM igf_aw_cal_rel_all

141: || (reverse chronological order - newest change first)
142: */
143: CURSOR cur_rowid IS
144: SELECT rowid
145: FROM igf_aw_cal_rel_all
146: WHERE crel_id = x_crel_id
147: FOR UPDATE NOWAIT;
148:
149: lv_rowid cur_rowid%RowType;

Line 179: || from igf_aw_cal_rel instead of igf_aw_cal_rel_all for bug :2222272.

175: || Known limitations, enhancements or remarks :
176: || Change History :
177: || Who When What
178: || vvutukur 18-feb-2002 modified org_id check in cur_rowid using new local variable l_org_id and selected
179: || from igf_aw_cal_rel instead of igf_aw_cal_rel_all for bug :2222272.
180: || (reverse chronological order - newest change first)
181: */
182:
183: l_org_id igf_aw_cal_rel_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

Line 183: l_org_id igf_aw_cal_rel_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

179: || from igf_aw_cal_rel instead of igf_aw_cal_rel_all for bug :2222272.
180: || (reverse chronological order - newest change first)
181: */
182:
183: l_org_id igf_aw_cal_rel_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM igf_aw_cal_rel

Line 187: FROM igf_aw_cal_rel

183: l_org_id igf_aw_cal_rel_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM igf_aw_cal_rel
188: WHERE cr_cal_type = x_cr_cal_type
189: AND cr_sequence_number = x_cr_sequence_number
190: AND NVL(org_id,NVL(l_org_id,-99)) = NVL(l_org_id,-99) --bug 2222272
191: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 225: FROM igf_aw_cal_rel_all

221: || (reverse chronological order - newest change first)
222: */
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM igf_aw_cal_rel_all
226: WHERE ((cr_cal_type = x_cal_type) AND
227: (cr_sequence_number = x_sequence_number));
228:
229: lv_rowid cur_rowid%RowType;

Line 342: FROM igf_aw_cal_rel_all

338: || (reverse chronological order - newest change first)
339: */
340: CURSOR c IS
341: SELECT rowid
342: FROM igf_aw_cal_rel_all
343: WHERE crel_id = x_crel_id;
344:
345: x_last_update_date DATE;
346: x_last_updated_by NUMBER;

Line 370: SELECT igf_aw_cal_rel_s.NEXTVAL

366: igs_ge_msg_stack.add;
367: app_exception.raise_exception;
368: END IF;
369:
370: SELECT igf_aw_cal_rel_s.NEXTVAL
371: INTO x_crel_id
372: FROM dual;
373:
374: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 391: INSERT INTO igf_aw_cal_rel_all (

387: x_last_updated_by => x_last_updated_by,
388: x_last_update_login => x_last_update_login
389: );
390:
391: INSERT INTO igf_aw_cal_rel_all (
392: crel_id,
393: cr_cal_type,
394: cr_sequence_number,
395: sc_sequence_number,

Line 451: FROM igf_aw_cal_rel_all

447: cr_cal_type,
448: cr_sequence_number,
449: sc_sequence_number,
450: active
451: FROM igf_aw_cal_rel_all
452: WHERE rowid = x_rowid
453: FOR UPDATE NOWAIT;
454:
455: tlinfo c1%ROWTYPE;

Line 546: UPDATE igf_aw_cal_rel_all

542: x_last_updated_by => x_last_updated_by,
543: x_last_update_login => x_last_update_login
544: );
545:
546: UPDATE igf_aw_cal_rel_all
547: SET
548: cr_cal_type = new_references.cr_cal_type,
549: cr_sequence_number = new_references.cr_sequence_number,
550: sc_sequence_number = new_references.sc_sequence_number,

Line 584: FROM igf_aw_cal_rel_all

580: || (reverse chronological order - newest change first)
581: */
582: CURSOR c1 IS
583: SELECT rowid
584: FROM igf_aw_cal_rel_all
585: WHERE crel_id = x_crel_id;
586:
587: BEGIN
588:

Line 639: DELETE FROM igf_aw_cal_rel_all

635: p_action => 'DELETE',
636: x_rowid => x_rowid
637: );
638:
639: DELETE FROM igf_aw_cal_rel_all
640: WHERE rowid = x_rowid;
641:
642: IF (SQL%NOTFOUND) THEN
643: RAISE NO_DATA_FOUND;

Line 649: END igf_aw_cal_rel_pkg;

645:
646: END delete_row;
647:
648:
649: END igf_aw_cal_rel_pkg;