[Home] [Help]
PACKAGE: APPS.OE_WF_UPGRADE_UTIL
Source
1 PACKAGE OE_WF_UPGRADE_UTIL AUTHID CURRENT_USER as
2 /* $Header: OEXWUPGS.pls 120.0 2005/06/01 02:47:32 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_WF_UPGRADE_UTIL';
5
6 -- Cycle Result
7 RES_NOT_APPLICABLE CONSTANT NUMBER := 8;
8 RES_FAIL_NOT_APPLICABLE CONSTANT NUMBER := 24;
9 RES_ELIGIBLE CONSTANT NUMBER := 18;
10 RES_PARTIAL CONSTANT NUMBER := 5;
11 RES_CONFIRMED CONSTANT NUMBER := 6;
12 RES_COMPLETE CONSTANT NUMBER := 11;
13 RES_INTERFACED CONSTANT NUMBER := 14;
14 RES_WORK_ORDER_COMPLETED CONSTANT NUMBER := 19;
15
16
17 PROCEDURE UPGRADE_CUSTOM_ACTIVITY_BLOCK(
18 itemtype in varchar2,
19 itemkey in varchar2,
20 actid in number,
21 funcmode in varchar2,
22 resultout in out nocopy varchar2);/* file.sql.39 change */
23
24 PROCEDURE UPGRADE_PRE_APPROVAL(
25 itemtype in varchar2,
26 itemkey in varchar2,
27 actid in number,
28 funcmode in varchar2,
29 resultout in out nocopy varchar2); /* file.sql.39 change */
30
31 PROCEDURE IS_ORDER_PAST_BOOKING(
32 itemtype in varchar2,
33 itemkey in varchar2,
34 actid in number,
35 funcmode in varchar2,
36 resultout in out nocopy varchar2);/* file.sql.39 change */
37
38 PROCEDURE IS_LINE_PAST_SHIPPING(
39 itemtype in varchar2,
40 itemkey in varchar2,
41 actid in number,
42 funcmode in varchar2,
43 resultout in out nocopy varchar2);/* file.sql.39 change */
44
45 PROCEDURE IS_LINE_SHIP_ELIGIBLE(
46 itemtype in varchar2,
47 itemkey in varchar2,
48 actid in number,
49 funcmode in varchar2,
50 resultout in out nocopy varchar2);/* file.sql.39 change */
51
52 PROCEDURE IS_RETURN_RECEIVED(
53 itemtype in varchar2,
54 itemkey in varchar2,
55 actid in number,
56 funcmode in varchar2,
57 resultout in out nocopy varchar2);/* file.sql.39 change */
58
59 PROCEDURE IS_RETURN_INSPECTED(
60 itemtype in varchar2,
61 itemkey in varchar2,
62 actid in number,
63 funcmode in varchar2,
64 resultout in out nocopy varchar2);/* file.sql.39 change */
65
66 PROCEDURE IS_LINE_PAST_INVOICING(
67 itemtype in varchar2,
68 itemkey in varchar2,
69 actid in number,
70 funcmode in varchar2,
71 resultout in out nocopy varchar2);/* file.sql.39 change */
72
73 PROCEDURE IS_ORDER_CLOSED(
74 itemtype in varchar2,
75 itemkey in varchar2,
76 actid in number,
77 funcmode in varchar2,
78 resultout in out nocopy varchar2);/* file.sql.39 change */
79
80 PROCEDURE IS_LINE_CLOSED(
81 itemtype in varchar2,
82 itemkey in varchar2,
83 actid in number,
84 funcmode in varchar2,
85 resultout in out nocopy varchar2);/* file.sql.39 change */
86
87 PROCEDURE IS_LINE_PAST_DEMAND_IFACE(
88 itemtype in varchar2,
89 itemkey in varchar2,
90 actid in number,
91 funcmode in varchar2,
92 resultout in out nocopy varchar2);/* file.sql.39 change */
93
94 PROCEDURE CHECK_PUR_REL_STATUS(
95 itemtype in varchar2,
96 itemkey in varchar2,
97 actid in number,
98 funcmode in varchar2,
99 resultout in out nocopy varchar2);/* file.sql.39 change */
100
101 PROCEDURE CHK_MFG_RELEASE_STS(
102 itemtype in varchar2,
103 itemkey in varchar2,
104 actid in number,
105 funcmode in varchar2,
106 resultout in out nocopy varchar2);/* file.sql.39 change */
107
108 PROCEDURE IS_LINE_PAST_MFG_RELEASE(
109 itemtype in varchar2,
110 itemkey in varchar2,
111 actid in number,
112 funcmode in varchar2,
113 resultout in out nocopy varchar2);/* file.sql.39 change */
114
115 PROCEDURE IS_LINE_ATO_MODEL(
116 itemtype in varchar2,
117 itemkey in varchar2,
118 actid in number,
119 funcmode in varchar2,
120 resultout in out nocopy varchar2);/* file.sql.39 change */
121
122 PROCEDURE IS_MODE_UPGRADE(
123 itemtype in varchar2,
124 itemkey in varchar2,
125 actid in number,
126 funcmode in varchar2,
127 resultout in out nocopy varchar2);/* file.sql.39 change */
128
129 END OE_WF_UPGRADE_UTIL;