DBA Data[Home] [Help]

APPS.CS_KB_WF_PKG dependencies on JTF_NUMBER_TABLE

Line 723: p_group_id OUT NOCOPY JTF_NUMBER_TABLE,

719: -- p_group_id = group ids
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:

Line 729: t_group_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

725: )
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;

Line 814: p_flow_details_id OUT NOCOPY JTF_NUMBER_TABLE,

810: -- p_action - NOT(NOTIFY),PUB(PUBLISH),OBS(OBSOLETE)
811: /*******************************************************************/
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

Line 815: p_order_num OUT NOCOPY JTF_NUMBER_TABLE,

811: /*******************************************************************/
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: )

Line 817: p_group_id OUT NOCOPY JTF_NUMBER_TABLE,

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
821: --tables to return

Line 822: t_flow_details_id JTF_NUMBER_TABLE := 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();
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();

Line 823: t_order_num JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

819: )
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:

Line 825: t_group_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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:
829: CURSOR DETAILS_TABLE IS

Line 904: p_flow_id OUT NOCOPY JTF_NUMBER_TABLE,

900: -- p_flow_id (id that is needed when updates are made)
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

Line 909: t_flow_id JTF_NUMBER_TABLE := 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();
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