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.OKL_SSC_WF dependencies on WF_ENGINE

Line 129: p_requestor_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));

125: BEGIN
126:
127: if ( funcmode = 'RUN' ) then
128:
129: p_requestor_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
130:
131: open user_info(p_requestor_id);
132: fetch user_info into requestor_info_rec;
133: l_requestor_name := requestor_info_rec.user_name;

Line 136: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_requestor_name);

132: fetch user_info into requestor_info_rec;
133: l_requestor_name := requestor_info_rec.user_name;
134: close user_info;
135:
136: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_requestor_name);
137:
138:
139: p_resp_key := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
140:

Line 139: p_resp_key := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');

135:
136: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_requestor_name);
137:
138:
139: p_resp_key := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
140:
141: open approver_cur(p_resp_key);
142: fetch approver_cur into l_approver_id;
143: close approver_cur;

Line 146: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER', l_approver_name);

142: fetch approver_cur into l_approver_id;
143: close approver_cur;
144: l_approver_name := l_respString||l_approver_id;
145:
146: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER', l_approver_name);
147:
148:
149:
150: --get the global variables transaction id and transaction type

Line 153: wf_engine.SetItemAttrText (itemtype => itemtype,

149:
150: --get the global variables transaction id and transaction type
151:
152:
153: wf_engine.SetItemAttrText (itemtype => itemtype,
154: itemkey => itemkey,
155: aname => l_doc_attr,
156: avalue => 'PLSQLCLOB:OKL_SSC_WF.getAssetReturnDocument/'||
157: itemtype ||':'||itemkey||':&#NID');

Line 187: resultout := wf_engine.eng_timedout;

183: end if;
184: if ( funcmode = 'TIMEOUT' ) then
185: resultout := 'COMPLETE';
186: else
187: resultout := wf_engine.eng_timedout;
188: return;
189: end if;
190:
191: exception

Line 246: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTASID'));

242:
243: l_itemtype := substr(document_id, first_index+1, second_index-first_index-1);
244: l_itemkey := substr(document_id, second_index+1, third_index-second_index-1);
245:
246: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTASID'));
247: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');
248:
249:
250: IF (display_type = 'text/html') THEN

Line 247: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');

243: l_itemtype := substr(document_id, first_index+1, second_index-first_index-1);
244: l_itemkey := substr(document_id, second_index+1, third_index-second_index-1);
245:
246: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTASID'));
247: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');
248:
249:
250: IF (display_type = 'text/html') THEN
251:

Line 341: p_requestor_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));

337: BEGIN
338:
339: if ( funcmode = 'RUN' ) then
340:
341: p_requestor_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
342: open user_info(p_requestor_id);
343: fetch user_info into requestor_info_rec;
344: l_requestor_name := requestor_info_rec.user_name;
345: close user_info;

Line 349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_requestor_name);

345: close user_info;
346:
347:
348:
349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_requestor_name);
350:
351: p_resp_key := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
352:
353: open approver_cur(p_resp_key);

Line 351: p_resp_key := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');

347:
348:
349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_requestor_name);
350:
351: p_resp_key := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
352:
353: open approver_cur(p_resp_key);
354: fetch approver_cur into l_approver_id;
355: close approver_cur;

Line 358: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER', l_approver_name);

354: fetch approver_cur into l_approver_id;
355: close approver_cur;
356: l_approver_name := l_respString||l_approver_id;
357:
358: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER', l_approver_name);
359:
360:
361: wf_engine.SetItemAttrText (itemtype => itemtype,
362: itemkey => itemkey,

Line 361: wf_engine.SetItemAttrText (itemtype => itemtype,

357:
358: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER', l_approver_name);
359:
360:
361: wf_engine.SetItemAttrText (itemtype => itemtype,
362: itemkey => itemkey,
363: aname => l_doc_attr,
364: avalue => 'PLSQLCLOB:OKL_SSC_WF.getSerialNumDocument/'||
365: itemtype ||':'||itemkey||':&#NID');

Line 393: resultout := wf_engine.eng_timedout;

389: end if;
390: if ( funcmode = 'TIMEOUT' ) then
391: resultout := 'COMPLETE';
392: else
393: resultout := wf_engine.eng_timedout;
394: return;
395: end if;
396:
397: exception

Line 454: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTASID'));

450:
451: l_itemtype := substr(document_id, first_index+1, second_index-first_index-1);
452: l_itemkey := substr(document_id, second_index+1, third_index-second_index-1);
453:
454: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTASID'));
455: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');
456:
457:
458: IF (display_type = 'text/html') THEN

Line 455: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');

451: l_itemtype := substr(document_id, first_index+1, second_index-first_index-1);
452: l_itemkey := substr(document_id, second_index+1, third_index-second_index-1);
453:
454: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTASID'));
455: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');
456:
457:
458: IF (display_type = 'text/html') THEN
459:

Line 515: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);

511: begin
512:
513:
514: -- assign variable to attribute
515: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
516:
517:
518: if ( funcmode = 'RUN' ) then
519:

Line 521: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCTASID'));

517:
518: if ( funcmode = 'RUN' ) then
519:
520:
521: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCTASID'));
522:
523: update_serial_number(p_api_version => 1.0,
524: p_init_msg_list => OKC_API.G_FALSE,
525: p_tas_id => l_tas_id,

Line 561: resultout := wf_engine.eng_timedout;

557: end if;
558: if ( funcmode = 'TIMEOUT' ) then
559: resultout := 'COMPLETE';
560: else
561: resultout := wf_engine.eng_timedout;
562: return;
563: end if;
564:
565: exception

Line 613: p_requestor_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));

609: BEGIN
610:
611: if ( funcmode = 'RUN' ) then
612:
613: p_requestor_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
614:
615: open user_info(p_requestor_id);
616: fetch user_info into requestor_info_rec;
617: l_requestor_name := requestor_info_rec.user_name;

Line 620: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_requestor_name);

616: fetch user_info into requestor_info_rec;
617: l_requestor_name := requestor_info_rec.user_name;
618: close user_info;
619:
620: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_requestor_name);
621:
622: p_resp_key := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
623:
624: open approver_cur(p_resp_key);

Line 622: p_resp_key := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');

618: close user_info;
619:
620: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_requestor_name);
621:
622: p_resp_key := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
623:
624: open approver_cur(p_resp_key);
625: fetch approver_cur into l_approver_id;
626: close approver_cur;

Line 629: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER', l_approver_name);

625: fetch approver_cur into l_approver_id;
626: close approver_cur;
627: l_approver_name := l_respString||l_approver_id;
628:
629: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER', l_approver_name);
630:
631: wf_engine.SetItemAttrText (itemtype => itemtype,
632: itemkey => itemkey,
633: aname => l_doc_attr,

Line 631: wf_engine.SetItemAttrText (itemtype => itemtype,

627: l_approver_name := l_respString||l_approver_id;
628:
629: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER', l_approver_name);
630:
631: wf_engine.SetItemAttrText (itemtype => itemtype,
632: itemkey => itemkey,
633: aname => l_doc_attr,
634: avalue => 'PLSQLCLOB:OKL_SSC_WF.getLocationDocument/'||
635: itemtype ||':'||itemkey||':&#NID');

Line 662: resultout := wf_engine.eng_timedout;

658: end if;
659: if ( funcmode = 'TIMEOUT' ) then
660: resultout := 'COMPLETE';
661: else
662: resultout := wf_engine.eng_timedout;
663: return;
664: end if;
665:
666: exception

Line 776: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTASID'));

772: l_itemkey := substr(document_id, second_index+1, third_index-second_index-1);
773:
774: -- Bug#4274575 - smadhava - 28-Sep-2005 - Modified - Start
775: /*
776: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTASID'));
777: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');
778: */
779:
780: -- have to fetch the location names for the Ids

Line 777: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');

773:
774: -- Bug#4274575 - smadhava - 28-Sep-2005 - Modified - Start
775: /*
776: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTASID'));
777: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');
778: */
779:
780: -- have to fetch the location names for the Ids
781: l_new_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID1');

Line 781: l_new_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID1');

777: l_tal_type := WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SSCTALTYPE');
778: */
779:
780: -- have to fetch the location names for the Ids
781: l_new_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID1');
782: l_old_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE1');
783: l_new_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID2');
784: l_old_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE2');
785: l_trx_date := wf_engine.GetItemAttrDate(l_itemtype, l_itemkey, 'TRX_DATE');

Line 782: l_old_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE1');

778: */
779:
780: -- have to fetch the location names for the Ids
781: l_new_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID1');
782: l_old_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE1');
783: l_new_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID2');
784: l_old_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE2');
785: l_trx_date := wf_engine.GetItemAttrDate(l_itemtype, l_itemkey, 'TRX_DATE');
786: l_asset_id := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'ASSETID');

Line 783: l_new_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID2');

779:
780: -- have to fetch the location names for the Ids
781: l_new_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID1');
782: l_old_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE1');
783: l_new_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID2');
784: l_old_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE2');
785: l_trx_date := wf_engine.GetItemAttrDate(l_itemtype, l_itemkey, 'TRX_DATE');
786: l_asset_id := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'ASSETID');
787:

Line 784: l_old_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE2');

780: -- have to fetch the location names for the Ids
781: l_new_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID1');
782: l_old_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE1');
783: l_new_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID2');
784: l_old_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE2');
785: l_trx_date := wf_engine.GetItemAttrDate(l_itemtype, l_itemkey, 'TRX_DATE');
786: l_asset_id := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'ASSETID');
787:
788: OPEN c_get_location(l_old_location_id1,l_old_location_id2);

Line 785: l_trx_date := wf_engine.GetItemAttrDate(l_itemtype, l_itemkey, 'TRX_DATE');

781: l_new_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID1');
782: l_old_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE1');
783: l_new_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID2');
784: l_old_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE2');
785: l_trx_date := wf_engine.GetItemAttrDate(l_itemtype, l_itemkey, 'TRX_DATE');
786: l_asset_id := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'ASSETID');
787:
788: OPEN c_get_location(l_old_location_id1,l_old_location_id2);
789: FETCH c_get_location INTO l_old_location;

Line 786: l_asset_id := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'ASSETID');

782: l_old_location_id1 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE1');
783: l_new_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'NEWSITEID2');
784: l_old_location_id2 := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'OLDSITE2');
785: l_trx_date := wf_engine.GetItemAttrDate(l_itemtype, l_itemkey, 'TRX_DATE');
786: l_asset_id := wf_engine.GetItemAttrText(l_itemtype, l_itemkey, 'ASSETID');
787:
788: OPEN c_get_location(l_old_location_id1,l_old_location_id2);
789: FETCH c_get_location INTO l_old_location;
790: CLOSE c_get_location;

Line 957: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);

953: l_orig_access_mode := MO_GLOBAL.GET_ACCESS_MODE;
954: --For bug 8933908 by NIKSHAH : END
955:
956: -- assign variable to attribute
957: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
958:
959:
960: if ( funcmode = 'RUN' ) then
961: /*

Line 963: l_new_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID1');

959:
960: if ( funcmode = 'RUN' ) then
961: /*
962: -- Bug#4274575 - smadhava - 28-Sep-2005 - Modified - Start
963: l_new_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID1');
964: l_new_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID2');
965: l_old_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE1');
966: l_old_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE2');
967: l_trx_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'TRX_DATE');

Line 964: l_new_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID2');

960: if ( funcmode = 'RUN' ) then
961: /*
962: -- Bug#4274575 - smadhava - 28-Sep-2005 - Modified - Start
963: l_new_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID1');
964: l_new_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID2');
965: l_old_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE1');
966: l_old_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE2');
967: l_trx_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'TRX_DATE');
968: l_asset_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ASSETID');

Line 965: l_old_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE1');

961: /*
962: -- Bug#4274575 - smadhava - 28-Sep-2005 - Modified - Start
963: l_new_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID1');
964: l_new_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID2');
965: l_old_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE1');
966: l_old_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE2');
967: l_trx_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'TRX_DATE');
968: l_asset_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ASSETID');
969:

Line 966: l_old_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE2');

962: -- Bug#4274575 - smadhava - 28-Sep-2005 - Modified - Start
963: l_new_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID1');
964: l_new_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID2');
965: l_old_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE1');
966: l_old_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE2');
967: l_trx_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'TRX_DATE');
968: l_asset_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ASSETID');
969:
970: OPEN okl_loc_csr(l_new_location_id1, l_new_location_id2);

Line 967: l_trx_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'TRX_DATE');

963: l_new_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID1');
964: l_new_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID2');
965: l_old_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE1');
966: l_old_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE2');
967: l_trx_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'TRX_DATE');
968: l_asset_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ASSETID');
969:
970: OPEN okl_loc_csr(l_new_location_id1, l_new_location_id2);
971: FETCH okl_loc_csr INTO l_party_site_id, l_location_id;

Line 968: l_asset_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ASSETID');

964: l_new_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'NEWSITEID2');
965: l_old_location_id1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE1');
966: l_old_location_id2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'OLDSITE2');
967: l_trx_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'TRX_DATE');
968: l_asset_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ASSETID');
969:
970: OPEN okl_loc_csr(l_new_location_id1, l_new_location_id2);
971: FETCH okl_loc_csr INTO l_party_site_id, l_location_id;
972: CLOSE okl_loc_csr;

Line 991: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCTASID'));

987: x_return_status => x_return_status,
988: x_msg_count => x_msg_count,
989: x_msg_data => l_msg_data);
990:
991: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCTASID'));
992:
993:
994: update_location(p_api_version => 1.0,
995: p_init_msg_list => OKC_API.G_FALSE,

Line 1005: l_asset_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ASSETID');

1001: -- Bug#4274575 - smadhava - 28-Sep-2005 - Modified - end
1002: --check the update result
1003: --asawanka ebtax changes start
1004:
1005: l_asset_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ASSETID');
1006:
1007: --For bug 8933908 by NIKSHAH : START
1008: IF l_orig_org_id IS NULL THEN
1009: OPEN c_get_org_id(l_asset_id);

Line 1060: resultout := wf_engine.eng_timedout;

1056: end if;
1057: if ( funcmode = 'TIMEOUT' ) then
1058: resultout := 'COMPLETE';
1059: else
1060: resultout := wf_engine.eng_timedout;
1061: return;
1062: end if;
1063:
1064: exception

Line 1604: l_provider_name:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWINSURANCEPROVIDERNUMBER');

1600:
1601: if ( funcmode = 'RUN' ) then
1602:
1603: --Read attributes from WorkFlow
1604: l_provider_name:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWINSURANCEPROVIDERNUMBER');
1605:
1606: open provider_info(l_provider_name);
1607: fetch provider_info into l_provider_id;
1608: close provider_info;

Line 1612: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCINSPROVIDERID',to_char(l_provider_id));

1608: close provider_info;
1609:
1610:
1611:
1612: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCINSPROVIDERID',to_char(l_provider_id));
1613:
1614: open site_id_cur(l_provider_id);
1615: fetch site_id_cur into l_site_id;
1616: close site_id_cur;

Line 1618: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCSITEID',to_char(l_site_id));

1614: open site_id_cur(l_provider_id);
1615: fetch site_id_cur into l_site_id;
1616: close site_id_cur;
1617:
1618: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCSITEID',to_char(l_site_id));
1619:
1620: resultout := 'COMPLETE';
1621:
1622: return;

Line 1645: resultout := wf_engine.eng_timedout;

1641: end if;
1642: if ( funcmode = 'TIMEOUT' ) then
1643: resultout := 'COMPLETE';
1644: else
1645: resultout := wf_engine.eng_timedout;
1646: return;
1647: end if;
1648:
1649: exception

Line 1669: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEYFORNEWPROV');

1665:
1666:
1667: begin
1668: l_respString:='FND_RESP540:';
1669: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEYFORNEWPROV');
1670:
1671: if ( funcmode = 'RUN' ) then
1672:
1673:

Line 1681: wf_engine.SetItemAttrText (itemtype => itemtype,

1677: FROM fnd_responsibility
1678: WHERE responsibility_key = l_resp_key
1679: AND application_id = 540;
1680:
1681: wf_engine.SetItemAttrText (itemtype => itemtype,
1682: itemkey => itemkey,
1683: aname => 'SSC_NTFRECIPIENT_ITMATTR2',
1684: avalue => l_respString || l_respId);
1685:

Line 1713: resultout := wf_engine.eng_timedout;

1709: end if;
1710: if ( funcmode = 'TIMEOUT' ) then
1711: resultout := 'COMPLETE';
1712: else
1713: resultout := wf_engine.eng_timedout;
1714: return;
1715: end if;
1716:
1717: exception

Line 1759: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');

1755: if ( funcmode = 'RUN' ) then
1756:
1757:
1758:
1759: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
1760:
1761:
1762: SELECT responsibility_id
1763: INTO l_respId

Line 1768: wf_engine.SetItemAttrText (itemtype => itemtype,

1764: FROM fnd_responsibility
1765: WHERE responsibility_key = l_resp_key
1766: AND application_id = 540;
1767:
1768: wf_engine.SetItemAttrText (itemtype => itemtype,
1769: itemkey => itemkey,
1770: aname => 'SSC_NTFRECIPIENT_ITMATTR',
1771: avalue => l_respString || l_respId);
1772:

Line 1777: l_providerid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPROVIDERID');

1773:
1774:
1775: --Read attributes from WorkFlow
1776: --Read attributes from WorkFlow
1777: l_providerid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPROVIDERID');
1778: l_siteid := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSITEID');
1779: l_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
1780: l_coverage_amount:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCCOVERAGEAMOUNT');
1781: l_deductible:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCDEDUCTIBLE');

Line 1778: l_siteid := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSITEID');

1774:
1775: --Read attributes from WorkFlow
1776: --Read attributes from WorkFlow
1777: l_providerid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPROVIDERID');
1778: l_siteid := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSITEID');
1779: l_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
1780: l_coverage_amount:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCCOVERAGEAMOUNT');
1781: l_deductible:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCDEDUCTIBLE');
1782: l_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');

Line 1779: l_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');

1775: --Read attributes from WorkFlow
1776: --Read attributes from WorkFlow
1777: l_providerid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPROVIDERID');
1778: l_siteid := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSITEID');
1779: l_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
1780: l_coverage_amount:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCCOVERAGEAMOUNT');
1781: l_deductible:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCDEDUCTIBLE');
1782: l_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1783:

Line 1780: l_coverage_amount:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCCOVERAGEAMOUNT');

1776: --Read attributes from WorkFlow
1777: l_providerid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPROVIDERID');
1778: l_siteid := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSITEID');
1779: l_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
1780: l_coverage_amount:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCCOVERAGEAMOUNT');
1781: l_deductible:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCDEDUCTIBLE');
1782: l_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1783:
1784: l_policynum:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPOLICYNUMBER');

Line 1781: l_deductible:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCDEDUCTIBLE');

1777: l_providerid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPROVIDERID');
1778: l_siteid := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSITEID');
1779: l_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
1780: l_coverage_amount:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCCOVERAGEAMOUNT');
1781: l_deductible:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCDEDUCTIBLE');
1782: l_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1783:
1784: l_policynum:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPOLICYNUMBER');
1785: l_lessor_insured:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORINSURED');

Line 1782: l_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');

1778: l_siteid := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSITEID');
1779: l_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
1780: l_coverage_amount:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCCOVERAGEAMOUNT');
1781: l_deductible:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCDEDUCTIBLE');
1782: l_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1783:
1784: l_policynum:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPOLICYNUMBER');
1785: l_lessor_insured:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORINSURED');
1786: l_lessor_payee:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORPAYEE');

Line 1784: l_policynum:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPOLICYNUMBER');

1780: l_coverage_amount:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCCOVERAGEAMOUNT');
1781: l_deductible:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCDEDUCTIBLE');
1782: l_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1783:
1784: l_policynum:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPOLICYNUMBER');
1785: l_lessor_insured:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORINSURED');
1786: l_lessor_payee:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORPAYEE');
1787:
1788: l_start_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSTARTDATE');

Line 1785: l_lessor_insured:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORINSURED');

1781: l_deductible:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCDEDUCTIBLE');
1782: l_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1783:
1784: l_policynum:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPOLICYNUMBER');
1785: l_lessor_insured:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORINSURED');
1786: l_lessor_payee:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORPAYEE');
1787:
1788: l_start_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSTARTDATE');
1789: l_end_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCENDDATE');

Line 1786: l_lessor_payee:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORPAYEE');

1782: l_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1783:
1784: l_policynum:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPOLICYNUMBER');
1785: l_lessor_insured:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORINSURED');
1786: l_lessor_payee:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORPAYEE');
1787:
1788: l_start_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSTARTDATE');
1789: l_end_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCENDDATE');
1790:

Line 1788: l_start_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSTARTDATE');

1784: l_policynum:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPOLICYNUMBER');
1785: l_lessor_insured:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORINSURED');
1786: l_lessor_payee:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORPAYEE');
1787:
1788: l_start_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSTARTDATE');
1789: l_end_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCENDDATE');
1790:
1791: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
1792:

Line 1789: l_end_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCENDDATE');

1785: l_lessor_insured:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORINSURED');
1786: l_lessor_payee:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCLESSORPAYEE');
1787:
1788: l_start_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSTARTDATE');
1789: l_end_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCENDDATE');
1790:
1791: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
1792:
1793:

Line 1791: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);

1787:
1788: l_start_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCSTARTDATE');
1789: l_end_date:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCENDDATE');
1790:
1791: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
1792:
1793:
1794: --get contract number for notification
1795: SELECT contract_number

Line 1800: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER',l_knum);

1796: INTO l_knum
1797: FROM okc_k_headers_v
1798: WHERE id = l_chrid;
1799:
1800: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER',l_knum);
1801:
1802:
1803: --Set attributes in record
1804: l_policy_rec.policy_number := l_policynum;

Line 1859: resultout := wf_engine.eng_timedout;

1855: end if;
1856: if ( funcmode = 'TIMEOUT' ) then
1857: resultout := 'COMPLETE';
1858: else
1859: resultout := wf_engine.eng_timedout;
1860: return;
1861: end if;
1862:
1863: exception

Line 1904: p_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');

1900: l_respString:='FND_RESP540:';
1901:
1902:
1903: if ( funcmode = 'RUN' ) then
1904: p_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
1905: p_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1906: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
1907:
1908: open contract_info(p_chrid);

Line 1905: p_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');

1901:
1902:
1903: if ( funcmode = 'RUN' ) then
1904: p_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
1905: p_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1906: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
1907:
1908: open contract_info(p_chrid);
1909: fetch contract_info into l_knum;

Line 1906: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');

1902:
1903: if ( funcmode = 'RUN' ) then
1904: p_chrid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
1905: p_requestor_userid:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'REQUESTOR');
1906: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
1907:
1908: open contract_info(p_chrid);
1909: fetch contract_info into l_knum;
1910: close contract_info;

Line 1922: wf_engine.SetItemAttrText (itemtype => itemtype,

1918: FROM fnd_responsibility
1919: WHERE responsibility_key = l_resp_key
1920: AND application_id = 540;
1921:
1922: wf_engine.SetItemAttrText (itemtype => itemtype,
1923: itemkey => itemkey,
1924: aname => 'SSC_NTFRECIPIENT_ITMATTR',
1925: avalue => l_respString || l_respId);
1926:

Line 1927: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM',l_knum);

1923: itemkey => itemkey,
1924: aname => 'SSC_NTFRECIPIENT_ITMATTR',
1925: avalue => l_respString || l_respId);
1926:
1927: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM',l_knum);
1928: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR',l_username);
1929: resultout := 'COMPLETE';
1930:
1931: return;

Line 1928: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR',l_username);

1924: aname => 'SSC_NTFRECIPIENT_ITMATTR',
1925: avalue => l_respString || l_respId);
1926:
1927: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM',l_knum);
1928: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR',l_username);
1929: resultout := 'COMPLETE';
1930:
1931: return;
1932: end if;

Line 1954: resultout := wf_engine.eng_timedout;

1950: end if;
1951: if ( funcmode = 'TIMEOUT' ) then
1952: resultout := 'COMPLETE';
1953: else
1954: resultout := wf_engine.eng_timedout;
1955: return;
1956: end if;
1957:
1958: exception

Line 2019: l_chr_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));

2015: begin
2016:
2017: if ( funcmode = 'RUN' ) then
2018:
2019: l_chr_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2020: l_format_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINVFORID'));
2021: l_requestor_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
2022: l_resp_key := ( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY'));
2023:

Line 2020: l_format_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINVFORID'));

2016:
2017: if ( funcmode = 'RUN' ) then
2018:
2019: l_chr_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2020: l_format_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINVFORID'));
2021: l_requestor_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
2022: l_resp_key := ( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY'));
2023:
2024: open contract_cur(l_chr_id);

Line 2021: l_requestor_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));

2017: if ( funcmode = 'RUN' ) then
2018:
2019: l_chr_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2020: l_format_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINVFORID'));
2021: l_requestor_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
2022: l_resp_key := ( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY'));
2023:
2024: open contract_cur(l_chr_id);
2025: fetch contract_cur into l_contract_number,l_org_info;

Line 2022: l_resp_key := ( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY'));

2018:
2019: l_chr_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2020: l_format_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINVFORID'));
2021: l_requestor_id:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
2022: l_resp_key := ( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY'));
2023:
2024: open contract_cur(l_chr_id);
2025: fetch contract_cur into l_contract_number,l_org_info;
2026: close contract_cur;

Line 2048: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM',l_contract_number);

2044: close old_format_cur;
2045:
2046: l_approver := l_respString||l_approver_id;
2047:
2048: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM',l_contract_number);
2049: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR',l_requestor);
2050: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER',l_approver);
2051: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWINVFOR',l_new_format);
2052: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURINVFOR',l_current_format);

Line 2049: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR',l_requestor);

2045:
2046: l_approver := l_respString||l_approver_id;
2047:
2048: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM',l_contract_number);
2049: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR',l_requestor);
2050: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER',l_approver);
2051: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWINVFOR',l_new_format);
2052: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURINVFOR',l_current_format);
2053: -- the error notification goes to the l_admin through WF default error processing

Line 2050: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER',l_approver);

2046: l_approver := l_respString||l_approver_id;
2047:
2048: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM',l_contract_number);
2049: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR',l_requestor);
2050: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER',l_approver);
2051: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWINVFOR',l_new_format);
2052: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURINVFOR',l_current_format);
2053: -- the error notification goes to the l_admin through WF default error processing
2054: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);

Line 2051: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWINVFOR',l_new_format);

2047:
2048: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM',l_contract_number);
2049: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR',l_requestor);
2050: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER',l_approver);
2051: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWINVFOR',l_new_format);
2052: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURINVFOR',l_current_format);
2053: -- the error notification goes to the l_admin through WF default error processing
2054: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
2055: resultout := 'COMPLETE';

Line 2052: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURINVFOR',l_current_format);

2048: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM',l_contract_number);
2049: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR',l_requestor);
2050: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER',l_approver);
2051: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWINVFOR',l_new_format);
2052: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURINVFOR',l_current_format);
2053: -- the error notification goes to the l_admin through WF default error processing
2054: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
2055: resultout := 'COMPLETE';
2056:

Line 2054: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);

2050: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCAPPROVER',l_approver);
2051: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWINVFOR',l_new_format);
2052: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURINVFOR',l_current_format);
2053: -- the error notification goes to the l_admin through WF default error processing
2054: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
2055: resultout := 'COMPLETE';
2056:
2057: return;
2058: end if;

Line 2080: resultout := wf_engine.eng_timedout;

2076: end if;
2077: if ( funcmode = 'TIMEOUT' ) then
2078: resultout := 'COMPLETE';
2079: else
2080: resultout := wf_engine.eng_timedout;
2081: return;
2082: end if;
2083:
2084: exception

Line 2143: l_contract_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');

2139: begin
2140:
2141:
2142: -- get attribute values from WF
2143: l_contract_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
2144: l_contract_number:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKNUM');
2145: l_invoice_format:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINVFORID'); --SSCNEWINVFOR -> Changed for bug 8933871 by nikshah
2146: open org_info(l_contract_id);
2147: fetch org_info into l_org_info;

Line 2144: l_contract_number:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKNUM');

2140:
2141:
2142: -- get attribute values from WF
2143: l_contract_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
2144: l_contract_number:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKNUM');
2145: l_invoice_format:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINVFORID'); --SSCNEWINVFOR -> Changed for bug 8933871 by nikshah
2146: open org_info(l_contract_id);
2147: fetch org_info into l_org_info;
2148: close org_info ;

Line 2145: l_invoice_format:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINVFORID'); --SSCNEWINVFOR -> Changed for bug 8933871 by nikshah

2141:
2142: -- get attribute values from WF
2143: l_contract_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID');
2144: l_contract_number:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKNUM');
2145: l_invoice_format:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINVFORID'); --SSCNEWINVFOR -> Changed for bug 8933871 by nikshah
2146: open org_info(l_contract_id);
2147: fetch org_info into l_org_info;
2148: close org_info ;
2149: MO_GLOBAL.set_policy_context('S',l_org_info);

Line 2299: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);

2295: if ( funcmode = 'RUN' ) then
2296:
2297: l_admin := 'SYSADMIN';
2298: -- assign variable to attribute
2299: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
2300:
2301: -- retrieve attributes from workflow engine
2302: p_chrid:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2303: p_requestor_userid:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));

Line 2302: p_chrid:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));

2298: -- assign variable to attribute
2299: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
2300:
2301: -- retrieve attributes from workflow engine
2302: p_chrid:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2303: p_requestor_userid:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
2304: p_new_billing_site_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEID'));
2305: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
2306: open org_info(p_chrid);

Line 2303: p_requestor_userid:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));

2299: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
2300:
2301: -- retrieve attributes from workflow engine
2302: p_chrid:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2303: p_requestor_userid:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
2304: p_new_billing_site_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEID'));
2305: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
2306: open org_info(p_chrid);
2307: fetch org_info into l_org_info;

Line 2304: p_new_billing_site_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEID'));

2300:
2301: -- retrieve attributes from workflow engine
2302: p_chrid:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2303: p_requestor_userid:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
2304: p_new_billing_site_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEID'));
2305: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
2306: open org_info(p_chrid);
2307: fetch org_info into l_org_info;
2308: close org_info ;

Line 2305: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');

2301: -- retrieve attributes from workflow engine
2302: p_chrid:=to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2303: p_requestor_userid:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID'));
2304: p_new_billing_site_id:=to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEID'));
2305: l_resp_key :=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCAPPROVERRESPONSIBILITYKEY');
2306: open org_info(p_chrid);
2307: fetch org_info into l_org_info;
2308: close org_info ;
2309: MO_GLOBAL.set_policy_context('S',l_org_info);

Line 2341: wf_engine.SetItemAttrText (itemtype => itemtype ,

2337: FROM fnd_responsibility
2338: WHERE responsibility_key = l_resp_key -- This example is for 'Lease Center Agent' responsibility
2339: AND application_id = 540;
2340:
2341: wf_engine.SetItemAttrText (itemtype => itemtype ,
2342: itemkey => itemkey ,
2343: aname => 'SSC_NTFRECIPIENT_ITMATTR',
2344: avalue => l_respString || l_respId);
2345:

Line 2348: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM', l_contract_number );

2344: avalue => l_respString || l_respId);
2345:
2346:
2347:
2348: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM', l_contract_number );
2349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_username);
2350: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITEADDRESS', l_current_billing_address );
2351: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITE',l_current_billing_site);
2352: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITE',l_new_billing_site);

Line 2349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_username);

2345:
2346:
2347:
2348: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM', l_contract_number );
2349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_username);
2350: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITEADDRESS', l_current_billing_address );
2351: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITE',l_current_billing_site);
2352: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITE',l_new_billing_site);
2353: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEADDRESS',l_new_billing_address);

Line 2350: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITEADDRESS', l_current_billing_address );

2346:
2347:
2348: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM', l_contract_number );
2349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_username);
2350: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITEADDRESS', l_current_billing_address );
2351: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITE',l_current_billing_site);
2352: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITE',l_new_billing_site);
2353: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEADDRESS',l_new_billing_address);
2354:

Line 2351: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITE',l_current_billing_site);

2347:
2348: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM', l_contract_number );
2349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_username);
2350: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITEADDRESS', l_current_billing_address );
2351: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITE',l_current_billing_site);
2352: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITE',l_new_billing_site);
2353: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEADDRESS',l_new_billing_address);
2354:
2355: resultout := 'COMPLETE';

Line 2352: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITE',l_new_billing_site);

2348: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCKNUM', l_contract_number );
2349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_username);
2350: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITEADDRESS', l_current_billing_address );
2351: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITE',l_current_billing_site);
2352: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITE',l_new_billing_site);
2353: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEADDRESS',l_new_billing_address);
2354:
2355: resultout := 'COMPLETE';
2356:

Line 2353: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEADDRESS',l_new_billing_address);

2349: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTOR', l_username);
2350: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITEADDRESS', l_current_billing_address );
2351: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCURBILLSITE',l_current_billing_site);
2352: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITE',l_new_billing_site);
2353: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEADDRESS',l_new_billing_address);
2354:
2355: resultout := 'COMPLETE';
2356:
2357: return;

Line 2380: resultout := wf_engine.eng_timedout;

2376: end if;
2377: if ( funcmode = 'TIMEOUT' ) then
2378: resultout := 'COMPLETE';
2379: else
2380: resultout := wf_engine.eng_timedout;
2381: return;
2382: end if;
2383:
2384: exception

Line 2425: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);

2421: if ( funcmode = 'RUN' ) then
2422:
2423: l_admin := 'SYSADMIN';
2424: -- assign variable to attribute
2425: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
2426:
2427:
2428: --retrieve from the workflow engine
2429: l_contract_id := to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));

Line 2429: l_contract_id := to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));

2425: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'WF_ADMINISTRATOR',l_admin);
2426:
2427:
2428: --retrieve from the workflow engine
2429: l_contract_id := to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2430: l_billing_site_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEID'));
2431: l_org_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
2432: l_chrv_rec.ID := l_contract_id;
2433: /* Bug 3292221 SPILLAIP changed l_khrv_rec.khr_id to id */

Line 2430: l_billing_site_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEID'));

2426:
2427:
2428: --retrieve from the workflow engine
2429: l_contract_id := to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2430: l_billing_site_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEID'));
2431: l_org_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
2432: l_chrv_rec.ID := l_contract_id;
2433: /* Bug 3292221 SPILLAIP changed l_khrv_rec.khr_id to id */
2434: l_khrv_rec.ID := l_contract_id;

Line 2431: l_org_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');

2427:
2428: --retrieve from the workflow engine
2429: l_contract_id := to_number( WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCKID'));
2430: l_billing_site_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCNEWBILLSITEID'));
2431: l_org_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORG_ID');
2432: l_chrv_rec.ID := l_contract_id;
2433: /* Bug 3292221 SPILLAIP changed l_khrv_rec.khr_id to id */
2434: l_khrv_rec.ID := l_contract_id;
2435: l_chrv_rec.bill_to_site_use_id := l_billing_site_id;

Line 2486: resultout := wf_engine.eng_timedout;

2482: end if;
2483: if ( funcmode = 'TIMEOUT' ) then
2484: resultout := 'COMPLETE';
2485: else
2486: resultout := wf_engine.eng_timedout;
2487: return;
2488: end if;
2489:
2490: EXCEPTION

Line 2634: l_pol_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPOLID');

2630:
2631: if ( funcmode = 'RUN' ) then
2632:
2633: --Read attributes from WorkFlow
2634: l_pol_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPOLID');
2635: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');
2636: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
2637:
2638: --Read from table

Line 2635: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');

2631: if ( funcmode = 'RUN' ) then
2632:
2633: --Read attributes from WorkFlow
2634: l_pol_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPOLID');
2635: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');
2636: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
2637:
2638: --Read from table
2639: open policy_info_cur(l_pol_id);

Line 2636: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');

2632:
2633: --Read attributes from WorkFlow
2634: l_pol_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCINSPOLID');
2635: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');
2636: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
2637:
2638: --Read from table
2639: open policy_info_cur(l_pol_id);
2640: fetch policy_info_cur into l_pol_number,l_iss_code, l_cancel_date,l_chr_id ;

Line 2667: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );

2663: WHERE responsibility_key = l_resp_key
2664: AND application_id = 540;
2665:
2666:
2667: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
2668: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
2669: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLNUMBER', l_pol_number);
2670: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLSTATUS', l_pol_status);
2671: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCANCELDATE', l_cancel_date);

Line 2668: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);

2664: AND application_id = 540;
2665:
2666:
2667: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
2668: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
2669: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLNUMBER', l_pol_number);
2670: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLSTATUS', l_pol_status);
2671: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCANCELDATE', l_cancel_date);
2672: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);

Line 2669: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLNUMBER', l_pol_number);

2665:
2666:
2667: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
2668: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
2669: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLNUMBER', l_pol_number);
2670: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLSTATUS', l_pol_status);
2671: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCANCELDATE', l_cancel_date);
2672: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
2673: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);

Line 2670: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLSTATUS', l_pol_status);

2666:
2667: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
2668: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
2669: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLNUMBER', l_pol_number);
2670: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLSTATUS', l_pol_status);
2671: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCANCELDATE', l_cancel_date);
2672: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
2673: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);
2674:

Line 2671: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCANCELDATE', l_cancel_date);

2667: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
2668: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
2669: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLNUMBER', l_pol_number);
2670: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLSTATUS', l_pol_status);
2671: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCANCELDATE', l_cancel_date);
2672: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
2673: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);
2674:
2675: resultout := 'COMPLETE';

Line 2672: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);

2668: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
2669: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLNUMBER', l_pol_number);
2670: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLSTATUS', l_pol_status);
2671: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCANCELDATE', l_cancel_date);
2672: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
2673: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);
2674:
2675: resultout := 'COMPLETE';
2676:

Line 2673: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);

2669: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLNUMBER', l_pol_number);
2670: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPOLSTATUS', l_pol_status);
2671: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCANCELDATE', l_cancel_date);
2672: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
2673: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);
2674:
2675: resultout := 'COMPLETE';
2676:
2677: return;

Line 2700: resultout := wf_engine.eng_timedout;

2696: end if;
2697: if ( funcmode = 'TIMEOUT' ) then
2698: resultout := 'COMPLETE';
2699: else
2700: resultout := wf_engine.eng_timedout;
2701: return;
2702: end if;
2703:
2704: exception

Line 2879: p_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');

2875: BEGIN
2876:
2877: if ( funcmode = 'RUN' ) then
2878:
2879: p_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
2880: p_claim_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'CLAIM_ID');
2881:
2882:
2883: -- SET RECEIVER

Line 2880: p_claim_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'CLAIM_ID');

2876:
2877: if ( funcmode = 'RUN' ) then
2878:
2879: p_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
2880: p_claim_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'CLAIM_ID');
2881:
2882:
2883: -- SET RECEIVER
2884: open receiver_cur(p_resp_key);

Line 2889: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSC_NTFRECIPIENT_ITMATTR', l_approver_name);

2885: fetch receiver_cur into l_approver_id;
2886: close receiver_cur;
2887: l_approver_name := l_respString||TO_CHAR(l_approver_id);
2888:
2889: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSC_NTFRECIPIENT_ITMATTR', l_approver_name);
2890:
2891: -- SET CLAIM NUMBER
2892: open claim_info(p_claim_id);
2893: fetch claim_info into l_policy_number,l_claim_number ;

Line 2901: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'POLICY_NUMBER', l_policy_number);

2897: FND_MSG_PUB.ADD;
2898: raise api_exception;
2899: END IF ;
2900:
2901: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'POLICY_NUMBER', l_policy_number);
2902: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'CLAIM_NUMBER', l_claim_number);
2903:
2904:
2905:

Line 2902: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'CLAIM_NUMBER', l_claim_number);

2898: raise api_exception;
2899: END IF ;
2900:
2901: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'POLICY_NUMBER', l_policy_number);
2902: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'CLAIM_NUMBER', l_claim_number);
2903:
2904:
2905:
2906: close claim_info;

Line 2936: resultout := wf_engine.eng_timedout;

2932: end if;
2933: if ( funcmode = 'TIMEOUT' ) then
2934: resultout := 'COMPLETE';
2935: else
2936: resultout := wf_engine.eng_timedout;
2937: return;
2938: end if;
2939:
2940: exception

Line 3018: wf_engine.SetItemAttrText (itemtype => itemtype,

3014: j := NVL(FND_MSG_PUB.Count_Msg,0);
3015: if (j=0) then return; end if;
3016: if (j>9) then j:=9; end if;
3017: FOR I IN 1..J LOOP
3018: wf_engine.SetItemAttrText (itemtype => itemtype,
3019: itemkey => itemkey,
3020: aname => 'MESSAGE'||i,
3021: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3022: END LOOP;

Line 3445: l_payment_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYMENTID');

3441:
3442: if ( funcmode = 'RUN' ) then
3443:
3444: --Read attributes from WorkFlow
3445: l_payment_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYMENTID');
3446: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');
3447: l_payment_number:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYMENTREFNUMBER');
3448:
3449:

Line 3446: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');

3442: if ( funcmode = 'RUN' ) then
3443:
3444: --Read attributes from WorkFlow
3445: l_payment_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYMENTID');
3446: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');
3447: l_payment_number:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYMENTREFNUMBER');
3448:
3449:
3450: --Read from table

Line 3447: l_payment_number:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYMENTREFNUMBER');

3443:
3444: --Read attributes from WorkFlow
3445: l_payment_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYMENTID');
3446: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');
3447: l_payment_number:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYMENTREFNUMBER');
3448:
3449:
3450: --Read from table
3451: open cust_id_info_cur(l_payment_id);

Line 3460: l_payee_role := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYEEROLE');

3456: fetch cust_name_info_cur into l_cust_name;
3457: close cust_name_info_cur;
3458:
3459:
3460: l_payee_role := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCPAYEEROLE');
3461:
3462: SELECT responsibility_id
3463: into l_resp_id
3464: FROM fnd_responsibility

Line 3468: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCACCOUNTNAME', l_cust_name );

3464: FROM fnd_responsibility
3465: WHERE responsibility_key = l_payee_role
3466: AND application_id = 540;
3467:
3468: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCACCOUNTNAME', l_cust_name );
3469: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPAYMENTNUM', l_payment_number);
3470: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPAYEEPERFORMER', l_respString || l_resp_id );
3471:
3472: resultout := 'COMPLETE';

Line 3469: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPAYMENTNUM', l_payment_number);

3465: WHERE responsibility_key = l_payee_role
3466: AND application_id = 540;
3467:
3468: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCACCOUNTNAME', l_cust_name );
3469: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPAYMENTNUM', l_payment_number);
3470: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPAYEEPERFORMER', l_respString || l_resp_id );
3471:
3472: resultout := 'COMPLETE';
3473:

Line 3470: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPAYEEPERFORMER', l_respString || l_resp_id );

3466: AND application_id = 540;
3467:
3468: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCACCOUNTNAME', l_cust_name );
3469: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPAYMENTNUM', l_payment_number);
3470: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPAYEEPERFORMER', l_respString || l_resp_id );
3471:
3472: resultout := 'COMPLETE';
3473:
3474: return;

Line 3497: resultout := wf_engine.eng_timedout;

3493: end if;
3494: if ( funcmode = 'TIMEOUT' ) then
3495: resultout := 'COMPLETE';
3496: else
3497: resultout := wf_engine.eng_timedout;
3498: return;
3499: end if;
3500:
3501: exception

Line 3731: l_qte_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCQUOTEID');

3727:
3728: if ( funcmode = 'RUN' ) then
3729:
3730: --Read attributes from WorkFlow
3731: l_qte_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCQUOTEID');
3732: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');
3733: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
3734:
3735:

Line 3732: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');

3728: if ( funcmode = 'RUN' ) then
3729:
3730: --Read attributes from WorkFlow
3731: l_qte_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCQUOTEID');
3732: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');
3733: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
3734:
3735:
3736: --Read from table

Line 3733: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');

3729:
3730: --Read attributes from WorkFlow
3731: l_qte_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCQUOTEID');
3732: l_requestor_id:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCREQUESTORID');
3733: l_resp_key:=WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCRESPONSIBILITYKEY');
3734:
3735:
3736: --Read from table
3737: open quote_info_cur(l_qte_id);

Line 3755: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );

3751: FROM fnd_responsibility
3752: WHERE responsibility_key = l_resp_key
3753: AND application_id = 540;
3754:
3755: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
3756: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
3757: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQUOTENUMBER', l_qte_number);
3758: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQTP', l_qtp);
3759: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQRS', l_qrs);

Line 3756: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);

3752: WHERE responsibility_key = l_resp_key
3753: AND application_id = 540;
3754:
3755: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
3756: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
3757: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQUOTENUMBER', l_qte_number);
3758: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQTP', l_qtp);
3759: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQRS', l_qrs);
3760: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);

Line 3757: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQUOTENUMBER', l_qte_number);

3753: AND application_id = 540;
3754:
3755: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
3756: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
3757: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQUOTENUMBER', l_qte_number);
3758: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQTP', l_qtp);
3759: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQRS', l_qrs);
3760: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
3761: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);

Line 3758: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQTP', l_qtp);

3754:
3755: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
3756: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
3757: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQUOTENUMBER', l_qte_number);
3758: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQTP', l_qtp);
3759: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQRS', l_qrs);
3760: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
3761: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);
3762:

Line 3759: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQRS', l_qrs);

3755: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCONTRACTNUMBER', l_chr_number );
3756: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
3757: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQUOTENUMBER', l_qte_number);
3758: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQTP', l_qtp);
3759: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQRS', l_qrs);
3760: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
3761: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);
3762:
3763: resultout := 'COMPLETE';

Line 3760: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);

3756: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCREQUESTORNAME', l_user_name);
3757: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQUOTENUMBER', l_qte_number);
3758: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQTP', l_qtp);
3759: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQRS', l_qrs);
3760: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
3761: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);
3762:
3763: resultout := 'COMPLETE';
3764:

Line 3761: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);

3757: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQUOTENUMBER', l_qte_number);
3758: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQTP', l_qtp);
3759: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCQRS', l_qrs);
3760: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCCOMMENTS', l_comments);
3761: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SSCPERFORMER', l_respString||l_resp_id);
3762:
3763: resultout := 'COMPLETE';
3764:
3765: return;

Line 3788: resultout := wf_engine.eng_timedout;

3784: end if;
3785: if ( funcmode = 'TIMEOUT' ) then
3786: resultout := 'COMPLETE';
3787: else
3788: resultout := wf_engine.eng_timedout;
3789: return;
3790: end if;
3791:
3792: exception