DBA Data[Home] [Help]

APPS.OTA_TFL_API_BUS dependencies on OTA_TFL_API_SHD

Line 13: Procedure insert_validate( p_rec in out nocopy ota_tfl_api_shd.g_rec_type

9: --
10: -- ----------------------------------------------------------------------------
11: -- |---------------------------< insert_validate >----------------------------|
12: -- ----------------------------------------------------------------------------
13: Procedure insert_validate( p_rec in out nocopy ota_tfl_api_shd.g_rec_type
14: , p_transaction_type in varchar2) is
15:
16: --
17: l_proc varchar2(72) := g_package||'insert_validate';

Line 117: Procedure update_validate( p_rec in out nocopy ota_tfl_api_shd.g_rec_type

113: --
114: -- ----------------------------------------------------------------------------
115: -- |---------------------------< update_validate >----------------------------|
116: -- ----------------------------------------------------------------------------
117: Procedure update_validate( p_rec in out nocopy ota_tfl_api_shd.g_rec_type
118: , p_money_amount in out nocopy number
119: , p_unitary_amount in out nocopy number
120: , p_date_raised in out nocopy date
121: , p_sequence_number in out nocopy number

Line 127: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.finance_header_id

123: --
124: l_proc varchar2(72) := g_package||'update_validate';
125: --
126: l_finance_header_id_changed boolean
127: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.finance_header_id
128: , p_rec.finance_header_id );
129: --
130: l_line_type_changed boolean
131: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.line_type

Line 131: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.line_type

127: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.finance_header_id
128: , p_rec.finance_header_id );
129: --
130: l_line_type_changed boolean
131: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.line_type
132: , p_rec.line_type );
133: --
134: l_cancelled_flag_changed boolean
135: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.cancelled_flag

Line 135: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.cancelled_flag

131: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.line_type
132: , p_rec.line_type );
133: --
134: l_cancelled_flag_changed boolean
135: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.cancelled_flag
136: , p_rec.cancelled_flag );
137: --
138: l_date_raised_changed boolean
139: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.date_raised

Line 139: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.date_raised

135: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.cancelled_flag
136: , p_rec.cancelled_flag );
137: --
138: l_date_raised_changed boolean
139: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.date_raised
140: , p_rec.date_raised );
141: --
142: l_sequence_number_changed boolean
143: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.sequence_number

Line 143: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.sequence_number

139: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.date_raised
140: , p_rec.date_raised );
141: --
142: l_sequence_number_changed boolean
143: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.sequence_number
144: , p_rec.sequence_number );
145: --
146: l_transfer_status_changed boolean
147: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.transfer_status

Line 147: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.transfer_status

143: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.sequence_number
144: , p_rec.sequence_number );
145: --
146: l_transfer_status_changed boolean
147: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.transfer_status
148: , p_rec.transfer_status );
149: --
150: l_booking_deal_id_changed boolean
151: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.booking_deal_id

Line 151: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.booking_deal_id

147: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.transfer_status
148: , p_rec.transfer_status );
149: --
150: l_booking_deal_id_changed boolean
151: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.booking_deal_id
152: , p_rec.booking_deal_id );
153: --
154: l_resource_booking_id_changed boolean
155: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.resource_booking_id

Line 155: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.resource_booking_id

151: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.booking_deal_id
152: , p_rec.booking_deal_id );
153: --
154: l_resource_booking_id_changed boolean
155: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.resource_booking_id
156: , p_rec.resource_booking_id );
157: --
158: l_resource_alloc_id_changed boolean
159: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.resource_allocation_id

Line 159: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.resource_allocation_id

155: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.resource_booking_id
156: , p_rec.resource_booking_id );
157: --
158: l_resource_alloc_id_changed boolean
159: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.resource_allocation_id
160: , p_rec.resource_allocation_id );
161: --
162: l_booking_id_changed boolean
163: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.booking_id

Line 163: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.booking_id

159: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.resource_allocation_id
160: , p_rec.resource_allocation_id );
161: --
162: l_booking_id_changed boolean
163: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.booking_id
164: , p_rec.booking_id );
165: --
166: l_standard_amount_changed boolean
167: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.standard_amount

Line 167: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.standard_amount

163: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.booking_id
164: , p_rec.booking_id );
165: --
166: l_standard_amount_changed boolean
167: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.standard_amount
168: , p_rec.standard_amount );
169: --
170: l_money_amount_changed boolean
171: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.money_amount

Line 171: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.money_amount

167: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.standard_amount
168: , p_rec.standard_amount );
169: --
170: l_money_amount_changed boolean
171: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.money_amount
172: , p_rec.money_amount );
173: --
174: l_unitary_amount_changed boolean
175: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.unitary_amount

Line 175: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.unitary_amount

171: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.money_amount
172: , p_rec.money_amount );
173: --
174: l_unitary_amount_changed boolean
175: := ota_general.value_changed( ota_tfl_api_shd.g_old_rec.unitary_amount
176: , p_rec.unitary_amount );
177: --
178: l_tfh_type varchar2(30);
179: l_tfh_customer_id number;

Line 353: Procedure delete_validate(p_rec in ota_tfl_api_shd.g_rec_type) is

349: --
350: -- ----------------------------------------------------------------------------
351: -- |---------------------------< delete_validate >----------------------------|
352: -- ----------------------------------------------------------------------------
353: Procedure delete_validate(p_rec in ota_tfl_api_shd.g_rec_type) is
354: --
355: l_proc varchar2(72) := g_package||'delete_validate';
356: --
357: Begin

Line 363: if ota_tfl_api_shd.g_old_rec.transfer_status = 'ST' then

359: --
360: -- Call all supporting business operations
361: -- Do Not allow deletion if Finance Line Transfer_status = 'ST'
362: --
363: if ota_tfl_api_shd.g_old_rec.transfer_status = 'ST' then
364: fnd_message.set_name('OTA','OTA_13610_TFL_DELETE_CHK');
365: fnd_message.raise_error;
366: end if;
367: --