[Home] [Help]
PACKAGE: APPS.XDPCORE_LINE
Source
1 PACKAGE XDPCORE_LINE AUTHID CURRENT_USER AS
2 /* $Header: XDPCORLS.pls 120.1 2005/06/08 23:48:12 appldev $ */
3
4
5
6 e_NullValueException EXCEPTION;
7
8
9
10
11 x_ErrMsg VARCHAR2(2000);
12 x_DebugMsg VARCHAR2(2000);
13
14
15 cursor c_LineSeqNullBundle(OrderID number, LineSeq number) is
16 select LINE_ITEM_ID, LINE_NUMBER, LINE_ITEM_NAME, IS_PACKAGE_FLAG, LINE_SEQUENCE ,
17 IB_SOURCE , NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
18 from XDP_ORDER_LINE_ITEMS
19 where ORDER_ID = OrderID
20 and status_code = 'READY'
21 and IS_VIRTUAL_LINE_FLAG = 'N'
22 and BUNDLE_ID is null
23 and LINE_SEQUENCE = (
24 select MIN(LINE_SEQUENCE)
25 from XDP_ORDER_LINE_ITEMS
26 where ORDER_ID = OrderID
27 and status_code = 'READY'
28 and IS_VIRTUAL_LINE_FLAG = 'N'
29 and BUNDLE_ID is null
30 and LINE_SEQUENCE > LineSeq);
31
32 cursor c_LineSeqForBundle(OrderID number, BundleID number, LineSeq number) is
33 select LINE_ITEM_ID, LINE_NUMBER, LINE_ITEM_NAME, IS_PACKAGE_FLAG, LINE_SEQUENCE ,
34 IB_SOURCE , NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
35 from XDP_ORDER_LINE_ITEMS
36 where ORDER_ID = OrderID
37 and status_code = 'READY'
38 and IS_VIRTUAL_LINE_FLAG = 'N'
39 and BUNDLE_ID = BundleID
40 and LINE_SEQUENCE = (
41 select MIN(LINE_SEQUENCE)
42 from XDP_ORDER_LINE_ITEMS
43 where ORDER_ID = OrderID
44 and status_code = 'READY'
45 and IS_VIRTUAL_LINE_FLAG = 'N'
46 and BUNDLE_ID = BundleID
47 and LINE_SEQUENCE > LineSeq);
48
49 cursor c_LineSeq(OrderID number, LineSeq number) is
50 select LINE_ITEM_ID, LINE_NUMBER, LINE_ITEM_NAME, IS_PACKAGE_FLAG, LINE_SEQUENCE,
51 IB_SOURCE,NVL(IB_SOURCE_ID,-999) IB_SOURCE_ID
52 from XDP_ORDER_LINE_ITEMS
53 where ORDER_ID = OrderID
54 and status_code = 'READY'
55 and IS_VIRTUAL_LINE_FLAG = 'N'
56 and LINE_SEQUENCE = (
57 select MIN(LINE_SEQUENCE)
58 from XDP_ORDER_LINE_ITEMS
59 where ORDER_ID = OrderID
60 and status_code = 'READY'
61 and IS_VIRTUAL_LINE_FLAG = 'N'
62 and LINE_SEQUENCE > LineSeq);
63
64 -- ARE_ALL_LINES_DONE
65 -- Resultout
66 -- Activity Performed - Activity was completed without any errors
67 --
68 -- Your Description here:
69
70
71 Procedure ARE_ALL_LINES_DONE (itemtype in varchar2,
72 itemkey in varchar2,
73 actid in number,
74 funcmode in varchar2,
75 resultout OUT NOCOPY varchar2);
76
77
78 -- LAUNCH_LINEITEM_PROCESS
79 -- Resultout
80 -- Activity Performed - Activity was completed without any errors
81 --
82 -- Your Description here:
83
84
85 Procedure LAUNCH_LINEITEM_PROCESS (itemtype in varchar2,
86 itemkey in varchar2,
87 actid in number,
88 funcmode in varchar2,
89 resultout OUT NOCOPY varchar2);
90
91
92 -- INITIALIZE_LINE
93 -- Resultout
94 -- Activity Performed - Activity was completed without any errors
95 --
96 -- Your Description here:
97
98
99 Procedure INITIALIZE_LINE (itemtype in varchar2,
100 itemkey in varchar2,
101 actid in number,
102 funcmode in varchar2,
103 resultout OUT NOCOPY varchar2);
104
105 -- IS_LINE_A_PACKAGE
106 -- Resultout
107 -- Activity Performed - Activity was completed without any errors
108 --
109 -- Your Description here:
110
111
112 Procedure IS_LINE_A_PACKAGE (itemtype in varchar2,
113 itemkey in varchar2,
114 actid in number,
115 funcmode in varchar2,
116 resultout OUT NOCOPY varchar2);
117
118
119
120 -- LAUNCH_LINE_FOR_ORDER_PROCESS
121 -- Resultout
122 -- Activity Performed - Activity was completed without any errors
123 --
124 -- Your Description here:
125
126
127 Procedure LAUNCH_LINE_FOR_ORDER_PROCESS (itemtype in varchar2,
128 itemkey in varchar2,
129 actid in number,
130 funcmode in varchar2,
131 resultout OUT NOCOPY varchar2);
132
133 -- LAUNCH_SERVICE_PROCESS
134 -- Resultout
135 -- Activity Performed - Activity was completed without any errors
136 --
137 -- Your Description here:
138
139
140 Procedure LAUNCH_SERVICE_PROCESS (itemtype in varchar2,
141 itemkey in varchar2,
142 actid in number,
143 funcmode in varchar2,
144 resultout OUT NOCOPY varchar2);
145
146
147
148 Procedure UPDATE_INSTALL_BASE (itemtype in varchar2,
149 itemkey in varchar2,
150 actid in number,
151 funcmode in varchar2,
152 resultout OUT NOCOPY varchar2);
153
154 Procedure LAUNCH_ALL_IND_LINES (itemtype in varchar2,
155 itemkey in varchar2,
156 actid in number,
157 funcmode in varchar2,
158 resultout OUT NOCOPY varchar2);
159
160 Procedure INITIALIZE_DEP_LINE_PROCESS (itemtype in varchar2,
161 itemkey in varchar2,
162 actid in number,
163 funcmode in varchar2,
164 resultout OUT NOCOPY varchar2);
165
166 Procedure RESOLVE_IND_DEP_LINES (itemtype in varchar2,
167 itemkey in varchar2,
168 actid in number,
169 funcmode in varchar2,
170 resultout OUT NOCOPY varchar2);
171
172 Procedure IS_SER_PART_PACKAGE (itemtype in varchar2,
173 itemkey in varchar2,
174 actid in number,
175 funcmode in varchar2,
176 resultout OUT NOCOPY varchar2);
177
178 -- **************** PUBLISH_XDP_LINE_DONE *********************
179
180 PROCEDURE PUBLISH_XDP_LINE_DONE
181 (itemtype IN VARCHAR2,
182 itemkey IN VARCHAR2,
183 actid IN NUMBER,
184 funcmode IN VARCHAR2,
185 resultout OUT NOCOPY VARCHAR2) ;
186
187 End XDPCORE_LINE;