APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_RSC_ALL

Line 1450: from JTF_TERR_RSC_ALL jtr,JTY_WEBADI_RESOURCES jwr

1446: and jwot.status is null
1447: and jwot.action_flag = 'C'
1448: and jwot.header = 'RSC'
1449: and exists( select 1
1450: from JTF_TERR_RSC_ALL jtr,JTY_WEBADI_RESOURCES jwr
1451: where jwr.USER_SEQUENCE = jwot.USER_SEQUENCE
1452: and jwr.header = jwot.header
1453: and jwr.INTERFACE_TYPE = jwot.INTERFACE_TYPE
1454: and jwot.lay_seq_num = jwr.lay_seq_num

Line 4178: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL

4174:
4175: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
4176: --Delete Territory Resource Access
4177: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
4178: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL
4179: WHERE TERR_ID = l_del_terr_rec.terr_id(i) );
4180:
4181: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
4182: --Delete the Territory Resource records

Line 4183: DELETE from JTF_TERR_RSC_ALL Where TERR_ID = l_del_terr_rec.terr_id(i);

4179: WHERE TERR_ID = l_del_terr_rec.terr_id(i) );
4180:
4181: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
4182: --Delete the Territory Resource records
4183: DELETE from JTF_TERR_RSC_ALL Where TERR_ID = l_del_terr_rec.terr_id(i);
4184:
4185: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
4186: --Delete Territory record
4187: DELETE from JTF_TERR_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);

Line 4281: DELETE FROM JTF_TERR_RSC_ALL

4277: WHERE TERR_RSC_ID = l_del_rsc_rec.terr_rsc_id(i);
4278:
4279: -- Delete the Territory Resource records
4280: forall i in l_del_rsc_rec.terr_rsc_id.first..l_del_rsc_rec.terr_rsc_id.last
4281: DELETE FROM JTF_TERR_RSC_ALL
4282: WHERE TERR_RSC_ID = l_del_rsc_rec.terr_rsc_id(i);
4283:
4284: forall i in l_del_rsc_rec.lay_seq_num.first..l_del_rsc_rec.lay_seq_num.last
4285: update JTY_WEBADI_OTH_TERR_INTF

Line 11012: INSERT INTO JTF_TERR_RSC_ALL (

11008: -- doesnot support flex field insert
11009: if (l_action_flag = 'C' AND l_rsc_rec.RESOURCE_ID.count > 0) then
11010: --dbms_output.put_line('Create territory resource information, rowcount: ' || l_rsc_rec.RESOURCE_ID.count);
11011: forall i in l_rsc_rec.RESOURCE_ID.first..l_rsc_rec.RESOURCE_ID.last
11012: INSERT INTO JTF_TERR_RSC_ALL (
11013: TERR_RSC_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
11014: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
11015: TERR_ID, RESOURCE_ID, RESOURCE_TYPE,
11016: ROLE, PRIMARY_CONTACT_FLAG, START_DATE_ACTIVE,

Line 11083: UPDATE JTF_TERR_RSC_ALL

11079: if (l_action_flag = 'U' AND l_rsc_rec.TERR_RSC_ID.count > 0) then
11080: --dbms_output.put_line('Update territory resource information, rowcount: ' || l_rsc_rec.TERR_RSC_ID.count);
11081:
11082: forall i in l_rsc_rec.TERR_RSC_ID.first..l_rsc_rec.TERR_RSC_ID.last
11083: UPDATE JTF_TERR_RSC_ALL
11084: SET LAST_UPDATE_DATE = l_rsc_rec.LAST_UPDATE_DATE(i),
11085: LAST_UPDATED_BY = l_rsc_rec.LAST_UPDATED_BY(i),
11086: LAST_UPDATE_LOGIN = l_rsc_rec.LAST_UPDATE_LOGIN(i),
11087: TERR_ID = l_rsc_rec.TERR_ID(i),