[Home] [Help]
140: DELETE FROM jtf_terr_usgs_all where terr_id = l_terr_id;
141: DELETE FROM jtf_terr_qtype_usgs_all where terr_id = l_terr_id;
142:
143: DELETE FROM jtf_terr_rsc_access_all
144: WHERE terr_rsc_id IN (SELECT terr_rsc_id FROM jtf_terr_rsc_all WHERE terr_id = l_terr_id);
145:
146: DELETE FROM jtf_terr_rsc_all WHERE terr_id = l_terr_id;
147:
148: DELETE FROM jtf_terr_all WHERE terr_id = l_terr_id;
142:
143: DELETE FROM jtf_terr_rsc_access_all
144: WHERE terr_rsc_id IN (SELECT terr_rsc_id FROM jtf_terr_rsc_all WHERE terr_id = l_terr_id);
145:
146: DELETE FROM jtf_terr_rsc_all WHERE terr_id = l_terr_id;
147:
148: DELETE FROM jtf_terr_all WHERE terr_id = l_terr_id;
149:
150: ELSE
404: --dbms_output.put_line('role_code:'||tran_type.role_code||',terr_group_id:'||tran_type.terr_group_id);
405: FOR rsc IN c_terr_resource(p_geo_terr_id,tran_type.role_code) LOOP
406: --dbms_output.put_line('rs:'||rsc.resource_id||',rsc_group_id:'||rsc.rsc_group_id||',rsc_resource_type:'||rsc.rsc_resource_type);
407:
408: /*insert in jtf_terr_rsc_all */
409:
410:
411: SELECT JTF_TERR_RSC_S.NEXTVAL
412: INTO l_terr_rsc_id
411: SELECT JTF_TERR_RSC_S.NEXTVAL
412: INTO l_terr_rsc_id
413: FROM DUAL;
414:
415: INSERT INTO jtf_terr_rsc_all
416: ( TERR_RSC_ID
417: ,LAST_UPDATE_DATE
418: ,LAST_UPDATED_BY
419: ,CREATION_DATE
447: , 1
448: FROM jtf_tty_geo_terr
449: WHERE geo_territory_id = p_geo_terr_id;
450:
451: --dbms_output.put_line(' After inserting jtf_terr_rsc_all');
452:
453:
454: /*insert in jtf_terr_rsc_access_all table */
455: FOR rsc_acc IN c_role_access(l_geo_terr_group_id, tran_type.role_code) LOOP
511: , rsc_acc.access_type
512: , l_org_id --org Id
513: , 1
514: , c.trans_access_code
515: FROM jtf_terr_rsc_all b
516: , jtf_terr_rsc_access_all c
517: WHERE b.terr_id = l_parent_terr_id
518: AND b.role = tran_type.role_code
519: AND b.resource_type <> 'RS_EMPLOYEE'