APPS.IGS_PS_FAC_ASG_TASK_PKG dependencies on IGS_PS_FAC_ASG_TASK

Line 1: PACKAGE BODY igs_ps_fac_asg_task_pkg AS

1: PACKAGE BODY igs_ps_fac_asg_task_pkg AS
2: /* $Header: IGSPI3HB.pls 115.5 2003/06/05 13:14:46 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_asg_task%ROWTYPE;

Line 5: old_references igs_ps_fac_asg_task%ROWTYPE;

1: PACKAGE BODY igs_ps_fac_asg_task_pkg AS
2: /* $Header: IGSPI3HB.pls 115.5 2003/06/05 13:14:46 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_asg_task%ROWTYPE;
6: new_references igs_ps_fac_asg_task%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_fac_asg_task%ROWTYPE;

2: /* $Header: IGSPI3HB.pls 115.5 2003/06/05 13:14:46 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_asg_task%ROWTYPE;
6: new_references igs_ps_fac_asg_task%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM igs_ps_fac_asg_task

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

Line 132: FROM igs_ps_fac_asg_task

128: || (reverse chronological order - newest change first)
129: */
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM igs_ps_fac_asg_task
133: WHERE fac_wl_id = x_fac_wl_id
134: AND faculty_task_type = x_faculty_task_type
135: FOR UPDATE NOWAIT;
136:

Line 168: FROM igs_ps_fac_asg_task

164: || (reverse chronological order - newest change first)
165: */
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM igs_ps_fac_asg_task
169: WHERE ((fac_wl_id = x_fac_wl_id));
170:
171: lv_rowid cur_rowid%RowType;
172:

Line 338: FROM igs_ps_fac_asg_task

334: || (reverse chronological order - newest change first)
335: */
336: CURSOR c IS
337: SELECT rowid
338: FROM igs_ps_fac_asg_task
339: WHERE fac_wl_id = x_fac_wl_id
340: AND faculty_task_type = x_faculty_task_type;
341:
342: x_last_update_date DATE;

Line 384: INSERT INTO igs_ps_fac_asg_task (

380: x_last_updated_by => x_last_updated_by,
381: x_last_update_login => x_last_update_login
382: );
383:
384: INSERT INTO igs_ps_fac_asg_task (
385: fac_wl_id,
386: faculty_task_type,
387: confirmed_ind,
388: num_rollover_period,

Line 449: FROM igs_ps_fac_asg_task

445: num_rollover_period,
446: rollover_flag,
447: dept_budget_cd,
448: default_wl
449: FROM igs_ps_fac_asg_task
450: WHERE rowid = x_rowid
451: FOR UPDATE NOWAIT;
452:
453: tlinfo c1%ROWTYPE;

Line 549: UPDATE igs_ps_fac_asg_task

545: x_last_updated_by => x_last_updated_by,
546: x_last_update_login => x_last_update_login
547: );
548:
549: UPDATE igs_ps_fac_asg_task
550: SET
551: confirmed_ind = new_references.confirmed_ind,
552: num_rollover_period = new_references.num_rollover_period,
553: rollover_flag = new_references.rollover_flag,

Line 590: FROM igs_ps_fac_asg_task

586: || (reverse chronological order - newest change first)
587: */
588: CURSOR c1 IS
589: SELECT rowid
590: FROM igs_ps_fac_asg_task
591: WHERE fac_wl_id = x_fac_wl_id
592: AND faculty_task_type = x_faculty_task_type;
593:
594: BEGIN

Line 650: DELETE FROM igs_ps_fac_asg_task

646: p_action => 'DELETE',
647: x_rowid => x_rowid
648: );
649:
650: DELETE FROM igs_ps_fac_asg_task
651: WHERE rowid = x_rowid;
652:
653: IF (SQL%NOTFOUND) THEN
654: RAISE NO_DATA_FOUND;

Line 660: END igs_ps_fac_asg_task_pkg;

656:
657: END delete_row;
658:
659:
660: END igs_ps_fac_asg_task_pkg;