APPS.IGS_TR_STP_CTL_TYPE_PKG dependencies on IGS_TR_STP_CTL_TYPE

Line 1: PACKAGE BODY igs_tr_stp_ctl_type_pkg AS

1: PACKAGE BODY igs_tr_stp_ctl_type_pkg AS
2: /* $Header: IGSTI16B.pls 115.0 2003/04/30 13:31:18 kumma noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_stp_ctl_type%ROWTYPE;

Line 5: old_references igs_tr_stp_ctl_type%ROWTYPE;

1: PACKAGE BODY igs_tr_stp_ctl_type_pkg AS
2: /* $Header: IGSTI16B.pls 115.0 2003/04/30 13:31:18 kumma noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_stp_ctl_type%ROWTYPE;
6: new_references igs_tr_stp_ctl_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_tr_stp_ctl_type%ROWTYPE;

2: /* $Header: IGSTI16B.pls 115.0 2003/04/30 13:31:18 kumma noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_stp_ctl_type%ROWTYPE;
6: new_references igs_tr_stp_ctl_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_tr_stp_ctl_type

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

Line 123: FROM igs_tr_stp_ctl_type

119: || (reverse chronological order - newest change first)
120: */
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM igs_tr_stp_ctl_type
124: WHERE step_catalog_id = x_step_catalog_id
125: AND s_tracking_type = x_s_tracking_type
126: FOR UPDATE NOWAIT;
127:

Line 239: fnd_message.set_token ('ROUTINE', 'IGS_TR_STP_CTL_TYPE_PKG.INSERT_ROW');

235: x_last_update_login := -1;
236: END IF;
237: ELSE
238: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
239: fnd_message.set_token ('ROUTINE', 'IGS_TR_STP_CTL_TYPE_PKG.INSERT_ROW');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception;
242: END IF;
243:

Line 257: INSERT INTO igs_tr_stp_ctl_type (

253: x_last_updated_by => x_last_updated_by,
254: x_last_update_login => x_last_update_login
255: );
256:
257: INSERT INTO igs_tr_stp_ctl_type (
258: step_catalog_id,
259: s_tracking_type,
260: closed_ind,
261: creation_date,

Line 298: FROM igs_tr_stp_ctl_type

294: */
295: CURSOR c1 IS
296: SELECT
297: closed_ind
298: FROM igs_tr_stp_ctl_type
299: WHERE rowid = x_rowid
300: FOR UPDATE NOWAIT;
301:
302: tlinfo c1%ROWTYPE;

Line 369: fnd_message.set_token ('ROUTINE', 'IGS_TR_STP_CTL_TYPE_PKG.UPDATE_ROW');

365: x_last_update_login := -1;
366: END IF;
367: ELSE
368: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
369: fnd_message.set_token ('ROUTINE', 'IGS_TR_STP_CTL_TYPE_PKG.UPDATE_ROW');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373:

Line 387: UPDATE igs_tr_stp_ctl_type

383: x_last_updated_by => x_last_updated_by,
384: x_last_update_login => x_last_update_login
385: );
386:
387: UPDATE igs_tr_stp_ctl_type
388: SET
389: closed_ind = new_references.closed_ind,
390: last_update_date = x_last_update_date,
391: last_updated_by = x_last_updated_by,

Line 420: FROM igs_tr_stp_ctl_type

416: || (reverse chronological order - newest change first)
417: */
418: CURSOR c1 IS
419: SELECT rowid
420: FROM igs_tr_stp_ctl_type
421: WHERE step_catalog_id = x_step_catalog_id
422: AND s_tracking_type = x_s_tracking_type;
423:
424: BEGIN

Line 472: DELETE FROM igs_tr_stp_ctl_type

468: p_action => 'DELETE',
469: x_rowid => x_rowid
470: );
471:
472: DELETE FROM igs_tr_stp_ctl_type
473: WHERE rowid = x_rowid;
474:
475: IF (SQL%NOTFOUND) THEN
476: RAISE NO_DATA_FOUND;

Line 482: END igs_tr_stp_ctl_type_pkg;

478:
479: END delete_row;
480:
481:
482: END igs_tr_stp_ctl_type_pkg;