1 Package ota_tfl_api_business_rules AUTHID CURRENT_USER as
2 /* $Header: ottfl02t.pkh 115.2 2002/11/29 09:24:36 arkashya ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------< check_update_attributes >-------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- PUBLIC
9 -- Description:
10 -- If the line has been transferred then no attributes may be updated.
11 --
12 Procedure check_update_attributes
13 (
14 p_transfer_status in varchar2
15 );
16 --
17 -- ----------------------------------------------------------------------------
18 -- |-------------------------< check_cancelled_flag >-------------------------|
19 -- ----------------------------------------------------------------------------
20 --
21 -- PUBLIC
22 -- Description:
23 -- The attribute CANCELLED_FLAG must be in the doamin 'Yes No'
24 --
25 Procedure check_cancelled_flag
26 (
27 p_cancelled_flag in varchar2
28 );
29 --
30 -- ----------------------------------------------------------------------------
31 -- |------------------------< check_sequence_number >-------------------------|
32 -- ----------------------------------------------------------------------------
33 --
34 -- PUBLIC
35 -- Description:
36 -- The sequence_number for a finance line within a finance_header_id
37 -- MUST be unique.
38 --
39 Procedure check_sequence_number
40 (
41 p_finance_header_id in number
42 ,p_sequence_number in number
43 );
44 --
45 -- ----------------------------------------------------------------------------
46 -- |-----------------------< get_next_sequence_number >-----------------------|
47 -- ----------------------------------------------------------------------------
48 --
49 -- PUBLIC
50 -- Description:
51 -- The sequence_number for a finance line within a finance_header_id
52 -- MUST be unique.
53 --
54 Procedure get_next_sequence_number
55 (
56 p_finance_header_id in number
57 ,p_sequence_number in out nocopy number
58 );
59 --
60 -- ----------------------------------------------------------------------------
61 -- |---------------------------< get_date_raised >----------------------------|
62 -- ----------------------------------------------------------------------------
63 --
64 -- PUBLIC
65 -- Description:
66 -- Get a valid date_raised for the finance line.
67 --
68 Procedure get_date_raised
69 (
70 p_finance_header_id in number
71 ,p_date_raised in out nocopy date
72 );
73 --
74 -- ----------------------------------------------------------------------------
75 -- |-----------------------< check_delete_attempt >---------------------------|
76 -- ----------------------------------------------------------------------------
77 --
78 -- PUBLIC
79 -- Description:
80 -- No finance lines may be delated.
81 --
82 Procedure check_delete_attempt
83 (
84 p_finance_header_id in number
85 ,p_finance_line_id in number
86 );
87 --
88 -- ----------------------------------------------------------------------------
89 -- |--------------------------< get_currency_code >---------------------------|
90 -- ----------------------------------------------------------------------------
91 --
92 -- PUBLIC
93 -- Description:
94 --
95 Procedure get_currency_code
96 (
97 p_finance_line_type in varchar2
98 ,p_booking_id in number
99 ,p_booking_deal_id in number
100 ,p_resource_allocation_id in number
101 ,p_resource_booking_id in number
102 ,p_currency_code out nocopy varchar2
103 );
104 -- ----------------------------------------------------------------------------
105 -- |--------------------------< check_currency_code >-------------------------|
106 -- ----------------------------------------------------------------------------
107 --
108 -- PUBLIC
109 -- Description:
110 --
111 Procedure check_currency_code
112 (
113 p_finance_line_type in varchar2
114 ,p_finance_header_id in number
115 ,p_booking_id in number
116 ,p_booking_deal_id in number
117 ,p_resource_allocation_id in number
118 ,p_resource_booking_id in number
119 );
120 --
121 -- ----------------------------------------------------------------------------
122 -- |---------------------< check_type_constraints >---------------------------|
123 -- ----------------------------------------------------------------------------
124 --
125 -- PUBLIC
126 -- Description:
127 --
128 procedure check_type_constraints (
129 p_finance_line_type in varchar2
130 ,p_finance_header_id in number
131 ,p_booking_id in number
132 ,p_booking_deal_id in number
133 ,p_resource_booking_id in number
134 ,p_resource_allocation_id in number
135 );
136 --
137 -- ----------------------------------------------------------------------------
138 -- |---------------------< check_type_and_amounts >----------------------|
139 -- ----------------------------------------------------------------------------
140 --
141 -- Description:
142 --
143 Procedure check_type_and_amounts
144 (
145 p_finance_line_type in varchar2
146 ,p_standard_amount in number
147 ,p_money_amount in number
148 ,p_unitary_amount in number
149 ,p_booking_deal_id in number
150 ,p_finance_header_id in number
151 );
152 -- ---------------------------------------------------------------------------
153 -- ---------------------------------------------------------------------------
154 -- |--------------------< check_unique_finance_line >-----------------------|
155 -- ---------------------------------------------------------------------------
156 --
157 -- PUBLIC
158 -- Description:
159 --
160 procedure check_unique_finance_line
161 (p_finance_line_id in number
162 ,p_line_type in varchar2
163 ,p_booking_id in number
164 ,p_resource_booking_id in number
165 ,p_resource_allocation_id in number);
166 -- ---------------------------------------------------------------------------
167 -- ---------------------------------------------------------------------------
168 -- |--------------------< get_finance_header >-----------------------------|
169 -- ---------------------------------------------------------------------------
170 --
171 procedure get_finance_header
172 (p_finance_header_id in number
173 ,p_tfh_type in out nocopy varchar2
174 ,p_customer_id in out nocopy number
175 ,p_vendor_id in out nocopy number
176 ,p_tfh_receivable_type in out nocopy varchar2
177 ,p_tfh_transfer_status in out nocopy varchar2
178 ,p_tfh_superseded_flag in out nocopy varchar2
179 ,p_tfh_cancelled_flag in out nocopy varchar2);
180 --
181 -- ---------------------------------------------------------------------------
182 -- |--------------------< check_finance_header >---------------------------|
183 -- ---------------------------------------------------------------------------
184 procedure check_finance_header(p_type in varchar2
185 ,p_superseded_flag in varchar2
186 ,p_transfer_status in varchar2
187 ,p_cancelled_flag in varchar2
188 ,p_check_cancelled_flag in boolean
189 ,p_check_successful_transfer in boolean);
190 end ota_tfl_api_business_rules;