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_TASKFLOW_WORKFLOW dependencies on WF_PROCESS_ACTIVITIES

Line 6: g_process_activity_rec wf_process_activities%rowtype;

2: /* $Header: hrtskwkf.pkb 120.1.12000000.2 2007/04/09 14:13:57 agolechh ship $ */
3: --
4: -- WF Used Private Globals
5: --
6: g_process_activity_rec wf_process_activities%rowtype;
7: type g_usage_rec is record
8: (nav_node_usage_id hr_navigation_node_usages.nav_node_usage_id%type
9: ,instance_id wf_process_activities.instance_id%type
10: ,sqlform hr_navigation_units.form_name%type

Line 9: ,instance_id wf_process_activities.instance_id%type

5: --
6: g_process_activity_rec wf_process_activities%rowtype;
7: type g_usage_rec is record
8: (nav_node_usage_id hr_navigation_node_usages.nav_node_usage_id%type
9: ,instance_id wf_process_activities.instance_id%type
10: ,sqlform hr_navigation_units.form_name%type
11: ,override_label hr_navigation_paths.override_label%type);
12: type g_wf_transition_rec is record
13: (to_process_activity wf_activity_transitions.to_process_activity%type

Line 37: g_root_process_id wf_process_activities.instance_id%type;

33: g_to_form_activity varchar2(16) := 'TO_FORM_ACTIVITY';
34: g_max_number_of_buttons number := 5;
35: g_max_button_sequence_value number := 99999;
36: g_root_form_activity_id number;
37: g_root_process_id wf_process_activities.instance_id%type;
38: g_business_group_id pay_customized_restrictions.business_group_id%type;
39: g_legislation_code pay_customized_restrictions.legislation_code%type;
40: g_legislation_subgroup pay_customized_restrictions.legislation_subgroup%type;
41: g_activity_display_name wf_activities_tl.display_name%type;

Line 52: from wf_process_activities wpa

48: --
49: --
50: cursor g_get_process_activity(c_instance_id number) is
51: select *
52: from wf_process_activities wpa
53: where wpa.instance_id = c_instance_id;
54: --
55: cursor g_csr_root_runnable_process
56: (c_item_type varchar2, c_process_name varchar2) is

Line 58: from wf_process_activities wpa

54: --
55: cursor g_csr_root_runnable_process
56: (c_item_type varchar2, c_process_name varchar2) is
57: select wpa.activity_name
58: from wf_process_activities wpa
59: where wpa.process_version =
60: (select max(wpa1.process_version)
61: from wf_process_activities wpa1
62: where wpa1.process_name = wpa.process_name

Line 61: from wf_process_activities wpa1

57: select wpa.activity_name
58: from wf_process_activities wpa
59: where wpa.process_version =
60: (select max(wpa1.process_version)
61: from wf_process_activities wpa1
62: where wpa1.process_name = wpa.process_name
63: and wpa1.process_item_type = wpa.process_item_type)
64: and wpa.process_item_type = c_item_type
65: and wpa.activity_name = nvl(c_process_name, wpa.activity_name)

Line 98: ,wf_process_activities wpa

94: ,wf_activities_tl wat2
95: ,wf_activities wa1
96: ,wf_activities wa2
97: ,wf_item_types_tl witt
98: ,wf_process_activities wpa
99: where wpa.instance_id = p_instance_id
100: and witt.name = wpa.activity_item_type
101: and witt.language = g_language
102: and wa1.name = wpa.activity_name

Line 193: from wf_process_activities wpa

189: ,p_root_process_name in varchar2) is
190: -- cursor select the Process Activity ID of the root process
191: cursor l_get_instance_id is
192: select wpa.instance_id
193: from wf_process_activities wpa
194: where wpa.process_version =
195: (select max(wpa1.process_version)
196: from wf_process_activities wpa1
197: where wpa1.process_name = wpa.process_name

Line 196: from wf_process_activities wpa1

192: select wpa.instance_id
193: from wf_process_activities wpa
194: where wpa.process_version =
195: (select max(wpa1.process_version)
196: from wf_process_activities wpa1
197: where wpa1.process_name = wpa.process_name
198: and wpa1.process_item_type = wpa.process_item_type)
199: and wpa.process_item_type = p_process_item_type
200: and wpa.activity_name = p_root_process_name

Line 230: from wf_process_activities wpa

226: -- cursor select the Process Activity ID of the activity
227: -- ROOT_TASKFLOW_FORM_SELECTOR
228: cursor l_get_instance_id is
229: select wpa.instance_id
230: from wf_process_activities wpa
231: where wpa.process_version =
232: (select max(wpa1.process_version)
233: from wf_process_activities wpa1
234: where wpa1.process_name = wpa.process_name

Line 233: from wf_process_activities wpa1

229: select wpa.instance_id
230: from wf_process_activities wpa
231: where wpa.process_version =
232: (select max(wpa1.process_version)
233: from wf_process_activities wpa1
234: where wpa1.process_name = wpa.process_name
235: and wpa1.process_item_type = wpa.process_item_type)
236: and wpa.process_item_type = p_process_item_type
237: and wpa.process_name = p_root_process_name

Line 495: (c_instance_id wf_process_activities.instance_id%type) is

491: -- --------------------------------------------------------------------------
492: -- |-------------------------< private cursors >----------------------------|
493: -- --------------------------------------------------------------------------
494: cursor csr_process_start_transitions
495: (c_instance_id wf_process_activities.instance_id%type) is
496: -- select the START result codes
497: select wat.from_process_activity
498: ,wat.to_process_activity
499: ,wat.result_code

Line 500: from wf_process_activities wpa1

496: -- select the START result codes
497: select wat.from_process_activity
498: ,wat.to_process_activity
499: ,wat.result_code
500: from wf_process_activities wpa1
501: ,wf_process_activities wpa2
502: ,wf_activity_transitions wat
503: where wpa1.instance_id = c_instance_id
504: and wpa2.process_name = wpa1.activity_name

Line 501: ,wf_process_activities wpa2

497: select wat.from_process_activity
498: ,wat.to_process_activity
499: ,wat.result_code
500: from wf_process_activities wpa1
501: ,wf_process_activities wpa2
502: ,wf_activity_transitions wat
503: where wpa1.instance_id = c_instance_id
504: and wpa2.process_name = wpa1.activity_name
505: and wpa2.process_item_type = wpa1.activity_item_type

Line 509: from wf_process_activities wpa3

505: and wpa2.process_item_type = wpa1.activity_item_type
506: and wpa2.start_end = g_activity_type_start
507: and wpa2.process_version =
508: (select max(wpa3.process_version)
509: from wf_process_activities wpa3
510: where wpa3.process_name = wpa2.process_name
511: and wpa3.process_item_type = wpa2.process_item_type)
512: and wat.from_process_activity = wpa2.instance_id;
513: --

Line 515: (c_instance_id wf_process_activities.instance_id%type

511: and wpa3.process_item_type = wpa2.process_item_type)
512: and wat.from_process_activity = wpa2.instance_id;
513: --
514: cursor csr_process_end_transitions
515: (c_instance_id wf_process_activities.instance_id%type
516: ,c_result_code wf_activity_transitions.result_code%type) is
517: -- select the END result codes
518: select wat.from_process_activity
519: ,wat.to_process_activity

Line 521: from wf_process_activities wpa1

517: -- select the END result codes
518: select wat.from_process_activity
519: ,wat.to_process_activity
520: ,wat.result_code
521: from wf_process_activities wpa1
522: ,wf_process_activities wpa2
523: ,wf_activity_transitions wat
524: where wpa1.instance_id = c_instance_id
525: and wpa1.start_end = g_activity_type_end

Line 522: ,wf_process_activities wpa2

518: select wat.from_process_activity
519: ,wat.to_process_activity
520: ,wat.result_code
521: from wf_process_activities wpa1
522: ,wf_process_activities wpa2
523: ,wf_activity_transitions wat
524: where wpa1.instance_id = c_instance_id
525: and wpa1.start_end = g_activity_type_end
526: and wpa2.activity_name = wpa1.process_name

Line 530: from wf_process_activities wpa3

526: and wpa2.activity_name = wpa1.process_name
527: and wpa2.activity_item_type = wpa1.process_item_type
528: and wpa2.process_version =
529: (select max(wpa3.process_version)
530: from wf_process_activities wpa3
531: where wpa3.process_name = wpa2.process_name
532: and wpa3.process_item_type = wpa2.process_item_type)
533: and wat.from_process_activity = wpa2.instance_id
534: and wat.result_code = c_result_code;

Line 559: ,wf_process_activities wpa

555: cursor csr_attivity_type(c_instance_id number) is
556: select wa.type
557: ,wpa.start_end
558: from wf_activities wa
559: ,wf_process_activities wpa
560: where wpa.instance_id = c_instance_id
561: and wa.item_type = wpa.activity_item_type
562: and wa.name = wpa.activity_name
563: and wa.end_date is null;

Line 1366: cursor l_csr_processes(c_instance_id wf_process_activities.instance_id%type) is

1362: procedure insert_navigation_nodes
1363: (p_process_item_type in varchar2
1364: ,p_process_name in varchar2) is
1365: --
1366: cursor l_csr_processes(c_instance_id wf_process_activities.instance_id%type) is
1367: select wpa1.instance_id
1368: from wf_activities wa
1369: ,wf_process_activities wpa1
1370: ,wf_process_activities wpa2

Line 1369: ,wf_process_activities wpa1

1365: --
1366: cursor l_csr_processes(c_instance_id wf_process_activities.instance_id%type) is
1367: select wpa1.instance_id
1368: from wf_activities wa
1369: ,wf_process_activities wpa1
1370: ,wf_process_activities wpa2
1371: where wpa2.instance_id = c_instance_id
1372: and wpa1.process_name = wpa2.activity_name
1373: and wpa1.process_item_type = wpa2.activity_item_type

Line 1370: ,wf_process_activities wpa2

1366: cursor l_csr_processes(c_instance_id wf_process_activities.instance_id%type) is
1367: select wpa1.instance_id
1368: from wf_activities wa
1369: ,wf_process_activities wpa1
1370: ,wf_process_activities wpa2
1371: where wpa2.instance_id = c_instance_id
1372: and wpa1.process_name = wpa2.activity_name
1373: and wpa1.process_item_type = wpa2.activity_item_type
1374: and wpa1.process_version =

Line 1376: from wf_process_activities wpa3

1372: and wpa1.process_name = wpa2.activity_name
1373: and wpa1.process_item_type = wpa2.activity_item_type
1374: and wpa1.process_version =
1375: (select max(wpa3.process_version)
1376: from wf_process_activities wpa3
1377: where wpa3.process_name = wpa1.process_name
1378: and wpa3.process_item_type = wpa1.process_item_type)
1379: and wa.name = wpa1.activity_name
1380: and wa.item_type = wpa1.activity_item_type

Line 1385: (c_instance_id wf_process_activities.instance_id%type) is

1381: and wa.type = g_activity_type_process
1382: and wa.end_date is null;
1383: --
1384: cursor l_csr_tf_form_activity
1385: (c_instance_id wf_process_activities.instance_id%type) is
1386: select wpa1.instance_id
1387: from wf_activities wa
1388: ,wf_process_activities wpa1
1389: ,wf_process_activities wpa2

Line 1388: ,wf_process_activities wpa1

1384: cursor l_csr_tf_form_activity
1385: (c_instance_id wf_process_activities.instance_id%type) is
1386: select wpa1.instance_id
1387: from wf_activities wa
1388: ,wf_process_activities wpa1
1389: ,wf_process_activities wpa2
1390: ,wf_activity_attr_values waav
1391: ,wf_activity_attributes waa
1392: where wpa2.instance_id = c_instance_id

Line 1389: ,wf_process_activities wpa2

1385: (c_instance_id wf_process_activities.instance_id%type) is
1386: select wpa1.instance_id
1387: from wf_activities wa
1388: ,wf_process_activities wpa1
1389: ,wf_process_activities wpa2
1390: ,wf_activity_attr_values waav
1391: ,wf_activity_attributes waa
1392: where wpa2.instance_id = c_instance_id
1393: and wpa1.process_name = wpa2.activity_name

Line 1397: from wf_process_activities wpa3

1393: and wpa1.process_name = wpa2.activity_name
1394: and wpa1.process_item_type = wpa2.activity_item_type
1395: and wpa1.process_version =
1396: (select max(wpa3.process_version)
1397: from wf_process_activities wpa3
1398: where wpa3.process_name = wpa1.process_name
1399: and wpa3.process_item_type = wpa1.process_item_type)
1400: and wa.name = wpa1.activity_name
1401: and wa.item_type = wpa1.activity_item_type

Line 1413: (c_instance_id wf_process_activities.instance_id%type) is

1409: and waa.activity_version = wa.version
1410: and waa.name = g_taskflow_activity_type;
1411: --
1412: cursor l_csr_tf_form_attributes
1413: (c_instance_id wf_process_activities.instance_id%type) is
1414: select waa.name
1415: ,waav.text_value
1416: from wf_activities wa
1417: ,wf_process_activities wpa1

Line 1417: ,wf_process_activities wpa1

1413: (c_instance_id wf_process_activities.instance_id%type) is
1414: select waa.name
1415: ,waav.text_value
1416: from wf_activities wa
1417: ,wf_process_activities wpa1
1418: ,wf_activity_attr_values waav
1419: ,wf_activity_attributes waa
1420: where wpa1.instance_id = c_instance_id
1421: and wa.name = wpa1.activity_name

Line 1488: wf_process_activities.instance_id%type

1484: l_default_label hr_navigation_units.default_label%type;
1485: l_found_nav_node boolean;
1486: --
1487: type l_process_stack_tab is table of
1488: wf_process_activities.instance_id%type
1489: index by binary_integer;
1490: l_process_stack_struct l_process_stack_tab;
1491: l_current_working_process_id wf_process_activities.instance_id%type;
1492: --

Line 1491: l_current_working_process_id wf_process_activities.instance_id%type;

1487: type l_process_stack_tab is table of
1488: wf_process_activities.instance_id%type
1489: index by binary_integer;
1490: l_process_stack_struct l_process_stack_tab;
1491: l_current_working_process_id wf_process_activities.instance_id%type;
1492: --
1493: begin
1494: hr_utility.set_location('Entering:'||l_proc, 10);
1495: --

Line 1501: -- from workflow on the table wf_process_activities). so due to

1497: -- process is located within the specified root process.
1498: -- originally this was perceived as being a network/hierachy query but
1499: -- due to performance this mechasim has been abandoned (ideally this
1500: -- would the best solution, however, a new index would be required
1501: -- from workflow on the table wf_process_activities). so due to
1502: -- time constraints, a work around has been put in place which
1503: -- describes the processing logic in detail.
1504: --
1505: -- a stack is used to maintain a 'working' list of processes. the intial

Line 1770: from wf_process_activities wpa

1766: ,result out nocopy varchar2) is
1767: --
1768: cursor l_csr_tf_form is
1769: select 1
1770: from wf_process_activities wpa
1771: ,wf_activity_attr_values waav
1772: where wpa.instance_id = actid
1773: and waav.process_activity_id = wpa.instance_id
1774: and waav.name = g_taskflow_activity_type

Line 1822: l_dummy wf_process_activities.activity_name%type;

1818: ,p_process_name in varchar2)
1819: return boolean is
1820: --
1821: l_proc varchar2(72) := g_package||'chk_process_name';
1822: l_dummy wf_process_activities.activity_name%type;
1823: l_return boolean;
1824: --
1825: begin
1826: hr_utility.set_location('Entering:'||l_proc, 10);