48: jbegum 20 Feb 02 As part of Enh bug #2228910
49: Changed the type declaration of
50: p_source_transaction_id in the
51: header_rec_type record structure
52: from IGS_FI_INV_INT.Source_Transaction_Id%TYPE
53: to IGS_FI_INV_INT.Invoice_Id%TYPE
54: Change done by : jbegum
55: Change date : 24-Sep-2001
56: Change : As part of the bug #1962286 the record data structure line_rec_type has been modified.
49: Changed the type declaration of
50: p_source_transaction_id in the
51: header_rec_type record structure
52: from IGS_FI_INV_INT.Source_Transaction_Id%TYPE
53: to IGS_FI_INV_INT.Invoice_Id%TYPE
54: Change done by : jbegum
55: Change date : 24-Sep-2001
56: Change : As part of the bug #1962286 the record data structure line_rec_type has been modified.
57: The fields p_unit_cd , p_unit_version_number , p_unit_location_cd , p_cal_type ,
59: Two new fields p_location_cd and p_uoo_id have been added.
60: Also the record structure attribute_rec_type was removed as it was not used anywhere
61: ********************************************************************************************************/
62:
63: TYPE header_rec_type IS RECORD(p_person_id igs_fi_inv_int.person_id%TYPE,
64: p_fee_type igs_fi_inv_int.fee_type%TYPE,
65: p_fee_cat igs_fi_inv_int.fee_cat%TYPE,
66: p_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
60: Also the record structure attribute_rec_type was removed as it was not used anywhere
61: ********************************************************************************************************/
62:
63: TYPE header_rec_type IS RECORD(p_person_id igs_fi_inv_int.person_id%TYPE,
64: p_fee_type igs_fi_inv_int.fee_type%TYPE,
65: p_fee_cat igs_fi_inv_int.fee_cat%TYPE,
66: p_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
68: p_course_cd igs_fi_inv_int.course_cd%TYPE,
61: ********************************************************************************************************/
62:
63: TYPE header_rec_type IS RECORD(p_person_id igs_fi_inv_int.person_id%TYPE,
64: p_fee_type igs_fi_inv_int.fee_type%TYPE,
65: p_fee_cat igs_fi_inv_int.fee_cat%TYPE,
66: p_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
68: p_course_cd igs_fi_inv_int.course_cd%TYPE,
69: p_attendance_type igs_fi_inv_int.attendance_type%TYPE,
62:
63: TYPE header_rec_type IS RECORD(p_person_id igs_fi_inv_int.person_id%TYPE,
64: p_fee_type igs_fi_inv_int.fee_type%TYPE,
65: p_fee_cat igs_fi_inv_int.fee_cat%TYPE,
66: p_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
68: p_course_cd igs_fi_inv_int.course_cd%TYPE,
69: p_attendance_type igs_fi_inv_int.attendance_type%TYPE,
70: p_attendance_mode igs_fi_inv_int.attendance_mode%TYPE,
63: TYPE header_rec_type IS RECORD(p_person_id igs_fi_inv_int.person_id%TYPE,
64: p_fee_type igs_fi_inv_int.fee_type%TYPE,
65: p_fee_cat igs_fi_inv_int.fee_cat%TYPE,
66: p_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
68: p_course_cd igs_fi_inv_int.course_cd%TYPE,
69: p_attendance_type igs_fi_inv_int.attendance_type%TYPE,
70: p_attendance_mode igs_fi_inv_int.attendance_mode%TYPE,
71: p_invoice_amount igs_fi_inv_int.invoice_amount%TYPE,
64: p_fee_type igs_fi_inv_int.fee_type%TYPE,
65: p_fee_cat igs_fi_inv_int.fee_cat%TYPE,
66: p_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
68: p_course_cd igs_fi_inv_int.course_cd%TYPE,
69: p_attendance_type igs_fi_inv_int.attendance_type%TYPE,
70: p_attendance_mode igs_fi_inv_int.attendance_mode%TYPE,
71: p_invoice_amount igs_fi_inv_int.invoice_amount%TYPE,
72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%TYPE,
65: p_fee_cat igs_fi_inv_int.fee_cat%TYPE,
66: p_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
68: p_course_cd igs_fi_inv_int.course_cd%TYPE,
69: p_attendance_type igs_fi_inv_int.attendance_type%TYPE,
70: p_attendance_mode igs_fi_inv_int.attendance_mode%TYPE,
71: p_invoice_amount igs_fi_inv_int.invoice_amount%TYPE,
72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%TYPE,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,
66: p_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE,
67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
68: p_course_cd igs_fi_inv_int.course_cd%TYPE,
69: p_attendance_type igs_fi_inv_int.attendance_type%TYPE,
70: p_attendance_mode igs_fi_inv_int.attendance_mode%TYPE,
71: p_invoice_amount igs_fi_inv_int.invoice_amount%TYPE,
72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%TYPE,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,
74: p_transaction_type igs_fi_inv_int.transaction_type%TYPE,
67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE,
68: p_course_cd igs_fi_inv_int.course_cd%TYPE,
69: p_attendance_type igs_fi_inv_int.attendance_type%TYPE,
70: p_attendance_mode igs_fi_inv_int.attendance_mode%TYPE,
71: p_invoice_amount igs_fi_inv_int.invoice_amount%TYPE,
72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%TYPE,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,
74: p_transaction_type igs_fi_inv_int.transaction_type%TYPE,
75: p_currency_cd igs_fi_inv_int.currency_cd%TYPE,
68: p_course_cd igs_fi_inv_int.course_cd%TYPE,
69: p_attendance_type igs_fi_inv_int.attendance_type%TYPE,
70: p_attendance_mode igs_fi_inv_int.attendance_mode%TYPE,
71: p_invoice_amount igs_fi_inv_int.invoice_amount%TYPE,
72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%TYPE,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,
74: p_transaction_type igs_fi_inv_int.transaction_type%TYPE,
75: p_currency_cd igs_fi_inv_int.currency_cd%TYPE,
76: p_exchange_rate igs_fi_inv_int.exchange_rate%TYPE,
69: p_attendance_type igs_fi_inv_int.attendance_type%TYPE,
70: p_attendance_mode igs_fi_inv_int.attendance_mode%TYPE,
71: p_invoice_amount igs_fi_inv_int.invoice_amount%TYPE,
72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%TYPE,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,
74: p_transaction_type igs_fi_inv_int.transaction_type%TYPE,
75: p_currency_cd igs_fi_inv_int.currency_cd%TYPE,
76: p_exchange_rate igs_fi_inv_int.exchange_rate%TYPE,
77: p_effective_date igs_fi_inv_int.effective_date%TYPE,
70: p_attendance_mode igs_fi_inv_int.attendance_mode%TYPE,
71: p_invoice_amount igs_fi_inv_int.invoice_amount%TYPE,
72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%TYPE,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,
74: p_transaction_type igs_fi_inv_int.transaction_type%TYPE,
75: p_currency_cd igs_fi_inv_int.currency_cd%TYPE,
76: p_exchange_rate igs_fi_inv_int.exchange_rate%TYPE,
77: p_effective_date igs_fi_inv_int.effective_date%TYPE,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,
71: p_invoice_amount igs_fi_inv_int.invoice_amount%TYPE,
72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%TYPE,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,
74: p_transaction_type igs_fi_inv_int.transaction_type%TYPE,
75: p_currency_cd igs_fi_inv_int.currency_cd%TYPE,
76: p_exchange_rate igs_fi_inv_int.exchange_rate%TYPE,
77: p_effective_date igs_fi_inv_int.effective_date%TYPE,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,
79: p_waiver_reason igs_fi_inv_int.waiver_reason%TYPE,
72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%TYPE,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,
74: p_transaction_type igs_fi_inv_int.transaction_type%TYPE,
75: p_currency_cd igs_fi_inv_int.currency_cd%TYPE,
76: p_exchange_rate igs_fi_inv_int.exchange_rate%TYPE,
77: p_effective_date igs_fi_inv_int.effective_date%TYPE,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,
79: p_waiver_reason igs_fi_inv_int.waiver_reason%TYPE,
80: p_source_transaction_id igs_fi_inv_int.invoice_id%TYPE,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,
74: p_transaction_type igs_fi_inv_int.transaction_type%TYPE,
75: p_currency_cd igs_fi_inv_int.currency_cd%TYPE,
76: p_exchange_rate igs_fi_inv_int.exchange_rate%TYPE,
77: p_effective_date igs_fi_inv_int.effective_date%TYPE,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,
79: p_waiver_reason igs_fi_inv_int.waiver_reason%TYPE,
80: p_source_transaction_id igs_fi_inv_int.invoice_id%TYPE,
81: p_waiver_name igs_fi_inv_int.waiver_name%TYPE := NULL,
74: p_transaction_type igs_fi_inv_int.transaction_type%TYPE,
75: p_currency_cd igs_fi_inv_int.currency_cd%TYPE,
76: p_exchange_rate igs_fi_inv_int.exchange_rate%TYPE,
77: p_effective_date igs_fi_inv_int.effective_date%TYPE,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,
79: p_waiver_reason igs_fi_inv_int.waiver_reason%TYPE,
80: p_source_transaction_id igs_fi_inv_int.invoice_id%TYPE,
81: p_waiver_name igs_fi_inv_int.waiver_name%TYPE := NULL,
82: p_reverse_flag igs_fi_inv_int.waiver_flag%TYPE);
75: p_currency_cd igs_fi_inv_int.currency_cd%TYPE,
76: p_exchange_rate igs_fi_inv_int.exchange_rate%TYPE,
77: p_effective_date igs_fi_inv_int.effective_date%TYPE,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,
79: p_waiver_reason igs_fi_inv_int.waiver_reason%TYPE,
80: p_source_transaction_id igs_fi_inv_int.invoice_id%TYPE,
81: p_waiver_name igs_fi_inv_int.waiver_name%TYPE := NULL,
82: p_reverse_flag igs_fi_inv_int.waiver_flag%TYPE);
83:
76: p_exchange_rate igs_fi_inv_int.exchange_rate%TYPE,
77: p_effective_date igs_fi_inv_int.effective_date%TYPE,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,
79: p_waiver_reason igs_fi_inv_int.waiver_reason%TYPE,
80: p_source_transaction_id igs_fi_inv_int.invoice_id%TYPE,
81: p_waiver_name igs_fi_inv_int.waiver_name%TYPE := NULL,
82: p_reverse_flag igs_fi_inv_int.waiver_flag%TYPE);
83:
84: --Added new columns - p_unit_type_id,p_unit_class,p_unit_mode,p_cd,p_version_number,p_unit_level.
77: p_effective_date igs_fi_inv_int.effective_date%TYPE,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,
79: p_waiver_reason igs_fi_inv_int.waiver_reason%TYPE,
80: p_source_transaction_id igs_fi_inv_int.invoice_id%TYPE,
81: p_waiver_name igs_fi_inv_int.waiver_name%TYPE := NULL,
82: p_reverse_flag igs_fi_inv_int.waiver_flag%TYPE);
83:
84: --Added new columns - p_unit_type_id,p_unit_class,p_unit_mode,p_cd,p_version_number,p_unit_level.
85: TYPE line_rec_type IS RECORD(p_s_chg_method_type igs_fi_invln_int.s_chg_method_type%TYPE,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,
79: p_waiver_reason igs_fi_inv_int.waiver_reason%TYPE,
80: p_source_transaction_id igs_fi_inv_int.invoice_id%TYPE,
81: p_waiver_name igs_fi_inv_int.waiver_name%TYPE := NULL,
82: p_reverse_flag igs_fi_inv_int.waiver_flag%TYPE);
83:
84: --Added new columns - p_unit_type_id,p_unit_class,p_unit_mode,p_cd,p_version_number,p_unit_level.
85: TYPE line_rec_type IS RECORD(p_s_chg_method_type igs_fi_invln_int.s_chg_method_type%TYPE,
86: p_description igs_fi_invln_int.description%TYPE,