APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 612: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;

608: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
609:
610: l_status_type eng_engineering_changes.status_type%TYPE;
611:
612: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;
613:
614: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
615: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
616:

Line 1289: l_line_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;

1285:
1286:
1287: l_change_line_id NUMBER ;
1288: l_line_wf_route_id NUMBER ;
1289: l_line_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;
1290:
1291:
1292: -- Select Line Workflow to be started for the passed status_code
1293: CURSOR c_line_wf ( c_change_id IN NUMBER

Line 1558: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;

1554: l_action_id eng_change_actions.action_id%TYPE;
1555:
1556: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
1557: l_wf_route_temp_id eng_lifecycle_statuses.change_wf_route_template_id%TYPE;
1558: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;
1559:
1560: l_chg_notice eng_engineering_changes.change_notice%TYPE;
1561: l_org_id eng_engineering_changes.organization_id%TYPE;
1562: l_request_id NUMBER;