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

Line 33: l_approval_result := wf_engine.getitemattrtext (itemtype => item_type,

29: 'fnd.plsql.UMXUTILB.checkApprovalStatus.begin','');
30: end if;
31:
32: if (command = 'RUN') then
33: l_approval_result := wf_engine.getitemattrtext (itemtype => item_type,
34: itemkey => item_key,
35: aname => 'APPROVAL_RESULT',
36: ignore_notfound => false);
37:

Line 162: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,

158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
159: 'fnd.plsql.UMXUTILB.addparamtoevent.begin','');
160: end if;
161:
162: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,
163: itemkey => p_item_key,
164: name => 'REGISTRATION_DATA');
165: l_event.addParametertoList (p_attr_name,p_attr_value);
166: wf_engine.setitemattrevent (itemtype => p_item_type,

Line 166: wf_engine.setitemattrevent (itemtype => p_item_type,

162: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,
163: itemkey => p_item_key,
164: name => 'REGISTRATION_DATA');
165: l_event.addParametertoList (p_attr_name,p_attr_value);
166: wf_engine.setitemattrevent (itemtype => p_item_type,
167: itemkey => p_item_key,
168: name => 'REGISTRATION_DATA',
169: event => l_event);
170:

Line 225: l_wf_role_name := wf_engine.getitemattrtext (itemtype => item_type,

221: 'fnd.plsql.UMXUTILB.assignwfRole.begin','itemkey: '||item_key);
222: end if;
223:
224: if (command = 'RUN') then
225: l_wf_role_name := wf_engine.getitemattrtext (itemtype => item_type,
226: itemkey => item_key,
227: aname => 'WF_ROLE_NAME',
228: ignore_notfound => false);
229:

Line 232: wf_engine.getitemattrtext (itemtype => item_type,

228: ignore_notfound => false);
229:
230:
231: l_user_role_start_date := fnd_date.canonical_to_date (
232: wf_engine.getitemattrtext (itemtype => item_type,
233: itemkey => item_key,
234: aname => 'REQUESTED_START_DATE',
235: ignore_notfound => false));
236:

Line 238: wf_engine.getitemattrtext (itemtype => item_type,

234: aname => 'REQUESTED_START_DATE',
235: ignore_notfound => false));
236:
237: l_user_role_expiration_date := fnd_date.canonical_to_date (
238: wf_engine.getitemattrtext (itemtype => item_type,
239: itemkey => item_key,
240: aname => 'REQUESTED_END_DATE',
241: ignore_notfound => false));
242:

Line 243: l_requested_for_user_id := wf_engine.getitemattrtext (itemtype => item_type,

239: itemkey => item_key,
240: aname => 'REQUESTED_END_DATE',
241: ignore_notfound => false));
242:
243: l_requested_for_user_id := wf_engine.getitemattrtext (itemtype => item_type,
244: itemkey => item_key,
245: aname => 'REQUESTED_FOR_USER_ID',
246: ignore_notfound => false);
247:

Line 248: l_user_name := wf_engine.getitemattrtext (itemtype => item_type,

244: itemkey => item_key,
245: aname => 'REQUESTED_FOR_USER_ID',
246: ignore_notfound => false);
247:
248: l_user_name := wf_engine.getitemattrtext (itemtype => item_type,
249: itemkey => item_key,
250: aname => 'REQUESTED_USERNAME',
251: ignore_notfound => false);
252:

Line 267: l_justification := wf_engine.getitemattrtext (

263: 'fnd.plsql.UMXUTILB','invoking propagateuserrole '||
264: 'rolename:'||l_wf_role_name||' username:'||l_user_name);
265: end if;
266:
267: l_justification := wf_engine.getitemattrtext (
268: itemtype => item_type,
269: itemkey => item_key,
270: aname => 'JUSTIFICATION');
271:

Line 275: l_regsvc_disp_name := wf_engine.getitemattrtext (

271:
272: if (l_justification is null) or (l_justification = '') then
273: -- Jusification is null or empty string. In that case, get the default
274: -- justification from the FND Message.
275: l_regsvc_disp_name := wf_engine.getitemattrtext (
276: itemtype => item_type,
277: itemkey => item_key,
278: aname => 'REGSVC_DISP_NAME');
279:

Line 346: l_ame_transaction_type_id := wf_engine.getitemattrtext (

342: 'fnd.plsql.UMXUTILB.checkapprovaldefined.begin','itemkey: '||item_key);
343: end if;
344:
345: if (command = 'RUN') then
346: l_ame_transaction_type_id := wf_engine.getitemattrtext (
347: itemtype => item_type,
348: itemkey => item_key,
349: aname => 'AME_TRANSACTION_TYPE_ID',
350: ignore_notfound => false);

Line 352: l_ame_application_id := wf_engine.getitemattrtext (itemtype => item_type,

348: itemkey => item_key,
349: aname => 'AME_TRANSACTION_TYPE_ID',
350: ignore_notfound => false);
351:
352: l_ame_application_id := wf_engine.getitemattrtext (itemtype => item_type,
353: itemkey => item_key,
354: aname => 'AME_APPLICATION_ID',
355: ignore_notfound => false);
356:

Line 357: l_reg_svc_code := wf_engine.getitemattrtext (itemtype => item_type,

353: itemkey => item_key,
354: aname => 'AME_APPLICATION_ID',
355: ignore_notfound => false);
356:
357: l_reg_svc_code := wf_engine.getitemattrtext (itemtype => item_type,
358: itemkey => item_key,
359: aname => 'REG_SERVICE_CODE',
360: ignore_notfound => false);
361:

Line 362: l_reg_svc_type := wf_engine.getitemattrtext (itemtype => item_type,

358: itemkey => item_key,
359: aname => 'REG_SERVICE_CODE',
360: ignore_notfound => false);
361:
362: l_reg_svc_type := wf_engine.getitemattrtext (itemtype => item_type,
363: itemkey => item_key,
364: aname => 'REG_SERVICE_TYPE',
365: ignore_notfound => false);
366: l_rby_userid_string := wf_engine.getitemattrtext (itemtype => item_type,

Line 366: l_rby_userid_string := wf_engine.getitemattrtext (itemtype => item_type,

362: l_reg_svc_type := wf_engine.getitemattrtext (itemtype => item_type,
363: itemkey => item_key,
364: aname => 'REG_SERVICE_TYPE',
365: ignore_notfound => false);
366: l_rby_userid_string := wf_engine.getitemattrtext (itemtype => item_type,
367: itemkey => item_key,
368: aname => 'REQUESTED_BY_USER_ID',
369: ignore_notfound => false);
370: l_requested_by_user_id := to_number (l_rby_userid_string);

Line 371: l_rfor_userid_string := wf_engine.getitemattrtext (itemtype => item_type,

367: itemkey => item_key,
368: aname => 'REQUESTED_BY_USER_ID',
369: ignore_notfound => false);
370: l_requested_by_user_id := to_number (l_rby_userid_string);
371: l_rfor_userid_string := wf_engine.getitemattrtext (itemtype => item_type,
372: itemkey => item_key,
373: aname => 'REQUESTED_FOR_USER_ID',
374: ignore_notfound => false);
375: l_requested_for_user_id := to_number (l_rfor_userid_string);

Line 406: wf_engine.setItemattrtext (itemtype => item_type,

402: l_ame_transaction_type_id is not null and
403: l_ame_application_id is not null) then
404:
405: resultout := 'COMPLETE:Y';
406: wf_engine.setItemattrtext (itemtype => item_type,
407: itemkey => item_key,
408: aname => 'NOTIFICATION_CONTEXT',
409: avalue => 'APPROVAL_REQUIRED');
410:

Line 455: l_identity_vrfy_reqd := wf_engine.getitemattrtext (itemtype => item_type,

451: 'itemkey: '||item_key);
452: end if;
453:
454: if (command = 'RUN') then
455: l_identity_vrfy_reqd := wf_engine.getitemattrtext (itemtype => item_type,
456: itemkey => item_key,
457: aname => 'IDENTITY_VERIFICATION_REQD',
458: ignore_notfound => true);
459: if (l_identity_vrfy_reqd is not null AND l_identity_vrfy_reqd = 'Y') then

Line 460: wf_engine.setItemattrtext (itemtype => item_type,

456: itemkey => item_key,
457: aname => 'IDENTITY_VERIFICATION_REQD',
458: ignore_notfound => true);
459: if (l_identity_vrfy_reqd is not null AND l_identity_vrfy_reqd = 'Y') then
460: wf_engine.setItemattrtext (itemtype => item_type,
461: itemkey => item_key,
462: aname => 'NOTIFICATION_CONTEXT',
463: avalue => 'IDENTITY_VERIFICATION');
464: -- update the status in the reg table to VERIFYING

Line 520: l_username := wf_engine.getitemattrtext (itemtype => item_type,

516:
517: if (command = 'RUN') then
518:
519: -- First check the user name.
520: l_username := wf_engine.getitemattrtext (itemtype => item_type,
521: itemkey => item_key,
522: aname => 'REQUESTED_USERNAME',
523: ignore_notfound => true);
524:

Line 612: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,

608: **/
609:
610: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
611:
612: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,
613: itemkey => p_item_key,
614: name => 'REGISTRATION_DATA');
615: print_Event_params (p_event => l_event);
616: end if;

Line 619: l_requested_for_user_id := wf_engine.getitemattrtext (

615: print_Event_params (p_event => l_event);
616: end if;
617:
618: l_reg_request_id := To_Number (p_item_key);
619: l_requested_for_user_id := wf_engine.getitemattrtext (
620: itemtype => p_item_type,
621: itemkey => p_item_key,
622: aname => 'REQUESTED_FOR_USER_ID',
623: ignore_notfound => true);

Line 625: l_requested_by_user_id := wf_engine.getitemattrtext (

621: itemkey => p_item_key,
622: aname => 'REQUESTED_FOR_USER_ID',
623: ignore_notfound => true);
624:
625: l_requested_by_user_id := wf_engine.getitemattrtext (
626: itemtype => p_item_type,
627: itemkey => p_item_key,
628: aname => 'REQUESTED_BY_USER_ID',
629: ignore_notfound => false);

Line 631: l_requested_for_party_id := wf_engine.getitemattrtext (

627: itemkey => p_item_key,
628: aname => 'REQUESTED_BY_USER_ID',
629: ignore_notfound => false);
630:
631: l_requested_for_party_id := wf_engine.getitemattrtext (
632: itemtype => p_item_type,
633: itemkey => p_item_key,
634: aname => 'PERSON_PARTY_ID',
635: ignore_notfound => true);

Line 637: l_requested_username := wf_engine.getitemattrtext (

633: itemkey => p_item_key,
634: aname => 'PERSON_PARTY_ID',
635: ignore_notfound => true);
636:
637: l_requested_username := wf_engine.getitemattrtext (
638: itemtype => p_item_type,
639: itemkey => p_item_key,
640: aname => 'REQUESTED_USERNAME',
641: ignore_notfound => false);

Line 643: l_wf_role_name := wf_engine.getitemattrtext (itemtype => p_item_type,

639: itemkey => p_item_key,
640: aname => 'REQUESTED_USERNAME',
641: ignore_notfound => false);
642:
643: l_wf_role_name := wf_engine.getitemattrtext (itemtype => p_item_type,
644: itemkey => p_item_key,
645: aname => 'WF_ROLE_NAME',
646: ignore_notfound => true);
647: l_reg_service_code := wf_engine.getitemattrtext (

Line 647: l_reg_service_code := wf_engine.getitemattrtext (

643: l_wf_role_name := wf_engine.getitemattrtext (itemtype => p_item_type,
644: itemkey => p_item_key,
645: aname => 'WF_ROLE_NAME',
646: ignore_notfound => true);
647: l_reg_service_code := wf_engine.getitemattrtext (
648: itemtype => p_item_type,
649: itemkey => p_item_key,
650: aname => 'REG_SERVICE_CODE',
651: ignore_notfound => false);

Line 652: l_reg_service_type := wf_engine.getitemattrtext (

648: itemtype => p_item_type,
649: itemkey => p_item_key,
650: aname => 'REG_SERVICE_CODE',
651: ignore_notfound => false);
652: l_reg_service_type := wf_engine.getitemattrtext (
653: itemtype => p_item_type,
654: itemkey => p_item_key,
655: aname => 'REG_SERVICE_TYPE',
656: ignore_notfound => false);

Line 657: l_ame_application_id := wf_engine.getitemattrtext (

653: itemtype => p_item_type,
654: itemkey => p_item_key,
655: aname => 'REG_SERVICE_TYPE',
656: ignore_notfound => false);
657: l_ame_application_id := wf_engine.getitemattrtext (
658: itemtype => p_item_type,
659: itemkey => p_item_key,
660: aname => 'AME_APPLICATION_ID',
661: ignore_notfound => true);

Line 663: l_ame_transaction_type_id := wf_engine.getitemattrtext (

659: itemkey => p_item_key,
660: aname => 'AME_APPLICATION_ID',
661: ignore_notfound => true);
662:
663: l_ame_transaction_type_id := wf_engine.getitemattrtext (
664: itemtype => p_item_type,
665: itemkey => p_item_key,
666: aname => 'AME_TRANSACTION_TYPE_ID',
667: ignore_notfound => true);

Line 670: l_justification := wf_engine.getitemattrtext (

666: aname => 'AME_TRANSACTION_TYPE_ID',
667: ignore_notfound => true);
668:
669: l_request_status_code := 'PENDING';
670: l_justification := wf_engine.getitemattrtext (
671: itemtype => p_item_type,
672: itemkey => p_item_key,
673: aname => 'JUSTIFICATION',
674: ignore_notfound => true);

Line 677: wf_engine.getitemattrtext (itemtype => p_item_type,

673: aname => 'JUSTIFICATION',
674: ignore_notfound => true);
675:
676: l_requested_start_date := fnd_date.canonical_to_date (
677: wf_engine.getitemattrtext (itemtype => p_item_type,
678: itemkey => p_item_key,
679: aname => 'REQUESTED_START_DATE',
680: ignore_notfound => false));
681:

Line 683: wf_engine.getitemattrtext (itemtype => p_item_type,

679: aname => 'REQUESTED_START_DATE',
680: ignore_notfound => false));
681:
682: l_requested_end_date := fnd_date.canonical_to_date (
683: wf_engine.getitemattrtext (itemtype => p_item_type,
684: itemkey => p_item_key,
685: aname => 'REQUESTED_END_DATE',
686: ignore_notfound => false));
687:

Line 757: l_username := wf_engine.getitemattrtext (itemtype => p_item_type,

753: 'itemkey: '||p_item_key);
754: end if;
755:
756: if (p_command = 'RUN') then
757: l_username := wf_engine.getitemattrtext (itemtype => p_item_type,
758: itemkey => p_item_key,
759: aname => 'REQUESTED_USERNAME',
760: ignore_notfound => true);
761:

Line 762: l_temp_party_id := wf_engine.getitemattrtext (itemtype => p_item_type,

758: itemkey => p_item_key,
759: aname => 'REQUESTED_USERNAME',
760: ignore_notfound => true);
761:
762: l_temp_party_id := wf_engine.getitemattrtext (itemtype => p_item_type,
763: itemkey => p_item_key,
764: aname => 'PERSON_PARTY_ID',
765: ignore_notfound => true);
766: if l_temp_party_id is not null then

Line 770: l_password := wf_engine.getitemattrtext (itemtype => p_item_type,

766: if l_temp_party_id is not null then
767: l_person_party_id := to_number (l_temp_party_id);
768: end if;
769:
770: l_password := wf_engine.getitemattrtext (itemtype => p_item_type,
771: itemkey => p_item_key,
772: aname => 'PASSWORD',
773: ignore_notfound => true);
774:

Line 775: l_expire_password := wf_engine.getitemattrtext (itemtype => p_item_type,

771: itemkey => p_item_key,
772: aname => 'PASSWORD',
773: ignore_notfound => true);
774:
775: l_expire_password := wf_engine.getitemattrtext (itemtype => p_item_type,
776: itemkey => p_item_key,
777: aname => 'EXPIRE_PASSWORD',
778: ignore_notfound => true);
779:

Line 780: l_email_address := wf_engine.getitemattrtext (itemtype => p_item_type,

776: itemkey => p_item_key,
777: aname => 'EXPIRE_PASSWORD',
778: ignore_notfound => true);
779:
780: l_email_address := wf_engine.getitemattrtext (itemtype => p_item_type,
781: itemkey => p_item_key,
782: aname => 'EMAIL_ADDRESS',
783: ignore_notfound => false);
784:

Line 785: l_fax := wf_engine.getitemattrtext (itemtype => p_item_type,

781: itemkey => p_item_key,
782: aname => 'EMAIL_ADDRESS',
783: ignore_notfound => false);
784:
785: l_fax := wf_engine.getitemattrtext (itemtype => p_item_type,
786: itemkey => p_item_key,
787: aname => 'FAX',
788: ignore_notfound => false);
789:

Line 833: wf_engine.setitemattrtext (itemtype => p_item_type,

829: if (l_return_status = fnd_user_pkg.user_synched) then
830: -- Because the account will be synched, we no longer needs to keep
831: -- the user password in apps. Password will be managed "EXTERNALLY".
832: l_password := null;
833: wf_engine.setitemattrtext (itemtype => p_item_type,
834: itemkey => p_item_key,
835: aname => 'PASSWORD',
836: avalue => l_password);
837: add_param_to_event (p_item_type, p_item_key, 'DISPLAY_PASSWORD', l_password);

Line 864: wf_engine.setitemattrtext (itemtype => p_item_type,

860: end if;
861:
862: if (l_user_id is not null) then
863: l_temp_user_id := to_char (l_user_id);
864: wf_engine.setitemattrtext (itemtype => p_item_type,
865: itemkey =>p_item_key,
866: aname => 'REQUESTED_FOR_USER_ID',
867: avalue => l_temp_user_id);
868:

Line 919: l_person_party_id := wf_engine.getitemattrtext (itemtype => p_item_type,

915: end if;
916:
917:
918: if (p_command = 'RUN') then
919: l_person_party_id := wf_engine.getitemattrtext (itemtype => p_item_type,
920: itemkey => p_item_key,
921: aname => 'PERSON_PARTY_ID',
922: ignore_notfound => false);
923:

Line 924: l_user_name := wf_engine.getitemattrtext (itemtype => p_item_type,

920: itemkey => p_item_key,
921: aname => 'PERSON_PARTY_ID',
922: ignore_notfound => false);
923:
924: l_user_name := wf_engine.getitemattrtext (itemtype => p_item_type,
925: itemkey => p_item_key,
926: aname => 'REQUESTED_USERNAME',
927: ignore_notfound => false);
928:

Line 930: wf_engine.getitemattrtext (itemtype => p_item_type,

926: aname => 'REQUESTED_USERNAME',
927: ignore_notfound => false);
928:
929: l_start_date := fnd_date.canonical_to_date (
930: wf_engine.getitemattrtext (itemtype => p_item_type,
931: itemkey => p_item_key,
932: aname => 'REQUESTED_START_DATE',
933: ignore_notfound => false));
934:

Line 936: wf_engine.getitemattrtext (itemtype => p_item_type,

932: aname => 'REQUESTED_START_DATE',
933: ignore_notfound => false));
934:
935: l_end_date := fnd_date.canonical_to_date (
936: wf_engine.getitemattrtext (itemtype => p_item_type,
937: itemkey => p_item_key,
938: aname => 'REQUESTED_END_DATE',
939: ignore_notfound => false));
940: if (l_person_party_id is not null) then

Line 1002: l_username := wf_engine.getitemattrtext (itemtype => p_item_type,

998: 'itemkey: '||p_item_key);
999: end if;
1000:
1001: if (p_command = 'RUN') then
1002: l_username := wf_engine.getitemattrtext (itemtype => p_item_type,
1003: itemkey => p_item_key,
1004: aname => 'REQUESTED_USERNAME',
1005: ignore_notfound => false);
1006:

Line 1007: l_userid := wf_engine.getitemattrtext (itemtype => p_item_type,

1003: itemkey => p_item_key,
1004: aname => 'REQUESTED_USERNAME',
1005: ignore_notfound => false);
1006:
1007: l_userid := wf_engine.getitemattrtext (itemtype => p_item_type,
1008: itemkey => p_item_key,
1009: aname => 'REQUESTED_FOR_USER_ID',
1010: ignore_notfound => false);
1011:

Line 1059: l_event_type := wf_engine.getActivityAttrText (itemtype => p_item_type,

1055: end if;
1056:
1057: if (p_command = 'RUN') then
1058:
1059: l_event_type := wf_engine.getActivityAttrText (itemtype => p_item_type,
1060: itemkey => p_item_key,
1061: actid => p_activity_id,
1062: aname => 'EVENT_TYPE',
1063: ignore_notfound => true);

Line 1078: wf_engine.setitemattrtext (itemtype => p_item_type,

1074: select UMX_REG_REQUESTS_S.nextval into l_temp_event_key from dual;
1075: end if;
1076:
1077: l_event_key := to_char (l_temp_event_key);
1078: wf_engine.setitemattrtext (itemtype => p_item_type,
1079: itemkey =>p_item_key,
1080: aname => 'EVENT_KEY_SEQUENCE',
1081: avalue => l_event_key);
1082: p_resultout := 'COMPLETE';

Line 1129: l_password := wf_engine.getitemattrtext (itemtype => item_type,

1125: 'itemkey: '||item_key);
1126: end if;
1127:
1128: if (command = 'RUN') then
1129: l_password := wf_engine.getitemattrtext (itemtype => item_type,
1130: itemkey => item_key,
1131: aname => 'PASSWORD',
1132: ignore_notfound => false);
1133:

Line 1136: wf_engine.setitemattrtext (itemtype => item_type,

1132: ignore_notfound => false);
1133:
1134: if (l_password is null) then
1135: resultout := 'COMPLETE:Y';
1136: wf_engine.setitemattrtext (itemtype => item_type,
1137: itemkey => item_key,
1138: aname => 'EXPIRE_PASSWORD',
1139: avalue => 'Y');
1140: else

Line 1200: wf_engine.setitemattrtext (itemtype => l_parent_itemtype,

1196: p_event.addParametertoList (p_attr_name, p_attr_value);
1197: -- modify this to check if the attr has been defined earlier
1198: --if not then add and set
1199: begin
1200: wf_engine.setitemattrtext (itemtype => l_parent_itemtype,
1201: itemkey => l_parent_itemkey,
1202: aname => p_attr_name,
1203: avalue => p_attr_value);
1204: EXCEPTION

Line 1206: wf_engine.additemattr (itemtype => l_parent_itemtype,

1202: aname => p_attr_name,
1203: avalue => p_attr_value);
1204: EXCEPTION
1205: WHEN OTHERS THEN
1206: wf_engine.additemattr (itemtype => l_parent_itemtype,
1207: itemkey => l_parent_itemkey,
1208: aname => p_attr_name,
1209: text_value => p_attr_value);
1210: end;

Line 1217: wf_engine.setitemattrevent (itemtype => l_parent_itemtype,

1213:
1214:
1215:
1216: -- set the event object into workflow
1217: wf_engine.setitemattrevent (itemtype => l_parent_itemtype,
1218: itemkey => l_parent_itemkey,
1219: name => 'REGISTRATION_DATA',
1220: event => p_event);
1221:

Line 1288: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,

1284: if (p_command = 'RUN') then
1285:
1286: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1287:
1288: l_event := wf_engine.getitemattrevent (itemtype => p_item_type,
1289: itemkey => p_item_key,
1290: name => 'REGISTRATION_DATA');
1291: print_Event_params (p_event => l_event);
1292: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

Line 1309: l_reg_request.requested_for_user_id := wf_engine.getitemattrtext (

1305:
1306: close getRegRequest;
1307:
1308: l_reg_request.reg_request_id := p_item_key;
1309: l_reg_request.requested_for_user_id := wf_engine.getitemattrtext (
1310: itemtype => p_item_type,
1311: itemkey => p_item_key,
1312: aname => 'REQUESTED_FOR_USER_ID',
1313: ignore_notfound => true);

Line 1315: l_reg_request.requested_by_userid := wf_engine.getitemattrtext (

1311: itemkey => p_item_key,
1312: aname => 'REQUESTED_FOR_USER_ID',
1313: ignore_notfound => true);
1314:
1315: l_reg_request.requested_by_userid := wf_engine.getitemattrtext (
1316: itemtype => p_item_type,
1317: itemkey => p_item_key,
1318: aname => 'REQUESTED_BY_USER_ID',
1319: ignore_notfound => false);

Line 1321: l_reg_request.requested_for_party_id := wf_engine.getitemattrtext (

1317: itemkey => p_item_key,
1318: aname => 'REQUESTED_BY_USER_ID',
1319: ignore_notfound => false);
1320:
1321: l_reg_request.requested_for_party_id := wf_engine.getitemattrtext (
1322: itemtype => p_item_type,
1323: itemkey => p_item_key,
1324: aname => 'PERSON_PARTY_ID',
1325: ignore_notfound => true);

Line 1327: l_reg_request.requested_username := wf_engine.getitemattrtext (

1323: itemkey => p_item_key,
1324: aname => 'PERSON_PARTY_ID',
1325: ignore_notfound => true);
1326:
1327: l_reg_request.requested_username := wf_engine.getitemattrtext (
1328: itemtype => p_item_type,
1329: itemkey => p_item_key,
1330: aname => 'REQUESTED_USERNAME',
1331: ignore_notfound => false);

Line 1333: l_reg_request.wf_role_name := wf_engine.getitemattrtext (itemtype => p_item_type,

1329: itemkey => p_item_key,
1330: aname => 'REQUESTED_USERNAME',
1331: ignore_notfound => false);
1332:
1333: l_reg_request.wf_role_name := wf_engine.getitemattrtext (itemtype => p_item_type,
1334: itemkey => p_item_key,
1335: aname => 'WF_ROLE_NAME',
1336: ignore_notfound => true);
1337: l_reg_request.reg_service_code := wf_engine.getitemattrtext (

Line 1337: l_reg_request.reg_service_code := wf_engine.getitemattrtext (

1333: l_reg_request.wf_role_name := wf_engine.getitemattrtext (itemtype => p_item_type,
1334: itemkey => p_item_key,
1335: aname => 'WF_ROLE_NAME',
1336: ignore_notfound => true);
1337: l_reg_request.reg_service_code := wf_engine.getitemattrtext (
1338: itemtype => p_item_type,
1339: itemkey => p_item_key,
1340: aname => 'REG_SERVICE_CODE',
1341: ignore_notfound => false);

Line 1342: l_reg_request.reg_service_type := wf_engine.getitemattrtext (

1338: itemtype => p_item_type,
1339: itemkey => p_item_key,
1340: aname => 'REG_SERVICE_CODE',
1341: ignore_notfound => false);
1342: l_reg_request.reg_service_type := wf_engine.getitemattrtext (
1343: itemtype => p_item_type,
1344: itemkey => p_item_key,
1345: aname => 'REG_SERVICE_TYPE',
1346: ignore_notfound => false);

Line 1347: l_reg_request.ame_application_id := wf_engine.getitemattrtext (

1343: itemtype => p_item_type,
1344: itemkey => p_item_key,
1345: aname => 'REG_SERVICE_TYPE',
1346: ignore_notfound => false);
1347: l_reg_request.ame_application_id := wf_engine.getitemattrtext (
1348: itemtype => p_item_type,
1349: itemkey => p_item_key,
1350: aname => 'AME_APPLICATION_ID',
1351: ignore_notfound => true);

Line 1353: l_reg_request.ame_transaction_type_id := wf_engine.getitemattrtext (

1349: itemkey => p_item_key,
1350: aname => 'AME_APPLICATION_ID',
1351: ignore_notfound => true);
1352:
1353: l_reg_request.ame_transaction_type_id := wf_engine.getitemattrtext (
1354: itemtype => p_item_type,
1355: itemkey => p_item_key,
1356: aname => 'AME_TRANSACTION_TYPE_ID',
1357: ignore_notfound => true);

Line 1359: l_reg_request.justification := wf_engine.getitemattrtext (

1355: itemkey => p_item_key,
1356: aname => 'AME_TRANSACTION_TYPE_ID',
1357: ignore_notfound => true);
1358:
1359: l_reg_request.justification := wf_engine.getitemattrtext (
1360: itemtype => p_item_type,
1361: itemkey => p_item_key,
1362: aname => 'JUSTIFICATION',
1363: ignore_notfound => true);

Line 1366: wf_engine.getitemattrtext (itemtype => p_item_type,

1362: aname => 'JUSTIFICATION',
1363: ignore_notfound => true);
1364:
1365: l_reg_request.requested_start_date := fnd_date.canonical_to_date (
1366: wf_engine.getitemattrtext (itemtype => p_item_type,
1367: itemkey => p_item_key,
1368: aname => 'REQUESTED_START_DATE',
1369: ignore_notfound => false));
1370:

Line 1372: wf_engine.getitemattrtext (itemtype => p_item_type,

1368: aname => 'REQUESTED_START_DATE',
1369: ignore_notfound => false));
1370:
1371: l_reg_request.requested_end_date := fnd_date.canonical_to_date (
1372: wf_engine.getitemattrtext (itemtype => p_item_type,
1373: itemkey => p_item_key,
1374: aname => 'REQUESTED_END_DATE',
1375: ignore_notfound => false));
1376:

Line 1421: l_person_party_id := wf_engine.getitemattrtext (itemtype => item_type,

1417: 'itemkey: '||item_key);
1418: end if;
1419:
1420: if (command = 'RUN') then
1421: l_person_party_id := wf_engine.getitemattrtext (itemtype => item_type,
1422: itemkey => item_key,
1423: aname => 'PERSON_PARTY_ID',
1424: ignore_notfound => false);
1425:

Line 1428: l_event := wf_engine.getitemattrevent (itemtype => item_type,

1424: ignore_notfound => false);
1425:
1426: if (l_person_party_id is null) then
1427:
1428: l_event := wf_engine.getitemattrevent (itemtype => item_type,
1429: itemkey => item_key,
1430: name => 'REGISTRATION_DATA');
1431: l_parameter_list := l_event.getParameterlist ();
1432:

Line 1474: l_notification_context := wf_engine.getitemattrtext (itemtype => item_type,

1470: l_notification_event wf_events.name%type;
1471: BEGIN
1472:
1473: if (command = 'RUN') then
1474: l_notification_context := wf_engine.getitemattrtext (itemtype => item_type,
1475: itemkey => item_key,
1476: aname => 'NOTIFICATION_CONTEXT',
1477: ignore_notfound => false);
1478: l_notification_event := wf_engine.getitemattrtext (itemtype => item_type,

Line 1478: l_notification_event := wf_engine.getitemattrtext (itemtype => item_type,

1474: l_notification_context := wf_engine.getitemattrtext (itemtype => item_type,
1475: itemkey => item_key,
1476: aname => 'NOTIFICATION_CONTEXT',
1477: ignore_notfound => false);
1478: l_notification_event := wf_engine.getitemattrtext (itemtype => item_type,
1479: itemkey => item_key,
1480: aname => 'WF_NOTIFICATION_EVENT',
1481: ignore_notfound => false);
1482:

Line 1483: l_event := wf_engine.getitemattrevent (itemtype => item_type,

1479: itemkey => item_key,
1480: aname => 'WF_NOTIFICATION_EVENT',
1481: ignore_notfound => false);
1482:
1483: l_event := wf_engine.getitemattrevent (itemtype => item_type,
1484: itemkey => item_key,
1485: name => 'REGISTRATION_DATA');
1486:
1487: l_parameter_list := l_event.getParameterList ();

Line 1552: l_reg_svc_type := wf_engine.getItemattrtext (

1548: end if;
1549:
1550: -- if additional access workflow then we dont have to create adhoc role
1551: -- as it is already a system user
1552: l_reg_svc_type := wf_engine.getItemattrtext (
1553: itemtype => item_type,
1554: itemkey => item_key,
1555: aname => 'REG_SERVICE_TYPE');
1556:

Line 1561: l_ad_hoc_role := wf_engine.getItemattrtext (

1557: if ((l_reg_svc_type <> 'ADDITIONAL_ACCESS') and
1558: (l_reg_svc_type <> 'ADMIN_ADDITIONAL_ACCESS')) then
1559:
1560: --check if the adhoc user has already been created then just reactivate
1561: l_ad_hoc_role := wf_engine.getItemattrtext (
1562: itemtype => item_type,
1563: itemkey => item_key,
1564: aname => 'USER_ROLE_NAME');
1565:

Line 1568: l_person_first_name := wf_engine.getItemattrtext (

1564: aname => 'USER_ROLE_NAME');
1565:
1566: if (l_ad_hoc_role is null) then
1567:
1568: l_person_first_name := wf_engine.getItemattrtext (
1569: itemtype => item_type,
1570: itemkey => item_key,
1571: aname => 'FIRST_NAME');
1572:

Line 1573: l_person_middle_name := wf_engine.getItemattrtext (

1569: itemtype => item_type,
1570: itemkey => item_key,
1571: aname => 'FIRST_NAME');
1572:
1573: l_person_middle_name := wf_engine.getItemattrtext (
1574: itemtype => item_type,
1575: itemkey => item_key,
1576: aname => 'MIDDLE_NAME');
1577:

Line 1578: l_person_last_name := wf_engine.getItemattrtext (

1574: itemtype => item_type,
1575: itemkey => item_key,
1576: aname => 'MIDDLE_NAME');
1577:
1578: l_person_last_name := wf_engine.getItemattrtext (
1579: itemtype => item_type,
1580: itemkey => item_key,
1581: aname => 'LAST_NAME');
1582:

Line 1583: l_prefix := wf_engine.getitemattrtext (

1579: itemtype => item_type,
1580: itemkey => item_key,
1581: aname => 'LAST_NAME');
1582:
1583: l_prefix := wf_engine.getitemattrtext (
1584: itemtype => item_type,
1585: itemkey => item_key,
1586: aname => 'PRE_NAME_ADJUNCT');
1587:

Line 1588: l_suffix := wf_engine.getitemattrtext (

1584: itemtype => item_type,
1585: itemkey => item_key,
1586: aname => 'PRE_NAME_ADJUNCT');
1587:
1588: l_suffix := wf_engine.getitemattrtext (
1589: itemtype => item_type,
1590: itemkey => item_key,
1591: aname => 'PERSON_SUFFIX');
1592:

Line 1635: wf_engine.setItemattrtext (

1631: if (l_formatted_name is null) then
1632: l_formatted_name := l_person_first_name || ' ' || l_person_last_name;
1633: end if;
1634:
1635: wf_engine.setItemattrtext (
1636: itemtype => item_type,
1637: itemkey => item_key,
1638: aname => 'FORMATED_NAME',
1639: avalue => l_formatted_name);

Line 1646: l_email_address := wf_engine.getItemattrtext (

1642: p_item_key => item_key,
1643: p_attr_name => 'FORMATED_NAME',
1644: p_attr_value => l_formatted_name);
1645:
1646: l_email_address := wf_engine.getItemattrtext (
1647: itemtype => item_type,
1648: itemkey => item_key,
1649: aname => 'EMAIL_ADDRESS');
1650:

Line 1679: l_requested_for_user_id := wf_engine.getItemattrtext (

1675: -- this regsvctype is additional accessrequest notification
1676: -- set USER_ROLE_NAME as the logged in USER_NAME and formating
1677: -- is taken care in UMXNTFSB.pls
1678:
1679: l_requested_for_user_id := wf_engine.getItemattrtext (
1680: itemtype => item_type,
1681: itemkey => item_key,
1682: aname => 'REQUESTED_FOR_USER_ID');
1683:

Line 1695: wf_engine.setItemattrtext (

1691:
1692: end if;
1693: end if;-- end for additional_access loop
1694:
1695: wf_engine.setItemattrtext (
1696: itemtype => item_type,
1697: itemkey => item_key,
1698: aname => 'USER_ROLE_NAME',
1699: avalue => l_ad_hoc_role);

Line 1755: l_reg_svc_type := wf_engine.getItemattrtext (

1751: end if;
1752:
1753: -- There is no need to release adhoc user in additional_access request
1754: -- since there is no adhoc user created.
1755: l_reg_svc_type := wf_engine.getItemattrtext (
1756: itemtype => item_type,
1757: itemkey => item_key,
1758: aname => 'REG_SERVICE_TYPE');
1759:

Line 1763: l_adhoc_role_name := wf_engine.getItemattrtext (

1759:
1760: if ((l_reg_svc_type <> 'ADDITIONAL_ACCESS') and
1761: (l_reg_svc_type <> 'ADMIN_ADDITIONAL_ACCESS')) then
1762:
1763: l_adhoc_role_name := wf_engine.getItemattrtext (
1764: itemtype => item_type,
1765: itemkey => item_key,
1766: aname => 'USER_ROLE_NAME');
1767:

Line 1845: l_username := wf_engine.getitemattrtext (itemtype => p_item_type,

1841: 'itemkey: '||p_item_key);
1842: end if;
1843:
1844: if (p_command = 'RUN') then
1845: l_username := wf_engine.getitemattrtext (itemtype => p_item_type,
1846: itemkey => p_item_key,
1847: aname => 'REQUESTED_USERNAME',
1848: ignore_notfound => false);
1849:

Line 1850: l_userid := wf_engine.getitemattrtext (itemtype => p_item_type,

1846: itemkey => p_item_key,
1847: aname => 'REQUESTED_USERNAME',
1848: ignore_notfound => false);
1849:
1850: l_userid := wf_engine.getitemattrtext (itemtype => p_item_type,
1851: itemkey => p_item_key,
1852: aname => 'REQUESTED_FOR_USER_ID',
1853: ignore_notfound => false);
1854:

Line 1900: l_userid := wf_engine.getitemattrtext (itemtype => p_item_type,

1896: end if;
1897:
1898: if (p_command = 'RUN') then
1899:
1900: l_userid := wf_engine.getitemattrtext (itemtype => p_item_type,
1901: itemkey => p_item_key,
1902: aname => 'REQUESTED_FOR_USER_ID',
1903: ignore_notfound => false);
1904:

Line 1947: l_reg_svc_type := wf_engine.getitemattrtext (itemtype => item_type,

1943: l_reg_svc_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%TYPE;
1944:
1945: begin
1946:
1947: l_reg_svc_type := wf_engine.getitemattrtext (itemtype => item_type,
1948: itemkey => item_key,
1949: aname => 'REG_SERVICE_TYPE');
1950:
1951: l_custom_event_context := wf_engine.getActivityAttrText (

Line 1951: l_custom_event_context := wf_engine.getActivityAttrText (

1947: l_reg_svc_type := wf_engine.getitemattrtext (itemtype => item_type,
1948: itemkey => item_key,
1949: aname => 'REG_SERVICE_TYPE');
1950:
1951: l_custom_event_context := wf_engine.getActivityAttrText (
1952: itemtype => item_type,
1953: itemkey => item_key,
1954: actid => activity_id,
1955: aname => 'UMX_CUSTOM_EVENT_CONTEXT');

Line 1965: l_custom_event := wf_engine.getitemattrtext (itemtype => item_type,

1961: -- If the request is ADMIN_CREATION or SELF_SERVICE, we only have to raise
1962: -- the event during before and after the account is created. We don't have
1963: -- to raise the event when it is role approved.
1964:
1965: l_custom_event := wf_engine.getitemattrtext (itemtype => item_type,
1966: itemkey => item_key,
1967: aname => 'CUSTOM_EVENT_NAME');
1968:
1969: if (l_custom_event is not null) then

Line 1979: l_event := wf_engine.getitemattrevent (itemtype => item_type,

1975: p_attr_value => l_custom_event_context);
1976:
1977: select UMX_EVENTS_S.nextval into l_event_key from dual;
1978:
1979: l_event := wf_engine.getitemattrevent (itemtype => item_type,
1980: itemkey => item_key,
1981: name => 'REGISTRATION_DATA');
1982:
1983: l_parameter_list := l_event.getParameterlist ();

Line 2050: l_requested_for_user_id := wf_engine.getitemattrtext (

2046: 'fnd.plsql.UMXUTILB.ICM_VIOLATION_CHECK',
2047: 'ICM is installed.');
2048: end if;
2049:
2050: l_requested_for_user_id := wf_engine.getitemattrtext (
2051: itemtype => item_type,
2052: itemkey => item_key,
2053: aname => 'REQUESTED_FOR_USER_ID',
2054: ignore_notfound => false);

Line 2056: l_wf_role_name := wf_engine.getitemattrtext (

2052: itemkey => item_key,
2053: aname => 'REQUESTED_FOR_USER_ID',
2054: ignore_notfound => false);
2055:
2056: l_wf_role_name := wf_engine.getitemattrtext (
2057: itemtype => item_type,
2058: itemkey => item_key,
2059: aname => 'WF_ROLE_NAME',
2060: ignore_notfound => false);

Line 2109: wf_engine.setItemattrtext (itemtype => item_type,

2105: p_item_key => item_key,
2106: p_attr_name => 'ICM_VIOLATION',
2107: p_attr_value => l_has_violations);
2108:
2109: wf_engine.setItemattrtext (itemtype => item_type,
2110: itemkey => item_key,
2111: aname => 'ICM_VIOLATION',
2112: avalue => l_has_violations);
2113:

Line 2121: wf_engine.setItemattrtext (itemtype => item_type,

2117: p_item_key => item_key,
2118: p_attr_name => 'ICM_DETAIL_REGION',
2119: p_attr_value => l_icm_region);
2120:
2121: wf_engine.setItemattrtext (itemtype => item_type,
2122: itemkey => item_key,
2123: aname => 'ICM_DETAIL_REGION',
2124: avalue => l_icm_region);
2125: end if;

Line 2176: l_person_party_id := wf_engine.getitemattrtext (itemtype => item_type,

2172: 'itemkey: '||item_key);
2173: end if;
2174:
2175: if (command = 'RUN') then
2176: l_person_party_id := wf_engine.getitemattrtext (itemtype => item_type,
2177: itemkey => item_key,
2178: aname => 'PERSON_PARTY_ID',
2179: ignore_notfound => true);
2180:

Line 2188: wf_engine.setitemattrtext (itemtype => item_type,

2184:
2185: if (l_suggested_username is null) then
2186: resultout := 'COMPLETE:F';
2187: else
2188: wf_engine.setitemattrtext (itemtype => item_type,
2189: itemkey =>item_key,
2190: aname => 'REQUESTED_USERNAME',
2191: avalue => l_suggested_username);
2192: add_param_to_event (p_item_type => item_type,

Line 2241: l_username := wf_engine.getitemattrtext (itemtype => item_type,

2237: 'itemkey: '||item_key);
2238: end if;
2239:
2240: if (command = 'RUN') then
2241: l_username := wf_engine.getitemattrtext (itemtype => item_type,
2242: itemkey => item_key,
2243: aname => 'REQUESTED_USERNAME',
2244: ignore_notfound => true);
2245: