APPS.IGS_PS_FAC_OVR_WL_PKG dependencies on IGS_PS_FAC_OVR_WL

Line 1: PACKAGE BODY igs_ps_fac_ovr_wl_pkg AS

1: PACKAGE BODY igs_ps_fac_ovr_wl_pkg AS
2: /* $Header: IGSPI3IB.pls 115.3 2002/11/29 02:26:40 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_ovr_wl%ROWTYPE;

Line 5: old_references igs_ps_fac_ovr_wl%ROWTYPE;

1: PACKAGE BODY igs_ps_fac_ovr_wl_pkg AS
2: /* $Header: IGSPI3IB.pls 115.3 2002/11/29 02:26:40 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_ovr_wl%ROWTYPE;
6: new_references igs_ps_fac_ovr_wl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_fac_ovr_wl%ROWTYPE;

2: /* $Header: IGSPI3IB.pls 115.3 2002/11/29 02:26:40 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_ovr_wl%ROWTYPE;
6: new_references igs_ps_fac_ovr_wl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM igs_ps_fac_ovr_wl

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

Line 129: FROM igs_ps_fac_ovr_wl

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

Line 164: FROM igs_ps_fac_ovr_wl

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

Line 199: FROM igs_ps_fac_ovr_wl

195: || (reverse chronological order - newest change first)
196: */
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igs_ps_fac_ovr_wl
200: WHERE ((fac_wl_id = x_fac_wl_id));
201:
202: lv_rowid cur_rowid%RowType;
203:

Line 313: FROM igs_ps_fac_ovr_wl

309: || (reverse chronological order - newest change first)
310: */
311: CURSOR c IS
312: SELECT rowid
313: FROM igs_ps_fac_ovr_wl
314: WHERE fac_ovr_wl_id = x_fac_ovr_wl_id;
315:
316: x_last_update_date DATE;
317: x_last_updated_by NUMBER;

Line 341: SELECT igs_ps_fac_ovr_wl_s.NEXTVAL

337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: END IF;
340:
341: SELECT igs_ps_fac_ovr_wl_s.NEXTVAL
342: INTO x_fac_ovr_wl_id
343: FROM dual;
344:
345: before_dml(

Line 361: INSERT INTO igs_ps_fac_ovr_wl (

357: x_last_updated_by => x_last_updated_by,
358: x_last_update_login => x_last_update_login
359: );
360:
361: INSERT INTO igs_ps_fac_ovr_wl (
362: fac_ovr_wl_id,
363: fac_wl_id,
364: start_date,
365: end_date,

Line 423: FROM igs_ps_fac_ovr_wl

419: start_date,
420: end_date,
421: new_exp_wl,
422: override_reason
423: FROM igs_ps_fac_ovr_wl
424: WHERE rowid = x_rowid
425: FOR UPDATE NOWAIT;
426:
427: tlinfo c1%ROWTYPE;

Line 521: UPDATE igs_ps_fac_ovr_wl

517: x_last_updated_by => x_last_updated_by,
518: x_last_update_login => x_last_update_login
519: );
520:
521: UPDATE igs_ps_fac_ovr_wl
522: SET
523: fac_wl_id = new_references.fac_wl_id,
524: start_date = new_references.start_date,
525: end_date = new_references.end_date,

Line 561: FROM igs_ps_fac_ovr_wl

557: || (reverse chronological order - newest change first)
558: */
559: CURSOR c1 IS
560: SELECT rowid
561: FROM igs_ps_fac_ovr_wl
562: WHERE fac_ovr_wl_id = x_fac_ovr_wl_id;
563:
564: BEGIN
565:

Line 618: DELETE FROM igs_ps_fac_ovr_wl

614: p_action => 'DELETE',
615: x_rowid => x_rowid
616: );
617:
618: DELETE FROM igs_ps_fac_ovr_wl
619: WHERE rowid = x_rowid;
620:
621: IF (SQL%NOTFOUND) THEN
622: RAISE NO_DATA_FOUND;

Line 628: END igs_ps_fac_ovr_wl_pkg;

624:
625: END delete_row;
626:
627:
628: END igs_ps_fac_ovr_wl_pkg;