APPS.IGS_PS_FAC_TASK_TYP_PKG dependencies on IGS_PS_FAC_TASK_TYP

Line 1: PACKAGE BODY igs_ps_fac_task_typ_pkg AS

1: PACKAGE BODY igs_ps_fac_task_typ_pkg AS
2: /* $Header: IGSPI3FB.pls 115.3 2003/06/05 13:15:33 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_task_typ%ROWTYPE;

Line 5: old_references igs_ps_fac_task_typ%ROWTYPE;

1: PACKAGE BODY igs_ps_fac_task_typ_pkg AS
2: /* $Header: IGSPI3FB.pls 115.3 2003/06/05 13:15:33 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_fac_task_typ%ROWTYPE;
6: new_references igs_ps_fac_task_typ%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_fac_task_typ%ROWTYPE;

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

Line 34: FROM igs_ps_fac_task_typ

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

Line 119: FROM igs_ps_fac_task_typ

115: || (reverse chronological order - newest change first)
116: */
117: CURSOR cur_rowid IS
118: SELECT rowid
119: FROM igs_ps_fac_task_typ
120: WHERE faculty_task_type = x_faculty_task_type ;
121:
122: lv_rowid cur_rowid%RowType;
123:

Line 231: FROM igs_ps_fac_task_typ

227: || (reverse chronological order - newest change first)
228: */
229: CURSOR c IS
230: SELECT rowid
231: FROM igs_ps_fac_task_typ
232: WHERE faculty_task_type = x_faculty_task_type;
233:
234: x_last_update_date DATE;
235: x_last_updated_by NUMBER;

Line 274: INSERT INTO igs_ps_fac_task_typ (

270: x_last_updated_by => x_last_updated_by,
271: x_last_update_login => x_last_update_login
272: );
273:
274: INSERT INTO igs_ps_fac_task_typ (
275: faculty_task_type,
276: description,
277: dept_budget_cd,
278: default_wl,

Line 332: FROM igs_ps_fac_task_typ

328: description,
329: dept_budget_cd,
330: default_wl,
331: closed_ind
332: FROM igs_ps_fac_task_typ
333: WHERE rowid = x_rowid
334: FOR UPDATE NOWAIT;
335:
336: tlinfo c1%ROWTYPE;

Line 427: UPDATE igs_ps_fac_task_typ

423: x_last_updated_by => x_last_updated_by,
424: x_last_update_login => x_last_update_login
425: );
426:
427: UPDATE igs_ps_fac_task_typ
428: SET
429: description = new_references.description,
430: dept_budget_cd = new_references.dept_budget_cd,
431: default_wl = new_references.default_wl,

Line 465: FROM igs_ps_fac_task_typ

461: || (reverse chronological order - newest change first)
462: */
463: CURSOR c1 IS
464: SELECT rowid
465: FROM igs_ps_fac_task_typ
466: WHERE faculty_task_type = x_faculty_task_type;
467:
468: BEGIN
469:

Line 501: END igs_ps_fac_task_typ_pkg;

497:
498: END add_row;
499:
500:
501: END igs_ps_fac_task_typ_pkg;