eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_FM_REQUEST_GRP dependencies on JTF_FM_REQUEST_GRP

Line 1: PACKAGE BODY JTF_FM_Request_GRP AS

1: PACKAGE BODY JTF_FM_Request_GRP AS
2: /* $Header: jtfgfmb.pls 120.11 2006/06/20 22:31:30 ahattark ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(200) := 'jtf.plsql.jtfgfmb.JTF_FM_REQUEST_GRP';
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtfgfmb.pls';
5: --

Line 3: G_PKG_NAME CONSTANT VARCHAR2(200) := 'jtf.plsql.jtfgfmb.JTF_FM_REQUEST_GRP';

1: PACKAGE BODY JTF_FM_Request_GRP AS
2: /* $Header: jtfgfmb.pls 120.11 2006/06/20 22:31:30 ahattark ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(200) := 'jtf.plsql.jtfgfmb.JTF_FM_REQUEST_GRP';
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtfgfmb.pls';
5: --
6: G_VALID_LEVEL_LOGIN CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
7:

Line 83: JTF_FM_UTL_V.PRINT_MESSAGE('END function GET_QUEU_NAME', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_QUEUE_NAME');

79: INTO l_queue_name
80: FROM JTF_FM_SERVICE_ALL
81: WHERE SERVer_ID = p_server_id;
82:
83: JTF_FM_UTL_V.PRINT_MESSAGE('END function GET_QUEU_NAME', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_QUEUE_NAME');
84:
85: RETURN l_queue_name;
86:
87: EXCEPTION

Line 111: JTF_FM_UTL_V.PRINT_MESSAGE('END function ', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_QUEUE_NAME');

107: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
108: JTF_FM_UTL_V.PRINT_MESSAGE('File Id' || p_file_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
109: SELECT FILE_NAME into l_file_name from fnd_lobs where file_id = p_file_id and LANGUAGE = USERENV('LANG') ;
110:
111: JTF_FM_UTL_V.PRINT_MESSAGE('END function ', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_QUEUE_NAME');
112:
113: RETURN l_file_name;
114:
115: EXCEPTION

Line 196: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');

192: VALUES (p_parent_req_id ,p_job ,p_request_id ,
193: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID,
194: SYSDATE, FND_GLOBAL.LOGIN_ID);
195:
196: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');
197:
198: END UPDATE_RESUBMITTED;
199:
200:

Line 373: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');

369:
370: update JTF_FM_INT_REQUEST_HEADER
371: set request_status = 'CANCELLED'
372: where REQUEST_ID = p_request_id ;
373: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');
374:
375: -- Success message
376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
377: THEN

Line 477: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');

473: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
474:
475: BEGIN
476:
477: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');
478:
479: END NEW_PAUSE_RESUME_REQUEST;
480:
481: /*****************************************************

Line 745: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');

741: SET QUEUE_TYPE = p_queue_type ,
742: AQ_MSG_ID = p_new_msg_handle
743: WHERE REQUEST_ID = p_request_id
744: AND AQ_MSG_ID = p_old_msg_handle;
745: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');
746:
747: END UPDATE_REQUESTS_AQ;
748:
749: /**

Line 780: JTF_FM_UTL_V.PRINT_MESSAGE('Begin procedure UPDATE_STATUS_HISTORY', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_STATUS_HISTORY');

776: message_id = p_msg_id
777: WHERE
778: hist_req_id = p_request_id;
779:
780: JTF_FM_UTL_V.PRINT_MESSAGE('Begin procedure UPDATE_STATUS_HISTORY', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_STATUS_HISTORY');
781:
782:
783: END UPDATE_STATUS_HISTORY;
784:

Line 2348: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_JOB_NOT_FOUND', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_FILE_ID');

2344:
2345: EXCEPTION
2346: WHEN NO_DATA_FOUND
2347: THEN
2348: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_JOB_NOT_FOUND', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_FILE_ID');
2349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2350: THEN
2351: FND_MESSAGE.set_name('JTF', 'JTF_FM_JOB_NOT_FOUND');
2352: FND_MESSAGE.Set_Token('ARG1',p_job_id);

Line 2465: JTF_FM_UTL_V.PRINT_MESSAGE('Begin function IS_HTML', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.IS_HTML');

2461: l_api_name CONSTANT VARCHAR2(30) := 'IS_HTML';
2462: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
2463:
2464: BEGIN
2465: JTF_FM_UTL_V.PRINT_MESSAGE('Begin function IS_HTML', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.IS_HTML');
2466:
2467: -- Get the last index of .
2468: -- Search for htm, if htm, return true else return false
2469: IF(INSTR(SUBSTR(p_item_name, Length(p_item_name)-4 ,Length(p_item_name)),'htm') > 0) THEN

Line 2471: JTF_FM_UTL_V.PRINT_MESSAGE('Document is a html doc', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.IS_HTML');

2467: -- Get the last index of .
2468: -- Search for htm, if htm, return true else return false
2469: IF(INSTR(SUBSTR(p_item_name, Length(p_item_name)-4 ,Length(p_item_name)),'htm') > 0) THEN
2470: x_html := 'true';
2471: JTF_FM_UTL_V.PRINT_MESSAGE('Document is a html doc', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.IS_HTML');
2472:
2473: END IF;
2474:
2475: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 2524: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, 'JTF_FM_REQUEST_GRP.GET_FILE_ID');

2520:
2521: EXCEPTION
2522: WHEN NO_DATA_FOUND THEN
2523: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_OCM_NOTAPP_OR_ABS',
2524: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, 'JTF_FM_REQUEST_GRP.GET_FILE_ID');
2525: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_NOTAPP_OR_ABS', p_content_id);
2526: RAISE FND_API.G_EXC_ERROR;
2527: END;
2528:

Line 2561: JTF_FM_UTL_V.PRINT_MESSAGE(' THE REQUEST_ID IS ' || p_request_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');

2557: BEGIN
2558:
2559: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2560:
2561: JTF_FM_UTL_V.PRINT_MESSAGE(' THE REQUEST_ID IS ' || p_request_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');
2562:
2563: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS
2564: WHERE REQUEST_ID = p_request_id ;
2565: BEGIN

Line 2568: JTF_FM_UTL_V.PRINT_MESSAGE(' THE COUNT IS ' || l_req_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');

2564: WHERE REQUEST_ID = p_request_id ;
2565: BEGIN
2566: IF l_req_count > 0
2567: THEN
2568: JTF_FM_UTL_V.PRINT_MESSAGE(' THE COUNT IS ' || l_req_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');
2569:
2570: SELECT CITEM_VER_ID INTO l_cItemVersionId FROM IBC_CITEMS_V
2571: WHERE CITEM_ID = TO_NUMBER(p_content_id)
2572: and LANGUAGE = USERENV('LANG');

Line 2585: JTF_FM_UTL_V.PRINT_MESSAGE(' JTF_FM_OCM_NOTAPP_OR_ABS' ||' : ' || p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');

2581: END IF;
2582: EXCEPTION
2583: WHEN NO_DATA_FOUND
2584: THEN
2585: JTF_FM_UTL_V.PRINT_MESSAGE(' JTF_FM_OCM_NOTAPP_OR_ABS' ||' : ' || p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');
2586: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_NOTAPP_OR_ABS', p_content_id);
2587: RAISE FND_API.G_EXC_ERROR;
2588:
2589: END;

Line 2592: JTF_FM_UTL_V.PRINT_MESSAGE('Before Ibc_Citem_Admin_Grp.get_attribute_bundle call ' , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');

2588:
2589: END;
2590:
2591:
2592: JTF_FM_UTL_V.PRINT_MESSAGE('Before Ibc_Citem_Admin_Grp.get_attribute_bundle call ' , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');
2593:
2594:
2595: Ibc_Citem_Admin_Grp.get_attribute_bundle(
2596: p_citem_ver_id => l_cItemVersionId

Line 2741: 'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');

2737: IF l_req_count > 0 THEN
2738:
2739: JTF_FM_UTL_V.PRINT_MESSAGE(' IT IS A TEST REQUEST:THE COUNT IS ' ||
2740: l_req_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
2741: 'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2742:
2743: IF(p_version IS NOT NULL AND p_version <> FND_API.G_MISS_NUM) THEN
2744:
2745: -- In 11.5.9 Fulfillment had users pass 1 or 1.0 in as the version

Line 2893: JTF_FM_UTL_V.PRINT_MESSAGE('type_name = ' || attribute_type_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');

2889: EXIT WHEN att_count = counter;
2890: counter := counter + 1;
2891:
2892: JTF_FM_UTL_V.PRINT_MESSAGE('type_code = ' || attribute_type_codes(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2893: JTF_FM_UTL_V.PRINT_MESSAGE('type_name = ' || attribute_type_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2894: JTF_FM_UTL_V.PRINT_MESSAGE('attribute = ' || attributes(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2895: JTF_FM_UTL_V.PRINT_MESSAGE('------------------------------------------------',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2896: -- 11.5.9 ibc does not support Renditiosn, but 11.5.10 does
2897: -- For Backward compatibility, the HTML fnd Id and Text fnd Id

Line 2894: JTF_FM_UTL_V.PRINT_MESSAGE('attribute = ' || attributes(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');

2890: counter := counter + 1;
2891:
2892: JTF_FM_UTL_V.PRINT_MESSAGE('type_code = ' || attribute_type_codes(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2893: JTF_FM_UTL_V.PRINT_MESSAGE('type_name = ' || attribute_type_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2894: JTF_FM_UTL_V.PRINT_MESSAGE('attribute = ' || attributes(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2895: JTF_FM_UTL_V.PRINT_MESSAGE('------------------------------------------------',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2896: -- 11.5.9 ibc does not support Renditiosn, but 11.5.10 does
2897: -- For Backward compatibility, the HTML fnd Id and Text fnd Id
2898: -- are stored in these two variables and will be used if the Renditions API

Line 2895: JTF_FM_UTL_V.PRINT_MESSAGE('------------------------------------------------',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');

2891:
2892: JTF_FM_UTL_V.PRINT_MESSAGE('type_code = ' || attribute_type_codes(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2893: JTF_FM_UTL_V.PRINT_MESSAGE('type_name = ' || attribute_type_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2894: JTF_FM_UTL_V.PRINT_MESSAGE('attribute = ' || attributes(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2895: JTF_FM_UTL_V.PRINT_MESSAGE('------------------------------------------------',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2896: -- 11.5.9 ibc does not support Renditiosn, but 11.5.10 does
2897: -- For Backward compatibility, the HTML fnd Id and Text fnd Id
2898: -- are stored in these two variables and will be used if the Renditions API
2899: -- throws an error.

Line 3095: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', G_PKG_NAME );

3091: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
3092:
3093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3094: THEN
3095: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', G_PKG_NAME );
3096: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3097:
3098: -- Standard call to get message count and if count=1, get the message
3099: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

Line 3106: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');

3102: );
3103: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
3104:
3105: for i in 0..x_msg_count loop
3106: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
3107:
3108: end loop;
3109:
3110:

Line 3560: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', l_api_name);

3556: JTF_FM_UTL_V.PRINT_MESSAGE(SQLERRM ,JTF_FM_UTL_V.G_LEVEL_ERROR ,l_full_name);
3557:
3558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3559: THEN
3560: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', l_api_name);
3561: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3562:
3563: -- Standard call to get message count and if count=1, get the message
3564: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

Line 5957: p_job IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE,

5953: p_validation_level IN NUMBER,
5954: x_msg_count OUT NOCOPY NUMBER,
5955: x_msg_data OUT NOCOPY VARCHAR2,
5956: p_request_id IN NUMBER,
5957: p_job IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE,
5958: p_corrected_address IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
5959: x_return_status OUT NOCOPY VARCHAR2)
5960: IS
5961: l_api_name CONSTANT VARCHAR2(30) := 'CORRECT_MALFORMED_ADD';

Line 5958: p_corrected_address IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,

5954: x_msg_count OUT NOCOPY NUMBER,
5955: x_msg_data OUT NOCOPY VARCHAR2,
5956: p_request_id IN NUMBER,
5957: p_job IN JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE,
5958: p_corrected_address IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
5959: x_return_status OUT NOCOPY VARCHAR2)
5960: IS
5961: l_api_name CONSTANT VARCHAR2(30) := 'CORRECT_MALFORMED_ADD';
5962: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;

Line 6051: x_request_id OUT NOCOPY JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE,

6047: p_validation_level IN NUMBER,
6048: x_msg_count OUT NOCOPY NUMBER,
6049: x_msg_data OUT NOCOPY VARCHAR2,
6050: p_request_id IN NUMBER,
6051: x_request_id OUT NOCOPY JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE,
6052: x_return_status OUT NOCOPY VARCHAR2
6053: )
6054: IS
6055: l_api_name CONSTANT VARCHAR2(30) := 'RESUBMIT_MALFORMED_REQUEST';

Line 7151: p_mass_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated

7147: p_content_xml IN VARCHAR2,
7148: p_request_id IN NUMBER,
7149: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,
7150: p_mass_query_id IN NUMBER, --deprecated
7151: p_mass_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
7152: p_mass_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
7153: p_mass_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL --deprecated
7154:
7155: ) IS

Line 7152: p_mass_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated

7148: p_request_id IN NUMBER,
7149: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,
7150: p_mass_query_id IN NUMBER, --deprecated
7151: p_mass_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
7152: p_mass_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
7153: p_mass_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL --deprecated
7154:
7155: ) IS
7156: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_MASS_REQUEST';

Line 7153: p_mass_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL --deprecated

7149: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,
7150: p_mass_query_id IN NUMBER, --deprecated
7151: p_mass_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
7152: p_mass_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
7153: p_mass_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL --deprecated
7154:
7155: ) IS
7156: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_MASS_REQUEST';
7157: l_api_version CONSTANT NUMBER := 1.0;

Line 7267: p_priority => JTF_FM_REQUEST_GRP.G_PRIORITY_BATCH_REQUEST,

7263: p_party_id => l_party_id,
7264: p_user_id => p_user_id,
7265: p_doc_id => p_doc_id,
7266: p_doc_ref => p_doc_ref,
7267: p_priority => JTF_FM_REQUEST_GRP.G_PRIORITY_BATCH_REQUEST,
7268: p_source_code_id => p_source_code_id,
7269: p_source_code => p_source_code,
7270: p_object_type => p_object_type,
7271: p_object_id => p_object_id,

Line 7654: END JTF_FM_Request_GRP;

7650:
7651: JTF_FM_UTL_V.PRINT_MESSAGE('END: '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
7652: END PAUSE_RESUME_REQUEST;
7653:
7654: END JTF_FM_Request_GRP;