DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_AS_RT

Line 34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,

30: -- procedure as part of Bug 2175865
31: /* Obseleted the procedure finp_ins_fe_hist( as part of bug 2126091 as this is no longer used -sykrishn 29112001 */
32: --
33: PROCEDURE finp_ins_cfar_hist (
34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,

Line 35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,

31: /* Obseleted the procedure finp_ins_fe_hist( as part of bug 2126091 as this is no longer used -sykrishn 29112001 */
32: --
33: PROCEDURE finp_ins_cfar_hist (
34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,

Line 36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,

32: --
33: PROCEDURE finp_ins_cfar_hist (
34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,

Line 37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,

33: PROCEDURE finp_ins_cfar_hist (
34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,

Line 38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,

34: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,

Line 39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,

35: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,

Line 40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,

36: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,

Line 41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,

37: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
38: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
40: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,

Line 46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,

42: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,

Line 47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,

43: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,

Line 48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,

44: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,

Line 49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,

45: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE

Line 50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,

46: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
54: );

Line 51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,

47: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
54: );
55: --

Line 52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,

48: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
54: );
55: --
56: PROCEDURE finp_ins_cft_hist(

Line 53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE

49: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
50: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
52: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
53: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
54: );
55: --
56: PROCEDURE finp_ins_cft_hist(
57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,