APPS.IGS_FI_ANC_INT_PKG dependencies on IGS_FI_ANC_INT_ALL

Line 5: old_references igs_fi_anc_int_all%ROWTYPE;

1: PACKAGE BODY igs_fi_anc_int_pkg AS
2: /* $Header: IGSSI81B.pls 115.12 2002/11/29 03:54:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_anc_int_all%ROWTYPE;
6: new_references igs_fi_anc_int_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_anc_int_all%ROWTYPE;

2: /* $Header: IGSSI81B.pls 115.12 2002/11/29 03:54:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_anc_int_all%ROWTYPE;
6: new_references igs_fi_anc_int_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 78: FROM IGS_FI_ANC_INT_ALL

74: */
75:
76: CURSOR cur_old_ref_values IS
77: SELECT *
78: FROM IGS_FI_ANC_INT_ALL
79: WHERE rowid = x_rowid;
80:
81: BEGIN
82:

Line 217: FROM igs_fi_anc_int_all

213: || (reverse chronological order - newest change first)
214: */
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM igs_fi_anc_int_all
218: WHERE ancillary_int_id = x_ancillary_int_id
219: FOR UPDATE NOWAIT;
220:
221: lv_rowid cur_rowid%RowType;

Line 253: FROM igs_fi_anc_int_all

249: || (reverse chronological order - newest change first)
250: */
251: CURSOR cur_rowid IS
252: SELECT rowid
253: FROM igs_fi_anc_int_all
254: WHERE ((fee_type = x_fee_type) AND
255: (fee_cal_type = x_fee_cal_type) AND
256: (fee_ci_sequence_number = x_fee_ci_sequence_number));
257:

Line 282: FROM IGS_FI_ANC_INT_ALL

278: ) AS
279:
280: CURSOR cur_rowid IS
281: SELECT rowid
282: FROM IGS_FI_ANC_INT_ALL
283: WHERE status = x_status ;
284:
285: lv_rowid cur_rowid%RowType;
286:

Line 525: FROM igs_fi_anc_int_all

521: || (reverse chronological order - newest change first)
522: */
523: CURSOR c IS
524: SELECT rowid
525: FROM igs_fi_anc_int_all
526: WHERE ancillary_int_id = x_ancillary_int_id;
527:
528: x_last_update_date DATE;
529: x_last_updated_by NUMBER;

Line 628: INSERT INTO igs_fi_anc_int_all (

624: x_last_updated_by => x_last_updated_by,
625: x_last_update_login => x_last_update_login
626: );
627:
628: INSERT INTO igs_fi_anc_int_all (
629: ancillary_int_id,
630: person_id,
631: person_id_type,
632: api_person_id,

Line 868: FROM igs_fi_anc_int_all

864: attribute20,
865: effective_dt,
866: error_msg,
867: validation_flag
868: FROM igs_fi_anc_int_all
869: WHERE rowid = x_rowid
870: FOR UPDATE NOWAIT;
871:
872: tlinfo c1%ROWTYPE;

Line 1110: UPDATE igs_fi_anc_int_all

1106: x_program_update_date := SYSDATE;
1107: END IF;
1108: END IF;
1109:
1110: UPDATE igs_fi_anc_int_all
1111: SET
1112: person_id = new_references.person_id,
1113: person_id_type = new_references.person_id_type,
1114: api_person_id = new_references.api_person_id,

Line 1240: FROM igs_fi_anc_int_all

1236: || (reverse chronological order - newest change first)
1237: */
1238: CURSOR c1 IS
1239: SELECT rowid
1240: FROM igs_fi_anc_int_all
1241: WHERE ancillary_int_id = x_ancillary_int_id;
1242:
1243: BEGIN
1244:

Line 1381: DELETE FROM igs_fi_anc_int_all

1377: p_action => 'DELETE',
1378: x_rowid => x_rowid
1379: );
1380:
1381: DELETE FROM igs_fi_anc_int_all
1382: WHERE rowid = x_rowid;
1383:
1384: IF (SQL%NOTFOUND) THEN
1385: RAISE NO_DATA_FOUND;