DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_WF_STD

Line 1382: WSH_WF_STD.Raise_Event(

1378: last_update_login = l_login_id
1379: WHERE delivery_detail_id = l_rel_delivery_detail_id(i);
1380:
1381: --Raise Event : Pick To Pod Workflow
1382: WSH_WF_STD.Raise_Event(
1383: p_entity_type => 'LINE',
1384: p_entity_id => l_rel_delivery_detail_id(i) ,
1385: p_event => 'oracle.apps.wsh.line.gen.staged' ,
1386: --p_parameters IN wf_parameter_list_t DEFAULT NULL,

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

1388: x_return_status => l_wf_rs ) ;
1389:
1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1392: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
1393: END IF;
1394: --Done Raise Event: Pick To Pod Workflow
1395: END LOOP;
1396:

Line 1689: WSH_WF_STD.Raise_Event(

1685: END IF;
1686: --DBI
1687:
1688: --Raise Event : Pick To Pod Workflow
1689: WSH_WF_STD.Raise_Event(
1690: p_entity_type => 'LINE',
1691: p_entity_id => g_del_detail_ids(i) ,
1692: p_event => 'oracle.apps.wsh.line.gen.releasedtowarehouse' ,
1693: --p_parameters IN wf_parameter_list_t DEFAULT NULL,

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

1694: p_organization_id => p_organization_id,
1695: x_return_status => l_wf_rs ) ;
1696: IF l_debug_on THEN
1697: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1698: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
1699: END IF;
1700:
1701: OPEN c_get_picked_lines_count( g_del_detail_ids(i) );
1702: FETCH c_get_picked_lines_count INTO l_count_picked_lines, l_delv_id ;

Line 1705: WSH_WF_STD.Raise_Event(

1701: OPEN c_get_picked_lines_count( g_del_detail_ids(i) );
1702: FETCH c_get_picked_lines_count INTO l_count_picked_lines, l_delv_id ;
1703: IF (c_get_picked_lines_count%FOUND) THEN
1704: IF ( l_count_picked_lines=1) THEN --If it is the first line in a delivery to be released
1705: WSH_WF_STD.Raise_Event(
1706: p_entity_type => 'DELIVERY',
1707: p_entity_id => l_delv_id ,
1708: p_event => 'oracle.apps.wsh.delivery.pik.pickinitiated' ,
1709: p_organization_id => p_organization_id,

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

1709: p_organization_id => p_organization_id,
1710: x_return_status => l_wf_rs ) ;
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1713: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
1714: END IF;
1715: END IF;
1716: END IF;
1717: CLOSE c_get_picked_lines_count;