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_ANC_RATES_PKG dependencies on IGS_FI_ANC_RATES

Line 1: PACKAGE BODY igs_fi_anc_rates_pkg AS

1: PACKAGE BODY igs_fi_anc_rates_pkg AS
2: /* $Header: IGSSI82B.pls 115.6 2003/02/12 09:35:55 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_anc_rates%ROWTYPE;

Line 5: old_references igs_fi_anc_rates%ROWTYPE;

1: PACKAGE BODY igs_fi_anc_rates_pkg AS
2: /* $Header: IGSSI82B.pls 115.6 2003/02/12 09:35:55 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_anc_rates%ROWTYPE;
6: new_references igs_fi_anc_rates%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_anc_rates%ROWTYPE;

2: /* $Header: IGSSI82B.pls 115.6 2003/02/12 09:35:55 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_anc_rates%ROWTYPE;
6: new_references igs_fi_anc_rates%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 50: FROM IGS_FI_ANC_RATES

46: */
47:
48: CURSOR cur_old_ref_values IS
49: SELECT *
50: FROM IGS_FI_ANC_RATES
51: WHERE rowid = x_rowid;
52:
53: BEGIN
54:

Line 122: CURSOR cur_impchgs_lines ( cp_anc_att1 IGS_FI_ANC_RATES.ancillary_attribute1%TYPE, cp_anc_att2 IGS_FI_ANC_RATES.ancillary_attribute2%TYPE,

118: || Who When What
119: || (reverse chronological order - newest change first)
120: */
121:
122: CURSOR cur_impchgs_lines ( cp_anc_att1 IGS_FI_ANC_RATES.ancillary_attribute1%TYPE, cp_anc_att2 IGS_FI_ANC_RATES.ancillary_attribute2%TYPE,
123: cp_anc_att3 IGS_FI_ANC_RATES.ancillary_attribute3%TYPE, cp_anc_att4 IGS_FI_ANC_RATES.ancillary_attribute4%TYPE,
124: cp_anc_att5 IGS_FI_ANC_RATES.ancillary_attribute5%TYPE, cp_anc_att6 IGS_FI_ANC_RATES.ancillary_attribute6%TYPE,
125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,
126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,

Line 123: cp_anc_att3 IGS_FI_ANC_RATES.ancillary_attribute3%TYPE, cp_anc_att4 IGS_FI_ANC_RATES.ancillary_attribute4%TYPE,

119: || (reverse chronological order - newest change first)
120: */
121:
122: CURSOR cur_impchgs_lines ( cp_anc_att1 IGS_FI_ANC_RATES.ancillary_attribute1%TYPE, cp_anc_att2 IGS_FI_ANC_RATES.ancillary_attribute2%TYPE,
123: cp_anc_att3 IGS_FI_ANC_RATES.ancillary_attribute3%TYPE, cp_anc_att4 IGS_FI_ANC_RATES.ancillary_attribute4%TYPE,
124: cp_anc_att5 IGS_FI_ANC_RATES.ancillary_attribute5%TYPE, cp_anc_att6 IGS_FI_ANC_RATES.ancillary_attribute6%TYPE,
125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,
126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,
127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,

Line 124: cp_anc_att5 IGS_FI_ANC_RATES.ancillary_attribute5%TYPE, cp_anc_att6 IGS_FI_ANC_RATES.ancillary_attribute6%TYPE,

120: */
121:
122: CURSOR cur_impchgs_lines ( cp_anc_att1 IGS_FI_ANC_RATES.ancillary_attribute1%TYPE, cp_anc_att2 IGS_FI_ANC_RATES.ancillary_attribute2%TYPE,
123: cp_anc_att3 IGS_FI_ANC_RATES.ancillary_attribute3%TYPE, cp_anc_att4 IGS_FI_ANC_RATES.ancillary_attribute4%TYPE,
124: cp_anc_att5 IGS_FI_ANC_RATES.ancillary_attribute5%TYPE, cp_anc_att6 IGS_FI_ANC_RATES.ancillary_attribute6%TYPE,
125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,
126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,
127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,
128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,

Line 125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,

121:
122: CURSOR cur_impchgs_lines ( cp_anc_att1 IGS_FI_ANC_RATES.ancillary_attribute1%TYPE, cp_anc_att2 IGS_FI_ANC_RATES.ancillary_attribute2%TYPE,
123: cp_anc_att3 IGS_FI_ANC_RATES.ancillary_attribute3%TYPE, cp_anc_att4 IGS_FI_ANC_RATES.ancillary_attribute4%TYPE,
124: cp_anc_att5 IGS_FI_ANC_RATES.ancillary_attribute5%TYPE, cp_anc_att6 IGS_FI_ANC_RATES.ancillary_attribute6%TYPE,
125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,
126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,
127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,
128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,
129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,

Line 126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,

122: CURSOR cur_impchgs_lines ( cp_anc_att1 IGS_FI_ANC_RATES.ancillary_attribute1%TYPE, cp_anc_att2 IGS_FI_ANC_RATES.ancillary_attribute2%TYPE,
123: cp_anc_att3 IGS_FI_ANC_RATES.ancillary_attribute3%TYPE, cp_anc_att4 IGS_FI_ANC_RATES.ancillary_attribute4%TYPE,
124: cp_anc_att5 IGS_FI_ANC_RATES.ancillary_attribute5%TYPE, cp_anc_att6 IGS_FI_ANC_RATES.ancillary_attribute6%TYPE,
125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,
126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,
127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,
128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,
129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,
130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,

Line 127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,

123: cp_anc_att3 IGS_FI_ANC_RATES.ancillary_attribute3%TYPE, cp_anc_att4 IGS_FI_ANC_RATES.ancillary_attribute4%TYPE,
124: cp_anc_att5 IGS_FI_ANC_RATES.ancillary_attribute5%TYPE, cp_anc_att6 IGS_FI_ANC_RATES.ancillary_attribute6%TYPE,
125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,
126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,
127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,
128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,
129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,
130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,
131: cp_fee_cal_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_cal_type%TYPE,

Line 128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,

124: cp_anc_att5 IGS_FI_ANC_RATES.ancillary_attribute5%TYPE, cp_anc_att6 IGS_FI_ANC_RATES.ancillary_attribute6%TYPE,
125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,
126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,
127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,
128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,
129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,
130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,
131: cp_fee_cal_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_cal_type%TYPE,
132: cp_anc_chg_rate IGS_FI_ANC_RATES.ancillary_chg_rate%TYPE) IS

Line 129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,

125: cp_anc_att7 IGS_FI_ANC_RATES.ancillary_attribute7%TYPE, cp_anc_att8 IGS_FI_ANC_RATES.ancillary_attribute8%TYPE,
126: cp_anc_att9 IGS_FI_ANC_RATES.ancillary_attribute9%TYPE, cp_anc_att10 IGS_FI_ANC_RATES.ancillary_attribute10%TYPE,
127: cp_anc_att11 IGS_FI_ANC_RATES.ancillary_attribute11%TYPE,cp_anc_att12 IGS_FI_ANC_RATES.ancillary_attribute12%TYPE,
128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,
129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,
130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,
131: cp_fee_cal_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_cal_type%TYPE,
132: cp_anc_chg_rate IGS_FI_ANC_RATES.ancillary_chg_rate%TYPE) IS
133:

Line 132: cp_anc_chg_rate IGS_FI_ANC_RATES.ancillary_chg_rate%TYPE) IS

128: cp_anc_att13 IGS_FI_ANC_RATES.ancillary_attribute13%TYPE,cp_anc_att14 IGS_FI_ANC_RATES.ancillary_attribute14%TYPE,
129: cp_anc_att15 IGS_FI_ANC_RATES.ancillary_attribute15%TYPE,cp_fee_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_type%TYPE,
130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,
131: cp_fee_cal_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_cal_type%TYPE,
132: cp_anc_chg_rate IGS_FI_ANC_RATES.ancillary_chg_rate%TYPE) IS
133:
134: SELECT 'x' FROM igs_fi_impchgs_lines i
135: WHERE (ancillary_attribute1 = cp_anc_att1 OR ( ancillary_attribute1 IS NULL AND cp_anc_att1 IS NULL)) AND
136: (ancillary_attribute2 = cp_anc_att2 OR ( ancillary_attribute2 IS NULL AND cp_anc_att2 IS NULL)) AND

Line 355: FROM igs_fi_anc_rates

351: || (reverse chronological order - newest change first)
352: */
353: CURSOR cur_rowid IS
354: SELECT rowid
355: FROM igs_fi_anc_rates
356: WHERE ancillary_rate_id = x_ancillary_rate_id
357: FOR UPDATE NOWAIT;
358:
359: lv_rowid cur_rowid%RowType;

Line 408: FROM igs_fi_anc_rates

404: || (reverse chronological order - newest change first)
405: */
406: CURSOR cur_rowid IS
407: SELECT rowid
408: FROM igs_fi_anc_rates
409: WHERE fee_cal_type = x_fee_cal_type
410: AND fee_ci_sequence_number = x_fee_ci_sequence_number
411: AND fee_type = x_fee_type
412: AND ((ancillary_attribute1 = x_ancillary_attribute1) OR (ancillary_attribute1 IS NULL AND x_ancillary_attribute1 IS NULL))

Line 595: FROM igs_fi_anc_rates

591: || (reverse chronological order - newest change first)
592: */
593: CURSOR c IS
594: SELECT rowid
595: FROM igs_fi_anc_rates
596: WHERE ancillary_rate_id = x_ancillary_rate_id;
597:
598: x_last_update_date DATE;
599: x_last_updated_by NUMBER;

Line 622: SELECT IGS_FI_ANC_RATES_S.NEXTVAL INTO x_ancillary_rate_id FROM DUAL;

618: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
619: igs_ge_msg_stack.add;
620: app_exception.raise_exception;
621: END IF;
622: SELECT IGS_FI_ANC_RATES_S.NEXTVAL INTO x_ancillary_rate_id FROM DUAL;
623:
624: before_dml(
625: p_action => 'INSERT',
626: x_rowid => x_rowid,

Line 655: INSERT INTO igs_fi_anc_rates (

651: x_last_updated_by => x_last_updated_by,
652: x_last_update_login => x_last_update_login
653: );
654:
655: INSERT INTO igs_fi_anc_rates (
656: ancillary_rate_id,
657: fee_type,
658: fee_cal_type,
659: fee_ci_sequence_number,

Line 779: FROM igs_fi_anc_rates

775: ancillary_attribute14,
776: ancillary_attribute15,
777: ancillary_chg_rate,
778: enabled_flag
779: FROM igs_fi_anc_rates
780: WHERE rowid = x_rowid
781: FOR UPDATE NOWAIT;
782:
783: tlinfo c1%ROWTYPE;

Line 923: UPDATE igs_fi_anc_rates

919: x_last_updated_by => x_last_updated_by,
920: x_last_update_login => x_last_update_login
921: );
922:
923: UPDATE igs_fi_anc_rates
924: SET
925: fee_type = new_references.fee_type,
926: fee_cal_type = new_references.fee_cal_type,
927: fee_ci_sequence_number = new_references.fee_ci_sequence_number,

Line 995: FROM igs_fi_anc_rates

991: || (reverse chronological order - newest change first)
992: */
993: CURSOR c1 IS
994: SELECT rowid
995: FROM igs_fi_anc_rates
996: WHERE ancillary_rate_id = x_ancillary_rate_id;
997:
998: BEGIN
999:

Line 1084: DELETE FROM igs_fi_anc_rates

1080: p_action => 'DELETE',
1081: x_rowid => x_rowid
1082: );
1083:
1084: DELETE FROM igs_fi_anc_rates
1085: WHERE rowid = x_rowid;
1086:
1087: IF (SQL%NOTFOUND) THEN
1088: RAISE NO_DATA_FOUND;

Line 1096: END igs_fi_anc_rates_pkg;

1092:
1093: END delete_row;
1094:
1095:
1096: END igs_fi_anc_rates_pkg;