DBA Data[Home] [Help]

APPS.IES_SVY_DEPLOYMENT_PVT dependencies on JTF_FM_REQUEST_GRP

Line 331: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

327: l_user_id NUMBER;
328: l_server_id NUMBER;
329: l_request_id NUMBER;
330: l_subject VARCHAR2(100);
331: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
332: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
333: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
334:
335: --

Line 332: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

328: l_server_id NUMBER;
329: l_request_id NUMBER;
330: l_subject VARCHAR2(100);
331: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
332: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
333: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
334:
335: --
336: l_msg_count NUMBER;

Line 333: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

329: l_request_id NUMBER;
330: l_subject VARCHAR2(100);
331: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
332: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
333: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
334:
335: --
336: l_msg_count NUMBER;
337: l_msg_data VARCHAR2(1000);

Line 441: JTF_FM_REQUEST_GRP.Start_Request

437:
438: -- Start the fulfillment request. The output request_id must be passed
439: -- to all subsequent calls made for this request.
440:
441: JTF_FM_REQUEST_GRP.Start_Request
442: (
443: p_api_version => l_api_version,
444: x_return_status => l_return_status,
445: x_msg_count => l_msg_count,

Line 483: JTF_FM_REQUEST_GRP.Get_Content_XML

479:
480:
481: -- This call gets the XML string for the content(Master Document) with
482: -- the parameters as defined above
483: JTF_FM_REQUEST_GRP.Get_Content_XML
484: (
485: p_api_version => l_api_version,
486: x_return_status => l_return_status,
487: x_msg_count => l_msg_count,

Line 535: JTF_FM_REQUEST_GRP.Submit_Request

531: -- Initialize Parameters for submitting the fulfillment request
532:
533: l_user_id := p_user_id;
534: -- Submit the fulfillment request
535: JTF_FM_REQUEST_GRP.Submit_Request
536: (p_api_version => l_api_version,
537: p_commit => l_commit,
538: x_return_status => l_return_status,
539: x_msg_count => l_msg_count,

Line 612: JTF_FM_REQUEST_GRP.Cancel_Request

608: p_encoded => FND_API.G_FALSE);
609: x_msg_data := l_msg_data;
610: end loop;
611: end if;
612: JTF_FM_REQUEST_GRP.Cancel_Request
613: (p_api_version => l_api_version,
614: p_commit => l_commit,
615: p_init_msg_list => FND_API.G_FALSE,
616: x_return_status => l_return_status,

Line 635: JTF_FM_REQUEST_GRP.Cancel_Request

631: x_msg_data := l_msg_data;
632: end loop;
633: end if;
634:
635: JTF_FM_REQUEST_GRP.Cancel_Request
636: (p_api_version => l_api_version,
637: p_commit => l_commit,
638: p_init_msg_list => FND_API.G_FALSE,
639: x_return_status => l_return_status,

Line 659: JTF_FM_REQUEST_GRP.Cancel_Request

655: x_msg_data := l_msg_data;
656: end loop;
657: end if;
658: -- cancel the request just sent
659: JTF_FM_REQUEST_GRP.Cancel_Request
660: (p_api_version => l_api_version,
661: p_commit => l_commit,
662: p_init_msg_list => FND_API.G_FALSE,
663: x_return_status => l_return_status,

Line 723: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

719: l_server_id NUMBER;
720: l_request_id NUMBER;
721: l_subject VARCHAR2(100);
722: l_list_type VARCHAR2(100);
723: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
724: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
725: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
726:
727: --

Line 724: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

720: l_request_id NUMBER;
721: l_subject VARCHAR2(100);
722: l_list_type VARCHAR2(100);
723: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
724: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
725: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
726:
727: --
728: l_msg_count NUMBER;

Line 725: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

721: l_subject VARCHAR2(100);
722: l_list_type VARCHAR2(100);
723: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
724: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
725: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
726:
727: --
728: l_msg_count NUMBER;
729: l_msg_data VARCHAR2(1000);

Line 735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;

731: l_content_xml1 VARCHAR2(1000);
732: l_content_xml VARCHAR2(10000);
733: l_content_nm VARCHAR2(100);
734:
735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

Line 736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;

732: l_content_xml VARCHAR2(10000);
733: l_content_nm VARCHAR2(100);
734:
735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

Line 737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

733: l_content_nm VARCHAR2(100);
734:
735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

Line 738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

734:
735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

Line 739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

735: l_mass_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

Line 740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

736: l_mass_survey_list_entry_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

Line 741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

737: l_mass_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
745:

Line 742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

738: l_mass_printer JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
745:
746: l_content_no NUMBER;

Line 743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

739: l_mass_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
745:
746: l_content_no NUMBER;
747: l_content_type NUMBER;

Line 744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

740: l_mass_path JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
741: l_mass_party_name JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
742: l_mass_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
743: l_mass_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
744: l_mass_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
745:
746: l_content_no NUMBER;
747: l_content_type NUMBER;
748: l_content_type_text VARCHAR2(30);

Line 840: JTF_FM_REQUEST_GRP.Start_Request

836: end if;
837:
838: -- Start the fulfillment request. The output request_id must be passed
839: -- to all subsequent calls made for this request.
840: JTF_FM_REQUEST_GRP.Start_Request
841: (
842: p_api_version => l_api_version,
843: x_return_status => l_return_status,
844: x_msg_count => l_msg_count,

Line 885: JTF_FM_REQUEST_GRP.Get_Content_XML

881: l_user_note := ' ';
882:
883: -- This call gets the XML string for the content(Master Document) with
884: -- the parameters as defined above
885: JTF_FM_REQUEST_GRP.Get_Content_XML
886: (
887: p_api_version => l_api_version,
888: x_return_status => l_return_status,
889: x_msg_count => l_msg_count,

Line 941: JTF_FM_REQUEST_GRP.Submit_Mass_Request

937: */
938: l_user_id := p_user_id;
939: -- Submit the fulfillment request
940:
941: JTF_FM_REQUEST_GRP.Submit_Mass_Request
942: ( p_api_version =>l_api_version,
943: p_init_msg_list=> FND_API.G_TRUE,
944: p_commit =>FND_API.G_FALSE,
945: p_validation_level=>FND_API.G_VALID_LEVEL_FULL,

Line 1028: JTF_FM_REQUEST_GRP.Cancel_Request

1024: FND_MSG_PUB.Count_And_Get
1025: (p_count => x_msg_count ,
1026: p_data => x_msg_data
1027: );
1028: JTF_FM_REQUEST_GRP.Cancel_Request
1029: (p_api_version => l_api_version,
1030: p_commit => l_commit,
1031: p_init_msg_list => FND_API.G_FALSE,
1032: x_return_status => l_return_status,

Line 1057: JTF_FM_REQUEST_GRP.Cancel_Request

1053: fnd_file.put_line(fnd_file.log, l_msg_data);
1054: end loop;
1055: end if;
1056: fnd_file.put_line(fnd_file.log, SQLERRM);
1057: JTF_FM_REQUEST_GRP.Cancel_Request
1058: (p_api_version => l_api_version,
1059: p_commit => l_commit,
1060: p_init_msg_list => FND_API.G_FALSE,
1061: x_return_status => l_return_status,

Line 1089: JTF_FM_REQUEST_GRP.Cancel_Request

1085: end if;
1086: fnd_file.put_line(fnd_file.log, SQLERRM);
1087:
1088: -- cancel the request just sent
1089: JTF_FM_REQUEST_GRP.Cancel_Request
1090: (p_api_version => l_api_version,
1091: p_commit => l_commit,
1092: p_init_msg_list => FND_API.G_FALSE,
1093: x_return_status => l_return_status,