eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CCT_ROUTINGWORKFLOW_PUB dependencies on WF_ENGINE

Line 179: l_itemkey := wf_engine.eng_synch;

175: --This step is redundant for Synchronous Workflow
176: -- 2:04 PM 2/13/99 Savvas Xenophontos
177: l_itemkey := Encode_Call_Itemkey(p_call_ID, l_wf_process_ID);
178: IF G_TEST_MODE <> 'ON' THEN
179: l_itemkey := wf_engine.eng_synch;
180: END IF;
181:
182: -- Create and launch the Workflow process
183: WF_ENGINE.CreateProcess(

Line 183: WF_ENGINE.CreateProcess(

179: l_itemkey := wf_engine.eng_synch;
180: END IF;
181:
182: -- Create and launch the Workflow process
183: WF_ENGINE.CreateProcess(
184: itemtype => l_itemtype,
185: itemkey => l_itemkey,
186: process => null );
187:

Line 189: WF_ENGINE.SetItemAttrNumber (l_itemtype, l_itemkey, 'MCM_ID', p_mcm_id);

185: itemkey => l_itemkey,
186: process => null );
187:
188: -- Set Item Attributes
189: WF_ENGINE.SetItemAttrNumber (l_itemtype, l_itemkey, 'MCM_ID', p_mcm_id);
190: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTMEDIAITEMID', p_call_id);
191:
192: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTANI', p_ANI);
193: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTACTNUM',p_contact_num);

Line 190: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTMEDIAITEMID', p_call_id);

186: process => null );
187:
188: -- Set Item Attributes
189: WF_ENGINE.SetItemAttrNumber (l_itemtype, l_itemkey, 'MCM_ID', p_mcm_id);
190: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTMEDIAITEMID', p_call_id);
191:
192: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTANI', p_ANI);
193: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTACTNUM',p_contact_num);
194: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTRACTNUM',

Line 192: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTANI', p_ANI);

188: -- Set Item Attributes
189: WF_ENGINE.SetItemAttrNumber (l_itemtype, l_itemkey, 'MCM_ID', p_mcm_id);
190: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTMEDIAITEMID', p_call_id);
191:
192: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTANI', p_ANI);
193: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTACTNUM',p_contact_num);
194: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTRACTNUM',
195: p_contract_num);
196: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID, p_customer_ID);

Line 193: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTACTNUM',p_contact_num);

189: WF_ENGINE.SetItemAttrNumber (l_itemtype, l_itemkey, 'MCM_ID', p_mcm_id);
190: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTMEDIAITEMID', p_call_id);
191:
192: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTANI', p_ANI);
193: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTACTNUM',p_contact_num);
194: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTRACTNUM',
195: p_contract_num);
196: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID, p_customer_ID);
197: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNAME',

Line 194: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTRACTNUM',

190: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTMEDIAITEMID', p_call_id);
191:
192: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTANI', p_ANI);
193: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTACTNUM',p_contact_num);
194: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTRACTNUM',
195: p_contract_num);
196: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID, p_customer_ID);
197: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNAME',
198: p_customer_name);

Line 196: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID, p_customer_ID);

192: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTANI', p_ANI);
193: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTACTNUM',p_contact_num);
194: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTRACTNUM',
195: p_contract_num);
196: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID, p_customer_ID);
197: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNAME',
198: p_customer_name);
199: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNUM',
200: p_customer_num);

Line 197: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNAME',

193: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTACTNUM',p_contact_num);
194: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CONTRACTNUM',
195: p_contract_num);
196: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID, p_customer_ID);
197: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNAME',
198: p_customer_name);
199: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNUM',
200: p_customer_num);
201: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'CUSTOMERPRODUCTID',

Line 199: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNUM',

195: p_contract_num);
196: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID, p_customer_ID);
197: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNAME',
198: p_customer_name);
199: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNUM',
200: p_customer_num);
201: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'CUSTOMERPRODUCTID',
202: p_customer_product_ID);
203: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTDNIS', p_DNIS);

Line 201: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'CUSTOMERPRODUCTID',

197: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNAME',
198: p_customer_name);
199: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNUM',
200: p_customer_num);
201: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'CUSTOMERPRODUCTID',
202: p_customer_product_ID);
203: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTDNIS', p_DNIS);
204: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'INVENTORYITEMID',
205: p_inventory_item_ID);

Line 203: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTDNIS', p_DNIS);

199: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'CUSTOMERNUM',
200: p_customer_num);
201: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'CUSTOMERPRODUCTID',
202: p_customer_product_ID);
203: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTDNIS', p_DNIS);
204: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'INVENTORYITEMID',
205: p_inventory_item_ID);
206: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM', p_invoice_num);
207: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM', p_lot_num);

Line 204: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'INVENTORYITEMID',

200: p_customer_num);
201: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'CUSTOMERPRODUCTID',
202: p_customer_product_ID);
203: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTDNIS', p_DNIS);
204: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'INVENTORYITEMID',
205: p_inventory_item_ID);
206: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM', p_invoice_num);
207: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM', p_lot_num);
208: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ORDERNUM', p_order_num);

Line 206: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM', p_invoice_num);

202: p_customer_product_ID);
203: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTDNIS', p_DNIS);
204: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'INVENTORYITEMID',
205: p_inventory_item_ID);
206: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM', p_invoice_num);
207: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM', p_lot_num);
208: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ORDERNUM', p_order_num);
209: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROBCODE',
210: p_problem_code);

Line 207: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM', p_lot_num);

203: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, 'OCCTDNIS', p_DNIS);
204: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'INVENTORYITEMID',
205: p_inventory_item_ID);
206: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM', p_invoice_num);
207: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM', p_lot_num);
208: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ORDERNUM', p_order_num);
209: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROBCODE',
210: p_problem_code);
211: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTNAME',

Line 208: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ORDERNUM', p_order_num);

204: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'INVENTORYITEMID',
205: p_inventory_item_ID);
206: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM', p_invoice_num);
207: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM', p_lot_num);
208: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ORDERNUM', p_order_num);
209: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROBCODE',
210: p_problem_code);
211: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTNAME',
212: p_product_name);

Line 209: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROBCODE',

205: p_inventory_item_ID);
206: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM', p_invoice_num);
207: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM', p_lot_num);
208: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ORDERNUM', p_order_num);
209: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROBCODE',
210: p_problem_code);
211: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTNAME',
212: p_product_name);
213: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM', p_po_num);

Line 211: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTNAME',

207: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM', p_lot_num);
208: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ORDERNUM', p_order_num);
209: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROBCODE',
210: p_problem_code);
211: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTNAME',
212: p_product_name);
213: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM', p_po_num);
214: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REFERENCENUM', p_reference_num);
215: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM', p_revision_num);

Line 213: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM', p_po_num);

209: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROBCODE',
210: p_problem_code);
211: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTNAME',
212: p_product_name);
213: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM', p_po_num);
214: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REFERENCENUM', p_reference_num);
215: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM', p_revision_num);
216: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM', p_rma_num);
217: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SCRPOPTYP',

Line 214: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REFERENCENUM', p_reference_num);

210: p_problem_code);
211: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTNAME',
212: p_product_name);
213: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM', p_po_num);
214: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REFERENCENUM', p_reference_num);
215: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM', p_revision_num);
216: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM', p_rma_num);
217: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SCRPOPTYP',
218: p_screen_pop_type);

Line 215: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM', p_revision_num);

211: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTNAME',
212: p_product_name);
213: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM', p_po_num);
214: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REFERENCENUM', p_reference_num);
215: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM', p_revision_num);
216: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM', p_rma_num);
217: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SCRPOPTYP',
218: p_screen_pop_type);
219: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM', p_serial_num);

Line 216: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM', p_rma_num);

212: p_product_name);
213: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM', p_po_num);
214: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REFERENCENUM', p_reference_num);
215: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM', p_revision_num);
216: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM', p_rma_num);
217: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SCRPOPTYP',
218: p_screen_pop_type);
219: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM', p_serial_num);
220: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM', p_sr_num);

Line 217: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SCRPOPTYP',

213: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM', p_po_num);
214: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REFERENCENUM', p_reference_num);
215: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM', p_revision_num);
216: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM', p_rma_num);
217: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SCRPOPTYP',
218: p_screen_pop_type);
219: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM', p_serial_num);
220: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM', p_sr_num);
221: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME', p_system_name);

Line 219: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM', p_serial_num);

215: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM', p_revision_num);
216: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM', p_rma_num);
217: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SCRPOPTYP',
218: p_screen_pop_type);
219: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM', p_serial_num);
220: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM', p_sr_num);
221: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME', p_system_name);
222: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, 'OCCTCREATIONTIME', l_datetime);
223: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'ACCOUNTCODE',

Line 220: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM', p_sr_num);

216: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM', p_rma_num);
217: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SCRPOPTYP',
218: p_screen_pop_type);
219: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM', p_serial_num);
220: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM', p_sr_num);
221: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME', p_system_name);
222: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, 'OCCTCREATIONTIME', l_datetime);
223: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'ACCOUNTCODE',
224: p_account_code);

Line 221: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME', p_system_name);

217: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SCRPOPTYP',
218: p_screen_pop_type);
219: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM', p_serial_num);
220: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM', p_sr_num);
221: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME', p_system_name);
222: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, 'OCCTCREATIONTIME', l_datetime);
223: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'ACCOUNTCODE',
224: p_account_code);
225: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'PREFERREDID',

Line 222: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, 'OCCTCREATIONTIME', l_datetime);

218: p_screen_pop_type);
219: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM', p_serial_num);
220: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM', p_sr_num);
221: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME', p_system_name);
222: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, 'OCCTCREATIONTIME', l_datetime);
223: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'ACCOUNTCODE',
224: p_account_code);
225: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'PREFERREDID',
226: p_preferred_ID);

Line 223: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'ACCOUNTCODE',

219: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM', p_serial_num);
220: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM', p_sr_num);
221: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME', p_system_name);
222: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, 'OCCTCREATIONTIME', l_datetime);
223: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'ACCOUNTCODE',
224: p_account_code);
225: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'PREFERREDID',
226: p_preferred_ID);
227: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROMOTIONCODE',

Line 225: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'PREFERREDID',

221: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME', p_system_name);
222: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, 'OCCTCREATIONTIME', l_datetime);
223: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'ACCOUNTCODE',
224: p_account_code);
225: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'PREFERREDID',
226: p_preferred_ID);
227: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROMOTIONCODE',
228: p_promotion_code);
229: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM', p_quote_num);

Line 227: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROMOTIONCODE',

223: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'ACCOUNTCODE',
224: p_account_code);
225: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'PREFERREDID',
226: p_preferred_ID);
227: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROMOTIONCODE',
228: p_promotion_code);
229: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM', p_quote_num);
230:
231: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LANGUAGECOMPETENCY',

Line 229: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM', p_quote_num);

225: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'PREFERREDID',
226: p_preferred_ID);
227: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROMOTIONCODE',
228: p_promotion_code);
229: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM', p_quote_num);
230:
231: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LANGUAGECOMPETENCY',
232: p_competency_lang);
233: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'KNOWLEDGECOMPETENCY',

Line 231: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LANGUAGECOMPETENCY',

227: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PROMOTIONCODE',
228: p_promotion_code);
229: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM', p_quote_num);
230:
231: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LANGUAGECOMPETENCY',
232: p_competency_lang);
233: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'KNOWLEDGECOMPETENCY',
234: p_competency_know);
235: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTCOMPETENCY',

Line 233: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'KNOWLEDGECOMPETENCY',

229: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM', p_quote_num);
230:
231: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LANGUAGECOMPETENCY',
232: p_competency_lang);
233: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'KNOWLEDGECOMPETENCY',
234: p_competency_know);
235: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTCOMPETENCY',
236: p_competency_prod);
237: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ACCOUNTNUM',

Line 235: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTCOMPETENCY',

231: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'LANGUAGECOMPETENCY',
232: p_competency_lang);
233: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'KNOWLEDGECOMPETENCY',
234: p_competency_know);
235: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTCOMPETENCY',
236: p_competency_prod);
237: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ACCOUNTNUM',
238: p_account_num);
239: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM',

Line 237: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ACCOUNTNUM',

233: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'KNOWLEDGECOMPETENCY',
234: p_competency_know);
235: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTCOMPETENCY',
236: p_competency_prod);
237: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ACCOUNTNUM',
238: p_account_num);
239: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM',
240: p_site_num);
241: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'REPAIRNUM',

Line 239: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM',

235: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'PRODUCTCOMPETENCY',
236: p_competency_prod);
237: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ACCOUNTNUM',
238: p_account_num);
239: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM',
240: p_site_num);
241: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'REPAIRNUM',
242: p_repair_num);
243: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'DEFECTNUM',

Line 241: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'REPAIRNUM',

237: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'ACCOUNTNUM',
238: p_account_num);
239: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM',
240: p_site_num);
241: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'REPAIRNUM',
242: p_repair_num);
243: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'DEFECTNUM',
244: p_defect_num);
245: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'CUSTOMERSTATUS',

Line 243: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'DEFECTNUM',

239: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM',
240: p_site_num);
241: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'REPAIRNUM',
242: p_repair_num);
243: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'DEFECTNUM',
244: p_defect_num);
245: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'CUSTOMERSTATUS',
246: p_cust_status);
247: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EVENTCODE',

Line 245: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'CUSTOMERSTATUS',

241: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'REPAIRNUM',
242: p_repair_num);
243: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'DEFECTNUM',
244: p_defect_num);
245: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'CUSTOMERSTATUS',
246: p_cust_status);
247: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EVENTCODE',
248: p_event_code);
249: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ',

Line 247: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EVENTCODE',

243: WF_ENGINE.SetItemAttrNumber(l_itemtype, l_itemkey, 'DEFECTNUM',
244: p_defect_num);
245: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'CUSTOMERSTATUS',
246: p_cust_status);
247: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EVENTCODE',
248: p_event_code);
249: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ',
250: p_coll_req);
251: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'OCCTCLASSIFICATION',

Line 249: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ',

245: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'CUSTOMERSTATUS',
246: p_cust_status);
247: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EVENTCODE',
248: p_event_code);
249: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ',
250: p_coll_req);
251: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'OCCTCLASSIFICATION',
252: p_classification);
253: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EMAILICENTERMAPID',

Line 251: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'OCCTCLASSIFICATION',

247: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EVENTCODE',
248: p_event_code);
249: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ',
250: p_coll_req);
251: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'OCCTCLASSIFICATION',
252: p_classification);
253: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EMAILICENTERMAPID',
254: p_email_icntr_map_id);
255:

Line 253: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EMAILICENTERMAPID',

249: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ',
250: p_coll_req);
251: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'OCCTCLASSIFICATION',
252: p_classification);
253: WF_ENGINE.SetItemAttrText(l_itemtype, l_itemkey, 'EMAILICENTERMAPID',
254: p_email_icntr_map_id);
255:
256: -- Set the engine threshold to a very high number to prevent
257: -- this process from ever being deferred

Line 258: WF_ENGINE.THRESHOLD := 999999;

254: p_email_icntr_map_id);
255:
256: -- Set the engine threshold to a very high number to prevent
257: -- this process from ever being deferred
258: WF_ENGINE.THRESHOLD := 999999;
259:
260: --
261: -- Start the process
262: -- This procedure call will return only after the process

Line 264: WF_ENGINE.StartProcess(l_itemtype, l_itemkey );

260: --
261: -- Start the process
262: -- This procedure call will return only after the process
263: -- completes since only function activities are used.
264: WF_ENGINE.StartProcess(l_itemtype, l_itemkey );
265:
266: /************************************************************
267: IF FND_API.To_Boolean(p_commit ) THEN
268: --COMMIT WORK;

Line 273: p_contact_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey

269: END IF;
270: ************************************************************/
271: -- Get all the OUT or IN OUT variables from the Workflow
272:
273: p_contact_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
274: , 'CONTACTNUM');
275: p_customer_name := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,
276: 'CUSTOMERNAME');
277: p_product_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

Line 275: p_customer_name := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,

271: -- Get all the OUT or IN OUT variables from the Workflow
272:
273: p_contact_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
274: , 'CONTACTNUM');
275: p_customer_name := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,
276: 'CUSTOMERNAME');
277: p_product_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
278: , 'PRODUCTNAME');
279: p_contract_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey

Line 277: p_product_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

273: p_contact_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
274: , 'CONTACTNUM');
275: p_customer_name := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,
276: 'CUSTOMERNAME');
277: p_product_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
278: , 'PRODUCTNAME');
279: p_contract_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
280: , 'CONTRACTNUM');
281: p_customer_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID);

Line 279: p_contract_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey

275: p_customer_name := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,
276: 'CUSTOMERNAME');
277: p_product_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
278: , 'PRODUCTNAME');
279: p_contract_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
280: , 'CONTRACTNUM');
281: p_customer_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID);
282: p_customer_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
283: , 'CUSTOMERNUM');

Line 281: p_customer_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID);

277: p_product_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
278: , 'PRODUCTNAME');
279: p_contract_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
280: , 'CONTRACTNUM');
281: p_customer_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID);
282: p_customer_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
283: , 'CUSTOMERNUM');
284: p_inventory_item_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
285: , 'INVENTORYITEMID');

Line 282: p_customer_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey

278: , 'PRODUCTNAME');
279: p_contract_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
280: , 'CONTRACTNUM');
281: p_customer_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID);
282: p_customer_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
283: , 'CUSTOMERNUM');
284: p_inventory_item_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
285: , 'INVENTORYITEMID');
286: p_invoice_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM');

Line 284: p_inventory_item_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey

280: , 'CONTRACTNUM');
281: p_customer_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype,l_itemkey,CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID);
282: p_customer_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
283: , 'CUSTOMERNUM');
284: p_inventory_item_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
285: , 'INVENTORYITEMID');
286: p_invoice_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM');
287: p_lot_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM');
288: p_order_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey

Line 286: p_invoice_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM');

282: p_customer_num := WF_ENGINE.GetItemAttrText (l_itemtype, l_itemkey
283: , 'CUSTOMERNUM');
284: p_inventory_item_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
285: , 'INVENTORYITEMID');
286: p_invoice_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM');
287: p_lot_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM');
288: p_order_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
289: , 'ORDERNUM');
290: p_problem_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

Line 287: p_lot_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM');

283: , 'CUSTOMERNUM');
284: p_inventory_item_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
285: , 'INVENTORYITEMID');
286: p_invoice_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM');
287: p_lot_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM');
288: p_order_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
289: , 'ORDERNUM');
290: p_problem_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
291: , 'PROBCODE');

Line 288: p_order_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey

284: p_inventory_item_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
285: , 'INVENTORYITEMID');
286: p_invoice_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM');
287: p_lot_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM');
288: p_order_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
289: , 'ORDERNUM');
290: p_problem_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
291: , 'PROBCODE');
292: p_po_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM');

Line 290: p_problem_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

286: p_invoice_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'INVOICENUM');
287: p_lot_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'LOTNUM');
288: p_order_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
289: , 'ORDERNUM');
290: p_problem_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
291: , 'PROBCODE');
292: p_po_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM');
293: p_reference_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
294: , 'REFERENCENUM');

Line 292: p_po_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM');

288: p_order_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
289: , 'ORDERNUM');
290: p_problem_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
291: , 'PROBCODE');
292: p_po_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM');
293: p_reference_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
294: , 'REFERENCENUM');
295: p_revision_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM');
296: p_rma_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM');

Line 293: p_reference_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

289: , 'ORDERNUM');
290: p_problem_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
291: , 'PROBCODE');
292: p_po_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM');
293: p_reference_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
294: , 'REFERENCENUM');
295: p_revision_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM');
296: p_rma_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM');
297: p_screen_pop_type := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

Line 295: p_revision_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM');

291: , 'PROBCODE');
292: p_po_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM');
293: p_reference_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
294: , 'REFERENCENUM');
295: p_revision_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM');
296: p_rma_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM');
297: p_screen_pop_type := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
298: , 'SCRPOPTYP');
299: p_serial_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM');

Line 296: p_rma_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM');

292: p_po_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'PURCHASEORDERNUM');
293: p_reference_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
294: , 'REFERENCENUM');
295: p_revision_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM');
296: p_rma_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM');
297: p_screen_pop_type := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
298: , 'SCRPOPTYP');
299: p_serial_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM');
300: p_sr_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM');

Line 297: p_screen_pop_type := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

293: p_reference_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
294: , 'REFERENCENUM');
295: p_revision_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM');
296: p_rma_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM');
297: p_screen_pop_type := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
298: , 'SCRPOPTYP');
299: p_serial_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM');
300: p_sr_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM');
301: p_system_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME');

Line 299: p_serial_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM');

295: p_revision_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'REVISONNUM');
296: p_rma_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM');
297: p_screen_pop_type := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
298: , 'SCRPOPTYP');
299: p_serial_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM');
300: p_sr_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM');
301: p_system_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME');
302: p_account_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
303: , 'ACCOUNTCODE');

Line 300: p_sr_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM');

296: p_rma_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'RMANUM');
297: p_screen_pop_type := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
298: , 'SCRPOPTYP');
299: p_serial_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM');
300: p_sr_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM');
301: p_system_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME');
302: p_account_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
303: , 'ACCOUNTCODE');
304: p_preferred_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey

Line 301: p_system_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME');

297: p_screen_pop_type := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
298: , 'SCRPOPTYP');
299: p_serial_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM');
300: p_sr_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM');
301: p_system_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME');
302: p_account_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
303: , 'ACCOUNTCODE');
304: p_preferred_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
305: , 'PREFERREDID');

Line 302: p_account_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

298: , 'SCRPOPTYP');
299: p_serial_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERIALNUM');
300: p_sr_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM');
301: p_system_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME');
302: p_account_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
303: , 'ACCOUNTCODE');
304: p_preferred_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
305: , 'PREFERREDID');
306: p_promotion_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

Line 304: p_preferred_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey

300: p_sr_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SERVICEREQUESTNUM');
301: p_system_name := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'SYSTEMNAME');
302: p_account_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
303: , 'ACCOUNTCODE');
304: p_preferred_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
305: , 'PREFERREDID');
306: p_promotion_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
307: , 'PROMOTIONCODE');
308: p_quote_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM');

Line 306: p_promotion_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

302: p_account_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
303: , 'ACCOUNTCODE');
304: p_preferred_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
305: , 'PREFERREDID');
306: p_promotion_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
307: , 'PROMOTIONCODE');
308: p_quote_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM');
309: p_customer_product_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey,
310: 'CUSTOMERPRODUCTID');

Line 308: p_quote_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM');

304: p_preferred_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
305: , 'PREFERREDID');
306: p_promotion_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
307: , 'PROMOTIONCODE');
308: p_quote_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM');
309: p_customer_product_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey,
310: 'CUSTOMERPRODUCTID');
311: p_account_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
312: , 'ACCOUNTNUM');

Line 309: p_customer_product_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey,

305: , 'PREFERREDID');
306: p_promotion_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
307: , 'PROMOTIONCODE');
308: p_quote_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM');
309: p_customer_product_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey,
310: 'CUSTOMERPRODUCTID');
311: p_account_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
312: , 'ACCOUNTNUM');
313: p_site_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM');

Line 311: p_account_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey

307: , 'PROMOTIONCODE');
308: p_quote_num := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'QUOTENUM');
309: p_customer_product_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey,
310: 'CUSTOMERPRODUCTID');
311: p_account_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
312: , 'ACCOUNTNUM');
313: p_site_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM');
314: p_repair_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
315: , 'REPAIRNUM');

Line 313: p_site_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM');

309: p_customer_product_ID := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey,
310: 'CUSTOMERPRODUCTID');
311: p_account_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
312: , 'ACCOUNTNUM');
313: p_site_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM');
314: p_repair_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
315: , 'REPAIRNUM');
316: p_defect_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
317: , 'DEFECTNUM');

Line 314: p_repair_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey

310: 'CUSTOMERPRODUCTID');
311: p_account_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
312: , 'ACCOUNTNUM');
313: p_site_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM');
314: p_repair_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
315: , 'REPAIRNUM');
316: p_defect_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
317: , 'DEFECTNUM');
318: p_cust_status := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

Line 316: p_defect_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey

312: , 'ACCOUNTNUM');
313: p_site_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey, 'SITENUM');
314: p_repair_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
315: , 'REPAIRNUM');
316: p_defect_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
317: , 'DEFECTNUM');
318: p_cust_status := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
319: , 'CUSTOMERSTATUS');
320: p_event_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

Line 318: p_cust_status := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

314: p_repair_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
315: , 'REPAIRNUM');
316: p_defect_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
317: , 'DEFECTNUM');
318: p_cust_status := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
319: , 'CUSTOMERSTATUS');
320: p_event_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
321: , 'EVENTCODE');
322: p_coll_req := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ');

Line 320: p_event_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

316: p_defect_num := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemkey
317: , 'DEFECTNUM');
318: p_cust_status := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
319: , 'CUSTOMERSTATUS');
320: p_event_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
321: , 'EVENTCODE');
322: p_coll_req := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ');
323: p_classification := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
324: , 'OCCTCLASSIFICATION');

Line 322: p_coll_req := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ');

318: p_cust_status := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
319: , 'CUSTOMERSTATUS');
320: p_event_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
321: , 'EVENTCODE');
322: p_coll_req := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ');
323: p_classification := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
324: , 'OCCTCLASSIFICATION');
325: p_email_icntr_map_id := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
326: , 'EMAILICENTERMAPID');

Line 323: p_classification := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

319: , 'CUSTOMERSTATUS');
320: p_event_code := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
321: , 'EVENTCODE');
322: p_coll_req := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ');
323: p_classification := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
324: , 'OCCTCLASSIFICATION');
325: p_email_icntr_map_id := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
326: , 'EMAILICENTERMAPID');
327:

Line 325: p_email_icntr_map_id := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey

321: , 'EVENTCODE');
322: p_coll_req := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey, 'COLLATERALREQ');
323: p_classification := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
324: , 'OCCTCLASSIFICATION');
325: p_email_icntr_map_id := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
326: , 'EMAILICENTERMAPID');
327:
328: /* ***************************************************************
329: Retreive results from CCT_ROUTING_RESULTS tables

Line 452: WF_ENGINE.AbortProcess(

448: END IF;
449: **********************************************************************/
450:
451: -- Call Workflow API to abort the process
452: WF_ENGINE.AbortProcess(
453: itemtype => l_itemtype,
454: itemkey => l_itemkey );
455:
456: EXCEPTION

Line 561: l_reroute := WF_ENGINE.GetItemAttrText(

557:
558: BEGIN
559: -- set default result
560: -- If reouted do not reroute again
561: l_reroute := WF_ENGINE.GetItemAttrText(
562: itemtype
563: , itemkey
564: ,'REROUTED');
565:

Line 566: resultout := wf_engine.eng_completed ;

562: itemtype
563: , itemkey
564: ,'REROUTED');
565:
566: resultout := wf_engine.eng_completed ;
567:
568: IF ( l_reroute IS NULL) OR ( l_reroute <> 'Y')
569: THEN
570:

Line 572: l_call_ID := WF_ENGINE.GetItemAttrText(itemtype, itemkey,

568: IF ( l_reroute IS NULL) OR ( l_reroute <> 'Y')
569: THEN
570:
571: -- get the callid and wf_process_id from the item key
572: l_call_ID := WF_ENGINE.GetItemAttrText(itemtype, itemkey,
573: 'OCCTMEDIAITEMID');
574: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey,
575: 'MCM_ID');
576: l_default_select :=

Line 574: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey,

570:
571: -- get the callid and wf_process_id from the item key
572: l_call_ID := WF_ENGINE.GetItemAttrText(itemtype, itemkey,
573: 'OCCTMEDIAITEMID');
574: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey,
575: 'MCM_ID');
576: l_default_select :=
577: 'Select distinct(A.agent_id) from cct_tempagents a '||
578: 'where a.call_id ='||l_apos||l_call_ID||l_apos||

Line 888: l_itemkey := wf_engine.eng_synch;

884: -- 2:04 PM 2/13/99 Savvas Xenophontos
885: l_itemkey := Encode_Call_Itemkey(p_call_ID, l_wf_process_ID);
886: -- Do not SYNCH if test mode is ON, all other case SYNCH
887: IF G_TEST_MODE <> 'ON' THEN
888: l_itemkey := wf_engine.eng_synch;
889: END IF;
890:
891: begin
892: -- Create and launch the Workflow process

Line 893: WF_ENGINE.CreateProcess(

889: END IF;
890:
891: begin
892: -- Create and launch the Workflow process
893: WF_ENGINE.CreateProcess(
894: itemtype => l_itemtype,
895: itemkey => l_itemkey,
896: process => G_PROCESS_NAME );
897:

Line 912: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, param_name(nIndex), param_val(nIndex));

908: --DBMS_OUTPUT.PUT_LINE('itemType is : ' || l_itemtype || ' itemKey is : ' || l_itemkey );
909: FOR nIndex IN 1..PARAM_NAME.COUNT LOOP
910: Begin
911: IF param_type(nIndex) = 'VARCHAR' THEN
912: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, param_name(nIndex), param_val(nIndex));
913: ELSIF param_type(nIndex)='NUMBER' THEN
914: WF_ENGINE.SetItemAttrNumber (l_itemtype, l_itemkey, param_name(nIndex), param_val(nIndex));
915: ELSE
916: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, param_name(nIndex), to_date(param_val(nIndex),'yyyy-mm-dd hh24:mi:ss'));

Line 914: WF_ENGINE.SetItemAttrNumber (l_itemtype, l_itemkey, param_name(nIndex), param_val(nIndex));

910: Begin
911: IF param_type(nIndex) = 'VARCHAR' THEN
912: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, param_name(nIndex), param_val(nIndex));
913: ELSIF param_type(nIndex)='NUMBER' THEN
914: WF_ENGINE.SetItemAttrNumber (l_itemtype, l_itemkey, param_name(nIndex), param_val(nIndex));
915: ELSE
916: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, param_name(nIndex), to_date(param_val(nIndex),'yyyy-mm-dd hh24:mi:ss'));
917:
918: END IF;

Line 916: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, param_name(nIndex), to_date(param_val(nIndex),'yyyy-mm-dd hh24:mi:ss'));

912: WF_ENGINE.SetItemAttrText (l_itemtype, l_itemkey, param_name(nIndex), param_val(nIndex));
913: ELSIF param_type(nIndex)='NUMBER' THEN
914: WF_ENGINE.SetItemAttrNumber (l_itemtype, l_itemkey, param_name(nIndex), param_val(nIndex));
915: ELSE
916: WF_ENGINE.SetItemAttrDate (l_itemtype, l_itemkey, param_name(nIndex), to_date(param_val(nIndex),'yyyy-mm-dd hh24:mi:ss'));
917:
918: END IF;
919: Exception
920: when others then

Line 928: WF_ENGINE.THRESHOLD := 999999;

924: END LOOP;
925:
926: -- Set the engine threshold to a very high number to prevent
927: -- this process from ever being deferred
928: WF_ENGINE.THRESHOLD := 999999;
929:
930: --
931: -- Start the process
932: -- This procedure call will return only after the process

Line 934: WF_ENGINE.StartProcess(l_itemtype, l_itemkey );

930: --
931: -- Start the process
932: -- This procedure call will return only after the process
933: -- completes since only function activities are used.
934: WF_ENGINE.StartProcess(l_itemtype, l_itemkey );
935:
936: --dbms_output.put_line('Getting Attribute value for ScreenpopApp:'||WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SCREENPOPAPP'));
937: /* ***************************************************************
938: Retreive results from CCT_ROUTING_RESULTS tables

Line 936: --dbms_output.put_line('Getting Attribute value for ScreenpopApp:'||WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SCREENPOPAPP'));

932: -- This procedure call will return only after the process
933: -- completes since only function activities are used.
934: WF_ENGINE.StartProcess(l_itemtype, l_itemkey );
935:
936: --dbms_output.put_line('Getting Attribute value for ScreenpopApp:'||WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SCREENPOPAPP'));
937: /* ***************************************************************
938: Retreive results from CCT_ROUTING_RESULTS tables
939: *************************************************************** */
940: begin

Line 1085: l_reroute := WF_ENGINE.GetItemAttrText(

1081:
1082: BEGIN
1083: -- set default result
1084: -- If reouted do not reroute again
1085: l_reroute := WF_ENGINE.GetItemAttrText(
1086: itemtype
1087: , itemkey
1088: ,'REROUTED');
1089:

Line 1093: --resultout := wf_engine.eng_completed ;

1089:
1090: IF (l_reroute = 'Y') THEN
1091: resultout := 'COMPLETE:N';
1092: END IF;
1093: --resultout := wf_engine.eng_completed ;
1094:
1095: -- get the callid and wf_process_id from the item key
1096: l_call_ID := WF_ENGINE.GetItemAttrText(itemtype, itemkey,
1097: 'OCCTMEDIAITEMID');

Line 1096: l_call_ID := WF_ENGINE.GetItemAttrText(itemtype, itemkey,

1092: END IF;
1093: --resultout := wf_engine.eng_completed ;
1094:
1095: -- get the callid and wf_process_id from the item key
1096: l_call_ID := WF_ENGINE.GetItemAttrText(itemtype, itemkey,
1097: 'OCCTMEDIAITEMID');
1098: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey,
1099: 'MCM_ID');
1100: l_default_select :=

Line 1098: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey,

1094:
1095: -- get the callid and wf_process_id from the item key
1096: l_call_ID := WF_ENGINE.GetItemAttrText(itemtype, itemkey,
1097: 'OCCTMEDIAITEMID');
1098: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey,
1099: 'MCM_ID');
1100: l_default_select :=
1101: 'Select distinct(A.agent_id) from cct_tempagents a '||
1102: 'where a.call_id ='||l_apos||l_call_ID||l_apos||

Line 1157: WF_ENGINE.SetItemAttrText (

1153: IF l_reroute is NULL THEN
1154: -- If the call is already rerouted once don't reroute again
1155: -- even if no agents found
1156: -- Set Rerouted to Y as this call is about to be rerouted
1157: WF_ENGINE.SetItemAttrText (
1158: itemtype
1159: , itemkey
1160: , 'REROUTED'
1161: , 'Y');

Line 1239: l_number_of_reroutes := WF_ENGINE.GetItemAttrText(

1235: , resultout in out nocopy varchar2
1236: ) IS
1237: l_number_of_reroutes VARCHAR2(20) := '0';
1238: BEGIN
1239: l_number_of_reroutes := WF_ENGINE.GetItemAttrText(
1240: itemtype
1241: , itemkey
1242: ,'OCCTREROUTE');
1243: -- Return the number of reroutes between 0 and 5,

Line 1246: resultout := wf_engine.eng_completed||':0';

1242: ,'OCCTREROUTE');
1243: -- Return the number of reroutes between 0 and 5,
1244: -- if number if reroutes is more than 5 return 5 only.
1245: IF l_number_of_reroutes = '0' THEN
1246: resultout := wf_engine.eng_completed||':0';
1247: ELSIF l_number_of_reroutes = '1' THEN
1248: resultout := wf_engine.eng_completed||':1';
1249: ELSIF l_number_of_reroutes = '2' THEN
1250: resultout := wf_engine.eng_completed||':2';

Line 1248: resultout := wf_engine.eng_completed||':1';

1244: -- if number if reroutes is more than 5 return 5 only.
1245: IF l_number_of_reroutes = '0' THEN
1246: resultout := wf_engine.eng_completed||':0';
1247: ELSIF l_number_of_reroutes = '1' THEN
1248: resultout := wf_engine.eng_completed||':1';
1249: ELSIF l_number_of_reroutes = '2' THEN
1250: resultout := wf_engine.eng_completed||':2';
1251: ELSIF l_number_of_reroutes = '3' THEN
1252: resultout := wf_engine.eng_completed||':3';

Line 1250: resultout := wf_engine.eng_completed||':2';

1246: resultout := wf_engine.eng_completed||':0';
1247: ELSIF l_number_of_reroutes = '1' THEN
1248: resultout := wf_engine.eng_completed||':1';
1249: ELSIF l_number_of_reroutes = '2' THEN
1250: resultout := wf_engine.eng_completed||':2';
1251: ELSIF l_number_of_reroutes = '3' THEN
1252: resultout := wf_engine.eng_completed||':3';
1253: ELSIF l_number_of_reroutes = '4' THEN
1254: resultout := wf_engine.eng_completed||':4';

Line 1252: resultout := wf_engine.eng_completed||':3';

1248: resultout := wf_engine.eng_completed||':1';
1249: ELSIF l_number_of_reroutes = '2' THEN
1250: resultout := wf_engine.eng_completed||':2';
1251: ELSIF l_number_of_reroutes = '3' THEN
1252: resultout := wf_engine.eng_completed||':3';
1253: ELSIF l_number_of_reroutes = '4' THEN
1254: resultout := wf_engine.eng_completed||':4';
1255: ELSIF l_number_of_reroutes = '5' THEN
1256: resultout := wf_engine.eng_completed||':5';

Line 1254: resultout := wf_engine.eng_completed||':4';

1250: resultout := wf_engine.eng_completed||':2';
1251: ELSIF l_number_of_reroutes = '3' THEN
1252: resultout := wf_engine.eng_completed||':3';
1253: ELSIF l_number_of_reroutes = '4' THEN
1254: resultout := wf_engine.eng_completed||':4';
1255: ELSIF l_number_of_reroutes = '5' THEN
1256: resultout := wf_engine.eng_completed||':5';
1257: ELSE
1258: resultout := wf_engine.eng_completed||':5';

Line 1256: resultout := wf_engine.eng_completed||':5';

1252: resultout := wf_engine.eng_completed||':3';
1253: ELSIF l_number_of_reroutes = '4' THEN
1254: resultout := wf_engine.eng_completed||':4';
1255: ELSIF l_number_of_reroutes = '5' THEN
1256: resultout := wf_engine.eng_completed||':5';
1257: ELSE
1258: resultout := wf_engine.eng_completed||':5';
1259: END IF;
1260:

Line 1258: resultout := wf_engine.eng_completed||':5';

1254: resultout := wf_engine.eng_completed||':4';
1255: ELSIF l_number_of_reroutes = '5' THEN
1256: resultout := wf_engine.eng_completed||':5';
1257: ELSE
1258: resultout := wf_engine.eng_completed||':5';
1259: END IF;
1260:
1261: END number_of_reroutes;
1262: