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.11 2008/05/07 15:59:45 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.11 2008/05/07 15:59:45 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 1390: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;

1386: l_Start_Date DATE;
1387:
1388: l_usage_Details_Rec c_Usage_Details%ROWTYPE;
1389: l_prev_Rec c_Usage_Details%ROWTYPE;
1390: l_Dates_Table CSP_AUTO_ASLMSL_PVT.CSP_Date_Tbl_Type;
1391: l_Usage_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1392: l_Forecast_Qty_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1393: l_Weighted_Avg_Tbl Csp_Forecast_Pvt.T_NUMBER_TABLE;
1394:

Line 3231: End CSP_AUTO_ASLMSL_PVT;

3227: ,X_MSG_DATA => X_MSG_DATA
3228: ,X_RETURN_STATUS => X_RETURN_STATUS);
3229: End Calculate_needby_date;
3230:
3231: End CSP_AUTO_ASLMSL_PVT;