APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTF_TERR_ALL

Line 169: from jtf_terr_all

165: l_parent := l_terr;
166: --dbms_output.put_line('l_instr = 0, l_parent: '||l_parent);
167:
168: select count(*) into l_count
169: from jtf_terr_all
170: where name = l_parent
171: and parent_territory_id = l_anc_id
172: and org_id = l_hierarchy_tbl(c).org_id;
173:

Line 185: from jtf_terr_all

181: and interface_type = p_intf_type;
182: when 1 then
183: -- lowest level parent_id found, update interface table
184: select terr_id into l_parent_id
185: from jtf_terr_all
186: where org_id = l_hierarchy_tbl(c).org_id
187: and name = l_parent
188: and parent_territory_id = l_anc_id;
189:

Line 215: from jtf_terr_all

211: l_parent := substr(l_terr,1,l_instr -1);
212: --dbms_output.put_line('l_parent: '||l_parent);
213:
214: select count(*) into l_count
215: from jtf_terr_all
216: where name = l_parent
217: and parent_territory_id = l_anc_id
218: and org_id = l_hierarchy_tbl(c).org_id;
219:

Line 234: from jtf_terr_all

230: and interface_type = p_intf_type;
231: exit;
232: when 1 then
233: select terr_id into l_parent_id
234: from jtf_terr_all
235: where org_id = l_hierarchy_tbl(c).org_id
236: and name = l_parent
237: and parent_territory_id = l_anc_id;
238: else

Line 585: FROM jtf_terr_all jt

581: update JTY_WEBADI_OTH_TERR_INTF jwot
582: set jwot.status = x_return_status,
583: jwot.error_msg = X_Msg_Data
584: where not exists ( SELECT 1
585: FROM jtf_terr_all jt
586: WHERE jt.TERRITORY_TYPE_ID = jwot.TERR_TYPE_ID
587: and jt.terr_id = jwot.TERR_ID
588: AND jt.ORG_ID = jwot.ORG_ID )
589: and jwot.user_sequence = p_user_sequence

Line 815: from JTF_TERR_ALL jta

811: and NOT(jwot.TERR_START_DATE between NVL(jwot2.terr_start_date,SYSDATE)
812: and NVL(jwot2.TERR_END_DATE, ADD_MONTHS(NVL(jwot2.TERR_START_DATE,SYSDATE), 12)))
813: and jwot.parent_terr_name = jwot2.terr_name)
814: or exists ( select 1
815: from JTF_TERR_ALL jta
816: where jwot.parent_terr_id = jta.terr_id
817: and NOT(jwot.TERR_START_DATE between jta.START_DATE_ACTIVE and jta.END_DATE_ACTIVE))
818: );
819:

Line 841: from JTF_TERR_ALL jta

837: and NOT (jwot.TERR_END_DATE between NVL(jwot2.terr_start_date,SYSDATE)
838: and NVL(jwot2.TERR_END_DATE, ADD_MONTHS(NVL(jwot2.TERR_START_DATE,SYSDATE), 12)))
839: and jwot.parent_terr_name = jwot2.terr_name)
840: or exists ( select 1
841: from JTF_TERR_ALL jta
842: where jwot.parent_terr_id = jta.terr_id
843: and NOT(jwot.TERR_END_DATE between jta.START_DATE_ACTIVE and jta.END_DATE_ACTIVE))
844: );
845:

Line 936: from jtf_terr_all jta

932: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
933: SET (TERR_ID, TERR_START_DATE, TERR_END_DATE) =
934: (select jta.terr_id, NVL(jwot.TERR_START_DATE,jta.START_DATE_ACTIVE)
935: , NVL(jwot.TERR_END_DATE,jta.END_DATE_ACTIVE)
936: from jtf_terr_all jta
937: where jta.name = jwot.terr_name
938: --and jta.parent_territory_id = jwot.parent_terr_id
939: and rownum = 1)
940: where status is null

Line 944: from jtf_terr_all jta

940: where status is null
941: and interface_type = l_intf_type
942: and user_sequence = p_user_sequence
943: and exists (select 1
944: from jtf_terr_all jta
945: where jta.name = jwot.terr_name
946: --and jta.parent_territory_id = jwot.parent_terr_id
947: ) ;
948:

Line 1899: DELETE from JTF_TERR_ALL WHERE TERR_ID = l_del_terr_rec.terr_id(i);

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);
1900:
1901: -- update all records including the qual and rsc which will be deleted
1902: forall i in l_del_terr_rec.terr_id.first..l_del_terr_rec.terr_id.last
1903: update JTY_WEBADI_OTH_TERR_INTF

Line 2403: INSERT INTO JTF_TERR_ALL(

2399: close get_terr_all_csr;
2400:
2401: if (p_action_flag = 'C' and l_terr_all_rec.NAME.count > 0) then
2402: forall i in l_terr_all_rec.NAME.first..l_terr_all_rec.NAME.last
2403: INSERT INTO JTF_TERR_ALL(
2404: TERR_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2405: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
2406: APPLICATION_SHORT_NAME, NAME, ENABLED_FLAG,
2407: START_DATE_ACTIVE, RANK, END_DATE_ACTIVE, DESCRIPTION,

Line 2523: Update JTF_TERR_ALL

2519: x_return_status := FND_API.G_RET_STS_SUCCESS;
2520: if (p_action_flag = 'U' and l_terr_all_rec.TERR_ID.count > 0) then
2521:
2522: forall i in l_terr_all_rec.TERR_ID.first..l_terr_all_rec.TERR_ID.last
2523: Update JTF_TERR_ALL
2524: SET
2525: LAST_UPDATE_DATE = l_terr_all_rec.LAST_UPDATE_DATE(i),
2526: LAST_UPDATED_BY = l_terr_all_rec.LAST_UPDATED_BY(i),
2527: LAST_UPDATE_LOGIN = l_terr_all_rec.LAST_UPDATE_LOGIN(i),