1 PACKAGE OTA_FINANCE_LINE_BK2 AUTHID CURRENT_USER as
2 /* $Header: ottflapi.pkh 120.5 2006/09/11 10:28:57 niarora noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' OTA_FINANCE_LINE_BK2.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-------------------------< UPDATE_FINANCE_LINE_B >----------------------|
10 -- ----------------------------------------------------------------------------
11 -- {Start Of Comments}
12 --
13 -- Description:
14 --
15 -- Before Process User Hook.
16 --
17 -- {End Of Comments}
18 --
19 procedure Update_FINANCE_LINE_b
20 (
21
22 P_FINANCE_LINE_ID IN NUMBER,
23 P_FINANCE_HEADER_ID IN NUMBER,
24 P_CANCELLED_FLAG IN VARCHAR2,
25 P_DATE_RAISED IN DATE,
26 P_LINE_TYPE IN VARCHAR2,
27 P_SEQUENCE_NUMBER IN NUMBER,
28 P_TRANSFER_STATUS IN VARCHAR2,
29 P_COMMENTS IN VARCHAR2,
30 P_CURRENCY_CODE IN VARCHAR2,
31 P_MONEY_AMOUNT IN NUMBER,
32 P_STANDARD_AMOUNT IN NUMBER,
33 P_TRANS_INFORMATION_CATEGORY IN VARCHAR2,
34 P_TRANS_INFORMATION1 IN VARCHAR2,
35 P_TRANS_INFORMATION10 IN VARCHAR2,
36 P_TRANS_INFORMATION11 IN VARCHAR2,
37 P_TRANS_INFORMATION12 IN VARCHAR2,
38 P_TRANS_INFORMATION13 IN VARCHAR2,
39 P_TRANS_INFORMATION14 IN VARCHAR2,
40 P_TRANS_INFORMATION15 IN VARCHAR2,
41 P_TRANS_INFORMATION16 IN VARCHAR2,
42 P_TRANS_INFORMATION17 IN VARCHAR2,
43 P_TRANS_INFORMATION18 IN VARCHAR2,
44 P_TRANS_INFORMATION19 IN VARCHAR2,
45 P_TRANS_INFORMATION2 IN VARCHAR2,
46 P_TRANS_INFORMATION20 IN VARCHAR2,
47 P_TRANS_INFORMATION3 IN VARCHAR2,
48 P_TRANS_INFORMATION4 IN VARCHAR2,
49 P_TRANS_INFORMATION5 IN VARCHAR2,
50 P_TRANS_INFORMATION6 IN VARCHAR2,
51 P_TRANS_INFORMATION7 IN VARCHAR2,
52 P_TRANS_INFORMATION8 IN VARCHAR2,
53 P_TRANS_INFORMATION9 IN VARCHAR2,
54 P_TRANSFER_DATE IN DATE ,
55 P_TRANSFER_MESSAGE IN VARCHAR2,
56 P_UNITARY_AMOUNT IN NUMBER,
57 P_BOOKING_DEAL_ID IN NUMBER,
58 P_BOOKING_ID IN NUMBER,
59 P_RESOURCE_ALLOCATION_ID IN NUMBER,
60 P_RESOURCE_BOOKING_ID IN NUMBER,
61 P_LAST_UPDATE_DATE IN DATE,
62 P_LAST_UPDATED_BY IN NUMBER,
63 P_LAST_UPDATE_LOGIN IN NUMBER,
64 P_CREATED_BY IN NUMBER,
65 P_CREATION_DATE IN DATE ,
66 P_TFL_INFORMATION_CATEGORY IN VARCHAR2,
67 P_TFL_INFORMATION1 IN VARCHAR2,
68 P_TFL_INFORMATION2 IN VARCHAR2,
69 P_TFL_INFORMATION3 IN VARCHAR2,
70 P_TFL_INFORMATION4 IN VARCHAR2,
71 P_TFL_INFORMATION5 IN VARCHAR2,
72 P_TFL_INFORMATION6 IN VARCHAR2,
73 P_TFL_INFORMATION7 IN VARCHAR2,
74 P_TFL_INFORMATION8 IN VARCHAR2,
75 P_TFL_INFORMATION9 IN VARCHAR2,
76 P_TFL_INFORMATION10 IN VARCHAR2,
77 P_TFL_INFORMATION11 IN VARCHAR2,
78 P_TFL_INFORMATION12 IN VARCHAR2,
79 P_TFL_INFORMATION13 IN VARCHAR2,
80 P_TFL_INFORMATION14 IN VARCHAR2,
81 P_TFL_INFORMATION15 IN VARCHAR2,
82 P_TFL_INFORMATION16 IN VARCHAR2,
83 P_TFL_INFORMATION17 IN VARCHAR2,
84 P_TFL_INFORMATION18 IN VARCHAR2,
85 P_TFL_INFORMATION19 IN VARCHAR2,
86 P_TFL_INFORMATION20 IN VARCHAR2,
87 P_EFFECTIVE_DATE IN DATE
88
89
90 );
91
92 --
93 -- ----------------------------------------------------------------------------
94 -- |-------------------------< UPDATE_FINANCE_LINE_A >------------------------|
95 -- ----------------------------------------------------------------------------
96 -- {Start Of Comments}
97 --
98 -- Description:
99 --
100 -- After Process User Hook.
101 --
102 -- {End Of Comments}
103 --
104 procedure UPDATE_FINANCE_LINE_A
105 (
106
107 P_FINANCE_LINE_ID IN NUMBER,
108 P_FINANCE_HEADER_ID IN NUMBER,
109 P_CANCELLED_FLAG IN VARCHAR2,
110 P_DATE_RAISED IN DATE,
111 P_LINE_TYPE IN VARCHAR2,
112 P_SEQUENCE_NUMBER IN NUMBER,
113 P_TRANSFER_STATUS IN VARCHAR2,
114 P_COMMENTS IN VARCHAR2,
115 P_CURRENCY_CODE IN VARCHAR2,
116 P_MONEY_AMOUNT IN NUMBER,
117 P_STANDARD_AMOUNT IN NUMBER,
118 P_TRANS_INFORMATION_CATEGORY IN VARCHAR2,
119 P_TRANS_INFORMATION1 IN VARCHAR2,
120 P_TRANS_INFORMATION10 IN VARCHAR2,
121 P_TRANS_INFORMATION11 IN VARCHAR2,
122 P_TRANS_INFORMATION12 IN VARCHAR2,
123 P_TRANS_INFORMATION13 IN VARCHAR2,
124 P_TRANS_INFORMATION14 IN VARCHAR2,
125 P_TRANS_INFORMATION15 IN VARCHAR2,
126 P_TRANS_INFORMATION16 IN VARCHAR2,
127 P_TRANS_INFORMATION17 IN VARCHAR2,
128 P_TRANS_INFORMATION18 IN VARCHAR2,
129 P_TRANS_INFORMATION19 IN VARCHAR2,
130 P_TRANS_INFORMATION2 IN VARCHAR2,
131 P_TRANS_INFORMATION20 IN VARCHAR2,
132 P_TRANS_INFORMATION3 IN VARCHAR2,
133 P_TRANS_INFORMATION4 IN VARCHAR2,
134 P_TRANS_INFORMATION5 IN VARCHAR2,
135 P_TRANS_INFORMATION6 IN VARCHAR2,
136 P_TRANS_INFORMATION7 IN VARCHAR2,
137 P_TRANS_INFORMATION8 IN VARCHAR2,
138 P_TRANS_INFORMATION9 IN VARCHAR2,
139 P_TRANSFER_DATE IN DATE ,
140 P_TRANSFER_MESSAGE IN VARCHAR2,
141 P_UNITARY_AMOUNT IN NUMBER,
142 P_BOOKING_DEAL_ID IN NUMBER,
143 P_BOOKING_ID IN NUMBER,
144 P_RESOURCE_ALLOCATION_ID IN NUMBER,
145 P_RESOURCE_BOOKING_ID IN NUMBER,
146 P_LAST_UPDATE_DATE IN DATE,
147 P_LAST_UPDATED_BY IN NUMBER,
148 P_LAST_UPDATE_LOGIN IN NUMBER,
149 P_CREATED_BY IN NUMBER,
150 P_CREATION_DATE IN DATE ,
151 P_TFL_INFORMATION_CATEGORY IN VARCHAR2,
152 P_TFL_INFORMATION1 IN VARCHAR2,
153 P_TFL_INFORMATION2 IN VARCHAR2,
154 P_TFL_INFORMATION3 IN VARCHAR2,
155 P_TFL_INFORMATION4 IN VARCHAR2,
156 P_TFL_INFORMATION5 IN VARCHAR2,
157 P_TFL_INFORMATION6 IN VARCHAR2,
158 P_TFL_INFORMATION7 IN VARCHAR2,
159 P_TFL_INFORMATION8 IN VARCHAR2,
160 P_TFL_INFORMATION9 IN VARCHAR2,
161 P_TFL_INFORMATION10 IN VARCHAR2,
162 P_TFL_INFORMATION11 IN VARCHAR2,
163 P_TFL_INFORMATION12 IN VARCHAR2,
164 P_TFL_INFORMATION13 IN VARCHAR2,
165 P_TFL_INFORMATION14 IN VARCHAR2,
166 P_TFL_INFORMATION15 IN VARCHAR2,
167 P_TFL_INFORMATION16 IN VARCHAR2,
168 P_TFL_INFORMATION17 IN VARCHAR2,
169 P_TFL_INFORMATION18 IN VARCHAR2,
170 P_TFL_INFORMATION19 IN VARCHAR2,
171 P_TFL_INFORMATION20 IN VARCHAR2,
172 P_EFFECTIVE_DATE IN DATE
173 );
174
175 end OTA_FINANCE_LINE_BK2;
[Home] [Help]