APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_CHANGED_TERRS_GT

Line 203: DELETE jty_changed_terrs_gt;

199: ,'D'
200: ,'Y'
201: ,'D');
202:
203: DELETE jty_changed_terrs_gt;
204:
205: UPDATE jty_changed_terrs a
206: SET a.star_request_id = p_request_id
207: WHERE a.star_request_id IS NULL

Line 221: INSERT INTO jty_changed_terrs_gt (

217: CLOSE c_changed_terrs;
218:
219: IF (l_terr_id_tbl.COUNT > 0) THEN
220: FOR i IN l_terr_id_tbl.FIRST .. l_terr_id_tbl.LAST LOOP
221: INSERT INTO jty_changed_terrs_gt (
222: terr_id
223: ,rank_calc_flag
224: ,process_attr_values_flag
225: ,matching_sql_flag

Line 235: UPDATE jty_changed_terrs_gt

231: ,l_match_sql_tbl(i)
232: ,l_hier_tbl(i));
233:
234: FOR child_terrs IN c_child_terrs (l_terr_id_tbl(i)) LOOP
235: UPDATE jty_changed_terrs_gt
236: SET rank_calc_flag = decode(rank_calc_flag, 'Y', 'Y', l_rank_tbl(i)),
237: process_attr_values_flag =
238: decode(process_attr_values_flag,
239: 'I', 'I',

Line 251: INSERT INTO jty_changed_terrs_gt (

247: l_hier_tbl(i))
248: WHERE terr_id = child_terrs.terr_id;
249:
250: IF (SQL%ROWCOUNT = 0) THEN
251: INSERT INTO jty_changed_terrs_gt (
252: terr_id
253: ,rank_calc_flag
254: ,process_attr_values_flag
255: ,matching_sql_flag

Line 298: jty_changed_terrs_gt a

294: ,p_terr_change_tab.parent_num_winners
295: ,p_terr_change_tab.start_date
296: ,p_terr_change_tab.end_date
297: FROM
298: jty_changed_terrs_gt a
299: ,jtf_terr_all b
300: ,jtf_terr_all c
301: WHERE a.terr_id = b.terr_id(+)
302: AND b.parent_territory_id = c.terr_id(+)