22: l_WORKITEM_INSTANCE_ID := to_number(DOCUMENT_ID);
23:
24: -- Get the starting and ending number from WI parameters
25: l_starting_number :=
26: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
27: (l_WORKITEM_INSTANCE_ID
28: ,'STARTING_NUMBER'
29: );
30:
28: ,'STARTING_NUMBER'
29: );
30:
31: l_ending_number :=
32: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
33: (l_WORKITEM_INSTANCE_ID
34: ,'ENDING_NUMBER'
35: );
36:
34: ,'ENDING_NUMBER'
35: );
36:
37: l_PORTING_TIME :=
38: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
39: (l_WORKITEM_INSTANCE_ID
40: ,'PORTING_TIME'
41: );
42:
42:
43:
44: IF l_PORTING_TIME IS NULL THEN
45: l_PORTING_TIME :=
46: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
47: (l_WORKITEM_INSTANCE_ID
48: ,'NEW_SP_DUE_DATE'
49: );
50: END IF;
100: l_WORKITEM_INSTANCE_ID := to_number(DOCUMENT_ID);
101:
102: -- Get the starting and ending number from WI parameters
103: l_starting_number :=
104: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
105: (l_WORKITEM_INSTANCE_ID
106: ,'STARTING_NUMBER'
107: );
108:
106: ,'STARTING_NUMBER'
107: );
108:
109: l_ending_number :=
110: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
111: (l_WORKITEM_INSTANCE_ID
112: ,'ENDING_NUMBER'
113: );
114:
112: ,'ENDING_NUMBER'
113: );
114:
115: l_ORDER_RESULT :=
116: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
117: (l_WORKITEM_INSTANCE_ID
118: ,'ORDER_RESULT'
119: );
120:
169: l_WORKITEM_INSTANCE_ID := to_number(DOCUMENT_ID);
170:
171: -- Get the starting and ending number from WI parameters
172: l_starting_number :=
173: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
174: (l_WORKITEM_INSTANCE_ID
175: ,'STARTING_NUMBER'
176: );
177:
175: ,'STARTING_NUMBER'
176: );
177:
178: l_ending_number :=
179: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
180: (l_WORKITEM_INSTANCE_ID
181: ,'ENDING_NUMBER'
182: );
183:
181: ,'ENDING_NUMBER'
182: );
183:
184: l_ORDER_REJECT_EXPLN :=
185: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
186: (l_WORKITEM_INSTANCE_ID
187: ,'ORDER_REJECT_EXPLN'
188: );
189:
237: l_WORKITEM_INSTANCE_ID := to_number(DOCUMENT_ID);
238:
239: -- Get the starting and ending number from WI parameters
240: l_starting_number :=
241: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
242: (l_WORKITEM_INSTANCE_ID
243: ,'STARTING_NUMBER'
244: );
245:
243: ,'STARTING_NUMBER'
244: );
245:
246: l_ending_number :=
247: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
248: (l_WORKITEM_INSTANCE_ID
249: ,'ENDING_NUMBER'
250: );
251:
296: l_WORKITEM_INSTANCE_ID := to_number(DOCUMENT_ID);
297:
298: -- Get the starting and ending number from WI parameters
299: l_starting_number :=
300: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
301: (l_WORKITEM_INSTANCE_ID
302: ,'STARTING_NUMBER'
303: );
304:
302: ,'STARTING_NUMBER'
303: );
304:
305: l_ending_number :=
306: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
307: (l_WORKITEM_INSTANCE_ID
308: ,'ENDING_NUMBER'
309: );
310:
448: l_WORKITEM_INSTANCE_ID := to_number(DOCUMENT_ID);
449:
450: -- Get the starting and ending number from WI parameters
451: l_starting_number :=
452: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
453: (l_WORKITEM_INSTANCE_ID
454: ,'STARTING_NUMBER'
455: );
456:
454: ,'STARTING_NUMBER'
455: );
456:
457: l_ending_number :=
458: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
459: (l_WORKITEM_INSTANCE_ID
460: ,'ENDING_NUMBER'
461: );
462: