eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_FTCI_ACCTS_PKG dependencies on IGS_FI_FTCI_ACCTS

Line 1: PACKAGE BODY igs_fi_ftci_accts_pkg AS

1: PACKAGE BODY igs_fi_ftci_accts_pkg AS
2: /* $Header: IGSSID0B.pls 120.3 2005/06/05 23:42:09 appldev $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_ftci_accts%ROWTYPE;

Line 5: old_references igs_fi_ftci_accts%ROWTYPE;

1: PACKAGE BODY igs_fi_ftci_accts_pkg AS
2: /* $Header: IGSSID0B.pls 120.3 2005/06/05 23:42:09 appldev $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_ftci_accts%ROWTYPE;
6: new_references igs_fi_ftci_accts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_ftci_accts%ROWTYPE;

2: /* $Header: IGSSID0B.pls 120.3 2005/06/05 23:42:09 appldev $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_ftci_accts%ROWTYPE;
6: new_references igs_fi_ftci_accts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 51: FROM igs_fi_ftci_accts

47: */
48:
49: CURSOR cur_old_ref_values IS
50: SELECT *
51: FROM igs_fi_ftci_accts
52: WHERE rowid = x_rowid;
53:
54: BEGIN
55:

Line 339: FROM igs_fi_ftci_accts

335: || (reverse chronological order - newest change first)
336: */
337: CURSOR cur_rowid IS
338: SELECT rowid
339: FROM igs_fi_ftci_accts
340: WHERE acct_id = x_acct_id
341: FOR UPDATE NOWAIT;
342:
343: lv_rowid cur_rowid%ROWTYPE;

Line 377: FROM igs_fi_ftci_accts

373: || (reverse chronological order - newest change first)
374: */
375: CURSOR cur_rowid IS
376: SELECT rowid
377: FROM igs_fi_ftci_accts
378: WHERE fee_type = x_fee_type
379: AND fee_cal_type = x_fee_cal_type
380: AND fee_ci_sequence_number = x_fee_ci_sequence_number
381: AND order_sequence = x_order_sequence

Line 431: FROM igs_fi_ftci_accts

427: || (reverse chronological order - newest change first)
428: */
429: CURSOR cur_rowid IS
430: SELECT rowid
431: FROM igs_fi_ftci_accts
432: WHERE fee_type = x_fee_type
433: AND fee_cal_type = x_fee_cal_type
434: AND fee_ci_sequence_number = x_fee_ci_sequence_number
435: AND ((location_cd = x_location_cd) OR (x_location_cd IS NULL AND location_cd IS NULL))

Line 482: FROM igs_fi_ftci_accts

478: || (reverse chronological order - newest change first)
479: */
480: CURSOR cur_rowid IS
481: SELECT rowid
482: FROM igs_fi_ftci_accts
483: WHERE ((fee_cal_type = x_fee_cal_type) AND
484: (fee_ci_sequence_number = x_fee_ci_sequence_number) AND
485: (fee_type = x_fee_type));
486:

Line 519: FROM igs_fi_ftci_accts

515: || (reverse chronological order - newest change first)
516: */
517: CURSOR cur_rowid IS
518: SELECT rowid
519: FROM igs_fi_ftci_accts
520: WHERE ((rev_account_cd = x_account_cd));
521:
522: lv_rowid cur_rowid%ROWTYPE;
523:

Line 554: FROM igs_fi_ftci_accts

550: || (reverse chronological order - newest change first)
551: */
552: CURSOR cur_rowid IS
553: SELECT rowid
554: FROM igs_fi_ftci_accts
555: WHERE ((location_cd = x_location_cd));
556:
557: lv_rowid cur_rowid%ROWTYPE;
558:

Line 589: FROM igs_fi_ftci_accts

585: || (reverse chronological order - newest change first)
586: */
587: CURSOR cur_rowid IS
588: SELECT rowid
589: FROM igs_fi_ftci_accts
590: WHERE ((attendance_type = x_attendance_type));
591:
592: lv_rowid cur_rowid%ROWTYPE;
593:

Line 624: FROM igs_fi_ftci_accts

620: || (reverse chronological order - newest change first)
621: */
622: CURSOR cur_rowid IS
623: SELECT rowid
624: FROM igs_fi_ftci_accts
625: WHERE ((attendance_mode = x_attendance_mode));
626:
627: lv_rowid cur_rowid%ROWTYPE;
628:

Line 660: FROM igs_fi_ftci_accts

656: || (reverse chronological order - newest change first)
657: */
658: CURSOR cur_rowid IS
659: SELECT rowid
660: FROM igs_fi_ftci_accts
661: WHERE ((course_cd = x_course_cd) AND
662: (crs_version_number = x_version_number));
663:
664: lv_rowid cur_rowid%ROWTYPE;

Line 696: FROM igs_fi_ftci_accts

692: || (reverse chronological order - newest change first)
693: */
694: CURSOR cur_rowid IS
695: SELECT rowid
696: FROM igs_fi_ftci_accts
697: WHERE ((unit_cd = x_unit_cd) AND
698: (unit_version_number = x_version_number));
699:
700: lv_rowid cur_rowid%ROWTYPE;

Line 734: FROM igs_fi_ftci_accts

730: || (reverse chronological order - newest change first)
731: */
732: CURSOR cur_rowid IS
733: SELECT rowid
734: FROM igs_fi_ftci_accts
735: WHERE ((uoo_id = x_uoo_id));
736:
737: lv_rowid cur_rowid%ROWTYPE;
738:

Line 768: FROM igs_fi_ftci_accts

764: || (reverse chronological order - newest change first)
765: */
766: CURSOR cur_rowid IS
767: SELECT rowid
768: FROM igs_fi_ftci_accts
769: WHERE ((unit_mode = x_unit_mode));
770:
771: lv_rowid cur_rowid%ROWTYPE;
772:

Line 973: fnd_message.set_token ('ROUTINE', 'IGS_FI_FTCI_ACCTS_PKG.INSERT_ROW');

969: x_program_update_date := SYSDATE;
970: END IF;
971: ELSE
972: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
973: fnd_message.set_token ('ROUTINE', 'IGS_FI_FTCI_ACCTS_PKG.INSERT_ROW');
974: igs_ge_msg_stack.add;
975: app_exception.raise_exception;
976: END IF;
977:

Line 978: SELECT igs_fi_ftci_accts_s.NEXTVAL INTO x_acct_id FROM dual;

974: igs_ge_msg_stack.add;
975: app_exception.raise_exception;
976: END IF;
977:
978: SELECT igs_fi_ftci_accts_s.NEXTVAL INTO x_acct_id FROM dual;
979:
980: before_dml(
981: p_action => 'INSERT',
982: x_rowid => x_rowid,

Line 1011: INSERT INTO igs_fi_ftci_accts (

1007: x_unit_mode => x_unit_mode,
1008: x_unit_class => x_unit_class
1009: );
1010:
1011: INSERT INTO igs_fi_ftci_accts (
1012: acct_id,
1013: fee_type,
1014: fee_cal_type,
1015: fee_ci_sequence_number,

Line 1134: FROM igs_fi_ftci_accts

1130: unit_level,
1131: unit_type_id,
1132: unit_mode,
1133: unit_class
1134: FROM igs_fi_ftci_accts
1135: WHERE rowid = x_rowid
1136: FOR UPDATE NOWAIT;
1137:
1138: tlinfo c1%ROWTYPE;

Line 1247: fnd_message.set_token ('ROUTINE', 'IGS_FI_FTCI_ACCTS_PKG.UPDATE_ROW');

1243: x_last_update_login := -1;
1244: END IF;
1245: ELSE
1246: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1247: fnd_message.set_token ('ROUTINE', 'IGS_FI_FTCI_ACCTS_PKG.UPDATE_ROW');
1248: igs_ge_msg_stack.add;
1249: app_exception.raise_exception;
1250: END IF;
1251:

Line 1297: UPDATE igs_fi_ftci_accts

1293: x_program_update_date := SYSDATE;
1294: END IF;
1295: END IF;
1296:
1297: UPDATE igs_fi_ftci_accts
1298: SET
1299: fee_type = new_references.fee_type,
1300: fee_cal_type = new_references.fee_cal_type,
1301: fee_ci_sequence_number = new_references.fee_ci_sequence_number,

Line 1372: FROM igs_fi_ftci_accts

1368: || (reverse chronological order - newest change first)
1369: */
1370: CURSOR c1 IS
1371: SELECT rowid
1372: FROM igs_fi_ftci_accts
1373: WHERE acct_id = x_acct_id;
1374:
1375: BEGIN
1376:

Line 1458: DELETE FROM igs_fi_ftci_accts

1454: p_action => 'DELETE',
1455: x_rowid => x_rowid
1456: );
1457:
1458: DELETE FROM igs_fi_ftci_accts
1459: WHERE rowid = x_rowid;
1460:
1461: IF (SQL%NOTFOUND) THEN
1462: RAISE NO_DATA_FOUND;

Line 1468: END igs_fi_ftci_accts_pkg;

1464:
1465: END delete_row;
1466:
1467:
1468: END igs_fi_ftci_accts_pkg;