3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_SCN_FORECAST_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvpemb.pls';
6:
7: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
11: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
4: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_SCN_FORECAST_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvpemb.pls';
6:
7: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
11: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
12:
5: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvpemb.pls';
6:
7: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
11: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
12:
13:
6:
7: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
11: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
12:
13:
14: PROCEDURE Get_Forecast_Amounts (
7: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
9: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
10: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
11: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
12:
13:
14: PROCEDURE Get_Forecast_Amounts (
15: p_api_version_number IN NUMBER,