2: /* $Header: FLMKBCHB.pls 120.1.12020000.1 2012/07/13 11:50:05 sisankar noship $ * */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FLM_EKB_CUSTOM_HEALTH';
6: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
8: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
10: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FLM_EKB_CUSTOM_HEALTH';
6: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
8: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
10: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
11: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FLM_EKB_CUSTOM_HEALTH';
6: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
8: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
10: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
11: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
12: G_CURRENT_USER_ID NUMBER;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FLM_EKB_CUSTOM_HEALTH';
6: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
8: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
10: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
11: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
12: G_CURRENT_USER_ID NUMBER;
13: G_CURRENT_LOGIN_ID NUMBER;
6: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
7: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
8: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
10: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
11: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
12: G_CURRENT_USER_ID NUMBER;
13: G_CURRENT_LOGIN_ID NUMBER;
14: G_ADD_ERRORS_TO_FND_STACK VARCHAR2(1);
7: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
8: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
9: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
10: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
11: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
12: G_CURRENT_USER_ID NUMBER;
13: G_CURRENT_LOGIN_ID NUMBER;
14: G_ADD_ERRORS_TO_FND_STACK VARCHAR2(1);
15: G_APPLICATION_CONTEXT VARCHAR2(30);