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

Line 278: wf_engine.CreateProcess( itemtype => l_item_type

274: p_return_code := INVALID_ACTION;
275: return;
276: End If;
277: l_item_key := get_unique_id;
278: wf_engine.CreateProcess( itemtype => l_item_type
279: ,itemkey => l_item_key
280: ,process => 'GL_CIT_PROCESS' );
281: commit;
282: diagn_msg('Created workflow item key = '||to_char(l_item_key));

Line 312: wf_engine.StartProcess( itemtype => l_item_type,

308: p_post_request_id);
309: commit;
310: -- p_return_code := NOTIFICATION_PROCESS_STARTED ;
311: diagn_msg('Starting CIT Workflow Process');
312: wf_engine.StartProcess( itemtype => l_item_type,
313: itemkey => l_item_key );
314: commit;
315: diagn_msg('After Starting CIT Workflow Process');
316: Return;

Line 360: wf_engine.SetItemOwner( itemtype => l_item_type,

356: WHERE user_id = l_user_id;
357: l_monitor_url VARCHAR2(500);
358: Begin
359: --+ Set the process owner
360: wf_engine.SetItemOwner( itemtype => l_item_type,
361: itemkey => l_item_key,
362: owner => l_user_name );
363: wf_engine.SetItemUserKey( itemtype => l_item_type,
364: itemkey => l_item_key,

Line 363: wf_engine.SetItemUserKey( itemtype => l_item_type,

359: --+ Set the process owner
360: wf_engine.SetItemOwner( itemtype => l_item_type,
361: itemkey => l_item_key,
362: owner => l_user_name );
363: wf_engine.SetItemUserKey( itemtype => l_item_type,
364: itemkey => l_item_key,
365: userkey => to_char(l_request_id)||'-'||to_char(l_item_key) );
366: diagn_msg('Request ID = '||l_request_id);
367: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

Line 367: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

363: wf_engine.SetItemUserKey( itemtype => l_item_type,
364: itemkey => l_item_key,
365: userkey => to_char(l_request_id)||'-'||to_char(l_item_key) );
366: diagn_msg('Request ID = '||l_request_id);
367: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
368: itemkey => l_item_key,
369: aname => 'ITEM_KEY',
370: avalue => l_item_key );
371: wf_engine.SetItemAttrText(itemtype => l_item_type,

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

367: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
368: itemkey => l_item_key,
369: aname => 'ITEM_KEY',
370: avalue => l_item_key );
371: wf_engine.SetItemAttrText(itemtype => l_item_type,
372: itemkey => l_item_key,
373: aname => 'APPLICATION_NAME',
374: avalue => l_application_name );
375: wf_engine.SetItemAttrText(itemtype => l_item_type,

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

371: wf_engine.SetItemAttrText(itemtype => l_item_type,
372: itemkey => l_item_key,
373: aname => 'APPLICATION_NAME',
374: avalue => l_application_name );
375: wf_engine.SetItemAttrText(itemtype => l_item_type,
376: itemkey => l_item_key,
377: aname => 'RESPONSIBILITY_NAME',
378: avalue => l_responsibility_name );
379: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 379: wf_engine.SetItemAttrText(itemtype => l_item_type,

375: wf_engine.SetItemAttrText(itemtype => l_item_type,
376: itemkey => l_item_key,
377: aname => 'RESPONSIBILITY_NAME',
378: avalue => l_responsibility_name );
379: wf_engine.SetItemAttrText(itemtype => l_item_type,
380: itemkey => l_item_key,
381: aname => 'USER_NAME',
382: avalue => l_user_name );
383: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 383: wf_engine.SetItemAttrText(itemtype => l_item_type,

379: wf_engine.SetItemAttrText(itemtype => l_item_type,
380: itemkey => l_item_key,
381: aname => 'USER_NAME',
382: avalue => l_user_name );
383: wf_engine.SetItemAttrText(itemtype => l_item_type,
384: itemkey => l_item_key,
385: aname => 'SOURCE_DATABASE_NAME',
386: avalue => l_source_database_name );
387: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 387: wf_engine.SetItemAttrText(itemtype => l_item_type,

383: wf_engine.SetItemAttrText(itemtype => l_item_type,
384: itemkey => l_item_key,
385: aname => 'SOURCE_DATABASE_NAME',
386: avalue => l_source_database_name );
387: wf_engine.SetItemAttrText(itemtype => l_item_type,
388: itemkey => l_item_key,
389: aname => 'TARGET_DATABASE_NAME',
390: avalue => l_target_database_name );
391: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 391: wf_engine.SetItemAttrText(itemtype => l_item_type,

387: wf_engine.SetItemAttrText(itemtype => l_item_type,
388: itemkey => l_item_key,
389: aname => 'TARGET_DATABASE_NAME',
390: avalue => l_target_database_name );
391: wf_engine.SetItemAttrText(itemtype => l_item_type,
392: itemkey => l_item_key,
393: aname => 'SOURCE_LEDGER_NAME',
394: avalue => l_source_ledger_name );
395: diagn_msg('Source ledger Name = '||l_source_ledger_name);

Line 396: wf_engine.SetItemAttrText(itemtype => l_item_type,

392: itemkey => l_item_key,
393: aname => 'SOURCE_LEDGER_NAME',
394: avalue => l_source_ledger_name );
395: diagn_msg('Source ledger Name = '||l_source_ledger_name);
396: wf_engine.SetItemAttrText(itemtype => l_item_type,
397: itemkey => l_item_key,
398: aname => 'TARGET_LEDGER_NAME',
399: avalue => l_target_ledger_name );
400: diagn_msg('Target ledger Name = '||l_target_ledger_name);

Line 401: wf_engine.SetItemAttrText(itemtype => l_item_type,

397: itemkey => l_item_key,
398: aname => 'TARGET_LEDGER_NAME',
399: avalue => l_target_ledger_name );
400: diagn_msg('Target ledger Name = '||l_target_ledger_name);
401: wf_engine.SetItemAttrText(itemtype => l_item_type,
402: itemkey => l_item_key,
403: aname => 'JOURNAL_SOURCE_NAME',
404: avalue => l_journal_source_name );
405: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 405: wf_engine.SetItemAttrText(itemtype => l_item_type,

401: wf_engine.SetItemAttrText(itemtype => l_item_type,
402: itemkey => l_item_key,
403: aname => 'JOURNAL_SOURCE_NAME',
404: avalue => l_journal_source_name );
405: wf_engine.SetItemAttrText(itemtype => l_item_type,
406: itemkey => l_item_key,
407: aname => 'PERIOD_NAME',
408: avalue => l_period_name );
409: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 409: wf_engine.SetItemAttrText(itemtype => l_item_type,

405: wf_engine.SetItemAttrText(itemtype => l_item_type,
406: itemkey => l_item_key,
407: aname => 'PERIOD_NAME',
408: avalue => l_period_name );
409: wf_engine.SetItemAttrText(itemtype => l_item_type,
410: itemkey => l_item_key,
411: aname => 'MAPPING_RULE_NAME',
412: avalue => l_mapping_rule_name );
413: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 413: wf_engine.SetItemAttrText(itemtype => l_item_type,

409: wf_engine.SetItemAttrText(itemtype => l_item_type,
410: itemkey => l_item_key,
411: aname => 'MAPPING_RULE_NAME',
412: avalue => l_mapping_rule_name );
413: wf_engine.SetItemAttrText(itemtype => l_item_type,
414: itemkey => l_item_key,
415: aname => 'BATCH_NAME',
416: avalue => l_batch_name );
417: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 417: wf_engine.SetItemAttrText(itemtype => l_item_type,

413: wf_engine.SetItemAttrText(itemtype => l_item_type,
414: itemkey => l_item_key,
415: aname => 'BATCH_NAME',
416: avalue => l_batch_name );
417: wf_engine.SetItemAttrText(itemtype => l_item_type,
418: itemkey => l_item_key,
419: aname => 'INTERFACE_TABLE_NAME',
420: avalue => l_interface_table_name );
421: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

Line 421: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

417: wf_engine.SetItemAttrText(itemtype => l_item_type,
418: itemkey => l_item_key,
419: aname => 'INTERFACE_TABLE_NAME',
420: avalue => l_interface_table_name );
421: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
422: itemkey => l_item_key,
423: aname => 'REQUEST_ID',
424: avalue => l_request_id );
425: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

Line 425: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

421: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
422: itemkey => l_item_key,
423: aname => 'REQUEST_ID',
424: avalue => l_request_id );
425: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
426: itemkey => l_item_key,
427: aname => 'INTERFACE_RUN_ID',
428: avalue => l_interface_run_id );
429: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

Line 429: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

425: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
426: itemkey => l_item_key,
427: aname => 'INTERFACE_RUN_ID',
428: avalue => l_interface_run_id );
429: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
430: itemkey => l_item_key,
431: aname => 'POSTING_RUN_ID',
432: avalue => l_posting_run_id );
433: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

Line 433: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

429: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
430: itemkey => l_item_key,
431: aname => 'POSTING_RUN_ID',
432: avalue => l_posting_run_id );
433: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
434: itemkey => l_item_key,
435: aname => 'GROUP_ID',
436: avalue => l_group_id );
437: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 437: wf_engine.SetItemAttrText(itemtype => l_item_type,

433: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
434: itemkey => l_item_key,
435: aname => 'GROUP_ID',
436: avalue => l_group_id );
437: wf_engine.SetItemAttrText(itemtype => l_item_type,
438: itemkey => l_item_key,
439: aname => 'SEND_TO',
440: avalue => l_send_to );
441: diagn_msg('Send To = '||l_send_to);

Line 442: wf_engine.SetItemAttrText(itemtype => l_item_type,

438: itemkey => l_item_key,
439: aname => 'SEND_TO',
440: avalue => l_send_to );
441: diagn_msg('Send To = '||l_send_to);
442: wf_engine.SetItemAttrText(itemtype => l_item_type,
443: itemkey => l_item_key,
444: aname => 'SENDER_NAME',
445: avalue => l_sender_name );
446: diagn_msg('Sender Name = '||l_sender_name);

Line 447: wf_engine.SetItemAttrText(itemtype => l_item_type,

443: itemkey => l_item_key,
444: aname => 'SENDER_NAME',
445: avalue => l_sender_name );
446: diagn_msg('Sender Name = '||l_sender_name);
447: wf_engine.SetItemAttrText(itemtype => l_item_type,
448: itemkey => l_item_key,
449: aname => 'MESSAGE_NAME',
450: avalue => l_message_name );
451: diagn_msg('Message Name = '||l_message_name);

Line 452: wf_engine.SetItemAttrText(itemtype => l_item_type,

448: itemkey => l_item_key,
449: aname => 'MESSAGE_NAME',
450: avalue => l_message_name );
451: diagn_msg('Message Name = '||l_message_name);
452: wf_engine.SetItemAttrText(itemtype => l_item_type,
453: itemkey => l_item_key,
454: aname => 'SEND_FROM',
455: avalue => l_send_From );
456: diagn_msg('Send From = '||l_send_From);

Line 457: wf_engine.SetItemAttrText(itemtype => l_item_type,

453: itemkey => l_item_key,
454: aname => 'SEND_FROM',
455: avalue => l_send_From );
456: diagn_msg('Send From = '||l_send_From);
457: wf_engine.SetItemAttrText(itemtype => l_item_type,
458: itemkey => l_item_key,
459: aname => 'IMPORT_MESSAGE_BODY',
460: avalue => l_import_message_body );
461: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 461: wf_engine.SetItemAttrText(itemtype => l_item_type,

457: wf_engine.SetItemAttrText(itemtype => l_item_type,
458: itemkey => l_item_key,
459: aname => 'IMPORT_MESSAGE_BODY',
460: avalue => l_import_message_body );
461: wf_engine.SetItemAttrText(itemtype => l_item_type,
462: itemkey => l_item_key,
463: aname => 'POST_REQUEST_ID',
464: avalue => l_post_request_id );
465: --+ Get the monitor URL

Line 474: wf_engine.SetItemAttrText( itemtype => l_item_type,

470: Exception
471: When others then
472: l_monitor_url := 'Invalid URL';
473: end;
474: wf_engine.SetItemAttrText( itemtype => l_item_type,
475: itemkey => l_item_key,
476: aname => 'MONITOR_URL',
477: avalue => l_monitor_url);
478: End set_wf_variables;

Line 516: l_message_name := WF_ENGINE.GetItemAttrText

512: l_message_name VARCHAR2(100);
513: Begin
514: If p_funcmode = 'RUN' THEN
515: diagn_msg('Starting Get_Action_Type');
516: l_message_name := WF_ENGINE.GetItemAttrText
517: (p_item_type,
518: p_item_key,
519: 'MESSAGE_NAME');
520: diagn_msg('Message_Name = '||l_message_name);