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.HR_WORKFLOW_SERVICE dependencies on HR_WORKFLOW_SERVICE

Line 1: PACKAGE BODY hr_workflow_service as

1: PACKAGE BODY hr_workflow_service as
2: /* $Header: hrwfserv.pkb 120.7.12010000.2 2008/08/06 08:50:55 ubhat ship $ */
3: --
4: -- Package Variables
5: --

Line 9: g_package VARCHAR2(31) := 'hr_workflow_service.';

5: --
6: -- ---------------------------------------------------------------------------
7: -- private package global declarations
8: -- ---------------------------------------------------------------------------
9: g_package VARCHAR2(31) := 'hr_workflow_service.';
10: --
11: -- Private Package Procedures/Functions
12: --
13: -- ---------------------------------------------------------------------------

Line 1095: hr_utility.set_message_token('PROCEDURE', 'hr_workflow_service.display_html');

1091: -- supply HR error message
1092: -- an error has occurred when attempting to call the stored procedure
1093: -- to generate the web page.
1094: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1095: hr_utility.set_message_token('PROCEDURE', 'hr_workflow_service.display_html');
1096: hr_utility.set_message_token('STEP','10');
1097: hr_utility.raise_error;
1098: end display_html;
1099: -- ----------------------------------------------------------------------------

Line 1239: l_active_wf_items_list hr_workflow_service.active_wf_items_list;

1235: l_process_name wf_process_activities.process_name%type;
1236: l_active_item_key wf_items.item_key%type;
1237: l_dummy number(1);
1238: l_count integer;
1239: l_active_wf_items_list hr_workflow_service.active_wf_items_list;
1240: l_activity_id wf_item_activity_statuses_v.activity_id%type;
1241: --
1242: -- Local cursor definations
1243: -- csr_wf_active_item Returns the item key of any process which

Line 1380: -- hr_workflow_service.get_activity_reentry_value

1376: if csr_wfactname%notfound then
1377: l_activity_id := null;
1378: else
1379: l_activity_result_code := p_activity_result_code;
1380: -- hr_workflow_service.get_activity_reentry_value
1381: -- (p_item_type => p_item_type
1382: -- ,p_item_key => l_active_item_key
1383: -- ,p_actid => l_activity_id);
1384: --IF upper(p_activity_result_code) =

Line 1431: l_active_wf_items_list hr_workflow_service.active_wf_items_list;

1427: l_process_name wf_process_activities.process_name%type;
1428: l_active_item_key wf_items.item_key%type;
1429: l_dummy number(1);
1430: l_count integer;
1431: l_active_wf_items_list hr_workflow_service.active_wf_items_list;
1432: l_activity_id wf_item_activity_statuses_v.activity_id%type;
1433: --
1434: -- Local cursor definations
1435: -- csr_wf_active_item Returns the item key of any process which

Line 1566: := hr_workflow_service.get_activity_reentry_value

1562: else
1563: l_active_wf_items_list(l_count).activity_id
1564: := l_activity_id;
1565: l_active_wf_items_list(l_count).activity_result_code
1566: := hr_workflow_service.get_activity_reentry_value
1567: (p_item_type => p_item_type
1568: ,p_item_key => l_active_item_key
1569: ,p_actid => l_activity_id);
1570: end if;

Line 1608: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;

1604: --
1605: l_process_name wf_process_activities.process_name%type;
1606: l_active_item_key wf_items.item_key%type;
1607: l_count integer;
1608: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;
1609: l_activity_id wf_item_activity_statuses_v.activity_id%type;
1610: --
1611: -- Local cursor definitions
1612: -----------------------------------------------------------------------------

Line 2004: nvl(item_type,hr_workflow_service.getItemType(t.transaction_id)) item_type,

2000: a.item_type item_type,
2001: a.item_key item_key
2002: from (select transaction_id,
2003: status,
2004: nvl(item_type,hr_workflow_service.getItemType(t.transaction_id)) item_type,
2005: nvl(item_key,hr_workflow_service.getItemKey(t.transaction_id)) item_key
2006: from hr_api_transactions t
2007: where t.last_update_date <= sysdate - c_transaction_age
2008: and t.status not in ('Y', 'YS','W')

Line 2005: nvl(item_key,hr_workflow_service.getItemKey(t.transaction_id)) item_key

2001: a.item_key item_key
2002: from (select transaction_id,
2003: status,
2004: nvl(item_type,hr_workflow_service.getItemType(t.transaction_id)) item_type,
2005: nvl(item_key,hr_workflow_service.getItemKey(t.transaction_id)) item_key
2006: from hr_api_transactions t
2007: where t.last_update_date <= sysdate - c_transaction_age
2008: and t.status not in ('Y', 'YS','W')
2009: and t.transaction_ref_table <> 'PER_APPRAISALS'

Line 2060: WHERE wi.item_type = nvl(hat.item_type,hr_workflow_service.getItemType(hat.transaction_id))

2056: SELECT hat.transaction_id
2057: FROM hr_api_transactions hat
2058: WHERE NOT EXISTS (SELECT 'Y'
2059: FROM wf_items wi
2060: WHERE wi.item_type = nvl(hat.item_type,hr_workflow_service.getItemType(hat.transaction_id))
2061: AND wi.item_key = nvl(hat.item_key,hr_workflow_service.getItemKey(hat.transaction_id))
2062: )
2063: AND Not Exists( select 'Y' from wf_items w --fix for bug 6121860
2064: where w.item_type = 'HRSFL'

Line 2061: AND wi.item_key = nvl(hat.item_key,hr_workflow_service.getItemKey(hat.transaction_id))

2057: FROM hr_api_transactions hat
2058: WHERE NOT EXISTS (SELECT 'Y'
2059: FROM wf_items wi
2060: WHERE wi.item_type = nvl(hat.item_type,hr_workflow_service.getItemType(hat.transaction_id))
2061: AND wi.item_key = nvl(hat.item_key,hr_workflow_service.getItemKey(hat.transaction_id))
2062: )
2063: AND Not Exists( select 'Y' from wf_items w --fix for bug 6121860
2064: where w.item_type = 'HRSFL'
2065: and w.user_key = hat.transaction_id)

Line 2511: Wf_Core.Context('hr_workflow_service', 'start_cleanup_process', l_item_type, l_item_key, p_transaction_age);

2507:
2508:
2509: exception
2510: when others then
2511: Wf_Core.Context('hr_workflow_service', 'start_cleanup_process', l_item_type, l_item_key, p_transaction_age);
2512: raise;
2513: --
2514: end start_cleanup_process;
2515:

Line 2543: Wf_Core.Context('hr_workflow_service', 'Block', itemtype,

2539: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
2540: ':'||wf_engine.eng_null;
2541: exception
2542: when others then
2543: Wf_Core.Context('hr_workflow_service', 'Block', itemtype,
2544: itemkey, to_char(actid), funcmode);
2545: raise;
2546: end Block;
2547:

Line 2619: END hr_workflow_service;

2615: return getItemkey.l_item_key;
2616: end getItemKey;
2617:
2618: --
2619: END hr_workflow_service;