170: l_industry varchar2(10);
171: l_applsys_schema varchar2(30);
172: l_result boolean;
173:
174: L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
175: L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();
176: L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
177: L_USER_ID NUMBER := FND_GLOBAL.USER_ID();
178:
171: l_applsys_schema varchar2(30);
172: l_result boolean;
173:
174: L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
175: L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();
176: L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
177: L_USER_ID NUMBER := FND_GLOBAL.USER_ID();
178:
179: l_sysdate DATE := SYSDATE;
172: l_result boolean;
173:
174: L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
175: L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();
176: L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
177: L_USER_ID NUMBER := FND_GLOBAL.USER_ID();
178:
179: l_sysdate DATE := SYSDATE;
180: l_root_terr_id CONSTANT NUMBER := 1;
173:
174: L_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
175: L_PROGRAM_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID();
176: L_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
177: L_USER_ID NUMBER := FND_GLOBAL.USER_ID();
178:
179: l_sysdate DATE := SYSDATE;
180: l_root_terr_id CONSTANT NUMBER := 1;
181: l_new_parent_territory_id NUMBER;