APPS.IGS_TR_TSTP_GRP_LMT_PKG dependencies on IGS_TR_TSTP_GRP_LMT

Line 1: PACKAGE BODY igs_tr_tstp_grp_lmt_pkg AS

1: PACKAGE BODY igs_tr_tstp_grp_lmt_pkg AS
2: /* $Header: IGSTI14B.pls 115.2 2002/11/29 04:17:33 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_tstp_grp_lmt%ROWTYPE;

Line 5: old_references igs_tr_tstp_grp_lmt%ROWTYPE;

1: PACKAGE BODY igs_tr_tstp_grp_lmt_pkg AS
2: /* $Header: IGSTI14B.pls 115.2 2002/11/29 04:17:33 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_tstp_grp_lmt%ROWTYPE;
6: new_references igs_tr_tstp_grp_lmt%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_tr_tstp_grp_lmt%ROWTYPE;

2: /* $Header: IGSTI14B.pls 115.2 2002/11/29 04:17:33 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_tstp_grp_lmt%ROWTYPE;
6: new_references igs_tr_tstp_grp_lmt%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM igs_tr_tstp_grp_lmt

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

Line 87: FROM igs_tr_tstp_grp_lmt

83: || (reverse chronological order - newest change first)
84: */
85: CURSOR cur_rowid IS
86: SELECT rowid
87: FROM igs_tr_tstp_grp_lmt
88: WHERE tracking_type = x_tracking_type
89: AND step_group_id = x_step_group_id
90: FOR UPDATE NOWAIT;
91:

Line 191: FROM igs_tr_tstp_grp_lmt

187: || (reverse chronological order - newest change first)
188: */
189: CURSOR c IS
190: SELECT rowid
191: FROM igs_tr_tstp_grp_lmt
192: WHERE tracking_type = x_tracking_type
193: AND step_group_id = x_step_group_id;
194:
195: x_last_update_date DATE;

Line 233: INSERT INTO igs_tr_tstp_grp_lmt (

229: x_last_updated_by => x_last_updated_by,
230: x_last_update_login => x_last_update_login
231: );
232:
233: INSERT INTO igs_tr_tstp_grp_lmt (
234: tracking_type,
235: step_group_id,
236: step_group_limit,
237: creation_date,

Line 282: FROM igs_tr_tstp_grp_lmt

278: */
279: CURSOR c1 IS
280: SELECT
281: step_group_limit
282: FROM igs_tr_tstp_grp_lmt
283: WHERE rowid = x_rowid
284: FOR UPDATE NOWAIT;
285:
286: tlinfo c1%ROWTYPE;

Line 370: UPDATE igs_tr_tstp_grp_lmt

366: x_last_updated_by => x_last_updated_by,
367: x_last_update_login => x_last_update_login
368: );
369:
370: UPDATE igs_tr_tstp_grp_lmt
371: SET
372: step_group_limit = new_references.step_group_limit,
373: last_update_date = x_last_update_date,
374: last_updated_by = x_last_updated_by,

Line 403: FROM igs_tr_tstp_grp_lmt

399: || (reverse chronological order - newest change first)
400: */
401: CURSOR c1 IS
402: SELECT rowid
403: FROM igs_tr_tstp_grp_lmt
404: WHERE tracking_type = x_tracking_type
405: AND step_group_id = x_step_group_id;
406:
407: BEGIN

Line 455: DELETE FROM igs_tr_tstp_grp_lmt

451: p_action => 'DELETE',
452: x_rowid => x_rowid
453: );
454:
455: DELETE FROM igs_tr_tstp_grp_lmt
456: WHERE rowid = x_rowid;
457:
458: IF (SQL%NOTFOUND) THEN
459: RAISE NO_DATA_FOUND;

Line 465: END igs_tr_tstp_grp_lmt_pkg;

461:
462: END delete_row;
463:
464:
465: END igs_tr_tstp_grp_lmt_pkg;