APPS.IGS_AS_UNIT_AI_GRP_PKG dependencies on IGS_AS_UNIT_AI_GRP

Line 1: PACKAGE BODY igs_as_unit_ai_grp_pkg AS

1: PACKAGE BODY igs_as_unit_ai_grp_pkg AS
2: /* $Header: IGSDI81B.pls 115.0 2003/12/05 10:39:40 kdande noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_unit_ai_grp%ROWTYPE;

Line 5: old_references igs_as_unit_ai_grp%ROWTYPE;

1: PACKAGE BODY igs_as_unit_ai_grp_pkg AS
2: /* $Header: IGSDI81B.pls 115.0 2003/12/05 10:39:40 kdande noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_unit_ai_grp%ROWTYPE;
6: new_references igs_as_unit_ai_grp%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_unit_ai_grp%ROWTYPE;

2: /* $Header: IGSDI81B.pls 115.0 2003/12/05 10:39:40 kdande noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_unit_ai_grp%ROWTYPE;
6: new_references igs_as_unit_ai_grp%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 41: FROM igs_as_unit_ai_grp

37: */
38:
39: CURSOR cur_old_ref_values IS
40: SELECT *
41: FROM igs_as_unit_ai_grp
42: WHERE rowid = x_rowid;
43:
44: BEGIN
45:

Line 128: igs_as_unitass_item_pkg.get_fk_igs_as_unit_ai_grp (

124: || Who When What
125: || (reverse chronological order - newest change first)
126: */
127: BEGIN
128: igs_as_unitass_item_pkg.get_fk_igs_as_unit_ai_grp (
129: old_references.unit_ass_item_group_id
130: );
131: END check_child_existance;
132:

Line 182: FROM igs_as_unit_ai_grp

178: || (reverse chronological order - newest change first)
179: */
180: CURSOR cur_rowid IS
181: SELECT rowid
182: FROM igs_as_unit_ai_grp
183: WHERE unit_ass_item_group_id = x_unit_ass_item_group_id
184: FOR UPDATE NOWAIT;
185:
186: lv_rowid cur_rowid%RowType;

Line 221: FROM igs_as_unit_ai_grp

217: || (reverse chronological order - newest change first)
218: */
219: CURSOR cur_rowid IS
220: SELECT rowid
221: FROM igs_as_unit_ai_grp
222: WHERE group_name = x_group_name
223: AND unit_cd = x_unit_cd
224: AND version_number = x_version_number
225: AND cal_type = x_cal_type

Line 263: FROM igs_as_unit_ai_grp

259: || (reverse chronological order - newest change first)
260: */
261: CURSOR cur_rowid IS
262: SELECT rowid
263: FROM igs_as_unit_ai_grp
264: WHERE ((cal_type = x_cal_type) AND
265: (ci_sequence_number = x_ci_sequence_number) AND
266: (unit_cd = x_unit_cd) AND
267: (version_number = x_version_number));

Line 429: fnd_message.set_token ('ROUTINE', 'IGS_AS_UNIT_AI_GRP_PKG.INSERT_ROW');

425: x_last_update_login := -1;
426: END IF;
427: ELSE
428: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
429: fnd_message.set_token ('ROUTINE', 'IGS_AS_UNIT_AI_GRP_PKG.INSERT_ROW');
430: igs_ge_msg_stack.add;
431: app_exception.raise_exception;
432: END IF;
433:

Line 458: INSERT INTO igs_as_unit_ai_grp (

454: x_last_updated_by => x_last_updated_by,
455: x_last_update_login => x_last_update_login
456: );
457:
458: INSERT INTO igs_as_unit_ai_grp (
459: unit_ass_item_group_id,
460: unit_cd,
461: version_number,
462: cal_type,

Line 477: igs_as_unit_ai_grp_s.NEXTVAL,

473: last_update_date,
474: last_updated_by,
475: last_update_login
476: ) VALUES (
477: igs_as_unit_ai_grp_s.NEXTVAL,
478: new_references.unit_cd,
479: new_references.version_number,
480: new_references.cal_type,
481: new_references.ci_sequence_number,

Line 538: FROM igs_as_unit_ai_grp

534: midterm_weight_qty,
535: final_formula_code,
536: final_formula_qty,
537: final_weight_qty
538: FROM igs_as_unit_ai_grp
539: WHERE rowid = x_rowid
540: FOR UPDATE NOWAIT;
541:
542: tlinfo c1%ROWTYPE;

Line 628: fnd_message.set_token ('ROUTINE', 'IGS_AS_UNIT_AI_GRP_PKG.UPDATE_ROW');

624: x_last_update_login := -1;
625: END IF;
626: ELSE
627: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
628: fnd_message.set_token ('ROUTINE', 'IGS_AS_UNIT_AI_GRP_PKG.UPDATE_ROW');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: END IF;
632:

Line 655: UPDATE igs_as_unit_ai_grp

651: x_last_updated_by => x_last_updated_by,
652: x_last_update_login => x_last_update_login
653: );
654:
655: UPDATE igs_as_unit_ai_grp
656: SET
657: unit_cd = new_references.unit_cd,
658: version_number = new_references.version_number,
659: cal_type = new_references.cal_type,

Line 709: FROM igs_as_unit_ai_grp

705: || (reverse chronological order - newest change first)
706: */
707: CURSOR c1 IS
708: SELECT rowid
709: FROM igs_as_unit_ai_grp
710: WHERE unit_ass_item_group_id = x_unit_ass_item_group_id;
711:
712: BEGIN
713:

Line 778: DELETE FROM igs_as_unit_ai_grp

774: p_action => 'DELETE',
775: x_rowid => x_rowid
776: );
777:
778: DELETE FROM igs_as_unit_ai_grp
779: WHERE rowid = x_rowid;
780:
781: IF (SQL%NOTFOUND) THEN
782: RAISE NO_DATA_FOUND;

Line 790: END igs_as_unit_ai_grp_pkg;

786:
787: END delete_row;
788:
789:
790: END igs_as_unit_ai_grp_pkg;