APPS.IGS_PS_USEC_ACT_TYPE_PKG dependencies on IGS_PS_USEC_ACT_TYPE

Line 1: PACKAGE BODY igs_ps_usec_act_type_pkg AS

1: PACKAGE BODY igs_ps_usec_act_type_pkg AS
2: /* $Header: IGSPI2JB.pls 115.5 2003/03/13 15:13:10 smvk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_act_type%ROWTYPE;

Line 5: old_references igs_ps_usec_act_type%ROWTYPE;

1: PACKAGE BODY igs_ps_usec_act_type_pkg AS
2: /* $Header: IGSPI2JB.pls 115.5 2003/03/13 15:13:10 smvk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_act_type%ROWTYPE;
6: new_references igs_ps_usec_act_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_usec_act_type%ROWTYPE;

2: /* $Header: IGSPI2JB.pls 115.5 2003/03/13 15:13:10 smvk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_act_type%ROWTYPE;
6: new_references igs_ps_usec_act_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_PS_USEC_ACT_TYPE

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

Line 109: igs_ps_us_unsched_cl_pkg.get_fk_igs_ps_usec_act_type (

105: || (reverse chronological order - newest change first)
106: */
107: BEGIN
108:
109: igs_ps_us_unsched_cl_pkg.get_fk_igs_ps_usec_act_type (
110: old_references.activity_type_id
111: );
112:
113: END check_child_existance;

Line 129: FROM igs_ps_usec_act_type

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

Line 164: FROM igs_ps_usec_act_type

160: || (reverse chronological order - newest change first)
161: */
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM igs_ps_usec_act_type
165: WHERE activity_type_code = x_activity_type_code
166: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
167:
168: lv_rowid cur_rowid%RowType;

Line 283: FROM igs_ps_usec_act_type

279: || (reverse chronological order - newest change first)
280: */
281: CURSOR c IS
282: SELECT rowid
283: FROM igs_ps_usec_act_type
284: WHERE activity_type_id = x_activity_type_id;
285:
286: x_last_update_date DATE;
287: x_last_updated_by NUMBER;

Line 311: SELECT igs_ps_usec_act_type_s.NEXTVAL

307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310:
311: SELECT igs_ps_usec_act_type_s.NEXTVAL
312: INTO x_activity_type_id
313: FROM dual;
314:
315: before_dml(

Line 329: INSERT INTO igs_ps_usec_act_type (

325: x_last_updated_by => x_last_updated_by,
326: x_last_update_login => x_last_update_login
327: );
328:
329: INSERT INTO igs_ps_usec_act_type (
330: activity_type_id,
331: activity_type_code,
332: activity_type_description,
333: closed_ind,

Line 383: FROM igs_ps_usec_act_type

379: SELECT
380: activity_type_code,
381: activity_type_description,
382: closed_ind
383: FROM igs_ps_usec_act_type
384: WHERE rowid = x_rowid
385: FOR UPDATE NOWAIT;
386:
387: tlinfo c1%ROWTYPE;

Line 475: UPDATE igs_ps_usec_act_type

471: x_last_updated_by => x_last_updated_by,
472: x_last_update_login => x_last_update_login
473: );
474:
475: UPDATE igs_ps_usec_act_type
476: SET
477: activity_type_code = new_references.activity_type_code,
478: activity_type_description = new_references.activity_type_description,
479: closed_ind = new_references.closed_ind,

Line 511: FROM igs_ps_usec_act_type

507: || (reverse chronological order - newest change first)
508: */
509: CURSOR c1 IS
510: SELECT rowid
511: FROM igs_ps_usec_act_type
512: WHERE activity_type_id = x_activity_type_id;
513:
514: BEGIN
515:

Line 564: DELETE FROM igs_ps_usec_act_type

560: p_action => 'DELETE',
561: x_rowid => x_rowid
562: );
563:
564: DELETE FROM igs_ps_usec_act_type
565: WHERE rowid = x_rowid;
566:
567: IF (SQL%NOTFOUND) THEN
568: RAISE NO_DATA_FOUND;

Line 574: END igs_ps_usec_act_type_pkg;

570:
571: END delete_row;
572:
573:
574: END igs_ps_usec_act_type_pkg;