DBA Data[Home] [Help]

APPS.JTF_FM_OCM_REQUEST_GRP dependencies on JTF_FM_REQUEST_GRP

Line 40: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,

36:
37:
38: PROCEDURE GET_TEST_XML
39: (
40: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,
41: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
42: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
43: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
44: p_content_xml IN VARCHAR2,

Line 41: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,

37:
38: PROCEDURE GET_TEST_XML
39: (
40: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,
41: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
42: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
43: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
44: p_content_xml IN VARCHAR2,
45: x_return_status OUT NOCOPY VARCHAR2,

Line 42: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,

38: PROCEDURE GET_TEST_XML
39: (
40: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,
41: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
42: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
43: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
44: p_content_xml IN VARCHAR2,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_test_xml OUT NOCOPY VARCHAR2

Line 43: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,

39: (
40: p_party_id IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ,
41: p_email IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
42: p_fax IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
43: p_printer IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ,
44: p_content_xml IN VARCHAR2,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_test_xml OUT NOCOPY VARCHAR2
47:

Line 174: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

170: l_api_version CONSTANT NUMBER := 1.0;
171: l_init_msg_list VARCHAR2(2) := FND_API.G_FALSE;
172: l_content_xml VARCHAR2(10000);
173: l_content_xml1 VARCHAR2(1000);
174: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
175: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
176: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
177: l_content_id NUMBER;
178: l_per_user_history VARCHAR2(2);

Line 175: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

171: l_init_msg_list VARCHAR2(2) := FND_API.G_FALSE;
172: l_content_xml VARCHAR2(10000);
173: l_content_xml1 VARCHAR2(1000);
174: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
175: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
176: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
177: l_content_id NUMBER;
178: l_per_user_history VARCHAR2(2);
179: l_subject VARCHAR2(255);

Line 176: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

172: l_content_xml VARCHAR2(10000);
173: l_content_xml1 VARCHAR2(1000);
174: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
175: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
176: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
177: l_content_id NUMBER;
178: l_per_user_history VARCHAR2(2);
179: l_subject VARCHAR2(255);
180: l_quantity NUMBER := 1;

Line 246: l_bind_var := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

242: ELSIF (IS_REQ_ETSL(p_fulfill_electronic_rec.request_type)) THEN
243:
244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: l_bind_var := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
247: l_bind_val := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
248: l_bind_var_type := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
249:
250: IF LENGTH(p_fulfill_electronic_rec.media_types) >3 THEN

Line 247: l_bind_val := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

243:
244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: l_bind_var := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
247: l_bind_val := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
248: l_bind_var_type := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
249:
250: IF LENGTH(p_fulfill_electronic_rec.media_types) >3 THEN
251: l_Error_Msg := null;

Line 248: l_bind_var_type := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;

244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: l_bind_var := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
247: l_bind_val := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
248: l_bind_var_type := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL;
249:
250: IF LENGTH(p_fulfill_electronic_rec.media_types) >3 THEN
251: l_Error_Msg := null;
252: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';

Line 345: JTF_FM_REQUEST_GRP.start_request

341: internally three apis are called
342: start request is called first
343: **/
344:
345: JTF_FM_REQUEST_GRP.start_request
346: (
347: p_api_version => l_api_version,
348: p_init_msg_list => l_init_msg_list,
349: x_return_status => x_return_status,

Line 404: JTF_FM_REQUEST_GRP.GET_CONTENT_XML

400: for single request
401: p_email,p_file_path,,p_fax should change
402: **/
403:
404: JTF_FM_REQUEST_GRP.GET_CONTENT_XML
405: (p_api_version => p_api_version,
406: x_return_status => x_return_status,
407: x_msg_count => x_msg_count,
408: x_msg_data => x_msg_data,