APPS.IGP_AC_ACC_CLASSES_PKG dependencies on IGP_AC_ACC_CLASSES

Line 1: PACKAGE BODY igp_ac_acc_classes_pkg AS

1: PACKAGE BODY igp_ac_acc_classes_pkg AS
2: /* $Header: IGSPADCB.pls 120.0 2005/06/01 22:29:18 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igp_ac_acc_classes%ROWTYPE;

Line 5: old_references igp_ac_acc_classes%ROWTYPE;

1: PACKAGE BODY igp_ac_acc_classes_pkg AS
2: /* $Header: IGSPADCB.pls 120.0 2005/06/01 22:29:18 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igp_ac_acc_classes%ROWTYPE;
6: new_references igp_ac_acc_classes%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igp_ac_acc_classes%ROWTYPE;

2: /* $Header: IGSPADCB.pls 120.0 2005/06/01 22:29:18 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igp_ac_acc_classes%ROWTYPE;
6: new_references igp_ac_acc_classes%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igp_ac_acc_classes

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM igp_ac_acc_classes
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 127: FROM igp_ac_acc_classes

123: || (reverse chronological order - newest change first)
124: */
125: CURSOR cur_rowid IS
126: SELECT rowid
127: FROM igp_ac_acc_classes
128: WHERE acc_classification_id = x_acc_classification_id
129: FOR UPDATE NOWAIT;
130:
131: lv_rowid cur_rowid%RowType;

Line 162: FROM igp_ac_acc_classes

158: || (reverse chronological order - newest change first)
159: */
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM igp_ac_acc_classes
163: WHERE ((account_id = x_account_id));
164:
165: lv_rowid cur_rowid%RowType;
166:

Line 197: FROM igp_ac_acc_classes

193: || (reverse chronological order - newest change first)
194: */
195: CURSOR cur_rowid IS
196: SELECT rowid
197: FROM igp_ac_acc_classes
198: WHERE ((account_id = x_account_id));
199:
200: lv_rowid cur_rowid%RowType;
201:

Line 328: fnd_message.set_token ('ROUTINE', 'IGP_AC_ACC_CLASSES_PKG.INSERT_ROW');

324: x_last_update_login := -1;
325: END IF;
326: ELSE
327: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
328: fnd_message.set_token ('ROUTINE', 'IGP_AC_ACC_CLASSES_PKG.INSERT_ROW');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: END IF;
332:

Line 350: INSERT INTO igp_ac_acc_classes (

346: x_last_updated_by => x_last_updated_by,
347: x_last_update_login => x_last_update_login
348: );
349:
350: INSERT INTO igp_ac_acc_classes (
351: acc_classification_id,
352: account_id,
353: acc_classification_code,
354: access_expiration_date,

Line 362: igp_ac_acc_classes_s.NEXTVAL,

358: last_update_date,
359: last_updated_by,
360: last_update_login
361: ) VALUES (
362: igp_ac_acc_classes_s.NEXTVAL,
363: new_references.account_id,
364: new_references.acc_classification_code,
365: new_references.access_expiration_date,
366: new_references.object_version_number,

Line 400: FROM igp_ac_acc_classes

396: account_id,
397: acc_classification_code,
398: access_expiration_date,
399: object_version_number
400: FROM igp_ac_acc_classes
401: WHERE rowid = x_rowid
402: FOR UPDATE NOWAIT;
403:
404: tlinfo c1%ROWTYPE;

Line 476: fnd_message.set_token ('ROUTINE', 'IGP_AC_ACC_CLASSES_PKG.UPDATE_ROW');

472: x_last_update_login := -1;
473: END IF;
474: ELSE
475: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
476: fnd_message.set_token ('ROUTINE', 'IGP_AC_ACC_CLASSES_PKG.UPDATE_ROW');
477: igs_ge_msg_stack.add;
478: app_exception.raise_exception;
479: END IF;
480:

Line 496: UPDATE igp_ac_acc_classes

492: x_last_updated_by => x_last_updated_by,
493: x_last_update_login => x_last_update_login
494: );
495:
496: UPDATE igp_ac_acc_classes
497: SET
498: account_id = new_references.account_id,
499: acc_classification_code = new_references.acc_classification_code,
500: access_expiration_date = new_references.access_expiration_date,

Line 534: FROM igp_ac_acc_classes

530: || (reverse chronological order - newest change first)
531: */
532: CURSOR c1 IS
533: SELECT rowid
534: FROM igp_ac_acc_classes
535: WHERE acc_classification_id = x_acc_classification_id;
536:
537: BEGIN
538:

Line 589: DELETE FROM igp_ac_acc_classes

585: p_action => 'DELETE',
586: x_rowid => x_rowid
587: );
588:
589: DELETE FROM igp_ac_acc_classes
590: WHERE rowid = x_rowid;
591:
592: IF (SQL%NOTFOUND) THEN
593: RAISE NO_DATA_FOUND;

Line 599: END igp_ac_acc_classes_pkg;

595:
596: END delete_row;
597:
598:
599: END igp_ac_acc_classes_pkg;