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 WF_ITEM_ACTIVITY_STATUSES

Line 115: ,wf_item_activity_statuses ias

111: (
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

Line 127: ,wf_item_activity_statuses_h iash

123: UNION ALL
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

Line 377: l_activity_name wf_item_activity_statuses_v.activity_name%type;

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

Line 378: l_activity_display_name wf_item_activity_statuses_v.activity_display_name%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
382: get_act_attr_expanded_info

Line 665: ,p_result_code out nocopy wf_item_activity_statuses_v.activity_result_code%type) is

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

Line 669: from wf_item_activity_statuses wiasv

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
670: where wiasv.process_activity = p_actid
671: and wiasv.item_type = p_item_type
672: and wiasv.item_key = p_item_key
673: order by wiasv.end_date desc;

Line 676: from wf_item_activity_statuses_v 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;*/

Line 716: l_activity_result_code wf_item_activity_statuses_v.activity_result_code%type;

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

Line 734: return wf_item_activity_statuses_v.activity_result_code%type is

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: --

Line 737: l_activity_result_code wf_item_activity_statuses_v.activity_result_code%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: --
739: begin
740: get_act_reentry_value_info
741: (p_item_type => p_item_type

Line 1112: from wf_item_activity_statuses wias

1108: l_dummy number(1);
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 =

Line 1130: from wf_item_activity_statuses_v wiasv

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

Line 1141: FROM WF_ITEM_ACTIVITY_STATUSES IAS

1137: from wf_activity_attr_values waav
1138: where waav.process_activity_id = wiasv.activity_id
1139: and waav.name in (g_hr_activity_type, g_hr_activity_type_value));*/
1140: SELECT process_activity activity_id
1141: FROM WF_ITEM_ACTIVITY_STATUSES IAS
1142: WHERE ias.item_type = p_item_type
1143: and ias.item_key = p_item_key
1144: and ias.activity_status = g_wf_activity_notified
1145: and exists

Line 1203: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type) is

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

Line 1230: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type

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: --

Line 1240: l_activity_id wf_item_activity_statuses_v.activity_id%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
1244: -- is currently active with the name of p_process and belonging to

Line 1255: wf_item_activity_statuses process,

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
1259: AND activity.activity_item_type = p_item_type

Line 1256: wf_item_activity_statuses result,

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
1259: AND activity.activity_item_type = p_item_type
1260: AND activity.process_item_type = p_item_type

Line 1275: -- removed the view wf_item_activity_statuses_v

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

Line 1279: from wf_item_activity_statuses process

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
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

Line 1297: from wf_item_activity_statuses process

1293: */
1294:
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

Line 1300: ,wf_item_activity_statuses result

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
1304: and activity.instance_id = process.process_activity

Line 1317: from wf_item_activity_statuses_v 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

Line 1336: wf_item_activity_statuses process

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
1340: and activity.instance_id = process.process_activity

Line 1346: from wf_item_activity_statuses_v process

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:

Line 1352: l_activity_result_code wf_item_activity_statuses.activity_result_code%type;

1348: and process.item_key = l_active_item_key
1349: and process.activity_name = p_activity_name; */
1350:
1351: --
1352: l_activity_result_code wf_item_activity_statuses.activity_result_code%type;
1353: --
1354: begin
1355: -- There can be mulitiple Itemkeys each corresponding to a
1356: -- section of a worksheet. Loop through all of them and validate

Line 1423: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type

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;

Line 1432: l_activity_id wf_item_activity_statuses_v.activity_id%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

Line 1448: wf_item_activity_statuses process,

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
1452: AND activity.instance_id = process.process_activity

Line 1462: -- removed the view wf_item_activity_statuses_v

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

Line 1469: wf_item_activity_statuses process

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
1473: and activity.instance_id = process.process_activity

Line 1485: from wf_item_activity_statuses process

1481: */
1482:
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

Line 1501: from wf_item_activity_statuses_v process

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

Line 1520: wf_item_activity_statuses process

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
1524: and activity.instance_id = process.process_activity

Line 1530: from wf_item_activity_statuses_v process

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:

Line 1609: l_activity_id wf_item_activity_statuses_v.activity_id%type;

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

Line 1629: from wf_item_activity_statuses process

1625: ,p_result_code in varchar2
1626: ) is
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

Line 1632: ,wf_item_activity_statuses result

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
1636: and activity.instance_id = process.process_activity

Line 1660: from wf_item_activity_statuses process

1656: ,p_item_type in wf_items.item_type%type
1657: ) is
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

Line 1677: -- that we don't need to loop through the wf_item_activity_statuses_v to

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

Line 1679: -- wf_item_activity_statuses_v has a lot of records to process.

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

Line 1718: l_activity_result_code wf_item_activity_statuses.activity_result_code%type;

1714: and value.name = 'P_PRIMARY_FLAG'
1715: and value.varchar2_value = csr_p_primary_flag;
1716:
1717:
1718: l_activity_result_code wf_item_activity_statuses.activity_result_code%type;
1719: l_activity_result_code_in wf_item_activity_statuses.activity_result_code%type
1720: default null;
1721: api_name_in hr_api_transaction_steps.api_name%type default null;
1722: l_trans_step_id hr_api_transaction_steps.transaction_step_id%type

Line 1719: l_activity_result_code_in wf_item_activity_statuses.activity_result_code%type

1715: and value.varchar2_value = csr_p_primary_flag;
1716:
1717:
1718: l_activity_result_code wf_item_activity_statuses.activity_result_code%type;
1719: l_activity_result_code_in wf_item_activity_statuses.activity_result_code%type
1720: default null;
1721: api_name_in hr_api_transaction_steps.api_name%type default null;
1722: l_trans_step_id hr_api_transaction_steps.transaction_step_id%type
1723: default null;

Line 1978: from wf_item_activity_statuses wias,

1974: -- ICX session id. Please check the LLD for details.
1975: -- The changes to the program are tracked through bug # 2380121
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