APPS.IGS_AZ_GROUPS_PKG dependencies on IGS_AZ_GROUPS

Line 1: PACKAGE BODY igs_az_groups_pkg AS

1: PACKAGE BODY igs_az_groups_pkg AS
2: /* $Header: IGSHI01B.pls 115.6 2003/10/30 13:29:08 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_az_groups%ROWTYPE;

Line 5: old_references igs_az_groups%ROWTYPE;

1: PACKAGE BODY igs_az_groups_pkg AS
2: /* $Header: IGSHI01B.pls 115.6 2003/10/30 13:29:08 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_az_groups%ROWTYPE;
6: new_references igs_az_groups%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_az_groups%ROWTYPE;

2: /* $Header: IGSHI01B.pls 115.6 2003/10/30 13:29:08 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_az_groups%ROWTYPE;
6: new_references igs_az_groups%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 73: FROM igs_az_groups

69: */
70:
71: CURSOR cur_old_ref_values IS
72: SELECT *
73: FROM igs_az_groups
74: WHERE rowid = x_rowid;
75:
76: BEGIN
77:

Line 226: IGS_AZ_ADVISING_RELS_pkg.get_fk_igs_az_groups (

222: || (reverse chronological order - newest change first)
223: */
224: BEGIN
225:
226: IGS_AZ_ADVISING_RELS_pkg.get_fk_igs_az_groups (
227: old_references.group_name
228: );
229:
230: IGS_AZ_ADVISORS_pkg.get_fk_igs_az_groups (

Line 230: IGS_AZ_ADVISORS_pkg.get_fk_igs_az_groups (

226: IGS_AZ_ADVISING_RELS_pkg.get_fk_igs_az_groups (
227: old_references.group_name
228: );
229:
230: IGS_AZ_ADVISORS_pkg.get_fk_igs_az_groups (
231: old_references.group_name
232: );
233:
234: IGS_AZ_STUDENTS_pkg.get_fk_igs_az_groups (

Line 234: IGS_AZ_STUDENTS_pkg.get_fk_igs_az_groups (

230: IGS_AZ_ADVISORS_pkg.get_fk_igs_az_groups (
231: old_references.group_name
232: );
233:
234: IGS_AZ_STUDENTS_pkg.get_fk_igs_az_groups (
235: old_references.group_name
236: );
237:
238: END check_child_existance;

Line 255: FROM igs_az_groups

251: || (reverse chronological order - newest change first)
252: */
253: CURSOR cur_rowid IS
254: SELECT rowid
255: FROM igs_az_groups
256: WHERE group_name = x_group_name;
257:
258: lv_rowid cur_rowid%RowType;
259:

Line 289: FROM igs_az_groups

285: || (reverse chronological order - newest change first)
286: */
287: CURSOR cur_rowid IS
288: SELECT rowid
289: FROM igs_az_groups
290: WHERE ((location_cd = x_location_cd));
291:
292: lv_rowid cur_rowid%RowType;
293:

Line 300: fnd_message.set_name ('IGS', 'IGS_AZ_GROUPS_LOC_FK');

296: OPEN cur_rowid;
297: FETCH cur_rowid INTO lv_rowid;
298: IF (cur_rowid%FOUND) THEN
299: CLOSE cur_rowid;
300: fnd_message.set_name ('IGS', 'IGS_AZ_GROUPS_LOC_FK');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: RETURN;
304: END IF;

Line 324: FROM igs_az_groups

320: || (reverse chronological order - newest change first)
321: */
322: CURSOR cur_rowid IS
323: SELECT rowid
324: FROM igs_az_groups
325: WHERE ((advisor_group_id = x_group_id))
326: OR ((student_group_id = x_group_id));
327:
328: lv_rowid cur_rowid%RowType;

Line 336: fnd_message.set_name ('IGS', 'IGS_AZ_GROUPS_PERS_FK');

332: OPEN cur_rowid;
333: FETCH cur_rowid INTO lv_rowid;
334: IF (cur_rowid%FOUND) THEN
335: CLOSE cur_rowid;
336: fnd_message.set_name ('IGS', 'IGS_AZ_GROUPS_PERS_FK');
337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: RETURN;
340: END IF;

Line 360: FROM igs_az_groups

356: || (reverse chronological order - newest change first)
357: */
358: CURSOR cur_rowid IS
359: SELECT rowid
360: FROM igs_az_groups
361: WHERE ((advising_hold_type = x_encumbrance_type));
362:
363: lv_rowid cur_rowid%RowType;
364:

Line 371: fnd_message.set_name ('IGS', 'IGS_AZ_GROUPS_ENCMB_FK');

367: OPEN cur_rowid;
368: FETCH cur_rowid INTO lv_rowid;
369: IF (cur_rowid%FOUND) THEN
370: CLOSE cur_rowid;
371: fnd_message.set_name ('IGS', 'IGS_AZ_GROUPS_ENCMB_FK');
372: igs_ge_msg_stack.add;
373: app_exception.raise_exception;
374: RETURN;
375: END IF;

Line 616: fnd_message.set_token ('ROUTINE', 'IGS_AZ_GROUPS_PKG.INSERT_ROW');

612: x_last_update_login := -1;
613: END IF;
614: ELSE
615: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
616: fnd_message.set_token ('ROUTINE', 'IGS_AZ_GROUPS_PKG.INSERT_ROW');
617: igs_ge_msg_stack.add;
618: app_exception.raise_exception;
619: END IF;
620:

Line 675: INSERT INTO igs_az_groups (

671: x_last_updated_by => x_last_updated_by,
672: x_last_update_login => x_last_update_login
673: );
674:
675: INSERT INTO igs_az_groups (
676: group_name,
677: group_desc,
678: advising_code,
679: resp_org_unit_cd,

Line 918: FROM igs_az_groups

914: attribute17,
915: attribute18,
916: attribute19,
917: attribute20
918: FROM igs_az_groups
919: WHERE rowid = x_rowid
920: FOR UPDATE NOWAIT;
921:
922: tlinfo c1%ROWTYPE;

Line 1110: fnd_message.set_token ('ROUTINE', 'IGS_AZ_GROUPS_PKG.UPDATE_ROW');

1106: x_last_update_login := -1;
1107: END IF;
1108: ELSE
1109: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1110: fnd_message.set_token ('ROUTINE', 'IGS_AZ_GROUPS_PKG.UPDATE_ROW');
1111: igs_ge_msg_stack.add;
1112: app_exception.raise_exception;
1113: END IF;
1114:

Line 1169: UPDATE igs_az_groups

1165: x_last_updated_by => x_last_updated_by,
1166: x_last_update_login => x_last_update_login
1167: );
1168:
1169: UPDATE igs_az_groups
1170: SET
1171: group_desc = new_references.group_desc,
1172: advising_code = new_references.advising_code,
1173: resp_org_unit_cd = new_references.resp_org_unit_cd,

Line 1318: FROM igs_az_groups

1314: || (reverse chronological order - newest change first)
1315: */
1316: CURSOR c1 IS
1317: SELECT rowid
1318: FROM igs_az_groups
1319: WHERE group_name = x_group_name;
1320: l_return_status VARCHAR2(10);
1321: l_msg_data VARCHAR2(2000);
1322: l_msg_count NUMBER(10);

Line 1462: DELETE FROM igs_az_groups

1458: p_action => 'DELETE',
1459: x_rowid => x_rowid
1460: );
1461:
1462: DELETE FROM igs_az_groups
1463: WHERE rowid = x_rowid;
1464:
1465: IF (SQL%NOTFOUND) THEN
1466: RAISE NO_DATA_FOUND;

Line 1506: END igs_az_groups_pkg;

1502: RETURN;
1503: END delete_row;
1504:
1505:
1506: END igs_az_groups_pkg;