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_CS_WF dependencies on WF_ENGINE

Line 133: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,

129: l_msg_data VARCHAR2(2000);
130: BEGIN
131:
132: if (funcmode = 'RUN') then
133: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,
134: itemkey => itemkey,
135: aname => 'TAS_ID');
136:
137: okl_equipment_exchange_pub.exchange(

Line 202: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,

198: WHERE ID=c_tas_id;
199:
200: BEGIN
201: if (funcmode = 'RUN') then
202: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,
203: itemkey => itemkey,
204: aname => 'TAS_ID');
205:
206:

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

286: l_restruct_role := 'SYSADMIN';
287: END IF;
288: l_request_number := x_thpv_tbl(1).trans_number;
289:
290: wf_engine.SetItemAttrText ( itemtype=> itemtype,
291: itemkey => itemkey,
292: aname => 'OKLCSEQUIP_RESTRUCTURE_ROLE',
293: avalue => l_restruct_role);
294: --Header Information

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

291: itemkey => itemkey,
292: aname => 'OKLCSEQUIP_RESTRUCTURE_ROLE',
293: avalue => l_restruct_role);
294: --Header Information
295: wf_engine.SetItemAttrText ( itemtype=> itemtype,
296: itemkey => itemkey,
297: aname => 'CONTRACT_NUMBER',
298: avalue => l_contract_number);
299: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

295: wf_engine.SetItemAttrText ( itemtype=> itemtype,
296: itemkey => itemkey,
297: aname => 'CONTRACT_NUMBER',
298: avalue => l_contract_number);
299: wf_engine.SetItemAttrText ( itemtype=> itemtype,
300: itemkey => itemkey,
301: aname => 'REQUEST_NUMBER',
302: avalue => l_request_number);
303: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

299: wf_engine.SetItemAttrText ( itemtype=> itemtype,
300: itemkey => itemkey,
301: aname => 'REQUEST_NUMBER',
302: avalue => l_request_number);
303: wf_engine.SetItemAttrText ( itemtype=> itemtype,
304: itemkey => itemkey,
305: aname => 'COMMENTS',
306: avalue => x_thpv_tbl(1).comments);
307: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

303: wf_engine.SetItemAttrText ( itemtype=> itemtype,
304: itemkey => itemkey,
305: aname => 'COMMENTS',
306: avalue => x_thpv_tbl(1).comments);
307: wf_engine.SetItemAttrText ( itemtype=> itemtype,
308: itemkey => itemkey,
309: aname => 'RETURN_DATE',
310: avalue => x_old_talv_tbl(1).date_due);
311:

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

310: avalue => x_old_talv_tbl(1).date_due);
311:
312:
313: --Old Asset Information
314: wf_engine.SetItemAttrText ( itemtype=> itemtype,
315: itemkey => itemkey,
316: aname => 'OLD_ASSET_NUMBER',
317: avalue => x_old_talv_tbl(1).asset_number);
318: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

314: wf_engine.SetItemAttrText ( itemtype=> itemtype,
315: itemkey => itemkey,
316: aname => 'OLD_ASSET_NUMBER',
317: avalue => x_old_talv_tbl(1).asset_number);
318: wf_engine.SetItemAttrText ( itemtype=> itemtype,
319: itemkey => itemkey,
320: aname => 'OLD_ASSET_DESC',
321: avalue => x_old_talv_tbl(1).DESCRIPTION);
322: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

318: wf_engine.SetItemAttrText ( itemtype=> itemtype,
319: itemkey => itemkey,
320: aname => 'OLD_ASSET_DESC',
321: avalue => x_old_talv_tbl(1).DESCRIPTION);
322: wf_engine.SetItemAttrText ( itemtype=> itemtype,
323: itemkey => itemkey,
324: aname => 'OLD_COST',
325: avalue => x_old_talv_tbl(1).ORIGINAL_COST);
326: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

322: wf_engine.SetItemAttrText ( itemtype=> itemtype,
323: itemkey => itemkey,
324: aname => 'OLD_COST',
325: avalue => x_old_talv_tbl(1).ORIGINAL_COST);
326: wf_engine.SetItemAttrText ( itemtype=> itemtype,
327: itemkey => itemkey,
328: aname => 'OLD_YEAR',
329: avalue => x_old_talv_tbl(1).YEAR_MANUFACTURED);
330: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

326: wf_engine.SetItemAttrText ( itemtype=> itemtype,
327: itemkey => itemkey,
328: aname => 'OLD_YEAR',
329: avalue => x_old_talv_tbl(1).YEAR_MANUFACTURED);
330: wf_engine.SetItemAttrText ( itemtype=> itemtype,
331: itemkey => itemkey,
332: aname => 'OLD_MODEL',
333: avalue => x_old_talv_tbl(1).MODEL_NUMBER);
334: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

330: wf_engine.SetItemAttrText ( itemtype=> itemtype,
331: itemkey => itemkey,
332: aname => 'OLD_MODEL',
333: avalue => x_old_talv_tbl(1).MODEL_NUMBER);
334: wf_engine.SetItemAttrText ( itemtype=> itemtype,
335: itemkey => itemkey,
336: aname => 'OLD_MANUFACTURER',
337: avalue => x_old_talv_tbl(1).MANUFACTURER_NAME);
338: IF x_old_talv_tbl(1).SUPPLIER_ID IS NOT NULL THEN

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

336: aname => 'OLD_MANUFACTURER',
337: avalue => x_old_talv_tbl(1).MANUFACTURER_NAME);
338: IF x_old_talv_tbl(1).SUPPLIER_ID IS NOT NULL THEN
339: l_old_vendor := okl_equipment_exchange_pub.get_vendor_name(x_old_talv_tbl(1).SUPPLIER_ID);
340: wf_engine.SetItemAttrText ( itemtype=> itemtype,
341: itemkey => itemkey,
342: aname => 'OLD_VENDOR',
343: avalue => l_old_vendor);
344: END IF;

Line 347: /* wf_engine.SetItemAttrText ( itemtype=> itemtype,

343: avalue => l_old_vendor);
344: END IF;
345:
346: --New Asset Information
347: /* wf_engine.SetItemAttrText ( itemtype=> itemtype,
348: itemkey => itemkey,
349: aname => 'OLD_ASSET_NUMBER',
350: avalue => x_new_talv_tbl(1).asset_number);
351: */

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

350: avalue => x_new_talv_tbl(1).asset_number);
351: */
352: --Bug# 5362977
353: -- Set attribute NEW_ASSET_DESC with new asset description
354: wf_engine.SetItemAttrText ( itemtype=> itemtype,
355: itemkey => itemkey,
356: aname => 'NEW_ASSET_DESC',
357: avalue => x_new_talv_tbl(1).DESCRIPTION);
358:

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

355: itemkey => itemkey,
356: aname => 'NEW_ASSET_DESC',
357: avalue => x_new_talv_tbl(1).DESCRIPTION);
358:
359: wf_engine.SetItemAttrText ( itemtype=> itemtype,
360: itemkey => itemkey,
361: aname => 'NEW_COST',
362: avalue => x_new_talv_tbl(1).ORIGINAL_COST);
363: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

359: wf_engine.SetItemAttrText ( itemtype=> itemtype,
360: itemkey => itemkey,
361: aname => 'NEW_COST',
362: avalue => x_new_talv_tbl(1).ORIGINAL_COST);
363: wf_engine.SetItemAttrText ( itemtype=> itemtype,
364: itemkey => itemkey,
365: aname => 'NEW_YEAR',
366: avalue => x_new_talv_tbl(1).YEAR_MANUFACTURED);
367: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

363: wf_engine.SetItemAttrText ( itemtype=> itemtype,
364: itemkey => itemkey,
365: aname => 'NEW_YEAR',
366: avalue => x_new_talv_tbl(1).YEAR_MANUFACTURED);
367: wf_engine.SetItemAttrText ( itemtype=> itemtype,
368: itemkey => itemkey,
369: aname => 'NEW_MODEL',
370: avalue => x_new_talv_tbl(1).MODEL_NUMBER);
371: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

367: wf_engine.SetItemAttrText ( itemtype=> itemtype,
368: itemkey => itemkey,
369: aname => 'NEW_MODEL',
370: avalue => x_new_talv_tbl(1).MODEL_NUMBER);
371: wf_engine.SetItemAttrText ( itemtype=> itemtype,
372: itemkey => itemkey,
373: aname => 'NEW_MANUFACTURER',
374: avalue => x_new_talv_tbl(1).MANUFACTURER_NAME);
375: IF x_new_talv_tbl(1).SUPPLIER_ID IS NOT NULL THEN

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

373: aname => 'NEW_MANUFACTURER',
374: avalue => x_new_talv_tbl(1).MANUFACTURER_NAME);
375: IF x_new_talv_tbl(1).SUPPLIER_ID IS NOT NULL THEN
376: l_new_vendor := okl_equipment_exchange_pub.get_vendor_name(x_new_talv_tbl(1).SUPPLIER_ID);
377: wf_engine.SetItemAttrText ( itemtype=> itemtype,
378: itemkey => itemkey,
379: aname => 'NEW_VENDOR',
380: avalue => l_new_vendor);
381: END IF;

Line 394: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,

390: l_tas_id NUMBER;
391: l_exchange_type VARCHAR2(60);
392: BEGIN
393: if (funcmode = 'RUN') then
394: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,
395: itemkey => itemkey,
396: aname => 'TAS_ID');
397: l_exchange_type := okl_equipment_exchange_pub.get_exchange_type(l_tas_id);
398:

Line 443: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,

439: l_tas_id NUMBER;
440: l_exchange_type VARCHAR2(60);
441: BEGIN
442: if (funcmode = 'RUN') then
443: l_tas_id := wf_engine.GetItemAttrText( itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'TAS_ID');
446: l_exchange_type := okl_equipment_exchange_pub.get_exchange_type(l_tas_id);
447: IF l_exchange_type = 'LLT' THEN

Line 540: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

536: WHERE ID=p_trx_id;
537:
538: BEGIN
539: if (funcmode = 'RUN') then
540: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
541: itemkey => itemkey,
542: aname => 'TRX_ID');
543:
544:

Line 692: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

688: END IF;
689:
690:
691: -- Get the value of the request id
692: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
693: itemkey => itemkey,
694: aname => 'TRX_ID');
695:
696: OPEN c_req_record(l_trx_id);

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

733: --rkuttiya changed recipient type to LESSEE for XMLP
734: l_recipient_type := 'LESSEE';
735:
736: --rkuttiya added for Bug:4257336
737: wf_engine.SetItemAttrText(itemtype => itemtype,
738: itemkey => itemkey,
739: aname => 'CONTRACT_ID',
740: avalue => l_req_rec.khr_id);
741: --end changes for Bug:4257336

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

739: aname => 'CONTRACT_ID',
740: avalue => l_req_rec.khr_id);
741: --end changes for Bug:4257336
742:
743: wf_engine.SetItemAttrText(itemtype => itemtype,
744: itemkey => itemkey,
745: aname => 'CREATED_BY',
746: avalue => l_requestor_id);
747: wf_engine.SetItemAttrText(itemtype => itemtype,

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

743: wf_engine.SetItemAttrText(itemtype => itemtype,
744: itemkey => itemkey,
745: aname => 'CREATED_BY',
746: avalue => l_requestor_id);
747: wf_engine.SetItemAttrText(itemtype => itemtype,
748: itemkey => itemkey,
749: aname => 'REQUESTER',
750: avalue => l_requestor);
751: wf_engine.SetItemAttrText(itemtype => itemtype,

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

747: wf_engine.SetItemAttrText(itemtype => itemtype,
748: itemkey => itemkey,
749: aname => 'REQUESTER',
750: avalue => l_requestor);
751: wf_engine.SetItemAttrText(itemtype => itemtype,
752: itemkey => itemkey,
753: aname => 'NOTIFY_AGENT',
754: avalue => l_requestor);
755: wf_engine.SetItemAttrText(itemtype => itemtype,

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

751: wf_engine.SetItemAttrText(itemtype => itemtype,
752: itemkey => itemkey,
753: aname => 'NOTIFY_AGENT',
754: avalue => l_requestor);
755: wf_engine.SetItemAttrText(itemtype => itemtype,
756: itemkey => itemkey,
757: aname => 'RECIPIENT_TYPE',
758: avalue => l_recipient_type);
759: wf_engine.SetItemAttrText(itemtype => itemtype,

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

755: wf_engine.SetItemAttrText(itemtype => itemtype,
756: itemkey => itemkey,
757: aname => 'RECIPIENT_TYPE',
758: avalue => l_recipient_type);
759: wf_engine.SetItemAttrText(itemtype => itemtype,
760: itemkey => itemkey,
761: aname => 'PROCESS_CODE',
762: avalue => 'CSTSFRASU');
763: wf_engine.SetItemAttrText(itemtype => itemtype,

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

759: wf_engine.SetItemAttrText(itemtype => itemtype,
760: itemkey => itemkey,
761: aname => 'PROCESS_CODE',
762: avalue => 'CSTSFRASU');
763: wf_engine.SetItemAttrText(itemtype => itemtype,
764: itemkey => itemkey,
765: aname => 'SERVICE_FEE_CODE',
766: avalue => 'CSTSFRFEE');
767: wf_engine.SetItemAttrText(itemtype => itemtype,

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

763: wf_engine.SetItemAttrText(itemtype => itemtype,
764: itemkey => itemkey,
765: aname => 'SERVICE_FEE_CODE',
766: avalue => 'CSTSFRFEE');
767: wf_engine.SetItemAttrText(itemtype => itemtype,
768: itemkey => itemkey,
769: aname => 'FROM_ADDRESS',
770: avalue => l_from_email);
771:

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

768: itemkey => itemkey,
769: aname => 'FROM_ADDRESS',
770: avalue => l_from_email);
771:
772: wf_engine.SetItemAttrText (itemtype=> itemtype,
773: itemkey => itemkey,
774: aname => 'CUST_ROLE',
775: avalue => l_cust_role) ;
776:

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

773: itemkey => itemkey,
774: aname => 'CUST_ROLE',
775: avalue => l_cust_role) ;
776:
777: wf_engine.SetItemAttrText (itemtype=> itemtype,
778: itemkey => itemkey,
779: aname => 'ROLE_CREDIT',
780: avalue => l_credit_role) ;
781: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

777: wf_engine.SetItemAttrText (itemtype=> itemtype,
778: itemkey => itemkey,
779: aname => 'ROLE_CREDIT',
780: avalue => l_credit_role) ;
781: wf_engine.SetItemAttrText (itemtype=> itemtype,
782: itemkey => itemkey,
783: aname => 'ROLE_ADMIN',
784: avalue => l_ctr_admin_role) ;
785: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

781: wf_engine.SetItemAttrText (itemtype=> itemtype,
782: itemkey => itemkey,
783: aname => 'ROLE_ADMIN',
784: avalue => l_ctr_admin_role) ;
785: wf_engine.SetItemAttrText (itemtype=> itemtype,
786: itemkey => itemkey,
787: aname => 'ROLE_VND',
788: avalue => l_vendor_role) ;
789: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

785: wf_engine.SetItemAttrText (itemtype=> itemtype,
786: itemkey => itemkey,
787: aname => 'ROLE_VND',
788: avalue => l_vendor_role) ;
789: wf_engine.SetItemAttrText (itemtype=> itemtype,
790: itemkey => itemkey,
791: aname => 'ROLE_COLLECTION',
792: avalue => l_collections_role) ;
793:

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

792: avalue => l_collections_role) ;
793:
794:
795:
796: wf_engine.SetItemAttrText (itemtype=> itemtype,
797: itemkey => itemkey,
798: aname => 'CONTRACT_NUMBER',
799: avalue => l_ctr_no) ;
800: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

796: wf_engine.SetItemAttrText (itemtype=> itemtype,
797: itemkey => itemkey,
798: aname => 'CONTRACT_NUMBER',
799: avalue => l_ctr_no) ;
800: wf_engine.SetItemAttrText (itemtype=> itemtype,
801: itemkey => itemkey,
802: aname => 'TRANSACTION_ID',
803: avalue => l_trx_id) ;
804:

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

802: aname => 'TRANSACTION_ID',
803: avalue => l_trx_id) ;
804:
805: --rkuttiya added for bug: 4056337
806: wf_engine.SetItemAttrText (itemtype=> itemtype,
807: itemkey => itemkey,
808: aname => 'TRANSFER_DATE',
809: avalue => l_transfer_date) ;
810:

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

808: aname => 'TRANSFER_DATE',
809: avalue => l_transfer_date) ;
810:
811:
812: wf_engine.SetItemAttrText (itemtype=> itemtype,
813: itemkey => itemkey,
814: aname => 'OLD_LESSEE',
815: avalue => l_party_name) ;
816:

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

813: itemkey => itemkey,
814: aname => 'OLD_LESSEE',
815: avalue => l_party_name) ;
816:
817: wf_engine.SetItemAttrText (itemtype=> itemtype,
818: itemkey => itemkey,
819: aname => 'REQUEST_NUMBER',
820: avalue => l_req_no) ;
821:

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

821:
822:
823: IF l_req_rec.complete_transfer_yn = 'N' THEN
824: l_type := 'Partial';
825: wf_engine.SetItemAttrText (itemtype=> itemtype,
826: itemkey => itemkey,
827: aname => 'TRANSFER_TYPE',
828: avalue => 'Partial') ;
829: ELSIF l_req_rec.complete_transfer_yn = 'Y' THEN

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

827: aname => 'TRANSFER_TYPE',
828: avalue => 'Partial') ;
829: ELSIF l_req_rec.complete_transfer_yn = 'Y' THEN
830: l_type := 'Complete';
831: wf_engine.SetItemAttrText (itemtype=> itemtype,
832: itemkey => itemkey,
833: aname => 'TRANSFER_TYPE',
834: avalue => 'Complete') ;
835: END IF;

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

848: ( p_count => l_msg_count,
849: p_data => l_msg_data);
850: Get_Messages(l_msg_count,l_error);
851:
852: wf_engine.SetItemAttrText(itemtype => itemtype,
853: itemkey => itemkey,
854: aname => 'ERROR_MESSAGE',
855: avalue => l_error);
856:

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

855: avalue => l_error);
856:
857: resultout := 'COMPLETE:N';
858: ELSE
859: wf_engine.SetItemAttrText (itemtype=> itemtype,
860: itemkey => itemkey,
861: aname => 'NEW_CONTRACT_NUMBER',
862: avalue => lx_new_lessee_tbl(1).new_contract_number) ;
863:

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

860: itemkey => itemkey,
861: aname => 'NEW_CONTRACT_NUMBER',
862: avalue => lx_new_lessee_tbl(1).new_contract_number) ;
863:
864: wf_engine.SetItemAttrText (itemtype=> itemtype,
865: itemkey => itemkey,
866: aname => 'NEW_LESSEE',
867: avalue => lx_new_lessee_tbl(1).new_lessee);
868: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

864: wf_engine.SetItemAttrText (itemtype=> itemtype,
865: itemkey => itemkey,
866: aname => 'NEW_LESSEE',
867: avalue => lx_new_lessee_tbl(1).new_lessee);
868: wf_engine.SetItemAttrText (itemtype=> itemtype,
869: itemkey => itemkey,
870: aname => 'RECIPIENT_DESCRIPTION',
871: avalue => lx_new_lessee_tbl(1).contact_name);
872: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

868: wf_engine.SetItemAttrText (itemtype=> itemtype,
869: itemkey => itemkey,
870: aname => 'RECIPIENT_DESCRIPTION',
871: avalue => lx_new_lessee_tbl(1).contact_name);
872: wf_engine.SetItemAttrText (itemtype=> itemtype,
873: itemkey => itemkey,
874: aname => 'EMAIL_ADDRESS',
875: avalue => lx_new_lessee_tbl(1).contact_email);
876: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

872: wf_engine.SetItemAttrText (itemtype=> itemtype,
873: itemkey => itemkey,
874: aname => 'EMAIL_ADDRESS',
875: avalue => lx_new_lessee_tbl(1).contact_email);
876: wf_engine.SetItemAttrText (itemtype=> itemtype,
877: itemkey => itemkey,
878: aname => 'RECIPIENT_ID',
879: avalue => lx_new_lessee_tbl(1).contact_id);
880: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

876: wf_engine.SetItemAttrText (itemtype=> itemtype,
877: itemkey => itemkey,
878: aname => 'RECIPIENT_ID',
879: avalue => lx_new_lessee_tbl(1).contact_id);
880: wf_engine.SetItemAttrText (itemtype=> itemtype,
881: itemkey => itemkey,
882: aname => 'BILL_TO',
883: avalue => lx_new_lessee_tbl(1).bill_to_address);
884: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

880: wf_engine.SetItemAttrText (itemtype=> itemtype,
881: itemkey => itemkey,
882: aname => 'BILL_TO',
883: avalue => lx_new_lessee_tbl(1).bill_to_address);
884: wf_engine.SetItemAttrText (itemtype=> itemtype,
885: itemkey => itemkey,
886: aname => 'CUST_ACCT_NUMBER',
887: avalue => lx_new_lessee_tbl(1).cust_acct_number);
888: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

884: wf_engine.SetItemAttrText (itemtype=> itemtype,
885: itemkey => itemkey,
886: aname => 'CUST_ACCT_NUMBER',
887: avalue => lx_new_lessee_tbl(1).cust_acct_number);
888: wf_engine.SetItemAttrText (itemtype=> itemtype,
889: itemkey => itemkey,
890: aname => 'BANK_ACCOUNT',
891: avalue => lx_new_lessee_tbl(1).bank_account);
892: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

888: wf_engine.SetItemAttrText (itemtype=> itemtype,
889: itemkey => itemkey,
890: aname => 'BANK_ACCOUNT',
891: avalue => lx_new_lessee_tbl(1).bank_account);
892: wf_engine.SetItemAttrText (itemtype=> itemtype,
893: itemkey => itemkey,
894: aname => 'INVOICE_FORMAT',
895: avalue => lx_new_lessee_tbl(1).invoice_format);
896: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

892: wf_engine.SetItemAttrText (itemtype=> itemtype,
893: itemkey => itemkey,
894: aname => 'INVOICE_FORMAT',
895: avalue => lx_new_lessee_tbl(1).invoice_format);
896: wf_engine.SetItemAttrText (itemtype=> itemtype,
897: itemkey => itemkey,
898: aname => 'PAYMENT_METHOD',
899: avalue => lx_new_lessee_tbl(1).payment_method);
900: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

896: wf_engine.SetItemAttrText (itemtype=> itemtype,
897: itemkey => itemkey,
898: aname => 'PAYMENT_METHOD',
899: avalue => lx_new_lessee_tbl(1).payment_method);
900: wf_engine.SetItemAttrText (itemtype=> itemtype,
901: itemkey => itemkey,
902: aname => 'MLA_NO',
903: avalue => lx_new_lessee_tbl(1).master_lease);
904: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

900: wf_engine.SetItemAttrText (itemtype=> itemtype,
901: itemkey => itemkey,
902: aname => 'MLA_NO',
903: avalue => lx_new_lessee_tbl(1).master_lease);
904: wf_engine.SetItemAttrText (itemtype=> itemtype,
905: itemkey => itemkey,
906: aname => 'CREDIT_LINE_NUMBER',
907: avalue => lx_new_lessee_tbl(1).credit_line_no);
908:

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

920: ( p_count => l_msg_count,
921: p_data => l_msg_data);
922: Get_Messages(l_msg_count,l_error);
923:
924: wf_engine.SetItemAttrText(itemtype => itemtype,
925: itemkey => itemkey,
926: aname => 'ERROR_MESSAGE',
927: avalue => l_error);
928:

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

927: avalue => l_error);
928:
929: resultout := 'COMPLETE:N';
930: ELSE
931: wf_engine.SetItemAttrText (itemtype=> itemtype,
932: itemkey => itemkey,
933: aname => 'INSURER',
934: avalue => lx_insurance_tbl(1).insurer) ;
935:

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

932: itemkey => itemkey,
933: aname => 'INSURER',
934: avalue => lx_insurance_tbl(1).insurer) ;
935:
936: wf_engine.SetItemAttrText (itemtype=> itemtype,
937: itemkey => itemkey,
938: aname => 'INSURANCE_AGENT',
939: avalue => lx_insurance_tbl(1).insurance_agent);
940: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

936: wf_engine.SetItemAttrText (itemtype=> itemtype,
937: itemkey => itemkey,
938: aname => 'INSURANCE_AGENT',
939: avalue => lx_insurance_tbl(1).insurance_agent);
940: wf_engine.SetItemAttrText (itemtype=> itemtype,
941: itemkey => itemkey,
942: aname => 'POLICY_NUMBER',
943: avalue => lx_insurance_tbl(1).policy_number);
944: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

940: wf_engine.SetItemAttrText (itemtype=> itemtype,
941: itemkey => itemkey,
942: aname => 'POLICY_NUMBER',
943: avalue => lx_insurance_tbl(1).policy_number);
944: wf_engine.SetItemAttrText (itemtype=> itemtype,
945: itemkey => itemkey,
946: aname => 'COVERED_AMOUNT',
947: avalue => lx_insurance_tbl(1).covered_amount);
948: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

944: wf_engine.SetItemAttrText (itemtype=> itemtype,
945: itemkey => itemkey,
946: aname => 'COVERED_AMOUNT',
947: avalue => lx_insurance_tbl(1).covered_amount);
948: wf_engine.SetItemAttrText (itemtype=> itemtype,
949: itemkey => itemkey,
950: aname => 'DEDUCTIBLE_AMOUNT',
951: avalue => lx_insurance_tbl(1).deductible_amount);
952: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

948: wf_engine.SetItemAttrText (itemtype=> itemtype,
949: itemkey => itemkey,
950: aname => 'DEDUCTIBLE_AMOUNT',
951: avalue => lx_insurance_tbl(1).deductible_amount);
952: wf_engine.SetItemAttrText (itemtype=> itemtype,
953: itemkey => itemkey,
954: aname => 'EFFECTIVE_FROM',
955: avalue => lx_insurance_tbl(1).effective_from);
956: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

952: wf_engine.SetItemAttrText (itemtype=> itemtype,
953: itemkey => itemkey,
954: aname => 'EFFECTIVE_FROM',
955: avalue => lx_insurance_tbl(1).effective_from);
956: wf_engine.SetItemAttrText (itemtype=> itemtype,
957: itemkey => itemkey,
958: aname => 'EFFECTIVE_TO',
959: avalue => lx_insurance_tbl(1).effective_to);
960: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

956: wf_engine.SetItemAttrText (itemtype=> itemtype,
957: itemkey => itemkey,
958: aname => 'EFFECTIVE_TO',
959: avalue => lx_insurance_tbl(1).effective_to);
960: wf_engine.SetItemAttrText (itemtype=> itemtype,
961: itemkey => itemkey,
962: aname => 'PROOF_PROVIDED',
963: avalue => lx_insurance_tbl(1).proof_provided);
964: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

960: wf_engine.SetItemAttrText (itemtype=> itemtype,
961: itemkey => itemkey,
962: aname => 'PROOF_PROVIDED',
963: avalue => lx_insurance_tbl(1).proof_provided);
964: wf_engine.SetItemAttrText (itemtype=> itemtype,
965: itemkey => itemkey,
966: aname => 'PROOF_REQUIRED',
967: avalue => lx_insurance_tbl(1).proof_required);
968: IF lx_insurance_tbl(1).lessor_insured_yn = 'Y' THEN

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

965: itemkey => itemkey,
966: aname => 'PROOF_REQUIRED',
967: avalue => lx_insurance_tbl(1).proof_required);
968: IF lx_insurance_tbl(1).lessor_insured_yn = 'Y' THEN
969: wf_engine.SetItemAttrText (itemtype=> itemtype,
970: itemkey => itemkey,
971: aname => 'LESSOR_INSURED_YN',
972: avalue => 'Yes');
973: ELSIF lx_insurance_tbl(1).lessor_insured_yn = 'Y' THEN

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

970: itemkey => itemkey,
971: aname => 'LESSOR_INSURED_YN',
972: avalue => 'Yes');
973: ELSIF lx_insurance_tbl(1).lessor_insured_yn = 'Y' THEN
974: wf_engine.SetItemAttrText (itemtype=> itemtype,
975: itemkey => itemkey,
976: aname => 'LESSOR_INSURED_YN',
977: avalue => 'No');
978: END IF;

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

977: avalue => 'No');
978: END IF;
979:
980: IF lx_insurance_tbl(1).lessor_payee_yn = 'Y' THEN
981: wf_engine.SetItemAttrText (itemtype=> itemtype,
982: itemkey => itemkey,
983: aname => 'LESSOR_PAYEE_YN',
984: avalue => 'Yes');
985: ELSIF lx_insurance_tbl(1).lessor_payee_yn = 'Y' THEN

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

982: itemkey => itemkey,
983: aname => 'LESSOR_PAYEE_YN',
984: avalue => 'Yes');
985: ELSIF lx_insurance_tbl(1).lessor_payee_yn = 'Y' THEN
986: wf_engine.SetItemAttrText (itemtype=> itemtype,
987: itemkey => itemkey,
988: aname => 'LESSOR_PAYEE_YN',
989: avalue => 'No');
990: END IF;

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

1002: 'Type of Transfer :' || l_type ||'

'||
1003: '

Please review further details of the request in the Lease Center.

';
1004:
1005:
1006: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1007: itemkey => itemkey,
1008: aname => 'TRX_TYPE_ID',
1009: avalue => 'OKLCSTRQ');
1010:

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

1007: itemkey => itemkey,
1008: aname => 'TRX_TYPE_ID',
1009: avalue => 'OKLCSTRQ');
1010:
1011: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1012: itemkey => itemkey,
1013: aname => 'MESSAGE_DESCRIPTION',
1014: avalue => l_message);
1015:

Line 1092: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1088:
1089: BEGIN
1090: IF (funcmode = 'RUN') THEN
1091: -- Get the value of the request id
1092: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1093: itemkey => itemkey,
1094: aname => 'TRX_ID');
1095: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1096: itemkey => itemkey,

Line 1095: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,

1091: -- Get the value of the request id
1092: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1093: itemkey => itemkey,
1094: aname => 'TRX_ID');
1095: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1096: itemkey => itemkey,
1097: aname => 'PROCESS_CODE');
1098:
1099: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 1099: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,

1095: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1096: itemkey => itemkey,
1097: aname => 'PROCESS_CODE');
1098:
1099: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,
1100: itemkey => itemkey,
1101: aname => 'CONTACT_EMAIL');
1102:
1103: l_bind_var(1) := 'p_request_id';

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

1135: ( p_count => lx_msg_count,
1136: p_data => lx_msg_data);
1137: Get_Messages(lx_msg_count,l_error);
1138:
1139: wf_engine.SetItemAttrText(itemtype => itemtype,
1140: itemkey => itemkey,
1141: aname => 'ERROR_MESSAGE',
1142: avalue => l_error);
1143:

Line 1214: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1210:
1211: BEGIN
1212: IF (funcmode = 'RUN') THEN
1213: -- Get the value of the request id
1214: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1215: itemkey => itemkey,
1216: aname => 'TRX_ID');
1217: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1218: itemkey => itemkey,

Line 1217: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,

1213: -- Get the value of the request id
1214: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1215: itemkey => itemkey,
1216: aname => 'TRX_ID');
1217: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1218: itemkey => itemkey,
1219: aname => 'PROCESS_CODE');
1220:
1221: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 1221: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,

1217: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1218: itemkey => itemkey,
1219: aname => 'PROCESS_CODE');
1220:
1221: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,
1222: itemkey => itemkey,
1223: aname => 'VENDOR_EMAIL');
1224:
1225: l_bind_var(1) := 'p_request_id';

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

1257: ( p_count => lx_msg_count,
1258: p_data => lx_msg_data);
1259: Get_Messages(lx_msg_count,l_error);
1260:
1261: wf_engine.SetItemAttrText(itemtype => itemtype,
1262: itemkey => itemkey,
1263: aname => 'ERROR_MESSAGE',
1264: avalue => l_error);
1265:

Line 1329: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1325: lx_tclv_tbl tclv_tbl_type;
1326:
1327: BEGIN
1328: IF (funcmode = 'RUN') THEN
1329: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1330: itemkey => itemkey,
1331: aname => 'TRX_ID');
1332: l_status := 'APPROVED';
1333:

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

1349: ( p_count => l_msg_count,
1350: p_data => l_msg_data);
1351: Get_Messages(l_msg_count,l_error);
1352:
1353: wf_engine.SetItemAttrText(itemtype => itemtype,
1354: itemkey => itemkey,
1355: aname => 'ERROR_MESSAGE',
1356: avalue => l_error);
1357: resultout := 'COMPLETE:N';

Line 1418: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1414: l_error VARCHAR2(2000);
1415:
1416: BEGIN
1417: IF (funcmode = 'RUN') THEN
1418: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1419: itemkey => itemkey,
1420: aname => 'TRX_ID');
1421:
1422: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 1422: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,

1418: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1419: itemkey => itemkey,
1420: aname => 'TRX_ID');
1421:
1422: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,
1423: itemkey => itemkey,
1424: aname => 'APPROVED_YN');
1425: IF l_approved_yn = 'Y' THEN
1426: l_status := 'SUBMITTED';

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

1448: ( p_count => l_msg_count,
1449: p_data => l_msg_data);
1450: Get_Messages(l_msg_count,l_error);
1451:
1452: wf_engine.SetItemAttrText(itemtype => itemtype,
1453: itemkey => itemkey,
1454: aname => 'ERROR_MESSAGE',
1455: avalue => l_error);
1456:

Line 1522: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1518:
1519: BEGIN
1520: IF (funcmode = 'RESPOND') THEN
1521: --get request id
1522: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1523: itemkey => itemkey,
1524: aname => 'TRX_ID');
1525:
1526:

Line 1527: --get notification id from wf_engine context

1523: itemkey => itemkey,
1524: aname => 'TRX_ID');
1525:
1526:
1527: --get notification id from wf_engine context
1528: l_nid := WF_ENGINE.CONTEXT_NID;
1529: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1530:
1531: IF l_ntf_result = 'NO' THEN

Line 1528: l_nid := WF_ENGINE.CONTEXT_NID;

1524: aname => 'TRX_ID');
1525:
1526:
1527: --get notification id from wf_engine context
1528: l_nid := WF_ENGINE.CONTEXT_NID;
1529: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1530:
1531: IF l_ntf_result = 'NO' THEN
1532: l_sts_code := 'REJECTED';

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

1560: ( p_count => l_msg_count,
1561: p_data => l_msg_data);
1562: Get_Messages(l_msg_count,l_error);
1563:
1564: wf_engine.SetItemAttrText(itemtype => itemtype,
1565: itemkey => itemkey,
1566: aname => 'ERROR_MESSAGE',
1567: avalue => l_error);
1568:

Line 1584: resultout := wf_engine.eng_null;

1580: --
1581: --Transfer Mode
1582: --
1583: IF funcmode = 'TRANSFER' THEN
1584: resultout := wf_engine.eng_null;
1585: return;
1586: END IF;
1587:
1588: --Run Mode

Line 1658: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1654:
1655: BEGIN
1656: IF (funcmode = 'RESPOND') THEN
1657: --get request id
1658: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1659: itemkey => itemkey,
1660: aname => 'TRX_ID');
1661:
1662:

Line 1663: --get notification id from wf_engine context

1659: itemkey => itemkey,
1660: aname => 'TRX_ID');
1661:
1662:
1663: --get notification id from wf_engine context
1664: l_nid := WF_ENGINE.CONTEXT_NID;
1665: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1666:
1667: --rkuttiya changed for bug#5149488

Line 1664: l_nid := WF_ENGINE.CONTEXT_NID;

1660: aname => 'TRX_ID');
1661:
1662:
1663: --get notification id from wf_engine context
1664: l_nid := WF_ENGINE.CONTEXT_NID;
1665: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1666:
1667: --rkuttiya changed for bug#5149488
1668: IF l_ntf_result = 'VND_REJECTED' THEN

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

1697: ( p_count => l_msg_count,
1698: p_data => l_msg_data);
1699: Get_Messages(l_msg_count,l_error);
1700:
1701: wf_engine.SetItemAttrText(itemtype => itemtype,
1702: itemkey => itemkey,
1703: aname => 'ERROR_MESSAGE',
1704: avalue => l_error);
1705:

Line 1722: resultout := wf_engine.eng_null;

1718: --
1719: --Transfer Mode
1720: --
1721: IF funcmode = 'TRANSFER' THEN
1722: resultout := wf_engine.eng_null;
1723: return;
1724: END IF;
1725:
1726: --rkuttiya added for bug # 5149488

Line 1814: l_ctr_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1810: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1811: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1812: BEGIN
1813: IF funcmode = 'RUN' THEN
1814: l_ctr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1815: itemkey => itemkey,
1816: aname => 'CONTRACT_ID');
1817: OPEN c_vnd_pgm(l_ctr_id);
1818: FETCH c_vnd_pgm INTO l_khr_id;

Line 1831: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1827: FETCH c_email INTO l_contact_name,l_email;
1828: CLOSE c_email;
1829: END IF;
1830:
1831: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1832: itemkey => itemkey,
1833: aname => 'TRX_ID');
1834:
1835: --set the value for the vendor email attribute,recipient type - VC for Vendor Contact

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

1832: itemkey => itemkey,
1833: aname => 'TRX_ID');
1834:
1835: --set the value for the vendor email attribute,recipient type - VC for Vendor Contact
1836: wf_engine.SetItemAttrText (itemtype=> itemtype,
1837: itemkey => itemkey,
1838: aname => 'VENDOR_EMAIL',
1839: avalue => l_email) ;
1840:

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

1838: aname => 'VENDOR_EMAIL',
1839: avalue => l_email) ;
1840:
1841: --set the EMAIL_ADDRESS attribute to that of Vendor for XML Publisher Report
1842: wf_engine.SetItemAttrText(itemtype => itemtype,
1843: itemkey => itemkey,
1844: aname => 'EMAIL_ADDRESS',
1845: avalue => l_email);
1846:

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

1844: aname => 'EMAIL_ADDRESS',
1845: avalue => l_email);
1846:
1847: --rkuttiya changed recipient type to VENDOR for XMLPProject
1848: wf_engine.SetItemAttrText (itemtype=> itemtype,
1849: itemkey => itemkey,
1850: aname => 'RECIPIENT_TYPE',
1851: avalue => 'VENDOR') ;
1852:

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

1849: itemkey => itemkey,
1850: aname => 'RECIPIENT_TYPE',
1851: avalue => 'VENDOR') ;
1852:
1853: wf_engine.SetItemAttrText (itemtype=> itemtype,
1854: itemkey => itemkey,
1855: aname => 'RECIPIENT_DESCRIPTION',
1856: avalue => l_contact_name);
1857:

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

1854: itemkey => itemkey,
1855: aname => 'RECIPIENT_DESCRIPTION',
1856: avalue => l_contact_name);
1857:
1858: wf_engine.SetItemAttrText (itemtype=> itemtype,
1859: itemkey => itemkey,
1860: aname => 'RECIPIENT_ID',
1861: avalue => l_object_id);
1862:

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

1878: );
1879:
1880: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1881: l_batch_id := lx_xmp_rec.batch_id;
1882: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1883: itemkey => itemkey,
1884: aname => 'BATCH_ID',
1885: avalue => l_batch_id );
1886: resultout := 'COMPLETE:YES';

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

1890: ( p_count => l_msg_count,
1891: p_data => l_msg_data);
1892: Get_Messages(l_msg_count,l_error);
1893:
1894: wf_engine.SetItemAttrText(itemtype => itemtype,
1895: itemkey => itemkey,
1896: aname => 'ERROR_MESSAGE',
1897: avalue => l_error);
1898: resultout := 'COMPLETE:N';

Line 1952: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype,

1948: l_party_id NUMBER;
1949: l_ctr NUMBER;
1950: BEGIN
1951: IF funcmode = 'RUN' THEN
1952: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1953: itemkey => itemkey,
1954: aname => 'PARTY_ID');
1955: OPEN c_cust_del(l_party_id);
1956: FETCH c_cust_del INTO l_ctr;

Line 2035: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2031:
2032: BEGIN
2033: IF (funcmode = 'RUN') THEN
2034: -- Get the value of the request id
2035: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2036: itemkey => itemkey,
2037: aname => 'TRX_ID');
2038: l_svf_code := wf_engine.GetItemAttrText( itemtype => itemtype,
2039: itemkey => itemkey,

Line 2038: l_svf_code := wf_engine.GetItemAttrText( itemtype => itemtype,

2034: -- Get the value of the request id
2035: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2036: itemkey => itemkey,
2037: aname => 'TRX_ID');
2038: l_svf_code := wf_engine.GetItemAttrText( itemtype => itemtype,
2039: itemkey => itemkey,
2040: aname => 'SERVICE_FEE_CODE');
2041:
2042: l_sty_name := 'SERVICE_FEE_TRANS_REQUEST';

Line 2045: l_khr_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2041:
2042: l_sty_name := 'SERVICE_FEE_TRANS_REQUEST';
2043:
2044:
2045: l_khr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2046: itemkey => itemkey,
2047: aname => 'CONTRACT_ID');
2048: OPEN c_svf_info(l_svf_code);
2049: FETCH c_svf_info into l_svf_name,l_svf_desc,l_svf_amount;

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

2066: ( p_count => lx_msg_count,
2067: p_data => lx_msg_data);
2068: Get_Messages(lx_msg_count,l_error);
2069:
2070: wf_engine.SetItemAttrText(itemtype => itemtype,
2071: itemkey => itemkey,
2072: aname => 'ERROR_MESSAGE',
2073: avalue => l_error);
2074: resultout := 'COMPLETE:N';

Line 2130: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2126: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2127: BEGIN
2128: IF (funcmode = 'RESPOND') THEN
2129: --get request id
2130: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2131: itemkey => itemkey,
2132: aname => 'TRX_ID');
2133:
2134:

Line 2135: --get notification id from wf_engine context

2131: itemkey => itemkey,
2132: aname => 'TRX_ID');
2133:
2134:
2135: --get notification id from wf_engine context
2136: l_nid := WF_ENGINE.CONTEXT_NID;
2137: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2138:
2139: IF l_ntf_result = 'CREDIT_REJECTED' THEN

Line 2136: l_nid := WF_ENGINE.CONTEXT_NID;

2132: aname => 'TRX_ID');
2133:
2134:
2135: --get notification id from wf_engine context
2136: l_nid := WF_ENGINE.CONTEXT_NID;
2137: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2138:
2139: IF l_ntf_result = 'CREDIT_REJECTED' THEN
2140: l_sts_code := 'REJECTED';

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

2168: ( p_count => l_msg_count,
2169: p_data => l_msg_data);
2170: Get_Messages(l_msg_count,l_error);
2171:
2172: wf_engine.SetItemAttrText(itemtype => itemtype,
2173: itemkey => itemkey,
2174: aname => 'ERROR_MESSAGE',
2175: avalue => l_error);
2176:

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

2200: );
2201:
2202: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2203: l_batch_id := lx_xmp_rec.batch_id;
2204: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2205: itemkey => itemkey,
2206: aname => 'BATCH_ID',
2207: avalue => l_batch_id );
2208:

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

2211: ( p_count => l_msg_count,
2212: p_data => l_msg_data);
2213: Get_Messages(l_msg_count,l_error);
2214:
2215: wf_engine.SetItemAttrText(itemtype => itemtype,
2216: itemkey => itemkey,
2217: aname => 'ERROR_MESSAGE',
2218: avalue => l_error);
2219: resultout := 'COMPLETE:N';

Line 2229: resultout := wf_engine.eng_null;

2225: --
2226: --Transfer Mode
2227: --
2228: IF funcmode = 'TRANSFER' THEN
2229: resultout := wf_engine.eng_null;
2230: return;
2231: END IF;
2232:
2233: --Run Mode

Line 2304: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2300: l_sts_code VARCHAR2(30);
2301: BEGIN
2302: IF (funcmode = 'RESPOND') THEN
2303: --get request id
2304: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2305: itemkey => itemkey,
2306: aname => 'TRX_ID');
2307:
2308:

Line 2309: --get notification id from wf_engine context

2305: itemkey => itemkey,
2306: aname => 'TRX_ID');
2307:
2308:
2309: --get notification id from wf_engine context
2310: l_nid := WF_ENGINE.CONTEXT_NID;
2311: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2312:
2313: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN

Line 2310: l_nid := WF_ENGINE.CONTEXT_NID;

2306: aname => 'TRX_ID');
2307:
2308:
2309: --get notification id from wf_engine context
2310: l_nid := WF_ENGINE.CONTEXT_NID;
2311: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2312:
2313: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN
2314: l_sts_code := 'REJECTED';

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

2341: ( p_count => l_msg_count,
2342: p_data => l_msg_data);
2343: Get_Messages(l_msg_count,l_error);
2344:
2345: wf_engine.SetItemAttrText(itemtype => itemtype,
2346: itemkey => itemkey,
2347: aname => 'ERROR_MESSAGE',
2348: avalue => l_error);
2349:

Line 2365: resultout := wf_engine.eng_null;

2361: --
2362: --Transfer Mode
2363: --
2364: IF funcmode = 'TRANSFER' THEN
2365: resultout := wf_engine.eng_null;
2366: return;
2367: END IF;
2368:
2369: --Run Mode

Line 2418: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2414: l_return_status VARCHAR2(10);
2415: l_days_overdue NUMBER;
2416: BEGIN
2417: if (funcmode = 'RUN') then
2418: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2419: itemkey => itemkey,
2420: aname => 'CONTRACT_ID');
2421:
2422: days_cust_balance_overdue(p_contract_id => l_contract_id

Line 2478: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2474: l_outstanding_balance NUMBER;
2475: l_return_status VARCHAR2(10);
2476: BEGIN
2477: if (funcmode = 'RUN') then
2478: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2479: itemkey => itemkey,
2480: aname => 'CONTRACT_ID');
2481:
2482: get_contract_balance(p_contract_id => l_contract_id

Line 2537: l_cust_account_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2533: l_outstanding_balance NUMBER;
2534: l_return_status VARCHAR2(10);
2535: BEGIN
2536: if (funcmode = 'RUN') then
2537: l_cust_account_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2538: itemkey => itemkey,
2539: aname => 'CUST_ACCOUNT_ID');
2540:
2541: get_customer_balance(p_cust_account_id => l_cust_account_id

Line 2597: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2593: l_return_status VARCHAR2(10);
2594: l_product_name VARCHAR2(150);
2595: BEGIN
2596: if (funcmode = 'RUN') then
2597: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2598: itemkey => itemkey,
2599: aname => 'CONTRACT_ID');
2600:
2601: get_product(p_contract_id => l_contract_id

Line 2657: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2653: l_return_status VARCHAR2(10);
2654: l_address_desc VARCHAR2(80);
2655: BEGIN
2656: if (funcmode = 'RUN') then
2657: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2658: itemkey => itemkey,
2659: aname => 'CONTRACT_ID');
2660:
2661: get_bill_to_address(p_contract_id => l_contract_id

Line 3079: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

3075: WHERE id=p_ctr_id;
3076: BEGIN
3077:
3078: if (funcmode = 'RUN') then
3079: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3080: itemkey => itemkey,
3081: aname => 'REQUEST_ID');
3082: OPEN c_req_record(l_request_id);
3083: FETCH c_req_record INTO l_req_rec;

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

3101: l_lease_renewal_role := fnd_profile.value('OKL_CTR_RENEWAL_REP');
3102: IF l_lease_renewal_role IS NULL THEN
3103: l_lease_renewal_role := 'SYSADMIN';
3104: END IF;
3105: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3106: itemkey => itemkey,
3107: aname => 'ROLE_TO_RENEW_LEASE',
3108: avalue => l_lease_renewal_role);
3109: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3105: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3106: itemkey => itemkey,
3107: aname => 'ROLE_TO_RENEW_LEASE',
3108: avalue => l_lease_renewal_role);
3109: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3110: itemkey => itemkey,
3111: aname => 'OLD_CHRID',
3112: avalue => l_old_contract_id);
3113: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3109: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3110: itemkey => itemkey,
3111: aname => 'OLD_CHRID',
3112: avalue => l_old_contract_id);
3113: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3114: itemkey => itemkey,
3115: aname => 'YIELD',
3116: avalue => l_yield);
3117: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3113: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3114: itemkey => itemkey,
3115: aname => 'YIELD',
3116: avalue => l_yield);
3117: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3118: itemkey => itemkey,
3119: aname => 'START_DATE',
3120: avalue => l_start_date);
3121: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3117: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3118: itemkey => itemkey,
3119: aname => 'START_DATE',
3120: avalue => l_start_date);
3121: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3122: itemkey => itemkey,
3123: aname => 'END_DATE',
3124: avalue => l_end_date);
3125: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3121: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3122: itemkey => itemkey,
3123: aname => 'END_DATE',
3124: avalue => l_end_date);
3125: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3126: itemkey => itemkey,
3127: aname => 'TERM',
3128: avalue => l_term);
3129: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3125: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3126: itemkey => itemkey,
3127: aname => 'TERM',
3128: avalue => l_term);
3129: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3130: itemkey => itemkey,
3131: aname => 'RENT',
3132: avalue => l_rent);
3133: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3129: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3130: itemkey => itemkey,
3131: aname => 'RENT',
3132: avalue => l_rent);
3133: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3134: itemkey => itemkey,
3135: aname => 'RESIDUAL_PTY',
3136: avalue => l_residula_percentage);
3137: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3133: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3134: itemkey => itemkey,
3135: aname => 'RESIDUAL_PTY',
3136: avalue => l_residula_percentage);
3137: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3138: itemkey => itemkey,
3139: aname => 'CHR_ID',
3140: avalue => l_new_contract_id);
3141: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3137: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3138: itemkey => itemkey,
3139: aname => 'CHR_ID',
3140: avalue => l_new_contract_id);
3141: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3142: itemkey => itemkey,
3143: aname => 'OLD_CONTRACT_NUMBER',
3144: avalue => l_parent_contract_num);
3145: resultout := 'COMPLETE:';

Line 3237: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,

3233: l_request_id NUMBER;
3234: l_nid NUMBER;
3235: BEGIN
3236:
3237: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
3238: itemkey => itemkey,
3239: aname => 'REQUEST_ID');
3240:
3241: IF (funcmode = 'RESPOND') THEN

Line 3242: --get notification id from wf_engine context

3238: itemkey => itemkey,
3239: aname => 'REQUEST_ID');
3240:
3241: IF (funcmode = 'RESPOND') THEN
3242: --get notification id from wf_engine context
3243: l_nid := WF_ENGINE.CONTEXT_NID;
3244: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3245:
3246: resultout := 'COMPLETE:'|| l_ntf_result;

Line 3243: l_nid := WF_ENGINE.CONTEXT_NID;

3239: aname => 'REQUEST_ID');
3240:
3241: IF (funcmode = 'RESPOND') THEN
3242: --get notification id from wf_engine context
3243: l_nid := WF_ENGINE.CONTEXT_NID;
3244: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3245:
3246: resultout := 'COMPLETE:'|| l_ntf_result;
3247:

Line 3286: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,

3282: l_request_id NUMBER;
3283: l_nid NUMBER;
3284: BEGIN
3285:
3286: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
3287: itemkey => itemkey,
3288: aname => 'REQUEST_ID');
3289:
3290: IF (funcmode = 'RESPOND') THEN

Line 3291: --get notification id from wf_engine context

3287: itemkey => itemkey,
3288: aname => 'REQUEST_ID');
3289:
3290: IF (funcmode = 'RESPOND') THEN
3291: --get notification id from wf_engine context
3292: l_nid := WF_ENGINE.CONTEXT_NID;
3293: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3294:
3295: resultout := 'COMPLETE:'|| l_ntf_result;

Line 3292: l_nid := WF_ENGINE.CONTEXT_NID;

3288: aname => 'REQUEST_ID');
3289:
3290: IF (funcmode = 'RESPOND') THEN
3291: --get notification id from wf_engine context
3292: l_nid := WF_ENGINE.CONTEXT_NID;
3293: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3294:
3295: resultout := 'COMPLETE:'|| l_ntf_result;
3296:

Line 3405: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

3401: WHERE id=p_ctr_id;
3402: BEGIN
3403:
3404: if (funcmode = 'RUN') then
3405: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3406: itemkey => itemkey,
3407: aname => 'REQUEST_ID');
3408: OPEN c_req_record(l_request_id);
3409: FETCH c_req_record INTO l_req_rec;

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

3438:
3439: l_new_prin_balance := (nvl(l_cur_prin_balance,0) - nvl(l_req_rec.payment_amount,0));
3440: */
3441:
3442: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3443: itemkey => itemkey,
3444: aname => 'ROLE_TO_EXECUTE_PPD',
3445: avalue => l_principal_paydown_role);
3446: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3442: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3443: itemkey => itemkey,
3444: aname => 'ROLE_TO_EXECUTE_PPD',
3445: avalue => l_principal_paydown_role);
3446: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3447: itemkey => itemkey,
3448: aname => 'KHR_ID',
3449: avalue => l_contract_id);
3450: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3446: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3447: itemkey => itemkey,
3448: aname => 'KHR_ID',
3449: avalue => l_contract_id);
3450: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3451: itemkey => itemkey,
3452: aname => 'PAYDOWN_AMOUNT',
3453: avalue => l_req_rec.payment_amount);
3454: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3450: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3451: itemkey => itemkey,
3452: aname => 'PAYDOWN_AMOUNT',
3453: avalue => l_req_rec.payment_amount);
3454: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3455: itemkey => itemkey,
3456: aname => 'REQUEST_NUMBER',
3457: avalue => l_req_rec.request_number);
3458: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3454: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3455: itemkey => itemkey,
3456: aname => 'REQUEST_NUMBER',
3457: avalue => l_req_rec.request_number);
3458: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3459: itemkey => itemkey,
3460: aname => 'CONTRACT_NUMBER',
3461: avalue => l_contract_num);
3462: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3458: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3459: itemkey => itemkey,
3460: aname => 'CONTRACT_NUMBER',
3461: avalue => l_contract_num);
3462: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3463: itemkey => itemkey,
3464: aname => 'NEW_PAYMENT_AMOUNT',
3465: avalue => l_req_rec.amount);
3466:

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

3464: aname => 'NEW_PAYMENT_AMOUNT',
3465: avalue => l_req_rec.amount);
3466:
3467: --Next Payment Date
3468: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3469: itemkey => itemkey,
3470: aname => 'NEXT_PAYMENT_DATE',
3471: avalue => l_req_rec.start_date);
3472: --Paydown Date

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

3469: itemkey => itemkey,
3470: aname => 'NEXT_PAYMENT_DATE',
3471: avalue => l_req_rec.start_date);
3472: --Paydown Date
3473: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3474: itemkey => itemkey,
3475: aname => 'PAYDOWN_DATE',
3476: avalue => l_req_rec.payment_date);
3477:

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

3474: itemkey => itemkey,
3475: aname => 'PAYDOWN_DATE',
3476: avalue => l_req_rec.payment_date);
3477:
3478: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3479: itemkey => itemkey,
3480: aname => 'CURRENT_PRIN_BALANCE',
3481: avalue => l_cur_prin_balance);
3482:

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

3479: itemkey => itemkey,
3480: aname => 'CURRENT_PRIN_BALANCE',
3481: avalue => l_cur_prin_balance);
3482:
3483: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3484: itemkey => itemkey,
3485: aname => 'NEW_PRIN_BALANCE',
3486: avalue => l_new_prin_balance);
3487:

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

3484: itemkey => itemkey,
3485: aname => 'NEW_PRIN_BALANCE',
3486: avalue => l_new_prin_balance);
3487:
3488: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3489: itemkey => itemkey,
3490: aname => 'CURRENCY_CODE',
3491: avalue => l_req_rec.currency_code);
3492:

Line 3538: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,

3534: l_request_id NUMBER;
3535: l_nid NUMBER;
3536: BEGIN
3537:
3538: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
3539: itemkey => itemkey,
3540: aname => 'REQUEST_ID');
3541:
3542: IF (funcmode = 'RESPOND') THEN

Line 3543: --get notification id from wf_engine context

3539: itemkey => itemkey,
3540: aname => 'REQUEST_ID');
3541:
3542: IF (funcmode = 'RESPOND') THEN
3543: --get notification id from wf_engine context
3544: l_nid := WF_ENGINE.CONTEXT_NID;
3545: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3546:
3547: resultout := 'COMPLETE:'|| l_ntf_result;

Line 3544: l_nid := WF_ENGINE.CONTEXT_NID;

3540: aname => 'REQUEST_ID');
3541:
3542: IF (funcmode = 'RESPOND') THEN
3543: --get notification id from wf_engine context
3544: l_nid := WF_ENGINE.CONTEXT_NID;
3545: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3546:
3547: resultout := 'COMPLETE:'|| l_ntf_result;
3548:

Line 3594: l_khr_id := wf_engine.GetItemAttrText( itemtype => itemtype,

3590: BEGIN
3591:
3592: if (funcmode = 'RUN') then
3593:
3594: l_khr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3595: itemkey => itemkey,
3596: aname => 'KHR_ID');
3597:
3598: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 3598: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

3594: l_khr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3595: itemkey => itemkey,
3596: aname => 'KHR_ID');
3597:
3598: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3599: itemkey => itemkey,
3600: aname => 'REQUEST_ID');
3601:
3602: --call the API here.

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

3615: p_data => l_msg_data
3616: );
3617: Get_Messages(l_msg_count,l_error);
3618:
3619: wf_engine.SetItemAttrText(itemtype => itemtype,
3620: itemkey => itemkey,
3621: aname => 'ERROR_MESSAGE',
3622: avalue => l_error);
3623:

Line 3697: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

3693: BEGIN
3694:
3695: if (funcmode = 'RUN') then
3696:
3697: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3698: itemkey => itemkey,
3699: aname => 'REQUEST_ID');
3700: l_trqv_rec.id := l_request_id;
3701: l_trqv_rec.request_status_code := 'PROCESSED';

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

3722: p_data => l_msg_data
3723: );
3724: Get_Messages(l_msg_count,l_error);
3725:
3726: wf_engine.SetItemAttrText(itemtype => itemtype,
3727: itemkey => itemkey,
3728: aname => 'ERROR_MESSAGE',
3729: avalue => l_error);
3730:

Line 3846: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

3842: WHERE id=p_ctr_id;
3843: BEGIN
3844:
3845: if (funcmode = 'RUN') then
3846: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3847: itemkey => itemkey,
3848: aname => 'REQUEST_ID');
3849: OPEN c_req_record(l_request_id);
3850: FETCH c_req_record INTO l_req_rec;

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

3860: l_approve_credit_memo_role := fnd_profile.value('OKL_CREDIT_MEMO_REP');
3861: IF l_approve_credit_memo_role IS NULL THEN
3862: l_approve_credit_memo_role := 'SYSADMIN';
3863: END IF;
3864: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3865: itemkey => itemkey,
3866: aname => 'NOTIFICATION_ROLE',
3867: avalue => l_approve_credit_memo_role);
3868: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3864: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3865: itemkey => itemkey,
3866: aname => 'NOTIFICATION_ROLE',
3867: avalue => l_approve_credit_memo_role);
3868: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3869: itemkey => itemkey,
3870: aname => 'CONTRACT_ID',
3871: avalue => l_contract_id);
3872: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3868: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3869: itemkey => itemkey,
3870: aname => 'CONTRACT_ID',
3871: avalue => l_contract_id);
3872: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3873: itemkey => itemkey,
3874: aname => 'CREDIT_AMOUNT',
3875: avalue => l_req_rec.amount);
3876: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3872: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3873: itemkey => itemkey,
3874: aname => 'CREDIT_AMOUNT',
3875: avalue => l_req_rec.amount);
3876: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3877: itemkey => itemkey,
3878: aname => 'REQUEST_NUMBER',
3879: avalue => l_req_rec.request_number);
3880: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3876: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3877: itemkey => itemkey,
3878: aname => 'REQUEST_NUMBER',
3879: avalue => l_req_rec.request_number);
3880: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3881: itemkey => itemkey,
3882: aname => 'CONTRACT_NUMBER',
3883: avalue => l_contract_num);
3884: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3880: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3881: itemkey => itemkey,
3882: aname => 'CONTRACT_NUMBER',
3883: avalue => l_contract_num);
3884: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3885: itemkey => itemkey,
3886: aname => 'LSM_ID',
3887: avalue => l_req_rec.lsm_id);
3888: resultout := 'COMPLETE:Y';

Line 3950: l_lsm_id := wf_engine.GetItemAttrText( itemtype => itemtype,

3946:
3947: BEGIN
3948:
3949: if (funcmode = 'RUN') then
3950: l_lsm_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3951: itemkey => itemkey,
3952: aname => 'LSM_ID');
3953:
3954: l_credit_amount := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 3954: l_credit_amount := wf_engine.GetItemAttrText( itemtype => itemtype,

3950: l_lsm_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3951: itemkey => itemkey,
3952: aname => 'LSM_ID');
3953:
3954: l_credit_amount := wf_engine.GetItemAttrText( itemtype => itemtype,
3955: itemkey => itemkey,
3956: aname => 'CREDIT_AMOUNT');
3957: --We need to send -ve amount to the API so negating the amount.
3958: l_credit_amount := -(l_credit_amount);

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

3985: p_data => l_msg_data
3986: );
3987: Get_Messages(l_msg_count,l_error);
3988:
3989: wf_engine.SetItemAttrText(itemtype => itemtype,
3990: itemkey => itemkey,
3991: aname => 'ERROR_MESSAGE',
3992: avalue => l_error);
3993:

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

3994: resultout := 'COMPLETE:N';
3995:
3996: ELSE
3997:
3998: wf_engine.SetItemAttrText (itemtype=> itemtype,
3999: itemkey => itemkey,
4000: aname => 'TAI_ID',
4001: avalue => lx_tai_id);
4002:

Line 4064: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

4060: BEGIN
4061:
4062: if (funcmode = 'RUN') then
4063:
4064: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4065: itemkey => itemkey,
4066: aname => 'REQUEST_ID');
4067: l_trqv_rec.id := l_request_id;
4068: l_trqv_rec.request_status_code := 'APPROVED';

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

4089: p_data => l_msg_data
4090: );
4091: Get_Messages(l_msg_count,l_error);
4092:
4093: wf_engine.SetItemAttrText(itemtype => itemtype,
4094: itemkey => itemkey,
4095: aname => 'ERROR_MESSAGE',
4096: avalue => l_error);
4097:

Line 4164: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

4160: BEGIN
4161:
4162: if (funcmode = 'RUN') then
4163:
4164: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4165: itemkey => itemkey,
4166: aname => 'REQUEST_ID');
4167: l_trqv_rec.id := l_request_id;
4168: l_trqv_rec.request_status_code := 'REJECTED';

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

4189: p_data => l_msg_data
4190: );
4191: Get_Messages(l_msg_count,l_error);
4192:
4193: wf_engine.SetItemAttrText(itemtype => itemtype,
4194: itemkey => itemkey,
4195: aname => 'ERROR_MESSAGE',
4196: avalue => l_error);
4197:

Line 4266: l_tai_id := wf_engine.GetItemAttrText( itemtype => itemtype,

4262:
4263: BEGIN
4264:
4265: if (funcmode = 'RUN') then
4266: l_tai_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4267: itemkey => itemkey,
4268: aname => 'TAI_ID');
4269:
4270: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 4270: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

4266: l_tai_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4267: itemkey => itemkey,
4268: aname => 'TAI_ID');
4269:
4270: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4271: itemkey => itemkey,
4272: aname => 'REQUEST_ID');
4273: l_trqv_rec.id := l_request_id;
4274: l_trqv_rec.object1_id1 := l_tai_id;

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

4297: p_data => l_msg_data
4298: );
4299: Get_Messages(l_msg_count,l_error);
4300:
4301: wf_engine.SetItemAttrText(itemtype => itemtype,
4302: itemkey => itemkey,
4303: aname => 'ERROR_MESSAGE',
4304: avalue => l_error);
4305:

Line 4371: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

4367: BEGIN
4368:
4369: if (funcmode = 'RUN') then
4370:
4371: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4372: itemkey => itemkey,
4373: aname => 'REQUEST_ID');
4374: l_trqv_rec.id := l_request_id;
4375: l_trqv_rec.request_status_code := 'INCOMPLETE'; --Should this be error instead

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

4396: p_data => l_msg_data
4397: );
4398: Get_Messages(l_msg_count,l_error);
4399:
4400: wf_engine.SetItemAttrText(itemtype => itemtype,
4401: itemkey => itemkey,
4402: aname => 'ERROR_MESSAGE',
4403: avalue => l_error);
4404: