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_VAL_FAS dependencies on IGS_FI_FEE_AS

Line 15: 1)Replaced RAISE NO_DATA_FOUND in code with message IGS_FI_FEE_ASS_DAT

11: Obsoletion of SPONSOR_CD related Parameters and Check from Function FINP_VAL_FAS_UPD
12: schodava 28-NOV-2001 Enh # 2122257 : Implements the CR for 'Fee Category Change'
13: Change in function finp_val_fas_ass_ind
14: jbegum 26-Nov-2001 As part of bug #2040038
15: 1)Replaced RAISE NO_DATA_FOUND in code with message IGS_FI_FEE_ASS_DAT
16: 2)In the procedure finp_val_fas_upd TRUNC function was added in the IF condition
17: checks being done on effective_dt and transaction_dt
18: */
19: --

Line 49: --validate IGS_FI_FEE_AS.course_cd has a course_attempt_status with a fee_ass_ind

45: (reverse chronological order - newest change first)
46: ***************************************************************/
47: gv_other_detail VARCHAR2(255);
48: BEGIN --finp_val_fas_ass_ind
49: --validate IGS_FI_FEE_AS.course_cd has a course_attempt_status with a fee_ass_ind
50: --of 'Y'
51: DECLARE
52: v_system_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;
53: v_fee_ass_ind IGS_LOOKUPS_VAL.fee_ass_ind%TYPE;

Line 132: p_message_name := 'IGS_FI_FEE_ASS_DAT';

128: FETCH c_sca_scas INTO v_fee_ass_ind,
129: v_course_attempt_status;
130: IF (c_sca_scas%NOTFOUND) THEN
131: CLOSE c_sca_scas;
132: p_message_name := 'IGS_FI_FEE_ASS_DAT';
133: RETURN FALSE;
134: END IF;
135: CLOSE c_sca_scas;
136: ELSE -- look back into history

Line 142: p_message_name := 'IGS_FI_FEE_ASS_DAT';

138: FETCH c_scaehv INTO v_fee_ass_ind,
139: v_course_attempt_status;
140: IF (c_scaehv%NOTFOUND) THEN
141: CLOSE c_scaehv;
142: p_message_name := 'IGS_FI_FEE_ASS_DAT';
143: RETURN FALSE;
144: END IF;
145: CLOSE c_scaehv;
146: END IF;

Line 215: -- Validate IGS_FI_FEE_AS.SI_FI_S_TRN_TYPE for a manual assessment.

211: RETURN TRUE;
212: END;
213: END finp_val_fas_retro;
214: --
215: -- Validate IGS_FI_FEE_AS.SI_FI_S_TRN_TYPE for a manual assessment.
216: FUNCTION finp_val_fas_cat(
217: p_transaction_type IN VARCHAR2 ,
218: p_message_name OUT NOCOPY VARCHAR2 )
219: RETURN BOOLEAN AS

Line 222: --This module validates IGS_FI_FEE_AS.SI_FI_S_TRN_TYPE.

218: p_message_name OUT NOCOPY VARCHAR2 )
219: RETURN BOOLEAN AS
220: gv_other_detail VARCHAR2(255);
221: BEGIN --finp_val_fas_cat
222: --This module validates IGS_FI_FEE_AS.SI_FI_S_TRN_TYPE.
223: --SI_FI_S_TRN_TYPE.transaction_cat must equal 'DEBT' and
224: --s_tranaction_type.system_generated_ind must equal 'N'
225: DECLARE
226: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;

Line 276: FROM IGS_FI_FEE_AS_RT cfar

272: DECLARE
273: v_cfar_rec CHAR;
274: CURSOR c_cfar IS
275: SELECT 'X'
276: FROM IGS_FI_FEE_AS_RT cfar
277: WHERE cfar.person_id = p_person_id AND
278: cfar.course_cd = p_course_cd AND
279: cfar.fee_type = p_fee_type AND
280: p_effective_dt BETWEEN cfar.start_dt AND

Line 292: --Determine if a IGS_FI_FEE_AS_RT exists

288: p_fee_type IS NULL OR
289: p_effective_dt IS NULL) THEN
290: RETURN TRUE;
291: END IF;
292: --Determine if a IGS_FI_FEE_AS_RT exists
293: OPEN c_cfar;
294: FETCH c_cfar INTO v_cfar_rec;
295: IF (c_cfar%FOUND) THEN
296: p_message_name := 'IGS_FI_STUD_ACTIVE_CONT_FEEAS';

Line 305: -- Validate that appropriate optional fields are entered for IGS_FI_FEE_AS.

301: RETURN TRUE;
302: END;
303: END finp_val_fas_cntrct;
304: --
305: -- Validate that appropriate optional fields are entered for IGS_FI_FEE_AS.
306: FUNCTION finp_val_fas_create(
307: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
308: p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
309: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,

Line 314: --This module validates IGS_FI_FEE_AS.IGS_FI_FEE_TYPE with the fee category and

310: p_message_name OUT NOCOPY VARCHAR2 )
311: RETURN BOOLEAN AS
312: gv_other_detail VARCHAR2(255);
313: BEGIN --finp_val_fas_create
314: --This module validates IGS_FI_FEE_AS.IGS_FI_FEE_TYPE with the fee category and
315: -- IGS_PS_COURSE code.
316: --If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN',then fee category and
317: --course_cd cannot be specified in the IGS_FI_FEE_AS record. Otherwise they
318: --must be specified

Line 317: --course_cd cannot be specified in the IGS_FI_FEE_AS record. Otherwise they

313: BEGIN --finp_val_fas_create
314: --This module validates IGS_FI_FEE_AS.IGS_FI_FEE_TYPE with the fee category and
315: -- IGS_PS_COURSE code.
316: --If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN',then fee category and
317: --course_cd cannot be specified in the IGS_FI_FEE_AS record. Otherwise they
318: --must be specified
319: DECLARE
320: v_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
321: CURSOR c_ft IS

Line 343: p_message_name := 'IGS_FI_FEE_ASS_DAT';

339: OPEN c_ft;
340: FETCH c_ft INTO v_fee_trigger_cat;
341: IF (c_ft%NOTFOUND) THEN
342: CLOSE c_ft;
343: p_message_name := 'IGS_FI_FEE_ASS_DAT';
344: RETURN FALSE;
345: END IF;
346: CLOSE c_ft;
347:

Line 377: --This module validates IGS_FI_FEE_AS.comments.

373: p_message_name OUT NOCOPY VARCHAR2 )
374: RETURN BOOLEAN AS
375: gv_other_detail VARCHAR2(255);
376: BEGIN --finp_val_fas_com
377: --This module validates IGS_FI_FEE_AS.comments.
378: --IGS_FI_FEE_AS.comments cannot be NULL when a manual fee assessment record is
379: --created
380: DECLARE
381: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;

Line 378: --IGS_FI_FEE_AS.comments cannot be NULL when a manual fee assessment record is

374: RETURN BOOLEAN AS
375: gv_other_detail VARCHAR2(255);
376: BEGIN --finp_val_fas_com
377: --This module validates IGS_FI_FEE_AS.comments.
378: --IGS_FI_FEE_AS.comments cannot be NULL when a manual fee assessment record is
379: --created
380: DECLARE
381: v_transaction_cat IGS_LOOKUPS_VAL.transaction_cat%TYPE;
382: v_sys_generated_ind IGS_LOOKUPS_VAL.system_generated_ind%TYPE;

Line 472: p_message_name := 'IGS_FI_FEE_ASS_DAT';

468: OPEN c_strty;
469: FETCH c_strty INTO v_transaction_cat;
470: IF (c_strty%NOTFOUND) THEN
471: CLOSE c_strty;
472: p_message_name := 'IGS_FI_FEE_ASS_DAT';
473: RETURN FALSE;
474: END IF;
475: CLOSE c_strty;
476: IF v_transaction_cat = 'PAYMENT' THEN

Line 492: p_message_name := 'IGS_FI_FEE_ASS_DAT';

488: OPEN c_daiv_sd;
489: FETCH c_daiv_sd INTO v_start_dt;
490: IF (c_daiv_sd%NOTFOUND) THEN
491: CLOSE c_daiv_sd;
492: p_message_name := 'IGS_FI_FEE_ASS_DAT';
493: RETURN FALSE;
494: END IF;
495: CLOSE c_daiv_sd;
496: --Get the end date value of the liability

Line 501: p_message_name := 'IGS_FI_FEE_ASS_DAT';

497: OPEN c_daiv_ed;
498: FETCH c_daiv_ed INTO v_end_dt;
499: IF (c_daiv_ed%NOTFOUND) THEN
500: CLOSE c_daiv_ed;
501: p_message_name := 'IGS_FI_FEE_ASS_DAT';
502: RETURN FALSE;
503: END IF;
504: CLOSE c_daiv_ed;
505: --Check that effective date is between the start and end dates

Line 536: IGS_FI_FEE_ASS_DEBT_V.local_assessment_amount%TYPE

532: || Who When What
533: || (reverse chronological order - newest change first)
534: uudayapr 12-12-2003 bug#3080983 made the modification to v_total_amount_due
535: declartion as number instead
536: IGS_FI_FEE_ASS_DEBT_V.local_assessment_amount%TYPE
537: and the Cursor c_fadv to point to the table
538: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
539:
540: || vvutukur 19-Dec-2002 Bug#2680885.Commented out cursor c_fpv which selects from igs_fi_fee_pay_v, which

Line 538: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.

534: uudayapr 12-12-2003 bug#3080983 made the modification to v_total_amount_due
535: declartion as number instead
536: IGS_FI_FEE_ASS_DEBT_V.local_assessment_amount%TYPE
537: and the Cursor c_fadv to point to the table
538: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
539:
540: || vvutukur 19-Dec-2002 Bug#2680885.Commented out cursor c_fpv which selects from igs_fi_fee_pay_v, which
541: || is to be dropped.Instead, cursor c_fpv is redefined selecting 0 from dual.
542: || The datatype for v_total_payments variable is also changed to NUMBER after removing

Line 554: --Modified the cursor to fetch data from the Base table instead of the view IGS_FI_FEE_ASS_DEBT_V

550: --cause the students balance for the liability to be less than zero
551: DECLARE
552: v_total_amount_due NUMBER;
553: v_total_payments NUMBER;
554: --Modified the cursor to fetch data from the Base table instead of the view IGS_FI_FEE_ASS_DEBT_V
555: CURSOR c_fadv IS
556: SELECT SUM(fadv.transaction_amount)
557: FROM IGS_FI_FEE_AS fadv
558: WHERE fadv.person_id = p_person_id

Line 557: FROM IGS_FI_FEE_AS fadv

553: v_total_payments NUMBER;
554: --Modified the cursor to fetch data from the Base table instead of the view IGS_FI_FEE_ASS_DEBT_V
555: CURSOR c_fadv IS
556: SELECT SUM(fadv.transaction_amount)
557: FROM IGS_FI_FEE_AS fadv
558: WHERE fadv.person_id = p_person_id
559: AND fadv.fee_type = p_fee_type
560: AND fadv.fee_cal_type = p_fee_cal_type
561: AND fadv.fee_ci_sequence_number = p_fee_ci_sequence_number

Line 608: -- Validate update to columns in the IGS_FI_FEE_AS table.

604: RETURN TRUE;
605: END;
606: END finp_val_fas_balance;
607: --
608: -- Validate update to columns in the IGS_FI_FEE_AS table.
609:
610: -- Change History
611: -- Who When What
612: -- masehgal 17-Jan-2002 ENH # 2170429

Line 616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,

612: -- masehgal 17-Jan-2002 ENH # 2170429
613: -- Obsoletion of SPONSOR_CD related Parameters from Function FINP_VAL_FAS_UPD
614:
615: FUNCTION finp_val_fas_upd(
616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,

Line 617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,

613: -- Obsoletion of SPONSOR_CD related Parameters from Function FINP_VAL_FAS_UPD
614:
615: FUNCTION finp_val_fas_upd(
616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,

Line 618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,

614:
615: FUNCTION finp_val_fas_upd(
616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,

Line 619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,

615: FUNCTION finp_val_fas_upd(
616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,

Line 620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,

616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,

Line 621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,

617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,

Line 622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,

618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,

Line 623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,

619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,

Line 624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,

620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,

Line 625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,

621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,

Line 626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,

622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,

Line 627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,

623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,

Line 628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,

624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,

Line 629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,

625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,

Line 630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,

626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,

Line 631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,

627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,

Line 632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,

628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,

Line 633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,

629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,

Line 634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,

630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,

Line 635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,

631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,

Line 636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,

632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,

Line 637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,

633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,

Line 638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,

634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,

Line 639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,

635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,

Line 640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,

636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,

Line 641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,

637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,

Line 642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,

638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,

Line 643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,

639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,

Line 644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,

640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
648: p_message_name OUT NOCOPY VARCHAR2 )

Line 645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,

641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
648: p_message_name OUT NOCOPY VARCHAR2 )
649: RETURN BOOLEAN AS

Line 646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,

642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
648: p_message_name OUT NOCOPY VARCHAR2 )
649: RETURN BOOLEAN AS
650: gv_other_detail VARCHAR2(255);

Line 647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,

643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
648: p_message_name OUT NOCOPY VARCHAR2 )
649: RETURN BOOLEAN AS
650: gv_other_detail VARCHAR2(255);
651: BEGIN -- finp_val_fas_upd

Line 652: -- This routine validates fields being updated in the IGS_FI_FEE_AS

648: p_message_name OUT NOCOPY VARCHAR2 )
649: RETURN BOOLEAN AS
650: gv_other_detail VARCHAR2(255);
651: BEGIN -- finp_val_fas_upd
652: -- This routine validates fields being updated in the IGS_FI_FEE_AS
653: -- table may be changed.
654: BEGIN
655: p_message_name := NULL;
656: -- 1. Check for allowable changes