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;