8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_realloc_txn_dtl >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_realloc_txn_dtl
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_transaction_id in number
15: ,p_transaction_type in varchar2
16: ,p_entity_id in number default null
43: --
44: -- Convert constant values to their corresponding boolean value
45: --
46: l_validate :=
47: hr_api.constant_to_boolean
48: (p_constant_value => p_validate);
49: --
50: -- Register Surrogate ID or user key values
51: --
116: -- ----------------------------------------------------------------------------
117: -- |-----------------------< create_realloc_txn_period >----------------------|
118: -- ----------------------------------------------------------------------------
119: PROCEDURE create_realloc_txn_period
120: (p_validate in number default hr_api.g_false_num
121: ,p_effective_date in date
122: ,p_txn_detail_id in number
123: ,p_transaction_type in varchar2
124: ,p_entity_id in number default null
155: --
156: -- Convert constant values to their corresponding boolean value
157: --
158: l_validate :=
159: hr_api.constant_to_boolean
160: (p_constant_value => p_validate);
161: --
162: -- Register Surrogate ID or user key values
163: --
232: -- ----------------------------------------------------------------------------
233: -- |------------------------< delete_realloc_txn_dtl >------------------------|
234: -- ----------------------------------------------------------------------------
235: PROCEDURE delete_realloc_txn_dtl
236: (p_validate in number default hr_api.g_false_num
237: ,p_txn_detail_id in number
238: ,p_object_version_number in number
239: ,p_return_status out nocopy varchar2
240: ) is
262: --
263: -- Convert constant values to their corresponding boolean value
264: --
265: l_validate :=
266: hr_api.constant_to_boolean
267: (p_constant_value => p_validate);
268: --
269: -- Register Surrogate ID or user key values
270: --
326: -- ----------------------------------------------------------------------------
327: -- |-----------------------< delete_realloc_txn_period >----------------------|
328: -- ----------------------------------------------------------------------------
329: PROCEDURE delete_realloc_txn_period
330: (p_validate in number default hr_api.g_false_num
331: ,p_reallocation_period_id in number
332: ,p_object_version_number in number
333: ,p_return_status out nocopy varchar2
334: ) is
356: --
357: -- Convert constant values to their corresponding boolean value
358: --
359: l_validate :=
360: hr_api.constant_to_boolean
361: (p_constant_value => p_validate);
362: --
363: -- Register Surrogate ID or user key values
364: --
420: -- ----------------------------------------------------------------------------
421: -- |------------------------< update_realloc_txn_dtl >------------------------|
422: -- ----------------------------------------------------------------------------
423: PROCEDURE update_realloc_txn_dtl
424: (p_validate in number default hr_api.g_false_num
425: ,p_effective_date in date
426: ,p_transaction_id in number default hr_api.g_number
427: ,p_transaction_type in varchar2 default hr_api.g_varchar2
428: ,p_entity_id in number default hr_api.g_number
422: -- ----------------------------------------------------------------------------
423: PROCEDURE update_realloc_txn_dtl
424: (p_validate in number default hr_api.g_false_num
425: ,p_effective_date in date
426: ,p_transaction_id in number default hr_api.g_number
427: ,p_transaction_type in varchar2 default hr_api.g_varchar2
428: ,p_entity_id in number default hr_api.g_number
429: ,p_budget_detail_id in number default hr_api.g_number
430: ,p_txn_detail_id in number
423: PROCEDURE update_realloc_txn_dtl
424: (p_validate in number default hr_api.g_false_num
425: ,p_effective_date in date
426: ,p_transaction_id in number default hr_api.g_number
427: ,p_transaction_type in varchar2 default hr_api.g_varchar2
428: ,p_entity_id in number default hr_api.g_number
429: ,p_budget_detail_id in number default hr_api.g_number
430: ,p_txn_detail_id in number
431: ,p_object_version_number in out nocopy number
424: (p_validate in number default hr_api.g_false_num
425: ,p_effective_date in date
426: ,p_transaction_id in number default hr_api.g_number
427: ,p_transaction_type in varchar2 default hr_api.g_varchar2
428: ,p_entity_id in number default hr_api.g_number
429: ,p_budget_detail_id in number default hr_api.g_number
430: ,p_txn_detail_id in number
431: ,p_object_version_number in out nocopy number
432: ,p_return_status out nocopy varchar2
425: ,p_effective_date in date
426: ,p_transaction_id in number default hr_api.g_number
427: ,p_transaction_type in varchar2 default hr_api.g_varchar2
428: ,p_entity_id in number default hr_api.g_number
429: ,p_budget_detail_id in number default hr_api.g_number
430: ,p_txn_detail_id in number
431: ,p_object_version_number in out nocopy number
432: ,p_return_status out nocopy varchar2
433: ) is
457: --
458: -- Convert constant values to their corresponding boolean value
459: --
460: l_validate :=
461: hr_api.constant_to_boolean
462: (p_constant_value => p_validate);
463: --
464: -- Register Surrogate ID or user key values
465: --
528: -- ----------------------------------------------------------------------------
529: -- |-----------------------< update_realloc_txn_period >----------------------|
530: -- ----------------------------------------------------------------------------
531: PROCEDURE update_realloc_txn_period
532: (p_validate in number default hr_api.g_false_num
533: ,p_effective_date in date
534: ,p_txn_detail_id in number default hr_api.g_number
535: ,p_transaction_type in varchar2 default hr_api.g_varchar2
536: ,p_entity_id in number default hr_api.g_number
530: -- ----------------------------------------------------------------------------
531: PROCEDURE update_realloc_txn_period
532: (p_validate in number default hr_api.g_false_num
533: ,p_effective_date in date
534: ,p_txn_detail_id in number default hr_api.g_number
535: ,p_transaction_type in varchar2 default hr_api.g_varchar2
536: ,p_entity_id in number default hr_api.g_number
537: ,p_budget_period_id in number default hr_api.g_number
538: ,p_start_date in date default hr_api.g_date
531: PROCEDURE update_realloc_txn_period
532: (p_validate in number default hr_api.g_false_num
533: ,p_effective_date in date
534: ,p_txn_detail_id in number default hr_api.g_number
535: ,p_transaction_type in varchar2 default hr_api.g_varchar2
536: ,p_entity_id in number default hr_api.g_number
537: ,p_budget_period_id in number default hr_api.g_number
538: ,p_start_date in date default hr_api.g_date
539: ,p_end_date in date default hr_api.g_date
532: (p_validate in number default hr_api.g_false_num
533: ,p_effective_date in date
534: ,p_txn_detail_id in number default hr_api.g_number
535: ,p_transaction_type in varchar2 default hr_api.g_varchar2
536: ,p_entity_id in number default hr_api.g_number
537: ,p_budget_period_id in number default hr_api.g_number
538: ,p_start_date in date default hr_api.g_date
539: ,p_end_date in date default hr_api.g_date
540: ,p_reallocation_amt in number default hr_api.g_number
533: ,p_effective_date in date
534: ,p_txn_detail_id in number default hr_api.g_number
535: ,p_transaction_type in varchar2 default hr_api.g_varchar2
536: ,p_entity_id in number default hr_api.g_number
537: ,p_budget_period_id in number default hr_api.g_number
538: ,p_start_date in date default hr_api.g_date
539: ,p_end_date in date default hr_api.g_date
540: ,p_reallocation_amt in number default hr_api.g_number
541: ,p_reserved_amt in number default hr_api.g_number
534: ,p_txn_detail_id in number default hr_api.g_number
535: ,p_transaction_type in varchar2 default hr_api.g_varchar2
536: ,p_entity_id in number default hr_api.g_number
537: ,p_budget_period_id in number default hr_api.g_number
538: ,p_start_date in date default hr_api.g_date
539: ,p_end_date in date default hr_api.g_date
540: ,p_reallocation_amt in number default hr_api.g_number
541: ,p_reserved_amt in number default hr_api.g_number
542: ,p_reallocation_period_id in number
535: ,p_transaction_type in varchar2 default hr_api.g_varchar2
536: ,p_entity_id in number default hr_api.g_number
537: ,p_budget_period_id in number default hr_api.g_number
538: ,p_start_date in date default hr_api.g_date
539: ,p_end_date in date default hr_api.g_date
540: ,p_reallocation_amt in number default hr_api.g_number
541: ,p_reserved_amt in number default hr_api.g_number
542: ,p_reallocation_period_id in number
543: ,p_object_version_number in out nocopy number
536: ,p_entity_id in number default hr_api.g_number
537: ,p_budget_period_id in number default hr_api.g_number
538: ,p_start_date in date default hr_api.g_date
539: ,p_end_date in date default hr_api.g_date
540: ,p_reallocation_amt in number default hr_api.g_number
541: ,p_reserved_amt in number default hr_api.g_number
542: ,p_reallocation_period_id in number
543: ,p_object_version_number in out nocopy number
544: ,p_return_status out nocopy varchar2
537: ,p_budget_period_id in number default hr_api.g_number
538: ,p_start_date in date default hr_api.g_date
539: ,p_end_date in date default hr_api.g_date
540: ,p_reallocation_amt in number default hr_api.g_number
541: ,p_reserved_amt in number default hr_api.g_number
542: ,p_reallocation_period_id in number
543: ,p_object_version_number in out nocopy number
544: ,p_return_status out nocopy varchar2
545: ) is
569: --
570: -- Convert constant values to their corresponding boolean value
571: --
572: l_validate :=
573: hr_api.constant_to_boolean
574: (p_constant_value => p_validate);
575: --
576: -- Register Surrogate ID or user key values
577: --