DBA Data[Home] [Help]

APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_FI_INV_INT

Line 52: from IGS_FI_INV_INT.Source_Transaction_Id%TYPE

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.

Line 53: to IGS_FI_INV_INT.Invoice_Id%TYPE

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 ,

Line 63: TYPE header_rec_type IS RECORD(p_person_id igs_fi_inv_int.person_id%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,

Line 64: p_fee_type igs_fi_inv_int.fee_type%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,

Line 65: p_fee_cat igs_fi_inv_int.fee_cat%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,

Line 66: p_fee_cal_type igs_fi_inv_int.fee_cal_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,

Line 67: p_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%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,

Line 68: p_course_cd igs_fi_inv_int.course_cd%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,

Line 69: p_attendance_type igs_fi_inv_int.attendance_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,
73: p_invoice_desc igs_fi_inv_int.invoice_desc%TYPE,

Line 70: p_attendance_mode igs_fi_inv_int.attendance_mode%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,

Line 71: p_invoice_amount igs_fi_inv_int.invoice_amount%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,

Line 72: p_invoice_creation_date igs_fi_inv_int.invoice_creation_date%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,

Line 73: p_invoice_desc igs_fi_inv_int.invoice_desc%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,

Line 74: p_transaction_type igs_fi_inv_int.transaction_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,
78: p_waiver_flag igs_fi_inv_int.waiver_flag%TYPE,

Line 75: p_currency_cd igs_fi_inv_int.currency_cd%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,

Line 76: p_exchange_rate igs_fi_inv_int.exchange_rate%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,

Line 77: p_effective_date igs_fi_inv_int.effective_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,
81: p_waiver_name igs_fi_inv_int.waiver_name%TYPE := NULL,

Line 78: p_waiver_flag igs_fi_inv_int.waiver_flag%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,
82: p_reverse_flag igs_fi_inv_int.waiver_flag%TYPE);

Line 79: p_waiver_reason igs_fi_inv_int.waiver_reason%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:

Line 80: p_source_transaction_id igs_fi_inv_int.invoice_id%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:
84: --Added new columns - p_unit_type_id,p_unit_class,p_unit_mode,p_cd,p_version_number,p_unit_level.

Line 81: p_waiver_name igs_fi_inv_int.waiver_name%TYPE := NULL,

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,

Line 82: p_reverse_flag igs_fi_inv_int.waiver_flag%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,