1 Package ota_tfl_api_business_rules2 AUTHID CURRENT_USER as
2 /* $Header: ottfl03t.pkh 115.3 2002/11/29 09:24:50 arkashya ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< set_all_amounts >---------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- PUBLIC
9 -- Description:
10 --
11 -- Set the AMOUNTS standard_amount, money_amount and unitary_amount
12 -- depending on the finance_line type and the booking deal type.
13 --
14 Procedure set_all_amounts
15 (
16 p_finance_line_type in varchar2
17 ,p_activity_version_id in number
18 ,p_event_id in number
19 ,p_price_basis in varchar2 default null
20 ,p_booking_id in number
21 ,p_number_of_places in number default 1
22 ,p_booking_deal_id in number
23 ,p_resource_allocation_id in number
24 ,p_resource_booking_id in number
25 ,p_currency_code in varchar2
26 ,p_standard_amount in out nocopy number
27 ,p_money_amount in out nocopy number
28 ,p_unitary_amount in out nocopy number
29 );
30 --
31 -- ----------------------------------------------------------------------------
32 -- |-----------------------< copy_lines_to_new_header >-----------------------|
33 -- ----------------------------------------------------------------------------
34 --
35 -- PUBLIC
36 -- Description:
37 -- A procedure is required to copy all finance lines from one finance
38 -- header to another. Only those lines with a cancelled_flag = 'N'
39 -- will be copied.
40 --
41 Procedure copy_lines_to_new_header
42 (
43 p_finance_header_id_from in number
44 ,p_finance_header_id_to in number
45 );
46 --
47 -- ----------------------------------------------------------------------------
48 -- |----------------------< set_cancel_flag_for_header>-----------------------|
49 -- ----------------------------------------------------------------------------
50 --
51 -- PUBLIC
52 -- Description:
53 -- A procedure is required to call the cancellation or
54 -- uncalleation procedure for
55 -- each finance line defined for a given finance header.
56 --
57 Procedure set_cancel_flag_for_header
58 (
59 p_finance_header_id in number
60 ,p_new_cancelled_flag in varchar2
61 );
62 --
63 -- ----------------------------------------------------------------------------
64 -- |------------------------< cancel_finance_line >---------------------------|
65 -- ----------------------------------------------------------------------------
66 --
67 -- PUBLIC
68 -- Description:
69 -- A procedure is required to set the attribute cancelled_flag to 'Y'.
70 --
71 Procedure cancel_finance_line
72 (
73 p_finance_line_id in number
74 ,p_cancelled_flag in out nocopy varchar2
75 ,p_transfer_status in varchar2
76 ,p_finance_header_id in number
77 ,p_validate in boolean
78 ,p_commit in boolean default FALSE
79 );
80 --
81 -- ----------------------------------------------------------------------------
82 -- |------------------------< cancel_finance_line >---------------------------|
83 -- ----------------------------------------------------------------------------
84 --
85 -- PUBLIC
86 -- Description:
87 -- A procedure is required to set the attribute cancelled_flag to 'Y'.
88 --
89 Procedure cancel_finance_line
90 (
91 p_finance_line_id in number
92 ,p_cancelled_flag in out nocopy varchar2
93 ,p_transfer_status in varchar2
94 ,p_finance_header_id in number
95 ,p_object_version_number in out nocopy number
96 ,p_validate in boolean
97 ,p_commit in boolean default FALSE
98 );
99 --
100 -- ----------------------------------------------------------------------------
101 -- |------------------------< recancel_finance_line >-------------------------|
102 -- ----------------------------------------------------------------------------
103 --
104 -- PUBLIC
105 -- Description:
106 -- A procedure is required to set the attribute cancelled_flag to 'N'.
107 --
108 Procedure recancel_finance_line
109 (
110 p_finance_line_id in number
111 ,p_cancelled_flag in out nocopy varchar2
112 ,p_transfer_status in varchar2
113 ,p_finance_header_id in number
114 ,p_validate in boolean
115 ,p_commit in boolean default FALSE
116 );
117 --
118 -- ----------------------------------------------------------------------------
119 -- |------------------------< change_line_for_header >------------------------|
120 -- ----------------------------------------------------------------------------
121 --
122 -- PUBLIC
123 -- Description:
124 -- A procedure is required to set the attribute transfer_status to the same
125 -- as the header when the header has been changed
126 -- This only occurs when the status is th esam eas the old value on the
127 -- header.
128 Procedure change_line_for_header
129 (
130 p_finance_header_id in number
131 ,p_new_transfer_status in varchar2
132 ,p_old_transfer_status in varchar2
133 ,p_include_cancelled in varchar2 default 'N'
134 );
135 --
136 -- ----------------------------------------------------------------------------
137 --
138 end ota_tfl_api_business_rules2;