2: /* $Header: iexvroub.pls 120.0 2004/01/24 03:28:34 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_ROUTING_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvroub.pls';
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_ROUTING_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvroub.pls';
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_ROUTING_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvroub.pls';
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvroub.pls';
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
13:
6: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
7: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
8: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
13:
14: PROCEDURE isCustomerOverdue ( p_api_version in number,