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

Line 23: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

19: --
20:
21: l_content_id VARCHAR2(30);
22: fulfillment_user_note VARCHAR2(2000);
23: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
24: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
25: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
26: --
27: l_template_id NUMBER;

Line 24: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

20:
21: l_content_id VARCHAR2(30);
22: fulfillment_user_note VARCHAR2(2000);
23: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
24: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
25: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
26: --
27: l_template_id NUMBER;
28: l_party_id NUMBER;

Line 25: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

21: l_content_id VARCHAR2(30);
22: fulfillment_user_note VARCHAR2(2000);
23: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
24: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
25: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
26: --
27: l_template_id NUMBER;
28: l_party_id NUMBER;
29: l_party_name VARCHAR2(100);

Line 655: JTF_FM_REQUEST_GRP.STart_Request

651:
652:
653: -- Start the fulfillment request. The output request_id must be passed
654: -- to all subsequent calls made for this request.
655: JTF_FM_REQUEST_GRP.STart_Request
656: (
657: p_api_version => l_api_version,
658: x_return_status => l_return_status,
659: x_msg_count => l_msg_count,

Line 703: l_bind_val(1) := jtf_fm_request_grp.replace_tag(p_incident_number);

699: -- are not accepted by fulfillment eg. &, <,> and '
700:
701: l_bind_var(1) := 'REQUEST_NUMBER';
702: l_bind_var_type(1) := 'VARCHAR2';
703: l_bind_val(1) := jtf_fm_request_grp.replace_tag(p_incident_number);
704:
705: l_bind_var(2) := 'STATUS';
706: l_bind_var_type(2) := 'VARCHAR2';
707: l_bind_val(2) := jtf_fm_request_grp.replace_tag(l_status_code);

Line 707: l_bind_val(2) := jtf_fm_request_grp.replace_tag(l_status_code);

703: l_bind_val(1) := jtf_fm_request_grp.replace_tag(p_incident_number);
704:
705: l_bind_var(2) := 'STATUS';
706: l_bind_var_type(2) := 'VARCHAR2';
707: l_bind_val(2) := jtf_fm_request_grp.replace_tag(l_status_code);
708:
709: l_bind_var(3) := 'REQUEST_TYPE';
710: l_bind_var_type(3) := 'VARCHAR2';
711: l_bind_val(3) := jtf_fm_request_grp.replace_tag(l_incident_type);

Line 711: l_bind_val(3) := jtf_fm_request_grp.replace_tag(l_incident_type);

707: l_bind_val(2) := jtf_fm_request_grp.replace_tag(l_status_code);
708:
709: l_bind_var(3) := 'REQUEST_TYPE';
710: l_bind_var_type(3) := 'VARCHAR2';
711: l_bind_val(3) := jtf_fm_request_grp.replace_tag(l_incident_type);
712:
713: l_bind_var(4) := 'SEVERITY';
714: l_bind_var_type(4) := 'VARCHAR2';
715: l_bind_val(4) := jtf_fm_request_grp.replace_tag(l_severity);

Line 715: l_bind_val(4) := jtf_fm_request_grp.replace_tag(l_severity);

711: l_bind_val(3) := jtf_fm_request_grp.replace_tag(l_incident_type);
712:
713: l_bind_var(4) := 'SEVERITY';
714: l_bind_var_type(4) := 'VARCHAR2';
715: l_bind_val(4) := jtf_fm_request_grp.replace_tag(l_severity);
716:
717: l_bind_var(5) := 'URGENCY';
718: l_bind_var_type(5) := 'VARCHAR2';
719: l_bind_val(5) := jtf_fm_request_grp.replace_tag(l_urgency);

Line 719: l_bind_val(5) := jtf_fm_request_grp.replace_tag(l_urgency);

715: l_bind_val(4) := jtf_fm_request_grp.replace_tag(l_severity);
716:
717: l_bind_var(5) := 'URGENCY';
718: l_bind_var_type(5) := 'VARCHAR2';
719: l_bind_val(5) := jtf_fm_request_grp.replace_tag(l_urgency);
720:
721: l_bind_var(6) := 'OWNER';
722: l_bind_var_type(6) := 'VARCHAR2';
723: l_bind_val(6) := jtf_fm_request_grp.replace_tag(l_owner);

Line 723: l_bind_val(6) := jtf_fm_request_grp.replace_tag(l_owner);

719: l_bind_val(5) := jtf_fm_request_grp.replace_tag(l_urgency);
720:
721: l_bind_var(6) := 'OWNER';
722: l_bind_var_type(6) := 'VARCHAR2';
723: l_bind_val(6) := jtf_fm_request_grp.replace_tag(l_owner);
724:
725: l_bind_var(7) := 'COMPANY';
726: l_bind_var_type(7) := 'VARCHAR2';
727: l_bind_val(7) := jtf_fm_request_grp.replace_tag(l_company_name);

Line 727: l_bind_val(7) := jtf_fm_request_grp.replace_tag(l_company_name);

723: l_bind_val(6) := jtf_fm_request_grp.replace_tag(l_owner);
724:
725: l_bind_var(7) := 'COMPANY';
726: l_bind_var_type(7) := 'VARCHAR2';
727: l_bind_val(7) := jtf_fm_request_grp.replace_tag(l_company_name);
728:
729: l_bind_var(8) := 'ACCOUNT';
730: l_bind_var_type(8) := 'VARCHAR2';
731: l_bind_val(8) := jtf_fm_request_grp.replace_tag(l_account_number);

Line 731: l_bind_val(8) := jtf_fm_request_grp.replace_tag(l_account_number);

727: l_bind_val(7) := jtf_fm_request_grp.replace_tag(l_company_name);
728:
729: l_bind_var(8) := 'ACCOUNT';
730: l_bind_var_type(8) := 'VARCHAR2';
731: l_bind_val(8) := jtf_fm_request_grp.replace_tag(l_account_number);
732:
733: l_bind_var(9) := 'HELPDESK_NUMBER';
734: l_bind_var_type(9) := 'VARCHAR2';
735: l_bind_val(9) := jtf_fm_request_grp.replace_tag(l_customer_ticket_number);

Line 735: l_bind_val(9) := jtf_fm_request_grp.replace_tag(l_customer_ticket_number);

731: l_bind_val(8) := jtf_fm_request_grp.replace_tag(l_account_number);
732:
733: l_bind_var(9) := 'HELPDESK_NUMBER';
734: l_bind_var_type(9) := 'VARCHAR2';
735: l_bind_val(9) := jtf_fm_request_grp.replace_tag(l_customer_ticket_number);
736:
737: l_bind_var(10) := 'FIRST_NAME';
738: l_bind_var_type(10) := 'VARCHAR2';
739: l_bind_val(10) := jtf_fm_request_grp.replace_tag(l_person_first_name);

Line 739: l_bind_val(10) := jtf_fm_request_grp.replace_tag(l_person_first_name);

735: l_bind_val(9) := jtf_fm_request_grp.replace_tag(l_customer_ticket_number);
736:
737: l_bind_var(10) := 'FIRST_NAME';
738: l_bind_var_type(10) := 'VARCHAR2';
739: l_bind_val(10) := jtf_fm_request_grp.replace_tag(l_person_first_name);
740:
741: l_bind_var(11) := 'LAST_NAME';
742: l_bind_var_type(11) := 'VARCHAR2';
743: l_bind_val(11) := jtf_fm_request_grp.replace_tag(l_person_last_name);

Line 743: l_bind_val(11) := jtf_fm_request_grp.replace_tag(l_person_last_name);

739: l_bind_val(10) := jtf_fm_request_grp.replace_tag(l_person_first_name);
740:
741: l_bind_var(11) := 'LAST_NAME';
742: l_bind_var_type(11) := 'VARCHAR2';
743: l_bind_val(11) := jtf_fm_request_grp.replace_tag(l_person_last_name);
744:
745: l_bind_var(12) := 'DATE_OPENED';
746: l_bind_var_type(12) := 'VARCHAR2';
747: l_bind_val(12) := jtf_fm_request_grp.replace_tag(l_date_opened);

Line 747: l_bind_val(12) := jtf_fm_request_grp.replace_tag(l_date_opened);

743: l_bind_val(11) := jtf_fm_request_grp.replace_tag(l_person_last_name);
744:
745: l_bind_var(12) := 'DATE_OPENED';
746: l_bind_var_type(12) := 'VARCHAR2';
747: l_bind_val(12) := jtf_fm_request_grp.replace_tag(l_date_opened);
748:
749: l_bind_var(13) := 'DATE_CLOSED';
750: l_bind_var_type(13) := 'VARCHAR2';
751: l_bind_val(13) := jtf_fm_request_grp.replace_tag(l_date_closed);

Line 751: l_bind_val(13) := jtf_fm_request_grp.replace_tag(l_date_closed);

747: l_bind_val(12) := jtf_fm_request_grp.replace_tag(l_date_opened);
748:
749: l_bind_var(13) := 'DATE_CLOSED';
750: l_bind_var_type(13) := 'VARCHAR2';
751: l_bind_val(13) := jtf_fm_request_grp.replace_tag(l_date_closed);
752:
753: l_bind_var(14) := 'PRODUCT_NAME';
754: l_bind_var_type(14) := 'VARCHAR2';
755: l_bind_val(14) := jtf_fm_request_grp.replace_tag(l_product_name);

Line 755: l_bind_val(14) := jtf_fm_request_grp.replace_tag(l_product_name);

751: l_bind_val(13) := jtf_fm_request_grp.replace_tag(l_date_closed);
752:
753: l_bind_var(14) := 'PRODUCT_NAME';
754: l_bind_var_type(14) := 'VARCHAR2';
755: l_bind_val(14) := jtf_fm_request_grp.replace_tag(l_product_name);
756:
757: l_bind_var(15) := 'PRODUCT_DESCRIPTION';
758: l_bind_var_type(15) := 'VARCHAR2';
759: l_bind_val(15) := jtf_fm_request_grp.replace_tag(l_product_description);

Line 759: l_bind_val(15) := jtf_fm_request_grp.replace_tag(l_product_description);

755: l_bind_val(14) := jtf_fm_request_grp.replace_tag(l_product_name);
756:
757: l_bind_var(15) := 'PRODUCT_DESCRIPTION';
758: l_bind_var_type(15) := 'VARCHAR2';
759: l_bind_val(15) := jtf_fm_request_grp.replace_tag(l_product_description);
760:
761: l_bind_var(16) := 'REQUEST_SUMMARY';
762: l_bind_var_type(16) := 'VARCHAR2';
763: l_bind_val(16) := jtf_fm_request_grp.replace_tag(l_summary);

Line 763: l_bind_val(16) := jtf_fm_request_grp.replace_tag(l_summary);

759: l_bind_val(15) := jtf_fm_request_grp.replace_tag(l_product_description);
760:
761: l_bind_var(16) := 'REQUEST_SUMMARY';
762: l_bind_var_type(16) := 'VARCHAR2';
763: l_bind_val(16) := jtf_fm_request_grp.replace_tag(l_summary);
764:
765: l_bind_var(17) := 'PROBLEM_MEANING';
766: l_bind_var_type(17) := 'VARCHAR2';
767: l_bind_val(17) := jtf_fm_request_grp.replace_tag(l_problem_meaning);

Line 767: l_bind_val(17) := jtf_fm_request_grp.replace_tag(l_problem_meaning);

763: l_bind_val(16) := jtf_fm_request_grp.replace_tag(l_summary);
764:
765: l_bind_var(17) := 'PROBLEM_MEANING';
766: l_bind_var_type(17) := 'VARCHAR2';
767: l_bind_val(17) := jtf_fm_request_grp.replace_tag(l_problem_meaning);
768:
769: l_bind_var(18) := 'RESOLUTION_MEANING';
770: l_bind_var_type(18) := 'VARCHAR2';
771: l_bind_val(18) := jtf_fm_request_grp.replace_tag(l_resolution_meaning);

Line 771: l_bind_val(18) := jtf_fm_request_grp.replace_tag(l_resolution_meaning);

767: l_bind_val(17) := jtf_fm_request_grp.replace_tag(l_problem_meaning);
768:
769: l_bind_var(18) := 'RESOLUTION_MEANING';
770: l_bind_var_type(18) := 'VARCHAR2';
771: l_bind_val(18) := jtf_fm_request_grp.replace_tag(l_resolution_meaning);
772:
773: l_bind_var(19) := 'SYSTEM_NAME';
774: l_bind_var_type(19) := 'VARCHAR2';
775: l_bind_val(19) := jtf_fm_request_grp.replace_tag(l_system_name);

Line 775: l_bind_val(19) := jtf_fm_request_grp.replace_tag(l_system_name);

771: l_bind_val(18) := jtf_fm_request_grp.replace_tag(l_resolution_meaning);
772:
773: l_bind_var(19) := 'SYSTEM_NAME';
774: l_bind_var_type(19) := 'VARCHAR2';
775: l_bind_val(19) := jtf_fm_request_grp.replace_tag(l_system_name);
776:
777: l_bind_var(20) := 'SERIAL_NUMBER';
778: l_bind_var_type(20) := 'VARCHAR2';
779: l_bind_val(20) := jtf_fm_request_grp.replace_tag(l_current_serial_number);

Line 779: l_bind_val(20) := jtf_fm_request_grp.replace_tag(l_current_serial_number);

775: l_bind_val(19) := jtf_fm_request_grp.replace_tag(l_system_name);
776:
777: l_bind_var(20) := 'SERIAL_NUMBER';
778: l_bind_var_type(20) := 'VARCHAR2';
779: l_bind_val(20) := jtf_fm_request_grp.replace_tag(l_current_serial_number);
780:
781: l_bind_var(21) := 'PLATFORM_NAME';
782: l_bind_var_type(21) := 'VARCHAR2';
783: l_bind_val(21) := jtf_fm_request_grp.replace_tag(l_platform_name);

Line 783: l_bind_val(21) := jtf_fm_request_grp.replace_tag(l_platform_name);

779: l_bind_val(20) := jtf_fm_request_grp.replace_tag(l_current_serial_number);
780:
781: l_bind_var(21) := 'PLATFORM_NAME';
782: l_bind_var_type(21) := 'VARCHAR2';
783: l_bind_val(21) := jtf_fm_request_grp.replace_tag(l_platform_name);
784:
785: l_bind_var(22) := 'PLATFORM_VERSION';
786: l_bind_var_type(22) := 'VARCHAR2';
787: l_bind_val(22) := jtf_fm_request_grp.replace_tag(l_platform_version);

Line 787: l_bind_val(22) := jtf_fm_request_grp.replace_tag(l_platform_version);

783: l_bind_val(21) := jtf_fm_request_grp.replace_tag(l_platform_name);
784:
785: l_bind_var(22) := 'PLATFORM_VERSION';
786: l_bind_var_type(22) := 'VARCHAR2';
787: l_bind_val(22) := jtf_fm_request_grp.replace_tag(l_platform_version);
788:
789: l_bind_var(23) := 'COMPONENT_NAME';
790: l_bind_var_type(23) := 'VARCHAR2';
791: l_bind_val(23) := jtf_fm_request_grp.replace_tag(l_component_name);

Line 791: l_bind_val(23) := jtf_fm_request_grp.replace_tag(l_component_name);

787: l_bind_val(22) := jtf_fm_request_grp.replace_tag(l_platform_version);
788:
789: l_bind_var(23) := 'COMPONENT_NAME';
790: l_bind_var_type(23) := 'VARCHAR2';
791: l_bind_val(23) := jtf_fm_request_grp.replace_tag(l_component_name);
792:
793: l_bind_var(24) := 'COMPONENT_DESCRIPTION';
794: l_bind_var_type(24) := 'VARCHAR2';
795: l_bind_val(24) := jtf_fm_request_grp.replace_tag(l_component_description);

Line 795: l_bind_val(24) := jtf_fm_request_grp.replace_tag(l_component_description);

791: l_bind_val(23) := jtf_fm_request_grp.replace_tag(l_component_name);
792:
793: l_bind_var(24) := 'COMPONENT_DESCRIPTION';
794: l_bind_var_type(24) := 'VARCHAR2';
795: l_bind_val(24) := jtf_fm_request_grp.replace_tag(l_component_description);
796:
797: l_bind_var(25) := 'COMPONENT_VERSION';
798: l_bind_var_type(25) := 'VARCHAR2';
799: l_bind_val(25) := jtf_fm_request_grp.replace_tag(l_component_version);

Line 799: l_bind_val(25) := jtf_fm_request_grp.replace_tag(l_component_version);

795: l_bind_val(24) := jtf_fm_request_grp.replace_tag(l_component_description);
796:
797: l_bind_var(25) := 'COMPONENT_VERSION';
798: l_bind_var_type(25) := 'VARCHAR2';
799: l_bind_val(25) := jtf_fm_request_grp.replace_tag(l_component_version);
800:
801: l_bind_var(26) := 'SUBCOMPONENT_NAME';
802: l_bind_var_type(26) := 'VARCHAR2';
803: l_bind_val(26) := jtf_fm_request_grp.replace_tag(l_subcomponent_name);

Line 803: l_bind_val(26) := jtf_fm_request_grp.replace_tag(l_subcomponent_name);

799: l_bind_val(25) := jtf_fm_request_grp.replace_tag(l_component_version);
800:
801: l_bind_var(26) := 'SUBCOMPONENT_NAME';
802: l_bind_var_type(26) := 'VARCHAR2';
803: l_bind_val(26) := jtf_fm_request_grp.replace_tag(l_subcomponent_name);
804:
805: l_bind_var(27) := 'SUBCOMPONENT_DESCRIPTION';
806: l_bind_var_type(27) := 'VARCHAR2';
807: l_bind_val(27) := jtf_fm_request_grp.replace_tag(l_subcomponent_description);

Line 807: l_bind_val(27) := jtf_fm_request_grp.replace_tag(l_subcomponent_description);

803: l_bind_val(26) := jtf_fm_request_grp.replace_tag(l_subcomponent_name);
804:
805: l_bind_var(27) := 'SUBCOMPONENT_DESCRIPTION';
806: l_bind_var_type(27) := 'VARCHAR2';
807: l_bind_val(27) := jtf_fm_request_grp.replace_tag(l_subcomponent_description);
808:
809: l_bind_var(28) := 'SUBCOMPONENT_VERSION';
810: l_bind_var_type(28) := 'VARCHAR2';
811: l_bind_val(28) := jtf_fm_request_grp.replace_tag(l_subcomponent_version);

Line 811: l_bind_val(28) := jtf_fm_request_grp.replace_tag(l_subcomponent_version);

807: l_bind_val(27) := jtf_fm_request_grp.replace_tag(l_subcomponent_description);
808:
809: l_bind_var(28) := 'SUBCOMPONENT_VERSION';
810: l_bind_var_type(28) := 'VARCHAR2';
811: l_bind_val(28) := jtf_fm_request_grp.replace_tag(l_subcomponent_version);
812:
813: -- Fix for bug 3251623 . prayadur . 02/25/04
814: -- Commented out. XML content should not be manually built
815: /***********************************************************************

Line 832: l_content_xml := l_content_xml || '';

828: end if;
829:
830: l_content_xml := l_content_xml || '';
831: l_content_xml := l_content_xml || '';
832: l_content_xml := l_content_xml || '';
833: l_content_xml := l_content_xml || '';
834: l_content_xml := l_content_xml || '';
835:
836:

Line 868: JTF_FM_REQUEST_GRP.Get_Content_XML

864: -- Removed the XML getting created and instead calling GET_CONTENT_XML
865: l_request_type := 'DATA' ; -- 'Query' if Query is attached to your document, else DATA
866: l_document_type := 'html'; -- Master Documents are usually htm or html files
867:
868: JTF_FM_REQUEST_GRP.Get_Content_XML
869: (
870: p_api_version => l_api_version,
871: x_return_status => l_return_status,
872: x_msg_count => l_msg_count,

Line 902: JTF_FM_REQUEST_GRP.Submit_Request

898:
899: -- End of fix for bug 3251623.
900:
901: -- Submit the fulfillment request
902: JTF_FM_REQUEST_GRP.Submit_Request
903: ( p_api_version => l_api_version,
904: p_commit => l_commit,
905: x_return_status => l_return_status,
906: x_msg_count => l_msg_count,

Line 996: JTF_FM_REQUEST_GRP.Resubmit_Request( p_api_version => l_api_version,

992: x_return_status := FND_API.G_RET_STS_SUCCESS;
993:
994: -- Resubmit the fulfillment request
995:
996: JTF_FM_REQUEST_GRP.Resubmit_Request( p_api_version => l_api_version,
997: p_commit => l_commit,
998: x_return_status => l_return_status,
999: x_msg_count => l_msg_count,
1000: x_msg_data => l_msg_data,