APPS.CSP_FAILURE_RATES_PVT dependencies on CSP_FAILURE_RATES_PVT

Line 1: PACKAGE BODY CSP_FAILURE_RATES_PVT as

1: PACKAGE BODY CSP_FAILURE_RATES_PVT as
2: /* $Header: cspvfrtb.pls 120.0 2005/05/25 11:37:49 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSP_FAILURE_RATES_PVT
5: -- Purpose :

Line 4: -- Package name : CSP_FAILURE_RATES_PVT

1: PACKAGE BODY CSP_FAILURE_RATES_PVT as
2: /* $Header: cspvfrtb.pls 120.0 2005/05/25 11:37:49 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSP_FAILURE_RATES_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_FAILURE_RATES_PVT';

5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_FAILURE_RATES_PVT';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspvfrtb.pls';
11:
12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
13: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 73: l_api_name CONSTANT VARCHAR2(30) := 'csp_failure_rates_pvt';

69: and cplp.level_id like l_level_id||'%'
70: and cdl.service_date > sysdate - l_history_size
71: group by cdl.inventory_item_id;
72:
73: l_api_name CONSTANT VARCHAR2(30) := 'csp_failure_rates_pvt';
74: l_api_version_number CONSTANT NUMBER := 1.0;
75: l_return_status_full VARCHAR2(1);
76: l_sqlcode NUMBER;
77: l_sqlerrm Varchar2(2000);

Line 99: SAVEPOINT CSP_FAILURE_RATES_PVT;

95: -- Alter session
96: -- EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
97:
98: -- Standard Start of API savepoint
99: SAVEPOINT CSP_FAILURE_RATES_PVT;
100:
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
103: p_api_version_number,