12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_SALES_MEMBER_PVT';
14: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvsmbb.pls';
15:
16: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
18: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
19: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
20: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
13: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_SALES_MEMBER_PVT';
14: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvsmbb.pls';
15:
16: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
18: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
19: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
20: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
21:
14: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvsmbb.pls';
15:
16: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
18: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
19: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
20: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
21:
22:
15:
16: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
18: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
19: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
20: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
21:
22:
23: /*************************** PUBLIC ROUTINES *********************************/
16: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
18: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
19: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
20: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
21:
22:
23: /*************************** PUBLIC ROUTINES *********************************/
24: