eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_SUA_AI_GROUP_PKG dependencies on IGS_AS_SUA_AI_GROUP

Line 1: PACKAGE BODY igs_as_sua_ai_group_pkg AS

1: PACKAGE BODY igs_as_sua_ai_group_pkg AS
2: /* $Header: IGSDI83B.pls 120.0 2005/07/05 13:03:38 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_sua_ai_group%ROWTYPE;

Line 5: old_references igs_as_sua_ai_group%ROWTYPE;

1: PACKAGE BODY igs_as_sua_ai_group_pkg AS
2: /* $Header: IGSDI83B.pls 120.0 2005/07/05 13:03:38 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_sua_ai_group%ROWTYPE;
6: new_references igs_as_sua_ai_group%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_sua_ai_group%ROWTYPE;

2: /* $Header: IGSDI83B.pls 120.0 2005/07/05 13:03:38 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_sua_ai_group%ROWTYPE;
6: new_references igs_as_sua_ai_group%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 43: FROM igs_as_sua_ai_group

39: */
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM igs_as_sua_ai_group
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 131: igs_as_su_atmpt_itm_pkg.get_fk_igs_as_sua_ai_group (

127: || Who When What
128: || (reverse chronological order - newest change first)
129: */
130: BEGIN
131: igs_as_su_atmpt_itm_pkg.get_fk_igs_as_sua_ai_group (
132: old_references.sua_ass_item_group_id
133: );
134: igs_as_suaai_ouhist_pkg.get_fk_igs_as_sua_ai_group (
135: old_references.sua_ass_item_group_id

Line 134: igs_as_suaai_ouhist_pkg.get_fk_igs_as_sua_ai_group (

130: BEGIN
131: igs_as_su_atmpt_itm_pkg.get_fk_igs_as_sua_ai_group (
132: old_references.sua_ass_item_group_id
133: );
134: igs_as_suaai_ouhist_pkg.get_fk_igs_as_sua_ai_group (
135: old_references.sua_ass_item_group_id
136: );
137: END check_child_existance;
138:

Line 207: FROM igs_as_sua_ai_group

203: || (reverse chronological order - newest change first)
204: */
205: CURSOR cur_rowid IS
206: SELECT rowid
207: FROM igs_as_sua_ai_group
208: WHERE sua_ass_item_group_id = x_sua_ass_item_group_id
209: FOR UPDATE NOWAIT;
210:
211: lv_rowid cur_rowid%RowType;

Line 245: FROM igs_as_sua_ai_group

241: || (reverse chronological order - newest change first)
242: */
243: CURSOR cur_rowid IS
244: SELECT rowid
245: FROM igs_as_sua_ai_group
246: WHERE person_id = x_person_id
247: AND course_cd = x_course_cd
248: AND uoo_id = x_uoo_id
249: AND group_name = x_group_name

Line 285: FROM igs_as_sua_ai_group

281: || (reverse chronological order - newest change first)
282: */
283: CURSOR cur_rowid IS
284: SELECT rowid
285: FROM igs_as_sua_ai_group
286: WHERE ((course_cd = x_course_cd) AND
287: (person_id = x_person_id) AND
288: (uoo_id = x_uoo_id));
289:

Line 322: FROM igs_as_sua_ai_group

318: || (reverse chronological order - newest change first)
319: */
320: CURSOR cur_rowid IS
321: SELECT rowid
322: FROM igs_as_sua_ai_group
323: WHERE ((unit_ass_item_group_id = x_unit_ass_item_group_id));
324:
325: lv_rowid cur_rowid%RowType;
326:

Line 357: FROM igs_as_sua_ai_group

353: || (reverse chronological order - newest change first)
354: */
355: CURSOR cur_rowid IS
356: SELECT rowid
357: FROM igs_as_sua_ai_group
358: WHERE ((us_ass_item_group_id = x_us_ass_item_group_id));
359:
360: lv_rowid cur_rowid%RowType;
361:

Line 522: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.INSERT_ROW');

518: x_last_update_login := -1;
519: END IF;
520: ELSE
521: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
522: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.INSERT_ROW');
523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
526:

Line 556: INSERT INTO igs_as_sua_ai_group (

552:
553: IF (x_mode = 'S') THEN
554: igs_sc_gen_001.set_ctx('R');
555: END IF;
556: INSERT INTO igs_as_sua_ai_group (
557: sua_ass_item_group_id,
558: person_id,
559: course_cd,
560: uoo_id,

Line 577: igs_as_sua_ai_group_s.NEXTVAL,

573: last_update_date,
574: last_updated_by,
575: last_update_login
576: ) VALUES (
577: igs_as_sua_ai_group_s.NEXTVAL,
578: new_references.person_id,
579: new_references.course_cd,
580: new_references.uoo_id,
581: new_references.group_name,

Line 662: FROM igs_as_sua_ai_group

658: final_weight_qty,
659: unit_ass_item_group_id,
660: us_ass_item_group_id,
661: logical_delete_date
662: FROM igs_as_sua_ai_group
663: WHERE rowid = x_rowid
664: FOR UPDATE NOWAIT;
665:
666: tlinfo c1%ROWTYPE;

Line 756: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.UPDATE_ROW');

752: x_last_update_login := -1;
753: END IF;
754: ELSE
755: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
756: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.UPDATE_ROW');
757: igs_ge_msg_stack.add;
758: app_exception.raise_exception;
759: END IF;
760:

Line 788: UPDATE igs_as_sua_ai_group

784:
785: IF (x_mode = 'S') THEN
786: igs_sc_gen_001.set_ctx('R');
787: END IF;
788: UPDATE igs_as_sua_ai_group
789: SET
790: person_id = new_references.person_id,
791: course_cd = new_references.course_cd,
792: uoo_id = new_references.uoo_id,

Line 864: FROM igs_as_sua_ai_group

860: || (reverse chronological order - newest change first)
861: */
862: CURSOR c1 IS
863: SELECT rowid
864: FROM igs_as_sua_ai_group
865: WHERE sua_ass_item_group_id = x_sua_ass_item_group_id;
866:
867: BEGIN
868:

Line 941: DELETE FROM igs_as_sua_ai_group

937:
938: IF (x_mode = 'S') THEN
939: igs_sc_gen_001.set_ctx('R');
940: END IF;
941: DELETE FROM igs_as_sua_ai_group
942: WHERE rowid = x_rowid;
943:
944: IF (SQL%NOTFOUND) THEN
945: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 958: END igs_as_sua_ai_group_pkg;

954:
955: END delete_row;
956:
957:
958: END igs_as_sua_ai_group_pkg;