APPS.IGS_FI_EXT_INT_PKG dependencies on IGS_FI_EXT_INT_ALL

Line 4: old_references igs_fi_ext_int_all%ROWTYPE;

1: PACKAGE BODY igs_fi_ext_int_pkg AS
2: /* $Header: IGSSI79B.pls 115.23 2003/06/26 10:01:03 vvutukur ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_fi_ext_int_all%ROWTYPE;
5: new_references igs_fi_ext_int_all%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_fi_ext_int_all%ROWTYPE;

1: PACKAGE BODY igs_fi_ext_int_pkg AS
2: /* $Header: IGSSI79B.pls 115.23 2003/06/26 10:01:03 vvutukur ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_fi_ext_int_all%ROWTYPE;
5: new_references igs_fi_ext_int_all%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 75: FROM IGS_FI_EXT_INT_ALL

71: ***************************************************************/
72:
73: CURSOR cur_old_ref_values IS
74: SELECT *
75: FROM IGS_FI_EXT_INT_ALL
76: WHERE rowid = x_rowid;
77:
78: BEGIN
79:

Line 247: FROM igs_fi_ext_int_all

243: ***************************************************************/
244:
245: CURSOR cur_rowid IS
246: SELECT rowid
247: FROM igs_fi_ext_int_all
248: WHERE external_fee_id = x_external_fee_id
249: FOR UPDATE NOWAIT;
250:
251: lv_rowid cur_rowid%RowType;

Line 286: FROM igs_fi_ext_int_all

282: ***************************************************************/
283:
284: CURSOR cur_rowid IS
285: SELECT rowid
286: FROM igs_fi_ext_int_all
287: WHERE fee_ci_sequence_number = x_fee_ci_sequence_number
288: AND fee_cal_type = x_fee_cal_type
289: AND person_id = x_person_id
290: AND fee_type = x_fee_type and ((l_rowid is null) or (rowid <> l_rowid))

Line 602: CURSOR c IS SELECT ROWID FROM igs_fi_ext_int_all

598: vvutukur 29-Jul-2002 Bug#2425767.Removed references to chg_rate,chg_elements,transaction_type
599: columns as these are obsolete.
600: ***************************************************************/
601:
602: CURSOR c IS SELECT ROWID FROM igs_fi_ext_int_all
603: WHERE external_fee_id= x_external_fee_id
604: ;
605: x_last_update_date DATE ;
606: x_last_updated_by NUMBER ;

Line 697: INSERT INTO igs_fi_ext_int_all (

693: x_gl_date => x_gl_date,
694: x_error_msg => x_error_msg
695: );
696:
697: INSERT INTO igs_fi_ext_int_all (
698: external_fee_id
699: ,person_id
700: ,status
701: ,fee_type

Line 912: FROM igs_fi_ext_int_all

908: attribute19,
909: attribute20,
910: gl_date,
911: error_msg
912: FROM igs_fi_ext_int_all
913: WHERE ROWID = x_rowid
914: FOR UPDATE NOWAIT;
915: tlinfo c1%ROWTYPE;
916: BEGIN

Line 1135: UPDATE igs_fi_ext_int_all SET

1131: ELSE
1132: x_program_update_date := SYSDATE;
1133: END IF;
1134: END IF;
1135: UPDATE igs_fi_ext_int_all SET
1136: person_id = NEW_REFERENCES.person_id,
1137: status = NEW_REFERENCES.status,
1138: fee_type = NEW_REFERENCES.fee_type,
1139: fee_cal_type = NEW_REFERENCES.fee_cal_type,

Line 1253: CURSOR c1 IS SELECT ROWID FROM igs_fi_ext_int_all

1249: vvutukur 29-Jul-2002 Bug#2425767.Removed references to chg_rate,chg_elements,transaction_type
1250: columns as these are obsolete.
1251: ***************************************************************/
1252:
1253: CURSOR c1 IS SELECT ROWID FROM igs_fi_ext_int_all
1254: WHERE external_fee_id= x_external_fee_id
1255: ;
1256: BEGIN
1257: OPEN c1;

Line 1375: DELETE FROM igs_fi_ext_int_all

1371: before_dml (
1372: p_action => 'DELETE',
1373: x_rowid => X_ROWID
1374: );
1375: DELETE FROM igs_fi_ext_int_all
1376: WHERE ROWID = x_rowid;
1377: IF (SQL%NOTFOUND) THEN
1378: RAISE NO_DATA_FOUND;
1379: END IF;