DBA Data[Home] [Help]

APPS.CSP_PICK_UTILS dependencies on STANDARD

Line 1060: -- Standard call to check for call compatibility.

1056: IF fnd_api.to_boolean(p_init_msg_list) THEN
1057: FND_MSG_PUB.initialize;
1058: END IF;
1059:
1060: -- Standard call to check for call compatibility.
1061: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1062: p_api_version_number,
1063: l_api_name,
1064: G_PKG_NAME)

Line 1543: STANDARD_OPERATION_ID ,

1539: TASK_GROUP_ID ,
1540: PICK_SLIP_NUMBER ,
1541: RESERVATION_ID ,
1542: TRANSACTION_STATUS ,
1543: STANDARD_OPERATION_ID ,
1544: TASK_PRIORITY ,
1545: -- ADDED by phegde 02/23
1546: WMS_TASK_TYPE ,
1547: PARENT_LINE_ID

Line 1561: -- Standard call to check for call compatibility.

1557: IF fnd_api.to_boolean(p_init_msg_list) THEN
1558: FND_MSG_PUB.initialize;
1559: END IF;
1560:
1561: -- Standard call to check for call compatibility.
1562: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1563: p_api_version_number,
1564: l_api_name,
1565: G_PKG_NAME)

Line 1745: -- Standard call to check for call compatibility.

1741: IF fnd_api.to_boolean(p_init_msg_list) THEN
1742: FND_MSG_PUB.initialize;
1743: END IF;
1744:
1745: -- Standard call to check for call compatibility.
1746: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1747: p_api_version_number,
1748: l_api_name,
1749: G_PKG_NAME)

Line 1858: p_Standard_Deviation Number,

1854: p_Service_Level Number,
1855: p_Item_Cost Number,
1856: p_Awu Number,
1857: p_Lead_time Number,
1858: p_Standard_Deviation Number,
1859: p_Safety_Stock_Flag Varchar2,
1860: p_Asl_Flag Varchar2) RETURN NUMBER Is
1861: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is
1862: Select SAFETY_FACTOR

Line 1918: Else l_safety_Stock := ROUND(nvl(l_Safety_Factor,0) * nvl(p_Standard_Deviation,0),4);

1914: G_Safety_Factor := l_Safety_factor;
1915: -- Calculate Safety Stock
1916: If nvl(l_Safety_Stock_flag,'N') = 'N' Then
1917: l_Safety_Stock := 0;
1918: Else l_safety_Stock := ROUND(nvl(l_Safety_Factor,0) * nvl(p_Standard_Deviation,0),4);
1919: End If;
1920: -- Calculate Reorder Point
1921: l_Reorder_Point := nvl(p_Awu/7 * p_Lead_Time,0) + nvl(l_Safety_Stock,0);
1922: -- Calculate Minimum and Maximum Quantities

Line 1948: p_Standard_Deviation Number,

1944: p_Service_Level Number,
1945: p_Item_Cost Number,
1946: p_Awu Number,
1947: p_Lead_time Number,
1948: p_Standard_Deviation Number,
1949: p_Safety_Stock_Flag Varchar2,
1950: p_Asl_Flag Varchar2) RETURN NUMBER Is
1951:
1952: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is

Line 2005: Else l_safety_Stock := ROUND(nvl(l_Safety_Factor,0) * nvl(p_Standard_Deviation,0),4);

2001: G_Safety_Factor := l_Safety_factor;
2002: -- Calculate Safety Stock
2003: If nvl(l_Safety_Stock_flag,'N') = 'N' Then
2004: l_Safety_Stock := 0;
2005: Else l_safety_Stock := ROUND(nvl(l_Safety_Factor,0) * nvl(p_Standard_Deviation,0),4);
2006: End If;
2007: -- Calculate Reorder Point
2008: l_Reorder_Point := nvl(p_Awu/7 * p_Lead_Time,0) + nvl(l_Safety_Stock,0);
2009: -- Calculate Minimum and Maximum Quantities

Line 2035: p_Standard_Deviation Number,

2031: p_Service_Level Number,
2032: p_Item_Cost Number,
2033: p_Awu Number,
2034: p_Lead_time Number,
2035: p_Standard_Deviation Number,
2036: p_Safety_Stock_Flag Varchar2,
2037: p_Asl_Flag Varchar2) RETURN NUMBER Is
2038:
2039: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is

Line 2092: Else l_safety_Stock := ROUND(nvl(l_Safety_Factor,0) * nvl(p_Standard_Deviation,0),4);

2088: G_Safety_Factor := l_Safety_factor;
2089: -- Calculate Safety Stock
2090: If nvl(l_Safety_Stock_flag,'N') = 'N' Then
2091: l_Safety_Stock := 0;
2092: Else l_safety_Stock := ROUND(nvl(l_Safety_Factor,0) * nvl(p_Standard_Deviation,0),4);
2093: End If;
2094: -- Calculate Reorder Point
2095: l_Reorder_Point := nvl(p_Awu/7 * p_Lead_Time,0) + nvl(l_Safety_Stock,0);
2096: -- Calculate Minimum and Maximum Quantities

Line 2122: p_Standard_Deviation Number,

2118: p_Service_Level Number,
2119: p_Item_Cost Number,
2120: p_Awu Number,
2121: p_Lead_time Number,
2122: p_Standard_Deviation Number,
2123: p_Safety_Stock_Flag Varchar2,
2124: p_Asl_Flag Varchar2) RETURN NUMBER Is
2125:
2126: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is

Line 2190: p_Standard_Deviation Number,

2186: p_Service_Level Number,
2187: p_Item_Cost Number,
2188: p_Awu Number,
2189: p_Lead_time Number,
2190: p_Standard_Deviation Number,
2191: p_Safety_Stock_Flag Varchar2,
2192: p_Asl_Flag Varchar2) RETURN NUMBER Is
2193: Cursor c_Safety_Factor(p_SL Number,p_Exp Number) Is
2194: Select SAFETY_FACTOR

Line 2250: Else l_safety_Stock := ROUND(nvl(l_Safety_Factor,0) * nvl(p_Standard_Deviation,0),4);

2246: G_Safety_Factor := l_Safety_factor;
2247: -- Calculate Safety Stock
2248: If nvl(l_Safety_Stock_flag,'N') = 'N' Then
2249: l_Safety_Stock := 0;
2250: Else l_safety_Stock := ROUND(nvl(l_Safety_Factor,0) * nvl(p_Standard_Deviation,0),4);
2251: End If;
2252:
2253: G_safety_Stock := l_safety_stock;
2254: