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.AMS_FULFILL_PVT dependencies on JTF_FM_REQUEST_GRP

Line 448: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

444: l_subject VARCHAR2(1000) ;
445: l_source_code VARCHAR2(30);
446: l_start_Date DATE;
447: l_template_id NUMBER;
448: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
449: l_source_code_id NUMBER;
450: l_resource_id NUMBER;
451: l_sender VARCHAR2(120) ;
452: l_reply_to VARCHAR2(120) ;

Line 476: l_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

472: l_media_types VARCHAR2(30) := 'E';
473: l_activity_id NUMBER;
474: l_fulfilment VARCHAR2(30);
475:
476: l_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
477: l_printer_address VARCHAR2(255);
478:
479: l_delivery_mode VARCHAR2(30);
480: BEGIN

Line 1058: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

1054: l_content_nm VARCHAR2(240); --(50) ;
1055: l_media_type VARCHAR2(30) ;
1056: l_content_xml VARCHAR2(4000) ;
1057:
1058: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1059: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1060: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1061: l_cnt NUMBER := 0 ;
1062:

Line 1059: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

1055: l_media_type VARCHAR2(30) ;
1056: l_content_xml VARCHAR2(4000) ;
1057:
1058: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1059: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1060: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1061: l_cnt NUMBER := 0 ;
1062:
1063: l_extended_header VARCHAR2(2000);

Line 1060: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

1056: l_content_xml VARCHAR2(4000) ;
1057:
1058: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1059: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1060: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1061: l_cnt NUMBER := 0 ;
1062:
1063: l_extended_header VARCHAR2(2000);
1064: l_sender VARCHAR2(120);

Line 1174: JTF_FM_REQUEST_GRP.Get_Content_XML

1170: -- bind Variable defined for the query of Master Doc is Party_id
1171: -- So the FF Engine will create Master Document in Submit Batch Process
1172: -- Also no need to pass Fax no / Email as well ,as these details will
1173: -- pass that in Submit Batch Process API
1174: JTF_FM_REQUEST_GRP.Get_Content_XML
1175: ( p_api_version => l_api_version,
1176: x_return_status => l_return_status,
1177: x_msg_count => x_msg_count,
1178: x_msg_data => x_msg_data,

Line 1349: JTF_FM_REQUEST_GRP.Get_Content_XML

1345: OPEN c_kit_det ;
1346: LOOP
1347: FETCH c_kit_det INTO l_content_id ,l_content_nm,l_kit_flag ;
1348: EXIT WHEN c_kit_det%NOTFOUND;
1349: JTF_FM_REQUEST_GRP.Get_Content_XML
1350: ( p_api_version => l_api_version,
1351: x_return_status => x_return_status,
1352: x_msg_count => x_msg_count,
1353: x_msg_data => x_msg_data,

Line 1574: JTF_FM_REQUEST_GRP.Get_Content_XML

1570: l_media_type := 'FAX' ;
1571: ELSE
1572: l_media_type := 'EMAIL' ;
1573: END IF ;
1574: JTF_FM_REQUEST_GRP.Get_Content_XML
1575: ( p_api_version => l_api_version,
1576: x_return_status => l_return_status,
1577: x_msg_count => x_msg_count,
1578: x_msg_data => x_msg_data,

Line 1700: JTF_FM_REQUEST_GRP.Get_Content_XML

1696: AMS_UTILITY_PVT.debug_message('Content Id :'||l_content_id);
1697: END IF;
1698: -- No need to pass Fax no / Email as well ,as these details will
1699: -- pass that in Submit Batch Process API
1700: JTF_FM_REQUEST_GRP.Get_Content_XML
1701: ( p_api_version => l_api_version,
1702: x_return_status => l_return_status,
1703: x_msg_count => x_msg_count,
1704: x_msg_data => x_msg_data,

Line 1948: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ;

1944: WHERE schedule_id = p_schedule_id ;
1945: l_subject VARCHAR2(1000) ;
1946: l_source_code VARCHAR2(30);
1947:
1948: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ;
1949: l_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1950: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1951: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1952:

Line 1949: l_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

1945: l_subject VARCHAR2(1000) ;
1946: l_source_code VARCHAR2(30);
1947:
1948: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ;
1949: l_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1950: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1951: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1952:
1953:

Line 1950: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

1946: l_source_code VARCHAR2(30);
1947:
1948: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ;
1949: l_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1950: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1951: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1952:
1953:
1954: l_request_id NUMBER ;

Line 1951: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

1947:
1948: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE ;
1949: l_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1950: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1951: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1952:
1953:
1954: l_request_id NUMBER ;
1955: l_content_xml VARCHAR2(4000); -- Temp. Variable to get XML Data

Line 1967: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

1963:
1964: -- added by soagrawa on 06-sep-2001
1965: -- to use submit_mass_request instead of submit_batch_request
1966: G_QUERY_ID CONSTANT NUMBER := 300 ;
1967: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1968: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1969: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1970:
1971:

Line 1968: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

1964: -- added by soagrawa on 06-sep-2001
1965: -- to use submit_mass_request instead of submit_batch_request
1966: G_QUERY_ID CONSTANT NUMBER := 300 ;
1967: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1968: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1969: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1970:
1971:
1972:

Line 1969: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

1965: -- to use submit_mass_request instead of submit_batch_request
1966: G_QUERY_ID CONSTANT NUMBER := 300 ;
1967: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1968: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1969: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
1970:
1971:
1972:
1973: BEGIN

Line 2019: JTF_FM_REQUEST_GRP.STart_Request

2015: OPEN c_list_hdr_det ;
2016: FETCH c_list_hdr_det INTO l_list_hdr_rec;
2017: CLOSE c_list_hdr_det ;
2018:
2019: JTF_FM_REQUEST_GRP.STart_Request
2020: ( p_api_version => l_api_version,
2021: x_return_status => l_return_status,
2022: x_msg_count => x_msg_count,
2023: x_msg_data => x_msg_data,

Line 2136: /*JTF_FM_REQUEST_GRP.Submit_Batch_Request

2132: -- added by soagrawa on 30-May-2001
2133: -- changes made in order to write to interaction history
2134: -- added value for parameter p_per_user_history as true
2135: */
2136: /*JTF_FM_REQUEST_GRP.Submit_Batch_Request
2137: (p_api_version => l_api_version,
2138: p_commit => p_commit,
2139: x_return_status => l_return_status,
2140: x_msg_count => x_msg_count,

Line 2166: JTF_FM_REQUEST_GRP.Submit_Mass_Request

2162: l_mass_bind_var(1) := 'LIST_ID' ;
2163: l_mass_bind_var_type(1) := 'NUMBER' ;
2164: l_mass_bind_val(1) := p_list_header_id ;
2165:
2166: JTF_FM_REQUEST_GRP.Submit_Mass_Request
2167: (p_api_version => l_api_version,
2168: p_commit => p_commit,
2169: x_return_status => l_return_status,
2170: x_msg_count => x_msg_count,

Line 2325: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

2321: l_reply_to VARCHAR2(240);
2322: l_from_fax VARCHAR2(25);
2323: l_media_type_code VARCHAR2(30) ;
2324:
2325: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2326: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2327: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2328:
2329: -- Following cursor will select dummy entry from ams_list_entries to

Line 2326: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

2322: l_from_fax VARCHAR2(25);
2323: l_media_type_code VARCHAR2(30) ;
2324:
2325: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2326: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2327: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2328:
2329: -- Following cursor will select dummy entry from ams_list_entries to
2330: -- send the test mail.

Line 2327: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

2323: l_media_type_code VARCHAR2(30) ;
2324:
2325: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2326: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2327: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
2328:
2329: -- Following cursor will select dummy entry from ams_list_entries to
2330: -- send the test mail.
2331: CURSOR c_list_entry IS

Line 2383: JTF_FM_REQUEST_GRP.STart_Request

2379: CLOSE c_csch_det ;
2380:
2381: -- Start the Api
2382: -- Get the xml for cover letter
2383: JTF_FM_REQUEST_GRP.STart_Request
2384: ( p_api_version => l_api_version,
2385: x_return_status => l_return_status,
2386: x_msg_count => x_msg_count,
2387: x_msg_data => x_msg_data,

Line 2430: JTF_FM_REQUEST_GRP.Get_Content_XML

2426: IF (AMS_DEBUG_HIGH_ON) THEN
2427: AMS_Utility_PVT.Debug_Message('Party Id : '||l_party_id || 'List : '||l_list_header_id);
2428: END IF;
2429:
2430: JTF_FM_REQUEST_GRP.Get_Content_XML
2431: (
2432: p_api_version => l_api_version,
2433: p_commit => p_commit,
2434: x_return_status => x_return_status,

Line 2476: JTF_FM_REQUEST_GRP.Submit_Request

2472: IF (AMS_DEBUG_HIGH_ON) THEN
2473: AMS_Utility_PVT.Debug_Message('Success Flag : '||x_return_status );
2474: END IF;
2475: l_content_xml := l_content_xml || nvl(l_attach_xml,'') ;
2476: JTF_FM_REQUEST_GRP.Submit_Request
2477: (p_api_version => l_api_version,
2478: p_commit => p_commit,
2479: x_return_status => l_return_status,
2480: x_msg_count => x_msg_count,