APPS.IGS_AS_US_AI_GROUP_PKG dependencies on IGS_AS_US_AI_GROUP

Line 1: PACKAGE BODY igs_as_us_ai_group_pkg AS

1: PACKAGE BODY igs_as_us_ai_group_pkg AS
2: /* $Header: IGSDI82B.pls 120.0 2005/07/05 12:40:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_us_ai_group%ROWTYPE;

Line 5: old_references igs_as_us_ai_group%ROWTYPE;

1: PACKAGE BODY igs_as_us_ai_group_pkg AS
2: /* $Header: IGSDI82B.pls 120.0 2005/07/05 12:40:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_us_ai_group%ROWTYPE;
6: new_references igs_as_us_ai_group%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_us_ai_group%ROWTYPE;

2: /* $Header: IGSDI82B.pls 120.0 2005/07/05 12:40:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_us_ai_group%ROWTYPE;
6: new_references igs_as_us_ai_group%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 38: FROM igs_as_us_ai_group

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM igs_as_us_ai_group
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 119: igs_ps_unitass_item_pkg.get_fk_igs_as_us_ai_group (

115: || Who When What
116: || (reverse chronological order - newest change first)
117: */
118: BEGIN
119: igs_ps_unitass_item_pkg.get_fk_igs_as_us_ai_group (
120: old_references.us_ass_item_group_id
121: );
122: END check_child_existance;
123:

Line 164: FROM igs_as_us_ai_group

160: || (reverse chronological order - newest change first)
161: */
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM igs_as_us_ai_group
165: WHERE us_ass_item_group_id = x_us_ass_item_group_id
166: FOR UPDATE NOWAIT;
167:
168: lv_rowid cur_rowid%RowType;

Line 200: FROM igs_as_us_ai_group

196: || (reverse chronological order - newest change first)
197: */
198: CURSOR cur_rowid IS
199: SELECT rowid
200: FROM igs_as_us_ai_group
201: WHERE uoo_id = x_uoo_id
202: AND group_name = x_group_name
203: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
204:

Line 237: FROM igs_as_us_ai_group

233: || (reverse chronological order - newest change first)
234: */
235: CURSOR cur_rowid IS
236: SELECT rowid
237: FROM igs_as_us_ai_group
238: WHERE ((uoo_id = x_uoo_id));
239:
240: lv_rowid cur_rowid%RowType;
241:

Line 387: fnd_message.set_token ('ROUTINE', 'IGS_AS_US_AI_GROUP_PKG.INSERT_ROW');

383: x_last_update_login := -1;
384: END IF;
385: ELSE
386: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
387: fnd_message.set_token ('ROUTINE', 'IGS_AS_US_AI_GROUP_PKG.INSERT_ROW');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:

Line 413: INSERT INTO igs_as_us_ai_group (

409: x_last_updated_by => x_last_updated_by,
410: x_last_update_login => x_last_update_login
411: );
412:
413: INSERT INTO igs_as_us_ai_group (
414: us_ass_item_group_id,
415: uoo_id,
416: group_name,
417: midterm_formula_code,

Line 429: igs_as_us_ai_group_s.NEXTVAL,

425: last_update_date,
426: last_updated_by,
427: last_update_login
428: ) VALUES (
429: igs_as_us_ai_group_s.NEXTVAL,
430: new_references.uoo_id,
431: new_references.group_name,
432: new_references.midterm_formula_code,
433: new_references.midterm_formula_qty,

Line 479: FROM igs_as_us_ai_group

475: midterm_weight_qty,
476: final_formula_code,
477: final_formula_qty,
478: final_weight_qty
479: FROM igs_as_us_ai_group
480: WHERE rowid = x_rowid
481: FOR UPDATE NOWAIT;
482:
483: tlinfo c1%ROWTYPE;

Line 563: fnd_message.set_token ('ROUTINE', 'IGS_AS_US_AI_GROUP_PKG.UPDATE_ROW');

559: x_last_update_login := -1;
560: END IF;
561: ELSE
562: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
563: fnd_message.set_token ('ROUTINE', 'IGS_AS_US_AI_GROUP_PKG.UPDATE_ROW');
564: igs_ge_msg_stack.add;
565: app_exception.raise_exception;
566: END IF;
567:

Line 587: UPDATE igs_as_us_ai_group

583: x_last_updated_by => x_last_updated_by,
584: x_last_update_login => x_last_update_login
585: );
586:
587: UPDATE igs_as_us_ai_group
588: SET
589: uoo_id = new_references.uoo_id,
590: group_name = new_references.group_name,
591: midterm_formula_code = new_references.midterm_formula_code,

Line 633: FROM igs_as_us_ai_group

629: || (reverse chronological order - newest change first)
630: */
631: CURSOR c1 IS
632: SELECT rowid
633: FROM igs_as_us_ai_group
634: WHERE us_ass_item_group_id = x_us_ass_item_group_id;
635:
636: BEGIN
637:

Line 696: DELETE FROM igs_as_us_ai_group

692: p_action => 'DELETE',
693: x_rowid => x_rowid
694: );
695:
696: DELETE FROM igs_as_us_ai_group
697: WHERE rowid = x_rowid;
698:
699: IF (SQL%NOTFOUND) THEN
700: RAISE NO_DATA_FOUND;

Line 706: END igs_as_us_ai_group_pkg;

702:
703: END delete_row;
704:
705:
706: END igs_as_us_ai_group_pkg;