3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_LOAD_SOD_DATA';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwsodwb.pls';
6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9: v_error_msg VARCHAR2(2000);
10: v_err_msg VARCHAR2(2000);
11: v_error_found boolean;
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_LOAD_SOD_DATA';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwsodwb.pls';
6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9: v_error_msg VARCHAR2(2000);
10: v_err_msg VARCHAR2(2000);
11: v_error_found boolean;
12: