[Home] [Help]
112: SELECT a.name activity_name,
113: a.display_name activity_display_name
114: FROM wf_activities_vl a
115: ,wf_item_activity_statuses ias
116: ,wf_process_activities pa
117: WHERE ias.item_type = p_item_type
118: AND ias.item_key = p_item_key
119: AND ias.process_activity = p_actid
120: AND ias.process_activity = pa.instance_id
124: SELECT a.name activity_name,
125: a.display_name activity_display_name
126: FROM wf_activities_vl a
127: ,wf_item_activity_statuses_h iash
128: ,wf_process_activities pa
129: WHERE iash.item_type = p_item_type
130: AND iash.item_key = p_item_key
131: AND iash.process_activity = p_actid
132: AND iash.process_activity = pa.instance_id
749: -- |--------------------< wf_get_runnable_process_name >----------------------|
750: -- ----------------------------------------------------------------------------
751: function wf_get_runnable_process_name
752: (p_item_type in wf_items.item_type%type
753: ,p_process_name in wf_process_activities.process_name%type)
754: return wf_runnable_processes_v.display_name%type is
755: -- cursor determines is the specified process is runnable
756: cursor csr_wrpv is
757: select wrpv.display_name
776: -- |-------------------------< wf_process_runnable >--------------------------|
777: -- ----------------------------------------------------------------------------
778: function wf_process_runnable
779: (p_item_type in wf_items.item_type%type
780: ,p_process_name in wf_process_activities.process_name%type)
781: return boolean is
782: --
783: begin
784: if wf_get_runnable_process_name
792: -- ----------------------------------------------------------------------------
793: -- |------------------------------< create_process >--------------------------|
794: -- ----------------------------------------------------------------------------
795: procedure create_process
796: (p_process_name in wf_process_activities.process_name%type
797: ,p_item_type in wf_items.item_type%type
798: ,p_person_id in varchar2 default null
799: ,p_called_from in varchar2 default null
800: ,p_item_attribute in g_varchar2_tab_type
802: ,p_item_attribute_value in g_varchar2_tab_type
803: default g_varchar2_tab_default
804: ,p_number_of_attributes_in in number default 0) is
805: --
806: l_process_name wf_process_activities.process_name%type :=
807: upper(p_process_name);
808:
809: l_item_type wf_items.item_type%type := upper(p_item_type);
810: l_item_key wf_items.item_key%type;
1109: --
1110: cursor csr_prc_active is
1111: select 1
1112: from wf_item_activity_statuses wias
1113: ,wf_process_activities wpa1
1114: where wpa1.process_item_type = p_item_type
1115: and wpa1.process_name = g_wf_root_process
1116: and wpa1.process_version =
1117: (select max(wpa2.process_version)
1114: where wpa1.process_item_type = p_item_type
1115: and wpa1.process_name = g_wf_root_process
1116: and wpa1.process_version =
1117: (select max(wpa2.process_version)
1118: from wf_process_activities wpa2
1119: where wpa2.process_item_type = p_item_type
1120: and wpa2.process_name = g_wf_root_process)
1121: and wias.process_activity = wpa1.instance_id
1122: and wias.item_type = p_item_type
1224: -- activity_result_code to a table.
1225: -- ----------------------------------------------------------------------------
1226: function check_active_wf_items
1227: (p_item_type in wf_items.item_type%type
1228: ,p_process_name in wf_process_activities.process_name%type
1229: ,p_current_person_id in per_people_f.person_id%type
1230: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
1231: ,p_activity_result_code in varchar2
1232: )
1231: ,p_activity_result_code in varchar2
1232: )
1233: return active_wf_items_list is
1234: --
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;
1243: -- csr_wf_active_item Returns the item key of any process which
1244: -- is currently active with the name of p_process and belonging to
1245: -- the given person id
1246: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type
1247: ,p_process_name in wf_process_activities.process_name%type
1248: ,p_item_type in wf_items.item_type%type
1249: ) is
1250:
1251: -- fix for the bug1835437
1250:
1251: -- fix for the bug1835437
1252: SELECT /*+ ordered */
1253: process.item_key
1254: FROM wf_process_activities activity,
1255: wf_item_activity_statuses process,
1256: wf_item_activity_statuses result,
1257: wf_item_attribute_values attribute
1258: WHERE activity.activity_name = p_process_name
1277:
1278: select process.item_key
1279: from wf_item_activity_statuses process
1280: ,wf_item_attribute_values attribute
1281: ,wf_process_activities activity
1282: where activity.activity_name = p_process_name
1283: and activity.process_item_type = p_item_type
1284: and activity.activity_item_type||'' = p_item_type
1285: and activity.instance_id = process.process_activity
1295: /*
1296: select process.item_key
1297: from wf_item_activity_statuses process
1298: ,wf_item_attribute_values attribute
1299: ,wf_process_activities activity
1300: ,wf_item_activity_statuses result
1301: where activity.activity_name = p_process_name
1302: and activity.process_item_type = p_item_type
1303: and activity.activity_item_type = p_item_type
1331: and item_key = l_active_item_key;
1332:
1333: cursor csr_wfactname is
1334: select activity.instance_id activity_id
1335: from wf_process_activities activity,
1336: wf_item_activity_statuses process
1337: where activity.activity_name = p_activity_name
1338: and activity.process_item_type = p_item_type
1339: and activity.activity_item_type = p_item_type
1417: -- activity result code.
1418: -- ----------------------------------------------------------------------------
1419: function check_active_wf_items
1420: (p_item_type in wf_items.item_type%type
1421: ,p_process_name in wf_process_activities.process_name%type
1422: ,p_current_person_id in per_people_f.person_id%type
1423: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
1424: )
1425: return active_wf_items_list is
1423: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
1424: )
1425: return active_wf_items_list is
1426: --
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;
1435: -- csr_wf_active_item Returns the item key of any process which
1436: -- is currently active with the name of p_process and belonging to
1437: -- the given person id
1438: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type
1439: ,p_process_name in wf_process_activities.process_name%type
1440: ,p_item_type in wf_items.item_type%type
1441: ) is
1442:
1443:
1443:
1444: -- fix for the bug1835437
1445: SELECT /*+ ordered */
1446: process.item_key
1447: FROM wf_process_activities activity,
1448: wf_item_activity_statuses process,
1449: wf_item_attribute_values attribute
1450: WHERE activity.activity_name = p_process_name
1451: AND activity.activity_item_type = p_item_type
1464: -- removed the redundant AND conditions
1465:
1466: select process.item_key
1467: from wf_item_attribute_values attribute,
1468: wf_process_activities activity,
1469: wf_item_activity_statuses process
1470: where activity.activity_name = p_process_name
1471: -- and activity.process_item_type = p_item_type
1472: -- and activity.activity_item_type||'' = p_item_type
1483: /*
1484: select process.item_key
1485: from wf_item_activity_statuses process
1486: ,wf_item_attribute_values attribute
1487: ,wf_process_activities activity
1488: where activity.activity_name = p_process_name
1489: and activity.process_item_type = p_item_type
1490: and activity.activity_item_type = p_item_type
1491: and activity.instance_id = process.process_activity
1515: and item_key = l_active_item_key;
1516:
1517: cursor csr_wfactname is
1518: select activity.instance_id activity_id
1519: from wf_process_activities activity,
1520: wf_item_activity_statuses process
1521: where activity.activity_name = p_activity_name
1522: and activity.process_item_type = p_item_type
1523: and activity.activity_item_type = p_item_type
1593: -- share the same api name, which is hr_process_address_ss.
1594: -- ----------------------------------------------------------------------------
1595: FUNCTION get_active_wf_items
1596: (p_item_type in wf_items.item_type%type
1597: ,p_process_name in wf_process_activities.process_name%type
1598: ,p_current_person_id in per_people_f.person_id%type
1599: ,p_api_name in hr_api_transaction_steps.api_name%type
1600: ,p_activity_result_code in varchar2 default null
1601: ,p_address_context in varchar2 default null
1601: ,p_address_context in varchar2 default null
1602: )
1603: return active_wf_trans_items_list is
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;
1619: -- determine if the item_key has gone through a specific path, such as
1620: -- submit for approval.
1621: -----------------------------------------------------------------------------
1622: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type
1623: ,p_process_name in wf_process_activities.process_name%type
1624: ,p_item_type in wf_items.item_type%type
1625: ,p_result_code in varchar2
1626: ) is
1627:
1627:
1628: select process.item_key
1629: from wf_item_activity_statuses process
1630: ,wf_item_attribute_values attribute
1631: ,wf_process_activities activity
1632: ,wf_item_activity_statuses result
1633: where activity.activity_name = p_process_name
1634: and activity.process_item_type = p_item_type
1635: and activity.activity_item_type = p_item_type
1651: --
1652: -- The following cursor is for no result code passed in.
1653: -----------------------------------------------------------------------------
1654: cursor csr_wfactitms2 (p_current_person_id in per_people_f.person_id%type
1655: ,p_process_name in wf_process_activities.process_name%type
1656: ,p_item_type in wf_items.item_type%type
1657: ) is
1658:
1659: select process.item_key
1658:
1659: select process.item_key
1660: from wf_item_activity_statuses process
1661: ,wf_item_attribute_values attribute
1662: ,wf_process_activities activity
1663: where activity.activity_name = p_process_name
1664: and activity.process_item_type = p_item_type
1665: and activity.activity_item_type = p_item_type
1666: and activity.instance_id = process.process_activity
1976: /*cursor csr_wfdfctitms is
1977: select wias.item_key
1978: from wf_item_activity_statuses wias,
1979: wf_activity_attr_values waav,
1980: wf_process_activities wpa,
1981: wf_item_attribute_values wiav
1982: where wias.item_type = itemtype
1983: and wias.activity_status = 'NOTIFIED'
1984: and wpa.instance_id = wias.process_activity
2412: -- ----------------------------------------------------------------------------
2413: procedure start_cleanup_process
2414: (p_item_type in wf_items.item_type%type
2415: ,p_transaction_age in wf_item_attribute_values.number_value%type
2416: ,p_process_name in wf_process_activities.process_name%type default 'HR_BACKGROUND_CLEANUP_PRC',
2417: p_transaction_status in varchar2 default 'ALL'
2418: ) is
2419: --
2420: l_process_name wf_process_activities.process_name%type := upper(p_process_name);
2416: ,p_process_name in wf_process_activities.process_name%type default 'HR_BACKGROUND_CLEANUP_PRC',
2417: p_transaction_status in varchar2 default 'ALL'
2418: ) is
2419: --
2420: l_process_name wf_process_activities.process_name%type := upper(p_process_name);
2421: l_item_type wf_items.item_type%type := upper(p_item_type);
2422: l_item_key wf_items.item_key%type;
2423: --
2424: --