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

Line 36: gurprsin 29-Aug-2005 Bug 3392088, Added max_chg_elements column to the IGS_FI_F_TYP_CA_INST_PKG.Insert_Row

32: Before rolling over an FTCI, Charge Method/Rule Seq Num is validated whether source FTCI has a value.
33: This is done even for FCFL.
34: svuppala 09-Sep-2005 Bug 3822813 - The setting of variable l_b_fcfl_not_found to TRUE is removed
35: in finp_ins_roll_ftci
36: gurprsin 29-Aug-2005 Bug 3392088, Added max_chg_elements column to the IGS_FI_F_TYP_CA_INST_PKG.Insert_Row
37: svuppala 22-Aug-2005 Enh 3392095, Added waiver_calc_flag column to the IGS_FI_F_CAT_FEE_LBL_Pkg.Insert_Row
38: gurprsin 28-Jun-2005 Bug# 3392088 Modified the rollover process to incorporate
39: sub element ranges and rates table rollover.
40: svuppala 03-Jun-2005 Enh# 3442712 - Modified TBH calls to table IGS_FI_FEE_AS_RATE to include

Line 90: vchappid 25-Apr-2002 Bug#2329407, removed the reference to the fin_cal_type, fin_ci_sequence_number from the view IGS_FI_F_TYP_CA_INST

86: fee_ci_sequence_number in different fee types then as many records are inserted, this function was returning FALSE
87: when the record is already exists, returning flase will terminate the process. Process should log the message and
88: should continue with next rollover categories
89:
90: vchappid 25-Apr-2002 Bug#2329407, removed the reference to the fin_cal_type, fin_ci_sequence_number from the view IGS_FI_F_TYP_CA_INST
91: Reference to the Financial Calendar is removed as a part of SFCR005 Build. Removed the parameters account_cd, fin_cal_type
92: and fin_ci_sequence_number from the function call finp_val_ftci_rqrd
93: schodava 06-Feb-2002 Enh # 2187247
94: SFCR021 : FCI-LCI Relation

Line 97: also from the insert_row of igs_fi_f_typ_ca_inst_pkg.Bug:2175865

93: schodava 06-Feb-2002 Enh # 2187247
94: SFCR021 : FCI-LCI Relation
95: Removed the function for Charge Method Apportion rollover finp_ins_roll_cma
96: Sarakshi 15-Jan-2002 In function finp_ins_roll_ftci,removed the reference of subaccount_id from cursor c_ftci_fss
97: also from the insert_row of igs_fi_f_typ_ca_inst_pkg.Bug:2175865
98: sarakshi 19-Nov-2001 Added column ret_account_cd,ret_gl_ccid in the select list of cur c_ftci_fss also in
99: the call to the insert row of igs_fi_f_typ_ca_inst_pkg
100: as a prt of sfcr012, bug:2113459
101: schodava 3-Sep-2001 Bug : 1966961

Line 99: the call to the insert row of igs_fi_f_typ_ca_inst_pkg

95: Removed the function for Charge Method Apportion rollover finp_ins_roll_cma
96: Sarakshi 15-Jan-2002 In function finp_ins_roll_ftci,removed the reference of subaccount_id from cursor c_ftci_fss
97: also from the insert_row of igs_fi_f_typ_ca_inst_pkg.Bug:2175865
98: sarakshi 19-Nov-2001 Added column ret_account_cd,ret_gl_ccid in the select list of cur c_ftci_fss also in
99: the call to the insert row of igs_fi_f_typ_ca_inst_pkg
100: as a prt of sfcr012, bug:2113459
101: schodava 3-Sep-2001 Bug : 1966961
102: Obsolete Items CCR
103: Removed references of the Account Code link to Financial Calendar

Line 132: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,

128: g_v_alternate_code igs_ca_inst_all.alternate_code%TYPE := NULL;
129:
130: -- Routine to rollover fee type calendar instances between cal instances
131: FUNCTION finp_ins_roll_ftci(
132: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
133: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
134: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
135: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
136: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,

Line 138: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,

134: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
135: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
136: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
137: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
138: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
139: p_message_name OUT NOCOPY VARCHAR2 ,
140: p_message_warning OUT NOCOPY VARCHAR2 )
141: RETURN BOOLEAN;
142: --

Line 310: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,

306: p_n_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE
307: ) RETURN BOOLEAN;
308:
309: -- Forward declaration of the finp_ins_roll_tprs procedure
310: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
311: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
312: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
313: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
314: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

Line 311: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

307: ) RETURN BOOLEAN;
308:
309: -- Forward declaration of the finp_ins_roll_tprs procedure
310: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
311: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
312: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
313: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
314: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
315: p_b_status OUT NOCOPY BOOLEAN,

Line 312: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

308:
309: -- Forward declaration of the finp_ins_roll_tprs procedure
310: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
311: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
312: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
313: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
314: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
315: p_b_status OUT NOCOPY BOOLEAN,
316: p_v_message_name OUT NOCOPY VARCHAR2);

Line 313: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

309: -- Forward declaration of the finp_ins_roll_tprs procedure
310: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
311: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
312: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
313: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
314: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
315: p_b_status OUT NOCOPY BOOLEAN,
316: p_v_message_name OUT NOCOPY VARCHAR2);
317:

Line 314: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

310: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
311: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
312: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
313: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
314: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
315: p_b_status OUT NOCOPY BOOLEAN,
316: p_v_message_name OUT NOCOPY VARCHAR2);
317:
318: --

Line 355: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST_ALL.fee_type_ci_status%TYPE ,

351: P_Source_Calendar IN VARCHAR2,
352: P_Dest_Calendar IN VARCHAR2 ,
353: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
354: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
355: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST_ALL.fee_type_ci_status%TYPE ,
356: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
357: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_liability_status%TYPE,
358: p_org_id NUMBER
359: ) AS

Line 645: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,

641: END finp_prc_fee_rollvr;
642: --
643: -- Routine to rollover fee type calendar instances between cal instances
644: FUNCTION finp_ins_roll_ftci(
645: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
646: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
647: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
648: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
649: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,

Line 651: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,

647: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
648: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
649: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
650: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
651: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
652: p_message_name OUT NOCOPY VARCHAR2 ,
653: p_message_warning OUT NOCOPY VARCHAR2 )
654: RETURN BOOLEAN AS
655: /*----------------------------------------------------------------------------

Line 685: || c_ftci_fss and from the call to IGS_FI_F_TYP_CA_INST_PKG.INSERT_ROW).

681: || vvutukur 26-Aug-2002 Bug#2531390.The comment in the code regarding the rollover of fee payment
682: || schedules is removed to avoid confusion.Removed DEFAULTing values of
683: || l_already_rolled,l_fcfl_exists_ind to avoid gscc warnings.
684: || vvutukur 23-Jul-2002 Bug#2425767.Removed references to payment_hierarchy_rank(from cursor
685: || c_ftci_fss and from the call to IGS_FI_F_TYP_CA_INST_PKG.INSERT_ROW).
686: ----------------------------------------------------------------------------*/
687: gv_other_detail VARCHAR2(255);
688: l_v_token1_val IGS_LOOKUP_VALUES.MEANING%TYPE;
689: BEGIN

Line 705: v_fee_type_ci_status IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE;

701: v_insert_record BOOLEAN; -- used for diff bet ins/upd of rec for dest cal type. not reqd now as no upd takes place
702: l_already_rolled BOOLEAN := FALSE;
703: l_fcfl_exists_ind BOOLEAN := TRUE;
704: v_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE;
705: v_fee_type_ci_status IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE;
706: v_tmp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE;
707: v_closed_ind IGS_FI_FEE_TYPE.closed_ind%TYPE;
708: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
709: v_valid_dai BOOLEAN;

Line 706: v_tmp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE;

702: l_already_rolled BOOLEAN := FALSE;
703: l_fcfl_exists_ind BOOLEAN := TRUE;
704: v_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE;
705: v_fee_type_ci_status IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE;
706: v_tmp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE;
707: v_closed_ind IGS_FI_FEE_TYPE.closed_ind%TYPE;
708: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
709: v_valid_dai BOOLEAN;
710: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;

Line 711: l_n_org_id IGS_FI_F_TYP_CA_INST.ORG_ID%type := igs_ge_gen_003.get_org_id;

707: v_closed_ind IGS_FI_FEE_TYPE.closed_ind%TYPE;
708: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
709: v_valid_dai BOOLEAN;
710: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
711: l_n_org_id IGS_FI_F_TYP_CA_INST.ORG_ID%type := igs_ge_gen_003.get_org_id;
712: l_rowid VARCHAR2(25);
713: l_b_records_found BOOLEAN;
714:
715:

Line 744: FROM IGS_FI_F_TYP_CA_INST ftci,

740: --Added by gurprsin,as a part of bug:3392088
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

Line 753: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS

749: ftci.fee_ci_sequence_number = p_source_sequence_number AND
750: ftci.fee_type_ci_status = fss.fee_structure_status AND
751: fss.s_fee_structure_status = cst_active;
752: CURSOR c_ft (
753: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS
754: SELECT ft.closed_ind, ft.s_fee_type
755: FROM IGS_FI_FEE_TYPE ft
756: WHERE ft.fee_type = cp_fee_type;
757:

Line 762: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS

758: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
759:
760: -- This cursor is changed as a part of SFCR005 (Enh #1966961)
761: CURSOR c_ftci (
762: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS
763: SELECT 'x'
764: FROM IGS_FI_F_TYP_CA_INST ftci
765: WHERE ftci.fee_type = cp_fee_type AND
766: ftci.fee_cal_type = p_dest_cal_type AND

Line 764: FROM IGS_FI_F_TYP_CA_INST ftci

760: -- This cursor is changed as a part of SFCR005 (Enh #1966961)
761: CURSOR c_ftci (
762: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS
763: SELECT 'x'
764: FROM IGS_FI_F_TYP_CA_INST ftci
765: WHERE ftci.fee_type = cp_fee_type AND
766: ftci.fee_cal_type = p_dest_cal_type AND
767: ftci.fee_ci_sequence_number = p_dest_sequence_number;
768: CURSOR c_fcfl (

Line 790: l_v_retention_level_code igs_fi_f_typ_ca_inst.retention_level_code%TYPE;

786: cal_type = cp_cal_type AND
787: ci_sequence_number = cp_ci_sequence_number;
788:
789: l_b_status BOOLEAN;
790: l_v_retention_level_code igs_fi_f_typ_ca_inst.retention_level_code%TYPE;
791: BEGIN
792: -- This function will roll all IGS_FI_F_TYP_CA_INST records underneath a
793: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
794: -- It also controls the rollover of;

Line 792: -- This function will roll all IGS_FI_F_TYP_CA_INST records underneath a

788:
789: l_b_status BOOLEAN;
790: l_v_retention_level_code igs_fi_f_typ_ca_inst.retention_level_code%TYPE;
791: BEGIN
792: -- This function will roll all IGS_FI_F_TYP_CA_INST records underneath a
793: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
794: -- It also controls the rollover of;
795: -- * fee_refund_schedule
796: -- * IGS_FI_FEE_RET_SCHD

Line 804: -- IGS_GE_NOTE: If some of the IGS_FI_F_TYP_CA_INST records already exist then

800: -- * IGS_FI_ELM_RANGE
801: -- The assumption is being made that the "destination" IGS_CA_INST
802: -- is open and active - it is the responsibility of the calling routine
803: -- to check for this.
804: -- IGS_GE_NOTE: If some of the IGS_FI_F_TYP_CA_INST records already exist then
805: -- these may be updated IF the assiciated IGS_FI_ACC link has not been
806: -- previously established via the rollover, and it is now possible to do so.
807: --------------------------------------------------------------------------
808: p_message_name := Null;

Line 839: -- process next IGS_FI_F_TYP_CA_INST

835: IF p_fee_cat IS NOT NULL THEN
836: OPEN c_fcfl(v_ftci_fss_rec.fee_type);
837: FETCH c_fcfl INTO v_fee_cat;
838: IF (c_fcfl%NOTFOUND) THEN
839: -- process next IGS_FI_F_TYP_CA_INST
840: v_process_next_ftci := TRUE;
841: l_fcfl_exists_ind := FALSE;
842: END IF;
843: CLOSE c_fcfl;

Line 852: -- process next IGS_FI_F_TYP_CA_INST

848: FETCH c_ft INTO v_closed_ind, l_s_fee_type;
849: CLOSE c_ft;
850: IF (v_closed_ind = 'Y') THEN
851: FND_FILE.PUT_LINE (FND_FILE.LOG, Fnd_Message.Get_String ('IGS', 'IGS_FI_FEETYPE_CLOSED'));
852: -- process next IGS_FI_F_TYP_CA_INST
853: v_process_next_ftci := TRUE;
854: END IF;
855: END IF;
856:

Line 859: -- Check for the existence of the IGS_FI_F_TYP_CA_INST

855: END IF;
856:
857: -- This is changed as a part of CCR SFCR005 (Enh # 1966961)
858: IF (v_process_next_ftci = FALSE) THEN
859: -- Check for the existence of the IGS_FI_F_TYP_CA_INST
860: -- record under the destination calendar.
861: OPEN c_ftci(v_ftci_fss_rec.fee_type);
862: FETCH c_ftci INTO v_dummy;
863: IF (c_ftci%FOUND) THEN

Line 967: IGS_FI_F_TYP_CA_INST_PKG.INSERT_ROW(

963: v_process_next_ftci := TRUE;
964: ELSE
965: l_rowid := NULL; -- initialise l_rowid to null before passing into the TBH
966: -- l_rowid with a value will throw Un-Handled Exception
967: IGS_FI_F_TYP_CA_INST_PKG.INSERT_ROW(
968: X_ROWID=>l_rowid,
969: X_FEE_TYPE=>v_ftci_fss_rec.fee_type,
970: X_FEE_CAL_TYPE=>p_dest_cal_type,
971: X_FEE_CI_SEQUENCE_NUMBER=>p_dest_sequence_number,

Line 1776: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS

1772: fcfl.fee_cal_type = p_dest_cal_type AND
1773: fcfl.fee_ci_sequence_number = p_dest_sequence_number AND
1774: fcfl.fee_type = cp_fee_type;
1775: CURSOR c_ftci (
1776: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS
1777: SELECT ftci.fee_type
1778: FROM IGS_FI_F_TYP_CA_INST ftci
1779: WHERE ftci.fee_type = cp_fee_type AND
1780: ftci.fee_cal_type = p_dest_cal_type AND

Line 1778: FROM IGS_FI_F_TYP_CA_INST ftci

1774: fcfl.fee_type = cp_fee_type;
1775: CURSOR c_ftci (
1776: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS
1777: SELECT ftci.fee_type
1778: FROM IGS_FI_F_TYP_CA_INST ftci
1779: WHERE ftci.fee_type = cp_fee_type AND
1780: ftci.fee_cal_type = p_dest_cal_type AND
1781: ftci.fee_ci_sequence_number = p_dest_sequence_number;
1782: CURSOR c_dai (

Line 1844: -- Check for the existence of the IGS_FI_F_TYP_CA_INST

1840: v_fee_liability_status := p_fee_liability_status;
1841: ELSE
1842: v_fee_liability_status := v_fcfl_fss_rec.fee_liability_status;
1843: END IF;
1844: -- Check for the existence of the IGS_FI_F_TYP_CA_INST
1845: -- record under the destination calendar
1846: OPEN c_ftci( v_fcfl_fss_rec.fee_type);
1847: FETCH c_ftci INTO v_fee_type;
1848: IF (c_ftci%NOTFOUND) THEN

Line 3386: CURSOR cur_ftci_accts(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,

3382: pathipat 26-Jun-2003 Bug:2992967 - Table validation value set for segments
3383: Removed cur_rev_account_Seg and its usage. Added call to
3384: fnd_flex_keyval.validate_segs()
3385: ***************************************************************/
3386: CURSOR cur_ftci_accts(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
3387: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3388: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
3389: SELECT *
3390: FROM igs_fi_ftci_accts

Line 3387: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

3383: Removed cur_rev_account_Seg and its usage. Added call to
3384: fnd_flex_keyval.validate_segs()
3385: ***************************************************************/
3386: CURSOR cur_ftci_accts(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
3387: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3388: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
3389: SELECT *
3390: FROM igs_fi_ftci_accts
3391: WHERE fee_type = cp_v_fee_type

Line 3388: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS

3384: fnd_flex_keyval.validate_segs()
3385: ***************************************************************/
3386: CURSOR cur_ftci_accts(cp_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
3387: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3388: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
3389: SELECT *
3390: FROM igs_fi_ftci_accts
3391: WHERE fee_type = cp_v_fee_type
3392: AND fee_cal_type = cp_v_fee_cal_type

Line 3397: CURSOR cur_rev_account_cd(cp_v_rev_acct_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE) IS

3393: AND fee_ci_sequence_number = cp_n_fee_ci_seq_number
3394: ORDER BY order_sequence;
3395: l_rec_ftci_accts cur_ftci_accts%ROWTYPE;
3396:
3397: CURSOR cur_rev_account_cd(cp_v_rev_acct_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE) IS
3398: SELECT closed_ind
3399: FROM igs_fi_acc
3400: WHERE account_cd = cp_v_rev_acct_cd;
3401: l_rec_rev_account_cd cur_rev_account_cd%ROWTYPE;

Line 3957: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,

3953: RETURN TRUE;
3954:
3955: END finp_ins_roll_usft;
3956:
3957: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
3958: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3959: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3960: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3961: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

Line 3958: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

3954:
3955: END finp_ins_roll_usft;
3956:
3957: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
3958: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3959: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3960: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3961: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3962: p_b_status OUT NOCOPY BOOLEAN,

Line 3959: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

3955: END finp_ins_roll_usft;
3956:
3957: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
3958: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3959: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3960: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3961: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3962: p_b_status OUT NOCOPY BOOLEAN,
3963: p_v_message_name OUT NOCOPY VARCHAR2) AS

Line 3960: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

3956:
3957: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
3958: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3959: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3960: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3961: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3962: p_b_status OUT NOCOPY BOOLEAN,
3963: p_v_message_name OUT NOCOPY VARCHAR2) AS
3964: /****************************************************************

Line 3961: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

3957: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
3958: p_v_source_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3959: p_n_source_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3960: p_v_dest_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3961: p_n_dest_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3962: p_b_status OUT NOCOPY BOOLEAN,
3963: p_v_message_name OUT NOCOPY VARCHAR2) AS
3964: /****************************************************************
3965: || Created By : [email protected]

Line 3979: CURSOR cur_dist_tp(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

3975: || is now rounded off to currency precision
3976: *****************************************************************/
3977:
3978: -- Cursor for identifying Distinct Teaching Periods
3979: CURSOR cur_dist_tp(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3980: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3981: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE) IS
3982: SELECT DISTINCT teach_cal_type,
3983: teach_ci_sequence_number

Line 3980: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

3976: *****************************************************************/
3977:
3978: -- Cursor for identifying Distinct Teaching Periods
3979: CURSOR cur_dist_tp(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3980: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3981: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE) IS
3982: SELECT DISTINCT teach_cal_type,
3983: teach_ci_sequence_number
3984: FROM igs_fi_tp_ret_schd

Line 3981: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE) IS

3977:
3978: -- Cursor for identifying Distinct Teaching Periods
3979: CURSOR cur_dist_tp(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
3980: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
3981: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE) IS
3982: SELECT DISTINCT teach_cal_type,
3983: teach_ci_sequence_number
3984: FROM igs_fi_tp_ret_schd
3985: WHERE fee_cal_type = cp_fee_cal_type

Line 4000: CURSOR cur_ret_schdl(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,

3996: WHERE cal_type = cp_cal_type
3997: AND prior_ci_sequence_number = cp_seq_number;
3998:
3999: -- Cursor for identifying the Retention Schedules
4000: CURSOR cur_ret_schdl(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
4001: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
4002: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
4003: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
4004: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS

Line 4001: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,

3997: AND prior_ci_sequence_number = cp_seq_number;
3998:
3999: -- Cursor for identifying the Retention Schedules
4000: CURSOR cur_ret_schdl(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
4001: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
4002: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
4003: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
4004: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
4005: SELECT *

Line 4002: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,

3998:
3999: -- Cursor for identifying the Retention Schedules
4000: CURSOR cur_ret_schdl(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
4001: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
4002: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
4003: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
4004: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
4005: SELECT *
4006: FROM igs_fi_tp_ret_schd