DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_WF_STD

Line 1321: WSH_WF_STD.Raise_Event(

1317: last_update_login = l_login_id
1318: WHERE delivery_detail_id = l_rel_delivery_detail_id(i);
1319:
1320: --Raise Event : Pick To Pod Workflow
1321: WSH_WF_STD.Raise_Event(
1322: p_entity_type => 'LINE',
1323: p_entity_id => l_rel_delivery_detail_id(i) ,
1324: p_event => 'oracle.apps.wsh.line.gen.staged' ,
1325: --p_parameters IN wf_parameter_list_t DEFAULT NULL,

Line 1331: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);

1327: x_return_status => l_wf_rs ) ;
1328:
1329: IF l_debug_on THEN
1330: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1331: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
1332: END IF;
1333: --Done Raise Event: Pick To Pod Workflow
1334: END LOOP;
1335:

Line 1628: WSH_WF_STD.Raise_Event(

1624: END IF;
1625: --DBI
1626:
1627: --Raise Event : Pick To Pod Workflow
1628: WSH_WF_STD.Raise_Event(
1629: p_entity_type => 'LINE',
1630: p_entity_id => g_del_detail_ids(i) ,
1631: p_event => 'oracle.apps.wsh.line.gen.releasedtowarehouse' ,
1632: --p_parameters IN wf_parameter_list_t DEFAULT NULL,

Line 1637: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);

1633: p_organization_id => p_organization_id,
1634: x_return_status => l_wf_rs ) ;
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1637: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
1638: END IF;
1639:
1640: OPEN c_get_picked_lines_count( g_del_detail_ids(i) );
1641: FETCH c_get_picked_lines_count INTO l_count_picked_lines, l_delv_id ;

Line 1644: WSH_WF_STD.Raise_Event(

1640: OPEN c_get_picked_lines_count( g_del_detail_ids(i) );
1641: FETCH c_get_picked_lines_count INTO l_count_picked_lines, l_delv_id ;
1642: IF (c_get_picked_lines_count%FOUND) THEN
1643: IF ( l_count_picked_lines=1) THEN --If it is the first line in a delivery to be released
1644: WSH_WF_STD.Raise_Event(
1645: p_entity_type => 'DELIVERY',
1646: p_entity_id => l_delv_id ,
1647: p_event => 'oracle.apps.wsh.delivery.pik.pickinitiated' ,
1648: p_organization_id => p_organization_id,

Line 1652: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);

1648: p_organization_id => p_organization_id,
1649: x_return_status => l_wf_rs ) ;
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1652: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
1653: END IF;
1654: END IF;
1655: END IF;
1656: CLOSE c_get_picked_lines_count;