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 352: wf_engine.SetItemAttrText ( itemtype=> itemtype,

348: itemkey => itemkey,
349: aname => 'OLD_ASSET_NUMBER',
350: avalue => x_new_talv_tbl(1).asset_number);
351: */
352: wf_engine.SetItemAttrText ( itemtype=> itemtype,
353: itemkey => itemkey,
354: aname => 'OLD_ASSET_DESC',
355: avalue => x_new_talv_tbl(1).DESCRIPTION);
356:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

527: WHERE ID=p_trx_id;
528:
529: BEGIN
530: if (funcmode = 'RUN') then
531: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
532: itemkey => itemkey,
533: aname => 'TRX_ID');
534:
535:

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

679: END IF;
680:
681:
682: -- Get the value of the request id
683: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'TRX_ID');
686:
687: OPEN c_req_record(l_trx_id);

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

724: --rkuttiya changed recipient type to LESSEE for XMLP
725: l_recipient_type := 'LESSEE';
726:
727: --rkuttiya added for Bug:4257336
728: wf_engine.SetItemAttrText(itemtype => itemtype,
729: itemkey => itemkey,
730: aname => 'CONTRACT_ID',
731: avalue => l_req_rec.khr_id);
732: --end changes for Bug:4257336

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

730: aname => 'CONTRACT_ID',
731: avalue => l_req_rec.khr_id);
732: --end changes for Bug:4257336
733:
734: wf_engine.SetItemAttrText(itemtype => itemtype,
735: itemkey => itemkey,
736: aname => 'CREATED_BY',
737: avalue => l_requestor_id);
738: wf_engine.SetItemAttrText(itemtype => itemtype,

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

734: wf_engine.SetItemAttrText(itemtype => itemtype,
735: itemkey => itemkey,
736: aname => 'CREATED_BY',
737: avalue => l_requestor_id);
738: wf_engine.SetItemAttrText(itemtype => itemtype,
739: itemkey => itemkey,
740: aname => 'REQUESTER',
741: avalue => l_requestor);
742: wf_engine.SetItemAttrText(itemtype => itemtype,

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

738: wf_engine.SetItemAttrText(itemtype => itemtype,
739: itemkey => itemkey,
740: aname => 'REQUESTER',
741: avalue => l_requestor);
742: wf_engine.SetItemAttrText(itemtype => itemtype,
743: itemkey => itemkey,
744: aname => 'NOTIFY_AGENT',
745: avalue => l_requestor);
746: wf_engine.SetItemAttrText(itemtype => itemtype,

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

742: wf_engine.SetItemAttrText(itemtype => itemtype,
743: itemkey => itemkey,
744: aname => 'NOTIFY_AGENT',
745: avalue => l_requestor);
746: wf_engine.SetItemAttrText(itemtype => itemtype,
747: itemkey => itemkey,
748: aname => 'RECIPIENT_TYPE',
749: avalue => l_recipient_type);
750: wf_engine.SetItemAttrText(itemtype => itemtype,

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

746: wf_engine.SetItemAttrText(itemtype => itemtype,
747: itemkey => itemkey,
748: aname => 'RECIPIENT_TYPE',
749: avalue => l_recipient_type);
750: wf_engine.SetItemAttrText(itemtype => itemtype,
751: itemkey => itemkey,
752: aname => 'PROCESS_CODE',
753: avalue => 'CSTSFRASU');
754: wf_engine.SetItemAttrText(itemtype => itemtype,

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

750: wf_engine.SetItemAttrText(itemtype => itemtype,
751: itemkey => itemkey,
752: aname => 'PROCESS_CODE',
753: avalue => 'CSTSFRASU');
754: wf_engine.SetItemAttrText(itemtype => itemtype,
755: itemkey => itemkey,
756: aname => 'SERVICE_FEE_CODE',
757: avalue => 'CSTSFRFEE');
758: wf_engine.SetItemAttrText(itemtype => itemtype,

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

754: wf_engine.SetItemAttrText(itemtype => itemtype,
755: itemkey => itemkey,
756: aname => 'SERVICE_FEE_CODE',
757: avalue => 'CSTSFRFEE');
758: wf_engine.SetItemAttrText(itemtype => itemtype,
759: itemkey => itemkey,
760: aname => 'FROM_ADDRESS',
761: avalue => l_from_email);
762:

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

759: itemkey => itemkey,
760: aname => 'FROM_ADDRESS',
761: avalue => l_from_email);
762:
763: wf_engine.SetItemAttrText (itemtype=> itemtype,
764: itemkey => itemkey,
765: aname => 'CUST_ROLE',
766: avalue => l_cust_role) ;
767:

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

764: itemkey => itemkey,
765: aname => 'CUST_ROLE',
766: avalue => l_cust_role) ;
767:
768: wf_engine.SetItemAttrText (itemtype=> itemtype,
769: itemkey => itemkey,
770: aname => 'ROLE_CREDIT',
771: avalue => l_credit_role) ;
772: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

768: wf_engine.SetItemAttrText (itemtype=> itemtype,
769: itemkey => itemkey,
770: aname => 'ROLE_CREDIT',
771: avalue => l_credit_role) ;
772: wf_engine.SetItemAttrText (itemtype=> itemtype,
773: itemkey => itemkey,
774: aname => 'ROLE_ADMIN',
775: avalue => l_ctr_admin_role) ;
776: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

772: wf_engine.SetItemAttrText (itemtype=> itemtype,
773: itemkey => itemkey,
774: aname => 'ROLE_ADMIN',
775: avalue => l_ctr_admin_role) ;
776: wf_engine.SetItemAttrText (itemtype=> itemtype,
777: itemkey => itemkey,
778: aname => 'ROLE_VND',
779: avalue => l_vendor_role) ;
780: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

776: wf_engine.SetItemAttrText (itemtype=> itemtype,
777: itemkey => itemkey,
778: aname => 'ROLE_VND',
779: avalue => l_vendor_role) ;
780: wf_engine.SetItemAttrText (itemtype=> itemtype,
781: itemkey => itemkey,
782: aname => 'ROLE_COLLECTION',
783: avalue => l_collections_role) ;
784:

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

783: avalue => l_collections_role) ;
784:
785:
786:
787: wf_engine.SetItemAttrText (itemtype=> itemtype,
788: itemkey => itemkey,
789: aname => 'CONTRACT_NUMBER',
790: avalue => l_ctr_no) ;
791: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

787: wf_engine.SetItemAttrText (itemtype=> itemtype,
788: itemkey => itemkey,
789: aname => 'CONTRACT_NUMBER',
790: avalue => l_ctr_no) ;
791: wf_engine.SetItemAttrText (itemtype=> itemtype,
792: itemkey => itemkey,
793: aname => 'TRANSACTION_ID',
794: avalue => l_trx_id) ;
795:

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

793: aname => 'TRANSACTION_ID',
794: avalue => l_trx_id) ;
795:
796: --rkuttiya added for bug: 4056337
797: wf_engine.SetItemAttrText (itemtype=> itemtype,
798: itemkey => itemkey,
799: aname => 'TRANSFER_DATE',
800: avalue => l_transfer_date) ;
801:

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

799: aname => 'TRANSFER_DATE',
800: avalue => l_transfer_date) ;
801:
802:
803: wf_engine.SetItemAttrText (itemtype=> itemtype,
804: itemkey => itemkey,
805: aname => 'OLD_LESSEE',
806: avalue => l_party_name) ;
807:

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

804: itemkey => itemkey,
805: aname => 'OLD_LESSEE',
806: avalue => l_party_name) ;
807:
808: wf_engine.SetItemAttrText (itemtype=> itemtype,
809: itemkey => itemkey,
810: aname => 'REQUEST_NUMBER',
811: avalue => l_req_no) ;
812:

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

812:
813:
814: IF l_req_rec.complete_transfer_yn = 'N' THEN
815: l_type := 'Partial';
816: wf_engine.SetItemAttrText (itemtype=> itemtype,
817: itemkey => itemkey,
818: aname => 'TRANSFER_TYPE',
819: avalue => 'Partial') ;
820: ELSIF l_req_rec.complete_transfer_yn = 'Y' THEN

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

818: aname => 'TRANSFER_TYPE',
819: avalue => 'Partial') ;
820: ELSIF l_req_rec.complete_transfer_yn = 'Y' THEN
821: l_type := 'Complete';
822: wf_engine.SetItemAttrText (itemtype=> itemtype,
823: itemkey => itemkey,
824: aname => 'TRANSFER_TYPE',
825: avalue => 'Complete') ;
826: END IF;

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

839: ( p_count => l_msg_count,
840: p_data => l_msg_data);
841: Get_Messages(l_msg_count,l_error);
842:
843: wf_engine.SetItemAttrText(itemtype => itemtype,
844: itemkey => itemkey,
845: aname => 'ERROR_MESSAGE',
846: avalue => l_error);
847:

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

846: avalue => l_error);
847:
848: resultout := 'COMPLETE:N';
849: ELSE
850: wf_engine.SetItemAttrText (itemtype=> itemtype,
851: itemkey => itemkey,
852: aname => 'NEW_CONTRACT_NUMBER',
853: avalue => lx_new_lessee_tbl(1).new_contract_number) ;
854:

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

851: itemkey => itemkey,
852: aname => 'NEW_CONTRACT_NUMBER',
853: avalue => lx_new_lessee_tbl(1).new_contract_number) ;
854:
855: wf_engine.SetItemAttrText (itemtype=> itemtype,
856: itemkey => itemkey,
857: aname => 'NEW_LESSEE',
858: avalue => lx_new_lessee_tbl(1).new_lessee);
859: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

855: wf_engine.SetItemAttrText (itemtype=> itemtype,
856: itemkey => itemkey,
857: aname => 'NEW_LESSEE',
858: avalue => lx_new_lessee_tbl(1).new_lessee);
859: wf_engine.SetItemAttrText (itemtype=> itemtype,
860: itemkey => itemkey,
861: aname => 'RECIPIENT_DESCRIPTION',
862: avalue => lx_new_lessee_tbl(1).contact_name);
863: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

859: wf_engine.SetItemAttrText (itemtype=> itemtype,
860: itemkey => itemkey,
861: aname => 'RECIPIENT_DESCRIPTION',
862: avalue => lx_new_lessee_tbl(1).contact_name);
863: wf_engine.SetItemAttrText (itemtype=> itemtype,
864: itemkey => itemkey,
865: aname => 'EMAIL_ADDRESS',
866: avalue => lx_new_lessee_tbl(1).contact_email);
867: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

863: wf_engine.SetItemAttrText (itemtype=> itemtype,
864: itemkey => itemkey,
865: aname => 'EMAIL_ADDRESS',
866: avalue => lx_new_lessee_tbl(1).contact_email);
867: wf_engine.SetItemAttrText (itemtype=> itemtype,
868: itemkey => itemkey,
869: aname => 'RECIPIENT_ID',
870: avalue => lx_new_lessee_tbl(1).contact_id);
871: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

867: wf_engine.SetItemAttrText (itemtype=> itemtype,
868: itemkey => itemkey,
869: aname => 'RECIPIENT_ID',
870: avalue => lx_new_lessee_tbl(1).contact_id);
871: wf_engine.SetItemAttrText (itemtype=> itemtype,
872: itemkey => itemkey,
873: aname => 'BILL_TO',
874: avalue => lx_new_lessee_tbl(1).bill_to_address);
875: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

871: wf_engine.SetItemAttrText (itemtype=> itemtype,
872: itemkey => itemkey,
873: aname => 'BILL_TO',
874: avalue => lx_new_lessee_tbl(1).bill_to_address);
875: wf_engine.SetItemAttrText (itemtype=> itemtype,
876: itemkey => itemkey,
877: aname => 'CUST_ACCT_NUMBER',
878: avalue => lx_new_lessee_tbl(1).cust_acct_number);
879: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

875: wf_engine.SetItemAttrText (itemtype=> itemtype,
876: itemkey => itemkey,
877: aname => 'CUST_ACCT_NUMBER',
878: avalue => lx_new_lessee_tbl(1).cust_acct_number);
879: wf_engine.SetItemAttrText (itemtype=> itemtype,
880: itemkey => itemkey,
881: aname => 'BANK_ACCOUNT',
882: avalue => lx_new_lessee_tbl(1).bank_account);
883: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

879: wf_engine.SetItemAttrText (itemtype=> itemtype,
880: itemkey => itemkey,
881: aname => 'BANK_ACCOUNT',
882: avalue => lx_new_lessee_tbl(1).bank_account);
883: wf_engine.SetItemAttrText (itemtype=> itemtype,
884: itemkey => itemkey,
885: aname => 'INVOICE_FORMAT',
886: avalue => lx_new_lessee_tbl(1).invoice_format);
887: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

883: wf_engine.SetItemAttrText (itemtype=> itemtype,
884: itemkey => itemkey,
885: aname => 'INVOICE_FORMAT',
886: avalue => lx_new_lessee_tbl(1).invoice_format);
887: wf_engine.SetItemAttrText (itemtype=> itemtype,
888: itemkey => itemkey,
889: aname => 'PAYMENT_METHOD',
890: avalue => lx_new_lessee_tbl(1).payment_method);
891: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

887: wf_engine.SetItemAttrText (itemtype=> itemtype,
888: itemkey => itemkey,
889: aname => 'PAYMENT_METHOD',
890: avalue => lx_new_lessee_tbl(1).payment_method);
891: wf_engine.SetItemAttrText (itemtype=> itemtype,
892: itemkey => itemkey,
893: aname => 'MLA_NO',
894: avalue => lx_new_lessee_tbl(1).master_lease);
895: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

891: wf_engine.SetItemAttrText (itemtype=> itemtype,
892: itemkey => itemkey,
893: aname => 'MLA_NO',
894: avalue => lx_new_lessee_tbl(1).master_lease);
895: wf_engine.SetItemAttrText (itemtype=> itemtype,
896: itemkey => itemkey,
897: aname => 'CREDIT_LINE_NUMBER',
898: avalue => lx_new_lessee_tbl(1).credit_line_no);
899:

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

911: ( p_count => l_msg_count,
912: p_data => l_msg_data);
913: Get_Messages(l_msg_count,l_error);
914:
915: wf_engine.SetItemAttrText(itemtype => itemtype,
916: itemkey => itemkey,
917: aname => 'ERROR_MESSAGE',
918: avalue => l_error);
919:

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

918: avalue => l_error);
919:
920: resultout := 'COMPLETE:N';
921: ELSE
922: wf_engine.SetItemAttrText (itemtype=> itemtype,
923: itemkey => itemkey,
924: aname => 'INSURER',
925: avalue => lx_insurance_tbl(1).insurer) ;
926:

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

923: itemkey => itemkey,
924: aname => 'INSURER',
925: avalue => lx_insurance_tbl(1).insurer) ;
926:
927: wf_engine.SetItemAttrText (itemtype=> itemtype,
928: itemkey => itemkey,
929: aname => 'INSURANCE_AGENT',
930: avalue => lx_insurance_tbl(1).insurance_agent);
931: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

927: wf_engine.SetItemAttrText (itemtype=> itemtype,
928: itemkey => itemkey,
929: aname => 'INSURANCE_AGENT',
930: avalue => lx_insurance_tbl(1).insurance_agent);
931: wf_engine.SetItemAttrText (itemtype=> itemtype,
932: itemkey => itemkey,
933: aname => 'POLICY_NUMBER',
934: avalue => lx_insurance_tbl(1).policy_number);
935: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

931: wf_engine.SetItemAttrText (itemtype=> itemtype,
932: itemkey => itemkey,
933: aname => 'POLICY_NUMBER',
934: avalue => lx_insurance_tbl(1).policy_number);
935: wf_engine.SetItemAttrText (itemtype=> itemtype,
936: itemkey => itemkey,
937: aname => 'COVERED_AMOUNT',
938: avalue => lx_insurance_tbl(1).covered_amount);
939: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

935: wf_engine.SetItemAttrText (itemtype=> itemtype,
936: itemkey => itemkey,
937: aname => 'COVERED_AMOUNT',
938: avalue => lx_insurance_tbl(1).covered_amount);
939: wf_engine.SetItemAttrText (itemtype=> itemtype,
940: itemkey => itemkey,
941: aname => 'DEDUCTIBLE_AMOUNT',
942: avalue => lx_insurance_tbl(1).deductible_amount);
943: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

939: wf_engine.SetItemAttrText (itemtype=> itemtype,
940: itemkey => itemkey,
941: aname => 'DEDUCTIBLE_AMOUNT',
942: avalue => lx_insurance_tbl(1).deductible_amount);
943: wf_engine.SetItemAttrText (itemtype=> itemtype,
944: itemkey => itemkey,
945: aname => 'EFFECTIVE_FROM',
946: avalue => lx_insurance_tbl(1).effective_from);
947: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

943: wf_engine.SetItemAttrText (itemtype=> itemtype,
944: itemkey => itemkey,
945: aname => 'EFFECTIVE_FROM',
946: avalue => lx_insurance_tbl(1).effective_from);
947: wf_engine.SetItemAttrText (itemtype=> itemtype,
948: itemkey => itemkey,
949: aname => 'EFFECTIVE_TO',
950: avalue => lx_insurance_tbl(1).effective_to);
951: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

947: wf_engine.SetItemAttrText (itemtype=> itemtype,
948: itemkey => itemkey,
949: aname => 'EFFECTIVE_TO',
950: avalue => lx_insurance_tbl(1).effective_to);
951: wf_engine.SetItemAttrText (itemtype=> itemtype,
952: itemkey => itemkey,
953: aname => 'PROOF_PROVIDED',
954: avalue => lx_insurance_tbl(1).proof_provided);
955: wf_engine.SetItemAttrText (itemtype=> itemtype,

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

951: wf_engine.SetItemAttrText (itemtype=> itemtype,
952: itemkey => itemkey,
953: aname => 'PROOF_PROVIDED',
954: avalue => lx_insurance_tbl(1).proof_provided);
955: wf_engine.SetItemAttrText (itemtype=> itemtype,
956: itemkey => itemkey,
957: aname => 'PROOF_REQUIRED',
958: avalue => lx_insurance_tbl(1).proof_required);
959: IF lx_insurance_tbl(1).lessor_insured_yn = 'Y' THEN

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

956: itemkey => itemkey,
957: aname => 'PROOF_REQUIRED',
958: avalue => lx_insurance_tbl(1).proof_required);
959: IF lx_insurance_tbl(1).lessor_insured_yn = 'Y' THEN
960: wf_engine.SetItemAttrText (itemtype=> itemtype,
961: itemkey => itemkey,
962: aname => 'LESSOR_INSURED_YN',
963: avalue => 'Yes');
964: ELSIF lx_insurance_tbl(1).lessor_insured_yn = 'Y' THEN

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

961: itemkey => itemkey,
962: aname => 'LESSOR_INSURED_YN',
963: avalue => 'Yes');
964: ELSIF lx_insurance_tbl(1).lessor_insured_yn = 'Y' THEN
965: wf_engine.SetItemAttrText (itemtype=> itemtype,
966: itemkey => itemkey,
967: aname => 'LESSOR_INSURED_YN',
968: avalue => 'No');
969: END IF;

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

968: avalue => 'No');
969: END IF;
970:
971: IF lx_insurance_tbl(1).lessor_payee_yn = 'Y' THEN
972: wf_engine.SetItemAttrText (itemtype=> itemtype,
973: itemkey => itemkey,
974: aname => 'LESSOR_PAYEE_YN',
975: avalue => 'Yes');
976: ELSIF lx_insurance_tbl(1).lessor_payee_yn = 'Y' THEN

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

973: itemkey => itemkey,
974: aname => 'LESSOR_PAYEE_YN',
975: avalue => 'Yes');
976: ELSIF lx_insurance_tbl(1).lessor_payee_yn = 'Y' THEN
977: wf_engine.SetItemAttrText (itemtype=> itemtype,
978: itemkey => itemkey,
979: aname => 'LESSOR_PAYEE_YN',
980: avalue => 'No');
981: END IF;

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

993: 'Type of Transfer :' || l_type ||'

'||
994: '

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

';
995:
996:
997: wf_engine.SetItemAttrText ( itemtype=> itemtype,
998: itemkey => itemkey,
999: aname => 'TRX_TYPE_ID',
1000: avalue => 'OKLCSTRQ');
1001:

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

998: itemkey => itemkey,
999: aname => 'TRX_TYPE_ID',
1000: avalue => 'OKLCSTRQ');
1001:
1002: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1003: itemkey => itemkey,
1004: aname => 'MESSAGE_DESCRIPTION',
1005: avalue => l_message);
1006:

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

1079:
1080: BEGIN
1081: IF (funcmode = 'RUN') THEN
1082: -- Get the value of the request id
1083: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1084: itemkey => itemkey,
1085: aname => 'TRX_ID');
1086: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1087: itemkey => itemkey,

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

1082: -- Get the value of the request id
1083: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1084: itemkey => itemkey,
1085: aname => 'TRX_ID');
1086: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1087: itemkey => itemkey,
1088: aname => 'PROCESS_CODE');
1089:
1090: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1086: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1087: itemkey => itemkey,
1088: aname => 'PROCESS_CODE');
1089:
1090: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,
1091: itemkey => itemkey,
1092: aname => 'CONTACT_EMAIL');
1093:
1094: l_bind_var(1) := 'p_request_id';

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

1126: ( p_count => lx_msg_count,
1127: p_data => lx_msg_data);
1128: Get_Messages(lx_msg_count,l_error);
1129:
1130: wf_engine.SetItemAttrText(itemtype => itemtype,
1131: itemkey => itemkey,
1132: aname => 'ERROR_MESSAGE',
1133: avalue => l_error);
1134:

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

1201:
1202: BEGIN
1203: IF (funcmode = 'RUN') THEN
1204: -- Get the value of the request id
1205: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1206: itemkey => itemkey,
1207: aname => 'TRX_ID');
1208: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1209: itemkey => itemkey,

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

1204: -- Get the value of the request id
1205: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1206: itemkey => itemkey,
1207: aname => 'TRX_ID');
1208: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1209: itemkey => itemkey,
1210: aname => 'PROCESS_CODE');
1211:
1212: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1208: l_ptm_code := wf_engine.GetItemAttrText( itemtype => itemtype,
1209: itemkey => itemkey,
1210: aname => 'PROCESS_CODE');
1211:
1212: l_email := wf_engine.GetItemAttrText( itemtype => itemtype,
1213: itemkey => itemkey,
1214: aname => 'VENDOR_EMAIL');
1215:
1216: l_bind_var(1) := 'p_request_id';

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

1248: ( p_count => lx_msg_count,
1249: p_data => lx_msg_data);
1250: Get_Messages(lx_msg_count,l_error);
1251:
1252: wf_engine.SetItemAttrText(itemtype => itemtype,
1253: itemkey => itemkey,
1254: aname => 'ERROR_MESSAGE',
1255: avalue => l_error);
1256:

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

1316: lx_tclv_tbl tclv_tbl_type;
1317:
1318: BEGIN
1319: IF (funcmode = 'RUN') THEN
1320: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1321: itemkey => itemkey,
1322: aname => 'TRX_ID');
1323: l_status := 'APPROVED';
1324:

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

1340: ( p_count => l_msg_count,
1341: p_data => l_msg_data);
1342: Get_Messages(l_msg_count,l_error);
1343:
1344: wf_engine.SetItemAttrText(itemtype => itemtype,
1345: itemkey => itemkey,
1346: aname => 'ERROR_MESSAGE',
1347: avalue => l_error);
1348: resultout := 'COMPLETE:N';

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

1405: l_error VARCHAR2(2000);
1406:
1407: BEGIN
1408: IF (funcmode = 'RUN') THEN
1409: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1410: itemkey => itemkey,
1411: aname => 'TRX_ID');
1412:
1413: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1409: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1410: itemkey => itemkey,
1411: aname => 'TRX_ID');
1412:
1413: l_approved_yn := wf_engine.GetItemAttrText( itemtype => itemtype,
1414: itemkey => itemkey,
1415: aname => 'APPROVED_YN');
1416: IF l_approved_yn = 'Y' THEN
1417: l_status := 'SUBMITTED';

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

1439: ( p_count => l_msg_count,
1440: p_data => l_msg_data);
1441: Get_Messages(l_msg_count,l_error);
1442:
1443: wf_engine.SetItemAttrText(itemtype => itemtype,
1444: itemkey => itemkey,
1445: aname => 'ERROR_MESSAGE',
1446: avalue => l_error);
1447:

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

1509:
1510: BEGIN
1511: IF (funcmode = 'RESPOND') THEN
1512: --get request id
1513: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1514: itemkey => itemkey,
1515: aname => 'TRX_ID');
1516:
1517:

Line 1518: --get notification id from wf_engine context

1514: itemkey => itemkey,
1515: aname => 'TRX_ID');
1516:
1517:
1518: --get notification id from wf_engine context
1519: l_nid := WF_ENGINE.CONTEXT_NID;
1520: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1521:
1522: IF l_ntf_result = 'NO' THEN

Line 1519: l_nid := WF_ENGINE.CONTEXT_NID;

1515: aname => 'TRX_ID');
1516:
1517:
1518: --get notification id from wf_engine context
1519: l_nid := WF_ENGINE.CONTEXT_NID;
1520: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1521:
1522: IF l_ntf_result = 'NO' THEN
1523: l_sts_code := 'REJECTED';

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

1551: ( p_count => l_msg_count,
1552: p_data => l_msg_data);
1553: Get_Messages(l_msg_count,l_error);
1554:
1555: wf_engine.SetItemAttrText(itemtype => itemtype,
1556: itemkey => itemkey,
1557: aname => 'ERROR_MESSAGE',
1558: avalue => l_error);
1559:

Line 1575: resultout := wf_engine.eng_null;

1571: --
1572: --Transfer Mode
1573: --
1574: IF funcmode = 'TRANSFER' THEN
1575: resultout := wf_engine.eng_null;
1576: return;
1577: END IF;
1578:
1579: --Run Mode

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

1645:
1646: BEGIN
1647: IF (funcmode = 'RESPOND') THEN
1648: --get request id
1649: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1650: itemkey => itemkey,
1651: aname => 'TRX_ID');
1652:
1653:

Line 1654: --get notification id from wf_engine context

1650: itemkey => itemkey,
1651: aname => 'TRX_ID');
1652:
1653:
1654: --get notification id from wf_engine context
1655: l_nid := WF_ENGINE.CONTEXT_NID;
1656: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1657:
1658: --rkuttiya changed for bug#5149488

Line 1655: l_nid := WF_ENGINE.CONTEXT_NID;

1651: aname => 'TRX_ID');
1652:
1653:
1654: --get notification id from wf_engine context
1655: l_nid := WF_ENGINE.CONTEXT_NID;
1656: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
1657:
1658: --rkuttiya changed for bug#5149488
1659: IF l_ntf_result = 'VND_REJECTED' THEN

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

1688: ( p_count => l_msg_count,
1689: p_data => l_msg_data);
1690: Get_Messages(l_msg_count,l_error);
1691:
1692: wf_engine.SetItemAttrText(itemtype => itemtype,
1693: itemkey => itemkey,
1694: aname => 'ERROR_MESSAGE',
1695: avalue => l_error);
1696:

Line 1713: resultout := wf_engine.eng_null;

1709: --
1710: --Transfer Mode
1711: --
1712: IF funcmode = 'TRANSFER' THEN
1713: resultout := wf_engine.eng_null;
1714: return;
1715: END IF;
1716:
1717: --rkuttiya added for bug # 5149488

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

1801: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1802: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1803: BEGIN
1804: IF funcmode = 'RUN' THEN
1805: l_ctr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1806: itemkey => itemkey,
1807: aname => 'CONTRACT_ID');
1808: OPEN c_vnd_pgm(l_ctr_id);
1809: FETCH c_vnd_pgm INTO l_khr_id;

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

1818: FETCH c_email INTO l_contact_name,l_email;
1819: CLOSE c_email;
1820: END IF;
1821:
1822: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1823: itemkey => itemkey,
1824: aname => 'TRX_ID');
1825:
1826: --set the value for the vendor email attribute,recipient type - VC for Vendor Contact

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

1823: itemkey => itemkey,
1824: aname => 'TRX_ID');
1825:
1826: --set the value for the vendor email attribute,recipient type - VC for Vendor Contact
1827: wf_engine.SetItemAttrText (itemtype=> itemtype,
1828: itemkey => itemkey,
1829: aname => 'VENDOR_EMAIL',
1830: avalue => l_email) ;
1831:

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

1829: aname => 'VENDOR_EMAIL',
1830: avalue => l_email) ;
1831:
1832: --set the EMAIL_ADDRESS attribute to that of Vendor for XML Publisher Report
1833: wf_engine.SetItemAttrText(itemtype => itemtype,
1834: itemkey => itemkey,
1835: aname => 'EMAIL_ADDRESS',
1836: avalue => l_email);
1837:

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

1835: aname => 'EMAIL_ADDRESS',
1836: avalue => l_email);
1837:
1838: --rkuttiya changed recipient type to VENDOR for XMLPProject
1839: wf_engine.SetItemAttrText (itemtype=> itemtype,
1840: itemkey => itemkey,
1841: aname => 'RECIPIENT_TYPE',
1842: avalue => 'VENDOR') ;
1843:

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

1840: itemkey => itemkey,
1841: aname => 'RECIPIENT_TYPE',
1842: avalue => 'VENDOR') ;
1843:
1844: wf_engine.SetItemAttrText (itemtype=> itemtype,
1845: itemkey => itemkey,
1846: aname => 'RECIPIENT_DESCRIPTION',
1847: avalue => l_contact_name);
1848:

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

1845: itemkey => itemkey,
1846: aname => 'RECIPIENT_DESCRIPTION',
1847: avalue => l_contact_name);
1848:
1849: wf_engine.SetItemAttrText (itemtype=> itemtype,
1850: itemkey => itemkey,
1851: aname => 'RECIPIENT_ID',
1852: avalue => l_object_id);
1853:

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

1869: );
1870:
1871: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1872: l_batch_id := lx_xmp_rec.batch_id;
1873: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1874: itemkey => itemkey,
1875: aname => 'BATCH_ID',
1876: avalue => l_batch_id );
1877: resultout := 'COMPLETE:YES';

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

1881: ( p_count => l_msg_count,
1882: p_data => l_msg_data);
1883: Get_Messages(l_msg_count,l_error);
1884:
1885: wf_engine.SetItemAttrText(itemtype => itemtype,
1886: itemkey => itemkey,
1887: aname => 'ERROR_MESSAGE',
1888: avalue => l_error);
1889: resultout := 'COMPLETE:N';

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

1939: l_party_id NUMBER;
1940: l_ctr NUMBER;
1941: BEGIN
1942: IF funcmode = 'RUN' THEN
1943: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1944: itemkey => itemkey,
1945: aname => 'PARTY_ID');
1946: OPEN c_cust_del(l_party_id);
1947: FETCH c_cust_del INTO l_ctr;

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

2022:
2023: BEGIN
2024: IF (funcmode = 'RUN') THEN
2025: -- Get the value of the request id
2026: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2027: itemkey => itemkey,
2028: aname => 'TRX_ID');
2029: l_svf_code := wf_engine.GetItemAttrText( itemtype => itemtype,
2030: itemkey => itemkey,

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

2025: -- Get the value of the request id
2026: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2027: itemkey => itemkey,
2028: aname => 'TRX_ID');
2029: l_svf_code := wf_engine.GetItemAttrText( itemtype => itemtype,
2030: itemkey => itemkey,
2031: aname => 'SERVICE_FEE_CODE');
2032:
2033: l_sty_name := 'SERVICE_FEE_TRANS_REQUEST';

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

2032:
2033: l_sty_name := 'SERVICE_FEE_TRANS_REQUEST';
2034:
2035:
2036: l_khr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2037: itemkey => itemkey,
2038: aname => 'CONTRACT_ID');
2039: OPEN c_svf_info(l_svf_code);
2040: FETCH c_svf_info into l_svf_name,l_svf_desc,l_svf_amount;

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

2057: ( p_count => lx_msg_count,
2058: p_data => lx_msg_data);
2059: Get_Messages(lx_msg_count,l_error);
2060:
2061: wf_engine.SetItemAttrText(itemtype => itemtype,
2062: itemkey => itemkey,
2063: aname => 'ERROR_MESSAGE',
2064: avalue => l_error);
2065: resultout := 'COMPLETE:N';

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

2117: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2118: BEGIN
2119: IF (funcmode = 'RESPOND') THEN
2120: --get request id
2121: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2122: itemkey => itemkey,
2123: aname => 'TRX_ID');
2124:
2125:

Line 2126: --get notification id from wf_engine context

2122: itemkey => itemkey,
2123: aname => 'TRX_ID');
2124:
2125:
2126: --get notification id from wf_engine context
2127: l_nid := WF_ENGINE.CONTEXT_NID;
2128: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2129:
2130: IF l_ntf_result = 'CREDIT_REJECTED' THEN

Line 2127: l_nid := WF_ENGINE.CONTEXT_NID;

2123: aname => 'TRX_ID');
2124:
2125:
2126: --get notification id from wf_engine context
2127: l_nid := WF_ENGINE.CONTEXT_NID;
2128: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2129:
2130: IF l_ntf_result = 'CREDIT_REJECTED' THEN
2131: l_sts_code := 'REJECTED';

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

2159: ( p_count => l_msg_count,
2160: p_data => l_msg_data);
2161: Get_Messages(l_msg_count,l_error);
2162:
2163: wf_engine.SetItemAttrText(itemtype => itemtype,
2164: itemkey => itemkey,
2165: aname => 'ERROR_MESSAGE',
2166: avalue => l_error);
2167:

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

2191: );
2192:
2193: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2194: l_batch_id := lx_xmp_rec.batch_id;
2195: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2196: itemkey => itemkey,
2197: aname => 'BATCH_ID',
2198: avalue => l_batch_id );
2199:

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

2202: ( p_count => l_msg_count,
2203: p_data => l_msg_data);
2204: Get_Messages(l_msg_count,l_error);
2205:
2206: wf_engine.SetItemAttrText(itemtype => itemtype,
2207: itemkey => itemkey,
2208: aname => 'ERROR_MESSAGE',
2209: avalue => l_error);
2210: resultout := 'COMPLETE:N';

Line 2220: resultout := wf_engine.eng_null;

2216: --
2217: --Transfer Mode
2218: --
2219: IF funcmode = 'TRANSFER' THEN
2220: resultout := wf_engine.eng_null;
2221: return;
2222: END IF;
2223:
2224: --Run Mode

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

2291: l_sts_code VARCHAR2(30);
2292: BEGIN
2293: IF (funcmode = 'RESPOND') THEN
2294: --get request id
2295: l_trx_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2296: itemkey => itemkey,
2297: aname => 'TRX_ID');
2298:
2299:

Line 2300: --get notification id from wf_engine context

2296: itemkey => itemkey,
2297: aname => 'TRX_ID');
2298:
2299:
2300: --get notification id from wf_engine context
2301: l_nid := WF_ENGINE.CONTEXT_NID;
2302: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2303:
2304: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN

Line 2301: l_nid := WF_ENGINE.CONTEXT_NID;

2297: aname => 'TRX_ID');
2298:
2299:
2300: --get notification id from wf_engine context
2301: l_nid := WF_ENGINE.CONTEXT_NID;
2302: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
2303:
2304: IF l_ntf_result = 'COLLECTIONS_REJECTED' THEN
2305: l_sts_code := 'REJECTED';

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

2332: ( p_count => l_msg_count,
2333: p_data => l_msg_data);
2334: Get_Messages(l_msg_count,l_error);
2335:
2336: wf_engine.SetItemAttrText(itemtype => itemtype,
2337: itemkey => itemkey,
2338: aname => 'ERROR_MESSAGE',
2339: avalue => l_error);
2340:

Line 2356: resultout := wf_engine.eng_null;

2352: --
2353: --Transfer Mode
2354: --
2355: IF funcmode = 'TRANSFER' THEN
2356: resultout := wf_engine.eng_null;
2357: return;
2358: END IF;
2359:
2360: --Run Mode

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

2405: l_return_status VARCHAR2(10);
2406: l_days_overdue NUMBER;
2407: BEGIN
2408: if (funcmode = 'RUN') then
2409: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2410: itemkey => itemkey,
2411: aname => 'CONTRACT_ID');
2412:
2413: days_cust_balance_overdue(p_contract_id => l_contract_id

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

2465: l_outstanding_balance NUMBER;
2466: l_return_status VARCHAR2(10);
2467: BEGIN
2468: if (funcmode = 'RUN') then
2469: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2470: itemkey => itemkey,
2471: aname => 'CONTRACT_ID');
2472:
2473: get_contract_balance(p_contract_id => l_contract_id

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

2524: l_outstanding_balance NUMBER;
2525: l_return_status VARCHAR2(10);
2526: BEGIN
2527: if (funcmode = 'RUN') then
2528: l_cust_account_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2529: itemkey => itemkey,
2530: aname => 'CUST_ACCOUNT_ID');
2531:
2532: get_customer_balance(p_cust_account_id => l_cust_account_id

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

2584: l_return_status VARCHAR2(10);
2585: l_product_name VARCHAR2(150);
2586: BEGIN
2587: if (funcmode = 'RUN') then
2588: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2589: itemkey => itemkey,
2590: aname => 'CONTRACT_ID');
2591:
2592: get_product(p_contract_id => l_contract_id

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

2644: l_return_status VARCHAR2(10);
2645: l_address_desc VARCHAR2(80);
2646: BEGIN
2647: if (funcmode = 'RUN') then
2648: l_contract_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2649: itemkey => itemkey,
2650: aname => 'CONTRACT_ID');
2651:
2652: get_bill_to_address(p_contract_id => l_contract_id

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

3066: WHERE id=p_ctr_id;
3067: BEGIN
3068:
3069: if (funcmode = 'RUN') then
3070: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3071: itemkey => itemkey,
3072: aname => 'REQUEST_ID');
3073: OPEN c_req_record(l_request_id);
3074: FETCH c_req_record INTO l_req_rec;

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

3092: l_lease_renewal_role := fnd_profile.value('OKL_CTR_RENEWAL_REP');
3093: IF l_lease_renewal_role IS NULL THEN
3094: l_lease_renewal_role := 'SYSADMIN';
3095: END IF;
3096: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3097: itemkey => itemkey,
3098: aname => 'ROLE_TO_RENEW_LEASE',
3099: avalue => l_lease_renewal_role);
3100: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3096: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3097: itemkey => itemkey,
3098: aname => 'ROLE_TO_RENEW_LEASE',
3099: avalue => l_lease_renewal_role);
3100: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3101: itemkey => itemkey,
3102: aname => 'OLD_CHRID',
3103: avalue => l_old_contract_id);
3104: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3100: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3101: itemkey => itemkey,
3102: aname => 'OLD_CHRID',
3103: avalue => l_old_contract_id);
3104: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3105: itemkey => itemkey,
3106: aname => 'YIELD',
3107: avalue => l_yield);
3108: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3104: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3105: itemkey => itemkey,
3106: aname => 'YIELD',
3107: avalue => l_yield);
3108: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3109: itemkey => itemkey,
3110: aname => 'START_DATE',
3111: avalue => l_start_date);
3112: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3108: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3109: itemkey => itemkey,
3110: aname => 'START_DATE',
3111: avalue => l_start_date);
3112: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3113: itemkey => itemkey,
3114: aname => 'END_DATE',
3115: avalue => l_end_date);
3116: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3112: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3113: itemkey => itemkey,
3114: aname => 'END_DATE',
3115: avalue => l_end_date);
3116: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3117: itemkey => itemkey,
3118: aname => 'TERM',
3119: avalue => l_term);
3120: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3116: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3117: itemkey => itemkey,
3118: aname => 'TERM',
3119: avalue => l_term);
3120: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3121: itemkey => itemkey,
3122: aname => 'RENT',
3123: avalue => l_rent);
3124: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3120: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3121: itemkey => itemkey,
3122: aname => 'RENT',
3123: avalue => l_rent);
3124: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3125: itemkey => itemkey,
3126: aname => 'RESIDUAL_PTY',
3127: avalue => l_residula_percentage);
3128: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3124: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3125: itemkey => itemkey,
3126: aname => 'RESIDUAL_PTY',
3127: avalue => l_residula_percentage);
3128: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3129: itemkey => itemkey,
3130: aname => 'CHR_ID',
3131: avalue => l_new_contract_id);
3132: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3128: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3129: itemkey => itemkey,
3130: aname => 'CHR_ID',
3131: avalue => l_new_contract_id);
3132: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3133: itemkey => itemkey,
3134: aname => 'OLD_CONTRACT_NUMBER',
3135: avalue => l_parent_contract_num);
3136: resultout := 'COMPLETE:';

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

3224: l_request_id NUMBER;
3225: l_nid NUMBER;
3226: BEGIN
3227:
3228: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
3229: itemkey => itemkey,
3230: aname => 'REQUEST_ID');
3231:
3232: IF (funcmode = 'RESPOND') THEN

Line 3233: --get notification id from wf_engine context

3229: itemkey => itemkey,
3230: aname => 'REQUEST_ID');
3231:
3232: IF (funcmode = 'RESPOND') THEN
3233: --get notification id from wf_engine context
3234: l_nid := WF_ENGINE.CONTEXT_NID;
3235: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3236:
3237: resultout := 'COMPLETE:'|| l_ntf_result;

Line 3234: l_nid := WF_ENGINE.CONTEXT_NID;

3230: aname => 'REQUEST_ID');
3231:
3232: IF (funcmode = 'RESPOND') THEN
3233: --get notification id from wf_engine context
3234: l_nid := WF_ENGINE.CONTEXT_NID;
3235: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3236:
3237: resultout := 'COMPLETE:'|| l_ntf_result;
3238:

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

3273: l_request_id NUMBER;
3274: l_nid NUMBER;
3275: BEGIN
3276:
3277: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
3278: itemkey => itemkey,
3279: aname => 'REQUEST_ID');
3280:
3281: IF (funcmode = 'RESPOND') THEN

Line 3282: --get notification id from wf_engine context

3278: itemkey => itemkey,
3279: aname => 'REQUEST_ID');
3280:
3281: IF (funcmode = 'RESPOND') THEN
3282: --get notification id from wf_engine context
3283: l_nid := WF_ENGINE.CONTEXT_NID;
3284: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3285:
3286: resultout := 'COMPLETE:'|| l_ntf_result;

Line 3283: l_nid := WF_ENGINE.CONTEXT_NID;

3279: aname => 'REQUEST_ID');
3280:
3281: IF (funcmode = 'RESPOND') THEN
3282: --get notification id from wf_engine context
3283: l_nid := WF_ENGINE.CONTEXT_NID;
3284: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3285:
3286: resultout := 'COMPLETE:'|| l_ntf_result;
3287:

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

3392: WHERE id=p_ctr_id;
3393: BEGIN
3394:
3395: if (funcmode = 'RUN') then
3396: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3397: itemkey => itemkey,
3398: aname => 'REQUEST_ID');
3399: OPEN c_req_record(l_request_id);
3400: FETCH c_req_record INTO l_req_rec;

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

3429:
3430: l_new_prin_balance := (nvl(l_cur_prin_balance,0) - nvl(l_req_rec.payment_amount,0));
3431: */
3432:
3433: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3434: itemkey => itemkey,
3435: aname => 'ROLE_TO_EXECUTE_PPD',
3436: avalue => l_principal_paydown_role);
3437: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3433: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3434: itemkey => itemkey,
3435: aname => 'ROLE_TO_EXECUTE_PPD',
3436: avalue => l_principal_paydown_role);
3437: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3438: itemkey => itemkey,
3439: aname => 'KHR_ID',
3440: avalue => l_contract_id);
3441: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3437: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3438: itemkey => itemkey,
3439: aname => 'KHR_ID',
3440: avalue => l_contract_id);
3441: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3442: itemkey => itemkey,
3443: aname => 'PAYDOWN_AMOUNT',
3444: avalue => l_req_rec.payment_amount);
3445: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3441: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3442: itemkey => itemkey,
3443: aname => 'PAYDOWN_AMOUNT',
3444: avalue => l_req_rec.payment_amount);
3445: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3446: itemkey => itemkey,
3447: aname => 'REQUEST_NUMBER',
3448: avalue => l_req_rec.request_number);
3449: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3445: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3446: itemkey => itemkey,
3447: aname => 'REQUEST_NUMBER',
3448: avalue => l_req_rec.request_number);
3449: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3450: itemkey => itemkey,
3451: aname => 'CONTRACT_NUMBER',
3452: avalue => l_contract_num);
3453: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3449: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3450: itemkey => itemkey,
3451: aname => 'CONTRACT_NUMBER',
3452: avalue => l_contract_num);
3453: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3454: itemkey => itemkey,
3455: aname => 'NEW_PAYMENT_AMOUNT',
3456: avalue => l_req_rec.amount);
3457:

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

3455: aname => 'NEW_PAYMENT_AMOUNT',
3456: avalue => l_req_rec.amount);
3457:
3458: --Next Payment Date
3459: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3460: itemkey => itemkey,
3461: aname => 'NEXT_PAYMENT_DATE',
3462: avalue => l_req_rec.start_date);
3463: --Paydown Date

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

3460: itemkey => itemkey,
3461: aname => 'NEXT_PAYMENT_DATE',
3462: avalue => l_req_rec.start_date);
3463: --Paydown Date
3464: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3465: itemkey => itemkey,
3466: aname => 'PAYDOWN_DATE',
3467: avalue => l_req_rec.payment_date);
3468:

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

3465: itemkey => itemkey,
3466: aname => 'PAYDOWN_DATE',
3467: avalue => l_req_rec.payment_date);
3468:
3469: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3470: itemkey => itemkey,
3471: aname => 'CURRENT_PRIN_BALANCE',
3472: avalue => l_cur_prin_balance);
3473:

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

3470: itemkey => itemkey,
3471: aname => 'CURRENT_PRIN_BALANCE',
3472: avalue => l_cur_prin_balance);
3473:
3474: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3475: itemkey => itemkey,
3476: aname => 'NEW_PRIN_BALANCE',
3477: avalue => l_new_prin_balance);
3478:

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

3475: itemkey => itemkey,
3476: aname => 'NEW_PRIN_BALANCE',
3477: avalue => l_new_prin_balance);
3478:
3479: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3480: itemkey => itemkey,
3481: aname => 'CURRENCY_CODE',
3482: avalue => l_req_rec.currency_code);
3483:

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

3525: l_request_id NUMBER;
3526: l_nid NUMBER;
3527: BEGIN
3528:
3529: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
3530: itemkey => itemkey,
3531: aname => 'REQUEST_ID');
3532:
3533: IF (funcmode = 'RESPOND') THEN

Line 3534: --get notification id from wf_engine context

3530: itemkey => itemkey,
3531: aname => 'REQUEST_ID');
3532:
3533: IF (funcmode = 'RESPOND') THEN
3534: --get notification id from wf_engine context
3535: l_nid := WF_ENGINE.CONTEXT_NID;
3536: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3537:
3538: resultout := 'COMPLETE:'|| l_ntf_result;

Line 3535: l_nid := WF_ENGINE.CONTEXT_NID;

3531: aname => 'REQUEST_ID');
3532:
3533: IF (funcmode = 'RESPOND') THEN
3534: --get notification id from wf_engine context
3535: l_nid := WF_ENGINE.CONTEXT_NID;
3536: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
3537:
3538: resultout := 'COMPLETE:'|| l_ntf_result;
3539:

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

3581: BEGIN
3582:
3583: if (funcmode = 'RUN') then
3584:
3585: l_khr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3586: itemkey => itemkey,
3587: aname => 'KHR_ID');
3588:
3589: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

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

3585: l_khr_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3586: itemkey => itemkey,
3587: aname => 'KHR_ID');
3588:
3589: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3590: itemkey => itemkey,
3591: aname => 'REQUEST_ID');
3592:
3593: --call the API here.

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

3606: p_data => l_msg_data
3607: );
3608: Get_Messages(l_msg_count,l_error);
3609:
3610: wf_engine.SetItemAttrText(itemtype => itemtype,
3611: itemkey => itemkey,
3612: aname => 'ERROR_MESSAGE',
3613: avalue => l_error);
3614:

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

3684: BEGIN
3685:
3686: if (funcmode = 'RUN') then
3687:
3688: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3689: itemkey => itemkey,
3690: aname => 'REQUEST_ID');
3691: l_trqv_rec.id := l_request_id;
3692: l_trqv_rec.request_status_code := 'PROCESSED';

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

3713: p_data => l_msg_data
3714: );
3715: Get_Messages(l_msg_count,l_error);
3716:
3717: wf_engine.SetItemAttrText(itemtype => itemtype,
3718: itemkey => itemkey,
3719: aname => 'ERROR_MESSAGE',
3720: avalue => l_error);
3721:

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

3833: WHERE id=p_ctr_id;
3834: BEGIN
3835:
3836: if (funcmode = 'RUN') then
3837: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3838: itemkey => itemkey,
3839: aname => 'REQUEST_ID');
3840: OPEN c_req_record(l_request_id);
3841: FETCH c_req_record INTO l_req_rec;

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

3851: l_approve_credit_memo_role := fnd_profile.value('OKL_CREDIT_MEMO_REP');
3852: IF l_approve_credit_memo_role IS NULL THEN
3853: l_approve_credit_memo_role := 'SYSADMIN';
3854: END IF;
3855: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3856: itemkey => itemkey,
3857: aname => 'NOTIFICATION_ROLE',
3858: avalue => l_approve_credit_memo_role);
3859: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3855: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3856: itemkey => itemkey,
3857: aname => 'NOTIFICATION_ROLE',
3858: avalue => l_approve_credit_memo_role);
3859: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3860: itemkey => itemkey,
3861: aname => 'CONTRACT_ID',
3862: avalue => l_contract_id);
3863: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3859: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3860: itemkey => itemkey,
3861: aname => 'CONTRACT_ID',
3862: avalue => l_contract_id);
3863: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3864: itemkey => itemkey,
3865: aname => 'CREDIT_AMOUNT',
3866: avalue => l_req_rec.amount);
3867: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3863: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3864: itemkey => itemkey,
3865: aname => 'CREDIT_AMOUNT',
3866: avalue => l_req_rec.amount);
3867: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3868: itemkey => itemkey,
3869: aname => 'REQUEST_NUMBER',
3870: avalue => l_req_rec.request_number);
3871: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3867: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3868: itemkey => itemkey,
3869: aname => 'REQUEST_NUMBER',
3870: avalue => l_req_rec.request_number);
3871: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3872: itemkey => itemkey,
3873: aname => 'CONTRACT_NUMBER',
3874: avalue => l_contract_num);
3875: wf_engine.SetItemAttrText ( itemtype=> itemtype,

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

3871: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3872: itemkey => itemkey,
3873: aname => 'CONTRACT_NUMBER',
3874: avalue => l_contract_num);
3875: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3876: itemkey => itemkey,
3877: aname => 'LSM_ID',
3878: avalue => l_req_rec.lsm_id);
3879: resultout := 'COMPLETE:Y';

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

3937:
3938: BEGIN
3939:
3940: if (funcmode = 'RUN') then
3941: l_lsm_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3942: itemkey => itemkey,
3943: aname => 'LSM_ID');
3944:
3945: l_credit_amount := wf_engine.GetItemAttrText( itemtype => itemtype,

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

3941: l_lsm_id := wf_engine.GetItemAttrText( itemtype => itemtype,
3942: itemkey => itemkey,
3943: aname => 'LSM_ID');
3944:
3945: l_credit_amount := wf_engine.GetItemAttrText( itemtype => itemtype,
3946: itemkey => itemkey,
3947: aname => 'CREDIT_AMOUNT');
3948: --We need to send -ve amount to the API so negating the amount.
3949: l_credit_amount := -(l_credit_amount);

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

3976: p_data => l_msg_data
3977: );
3978: Get_Messages(l_msg_count,l_error);
3979:
3980: wf_engine.SetItemAttrText(itemtype => itemtype,
3981: itemkey => itemkey,
3982: aname => 'ERROR_MESSAGE',
3983: avalue => l_error);
3984:

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

3985: resultout := 'COMPLETE:N';
3986:
3987: ELSE
3988:
3989: wf_engine.SetItemAttrText (itemtype=> itemtype,
3990: itemkey => itemkey,
3991: aname => 'TAI_ID',
3992: avalue => lx_tai_id);
3993:

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

4051: BEGIN
4052:
4053: if (funcmode = 'RUN') then
4054:
4055: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4056: itemkey => itemkey,
4057: aname => 'REQUEST_ID');
4058: l_trqv_rec.id := l_request_id;
4059: l_trqv_rec.request_status_code := 'APPROVED';

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

4080: p_data => l_msg_data
4081: );
4082: Get_Messages(l_msg_count,l_error);
4083:
4084: wf_engine.SetItemAttrText(itemtype => itemtype,
4085: itemkey => itemkey,
4086: aname => 'ERROR_MESSAGE',
4087: avalue => l_error);
4088:

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

4151: BEGIN
4152:
4153: if (funcmode = 'RUN') then
4154:
4155: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4156: itemkey => itemkey,
4157: aname => 'REQUEST_ID');
4158: l_trqv_rec.id := l_request_id;
4159: l_trqv_rec.request_status_code := 'REJECTED';

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

4180: p_data => l_msg_data
4181: );
4182: Get_Messages(l_msg_count,l_error);
4183:
4184: wf_engine.SetItemAttrText(itemtype => itemtype,
4185: itemkey => itemkey,
4186: aname => 'ERROR_MESSAGE',
4187: avalue => l_error);
4188:

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

4253:
4254: BEGIN
4255:
4256: if (funcmode = 'RUN') then
4257: l_tai_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4258: itemkey => itemkey,
4259: aname => 'TAI_ID');
4260:
4261: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,

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

4257: l_tai_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4258: itemkey => itemkey,
4259: aname => 'TAI_ID');
4260:
4261: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4262: itemkey => itemkey,
4263: aname => 'REQUEST_ID');
4264: l_trqv_rec.id := l_request_id;
4265: l_trqv_rec.object1_id1 := l_tai_id;

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

4288: p_data => l_msg_data
4289: );
4290: Get_Messages(l_msg_count,l_error);
4291:
4292: wf_engine.SetItemAttrText(itemtype => itemtype,
4293: itemkey => itemkey,
4294: aname => 'ERROR_MESSAGE',
4295: avalue => l_error);
4296:

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

4358: BEGIN
4359:
4360: if (funcmode = 'RUN') then
4361:
4362: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4363: itemkey => itemkey,
4364: aname => 'REQUEST_ID');
4365: l_trqv_rec.id := l_request_id;
4366: l_trqv_rec.request_status_code := 'INCOMPLETE'; --Should this be error instead

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

4387: p_data => l_msg_data
4388: );
4389: Get_Messages(l_msg_count,l_error);
4390:
4391: wf_engine.SetItemAttrText(itemtype => itemtype,
4392: itemkey => itemkey,
4393: aname => 'ERROR_MESSAGE',
4394: avalue => l_error);
4395: