APPS.IGS_TR_GROUP_MEMBER_PKG dependencies on IGS_TR_GROUP_MEMBER

Line 1: PACKAGE BODY igs_tr_group_member_pkg AS

1: PACKAGE BODY igs_tr_group_member_pkg AS
2: /* $Header: IGSTI10B.pls 115.5 2002/11/29 04:16:27 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_group_member%ROWTYPE;

Line 5: old_references igs_tr_group_member%ROWTYPE;

1: PACKAGE BODY igs_tr_group_member_pkg AS
2: /* $Header: IGSTI10B.pls 115.5 2002/11/29 04:16:27 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_group_member%ROWTYPE;
6: new_references igs_tr_group_member%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_tr_group_member%ROWTYPE;

2: /* $Header: IGSTI10B.pls 115.5 2002/11/29 04:16:27 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_tr_group_member%ROWTYPE;
6: new_references igs_tr_group_member%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM igs_tr_group_member

18: ) AS
19:
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM igs_tr_group_member
23: WHERE ROWID = x_rowid;
24:
25: BEGIN
26:

Line 97: FROM igs_tr_group_member

93: RETURN BOOLEAN AS
94:
95: CURSOR cur_rowid IS
96: SELECT ROWID
97: FROM igs_tr_group_member
98: WHERE tracking_group_id = x_tracking_group_id
99: AND tracking_id = x_tracking_id
100: FOR UPDATE NOWAIT;
101:

Line 124: FROM igs_tr_group_member

120: ) AS
121:
122: CURSOR cur_rowid IS
123: SELECT ROWID
124: FROM igs_tr_group_member
125: WHERE tracking_group_id = x_tracking_group_id ;
126:
127: lv_rowid cur_rowid%ROWTYPE;
128:

Line 150: FROM igs_tr_group_member

146: ) AS
147:
148: CURSOR cur_rowid IS
149: SELECT ROWID
150: FROM igs_tr_group_member
151: WHERE tracking_id = x_tracking_id ;
152:
153: lv_rowid cur_rowid%ROWTYPE;
154:

Line 241: FROM igs_tr_group_member

237: ) AS
238:
239: CURSOR c IS
240: SELECT ROWID
241: FROM igs_tr_group_member
242: WHERE tracking_group_id = x_tracking_group_id
243: AND tracking_id = x_tracking_id;
244:
245: x_last_update_date DATE;

Line 285: INSERT INTO igs_tr_group_member (

281: x_last_updated_by => x_last_updated_by,
282: x_last_update_login => x_last_update_login
283: );
284:
285: INSERT INTO igs_tr_group_member (
286: tracking_group_id,
287: tracking_id,
288: creation_date,
289: created_by,

Line 326: FROM igs_tr_group_member

322: ) AS
323:
324: CURSOR c1 IS
325: SELECT ROWID
326: FROM igs_tr_group_member
327: WHERE ROWID = x_rowid
328: FOR UPDATE NOWAIT;
329:
330: tlinfo c1%ROWTYPE;

Line 359: DELETE FROM igs_tr_group_member WHERE ROWID = x_rowid;

355: p_action =>'DELETE',
356: x_rowid => x_rowid
357: );
358:
359: DELETE FROM igs_tr_group_member WHERE ROWID = x_rowid;
360: IF (SQL%NOTFOUND) THEN
361: RAISE no_data_found;
362: END IF;
363: after_dml(

Line 370: END igs_tr_group_member_pkg;

366: );
367:
368: END delete_row;
369:
370: END igs_tr_group_member_pkg;