[Home] [Help]
PACKAGE: APPS.JTF_FM_REQUEST_GRP_W
Source
1 package jtf_fm_request_grp_w AUTHID CURRENT_USER as
2 /* $Header: jtfgfmws.pls 120.2 2005/12/27 00:34 anchaudh ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy jtf_fm_request_grp.g_varchar_tbl_type, a0 JTF_VARCHAR2_TABLE_1000);
4 procedure rosetta_table_copy_out_p3(t jtf_fm_request_grp.g_varchar_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_1000);
5
6 procedure rosetta_table_copy_in_p5(t out nocopy jtf_fm_request_grp.g_number_tbl_type, a0 JTF_NUMBER_TABLE);
7 procedure rosetta_table_copy_out_p5(t jtf_fm_request_grp.g_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
8
9 procedure get_content_xml(p_api_version NUMBER
10 , p_init_msg_list VARCHAR2
11 , p_commit VARCHAR2
12 , p_validation_level NUMBER
13 , x_return_status out nocopy VARCHAR2
14 , x_msg_count out nocopy NUMBER
15 , x_msg_data out nocopy VARCHAR2
16 , p_content_id NUMBER
17 , p_content_nm VARCHAR2
18 , p_document_type VARCHAR2
19 , p_quantity NUMBER
20 , p_media_type VARCHAR2
21 , p_printer VARCHAR2
22 , p_email VARCHAR2
23 , p_fax VARCHAR2
24 , p_file_path VARCHAR2
25 , p_user_note VARCHAR2
26 , p_content_type VARCHAR2
27 , p_bind_var JTF_VARCHAR2_TABLE_1000
28 , p_bind_val JTF_VARCHAR2_TABLE_1000
29 , p_bind_var_type JTF_VARCHAR2_TABLE_1000
30 , p_request_id NUMBER
31 , x_content_xml out nocopy VARCHAR2
32 );
33 procedure get_content_xml(p_api_version NUMBER
34 , p_init_msg_list VARCHAR2
35 , p_commit VARCHAR2
36 , p_validation_level NUMBER
37 , x_return_status out nocopy VARCHAR2
38 , x_msg_count out nocopy NUMBER
39 , x_msg_data out nocopy VARCHAR2
40 , p_content_id NUMBER
41 , p_content_nm VARCHAR2
42 , p_document_type VARCHAR2
43 , p_quantity NUMBER
44 , p_media_type VARCHAR2
45 , p_printer VARCHAR2
46 , p_email VARCHAR2
47 , p_fax VARCHAR2
48 , p_file_path VARCHAR2
49 , p_user_note VARCHAR2
50 , p_content_type VARCHAR2
51 , p_bind_var JTF_VARCHAR2_TABLE_1000
52 , p_bind_val JTF_VARCHAR2_TABLE_1000
53 , p_bind_var_type JTF_VARCHAR2_TABLE_1000
54 , p_request_id NUMBER
55 , x_content_xml out nocopy VARCHAR2
56 , p_content_source VARCHAR2
57 , p_version NUMBER
58 );
59 procedure cancel_request(p_api_version NUMBER
60 , p_init_msg_list VARCHAR2
61 , p_commit VARCHAR2
62 , p_validation_level NUMBER
63 , x_return_status out nocopy VARCHAR2
64 , x_msg_count out nocopy NUMBER
65 , x_msg_data out nocopy VARCHAR2
66 , p_request_id NUMBER
67 , p_submit_dt_tm date
68 );
69 procedure get_multiple_content_xml(p_api_version NUMBER
70 , p_init_msg_list VARCHAR2
71 , p_commit VARCHAR2
72 , p_validation_level NUMBER
73 , x_return_status out nocopy VARCHAR2
74 , x_msg_count out nocopy NUMBER
75 , x_msg_data out nocopy VARCHAR2
76 , p_request_id NUMBER
77 , p_content_type JTF_VARCHAR2_TABLE_1000
78 , p_content_id JTF_NUMBER_TABLE
79 , p_content_nm JTF_VARCHAR2_TABLE_1000
80 , p_document_type JTF_VARCHAR2_TABLE_1000
81 , p_media_type JTF_VARCHAR2_TABLE_1000
82 , p_printer JTF_VARCHAR2_TABLE_1000
83 , p_email JTF_VARCHAR2_TABLE_1000
84 , p_fax JTF_VARCHAR2_TABLE_1000
85 , p_file_path JTF_VARCHAR2_TABLE_1000
86 , p_user_note JTF_VARCHAR2_TABLE_1000
87 , p_quantity JTF_NUMBER_TABLE
88 , x_content_xml out nocopy VARCHAR2
89 );
90 procedure submit_batch_request(p_api_version NUMBER
91 , p_init_msg_list VARCHAR2
92 , p_commit VARCHAR2
93 , p_validation_level NUMBER
94 , x_return_status out nocopy VARCHAR2
95 , x_msg_count out nocopy NUMBER
96 , x_msg_data out nocopy VARCHAR2
97 , p_template_id NUMBER
98 , p_subject VARCHAR2
99 , p_user_id NUMBER
100 , p_source_code_id NUMBER
101 , p_source_code VARCHAR2
102 , p_object_type VARCHAR2
103 , p_object_id NUMBER
104 , p_order_id NUMBER
105 , p_doc_id NUMBER
106 , p_doc_ref VARCHAR2
107 , p_list_type VARCHAR2
108 , p_view_nm VARCHAR2
109 , p_party_id JTF_NUMBER_TABLE
110 , p_party_name JTF_VARCHAR2_TABLE_1000
111 , p_printer JTF_VARCHAR2_TABLE_1000
112 , p_email JTF_VARCHAR2_TABLE_1000
113 , p_fax JTF_VARCHAR2_TABLE_1000
114 , p_file_path JTF_VARCHAR2_TABLE_1000
115 , p_server_id NUMBER
116 , p_queue_response VARCHAR2
117 , p_extended_header VARCHAR2
118 , p_content_xml VARCHAR2
119 , p_request_id NUMBER
120 , p_per_user_history VARCHAR2
121 );
122 procedure submit_mass_request(p_api_version NUMBER
123 , p_init_msg_list VARCHAR2
124 , p_commit VARCHAR2
125 , p_validation_level NUMBER
126 , x_return_status out nocopy VARCHAR2
127 , x_msg_count out nocopy NUMBER
128 , x_msg_data out nocopy VARCHAR2
129 , p_template_id NUMBER
130 , p_subject VARCHAR2
131 , p_user_id NUMBER
132 , p_source_code_id NUMBER
133 , p_source_code VARCHAR2
134 , p_object_type VARCHAR2
135 , p_object_id NUMBER
136 , p_order_id NUMBER
137 , p_doc_id NUMBER
138 , p_doc_ref VARCHAR2
139 , p_list_type VARCHAR2
140 , p_view_nm VARCHAR2
141 , p_server_id NUMBER
142 , p_queue_response VARCHAR2
143 , p_extended_header VARCHAR2
144 , p_content_xml VARCHAR2
145 , p_request_id NUMBER
146 , p_per_user_history VARCHAR2
147 , p_mass_query_id NUMBER
148 , p_mass_bind_var JTF_VARCHAR2_TABLE_1000
149 , p_mass_bind_var_type JTF_VARCHAR2_TABLE_1000
150 , p_mass_bind_val JTF_VARCHAR2_TABLE_1000
151 );
152 procedure new_cancel_request(p_api_version NUMBER
153 , p_init_msg_list VARCHAR2
154 , p_commit VARCHAR2
155 , p_validation_level NUMBER
156 , x_return_status out nocopy VARCHAR2
157 , x_msg_count out nocopy NUMBER
158 , x_msg_data out nocopy VARCHAR2
159 , p_request_id NUMBER
160 , p_submit_dt_tm date
161 );
162 procedure correct_malformed(p_api_version NUMBER
163 , p_init_msg_list VARCHAR2
164 , p_commit VARCHAR2
165 , p_validation_level NUMBER
166 , x_msg_count out nocopy NUMBER
167 , x_msg_data out nocopy VARCHAR2
168 , p_request_id NUMBER
169 , p_job JTF_NUMBER_TABLE
170 , p_corrected_address JTF_VARCHAR2_TABLE_1000
171 , x_return_status out nocopy VARCHAR2
172 );
173 procedure resubmit_malformed(p_api_version NUMBER
174 , p_init_msg_list VARCHAR2
175 , p_commit VARCHAR2
176 , p_validation_level NUMBER
177 , x_msg_count out nocopy NUMBER
178 , x_msg_data out nocopy VARCHAR2
179 , p_request_id NUMBER
180 , x_request_id out nocopy JTF_NUMBER_TABLE
181 , x_return_status out nocopy VARCHAR2
182 );
183 end jtf_fm_request_grp_w;