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.

[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGS_CA_INST

Line 1126: v_fee_cal_type igs_ca_inst.cal_type%TYPE;

1122: cst_hecs CONSTANT VARCHAR2(10) := 'HECS';
1123: cst_payment CONSTANT VARCHAR2(10) := 'PAYMENT';
1124: cst_discount CONSTANT VARCHAR2(10) := 'DISCOUNT';
1125: v_fp_total NUMBER;
1126: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1127: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1128: v_message_name fnd_new_messages.message_name%TYPE;
1129:
1130: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 1127: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1123: cst_payment CONSTANT VARCHAR2(10) := 'PAYMENT';
1124: cst_discount CONSTANT VARCHAR2(10) := 'DISCOUNT';
1125: v_fp_total NUMBER;
1126: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1127: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1128: v_message_name fnd_new_messages.message_name%TYPE;
1129:
1130: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1131: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS

Line 1130: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,

1126: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1127: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1128: v_message_name fnd_new_messages.message_name%TYPE;
1129:
1130: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1131: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1132: SELECT SUM(fas.transaction_amount/fas.exchange_rate)
1133: FROM IGS_FI_FEE_TYPE ft,
1134: IGS_FI_FEE_AS fas

Line 1131: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS

1127: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1128: v_message_name fnd_new_messages.message_name%TYPE;
1129:
1130: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1131: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1132: SELECT SUM(fas.transaction_amount/fas.exchange_rate)
1133: FROM IGS_FI_FEE_TYPE ft,
1134: IGS_FI_FEE_AS fas
1135: WHERE ft.s_fee_type = cst_hecs AND

Line 1205: v_fee_cal_type igs_ca_inst.cal_type%TYPE;

1201: -- Routine to determine the HECS Fee assessed for a student IGS_PS_COURSE attempt.
1202:
1203: cst_hecs CONSTANT VARCHAR2(4) := 'HECS';
1204: v_fp_total NUMBER;
1205: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1206: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1207: v_message_name fnd_new_messages.message_name%TYPE;
1208: --modification to the Cursor c_fp_total to point to the table IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1209: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 1206: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1202:
1203: cst_hecs CONSTANT VARCHAR2(4) := 'HECS';
1204: v_fp_total NUMBER;
1205: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1206: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1207: v_message_name fnd_new_messages.message_name%TYPE;
1208: --modification to the Cursor c_fp_total to point to the table IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1209: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1210: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS

Line 1209: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,

1205: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1206: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1207: v_message_name fnd_new_messages.message_name%TYPE;
1208: --modification to the Cursor c_fp_total to point to the table IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1209: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1210: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1211: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount
1212: FROM IGS_FI_FEE_TYPE ft,
1213: IGS_FI_FEE_AS fadv

Line 1210: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS

1206: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1207: v_message_name fnd_new_messages.message_name%TYPE;
1208: --modification to the Cursor c_fp_total to point to the table IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1209: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1210: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1211: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount
1212: FROM IGS_FI_FEE_TYPE ft,
1213: IGS_FI_FEE_AS fadv
1214: WHERE ft.s_fee_type = cst_hecs

Line 1263: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,

1259: FUNCTION finp_get_hecs_pymnt_optn(
1260: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1261: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1262: p_effective_dt IN DATE ,
1263: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
1264: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
1265: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
1266: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE,
1267: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,

Line 1264: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

1260: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1261: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1262: p_effective_dt IN DATE ,
1263: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
1264: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
1265: p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
1266: p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE,
1267: p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
1268: p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%

Line 1367: v_fee_cal_type igs_ca_inst.cal_type%TYPE;

1363: ******************************************************************/
1364:
1365: cst_tuition VARCHAR2(7) := 'TUTNFEE';
1366: v_loc_ass_amt NUMBER;
1367: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1368: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1369: v_message_name fnd_new_messages.message_name%TYPE;
1370:
1371: CURSOR c_local_ass_amt(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 1368: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1364:
1365: cst_tuition VARCHAR2(7) := 'TUTNFEE';
1366: v_loc_ass_amt NUMBER;
1367: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1368: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1369: v_message_name fnd_new_messages.message_name%TYPE;
1370:
1371: CURSOR c_local_ass_amt(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1372: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS

Line 1371: CURSOR c_local_ass_amt(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,

1367: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1368: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1369: v_message_name fnd_new_messages.message_name%TYPE;
1370:
1371: CURSOR c_local_ass_amt(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1372: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1373: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount
1374: FROM IGS_FI_FEE_TYPE ft,
1375: IGS_FI_FEE_AS fadv

Line 1372: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS

1368: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1369: v_message_name fnd_new_messages.message_name%TYPE;
1370:
1371: CURSOR c_local_ass_amt(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1372: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1373: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount
1374: FROM IGS_FI_FEE_TYPE ft,
1375: IGS_FI_FEE_AS fadv
1376: WHERE ft.s_fee_type = cst_tuition

Line 1442: p_cal_type IN igs_ca_inst.cal_type%TYPE,

1438: remarks :
1439: Change History
1440: Who When What
1441: ******************************************************************/
1442: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1443: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1444: p_cal_category IN igs_ca_type.s_cal_cat%TYPE,
1445: p_ret_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1446: p_ret_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

Line 1443: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

1439: Change History
1440: Who When What
1441: ******************************************************************/
1442: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1443: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1444: p_cal_category IN igs_ca_type.s_cal_cat%TYPE,
1445: p_ret_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1446: p_ret_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1447: p_message_name OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE)

Line 1445: p_ret_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

1441: ******************************************************************/
1442: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1443: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1444: p_cal_category IN igs_ca_type.s_cal_cat%TYPE,
1445: p_ret_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1446: p_ret_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1447: p_message_name OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE)
1448: RETURN BOOLEAN AS
1449: -- To derive the subordinate Load Calendar Instance uniquely linked

Line 1446: p_ret_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

1442: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1443: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1444: p_cal_category IN igs_ca_type.s_cal_cat%TYPE,
1445: p_ret_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1446: p_ret_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1447: p_message_name OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE)
1448: RETURN BOOLEAN AS
1449: -- To derive the subordinate Load Calendar Instance uniquely linked
1450: -- to the passed superior Fee calendar Instance

Line 1457: FROM igs_ca_inst_rel cir,

1453: SELECT sub_cal_type,
1454: sub_ci_sequence_number,
1455: sup_cal_type,
1456: sup_ci_sequence_number
1457: FROM igs_ca_inst_rel cir,
1458: igs_ca_type ct1,
1459: igs_ca_type ct2
1460: WHERE cir.sub_cal_type = ct1.cal_type
1461: AND cir.sup_cal_type = ct2.cal_type

Line 1514: p_cal_type IN igs_ca_inst.cal_type%TYPE,

1510: remarks :
1511: Change History
1512: Who When What
1513: ******************************************************************/
1514: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1515: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1516: p_cal_category IN igs_ca_type.s_cal_cat%TYPE)
1517: RETURN VARCHAR2 AS
1518:

Line 1515: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

1511: Change History
1512: Who When What
1513: ******************************************************************/
1514: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1515: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1516: p_cal_category IN igs_ca_type.s_cal_cat%TYPE)
1517: RETURN VARCHAR2 AS
1518:
1519: l_cal_type igs_ca_inst.cal_type%TYPE;

Line 1519: l_cal_type igs_ca_inst.cal_type%TYPE;

1515: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1516: p_cal_category IN igs_ca_type.s_cal_cat%TYPE)
1517: RETURN VARCHAR2 AS
1518:
1519: l_cal_type igs_ca_inst.cal_type%TYPE;
1520: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1521: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1522:
1523: BEGIN

Line 1520: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1516: p_cal_category IN igs_ca_type.s_cal_cat%TYPE)
1517: RETURN VARCHAR2 AS
1518:
1519: l_cal_type igs_ca_inst.cal_type%TYPE;
1520: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1521: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1522:
1523: BEGIN
1524: IF igs_fi_gen_001.FINP_GET_LFCI_RELN(