APPS.IGS_FI_FEE_AS_PKG dependencies on IGS_FI_FEE_AS_ALL

Line 5: old_references IGS_FI_FEE_AS_ALL%RowType;

1: PACKAGE BODY igs_fi_fee_as_pkg AS
2: /* $Header: IGSSI18B.pls 115.25 2003/02/12 06:16:35 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FEE_AS_ALL%RowType;
6: new_references IGS_FI_FEE_AS_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 6: new_references IGS_FI_FEE_AS_ALL%RowType;

2: /* $Header: IGSSI18B.pls 115.25 2003/02/12 06:16:35 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FEE_AS_ALL%RowType;
6: new_references IGS_FI_FEE_AS_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,
10: x_person_id IN NUMBER ,

Line 48: FROM IGS_FI_FEE_AS_ALL

44: ----------------------------------------------------------------------------*/
45:
46: CURSOR cur_old_ref_values IS
47: SELECT *
48: FROM IGS_FI_FEE_AS_ALL
49: WHERE rowid = x_rowid;
50: BEGIN
51: l_rowid := x_rowid;
52: -- Code for setting the Old and New Reference Values.

Line 97: -- ON IGS_FI_FEE_AS_ALL

93: END Set_Column_Values;
94: -- Trigger description :-
95: -- "OSS_TST".trg_fas_br_iud
96: -- BEFORE INSERT OR DELETE OR UPDATE
97: -- ON IGS_FI_FEE_AS_ALL
98: -- FOR EACH ROW
99: PROCEDURE BeforeRowInsertUpdateDelete1(
100: p_inserting IN BOOLEAN ,
101: p_updating IN BOOLEAN ,

Line 493: FROM IGS_FI_FEE_AS_ALL

489: ) Return Boolean
490: AS
491: CURSOR cur_rowid IS
492: SELECT rowid
493: FROM IGS_FI_FEE_AS_ALL
494: WHERE person_id = x_person_id
495: AND transaction_id = x_transaction_id
496: FOR UPDATE NOWAIT;
497: lv_rowid cur_rowid%RowType;

Line 515: FROM IGS_FI_FEE_AS_ALL

511: x_transaction_id IN NUMBER
512: ) RETURN BOOLEAN AS
513: CURSOR cur_rowid IS
514: SELECT rowid
515: FROM IGS_FI_FEE_AS_ALL
516: WHERE transaction_id = new_references.transaction_id
517: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
518: FOR UPDATE NOWAIT;
519: lv_rowid cur_rowid%RowType;

Line 537: FROM IGS_FI_FEE_AS_ALL

533: x_course_cd IN VARCHAR2
534: ) AS
535: CURSOR cur_rowid IS
536: SELECT rowid
537: FROM IGS_FI_FEE_AS_ALL
538: WHERE course_cd = x_course_cd ;
539: lv_rowid cur_rowid%RowType;
540: BEGIN
541: Open cur_rowid;

Line 559: FROM IGS_FI_FEE_AS_ALL

555: x_person_id IN NUMBER
556: ) AS
557: CURSOR cur_rowid IS
558: SELECT rowid
559: FROM IGS_FI_FEE_AS_ALL
560: WHERE person_id = x_person_id ;
561: lv_rowid cur_rowid%RowType;
562: BEGIN
563: Open cur_rowid;

Line 580: FROM IGS_FI_FEE_AS_ALL

576: x_s_transaction_type IN VARCHAR2
577: ) AS
578: CURSOR cur_rowid IS
579: SELECT rowid
580: FROM IGS_FI_FEE_AS_ALL
581: WHERE s_transaction_type = x_s_transaction_type ;
582: lv_rowid cur_rowid%RowType;
583: BEGIN
584: Open cur_rowid;

Line 781: cursor C is select ROWID from IGS_FI_FEE_AS_ALL

777: || (reverse chronological order - newest change first)
778: || vvutukur 30-Aug-2002 Bug#2531390.Removed default value of x_mode parameter to avoid gscc
779: || warnings.
780: ----------------------------------------------------------------------------*/
781: cursor C is select ROWID from IGS_FI_FEE_AS_ALL
782: where PERSON_ID = X_PERSON_ID
783: and TRANSACTION_ID = X_TRANSACTION_ID;
784: X_LAST_UPDATE_DATE DATE;
785: X_LAST_UPDATED_BY NUMBER;

Line 854: insert into IGS_FI_FEE_AS_ALL (

850: x_last_update_date => X_LAST_UPDATE_DATE,
851: x_last_updated_by => X_LAST_UPDATED_BY,
852: x_last_update_login => X_LAST_UPDATE_LOGIN
853: );
854: insert into IGS_FI_FEE_AS_ALL (
855: PERSON_ID,
856: TRANSACTION_ID,
857: FEE_TYPE,
858: FEE_CAL_TYPE,

Line 960: from IGS_FI_FEE_AS_ALL

956: COURSE_CD,
957: NOTIFICATION_DT,
958: LOGICAL_DELETE_DT,
959: COMMENTS
960: from IGS_FI_FEE_AS_ALL
961: where ROWID = X_ROWID
962: for update nowait;
963: tlinfo c1%rowtype;
964: begin

Line 1135: update IGS_FI_FEE_AS_ALL set

1131: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1132: IGS_GE_MSG_STACK.ADD;
1133: app_exception.raise_exception;
1134: end if;
1135: update IGS_FI_FEE_AS_ALL set
1136: FEE_TYPE = NEW_REFERENCES.FEE_TYPE,
1137: FEE_CAL_TYPE = NEW_REFERENCES.FEE_CAL_TYPE,
1138: FEE_CI_SEQUENCE_NUMBER = NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
1139: FEE_CAT = NEW_REFERENCES.FEE_CAT,

Line 1204: cursor c1 is select rowid from IGS_FI_FEE_AS_ALL

1200: || vvutukur 30-Aug-2002 Bug#2531390.Removed default value of x_mode parameter to avoid gscc
1201: || warnings.
1202: ----------------------------------------------------------------------------*/
1203:
1204: cursor c1 is select rowid from IGS_FI_FEE_AS_ALL
1205: where PERSON_ID = X_PERSON_ID
1206: and TRANSACTION_ID = X_TRANSACTION_ID
1207: ;
1208: begin

Line 1266: delete from IGS_FI_FEE_AS_ALL

1262: Before_DML (
1263: p_action => 'DELETE',
1264: x_rowid => X_ROWID
1265: );
1266: delete from IGS_FI_FEE_AS_ALL
1267: where ROWID = X_ROWID;
1268: if (sql%notfound) then
1269: raise no_data_found;
1270: end if;