APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_RSC_ALL

Line 712: from JTF_TERR_RSC_ALL jtr,JTY_WEBADI_RESOURCES jwr

708: and jwot.status is null
709: and jwot.action_flag = 'C'
710: and jwot.header = 'RSC'
711: and exists( select 1
712: from JTF_TERR_RSC_ALL jtr,JTY_WEBADI_RESOURCES jwr
713: where jwr.USER_SEQUENCE = jwot.USER_SEQUENCE
714: and jwr.header = jwot.header
715: and jwr.INTERFACE_TYPE = jwot.INTERFACE_TYPE
716: and jwot.lay_seq_num = jwr.lay_seq_num

Line 1890: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL

1886:
1887: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1888: --Delete Territory Resource Access
1889: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
1890: ( SELECT TERR_RSC_ID FROM JTF_TERR_RSC_ALL
1891: WHERE TERR_ID = l_del_terr_rec.terr_id(i) );
1892:
1893: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1894: --Delete the Territory Resource records

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

1891: WHERE TERR_ID = l_del_terr_rec.terr_id(i) );
1892:
1893: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1894: --Delete the Territory Resource records
1895: DELETE from JTF_TERR_RSC_ALL Where TERR_ID = l_del_terr_rec.terr_id(i);
1896:
1897: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1898: --Delete Territory record
1899: DELETE from JTF_TERR_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);

Line 1993: DELETE FROM JTF_TERR_RSC_ALL

1989: WHERE TERR_RSC_ID = l_del_rsc_rec.terr_rsc_id(i);
1990:
1991: -- Delete the Territory Resource records
1992: forall i in l_del_rsc_rec.terr_rsc_id.first..l_del_rsc_rec.terr_rsc_id.last
1993: DELETE FROM JTF_TERR_RSC_ALL
1994: WHERE TERR_RSC_ID = l_del_rsc_rec.terr_rsc_id(i);
1995:
1996: forall i in l_del_rsc_rec.lay_seq_num.first..l_del_rsc_rec.lay_seq_num.last
1997: update JTY_WEBADI_OTH_TERR_INTF

Line 5083: INSERT INTO JTF_TERR_RSC_ALL (

5079: -- doesnot support flex field insert
5080: if (l_action_flag = 'C' AND l_rsc_rec.RESOURCE_ID.count > 0) then
5081: --dbms_output.put_line('Create territory resource information, rowcount: ' || l_rsc_rec.RESOURCE_ID.count);
5082: forall i in l_rsc_rec.RESOURCE_ID.first..l_rsc_rec.RESOURCE_ID.last
5083: INSERT INTO JTF_TERR_RSC_ALL (
5084: TERR_RSC_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5085: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
5086: TERR_ID, RESOURCE_ID, RESOURCE_TYPE,
5087: ROLE, PRIMARY_CONTACT_FLAG, START_DATE_ACTIVE,

Line 5154: UPDATE JTF_TERR_RSC_ALL

5150: if (l_action_flag = 'U' AND l_rsc_rec.TERR_RSC_ID.count > 0) then
5151: --dbms_output.put_line('Update territory resource information, rowcount: ' || l_rsc_rec.TERR_RSC_ID.count);
5152:
5153: forall i in l_rsc_rec.TERR_RSC_ID.first..l_rsc_rec.TERR_RSC_ID.last
5154: UPDATE JTF_TERR_RSC_ALL
5155: SET LAST_UPDATE_DATE = l_rsc_rec.LAST_UPDATE_DATE(i),
5156: LAST_UPDATED_BY = l_rsc_rec.LAST_UPDATED_BY(i),
5157: LAST_UPDATE_LOGIN = l_rsc_rec.LAST_UPDATE_LOGIN(i),
5158: TERR_ID = l_rsc_rec.TERR_ID(i),