APPS.IGS_FI_SPECIAL_FEES_PKG dependencies on IGS_FI_SPECIAL_FEES

Line 1: PACKAGE BODY igs_fi_special_fees_pkg AS

1: PACKAGE BODY igs_fi_special_fees_pkg AS
2: /* $Header: IGSSIE5B.pls 115.2 2003/11/06 14:23:00 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_special_fees%ROWTYPE;

Line 5: old_references igs_fi_special_fees%ROWTYPE;

1: PACKAGE BODY igs_fi_special_fees_pkg AS
2: /* $Header: IGSSIE5B.pls 115.2 2003/11/06 14:23:00 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_special_fees%ROWTYPE;
6: new_references igs_fi_special_fees%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_special_fees%ROWTYPE;

2: /* $Header: IGSSIE5B.pls 115.2 2003/11/06 14:23:00 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_special_fees%ROWTYPE;
6: new_references igs_fi_special_fees%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 40: FROM igs_fi_special_fees

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

Line 197: FROM igs_fi_special_fees

193: || (reverse chronological order - newest change first)
194: */
195: CURSOR cur_rowid IS
196: SELECT rowid
197: FROM igs_fi_special_fees
198: WHERE special_fee_id = x_special_fee_id
199: FOR UPDATE NOWAIT;
200:
201: lv_rowid cur_rowid%RowType;

Line 233: FROM igs_fi_special_fees

229: || (reverse chronological order - newest change first)
230: */
231: CURSOR cur_rowid IS
232: SELECT rowid
233: FROM igs_fi_special_fees
234: WHERE uoo_id = x_uoo_id
235: AND fee_type = x_fee_type;
236:
237: lv_rowid cur_rowid%RowType;

Line 399: fnd_message.set_token ('ROUTINE', 'IGS_FI_SPECIAL_FEES_PKG.INSERT_ROW');

395: x_program_update_date := SYSDATE;
396: END IF;
397: ELSE
398: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
399: fnd_message.set_token ('ROUTINE', 'IGS_FI_SPECIAL_FEES_PKG.INSERT_ROW');
400: igs_ge_msg_stack.add;
401: app_exception.raise_exception;
402: END IF;
403:

Line 427: INSERT INTO igs_fi_special_fees (

423: x_last_updated_by => x_last_updated_by,
424: x_last_update_login => x_last_update_login
425: );
426:
427: INSERT INTO igs_fi_special_fees (
428: special_fee_id,
429: person_id,
430: course_cd,
431: uoo_id,

Line 449: igs_fi_special_fees_s.NEXTVAL,

445: program_id,
446: program_application_id,
447: program_update_date
448: ) VALUES (
449: igs_fi_special_fees_s.NEXTVAL,
450: new_references.person_id,
451: new_references.course_cd,
452: new_references.uoo_id,
453: new_references.fee_type,

Line 509: FROM igs_fi_special_fees

505: fee_amt,
506: transaction_date,
507: s_transaction_type_code,
508: invoice_id
509: FROM igs_fi_special_fees
510: WHERE rowid = x_rowid
511: FOR UPDATE NOWAIT;
512:
513: tlinfo c1%ROWTYPE;

Line 601: fnd_message.set_token ('ROUTINE', 'IGS_FI_SPECIAL_FEES_PKG.UPDATE_ROW');

597: x_last_update_login := -1;
598: END IF;
599: ELSE
600: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
601: fnd_message.set_token ('ROUTINE', 'IGS_FI_SPECIAL_FEES_PKG.UPDATE_ROW');
602: igs_ge_msg_stack.add;
603: app_exception.raise_exception;
604: END IF;
605:

Line 641: UPDATE igs_fi_special_fees

637: x_program_update_date := SYSDATE;
638: END IF;
639: END IF;
640:
641: UPDATE igs_fi_special_fees
642: SET
643: person_id = new_references.person_id,
644: course_cd = new_references.course_cd,
645: uoo_id = new_references.uoo_id,

Line 695: FROM igs_fi_special_fees

691: || (reverse chronological order - newest change first)
692: */
693: CURSOR c1 IS
694: SELECT rowid
695: FROM igs_fi_special_fees
696: WHERE special_fee_id = x_special_fee_id;
697:
698: BEGIN
699:

Line 762: DELETE FROM igs_fi_special_fees

758: p_action => 'DELETE',
759: x_rowid => x_rowid
760: );
761:
762: DELETE FROM igs_fi_special_fees
763: WHERE rowid = x_rowid;
764:
765: IF (SQL%NOTFOUND) THEN
766: RAISE NO_DATA_FOUND;

Line 772: END igs_fi_special_fees_pkg;

768:
769: END delete_row;
770:
771:
772: END igs_fi_special_fees_pkg;