10: --
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_TCA_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvtca1.pls';
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_TCA_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvtca1.pls';
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
19:
12: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_TCA_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvtca1.pls';
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
19:
20: -- Procedure to validate the party_id
13: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvtca1.pls';
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
19:
20: -- Procedure to validate the party_id
21: --
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
17: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
19:
20: -- Procedure to validate the party_id
21: --
22: -- Validation: