[Home] [Help]
373: l_format wf_activity_attributes.format%type;
374: l_date_value wf_activity_attr_values.date_value%type;
375: l_number_value wf_activity_attr_values.number_value%type;
376: l_text_value wf_activity_attr_values.text_value%type;
377: l_activity_name wf_item_activity_statuses_v.activity_name%type;
378: l_activity_display_name wf_item_activity_statuses_v.activity_display_name%type;
379: --
380: begin
381: -- check to see if the HR_ACTIVITY_TYPE activity attribute exists
374: l_date_value wf_activity_attr_values.date_value%type;
375: l_number_value wf_activity_attr_values.number_value%type;
376: l_text_value wf_activity_attr_values.text_value%type;
377: l_activity_name wf_item_activity_statuses_v.activity_name%type;
378: l_activity_display_name wf_item_activity_statuses_v.activity_display_name%type;
379: --
380: begin
381: -- check to see if the HR_ACTIVITY_TYPE activity attribute exists
382: get_act_attr_expanded_info
661: (p_item_type in wf_items.item_type%type
662: ,p_item_key in wf_items.item_key%type
663: ,p_actid in wf_activity_attr_values.process_activity_id%type
664: ,p_exists out nocopy boolean
665: ,p_result_code out nocopy wf_item_activity_statuses_v.activity_result_code%type) is
666: --
667: cursor l_csr_wiasv is
668: select wiasv.activity_result_code
669: from wf_item_activity_statuses wiasv
672: and wiasv.item_key = p_item_key
673: order by wiasv.end_date desc;
674:
675: /*select wiasv.activity_result_code
676: from wf_item_activity_statuses_v wiasv
677: where wiasv.activity_id = p_actid
678: and wiasv.item_type = p_item_type
679: and wiasv.item_key = p_item_key
680: order by wiasv.activity_end_date desc;*/
712: ,p_actid in wf_activity_attr_values.process_activity_id%type)
713: return boolean is
714: --
715: l_exists boolean;
716: l_activity_result_code wf_item_activity_statuses_v.activity_result_code%type;
717: --
718: begin
719: get_act_reentry_value_info
720: (p_item_type => p_item_type
730: function get_activity_reentry_value
731: (p_item_type in wf_items.item_type%type
732: ,p_item_key in wf_items.item_key%type
733: ,p_actid in wf_activity_attr_values.process_activity_id%type)
734: return wf_item_activity_statuses_v.activity_result_code%type is
735: --
736: l_exists boolean;
737: l_activity_result_code wf_item_activity_statuses_v.activity_result_code%type;
738: --
733: ,p_actid in wf_activity_attr_values.process_activity_id%type)
734: return wf_item_activity_statuses_v.activity_result_code%type is
735: --
736: l_exists boolean;
737: l_activity_result_code wf_item_activity_statuses_v.activity_result_code%type;
738: --
739: begin
740: get_act_reentry_value_info
741: (p_item_type => p_item_type
1126: -- have a status of NOTIFIED and have either the HR_ACTIVITY_TYPE or
1127: -- HR_ACTIVITY_TYPE_VALUE activity attributes defined
1128: cursor csr_wiasv is
1129: /*select wiasv.activity_id
1130: from wf_item_activity_statuses_v wiasv
1131: where wiasv.item_type = p_item_type
1132: and wiasv.item_key = p_item_key
1133: and wiasv.activity_type_code = g_wf_function
1134: and wiasv.activity_status_code = g_wf_activity_notified
1199: procedure transition_activity
1200: (p_item_type in wf_items.item_type%type
1201: ,p_item_key in wf_items.item_key%type
1202: ,p_actid in wf_activity_attr_values.process_activity_id%type
1203: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type) is
1204: --
1205: begin
1206: -- transition the wf engine
1207: wf_engine.CompleteActivity
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: )
1233: return active_wf_items_list is
1234: --
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
1244: -- is currently active with the name of p_process and belonging to
1271:
1272: /*
1273:
1274: -- fix for bug # 1632855 also refer bug # 1577987
1275: -- removed the view wf_item_activity_statuses_v
1276: -- using activity_item_type||'' to disable non unique index
1277:
1278: select process.item_key
1279: from wf_item_activity_statuses process
1313: and result.activity_result_code = p_activity_result_code;
1314: */
1315:
1316: /*select process.item_key
1317: from wf_item_activity_statuses_v process
1318: where process.activity_name = p_process_name
1319: and process.activity_status_code = 'ACTIVE'
1320: and process.item_type = p_item_type
1321: and process.item_key in (select attribute.item_key
1342: and process.item_key = l_active_item_key
1343: and process.activity_status = 'COMPLETE';
1344:
1345: /* select distinct process.activity_id
1346: from wf_item_activity_statuses_v process
1347: where process.item_type = p_item_type
1348: and process.item_key = l_active_item_key
1349: and process.activity_name = p_activity_name; */
1350:
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
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;
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
1436: -- is currently active with the name of p_process and belonging to
1458: AND attribute.number_value = p_current_person_id;
1459:
1460: /*
1461: -- fix for bug # 1632855 and also refer bug # 1577987
1462: -- removed the view wf_item_activity_statuses_v
1463: -- using activity_item_type||'' to disable non unique index
1464: -- removed the redundant AND conditions
1465:
1466: select process.item_key
1497: and attribute.number_value = p_current_person_id;
1498: */
1499:
1500: /*select process.item_key
1501: from wf_item_activity_statuses_v process
1502: where process.activity_name = p_process_name
1503: and process.activity_status_code = 'ACTIVE'
1504: and process.item_type = p_item_type
1505: and process.item_key in (select attribute.item_key
1526: and process.item_key = l_active_item_key
1527: and process.activity_status = 'COMPLETE';
1528:
1529: /*select distinct process.activity_id
1530: from wf_item_activity_statuses_v process
1531: where process.item_type = p_item_type
1532: and process.item_key = l_active_item_key
1533: and process.activity_name = p_activity_name; */
1534:
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: -----------------------------------------------------------------------------
1613: -- csr_wf_active_item Returns the item key of any process which
1673:
1674:
1675: ------------------------------------------------------------------------------
1676: -- We use api_name to filter the transaction records to improve performance so
1677: -- that we don't need to loop through the wf_item_activity_statuses_v to
1678: -- derive the activity_id for a given activity_name. The view
1679: -- wf_item_activity_statuses_v has a lot of records to process.
1680: ------------------------------------------------------------------------------
1681: cursor csr_hats (csr_p_api_name in varchar2
1675: ------------------------------------------------------------------------------
1676: -- We use api_name to filter the transaction records to improve performance so
1677: -- that we don't need to loop through the wf_item_activity_statuses_v to
1678: -- derive the activity_id for a given activity_name. The view
1679: -- wf_item_activity_statuses_v has a lot of records to process.
1680: ------------------------------------------------------------------------------
1681: cursor csr_hats (csr_p_api_name in varchar2
1682: ,csr_p_item_key in varchar2) is
1683: select transaction_step_id, activity_id