DBA Data[Home] [Help]

APPS.PV_WORKFLOW_PUB dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1179: -- this can be written using just joins (wf_item_activity_statuses,

1175: l_return_status varchar2(1);
1176: l_msg_count number;
1177: l_msg_data varchar2(2000);
1178:
1179: -- this can be written using just joins (wf_item_activity_statuses,
1180: -- wf_process_activities, wf_activity_transitions) but if the
1181: -- timeout transition in WF is removed, it will not work
1182:
1183: cursor lc_chk_for_timeout (pc_itemtype varchar2,

Line 1188: from wf_item_activity_statuses a

1184: pc_itemkey varchar2,
1185: pc_from_activity_name varchar2,
1186: pc_to_activity_id number) is
1187: select a.activity_result_code
1188: from wf_item_activity_statuses a
1189: where a.item_type = pc_itemtype
1190: and a.item_key = pc_itemkey
1191: and a.process_activity =
1192: (select d.from_process_activity