eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_AUTO_ASLMSL_PVT dependencies on STANDARD

Line 136: -- Standard call to get message count and if count is 1, get message info.

132: -- Initialize API return status to SUCCESS
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:
135:
136: -- Standard call to get message count and if count is 1, get message info.
137: FND_MSG_PUB.Count_And_Get
138: ( p_count => x_msg_count,
139: p_data => x_msg_data
140: );

Line 276: -- Standard Start of API savepoint

272: from csp_planning_parameters cpp
273: Where cpp.level_id like p_Level_Id || '%' And cpp.node_type in ('ORGANIZATION_WH','SUBINVENTORY'));
274: End If;
275: commit;
276: -- Standard Start of API savepoint
277: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;
278:
279: if p_api_version_number <> 2.0 then
280: -- Standard call to check for call compatibility.

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

276: -- Standard Start of API savepoint
277: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;
278:
279: if p_api_version_number <> 2.0 then
280: -- Standard call to check for call compatibility.
281: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
282: p_api_version_number,
283: l_api_name,
284: G_PKG_NAME) THEN

Line 407: STANDARD_DEVIATION,

403: RAW_AWU,
404: AWU,
405: ITEM_COST,
406: LEAD_TIME,
407: STANDARD_DEVIATION,
408: PROCESS_STATUS,
409: EXTERNAL_DATA,
410: CREATION_DATE,
411: CREATED_BY,

Line 464: STANDARD_DEVIATION,

460: RAW_AWU,
461: AWU,
462: ITEM_COST,
463: LEAD_TIME,
464: STANDARD_DEVIATION,
465: PROCESS_STATUS,
466: EXTERNAL_DATA,
467: CREATION_DATE,
468: CREATED_BY,

Line 520: STANDARD_DEVIATION,

516: RAW_AWU,
517: AWU,
518: ITEM_COST,
519: LEAD_TIME,
520: STANDARD_DEVIATION,
521: PROCESS_STATUS,
522: EXTERNAL_DATA,
523: PLANNING_PARAMETERS_ID,
524: CREATION_DATE,

Line 557: sum(nvl(cuh.standard_deviation,0)),

553: decode(nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0),0,
554: decode(nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0),0,
555: nvl(msi.preprocessing_lead_time,0) + nvl(msi.processing_lead_time,0) + nvl(msi.postprocessing_lead_time,0), nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0)),
556: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))),
557: sum(nvl(cuh.standard_deviation,0)),
558: 'O',
559: 'N',
560: cpp.planning_parameters_id,
561: sysdate,

Line 652: ROUND(DECODE(SIGN(AWU),-1,0,ROUND(AWU,4))/7 * cuh.lead_time + DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0)) Min_quantity,

648: sq.MAX_QUANTITY
649: FROM (Select cuh.Inventory_Item_Id,
650: cuh.Organization_Id,
651: cuh.Secondary_Inventory,
652: ROUND(DECODE(SIGN(AWU),-1,0,ROUND(AWU,4))/7 * cuh.lead_time + DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0)) Min_quantity,
653: ROUND(DECODE(SIGN(AWU),-1,0,ROUND(AWU,4))/7 * cuh.lead_time +
654: DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0) +
655: DECODE(DECODE(SIGN(cuh.AWU),-1,0,cuh.AWU),0,0,DECODE(cuh.item_cost,0,0,
656: DECODE(cpp.edq_factor,0,0,ROUND(cpp.Edq_Factor * (SQRT(52 * cuh.Awu * cuh.Item_Cost)/cuh.Item_Cost),4))))) max_quantity

Line 654: DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0) +

650: cuh.Organization_Id,
651: cuh.Secondary_Inventory,
652: ROUND(DECODE(SIGN(AWU),-1,0,ROUND(AWU,4))/7 * cuh.lead_time + DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0)) Min_quantity,
653: ROUND(DECODE(SIGN(AWU),-1,0,ROUND(AWU,4))/7 * cuh.lead_time +
654: DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0) +
655: DECODE(DECODE(SIGN(cuh.AWU),-1,0,cuh.AWU),0,0,DECODE(cuh.item_cost,0,0,
656: DECODE(cpp.edq_factor,0,0,ROUND(cpp.Edq_Factor * (SQRT(52 * cuh.Awu * cuh.Item_Cost)/cuh.Item_Cost),4))))) max_quantity
657: from CSP_USAGE_HEADERS cuh,
658: CSP_PLANNING_PARAMETERS cpp,

Line 690: DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0)) min_quantity,

686: sq.MAX_QUANTITY
687: FROM (Select cuh.inventory_item_id,
688: cuh.organization_id,
689: ROUND(DECODE(SIGN(AWU),-1,0,ROUND(AWU,4))/7 * cuh.lead_time +
690: DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0)) min_quantity,
691: ROUND(DECODE(SIGN(AWU),-1,0,ROUND(AWU,4))/7 * cuh.lead_time +
692: DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0) +
693: DECODE(DECODE(SIGN(cuh.AWU),-1,0,cuh.AWU),0,0,DECODE(cuh.item_cost,0,0,
694: DECODE(cpp.edq_factor,0,0,ROUND(cpp.Edq_Factor * (SQRT(52 * cuh.Awu * cuh.Item_Cost)/cuh.Item_Cost),4))))) max_quantity

Line 692: DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0) +

688: cuh.organization_id,
689: ROUND(DECODE(SIGN(AWU),-1,0,ROUND(AWU,4))/7 * cuh.lead_time +
690: DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0)) min_quantity,
691: ROUND(DECODE(SIGN(AWU),-1,0,ROUND(AWU,4))/7 * cuh.lead_time +
692: DECODE(cpp.safety_stock_flag,'Y',ROUND(csf.Safety_Factor * nvl(cuh.Standard_Deviation,0),4),0) +
693: DECODE(DECODE(SIGN(cuh.AWU),-1,0,cuh.AWU),0,0,DECODE(cuh.item_cost,0,0,
694: DECODE(cpp.edq_factor,0,0,ROUND(cpp.Edq_Factor * (SQRT(52 * cuh.Awu * cuh.Item_Cost)/cuh.Item_Cost),4))))) max_quantity
695: from CSP_USAGE_HEADERS cuh,
696: CSP_PLANNING_PARAMETERS cpp,

Line 841: -- Standard check for p_commit

837: --
838: -- End of API body
839: --
840:
841: -- Standard check for p_commit
842: IF FND_API.to_Boolean( l_commit )
843: THEN
844: COMMIT WORK;
845: END IF;

Line 847: -- Standard call to get message count and if count is 1, get message info.

843: THEN
844: COMMIT WORK;
845: END IF;
846:
847: -- Standard call to get message count and if count is 1, get message info.
848: FND_MSG_PUB.Count_And_Get
849: ( p_count => x_msg_count,
850: p_data => x_msg_data
851: );

Line 931: -- Standard Start of API savepoint

927: l_status varchar2(1);
928: l_industry varchar2(1);
929: l_oracle_schema varchar2(30);
930: BEGIN
931: -- Standard Start of API savepoint
932: SAVEPOINT PURGE_DATA_PVT;
933:
934: -- Standard call to check for call compatibility.
935: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

930: BEGIN
931: -- Standard Start of API savepoint
932: SAVEPOINT PURGE_DATA_PVT;
933:
934: -- Standard call to check for call compatibility.
935: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
936: p_api_version_number,
937: l_api_name,
938: G_PKG_NAME)

Line 981: -- Standard check for p_commit

977: --
978: -- End of API body
979: --
980:
981: -- Standard check for p_commit
982: IF FND_API.to_Boolean( p_commit )
983: THEN
984: COMMIT WORK;
985: END IF;

Line 989: -- Standard call to get message count and if count is 1, get message info.

985: END IF;
986:
987:
988:
989: -- Standard call to get message count and if count is 1, get message info.
990: FND_MSG_PUB.Count_And_Get
991: ( p_count => x_msg_count,
992: p_data => x_msg_data
993: );

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

1061: l_oracle_schema varchar2(30);
1062: BEGIN
1063: -- Alter session
1064: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
1065: -- Standard call to check for call compatibility.
1066: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1067: p_api_version_number,
1068: l_api_name,
1069: G_PKG_NAME)

Line 1110: -- Standard Start of API savepoint

1106: If G_LAST_RUN_DATE < trunc(sysdate) - 1 Then
1107: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
1108: -- Delete from CSP_SUPPLY_CHAIN
1109: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUPPLY_CHAIN';
1110: -- Standard Start of API savepoint
1111: SAVEPOINT CREATE_USAGE_PVT;
1112: -- Build Supply Chain
1113: Create_Supply_Chain (
1114: P_Api_Version_Number => 1.0,

Line 1184: -- Standard call to get message count and if count is 1, get message info.

1180:
1181: --
1182: -- End of API body
1183: --
1184: -- Standard call to get message count and if count is 1, get message info.
1185: FND_MSG_PUB.Count_And_Get
1186: ( p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );

Line 1423: l_Standard_Deviation NUMBER := 0;

1419: l_Usage_Qty_Sum NUMBER := 0;
1420: l_weeks NUMBER := 0;
1421: l_Awu NUMBER := 0;
1422: l_Variance NUMBER := 0;
1423: l_Standard_Deviation NUMBER := 0;
1424:
1425: l_Usage_Id Number;
1426: l_index Number := 0;
1427: l_count Number := 0;

Line 1434: -- Standard Start of API savepoint

1430: l_Msg_Count NUMBER;
1431: l_Msg_Data Varchar2(2000);
1432:
1433: BEGIN
1434: -- Standard Start of API savepoint
1435: SAVEPOINT CALCULATE_FORECAST_PVT;
1436:
1437: -- Standard call to check for call compatibility.
1438: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1433: BEGIN
1434: -- Standard Start of API savepoint
1435: SAVEPOINT CALCULATE_FORECAST_PVT;
1436:
1437: -- Standard call to check for call compatibility.
1438: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1439: p_api_version_number,
1440: l_api_name,
1441: G_PKG_NAME)

Line 1562: -- Calculate Standard Deviation

1558: l_Usage_Data_Count := l_Usage_Qty_Tbl.COUNT;
1559: l_weeks := (l_Prev_Rec.Period_Size * l_Prev_Rec.Forecast_Periods)/7;
1560: l_Awu := ROUND((l_Forecast_Quantity/l_weeks),4);
1561:
1562: -- Calculate Standard Deviation
1563: l_Variance := 0;
1564: If l_Usage_Data_Count > 1 Then
1565: l_Variance :=
1566: (l_Usage_Qty_Sum - ((l_Usage_Quantity * l_Usage_Quantity) /l_Usage_Data_Count))/(l_Usage_Data_Count - 1);

Line 1568: l_Standard_Deviation := ROUND(SQRT(NVL(l_Variance,0)),4);

1564: If l_Usage_Data_Count > 1 Then
1565: l_Variance :=
1566: (l_Usage_Qty_Sum - ((l_Usage_Quantity * l_Usage_Quantity) /l_Usage_Data_Count))/(l_Usage_Data_Count - 1);
1567: End If;
1568: l_Standard_Deviation := ROUND(SQRT(NVL(l_Variance,0)),4);
1569: INSERT INTO CSP_USAGE_HEADERS
1570: (USAGE_HEADER_ID,
1571: INVENTORY_ITEM_ID,
1572: ORGANIZATION_ID,

Line 1577: STANDARD_DEVIATION,

1573: SECONDARY_INVENTORY,
1574: HEADER_DATA_TYPE,
1575: RAW_AWU,
1576: AWU,
1577: STANDARD_DEVIATION,
1578: LEAD_TIME,
1579: PROCESS_STATUS,
1580: EXTERNAL_DATA,
1581: COMMENTS,

Line 1595: l_Standard_Deviation,

1591: l_prev_rec.Subinventory_code,
1592: l_prev_rec.History_Data_Type,
1593: NULL,
1594: l_Awu,
1595: l_Standard_Deviation,
1596: NULL,
1597: 'O',
1598: 'N',
1599: NULL,

Line 1616: l_Standard_Deviation := 0;

1612: l_Usage_Qty_Sum := 0;
1613: l_weeks := 0;
1614: l_Awu := 0;
1615: l_Variance := 0;
1616: l_Standard_Deviation := 0;
1617: l_Usage_Qty_Tbl.Delete;
1618: l_Weighted_Avg_Tbl.Delete;
1619: END IF;
1620: l_Usage_Qty_Tbl(l_count) := l_Usage_Details_Rec.Quantity;

Line 1636: -- Standard check for p_commit

1632: --
1633: -- End of API body
1634: --
1635:
1636: -- Standard check for p_commit
1637: IF FND_API.to_Boolean( p_commit )
1638: THEN
1639: COMMIT WORK;
1640: END IF;

Line 1643: -- Standard call to get message count and if count is 1, get message info.

1639: COMMIT WORK;
1640: END IF;
1641:
1642:
1643: -- Standard call to get message count and if count is 1, get message info.
1644: FND_MSG_PUB.Count_And_Get
1645: ( p_count => x_msg_count,
1646: p_data => x_msg_data
1647: );

Line 1710: -- Standard Start of API savepoint

1706: l_Msg_Count NUMBER;
1707: l_Msg_Data Varchar2(2000);
1708:
1709: BEGIN
1710: -- Standard Start of API savepoint
1711: SAVEPOINT CALCULATE_PNORM_PVT;
1712:
1713: -- Standard call to check for call compatibility.
1714: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1709: BEGIN
1710: -- Standard Start of API savepoint
1711: SAVEPOINT CALCULATE_PNORM_PVT;
1712:
1713: -- Standard call to check for call compatibility.
1714: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1715: p_api_version_number,
1716: l_api_name,
1717: G_PKG_NAME)

Line 1768: -- Standard check for p_commit

1764: and csi.organization_id (+) = cppf.organization_id
1765: and csi.sub_inventory_code (+) = cppf.secondary_inventory;
1766:
1767:
1768: -- Standard check for p_commit
1769: IF FND_API.to_Boolean( p_commit )
1770: THEN
1771: COMMIT WORK;
1772: END IF;

Line 1775: -- Standard call to get message count and if count is 1, get message info.

1771: COMMIT WORK;
1772: END IF;
1773:
1774:
1775: -- Standard call to get message count and if count is 1, get message info.
1776: FND_MSG_PUB.Count_And_Get
1777: ( p_count => x_msg_count,
1778: p_data => x_msg_data
1779: );

Line 1842: -- Standard Start of API savepoint

1838: l_Msg_Count NUMBER;
1839: l_Msg_Data Varchar2(2000);
1840:
1841: BEGIN
1842: -- Standard Start of API savepoint
1843: SAVEPOINT CALCULATE_NPROD_PVT;
1844:
1845: -- Standard call to check for call compatibility.
1846: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1841: BEGIN
1842: -- Standard Start of API savepoint
1843: SAVEPOINT CALCULATE_NPROD_PVT;
1844:
1845: -- Standard call to check for call compatibility.
1846: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1847: p_api_version_number,
1848: l_api_name,
1849: G_PKG_NAME)

Line 1899: -- Standard check for p_commit

1895: and csi.inventory_item_id(+) = cnpp.inventory_item_id
1896: and csi.organization_id (+) = cnpp.organization_id
1897: and csi.sub_inventory_code (+) = cnpp.secondary_inventory;
1898:
1899: -- Standard check for p_commit
1900: IF FND_API.to_Boolean( p_commit )
1901: THEN
1902: COMMIT WORK;
1903: END IF;

Line 1906: -- Standard call to get message count and if count is 1, get message info.

1902: COMMIT WORK;
1903: END IF;
1904:
1905:
1906: -- Standard call to get message count and if count is 1, get message info.
1907: FND_MSG_PUB.Count_And_Get
1908: ( p_count => x_msg_count,
1909: p_data => x_msg_data
1910: );

Line 1973: -- Standard Start of API savepoint

1969: l_Msg_Count NUMBER;
1970: l_Msg_Data Varchar2(2000);
1971:
1972: BEGIN
1973: -- Standard Start of API savepoint
1974: SAVEPOINT CALCULATE_TNORM_PVT;
1975:
1976: -- Standard call to check for call compatibility.
1977: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1972: BEGIN
1973: -- Standard Start of API savepoint
1974: SAVEPOINT CALCULATE_TNORM_PVT;
1975:
1976: -- Standard call to check for call compatibility.
1977: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1978: p_api_version_number,
1979: l_api_name,
1980: G_PKG_NAME)

Line 2030: -- Standard check for p_commit

2026: and csi.sub_inventory_code(+) = curos.secondary_inventory
2027: group by nvl(csi.item_supplied,curos.inventory_item_id),
2028: curos.organization_id,curos.secondary_inventory,curos.awu;
2029:
2030: -- Standard check for p_commit
2031: IF FND_API.to_Boolean( p_commit )
2032: THEN
2033: COMMIT WORK;
2034: END IF;

Line 2037: -- Standard call to get message count and if count is 1, get message info.

2033: COMMIT WORK;
2034: END IF;
2035:
2036:
2037: -- Standard call to get message count and if count is 1, get message info.
2038: FND_MSG_PUB.Count_And_Get
2039: ( p_count => x_msg_count,
2040: p_data => x_msg_data
2041: );

Line 2123: -- Standard Start of API savepoint

2119: l_industry varchar2(1);
2120: l_oracle_schema varchar2(30);
2121:
2122: BEGIN
2123: -- Standard Start of API savepoint
2124: SAVEPOINT CREATE_SUPPLY_CHAIN_PVT;
2125:
2126: -- Standard call to check for call compatibility.
2127: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

2122: BEGIN
2123: -- Standard Start of API savepoint
2124: SAVEPOINT CREATE_SUPPLY_CHAIN_PVT;
2125:
2126: -- Standard call to check for call compatibility.
2127: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2128: p_api_version_number,
2129: l_api_name,
2130: G_PKG_NAME)

Line 2272: -- Standard check for p_commit

2268: --
2269: -- End of API body
2270: --
2271:
2272: -- Standard check for p_commit
2273: IF FND_API.to_Boolean( p_commit )
2274: THEN
2275: COMMIT WORK;
2276: END IF;

Line 2279: -- Standard call to get message count and if count is 1, get message info.

2275: COMMIT WORK;
2276: END IF;
2277:
2278:
2279: -- Standard call to get message count and if count is 1, get message info.
2280: FND_MSG_PUB.Count_And_Get
2281: ( p_count => x_msg_count,
2282: p_data => x_msg_data
2283: );

Line 2358: -- Standard Start of API savepoint

2354: g_default_flag number := 1;
2355: l_period_size number := 0;
2356:
2357: BEGIN
2358: -- Standard Start of API savepoint
2359: SAVEPOINT CREATE_SUPPLY_CHAIN_PVT;
2360:
2361: -- Standard call to check for call compatibility.
2362: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

2357: BEGIN
2358: -- Standard Start of API savepoint
2359: SAVEPOINT CREATE_SUPPLY_CHAIN_PVT;
2360:
2361: -- Standard call to check for call compatibility.
2362: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2363: p_api_version_number,
2364: l_api_name,
2365: G_PKG_NAME)

Line 2528: -- Standard check for p_commit

2524: --
2525: -- End of API body
2526: --
2527:
2528: -- Standard check for p_commit
2529: IF FND_API.to_Boolean( p_commit )
2530: THEN
2531: COMMIT WORK;
2532: END IF;

Line 2535: -- Standard call to get message count and if count is 1, get message info.

2531: COMMIT WORK;
2532: END IF;
2533:
2534:
2535: -- Standard call to get message count and if count is 1, get message info.
2536: FND_MSG_PUB.Count_And_Get
2537: ( p_count => x_msg_count,
2538: p_data => x_msg_data
2539: );

Line 2616: -- Standard Start of API savepoint

2612: l_Msg_Count NUMBER;
2613: l_Msg_Data Varchar2(2000);
2614:
2615: BEGIN
2616: -- Standard Start of API savepoint
2617: SAVEPOINT CREATE_USAGE_HIST_PVT;
2618:
2619:
2620: -- Initialize API return status to SUCCESS

Line 2729: -- Standard check for p_commit

2725: --
2726: -- End of API body
2727: --
2728:
2729: -- Standard check for p_commit
2730: IF FND_API.to_Boolean( p_commit )
2731: THEN
2732: COMMIT WORK;
2733: END IF;

Line 2736: -- Standard call to get message count and if count is 1, get message info.

2732: COMMIT WORK;
2733: END IF;
2734:
2735:
2736: -- Standard call to get message count and if count is 1, get message info.
2737: FND_MSG_PUB.Count_And_Get
2738: ( p_count => x_msg_count,
2739: p_data => x_msg_data
2740: );

Line 3035: -- Standard Start of API savepoint

3031: X_Msg_Data VARCHAR2(2000);
3032:
3033:
3034: BEGIN
3035: -- Standard Start of API savepoint
3036: SAVEPOINT CREATE_ROLLUP_PVT;
3037:
3038: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
3039:

Line 3072: -- Standard check for p_commit

3068: --
3069: -- End of API body
3070: --
3071:
3072: -- Standard check for p_commit
3073: IF FND_API.to_Boolean( l_commit )
3074: THEN
3075: COMMIT WORK;
3076: END IF;

Line 3078: -- Standard call to get message count and if count is 1, get message info.

3074: THEN
3075: COMMIT WORK;
3076: END IF;
3077:
3078: -- Standard call to get message count and if count is 1, get message info.
3079: FND_MSG_PUB.Count_And_Get
3080: ( p_count => x_msg_count,
3081: p_data => x_msg_data
3082: );

Line 3140: select nvl(cuh.standard_deviation,0) standard_deviation,

3136: X_Msg_Count OUT NOCOPY NUMBER,
3137: X_Msg_Data OUT NOCOPY VARCHAR2
3138: ) IS
3139: cursor c_usage_headers(p_item_id number,p_org_id number) is
3140: select nvl(cuh.standard_deviation,0) standard_deviation,
3141: cuh.awu ,
3142: cuh.item_cost,
3143: cuh.lead_time,
3144: cpp.edq_factor,

Line 3174: -- Standard Start of API savepoint

3170: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3171:
3172:
3173: BEGIN
3174: -- Standard Start of API savepoint
3175: SAVEPOINT CALCULATE_NEEDBY_PVT;
3176:
3177: -- Standard call to check for call compatibility.
3178: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

3173: BEGIN
3174: -- Standard Start of API savepoint
3175: SAVEPOINT CALCULATE_NEEDBY_PVT;
3176:
3177: -- Standard call to check for call compatibility.
3178: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3179: p_api_version_number,
3180: l_api_name,
3181: G_PKG_NAME)

Line 3211: p_standard_deviation => l_usage_headers_rec.standard_deviation,

3207: p_service_level => l_usage_headers_rec.service_level,
3208: p_item_cost => l_usage_headers_rec.item_cost,
3209: p_awu => l_usage_headers_rec.awu,
3210: p_lead_time => l_usage_headers_rec.lead_time,
3211: p_standard_deviation => l_usage_headers_rec.standard_deviation,
3212: p_safety_stock_flag => 'Y',
3213: p_asl_flag => NULL);
3214: If nvl(l_usage_headers_rec.awu,0) > 0 Then
3215: X_needby_date := trunc(sysdate) +

Line 3227: -- Standard check for p_commit

3223: --
3224: -- End of API body
3225: --
3226:
3227: -- Standard check for p_commit
3228: IF FND_API.to_Boolean( l_commit )
3229: THEN
3230: COMMIT WORK;
3231: END IF;

Line 3233: -- Standard call to get message count and if count is 1, get message info.

3229: THEN
3230: COMMIT WORK;
3231: END IF;
3232:
3233: -- Standard call to get message count and if count is 1, get message info.
3234: FND_MSG_PUB.Count_And_Get
3235: ( p_count => x_msg_count,
3236: p_data => x_msg_data
3237: );