DBA Data[Home] [Help]

PACKAGE: APPS.WSH_FLEX_UPGR_COGS

Source


1 PACKAGE WSH_FLEX_UPGR_COGS AUTHID CURRENT_USER AS
2 /* $Header: WSHWFUPS.pls 115.1 99/07/16 08:24:52 porting shi $ */
3 --
4 -- Package
5 --   WSH_FLEX_UPGR_COGS
6 -- Purpose
7 --   Will contain routines to upgrade an existing flexbuilder function
8 --   for the COGS Account
9 -- History
10 --   7-AUG-97  ADATTA    CREATED
11 --
12 
13 --
14 -- PUBLIC VARIABLES
15 --
16 
17 --
18 -- PUBLIC FUNCTIONS
19 --
20 
21 -- Name
22 --   UPGRADE_COGS_FLEX
23 -- Purpose
24 -- To upgrade an existing flexbuilder function
25 -- Arguments
26 --    Internal Name for the WF Item Type
27 --    WF Item Key
28 --    ID Number of thw WF activity
29 --    Result
30 
31      PROCEDURE UPGRADE_COGS_FLEX(ITEMTYPE  IN VARCHAR2,
32 	    	   ITEMKEY	IN VARCHAR2,
33 		   ACTID	     IN NUMBER,
34 		   FUNCMODE    IN VARCHAR2,
35 		   RESULT      OUT VARCHAR2);
36 -- Name
37 --   BUILD
38 -- Purpose
39 -- Ts is a stub build function that returns a value FALSE and
40 -- sets the value of the output varriable FB_FLEX_SEGto NULL and
41 -- output error message variable FB_ERROR_MSG to the AOL error
42 -- message FLEXWK-UPGRADE FUNC MISSING. This will ensure that the
43 -- user will get an appropriate error message if they try to use
44 -- the FLEXBUILDER_UPGRADE process without creating the conversion
45 -- package successfully.   o upgrade an existing flexbuilder function
46 -- Arguments
47 --    Flexfield  Structure Number
48 --    Commitment ID
49 --    Customrer ID
50 --    Header ID
51 --    Line Detail ID
52 --    Option Flag
53 --    Order Category
54 --    Line ID
55 --    Order Type ID
56 --    Organization ID
57 --    Picking Line Detail ID
58 --    Flexfield Segments
59 --    Error Message
60 
61       FUNCTION BUILD (
62       FB_FLEX_NUM IN NUMBER DEFAULT 101,
63       OE_II_COMMITMENT_ID_RAW IN VARCHAR2 DEFAULT NULL,
64       OE_II_CUSTOMER_ID_RAW IN VARCHAR2 DEFAULT NULL,
65       OE_II_HEADER_ID_RAW IN VARCHAR2 DEFAULT NULL,
66       OE_II_LINE_DETAIL_ID_RAW IN VARCHAR2 DEFAULT NULL,
67       OE_II_OPTION_FLAG_RAW IN VARCHAR2 DEFAULT NULL,
68       OE_II_ORDER_CATEGORY_RAW IN VARCHAR2 DEFAULT NULL,
69       OE_II_ORDER_LINE_ID_RAW IN VARCHAR2 DEFAULT NULL,
70       OE_II_ORDER_TYPE_ID_RAW IN VARCHAR2 DEFAULT NULL,
71       OE_II_ORGANIZATION_ID_RAW IN VARCHAR2 DEFAULT NULL,
72       OE_II_PICK_LINE_DETAIL_ID_RAW IN VARCHAR2 DEFAULT NULL,
73       FB_FLEX_SEG IN OUT VARCHAR2,
74       FB_ERROR_MSG IN OUT VARCHAR2)
75 	 RETURN BOOLEAN;
76 END WSH_FLEX_UPGR_COGS;