APPS.IGS_FI_F_TYPE_ACCTS_PKG dependencies on IGS_FI_F_TYPE_ACCTS_ALL

Line 5: old_references igs_fi_f_type_accts_all%ROWTYPE;

1: PACKAGE BODY igs_fi_f_type_accts_pkg AS
2: /* $Header: IGSSIA7B.pls 115.5 2003/02/12 10:12:46 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_f_type_accts_all%ROWTYPE;
6: new_references igs_fi_f_type_accts_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_f_type_accts_all%ROWTYPE;

2: /* $Header: IGSSIA7B.pls 115.5 2003/02/12 10:12:46 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_f_type_accts_all%ROWTYPE;
6: new_references igs_fi_f_type_accts_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_FI_F_TYPE_ACCTS_ALL

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_FI_F_TYPE_ACCTS_ALL
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 127: FROM igs_fi_f_type_accts_all

123: || (reverse chronological order - newest change first)
124: */
125: CURSOR cur_rowid IS
126: SELECT rowid
127: FROM igs_fi_f_type_accts_all
128: WHERE fee_type_account_id = x_fee_type_account_id
129: FOR UPDATE NOWAIT;
130:
131: lv_rowid cur_rowid%RowType;

Line 244: FROM igs_fi_f_type_accts_all

240: || (reverse chronological order - newest change first)
241: */
242: CURSOR c IS
243: SELECT rowid
244: FROM igs_fi_f_type_accts_all
245: WHERE fee_type_account_id = x_fee_type_account_id;
246:
247: x_last_update_date DATE;
248: x_last_updated_by NUMBER;

Line 295: INSERT INTO igs_fi_f_type_accts_all (

291: x_last_updated_by => x_last_updated_by,
292: x_last_update_login => x_last_update_login
293: );
294:
295: INSERT INTO igs_fi_f_type_accts_all (
296: fee_type_account_id,
297: fee_type,
298: fee_cal_type,
299: fee_ci_sequence_number,

Line 363: FROM igs_fi_f_type_accts_all

359: fee_ci_sequence_number,
360: segment,
361: segment_num,
362: segment_value
363: FROM igs_fi_f_type_accts_all
364: WHERE rowid = x_rowid
365: FOR UPDATE NOWAIT;
366:
367: tlinfo c1%ROWTYPE;

Line 464: UPDATE igs_fi_f_type_accts_all

460: x_last_updated_by => x_last_updated_by,
461: x_last_update_login => x_last_update_login
462: );
463:
464: UPDATE igs_fi_f_type_accts_all
465: SET
466: fee_type = new_references.fee_type,
467: fee_cal_type = new_references.fee_cal_type,
468: fee_ci_sequence_number = new_references.fee_ci_sequence_number,

Line 506: FROM igs_fi_f_type_accts_all

502: || (reverse chronological order - newest change first)
503: */
504: CURSOR c1 IS
505: SELECT rowid
506: FROM igs_fi_f_type_accts_all
507: WHERE fee_type_account_id = x_fee_type_account_id;
508:
509: BEGIN
510:

Line 565: DELETE FROM igs_fi_f_type_accts_all

561: p_action => 'DELETE',
562: x_rowid => x_rowid
563: );
564:
565: DELETE FROM igs_fi_f_type_accts_all
566: WHERE rowid = x_rowid;
567:
568: IF (SQL%NOTFOUND) THEN
569: RAISE NO_DATA_FOUND;