DBA Data[Home] [Help]

APPS.CCT_PRODUCTINIT_PUB dependencies on WF_ENGINE

Line 33: resultout := wf_engine.eng_completed || ':N';

29: l_cct_prod_id_key VARCHAR2(64):='CUSTOMERPRODUCTID';
30: l_cct_object_type VARCHAR2(64):='REFERENCENUM';
31: BEGIN
32: -- set default result
33: resultout := wf_engine.eng_completed || ':N';
34: IF (funmode = 'RUN') THEN
35: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
36: IF (l_app_object_value IS NOT NULL) THEN
37: l_prod_id:=CSC_ROUTING_UTL.Get_CP_From_ReferenceNum(p_Reference_Number=>l_app_object_value) ;

Line 35: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);

31: BEGIN
32: -- set default result
33: resultout := wf_engine.eng_completed || ':N';
34: IF (funmode = 'RUN') THEN
35: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
36: IF (l_app_object_value IS NOT NULL) THEN
37: l_prod_id:=CSC_ROUTING_UTL.Get_CP_From_ReferenceNum(p_Reference_Number=>l_app_object_value) ;
38: IF (l_prod_id IS NOT NULL) THEN
39: resultout := wf_engine.eng_completed || ':Y';

Line 39: resultout := wf_engine.eng_completed || ':Y';

35: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
36: IF (l_app_object_value IS NOT NULL) THEN
37: l_prod_id:=CSC_ROUTING_UTL.Get_CP_From_ReferenceNum(p_Reference_Number=>l_app_object_value) ;
38: IF (l_prod_id IS NOT NULL) THEN
39: resultout := wf_engine.eng_completed || ':Y';
40: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
41: END IF;
42: END IF;
43:

Line 40: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );

36: IF (l_app_object_value IS NOT NULL) THEN
37: l_prod_id:=CSC_ROUTING_UTL.Get_CP_From_ReferenceNum(p_Reference_Number=>l_app_object_value) ;
38: IF (l_prod_id IS NOT NULL) THEN
39: resultout := wf_engine.eng_completed || ':Y';
40: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
41: END IF;
42: END IF;
43:
44: END IF;

Line 76: resultout := wf_engine.eng_completed || ':N';

72: l_cct_prod_id_key VARCHAR2(64):='CUSTOMERPRODUCTID';
73: l_cct_object_type VARCHAR2(64):='SERVICEREQUESTNUM';
74: BEGIN
75: -- set default result
76: resultout := wf_engine.eng_completed || ':N';
77: IF (funmode = 'RUN') THEN
78: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
79: IF (l_app_object_value IS NOT NULL) THEN
80: l_prod_id:=CS_ROUTING_UTL.Get_CP_From_RequestNum

Line 78: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);

74: BEGIN
75: -- set default result
76: resultout := wf_engine.eng_completed || ':N';
77: IF (funmode = 'RUN') THEN
78: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
79: IF (l_app_object_value IS NOT NULL) THEN
80: l_prod_id:=CS_ROUTING_UTL.Get_CP_From_RequestNum
81: (p_Request_Number =>l_app_object_value) ;
82: IF (l_prod_id IS NOT NULL) THEN

Line 83: resultout := wf_engine.eng_completed || ':Y';

79: IF (l_app_object_value IS NOT NULL) THEN
80: l_prod_id:=CS_ROUTING_UTL.Get_CP_From_RequestNum
81: (p_Request_Number =>l_app_object_value) ;
82: IF (l_prod_id IS NOT NULL) THEN
83: resultout := wf_engine.eng_completed || ':Y';
84: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
85: END IF;
86: END IF;
87:

Line 84: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );

80: l_prod_id:=CS_ROUTING_UTL.Get_CP_From_RequestNum
81: (p_Request_Number =>l_app_object_value) ;
82: IF (l_prod_id IS NOT NULL) THEN
83: resultout := wf_engine.eng_completed || ':Y';
84: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
85: END IF;
86: END IF;
87:
88: END IF;

Line 120: resultout := wf_engine.eng_completed || ':N';

116: l_cct_prod_id_key VARCHAR2(64):='CUSTOMERPRODUCTID';
117: l_cct_object_type VARCHAR2(64):='SERIALNUM';
118: BEGIN
119: -- set default result
120: resultout := wf_engine.eng_completed || ':N';
121: IF (funmode = 'RUN') THEN
122: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
123: IF (l_app_object_value IS NOT NULL) THEN
124: l_prod_id:=CS_ROUTING_UTL.Get_CP_From_SerialNum

Line 122: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);

118: BEGIN
119: -- set default result
120: resultout := wf_engine.eng_completed || ':N';
121: IF (funmode = 'RUN') THEN
122: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
123: IF (l_app_object_value IS NOT NULL) THEN
124: l_prod_id:=CS_ROUTING_UTL.Get_CP_From_SerialNum
125: ( p_Serial_Number =>l_app_object_value) ;
126: IF (l_prod_id IS NOT NULL) THEN

Line 127: resultout := wf_engine.eng_completed || ':Y';

123: IF (l_app_object_value IS NOT NULL) THEN
124: l_prod_id:=CS_ROUTING_UTL.Get_CP_From_SerialNum
125: ( p_Serial_Number =>l_app_object_value) ;
126: IF (l_prod_id IS NOT NULL) THEN
127: resultout := wf_engine.eng_completed || ':Y';
128: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
129: END IF;
130: END IF;
131:

Line 128: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );

124: l_prod_id:=CS_ROUTING_UTL.Get_CP_From_SerialNum
125: ( p_Serial_Number =>l_app_object_value) ;
126: IF (l_prod_id IS NOT NULL) THEN
127: resultout := wf_engine.eng_completed || ':Y';
128: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
129: END IF;
130: END IF;
131:
132: END IF;

Line 163: resultout := wf_engine.eng_completed || ':N';

159: l_cct_prod_id_key VARCHAR2(64):='INVENTORYITEMID';
160: l_cct_object_type VARCHAR2(64):='REFERENCENUM';
161: BEGIN
162: -- set default result
163: resultout := wf_engine.eng_completed || ':N';
164: IF (funmode = 'RUN') THEN
165: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
166: IF (l_app_object_value IS NOT NULL) THEN
167: l_prod_id:= CSC_ROUTING_UTL.Get_Product_From_ReferenceNum (

Line 165: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);

161: BEGIN
162: -- set default result
163: resultout := wf_engine.eng_completed || ':N';
164: IF (funmode = 'RUN') THEN
165: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
166: IF (l_app_object_value IS NOT NULL) THEN
167: l_prod_id:= CSC_ROUTING_UTL.Get_Product_From_ReferenceNum (
168: p_Reference_Number =>l_app_object_value) ;
169: IF (l_prod_id IS NOT NULL) THEN

Line 170: resultout := wf_engine.eng_completed || ':Y';

166: IF (l_app_object_value IS NOT NULL) THEN
167: l_prod_id:= CSC_ROUTING_UTL.Get_Product_From_ReferenceNum (
168: p_Reference_Number =>l_app_object_value) ;
169: IF (l_prod_id IS NOT NULL) THEN
170: resultout := wf_engine.eng_completed || ':Y';
171: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
172: END IF;
173: END IF;
174:

Line 171: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );

167: l_prod_id:= CSC_ROUTING_UTL.Get_Product_From_ReferenceNum (
168: p_Reference_Number =>l_app_object_value) ;
169: IF (l_prod_id IS NOT NULL) THEN
170: resultout := wf_engine.eng_completed || ':Y';
171: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
172: END IF;
173: END IF;
174:
175: END IF;

Line 206: resultout := wf_engine.eng_completed || ':N';

202: l_cct_prod_id_key VARCHAR2(64):='INVENTORYITEMID';
203: l_cct_object_type VARCHAR2(64):='SERVICEREQUESTNUM';
204: BEGIN
205: -- set default result
206: resultout := wf_engine.eng_completed || ':N';
207: IF (funmode = 'RUN') THEN
208: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
209: IF (l_app_object_value IS NOT NULL) THEN
210: l_prod_id:= CS_ROUTING_UTL.Get_Product_From_RequestNum

Line 208: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);

204: BEGIN
205: -- set default result
206: resultout := wf_engine.eng_completed || ':N';
207: IF (funmode = 'RUN') THEN
208: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
209: IF (l_app_object_value IS NOT NULL) THEN
210: l_prod_id:= CS_ROUTING_UTL.Get_Product_From_RequestNum
211: (p_Request_Number =>l_app_object_value) ;
212: IF (l_prod_id IS NOT NULL) THEN

Line 213: resultout := wf_engine.eng_completed || ':Y';

209: IF (l_app_object_value IS NOT NULL) THEN
210: l_prod_id:= CS_ROUTING_UTL.Get_Product_From_RequestNum
211: (p_Request_Number =>l_app_object_value) ;
212: IF (l_prod_id IS NOT NULL) THEN
213: resultout := wf_engine.eng_completed || ':Y';
214: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
215: END IF;
216: END IF;
217:

Line 214: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );

210: l_prod_id:= CS_ROUTING_UTL.Get_Product_From_RequestNum
211: (p_Request_Number =>l_app_object_value) ;
212: IF (l_prod_id IS NOT NULL) THEN
213: resultout := wf_engine.eng_completed || ':Y';
214: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
215: END IF;
216: END IF;
217:
218: END IF;

Line 250: resultout := wf_engine.eng_completed || ':N';

246: l_cct_prod_id_key VARCHAR2(64):='INVENTORYITEMID';
247: l_cct_object_type VARCHAR2(64):='SERIALNUM';
248: BEGIN
249: -- set default result
250: resultout := wf_engine.eng_completed || ':N';
251: IF (funmode = 'RUN') THEN
252: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
253: IF (l_app_object_value IS NOT NULL) THEN
254: l_prod_id:= CS_ROUTING_UTL.Get_Product_From_SerialNum

Line 252: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);

248: BEGIN
249: -- set default result
250: resultout := wf_engine.eng_completed || ':N';
251: IF (funmode = 'RUN') THEN
252: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
253: IF (l_app_object_value IS NOT NULL) THEN
254: l_prod_id:= CS_ROUTING_UTL.Get_Product_From_SerialNum
255: (p_Serial_Number =>l_app_object_value) ;
256: IF (l_prod_id IS NOT NULL) THEN

Line 257: resultout := wf_engine.eng_completed || ':Y';

253: IF (l_app_object_value IS NOT NULL) THEN
254: l_prod_id:= CS_ROUTING_UTL.Get_Product_From_SerialNum
255: (p_Serial_Number =>l_app_object_value) ;
256: IF (l_prod_id IS NOT NULL) THEN
257: resultout := wf_engine.eng_completed || ':Y';
258: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
259: END IF;
260: END IF;
261:

Line 258: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );

254: l_prod_id:= CS_ROUTING_UTL.Get_Product_From_SerialNum
255: (p_Serial_Number =>l_app_object_value) ;
256: IF (l_prod_id IS NOT NULL) THEN
257: resultout := wf_engine.eng_completed || ':Y';
258: WF_ENGINE.SetItemAttrNumber(itemtype,itemkey,l_cct_prod_id_key,l_prod_id );
259: END IF;
260: END IF;
261:
262: END IF;

Line 294: resultout := wf_engine.eng_completed || ':N';

290: l_cct_object_type VARCHAR2(64):='CUSTOMERPRODUCTID';
291:
292: BEGIN
293: -- set default result
294: resultout := wf_engine.eng_completed || ':N';
295: IF (funmode = 'RUN') THEN
296: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
297: IF (l_app_object_value IS NOT NULL) THEN
298: resultout := wf_engine.eng_completed || ':Y';

Line 296: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);

292: BEGIN
293: -- set default result
294: resultout := wf_engine.eng_completed || ':N';
295: IF (funmode = 'RUN') THEN
296: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
297: IF (l_app_object_value IS NOT NULL) THEN
298: resultout := wf_engine.eng_completed || ':Y';
299: END IF;
300:

Line 298: resultout := wf_engine.eng_completed || ':Y';

294: resultout := wf_engine.eng_completed || ':N';
295: IF (funmode = 'RUN') THEN
296: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
297: IF (l_app_object_value IS NOT NULL) THEN
298: resultout := wf_engine.eng_completed || ':Y';
299: END IF;
300:
301: END IF;
302: END;

Line 332: resultout := wf_engine.eng_completed || ':N';

328: l_cct_object_type VARCHAR2(64):='INVENTORYITEMID';
329:
330: BEGIN
331: -- set default result
332: resultout := wf_engine.eng_completed || ':N';
333: IF (funmode = 'RUN') THEN
334: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
335: IF (l_app_object_value IS NOT NULL) THEN
336: resultout := wf_engine.eng_completed || ':Y';

Line 334: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);

330: BEGIN
331: -- set default result
332: resultout := wf_engine.eng_completed || ':N';
333: IF (funmode = 'RUN') THEN
334: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
335: IF (l_app_object_value IS NOT NULL) THEN
336: resultout := wf_engine.eng_completed || ':Y';
337: END IF;
338:

Line 336: resultout := wf_engine.eng_completed || ':Y';

332: resultout := wf_engine.eng_completed || ':N';
333: IF (funmode = 'RUN') THEN
334: l_app_object_value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,l_cct_object_type);
335: IF (l_app_object_value IS NOT NULL) THEN
336: resultout := wf_engine.eng_completed || ':Y';
337: END IF;
338:
339: END IF;
340: END;