[Home] [Help]
PACKAGE: APPS.JTF_FM_INT_REQUEST_PKG
Source
1 PACKAGE Jtf_Fm_Int_Request_Pkg AUTHID CURRENT_USER AS
2 /* $Header: jtffmrqs.pls 120.6 2006/03/15 11:34:44 jakaur noship $*/
3
4 PROCEDURE process_request( request_id NUMBER
5 , x_return_status OUT NOCOPY VARCHAR2
6 , x_msg_count OUT NOCOPY NUMBER
7 , x_msg_data OUT NOCOPY VARCHAR2
8 );
9
10 PROCEDURE update_lines_status_bulk( line_ids IN JTF_VARCHAR2_TABLE_100
11 , request_id IN NUMBER
12 , line_status IN JTF_VARCHAR2_TABLE_100
13 , p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
14 , x_return_status OUT NOCOPY VARCHAR2
15 , x_msg_count OUT NOCOPY NUMBER
16 , x_msg_data OUT NOCOPY VARCHAR2
17 ) ;
18
19 PROCEDURE update_lines_status( line_ids IN JTF_VARCHAR2_TABLE_100
20 , request_id IN NUMBER
21 , line_status IN VARCHAR2
22 , p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
23 , x_return_status OUT NOCOPY VARCHAR2
24 , x_msg_count OUT NOCOPY NUMBER
25 , x_msg_data OUT NOCOPY VARCHAR2
26 ) ;
27
28 PROCEDURE clean_up_instance( p_request_id IN NUMBER
29 , p_server_id IN NUMBER
30 , p_instance_id IN NUMBER
31 , p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
32 , x_return_status OUT NOCOPY VARCHAR2
33 , x_msg_count OUT NOCOPY NUMBER
34 , x_msg_data OUT NOCOPY VARCHAR2
35 ) ;
36
37 TYPE request_lines_rec IS TABLE OF JTF_FM_INT_REQUEST_LINES%ROWTYPE
38 INDEX BY PLS_INTEGER;
39
40 PROCEDURE get_next_request( p_server_id IN NUMBER
41 , p_instance_id IN NUMBER
42 , p_REQUEST_ID OUT NOCOPY NUMBER
43 , p_template_id OUT NOCOPY NUMBER
44 , p_NO_OF_PARAMETERS OUT NOCOPY NUMBER
45 , p_EMAIL_FORMAT OUT NOCOPY VARCHAR2
46 , p_EMAIL_FROM_ADDRESS OUT NOCOPY VARCHAR2
47 , p_EMAIL_REPLY_TO_ADDRESS OUT NOCOPY VARCHAR2
48 , p_sender_display_name OUT NOCOPY VARCHAR2
49 , p_subject OUT NOCOPY VARCHAR2
50 , p_parameter_table OUT NOCOPY JTF_VARCHAR2_TABLE_100
51 , x_return_status OUT NOCOPY VARCHAR2
52 , x_msg_count OUT NOCOPY NUMBER
53 , x_msg_data OUT NOCOPY VARCHAR2
54 ) ;
55
56 PROCEDURE update_instance_status( p_REQUEST_ID IN NUMBER
57 , p_server_id IN NUMBER
58 , p_instance_id IN NUMBER
59 , p_status IN VARCHAR2
60 , P_COMMIT IN VARCHAR2 := Fnd_Api.G_FALSE
61 , x_return_status OUT NOCOPY VARCHAR2
62 , x_msg_count OUT NOCOPY NUMBER
63 , x_msg_data OUT NOCOPY VARCHAR2
64 ) ;
65
66 PROCEDURE get_next_batch ( p_REQUEST_ID IN NUMBER
67 , p_server_id IN NUMBER
68 , p_instance_id IN NUMBER
69 , P_COMMIT IN VARCHAR2 := Fnd_Api.G_FALSE
70 , p_line_ids OUT NOCOPY JTF_NUMBER_TABLE
71 , p_PARTY_ID OUT NOCOPY JTF_NUMBER_TABLE
72 , p_PARTY_NAME OUT NOCOPY JTF_VARCHAR2_TABLE_200
73 , p_EMAIL_ADDRESS OUT NOCOPY JTF_VARCHAR2_TABLE_200
74 , p_COL1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
75 , p_COL2 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
76 , p_COL3 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
77 , p_COL4 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
78 , p_COL5 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
79 , p_COL6 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
80 , p_COL7 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
81 , p_COL8 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
82 , p_COL9 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
83 , p_COL10 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
84 , p_COL11 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
85 , p_COL12 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
86 , p_COL13 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
87 , p_COL14 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
88 , p_COL15 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
89 , p_COL16 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
90 , p_COL17 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
91 , p_COL18 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
92 , p_COL19 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
93 , p_COL20 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
94 , p_COL21 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
95 , p_COL22 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
96 , p_COL23 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
97 , p_COL24 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
98 , p_COL25 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
99 , p_COL26 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
100 , p_COL27 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
101 , p_COL28 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
102 , p_COL29 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
103 , p_COL30 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
104 , p_COL31 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
105 , p_COL32 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
106 , p_COL33 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
107 , p_COL34 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
108 , p_COL35 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
109 , p_COL36 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
110 , p_COL37 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
111 , p_COL38 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
112 , p_COL39 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
113 , p_COL40 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
114 , p_COL41 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
115 , p_COL42 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
116 , p_COL43 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
117 , p_COL44 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
118 , p_COL45 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
119 , p_COL46 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
120 , p_COL47 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
121 , p_COL48 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
122 , p_COL49 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
123 , p_COL50 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
124 , p_COL51 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
125 , p_COL52 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
126 , p_COL53 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
127 , p_COL54 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
128 , p_COL55 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
129 , p_COL56 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
130 , p_COL57 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
131 , p_COL58 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
132 , p_COL59 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
133 , p_COL60 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
134 , p_COL61 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
135 , p_COL62 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
136 , p_COL63 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
137 , p_COL64 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
138 , p_COL65 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
139 , p_COL66 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
140 , p_COL67 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
141 , p_COL68 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
142 , p_COL69 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
143 , p_COL70 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
144 , p_COL71 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
145 , p_COL72 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
146 , p_COL73 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
147 , p_COL74 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
148 , p_COL75 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
149 , p_COL76 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
150 , p_COL77 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
151 , p_COL78 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
152 , p_COL79 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
153 , p_COL80 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
154 , p_COL81 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
155 , p_COL82 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
156 , p_COL83 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
157 , p_COL84 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
158 , p_COL85 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
159 , p_COL86 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
160 , p_COL87 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
161 , p_COL88 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
162 , p_COL89 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
163 , p_COL90 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
164 , p_COL91 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
165 , p_COL92 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
166 , p_COL93 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
167 , p_COL94 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
168 , p_COL95 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
169 , p_COL96 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
170 , p_COL97 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
171 , p_COL98 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
172 , p_COL99 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
173 , p_COL100 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
174 , x_no_of_rows OUT NOCOPY NUMBER
175 , x_return_status OUT NOCOPY VARCHAR2
176 , x_msg_count OUT NOCOPY NUMBER
177 , x_msg_data OUT NOCOPY VARCHAR2) ;
178
179
180 PROCEDURE move_request( p_request_id NUMBER
181 , x_log_interaction OUT NOCOPY VARCHAR2
182 , x_return_status OUT NOCOPY VARCHAR2
183 , x_msg_count OUT NOCOPY NUMBER
184 , x_msg_data OUT NOCOPY VARCHAR2
185 ) ;
186 END Jtf_Fm_Int_Request_Pkg ;