APPS.IGS_FI_FAI_DTLS_PKG dependencies on IGS_FI_FAI_DTLS

Line 1: PACKAGE BODY igs_fi_fai_dtls_pkg AS

1: PACKAGE BODY igs_fi_fai_dtls_pkg AS
2: /* $Header: IGSSIF5B.pls 120.0 2005/09/09 17:48:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_fai_dtls%ROWTYPE;

Line 5: old_references igs_fi_fai_dtls%ROWTYPE;

1: PACKAGE BODY igs_fi_fai_dtls_pkg AS
2: /* $Header: IGSSIF5B.pls 120.0 2005/09/09 17:48:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_fai_dtls%ROWTYPE;
6: new_references igs_fi_fai_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_fai_dtls%ROWTYPE;

2: /* $Header: IGSSIF5B.pls 120.0 2005/09/09 17:48:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_fai_dtls%ROWTYPE;
6: new_references igs_fi_fai_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 42: FROM igs_fi_fai_dtls

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

Line 157: FROM igs_fi_fai_dtls

153: || (reverse chronological order - newest change first)
154: */
155: CURSOR cur_rowid IS
156: SELECT rowid
157: FROM igs_fi_fai_dtls
158: WHERE fee_as_item_dtl_id = x_fee_as_item_dtl_id
159: FOR UPDATE NOWAIT;
160:
161: lv_rowid cur_rowid%RowType;

Line 311: fnd_message.set_token ('ROUTINE', 'IGS_FI_FAI_DTLS_PKG.INSERT_ROW');

307: x_last_update_login := -1;
308: END IF;
309: ELSE
310: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
311: fnd_message.set_token ('ROUTINE', 'IGS_FI_FAI_DTLS_PKG.INSERT_ROW');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END IF;
315:

Line 341: INSERT INTO igs_fi_fai_dtls (

337: x_last_updated_by => x_last_updated_by,
338: x_last_update_login => x_last_update_login
339: );
340:
341: INSERT INTO igs_fi_fai_dtls (
342: fee_as_item_dtl_id,
343: fee_ass_item_id,
344: fee_cat,
345: course_cd,

Line 361: igs_fi_fai_dtls_s.NEXTVAL,

357: last_update_date,
358: last_updated_by,
359: last_update_login
360: ) VALUES (
361: igs_fi_fai_dtls_s.NEXTVAL,
362: new_references.fee_ass_item_id,
363: new_references.fee_cat,
364: new_references.course_cd,
365: new_references.crs_version_number,

Line 423: FROM igs_fi_fai_dtls

419: uoo_id,
420: unit_set_cd,
421: us_version_number,
422: chg_elements
423: FROM igs_fi_fai_dtls
424: WHERE rowid = x_rowid
425: FOR UPDATE NOWAIT;
426:
427: tlinfo c1%ROWTYPE;

Line 515: fnd_message.set_token ('ROUTINE', 'IGS_FI_FAI_DTLS_PKG.UPDATE_ROW');

511: x_last_update_login := -1;
512: END IF;
513: ELSE
514: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
515: fnd_message.set_token ('ROUTINE', 'IGS_FI_FAI_DTLS_PKG.UPDATE_ROW');
516: igs_ge_msg_stack.add;
517: app_exception.raise_exception;
518: END IF;
519:

Line 543: UPDATE igs_fi_fai_dtls

539: x_last_updated_by => x_last_updated_by,
540: x_last_update_login => x_last_update_login
541: );
542:
543: UPDATE igs_fi_fai_dtls
544: SET
545: fee_ass_item_id = new_references.fee_ass_item_id,
546: fee_cat = new_references.fee_cat,
547: course_cd = new_references.course_cd,

Line 597: FROM igs_fi_fai_dtls

593: || (reverse chronological order - newest change first)
594: */
595: CURSOR c1 IS
596: SELECT rowid
597: FROM igs_fi_fai_dtls
598: WHERE fee_as_item_dtl_id = x_fee_as_item_dtl_id;
599:
600: BEGIN
601:

Line 668: DELETE FROM igs_fi_fai_dtls

664: p_action => 'DELETE',
665: x_rowid => x_rowid
666: );
667:
668: DELETE FROM igs_fi_fai_dtls
669: WHERE rowid = x_rowid;
670:
671: IF (SQL%NOTFOUND) THEN
672: RAISE NO_DATA_FOUND;

Line 678: END igs_fi_fai_dtls_pkg;

674:
675: END delete_row;
676:
677:
678: END igs_fi_fai_dtls_pkg;