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

Line 94: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);

90: type gen_cursor is ref cursor;
91: c gen_cursor;
92: begin
93: if ( funcmode = 'RUN' ) then
94: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
95: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
96: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);
97: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);
98:

Line 95: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);

91: c gen_cursor;
92: begin
93: if ( funcmode = 'RUN' ) then
94: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
95: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
96: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);
97: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);
98:
99: stmt := 'select validate_code, count(*) '||

Line 96: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);

92: begin
93: if ( funcmode = 'RUN' ) then
94: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
95: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
96: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);
97: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);
98:
99: stmt := 'select validate_code, count(*) '||
100: 'from ap_credit_card_trxns_all '||

Line 97: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);

93: if ( funcmode = 'RUN' ) then
94: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
95: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
96: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);
97: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);
98:
99: stmt := 'select validate_code, count(*) '||
100: 'from ap_credit_card_trxns_all '||
101: 'where validate_code not in (''Y'', ''N'', ''UNTESTED'') ';

Line 131: wf_engine.setitemattrnumber(itemtype,itemkey,l_validate_code,l_count);

127: loop
128: fetch c into l_validate_code, l_count;
129: exit when c%notfound;
130:
131: wf_engine.setitemattrnumber(itemtype,itemkey,l_validate_code,l_count);
132: l_total_count := l_total_count + l_count;
133: end loop;
134: close c;
135:

Line 136: wf_engine.setitemattrnumber(itemtype,itemkey,'INVALID_ALL',l_total_count);

132: l_total_count := l_total_count + l_count;
133: end loop;
134: close c;
135:
136: wf_engine.setitemattrnumber(itemtype,itemkey,'INVALID_ALL',l_total_count);
137: exception
138: when others then
139: if c%isopen then
140: close c;

Line 186: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);

182:
183: url varchar2(2000);
184: begin
185: if ( funcmode = 'RUN' ) then
186: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
187: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
188: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);
189: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);
190:

Line 187: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);

183: url varchar2(2000);
184: begin
185: if ( funcmode = 'RUN' ) then
186: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
187: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
188: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);
189: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);
190:
191: url := 'JSP:/OA_HTML/OA.jsp?OAFunc=OIE_CCTRX_SEARCH_FN'||

Line 188: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);

184: begin
185: if ( funcmode = 'RUN' ) then
186: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
187: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
188: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);
189: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);
190:
191: url := 'JSP:/OA_HTML/OA.jsp?OAFunc=OIE_CCTRX_SEARCH_FN'||
192: '&'||'restrict=Y'||

Line 189: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);

185: if ( funcmode = 'RUN' ) then
186: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
187: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
188: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);
189: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);
190:
191: url := 'JSP:/OA_HTML/OA.jsp?OAFunc=OIE_CCTRX_SEARCH_FN'||
192: '&'||'restrict=Y'||
193: '&'||'pRequestId='||to_char(l_request_id)||

Line 200: wf_engine.setitemattrtext(itemtype,itemkey,'SEARCH_PAGE_URL',url);

196: '&'||'pEndDate='||to_char(l_end_date, 'YYYY/MM/DD')||
197: '&'||'pValidateCode=INVALID_ALL'||
198: '&'||'NtfId=-&#NID-';
199:
200: wf_engine.setitemattrtext(itemtype,itemkey,'SEARCH_PAGE_URL',url);
201:
202: resultout := 'COMPLETE:';
203: return;
204: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then

Line 302: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', true);

298: where det.card_id = card.card_id
299: and card.request_id = l_request_id;
300: begin
301: if ( funcmode = 'RUN' ) then
302: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', true);
303: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);
304:
305: for crec in ccard LOOP
306: select card_emp_matching_rule into l_match_rule

Line 303: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);

299: and card.request_id = l_request_id;
300: begin
301: if ( funcmode = 'RUN' ) then
302: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', true);
303: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);
304:
305: for crec in ccard LOOP
306: select card_emp_matching_rule into l_match_rule
307: from ap_card_programs_all

Line 363: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', false);

359: having count(*) = 1;
360:
361: begin
362: if ( funcmode = 'RUN' ) then
363: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', false);
364: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);
365:
366: for crec in cemp loop
367: ap_web_cc_validations_pkg.assign_employee(crec.card_id, crec.employee_id);

Line 364: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);

360:
361: begin
362: if ( funcmode = 'RUN' ) then
363: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', false);
364: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);
365:
366: for crec in cemp loop
367: ap_web_cc_validations_pkg.assign_employee(crec.card_id, crec.employee_id);
368: end loop;

Line 402: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);

398: l_request_id number;
399: l_exist number;
400: begin
401: if ( funcmode = 'RUN' ) then
402: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
403: select count(*) into l_exist from dual
404: where exists (select 1 from ap_cards_all where request_id = l_request_id);
405:
406: if l_exist = 0 then

Line 444: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);

440: l_request_id number;
441: l_exist number;
442: begin
443: if ( funcmode = 'RUN' ) then
444: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
445: select count(*) into l_exist from dual
446: where exists (select 1 from ap_cards_all where request_id = l_request_id and employee_id is null);
447:
448: if l_exist = 0 then

Line 490: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'OIE_INVALID_TABLE','JSP:/OA_HTML/OA.jsp?akRegionCode=InvalidCCardRN'||'&'||'akRegionApplicationId=200'||'&'||'itemKey='||itemkey||'&'||'requestId=-&#HDR_REQUEST_ID-'); -- Bug 6829024(sodash)

486: l_exist number;
487: l_exist1 number;
488: l_exist2 number;
489: begin
490: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'OIE_INVALID_TABLE','JSP:/OA_HTML/OA.jsp?akRegionCode=InvalidCCardRN'||'&'||'akRegionApplicationId=200'||'&'||'itemKey='||itemkey||'&'||'requestId=-&#HDR_REQUEST_ID-'); -- Bug 6829024(sodash)
491: if ( funcmode = 'RUN' ) then
492: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
493: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
494: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);

Line 492: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);

488: l_exist2 number;
489: begin
490: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'OIE_INVALID_TABLE','JSP:/OA_HTML/OA.jsp?akRegionCode=InvalidCCardRN'||'&'||'akRegionApplicationId=200'||'&'||'itemKey='||itemkey||'&'||'requestId=-&#HDR_REQUEST_ID-'); -- Bug 6829024(sodash)
491: if ( funcmode = 'RUN' ) then
492: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
493: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
494: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
495: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
496: select count(*) into l_exist1 from dual

Line 493: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);

489: begin
490: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'OIE_INVALID_TABLE','JSP:/OA_HTML/OA.jsp?akRegionCode=InvalidCCardRN'||'&'||'akRegionApplicationId=200'||'&'||'itemKey='||itemkey||'&'||'requestId=-&#HDR_REQUEST_ID-'); -- Bug 6829024(sodash)
491: if ( funcmode = 'RUN' ) then
492: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
493: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
494: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
495: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
496: select count(*) into l_exist1 from dual
497: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');

Line 494: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);

490: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'OIE_INVALID_TABLE','JSP:/OA_HTML/OA.jsp?akRegionCode=InvalidCCardRN'||'&'||'akRegionApplicationId=200'||'&'||'itemKey='||itemkey||'&'||'requestId=-&#HDR_REQUEST_ID-'); -- Bug 6829024(sodash)
491: if ( funcmode = 'RUN' ) then
492: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
493: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
494: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
495: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
496: select count(*) into l_exist1 from dual
497: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');
498: SELECT COUNT(*) INTO l_exist2 FROM dual

Line 495: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);

491: if ( funcmode = 'RUN' ) then
492: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
493: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
494: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
495: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
496: select count(*) into l_exist1 from dual
497: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');
498: SELECT COUNT(*) INTO l_exist2 FROM dual
499: WHERE exists (SELECT 1 FROM ap_credit_card_trxns_all

Line 544: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);

540: l_request_id number;
541: l_count number;
542: begin
543: if ( funcmode = 'RUN' ) then
544: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
545: select count(*) into l_count
546: from ap_cards_all
547: where request_id = l_request_id;
548:

Line 549: wf_engine.setitemattrnumber(itemtype,itemkey,'NEW_CARD_COUNT',l_count);

545: select count(*) into l_count
546: from ap_cards_all
547: where request_id = l_request_id;
548:
549: wf_engine.setitemattrnumber(itemtype,itemkey,'NEW_CARD_COUNT',l_count);
550:
551: resultout := 'COMPLETE:';
552: return;
553: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then

Line 589: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);

585:
586: url varchar2(2000);
587: begin
588: if ( funcmode = 'RUN' ) then
589: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
590: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
591:
592: url := 'JSP:/OA_HTML/OA.jsp?OAFunc=OIE_NEW_CCARD_SEARCH_FN'||
593: '&'||'restrict=Y'||

Line 590: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);

586: url varchar2(2000);
587: begin
588: if ( funcmode = 'RUN' ) then
589: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
590: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
591:
592: url := 'JSP:/OA_HTML/OA.jsp?OAFunc=OIE_NEW_CCARD_SEARCH_FN'||
593: '&'||'restrict=Y'||
594: '&'||'pRequestId='||to_char(l_request_id)||

Line 598: wf_engine.setitemattrtext(itemtype,itemkey,'NEW_CREDIT_CARD_URL',url);

594: '&'||'pRequestId='||to_char(l_request_id)||
595: '&'||'pCardProgramId='||to_char(l_card_program_id)||
596: '&'||'NtfId=-&#NID-';
597:
598: wf_engine.setitemattrtext(itemtype,itemkey,'NEW_CREDIT_CARD_URL',url);
599:
600: resultout := 'COMPLETE:';
601: return;
602: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then

Line 638: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true); -- Bug 6971825

634: begin
635: if ( funcmode = 'RUN' ) then
636:
637: begin
638: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true); -- Bug 6971825
639:
640: select user_name into user_name
641: from fnd_user
642: where user_id in (select requested_by from FND_CONCURRENT_REQUESTS where

Line 645: attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);

641: from fnd_user
642: where user_id in (select requested_by from FND_CONCURRENT_REQUESTS where
643: request_id = nvl(l_request_id,fnd_global.user_id));
644:
645: attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);
646: wf_engine.setitemattrtext(itemtype,itemkey,attr_name,user_name);
647: exception
648: when no_data_found then
649: user_name := null;

Line 646: wf_engine.setitemattrtext(itemtype,itemkey,attr_name,user_name);

642: where user_id in (select requested_by from FND_CONCURRENT_REQUESTS where
643: request_id = nvl(l_request_id,fnd_global.user_id));
644:
645: attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);
646: wf_engine.setitemattrtext(itemtype,itemkey,attr_name,user_name);
647: exception
648: when no_data_found then
649: user_name := null;
650: end;

Line 687: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',false);

683: l_role_name varchar2(360);
684: l_person_id number;
685: begin
686: if ( funcmode = 'RUN' ) then
687: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',false);
688:
689: IF(l_card_program_id IS NOT NULL) THEN
690: select sysadmin_role_name, admin_employee_id into l_role_name, l_person_id
691: from ap_card_programs_all

Line 716: l_attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);

712: if l_role_name is null then
713: whoami(itemtype, itemkey, actid, funcmode, resultout);
714: return;
715: else
716: l_attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);
717: wf_engine.setitemattrtext(itemtype,itemkey,l_attr_name,l_role_name);
718:
719: resultout := 'COMPLETE:';
720: return;

Line 717: wf_engine.setitemattrtext(itemtype,itemkey,l_attr_name,l_role_name);

713: whoami(itemtype, itemkey, actid, funcmode, resultout);
714: return;
715: else
716: l_attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);
717: wf_engine.setitemattrtext(itemtype,itemkey,l_attr_name,l_role_name);
718:
719: resultout := 'COMPLETE:';
720: return;
721: end if;

Line 753: l_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',false);

749: l_name varchar2(80);
750: l_id number;
751: begin
752: if ( funcmode = 'RUN' ) then
753: l_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',false);
754: -- Bug 6829024(sodash)
755: if (l_id is null) then
756: wf_engine.setitemattrtext(itemtype,itemkey,'CARD_PROGRAM_NAME',null);
757: return;

Line 756: wf_engine.setitemattrtext(itemtype,itemkey,'CARD_PROGRAM_NAME',null);

752: if ( funcmode = 'RUN' ) then
753: l_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',false);
754: -- Bug 6829024(sodash)
755: if (l_id is null) then
756: wf_engine.setitemattrtext(itemtype,itemkey,'CARD_PROGRAM_NAME',null);
757: return;
758: end if;
759:
760: select card_program_name into l_name

Line 763: wf_engine.setitemattrtext(itemtype,itemkey,'CARD_PROGRAM_NAME',l_name);

759:
760: select card_program_name into l_name
761: from ap_card_programs_all
762: where card_program_id = l_id;
763: wf_engine.setitemattrtext(itemtype,itemkey,'CARD_PROGRAM_NAME',l_name);
764:
765: resultout := 'COMPLETE';
766: return;
767: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then

Line 796: l_attrname := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'RETURN_ATTRIBUTE_NAME',false);

792: l_attrname VARCHAR2(100);
793: l_attrval VARCHAR2(100);
794: begin
795: if ( funcmode = 'RUN' ) then
796: l_attrname := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'RETURN_ATTRIBUTE_NAME',false);
797: l_attrval := wf_engine.getitemattrtext(itemtype,itemkey,l_attrname,false);
798: resultout := 'COMPLETE:'||l_attrval;
799: return;
800: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then

Line 797: l_attrval := wf_engine.getitemattrtext(itemtype,itemkey,l_attrname,false);

793: l_attrval VARCHAR2(100);
794: begin
795: if ( funcmode = 'RUN' ) then
796: l_attrname := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'RETURN_ATTRIBUTE_NAME',false);
797: l_attrval := wf_engine.getitemattrtext(itemtype,itemkey,l_attrname,false);
798: resultout := 'COMPLETE:'||l_attrval;
799: return;
800: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then
801: resultout := 'COMPLETE';

Line 829: l_attrval := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_VALUE',FALSE);

825: l_attrname VARCHAR2(100);
826: l_attrval VARCHAR2(100);
827: begin
828: if ( funcmode = 'RUN' ) then
829: l_attrval := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_VALUE',FALSE);
830: resultout := 'COMPLETE:'||l_attrval;
831: return;
832: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then
833: resultout := 'COMPLETE';

Line 860: l_message_app := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_APP',false);

856: l_message_name varchar2(30);
857: l_message_text varchar2(240);
858: begin
859: if ( funcmode = 'RUN' ) THEN
860: l_message_app := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_APP',false);
861: l_message_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_NAME',false);
862: fnd_message.set_name(l_message_app, l_message_name);
863: l_message_text := fnd_message.get;
864: wf_engine.setitemattrtext(itemtype,itemkey,'INSTRUCTIONS',l_message_text);

Line 861: l_message_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_NAME',false);

857: l_message_text varchar2(240);
858: begin
859: if ( funcmode = 'RUN' ) THEN
860: l_message_app := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_APP',false);
861: l_message_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_NAME',false);
862: fnd_message.set_name(l_message_app, l_message_name);
863: l_message_text := fnd_message.get;
864: wf_engine.setitemattrtext(itemtype,itemkey,'INSTRUCTIONS',l_message_text);
865: resultout := 'COMPLETE';

Line 864: wf_engine.setitemattrtext(itemtype,itemkey,'INSTRUCTIONS',l_message_text);

860: l_message_app := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_APP',false);
861: l_message_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_NAME',false);
862: fnd_message.set_name(l_message_app, l_message_name);
863: l_message_text := fnd_message.get;
864: wf_engine.setitemattrtext(itemtype,itemkey,'INSTRUCTIONS',l_message_text);
865: resultout := 'COMPLETE';
866: return;
867: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then
868: resultout := 'COMPLETE';