34:
35: PROCEDURE Start_Request
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
35: PROCEDURE Start_Request
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: x_request_id OUT NOCOPY NUMBER
79:
80: PROCEDURE Get_Content_XML
81: (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
80: PROCEDURE Get_Content_XML
81: (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
81: (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_content_id IN NUMBER,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_content_id IN NUMBER,
90: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
92: p_quantity IN NUMBER := 1,
93: p_media_type IN VARCHAR2,
94: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_content_id IN NUMBER,
90: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
92: p_quantity IN NUMBER := 1,
93: p_media_type IN VARCHAR2,
94: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
92: p_quantity IN NUMBER := 1,
93: p_media_type IN VARCHAR2,
94: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
92: p_quantity IN NUMBER := 1,
93: p_media_type IN VARCHAR2,
94: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_content_type IN VARCHAR2,
92: p_quantity IN NUMBER := 1,
93: p_media_type IN VARCHAR2,
94: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_content_type IN VARCHAR2,
100: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
93: p_media_type IN VARCHAR2,
94: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_content_type IN VARCHAR2,
100: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
101: p_bind_val IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
94: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_content_type IN VARCHAR2,
100: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
101: p_bind_val IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
102: p_bind_var_type IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
143:
144: PROCEDURE Get_Content_XML
145: (
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
144: PROCEDURE Get_Content_XML
145: (
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
145: (
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_content_id IN NUMBER,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_content_id IN NUMBER,
154: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
156: p_quantity IN NUMBER := 1,
157: p_media_type IN VARCHAR2,
158: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_content_id IN NUMBER,
154: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
156: p_quantity IN NUMBER := 1,
157: p_media_type IN VARCHAR2,
158: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
156: p_quantity IN NUMBER := 1,
157: p_media_type IN VARCHAR2,
158: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
156: p_quantity IN NUMBER := 1,
157: p_media_type IN VARCHAR2,
158: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_content_type IN VARCHAR2,
156: p_quantity IN NUMBER := 1,
157: p_media_type IN VARCHAR2,
158: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_content_type IN VARCHAR2,
164: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
157: p_media_type IN VARCHAR2,
158: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_content_type IN VARCHAR2,
164: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
165: p_bind_val IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
158: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_content_type IN VARCHAR2,
164: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
165: p_bind_val IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
166: p_bind_var_type IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
213: -- 05/07/01 sxkrishn overloaded with org_id
214: ---------------------------------------------------------------
215: PROCEDURE Send_Request
216: (p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
218: p_commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
214: ---------------------------------------------------------------
215: PROCEDURE Send_Request
216: (p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
218: p_commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
215: PROCEDURE Send_Request
216: (p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
218: p_commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_user_id IN NUMBER,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_user_id IN NUMBER,
228: p_priority IN NUMBER := G_PRIORITY_REGULAR,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_user_id IN NUMBER,
228: p_priority IN NUMBER := G_PRIORITY_REGULAR,
229: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_user_id IN NUMBER,
228: p_priority IN NUMBER := G_PRIORITY_REGULAR,
229: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
230: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_user_id IN NUMBER,
228: p_priority IN NUMBER := G_PRIORITY_REGULAR,
229: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
230: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
233: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
226: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_user_id IN NUMBER,
228: p_priority IN NUMBER := G_PRIORITY_REGULAR,
229: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
230: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
233: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
234: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_user_id IN NUMBER,
228: p_priority IN NUMBER := G_PRIORITY_REGULAR,
229: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
230: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
233: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
234: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_priority IN NUMBER := G_PRIORITY_REGULAR,
229: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
230: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
233: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
234: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
229: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
230: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
233: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
234: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_queue_response IN VARCHAR2 := 'S',
230: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
233: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
234: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_queue_response IN VARCHAR2 := 'S',
238: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
233: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
234: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_queue_response IN VARCHAR2 := 'S',
238: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_content_xml IN VARCHAR2,
232: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
233: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
234: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_queue_response IN VARCHAR2 := 'S',
238: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_content_xml IN VARCHAR2,
240: p_request_id IN NUMBER,
234: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_queue_response IN VARCHAR2 := 'S',
238: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_content_xml IN VARCHAR2,
240: p_request_id IN NUMBER,
241: p_preview IN VARCHAR2 := FND_API.G_FALSE
242: );
237: p_queue_response IN VARCHAR2 := 'S',
238: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_content_xml IN VARCHAR2,
240: p_request_id IN NUMBER,
241: p_preview IN VARCHAR2 := FND_API.G_FALSE
242: );
243:
244:
245: ---------------------------------------------------------------------
274: -------------------------------------------------------------------------
275:
276: PROCEDURE Submit_Request
277: ( p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
275:
276: PROCEDURE Submit_Request
277: ( p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
276: PROCEDURE Submit_Request
277: ( p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
287: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_user_id IN NUMBER,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
287: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_user_id IN NUMBER,
289: p_priority IN NUMBER := G_PRIORITY_REGULAR,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
287: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_user_id IN NUMBER,
289: p_priority IN NUMBER := G_PRIORITY_REGULAR,
290: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
283: x_msg_data OUT NOCOPY VARCHAR2,
284: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
287: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_user_id IN NUMBER,
289: p_priority IN NUMBER := G_PRIORITY_REGULAR,
290: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
291: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
287: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_user_id IN NUMBER,
289: p_priority IN NUMBER := G_PRIORITY_REGULAR,
290: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
291: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
287: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_user_id IN NUMBER,
289: p_priority IN NUMBER := G_PRIORITY_REGULAR,
290: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
291: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
288: p_user_id IN NUMBER,
289: p_priority IN NUMBER := G_PRIORITY_REGULAR,
290: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
291: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_priority IN NUMBER := G_PRIORITY_REGULAR,
290: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
291: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
290: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
291: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
291: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
299: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
299: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_content_xml IN VARCHAR2,
293: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
299: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_content_xml IN VARCHAR2,
301: p_request_id IN NUMBER
294: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
299: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_content_xml IN VARCHAR2,
301: p_request_id IN NUMBER
302: );
295: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
299: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_content_xml IN VARCHAR2,
301: p_request_id IN NUMBER
302: );
303:
305:
306:
307: PROCEDURE Submit_Previewed_Request(
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
310: p_commit IN VARCHAR2 := FND_API.G_FALSE,
311: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
306:
307: PROCEDURE Submit_Previewed_Request(
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
310: p_commit IN VARCHAR2 := FND_API.G_FALSE,
311: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
314: x_msg_data OUT NOCOPY VARCHAR2,
307: PROCEDURE Submit_Previewed_Request(
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
310: p_commit IN VARCHAR2 := FND_API.G_FALSE,
311: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
314: x_msg_data OUT NOCOPY VARCHAR2,
315: p_request_id IN NUMBER
337: ---------------------------------------------------------------------
338:
339: PROCEDURE Resubmit_Request(
340: p_api_version IN NUMBER,
341: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
342: p_commit IN VARCHAR2 := FND_API.G_FALSE,
343: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
338:
339: PROCEDURE Resubmit_Request(
340: p_api_version IN NUMBER,
341: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
342: p_commit IN VARCHAR2 := FND_API.G_FALSE,
343: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,
339: PROCEDURE Resubmit_Request(
340: p_api_version IN NUMBER,
341: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
342: p_commit IN VARCHAR2 := FND_API.G_FALSE,
343: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,
347: p_request_id IN NUMBER,
368: ---------------------------------------------------------------------
369:
370: PROCEDURE Resubmit_Request(
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
369:
370: PROCEDURE Resubmit_Request(
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2,
370: PROCEDURE Resubmit_Request(
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2,
378: p_request_id IN NUMBER
398: ---------------------------------------------------------------------
399:
400: PROCEDURE Cancel_Request(
401: p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
399:
400: PROCEDURE Cancel_Request(
401: p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
400: PROCEDURE Cancel_Request(
401: p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
408: p_request_id IN NUMBER,
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
408: p_request_id IN NUMBER,
409: p_submit_dt_tm IN DATE := FND_API.G_MISS_DATE
410: );
411:
412: ---------------------------------------------------------------------
413: -- PROCEDURE
444:
445: PROCEDURE Get_Multiple_Content_XML
446: (
447: p_api_version IN NUMBER,
448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
449: p_commit IN VARCHAR2 := FND_API.G_FALSE,
450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
445: PROCEDURE Get_Multiple_Content_XML
446: (
447: p_api_version IN NUMBER,
448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
449: p_commit IN VARCHAR2 := FND_API.G_FALSE,
450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
453: x_msg_data OUT NOCOPY VARCHAR2,
446: (
447: p_api_version IN NUMBER,
448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
449: p_commit IN VARCHAR2 := FND_API.G_FALSE,
450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
453: x_msg_data OUT NOCOPY VARCHAR2,
454: p_request_id IN NUMBER,
510: ---------------------------------------------------------------------
511:
512: PROCEDURE Submit_Batch_Request
513: ( p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
515: p_commit IN VARCHAR2 := FND_API.G_FALSE,
516: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
511:
512: PROCEDURE Submit_Batch_Request
513: ( p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
515: p_commit IN VARCHAR2 := FND_API.G_FALSE,
516: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2,
512: PROCEDURE Submit_Batch_Request
513: ( p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
515: p_commit IN VARCHAR2 := FND_API.G_FALSE,
516: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2,
520: p_template_id IN NUMBER := NULL,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2,
520: p_template_id IN NUMBER := NULL,
521: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_user_id IN NUMBER,
523: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: x_msg_data OUT NOCOPY VARCHAR2,
520: p_template_id IN NUMBER := NULL,
521: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_user_id IN NUMBER,
523: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
526: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
527: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
520: p_template_id IN NUMBER := NULL,
521: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_user_id IN NUMBER,
523: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
526: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
527: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
528: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
521: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_user_id IN NUMBER,
523: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
526: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
527: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
528: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
529: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_user_id IN NUMBER,
523: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
526: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
527: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
528: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
529: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
530: p_list_type IN VARCHAR2,
523: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
526: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
527: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
528: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
529: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
530: p_list_type IN VARCHAR2,
531: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
526: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
527: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
528: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
529: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
530: p_list_type IN VARCHAR2,
531: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_party_id IN G_NUMBER_TBL_TYPE := L_NUMBER_TBL,
525: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
526: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
527: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
528: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
529: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
530: p_list_type IN VARCHAR2,
531: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_party_id IN G_NUMBER_TBL_TYPE := L_NUMBER_TBL,
533: p_party_name IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
527: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
528: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
529: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
530: p_list_type IN VARCHAR2,
531: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_party_id IN G_NUMBER_TBL_TYPE := L_NUMBER_TBL,
533: p_party_name IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
534: p_printer IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
535: p_email IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
534: p_printer IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
535: p_email IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
536: p_fax IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
537: p_file_path IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
538: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
539: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
540: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_content_xml IN VARCHAR2,
542: p_request_id IN NUMBER,
535: p_email IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
536: p_fax IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
537: p_file_path IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
538: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
539: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
540: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_content_xml IN VARCHAR2,
542: p_request_id IN NUMBER,
543: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE
536: p_fax IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
537: p_file_path IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
538: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
539: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
540: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_content_xml IN VARCHAR2,
542: p_request_id IN NUMBER,
543: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE
544: );
539: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
540: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_content_xml IN VARCHAR2,
542: p_request_id IN NUMBER,
543: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE
544: );
545:
546: ---------------------------------------------------------------------------
547:
546: ---------------------------------------------------------------------------
547:
548: PROCEDURE Submit_Mass_Request
549: ( p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551: p_commit IN VARCHAR2 := FND_API.G_FALSE,
552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
547:
548: PROCEDURE Submit_Mass_Request
549: ( p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551: p_commit IN VARCHAR2 := FND_API.G_FALSE,
552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,
548: PROCEDURE Submit_Mass_Request
549: ( p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
551: p_commit IN VARCHAR2 := FND_API.G_FALSE,
552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,
556: p_template_id IN NUMBER := NULL,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,
556: p_template_id IN NUMBER := NULL,
557: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
558: p_user_id IN NUMBER,
559: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
560: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
561: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
555: x_msg_data OUT NOCOPY VARCHAR2,
556: p_template_id IN NUMBER := NULL,
557: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
558: p_user_id IN NUMBER,
559: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
560: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
561: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
562: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
563: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
556: p_template_id IN NUMBER := NULL,
557: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
558: p_user_id IN NUMBER,
559: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
560: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
561: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
562: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
563: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
557: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
558: p_user_id IN NUMBER,
559: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
560: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
561: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
562: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
563: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
558: p_user_id IN NUMBER,
559: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
560: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
561: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
562: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
563: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_list_type IN VARCHAR2, --deprecated
559: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
560: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
561: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
562: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
563: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_list_type IN VARCHAR2, --deprecated
567: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
560: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
561: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
562: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
563: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_list_type IN VARCHAR2, --deprecated
567: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
561: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
562: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
563: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_list_type IN VARCHAR2, --deprecated
567: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
563: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
564: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_list_type IN VARCHAR2, --deprecated
567: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
570: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_content_xml IN VARCHAR2,
564: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
565: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_list_type IN VARCHAR2, --deprecated
567: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
570: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_content_xml IN VARCHAR2,
572: p_request_id IN NUMBER,
565: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
566: p_list_type IN VARCHAR2, --deprecated
567: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
570: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_content_xml IN VARCHAR2,
572: p_request_id IN NUMBER,
573: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,
566: p_list_type IN VARCHAR2, --deprecated
567: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
568: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
569: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
570: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_content_xml IN VARCHAR2,
572: p_request_id IN NUMBER,
573: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,
574: p_mass_query_id IN NUMBER, --deprecated
569: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
570: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
571: p_content_xml IN VARCHAR2,
572: p_request_id IN NUMBER,
573: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,
574: p_mass_query_id IN NUMBER, --deprecated
575: p_mass_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
576: p_mass_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
577: p_mass_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL --deprecated
640: ---------------------------------------------------------------------
641: PROCEDURE New_Cancel_Request --anchaudh added
642: (
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
645: p_commit IN VARCHAR2 := FND_API.G_FALSE,
646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
641: PROCEDURE New_Cancel_Request --anchaudh added
642: (
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
645: p_commit IN VARCHAR2 := FND_API.G_FALSE,
646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
649: x_msg_data OUT NOCOPY VARCHAR2,
642: (
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
645: p_commit IN VARCHAR2 := FND_API.G_FALSE,
646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
649: x_msg_data OUT NOCOPY VARCHAR2,
650: p_request_id IN NUMBER,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
649: x_msg_data OUT NOCOPY VARCHAR2,
650: p_request_id IN NUMBER,
651: p_submit_dt_tm IN DATE := FND_API.G_MISS_DATE
652: );
653:
654: ------------------------------------------------------------
655: --Determines which route the request has taken for its processing.