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_KB_WF_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 661: p_action_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,

657: -- p_action_code = group ids
658: -- p_action_name = group names
659: /*******************************************************************/
660: PROCEDURE Get_Actions(
661: p_action_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,
662: p_action_name OUT NOCOPY JTF_VARCHAR2_TABLE_100)
663: IS
664: l_resp_id number;
665: l_application_id number := 170;

Line 662: p_action_name OUT NOCOPY JTF_VARCHAR2_TABLE_100)

658: -- p_action_name = group names
659: /*******************************************************************/
660: PROCEDURE Get_Actions(
661: p_action_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,
662: p_action_name OUT NOCOPY JTF_VARCHAR2_TABLE_100)
663: IS
664: l_resp_id number;
665: l_application_id number := 170;
666: l_region_code varchar2(30) := 'CS_KB_WF_ACTION';

Line 671: code JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

667: l_user_id number := fnd_global.user_id;
668: region_name varchar2(50);
669: empty_str varchar2(30) := ' ';
670: items_table jtf_region_pub.ak_region_items_table;
671: code JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
672: name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
673: BEGIN
674:
675: l_resp_id := FND_PROFILE.VALUE_SPECIFIC(

Line 672: name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

668: region_name varchar2(50);
669: empty_str varchar2(30) := ' ';
670: items_table jtf_region_pub.ak_region_items_table;
671: code JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
672: name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
673: BEGIN
674:
675: l_resp_id := FND_PROFILE.VALUE_SPECIFIC(
676: 'JTF_PROFILE_DEFAULT_RESPONSIBILITY',

Line 724: p_group_name OUT NOCOPY JTF_VARCHAR2_TABLE_100

720: -- p_group_name = group names
721: /*******************************************************************/
722: PROCEDURE Get_All_Groups(
723: p_group_id OUT NOCOPY JTF_NUMBER_TABLE,
724: p_group_name OUT NOCOPY JTF_VARCHAR2_TABLE_100
725: )
726: IS
727:
728: -- Create the table variables to hold returnable info.

Line 730: t_group_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

726: IS
727:
728: -- Create the table variables to hold returnable info.
729: t_group_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
730: t_group_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
731:
732: -- Temp variables to use to populate table variables
733: gi NUMBER;
734: gn JTF_RS_GROUPS_TL.GROUP_NAME%TYPE;

Line 793: p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,

789: -- above list of codes.
790: /*******************************************************************/
791:
792: PROCEDURE Get_All_Steps(
793: p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,
794: p_step_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
795: )
796: IS
797: BEGIN

Line 794: p_step_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

790: /*******************************************************************/
791:
792: PROCEDURE Get_All_Steps(
793: p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,
794: p_step_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
795: )
796: IS
797: BEGIN
798: Get_Step_List(0,p_step,p_step_names);

Line 816: p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,

812: PROCEDURE Get_Flow_Details(
813: p_flow_id IN NUMBER,
814: p_flow_details_id OUT NOCOPY JTF_NUMBER_TABLE,
815: p_order_num OUT NOCOPY JTF_NUMBER_TABLE,
816: p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,
817: p_group_id OUT NOCOPY JTF_NUMBER_TABLE,
818: p_action OUT NOCOPY JTF_VARCHAR2_TABLE_100
819: )
820: IS

Line 818: p_action OUT NOCOPY JTF_VARCHAR2_TABLE_100

814: p_flow_details_id OUT NOCOPY JTF_NUMBER_TABLE,
815: p_order_num OUT NOCOPY JTF_NUMBER_TABLE,
816: p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,
817: p_group_id OUT NOCOPY JTF_NUMBER_TABLE,
818: p_action OUT NOCOPY JTF_VARCHAR2_TABLE_100
819: )
820: IS
821: --tables to return
822: t_flow_details_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 824: t_step JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

820: IS
821: --tables to return
822: t_flow_details_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
823: t_order_num JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
824: t_step JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
825: t_group_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
826: t_action JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
827:
828:

Line 826: t_action JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

822: t_flow_details_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
823: t_order_num JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
824: t_step JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
825: t_group_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
826: t_action JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
827:
828:
829: CURSOR DETAILS_TABLE IS
830: SELECT

Line 905: p_flow_name OUT NOCOPY JTF_VARCHAR2_TABLE_100

901: -- p_flow_name (name to display)
902: /*******************************************************************/
903: PROCEDURE Get_Flows(
904: p_flow_id OUT NOCOPY JTF_NUMBER_TABLE,
905: p_flow_name OUT NOCOPY JTF_VARCHAR2_TABLE_100
906: )
907: IS
908: --tables to return
909: t_flow_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 910: t_flow_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

906: )
907: IS
908: --tables to return
909: t_flow_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
910: t_flow_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
911:
912: CURSOR FLOWS_TABLE IS
913: select b.flow_id, t.name
914: from cs_kb_wf_flows_b b,

Line 1072: p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1068: /*******************************************************************/
1069:
1070: PROCEDURE Get_Step_List(
1071: p_restriction IN NUMBER,
1072: p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1073: p_step_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
1074: )
1075: IS
1076:

Line 1073: p_step_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

1069:
1070: PROCEDURE Get_Step_List(
1071: p_restriction IN NUMBER,
1072: p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1073: p_step_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
1074: )
1075: IS
1076:
1077: -- Create the table variables to hold returnable info.

Line 1078: t_step JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1074: )
1075: IS
1076:
1077: -- Create the table variables to hold returnable info.
1078: t_step JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1079: t_step_names JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1080:
1081: steps INTEGER;
1082: cursorReturn INTEGER;

Line 1079: t_step_names JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1075: IS
1076:
1077: -- Create the table variables to hold returnable info.
1078: t_step JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1079: t_step_names JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1080:
1081: steps INTEGER;
1082: cursorReturn INTEGER;
1083: