APPS.CSP_AUTO_ASLMSL_PVT dependencies on CSP_AUTO_ASLMSL_PVT

Line 1: PACKAGE BODY CSP_AUTO_ASLMSL_PVT as

1: PACKAGE BODY CSP_AUTO_ASLMSL_PVT as
2: /* $Header: cspvaslb.pls 120.12 2011/12/22 19:23:24 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_AUTO_ASLMSL_PVT
5: -- Purpose :

Line 4: -- Package name : CSP_AUTO_ASLMSL_PVT

1: PACKAGE BODY CSP_AUTO_ASLMSL_PVT as
2: /* $Header: cspvaslb.pls 120.12 2011/12/22 19:23:24 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_AUTO_ASLMSL_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_AUTO_ASLMSL_PVT';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_AUTO_ASLMSL_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspvaslb.pls';
13:
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 27: G_HIST_DATES_TABLE CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;

23: G_DAYS NUMBER;
24: G_NO_LEAD_TIME_MSG VARCHAR2(2000);
25: G_WAREHOUSE VARCHAR2(1) := 'W';
26: G_FIELD_ENGINEER VARCHAR2(1) := 'F';
27: G_HIST_DATES_TABLE CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;
28: G_OTHER_USAGE_DATA NUMBER ;
29: G_ORG_OTHER_USAGE_DATA NUMBER ;
30: G_DEFAULT NUMBER := -1;
31: G_TXN_TYPE_ID NUMBER := 93;

Line 1410: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;

1406: l_Start_Date DATE;
1407:
1408: l_usage_Details_Rec c_Usage_Details%ROWTYPE;
1409: l_prev_Rec c_Usage_Details%ROWTYPE;
1410: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;
1411: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1412: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1413: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1414:

Line 3278: End CSP_AUTO_ASLMSL_PVT;

3274: ,X_MSG_DATA => X_MSG_DATA
3275: ,X_RETURN_STATUS => X_RETURN_STATUS);
3276: End Calculate_needby_date;
3277:
3278: End CSP_AUTO_ASLMSL_PVT;