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 278: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', true);

274: where det.card_id = card.card_id
275: and card.request_id = l_request_id;
276: begin
277: if ( funcmode = 'RUN' ) then
278: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', true);
279: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);
280:
281: select card_emp_matching_rule into l_match_rule
282: from ap_card_programs_all

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

275: and card.request_id = l_request_id;
276: begin
277: if ( funcmode = 'RUN' ) then
278: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', true);
279: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);
280:
281: select card_emp_matching_rule into l_match_rule
282: from ap_card_programs_all
283: where card_program_id = l_card_program_id;

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

335: having count(*) = 1;
336:
337: begin
338: if ( funcmode = 'RUN' ) then
339: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', false);
340: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);
341:
342: for crec in cemp loop
343: ap_web_cc_validations_pkg.assign_employee(crec.card_id, crec.employee_id);

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

336:
337: begin
338: if ( funcmode = 'RUN' ) then
339: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', false);
340: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);
341:
342: for crec in cemp loop
343: ap_web_cc_validations_pkg.assign_employee(crec.card_id, crec.employee_id);
344: end loop;

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

374: l_request_id number;
375: l_exist number;
376: begin
377: if ( funcmode = 'RUN' ) then
378: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
379: select count(*) into l_exist from dual
380: where exists (select 1 from ap_cards_all where request_id = l_request_id);
381:
382: if l_exist = 0 then

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

416: l_request_id number;
417: l_exist number;
418: begin
419: if ( funcmode = 'RUN' ) then
420: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
421: select count(*) into l_exist from dual
422: where exists (select 1 from ap_cards_all where request_id = l_request_id and employee_id is null);
423:
424: if l_exist = 0 then

Line 466: 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)

462: l_exist number;
463: l_exist1 number;
464: l_exist2 number;
465: begin
466: 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)
467: if ( funcmode = 'RUN' ) then
468: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
469: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
470: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);

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

464: l_exist2 number;
465: begin
466: 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)
467: if ( funcmode = 'RUN' ) then
468: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
469: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
470: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
471: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
472: select count(*) into l_exist1 from dual

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

465: begin
466: 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)
467: if ( funcmode = 'RUN' ) then
468: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
469: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
470: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
471: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
472: select count(*) into l_exist1 from dual
473: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');

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

466: 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)
467: if ( funcmode = 'RUN' ) then
468: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
469: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
470: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
471: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
472: select count(*) into l_exist1 from dual
473: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');
474: SELECT COUNT(*) INTO l_exist2 FROM dual

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

467: if ( funcmode = 'RUN' ) then
468: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
469: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
470: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
471: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
472: select count(*) into l_exist1 from dual
473: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');
474: SELECT COUNT(*) INTO l_exist2 FROM dual
475: WHERE exists (SELECT 1 FROM ap_credit_card_trxns_all

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

516: l_request_id number;
517: l_count number;
518: begin
519: if ( funcmode = 'RUN' ) then
520: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
521: select count(*) into l_count
522: from ap_cards_all
523: where request_id = l_request_id;
524:

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

521: select count(*) into l_count
522: from ap_cards_all
523: where request_id = l_request_id;
524:
525: wf_engine.setitemattrnumber(itemtype,itemkey,'NEW_CARD_COUNT',l_count);
526:
527: resultout := 'COMPLETE:';
528: return;
529: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then

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

561:
562: url varchar2(2000);
563: begin
564: if ( funcmode = 'RUN' ) then
565: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
566: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
567:
568: url := 'JSP:/OA_HTML/OA.jsp?OAFunc=OIE_NEW_CCARD_SEARCH_FN'||
569: '&'||'restrict=Y'||

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

562: url varchar2(2000);
563: begin
564: if ( funcmode = 'RUN' ) then
565: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true);
566: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',true);
567:
568: url := 'JSP:/OA_HTML/OA.jsp?OAFunc=OIE_NEW_CCARD_SEARCH_FN'||
569: '&'||'restrict=Y'||
570: '&'||'pRequestId='||to_char(l_request_id)||

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

570: '&'||'pRequestId='||to_char(l_request_id)||
571: '&'||'pCardProgramId='||to_char(l_card_program_id)||
572: '&'||'NtfId=-&#NID-';
573:
574: wf_engine.setitemattrtext(itemtype,itemkey,'NEW_CREDIT_CARD_URL',url);
575:
576: resultout := 'COMPLETE:';
577: return;
578: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then

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

610: begin
611: if ( funcmode = 'RUN' ) then
612:
613: begin
614: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',true); -- Bug 6971825
615:
616: select user_name into user_name
617: from fnd_user
618: where user_id in (select requested_by from FND_CONCURRENT_REQUESTS where

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

617: from fnd_user
618: where user_id in (select requested_by from FND_CONCURRENT_REQUESTS where
619: request_id = nvl(l_request_id,fnd_global.user_id));
620:
621: attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);
622: wf_engine.setitemattrtext(itemtype,itemkey,attr_name,user_name);
623: exception
624: when no_data_found then
625: user_name := null;

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

618: where user_id in (select requested_by from FND_CONCURRENT_REQUESTS where
619: request_id = nvl(l_request_id,fnd_global.user_id));
620:
621: attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);
622: wf_engine.setitemattrtext(itemtype,itemkey,attr_name,user_name);
623: exception
624: when no_data_found then
625: user_name := null;
626: end;

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

659: l_role_name varchar2(360);
660: l_person_id number;
661: begin
662: if ( funcmode = 'RUN' ) then
663: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',false);
664:
665: IF(l_card_program_id IS NOT NULL) THEN
666: select sysadmin_role_name, admin_employee_id into l_role_name, l_person_id
667: from ap_card_programs_all

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

688: if l_role_name is null then
689: whoami(itemtype, itemkey, actid, funcmode, resultout);
690: return;
691: else
692: l_attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);
693: wf_engine.setitemattrtext(itemtype,itemkey,l_attr_name,l_role_name);
694:
695: resultout := 'COMPLETE:';
696: return;

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

689: whoami(itemtype, itemkey, actid, funcmode, resultout);
690: return;
691: else
692: l_attr_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_NAME', false);
693: wf_engine.setitemattrtext(itemtype,itemkey,l_attr_name,l_role_name);
694:
695: resultout := 'COMPLETE:';
696: return;
697: end if;

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

725: l_name varchar2(80);
726: l_id number;
727: begin
728: if ( funcmode = 'RUN' ) then
729: l_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',false);
730: -- Bug 6829024(sodash)
731: if (l_id is null) then
732: wf_engine.setitemattrtext(itemtype,itemkey,'CARD_PROGRAM_NAME',null);
733: return;

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

728: if ( funcmode = 'RUN' ) then
729: l_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',false);
730: -- Bug 6829024(sodash)
731: if (l_id is null) then
732: wf_engine.setitemattrtext(itemtype,itemkey,'CARD_PROGRAM_NAME',null);
733: return;
734: end if;
735:
736: select card_program_name into l_name

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

735:
736: select card_program_name into l_name
737: from ap_card_programs_all
738: where card_program_id = l_id;
739: wf_engine.setitemattrtext(itemtype,itemkey,'CARD_PROGRAM_NAME',l_name);
740:
741: resultout := 'COMPLETE';
742: return;
743: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then

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

768: l_attrname VARCHAR2(100);
769: l_attrval VARCHAR2(100);
770: begin
771: if ( funcmode = 'RUN' ) then
772: l_attrname := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'RETURN_ATTRIBUTE_NAME',false);
773: l_attrval := wf_engine.getitemattrtext(itemtype,itemkey,l_attrname,false);
774: resultout := 'COMPLETE:'||l_attrval;
775: return;
776: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then

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

769: l_attrval VARCHAR2(100);
770: begin
771: if ( funcmode = 'RUN' ) then
772: l_attrname := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'RETURN_ATTRIBUTE_NAME',false);
773: l_attrval := wf_engine.getitemattrtext(itemtype,itemkey,l_attrname,false);
774: resultout := 'COMPLETE:'||l_attrval;
775: return;
776: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then
777: resultout := 'COMPLETE';

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

801: l_attrname VARCHAR2(100);
802: l_attrval VARCHAR2(100);
803: begin
804: if ( funcmode = 'RUN' ) then
805: l_attrval := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'ATTRIBUTE_VALUE',FALSE);
806: resultout := 'COMPLETE:'||l_attrval;
807: return;
808: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then
809: resultout := 'COMPLETE';

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

832: l_message_name varchar2(30);
833: l_message_text varchar2(240);
834: begin
835: if ( funcmode = 'RUN' ) THEN
836: l_message_app := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_APP',false);
837: l_message_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_NAME',false);
838: fnd_message.set_name(l_message_app, l_message_name);
839: l_message_text := fnd_message.get;
840: wf_engine.setitemattrtext(itemtype,itemkey,'INSTRUCTIONS',l_message_text);

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

833: l_message_text varchar2(240);
834: begin
835: if ( funcmode = 'RUN' ) THEN
836: l_message_app := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_APP',false);
837: l_message_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_NAME',false);
838: fnd_message.set_name(l_message_app, l_message_name);
839: l_message_text := fnd_message.get;
840: wf_engine.setitemattrtext(itemtype,itemkey,'INSTRUCTIONS',l_message_text);
841: resultout := 'COMPLETE';

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

836: l_message_app := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_APP',false);
837: l_message_name := wf_engine.getactivityattrtext(itemtype,itemkey,actid,'MESSAGE_NAME',false);
838: fnd_message.set_name(l_message_app, l_message_name);
839: l_message_text := fnd_message.get;
840: wf_engine.setitemattrtext(itemtype,itemkey,'INSTRUCTIONS',l_message_text);
841: resultout := 'COMPLETE';
842: return;
843: elsif ( funcmode in ('CANCEL', 'RESPOND', 'FORWARD', 'TRANSFER', 'TIMEOUT') ) then
844: resultout := 'COMPLETE';