APPS.IGS_PS_FAC_WL_PKG dependencies on IGS_PS_FAC_WL

Line 1: PACKAGE BODY igs_ps_fac_wl_pkg AS

1: PACKAGE BODY igs_ps_fac_wl_pkg AS
2: /* $Header: IGSPI3JB.pls 120.0 2005/06/01 20:11:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_wl%ROWTYPE;

Line 5: old_references igs_ps_fac_wl%ROWTYPE;

1: PACKAGE BODY igs_ps_fac_wl_pkg AS
2: /* $Header: IGSPI3JB.pls 120.0 2005/06/01 20:11:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_wl%ROWTYPE;
6: new_references igs_ps_fac_wl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_fac_wl%ROWTYPE;

2: /* $Header: IGSPI3JB.pls 120.0 2005/06/01 20:11:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_wl%ROWTYPE;
6: new_references igs_ps_fac_wl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 55: FROM igs_ps_fac_wl

51: */
52:
53: CURSOR cur_old_ref_values IS
54: SELECT *
55: FROM igs_ps_fac_wl
56: WHERE rowid = x_rowid;
57:
58: BEGIN
59:

Line 202: igs_ps_fac_asg_task_pkg.get_fk_igs_ps_fac_wl (

198: || (reverse chronological order - newest change first)
199: */
200: BEGIN
201:
202: igs_ps_fac_asg_task_pkg.get_fk_igs_ps_fac_wl (
203: old_references.fac_wl_id
204: );
205:
206: igs_ps_fac_ovr_wl_pkg.get_fk_igs_ps_fac_wl (

Line 206: igs_ps_fac_ovr_wl_pkg.get_fk_igs_ps_fac_wl (

202: igs_ps_fac_asg_task_pkg.get_fk_igs_ps_fac_wl (
203: old_references.fac_wl_id
204: );
205:
206: igs_ps_fac_ovr_wl_pkg.get_fk_igs_ps_fac_wl (
207: old_references.fac_wl_id
208: );
209:
210: END check_child_existance;

Line 227: FROM igs_ps_fac_wl

223: || (reverse chronological order - newest change first)
224: */
225: CURSOR cur_rowid IS
226: SELECT rowid
227: FROM igs_ps_fac_wl
228: WHERE fac_wl_id = x_fac_wl_id
229: FOR UPDATE NOWAIT;
230:
231: lv_rowid cur_rowid%RowType;

Line 264: FROM igs_ps_fac_wl

260: || (reverse chronological order - newest change first)
261: */
262: CURSOR cur_rowid IS
263: SELECT rowid
264: FROM igs_ps_fac_wl
265: WHERE person_id = x_person_id
266: AND cal_type = x_cal_type
267: AND ci_sequence_number = x_ci_sequence_number
268: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 301: FROM igs_ps_fac_wl

297: || (reverse chronological order - newest change first)
298: */
299: CURSOR cur_rowid IS
300: SELECT rowid
301: FROM igs_ps_fac_wl
302: WHERE ((cal_type = x_cal_type) AND
303: (ci_sequence_number = x_sequence_number));
304:
305: lv_rowid cur_rowid%RowType;

Line 486: FROM igs_ps_fac_wl

482: || (reverse chronological order - newest change first)
483: */
484: CURSOR c IS
485: SELECT rowid
486: FROM igs_ps_fac_wl
487: WHERE fac_wl_id = x_fac_wl_id;
488:
489: x_last_update_date DATE;
490: x_last_updated_by NUMBER;

Line 514: SELECT igs_ps_fac_wl_s.NEXTVAL

510: igs_ge_msg_stack.add;
511: app_exception.raise_exception;
512: END IF;
513:
514: SELECT igs_ps_fac_wl_s.NEXTVAL
515: INTO x_fac_wl_id
516: FROM dual;
517:
518: before_dml(

Line 554: INSERT INTO igs_ps_fac_wl (

550: x_last_updated_by => x_last_updated_by,
551: x_last_update_login => x_last_update_login
552: );
553:
554: INSERT INTO igs_ps_fac_wl (
555: fac_wl_id,
556: person_id,
557: calendar_cat,
558: cal_type,

Line 697: FROM igs_ps_fac_wl

693: attribute17,
694: attribute18,
695: attribute19,
696: attribute20
697: FROM igs_ps_fac_wl
698: WHERE rowid = x_rowid
699: FOR UPDATE NOWAIT;
700:
701: tlinfo c1%ROWTYPE;

Line 855: UPDATE igs_ps_fac_wl

851: x_last_updated_by => x_last_updated_by,
852: x_last_update_login => x_last_update_login
853: );
854:
855: UPDATE igs_ps_fac_wl
856: SET
857: person_id = new_references.person_id,
858: calendar_cat = new_references.calendar_cat,
859: cal_type = new_references.cal_type,

Line 935: FROM igs_ps_fac_wl

931: || (reverse chronological order - newest change first)
932: */
933: CURSOR c1 IS
934: SELECT rowid
935: FROM igs_ps_fac_wl
936: WHERE fac_wl_id = x_fac_wl_id;
937:
938: BEGIN
939:

Line 1032: DELETE FROM igs_ps_fac_wl

1028: p_action => 'DELETE',
1029: x_rowid => x_rowid
1030: );
1031:
1032: DELETE FROM igs_ps_fac_wl
1033: WHERE rowid = x_rowid;
1034:
1035: IF (SQL%NOTFOUND) THEN
1036: RAISE NO_DATA_FOUND;

Line 1042: END igs_ps_fac_wl_pkg;

1038:
1039: END delete_row;
1040:
1041:
1042: END igs_ps_fac_wl_pkg;