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_PRC_FEE_ROLLV dependencies on IGS_FI_FEE_STR_STAT

Line 439: p_fee_structure_status IN IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE,

435: FROM IGS_CA_INST ci
436: WHERE ci.cal_type = p_dest_cal_type AND
437: ci.sequence_number = p_dest_sequence_number;
438: FUNCTION finpl_chk_fss (
439: p_fee_structure_status IN IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE,
440: p_message_name OUT NOCOPY VARCHAR2)
441: RETURN BOOLEAN AS
442: BEGIN
443: DECLARE

Line 444: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;

440: p_message_name OUT NOCOPY VARCHAR2)
441: RETURN BOOLEAN AS
442: BEGIN
443: DECLARE
444: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
445: CURSOR c_fss (
446: cp_fee_structure_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE) IS
447: SELECT fss.s_fee_structure_status
448: FROM IGS_FI_FEE_STR_STAT fss

Line 446: cp_fee_structure_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE) IS

442: BEGIN
443: DECLARE
444: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
445: CURSOR c_fss (
446: cp_fee_structure_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE) IS
447: SELECT fss.s_fee_structure_status
448: FROM IGS_FI_FEE_STR_STAT fss
449: WHERE fss.fee_structure_status= cp_fee_structure_status;
450: BEGIN

Line 448: FROM IGS_FI_FEE_STR_STAT fss

444: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
445: CURSOR c_fss (
446: cp_fee_structure_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE) IS
447: SELECT fss.s_fee_structure_status
448: FROM IGS_FI_FEE_STR_STAT fss
449: WHERE fss.fee_structure_status= cp_fee_structure_status;
450: BEGIN
451: OPEN c_fss(p_fee_structure_status);
452: FETCH c_fss INTO v_s_fee_structure_status;

Line 693: cst_active CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :=

689: BEGIN
690: DECLARE
691: e_resource_busy EXCEPTION;
692: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
693: cst_active CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :=
694: 'ACTIVE';
695: cst_ftci CONSTANT IGS_FI_FEE_AS_RATE.s_relation_type%TYPE := 'FTCI';
696: v_message_name VARCHAR2(30);
697: v_message_warning VARCHAR2(30);

Line 745: IGS_FI_FEE_STR_STAT fss

741: ftci.scope_rul_sequence_num,
742: ftci.elm_rng_order_name,
743: ftci.max_chg_elements
744: FROM IGS_FI_F_TYP_CA_INST ftci,
745: IGS_FI_FEE_STR_STAT fss
746: WHERE (p_fee_type IS NULL OR
747: ftci.fee_type = p_fee_type) AND
748: ftci.fee_cal_type = p_source_cal_type AND
749: ftci.fee_ci_sequence_number = p_source_sequence_number AND

Line 1205: cst_active CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='ACTIVE';

1201: RETURN BOOLEAN AS
1202: gv_other_detail VARCHAR2(255);
1203: BEGIN
1204: DECLARE
1205: cst_active CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='ACTIVE';
1206: cst_fcci CONSTANT IGS_FI_FEE_AS_RATE.s_relation_type%TYPE := 'FCCI';
1207: v_message_name VARCHAR2(30);
1208: v_message_warning VARCHAR2(30);
1209: v_fcci_inserted_ind BOOLEAN;

Line 1229: IGS_FI_FEE_STR_STAT fss,

1225: fcci.end_dai_sequence_number,
1226: fcci.retro_dt_alias,
1227: fcci.retro_dai_sequence_number
1228: FROM IGS_FI_F_CAT_CA_INST fcci,
1229: IGS_FI_FEE_STR_STAT fss,
1230: IGS_FI_FEE_CAT fc
1231: WHERE (p_fee_cat IS NULL OR
1232: fcci.fee_cat = p_fee_cat) AND
1233: fcci.fee_cal_type = p_source_cal_type AND

Line 1735: cst_active CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :=

1731: gv_other_detail VARCHAR2(255);
1732: l_v_token1_val IGS_LOOKUP_VALUES.MEANING%TYPE;
1733: BEGIN
1734: DECLARE
1735: cst_active CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :=
1736: 'ACTIVE';
1737: cst_fcfl CONSTANT IGS_FI_FEE_AS_RATE.s_relation_type%TYPE := 'FCFL';
1738: v_message_name VARCHAR2(30);
1739: v_message_warning VARCHAR2(30);

Line 1759: IGS_FI_FEE_STR_STAT fss

1755: fcfl.rul_sequence_number,
1756: fcfl.fee_cat,
1757: fcfl.waiver_calc_flag
1758: FROM IGS_FI_F_CAT_FEE_LBL fcfl,
1759: IGS_FI_FEE_STR_STAT fss
1760: WHERE fcfl.fee_cat = p_fee_cat AND
1761: fcfl.fee_cal_type = p_source_cal_type AND
1762: fcfl.fee_ci_sequence_number = p_source_sequence_number AND
1763: (fcfl.fee_type = p_fee_type OR