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_FEE_AS_ITEMS_PKG dependencies on IGS_FI_FEE_AS_ITEMS

Line 1: PACKAGE BODY igs_fi_fee_as_items_pkg AS

1: PACKAGE BODY igs_fi_fee_as_items_pkg AS
2: /* $Header: IGSSI76B.pls 120.5 2005/10/05 16:48:38 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_fi_fee_as_items%RowType;
5: new_references igs_fi_fee_as_items%RowType;

Line 4: old_references igs_fi_fee_as_items%RowType;

1: PACKAGE BODY igs_fi_fee_as_items_pkg AS
2: /* $Header: IGSSI76B.pls 120.5 2005/10/05 16:48:38 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_fi_fee_as_items%RowType;
5: new_references igs_fi_fee_as_items%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_fi_fee_as_items%RowType;

1: PACKAGE BODY igs_fi_fee_as_items_pkg AS
2: /* $Header: IGSSI76B.pls 120.5 2005/10/05 16:48:38 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_fi_fee_as_items%RowType;
5: new_references igs_fi_fee_as_items%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 70: FROM IGS_FI_FEE_AS_ITEMS

66: ***************************************************************/
67:
68: CURSOR cur_old_ref_values IS
69: SELECT *
70: FROM IGS_FI_FEE_AS_ITEMS
71: WHERE rowid = x_rowid;
72:
73: BEGIN
74:

Line 286: FROM igs_fi_fee_as_items

282: ***************************************************************/
283:
284: CURSOR cur_rowid IS
285: SELECT rowid
286: FROM igs_fi_fee_as_items
287: WHERE fee_ass_item_id = x_fee_ass_item_id
288: FOR UPDATE NOWAIT;
289:
290: lv_rowid cur_rowid%RowType;

Line 314: FROM IGS_FI_FEE_AS_ITEMS

310: ) AS
311:
312: CURSOR cur_rowid IS
313: SELECT rowid
314: FROM IGS_FI_FEE_AS_ITEMS
315: WHERE person_id = x_person_id
316: AND transaction_id = x_transaction_id;
317:
318: lv_rowid cur_rowid%RowType;

Line 365: FROM igs_fi_fee_as_items

361: ***************************************************************/
362: --to take care of unique keys which are nullable -syam
363: CURSOR cur_rowid IS
364: SELECT rowid
365: FROM igs_fi_fee_as_items
366: WHERE person_id = x_person_id
367: AND transaction_id = x_TRANSACTION_ID
368: AND ((LOCATION_CD = X_LOCATION_CD) OR ((LOCATION_CD is null) AND (X_LOCATION_CD is null)))
369: AND ((COURSE_CD = X_COURSE_CD) OR ((COURSE_CD is null) AND (X_COURSE_CD is null)))

Line 634: cursor C is select ROWID from IGS_FI_FEE_AS_ITEMS

630: Added 2 new columns unit_set_cd and us_version_number
631: (reverse chronological order - newest change first)
632: ***************************************************************/
633:
634: cursor C is select ROWID from IGS_FI_FEE_AS_ITEMS
635: where FEE_ASS_ITEM_ID= X_FEE_ASS_ITEM_ID;
636: X_LAST_UPDATE_DATE DATE ;
637: X_LAST_UPDATED_BY NUMBER ;
638: X_LAST_UPDATE_LOGIN NUMBER ;

Line 659: SELECT igs_fi_fee_as_items_s.nextval

655: IGS_GE_MSG_STACK.ADD;
656: app_exception.raise_exception;
657: end if;
658: ----------------------------------
659: SELECT igs_fi_fee_as_items_s.nextval
660: INTO X_FEE_ASS_ITEM_ID
661: FROM dual;
662: --------------------------------------
663:

Line 713: insert into IGS_FI_FEE_AS_ITEMS (

709: x_elm_rng_order_name => x_elm_rng_order_name,
710: x_max_chg_elements => x_max_chg_elements
711: );
712:
713: insert into IGS_FI_FEE_AS_ITEMS (
714: FEE_ASS_ITEM_ID
715: ,TRANSACTION_ID
716: ,PERSON_ID
717: ,STATUS

Line 911: FROM igs_fi_fee_as_items

907: unit_level,
908: scope_rul_sequence_num,
909: elm_rng_order_name,
910: max_chg_elements
911: FROM igs_fi_fee_as_items
912: WHERE rowid = x_rowid
913: FOR UPDATE NOWAIT;
914: tlinfo c1%rowtype;
915: begin

Line 1145: update IGS_FI_FEE_AS_ITEMS set

1141: x_elm_rng_order_name => x_elm_rng_order_name,
1142: x_max_chg_elements => x_max_chg_elements
1143: );
1144:
1145: update IGS_FI_FEE_AS_ITEMS set
1146: TRANSACTION_ID = NEW_REFERENCES.TRANSACTION_ID,
1147: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1148: STATUS = NEW_REFERENCES.STATUS,
1149: FEE_TYPE = NEW_REFERENCES.FEE_TYPE,

Line 1254: SELECT rowid FROM igs_fi_fee_as_items

1250: Added 2 new columns unit_set_cd and us_version_number
1251: (reverse chronological order - newest change first)
1252: ***************************************************************/
1253: CURSOR c1 IS
1254: SELECT rowid FROM igs_fi_fee_as_items
1255: WHERE fee_ass_item_id = x_fee_ass_item_id;
1256: BEGIN
1257: OPEN c1;
1258: FETCH c1 INTO x_rowid;

Line 1370: DELETE FROM igs_fi_fee_as_items

1366: p_action => 'DELETE',
1367: x_rowid => x_rowid
1368: );
1369:
1370: DELETE FROM igs_fi_fee_as_items
1371: WHERE rowid = x_rowid;
1372:
1373: IF (SQL%NOTFOUND) THEN
1374: RAISE NO_DATA_FOUND;

Line 1397: FROM igs_fi_fee_as_items

1393: (reverse chronological order - newest change first)
1394: ***************************************************************/
1395: CURSOR cur_rowid IS
1396: SELECT rowid
1397: FROM igs_fi_fee_as_items
1398: WHERE unit_set_cd = x_unit_set_cd
1399: AND us_version_number = x_us_version_number;
1400:
1401: lv_rowid cur_rowid%ROWTYPE;

Line 1416: END igs_fi_fee_as_items_pkg;

1412: END IF;
1413: CLOSE cur_rowid;
1414: END get_fk_igs_en_unit_set_all;
1415:
1416: END igs_fi_fee_as_items_pkg;