APPS.IGS_PS_EMP_CATS_WL_PKG dependencies on IGS_PS_EMP_CATS_WL

Line 1: PACKAGE BODY igs_ps_emp_cats_wl_pkg AS

1: PACKAGE BODY igs_ps_emp_cats_wl_pkg AS
2: /* $Header: IGSPI3KB.pls 120.0 2005/06/02 00:18:30 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_emp_cats_wl%ROWTYPE;

Line 5: old_references igs_ps_emp_cats_wl%ROWTYPE;

1: PACKAGE BODY igs_ps_emp_cats_wl_pkg AS
2: /* $Header: IGSPI3KB.pls 120.0 2005/06/02 00:18:30 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_emp_cats_wl%ROWTYPE;
6: new_references igs_ps_emp_cats_wl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_emp_cats_wl%ROWTYPE;

2: /* $Header: IGSPI3KB.pls 120.0 2005/06/02 00:18:30 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_emp_cats_wl%ROWTYPE;
6: new_references igs_ps_emp_cats_wl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_ps_emp_cats_wl

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

Line 113: FROM igs_ps_emp_cats_wl

109: || (reverse chronological order - newest change first)
110: */
111: CURSOR cur_rowid IS
112: SELECT rowid
113: FROM igs_ps_emp_cats_wl
114: WHERE cal_cat_code = x_cal_cat_code
115: AND emp_cat_code = x_emp_cat_code
116: FOR UPDATE NOWAIT;
117:

Line 149: FROM igs_ps_emp_cats_wl

145: || (reverse chronological order - newest change first)
146: */
147: CURSOR cur_rowid IS
148: SELECT rowid
149: FROM igs_ps_emp_cats_wl
150: WHERE ((cal_cat_code = x_calendar_cat));
151:
152: lv_rowid cur_rowid%RowType;
153:

Line 319: fnd_message.set_token ('ROUTINE', 'igs_ps_emp_cats_wl_PKG.INSERT_ROW');

315: x_last_update_login := -1;
316: END IF;
317: ELSE
318: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
319: fnd_message.set_token ('ROUTINE', 'igs_ps_emp_cats_wl_PKG.INSERT_ROW');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: END IF;
323:

Line 337: INSERT INTO igs_ps_emp_cats_wl (

333: x_last_updated_by => x_last_updated_by,
334: x_last_update_login => x_last_update_login
335: );
336:
337: INSERT INTO igs_ps_emp_cats_wl (
338: cal_cat_code,
339: emp_cat_code,
340: expected_wl_num,
341: creation_date,

Line 378: FROM igs_ps_emp_cats_wl

374: */
375: CURSOR c1 IS
376: SELECT
377: expected_wl_num
378: FROM igs_ps_emp_cats_wl
379: WHERE rowid = x_rowid
380: FOR UPDATE NOWAIT;
381:
382: tlinfo c1%ROWTYPE;

Line 449: fnd_message.set_token ('ROUTINE', 'igs_ps_emp_cats_wl_PKG.UPDATE_ROW');

445: x_last_update_login := -1;
446: END IF;
447: ELSE
448: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
449: fnd_message.set_token ('ROUTINE', 'igs_ps_emp_cats_wl_PKG.UPDATE_ROW');
450: igs_ge_msg_stack.add;
451: app_exception.raise_exception;
452: END IF;
453:

Line 467: UPDATE igs_ps_emp_cats_wl

463: x_last_updated_by => x_last_updated_by,
464: x_last_update_login => x_last_update_login
465: );
466:
467: UPDATE igs_ps_emp_cats_wl
468: SET
469: expected_wl_num = new_references.expected_wl_num,
470: last_update_date = x_last_update_date,
471: last_updated_by = x_last_updated_by,

Line 503: FROM igs_ps_emp_cats_wl

499: || (reverse chronological order - newest change first)
500: */
501: CURSOR c1 IS
502: SELECT rowid
503: FROM igs_ps_emp_cats_wl
504: WHERE cal_cat_code = x_cal_cat_code
505: AND emp_cat_code = x_emp_cat_code;
506:
507: BEGIN

Line 555: DELETE FROM igs_ps_emp_cats_wl

551: p_action => 'DELETE',
552: x_rowid => x_rowid
553: );
554:
555: DELETE FROM igs_ps_emp_cats_wl
556: WHERE rowid = x_rowid;
557:
558: IF (SQL%NOTFOUND) THEN
559: RAISE NO_DATA_FOUND;

Line 565: END igs_ps_emp_cats_wl_pkg;

561:
562: END delete_row;
563:
564:
565: END igs_ps_emp_cats_wl_pkg;