DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_PS_FEE_TRG

Line 57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%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 ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,

Line 58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,

54: );
55: --
56: PROCEDURE finp_ins_cft_hist(
57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,

Line 59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,

55: --
56: PROCEDURE finp_ins_cft_hist(
57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,

Line 60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,

56: PROCEDURE finp_ins_cft_hist(
57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,

Line 61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,

57: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,

Line 62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,

58: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,

Line 63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,

59: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,

Line 64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,

60: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,

Line 65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,

61: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,

Line 66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,

62: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,

Line 67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,

63: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,

Line 68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,

64: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,

Line 69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,

65: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,

Line 70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,

66: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,

Line 71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,

67: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,

Line 72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,

68: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,

Line 73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,

69: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,

Line 74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,

70: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,

Line 75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,

71: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,

Line 76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,

72: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );

Line 77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,

73: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );
81: --

Line 78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,

74: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );
81: --
82: --PROCEDURE finp_ins_cma_hist has been obsolted since the table IGS_FI_CHG_MTH_APP was being obsoleted

Line 79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,

75: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );
81: --
82: --PROCEDURE finp_ins_cma_hist has been obsolted since the table IGS_FI_CHG_MTH_APP was being obsoleted
83: -- this procedure invoked the tbh for the history rable which also is beng obsolete

Line 80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );

76: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE ,
77: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
78: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
79: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
80: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE );
81: --
82: --PROCEDURE finp_ins_cma_hist has been obsolted since the table IGS_FI_CHG_MTH_APP was being obsoleted
83: -- this procedure invoked the tbh for the history rable which also is beng obsolete
84: -- bug# 2187247 (rnirwani)