APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_CHANGED_TERRS_GT

Line 213: DELETE jty_changed_terrs_gt;

209: ,'D'
210: ,'Y'
211: ,'D');
212:
213: DELETE jty_changed_terrs_gt;
214:
215: UPDATE jty_changed_terrs a
216: SET a.star_request_id = p_request_id
217: WHERE a.star_request_id IS NULL

Line 231: INSERT INTO jty_changed_terrs_gt (

227: CLOSE c_changed_terrs;
228:
229: IF (l_terr_id_tbl.COUNT > 0) THEN
230: FOR i IN l_terr_id_tbl.FIRST .. l_terr_id_tbl.LAST LOOP
231: INSERT INTO jty_changed_terrs_gt (
232: terr_id
233: ,rank_calc_flag
234: ,process_attr_values_flag
235: ,matching_sql_flag

Line 245: UPDATE jty_changed_terrs_gt

241: ,l_match_sql_tbl(i)
242: ,l_hier_tbl(i));
243:
244: FOR child_terrs IN c_child_terrs (l_terr_id_tbl(i)) LOOP
245: UPDATE jty_changed_terrs_gt
246: SET rank_calc_flag = decode(rank_calc_flag, 'Y', 'Y', l_rank_tbl(i)),
247: process_attr_values_flag =
248: decode(process_attr_values_flag,
249: 'I', 'I',

Line 261: INSERT INTO jty_changed_terrs_gt (

257: l_hier_tbl(i))
258: WHERE terr_id = child_terrs.terr_id;
259:
260: IF (SQL%ROWCOUNT = 0) THEN
261: INSERT INTO jty_changed_terrs_gt (
262: terr_id
263: ,rank_calc_flag
264: ,process_attr_values_flag
265: ,matching_sql_flag

Line 308: jty_changed_terrs_gt a

304: ,p_terr_change_tab.parent_num_winners
305: ,p_terr_change_tab.start_date
306: ,p_terr_change_tab.end_date
307: FROM
308: jty_changed_terrs_gt a
309: ,jtf_terr_all b
310: ,jtf_terr_all c
311: WHERE a.terr_id = b.terr_id(+)
312: AND b.parent_territory_id = c.terr_id(+)

Line 402: DELETE jty_changed_terrs_gt;

398: AND a.retcode = 0
399: and rownum = 1
400: order by end_date ;
401:
402: DELETE jty_changed_terrs_gt;
403:
404: UPDATE jty_changed_dea_terrs a
405: SET a.star_request_id = p_request_id
406: WHERE a.star_request_id IS NULL

Line 420: INSERT INTO jty_changed_terrs_gt (

416: CLOSE c_changed_terrs;
417:
418: IF (l_terr_id_tbl.COUNT > 0) THEN
419: FOR i IN l_terr_id_tbl.FIRST .. l_terr_id_tbl.LAST LOOP
420: INSERT INTO jty_changed_terrs_gt (
421: terr_id
422: ,rank_calc_flag
423: ,process_attr_values_flag
424: ,matching_sql_flag

Line 435: UPDATE jty_changed_terrs_gt

431: ,l_hier_tbl(i));
432:
433:
434: FOR child_terrs IN c_child_terrs (l_terr_id_tbl(i)) LOOP
435: UPDATE jty_changed_terrs_gt
436: SET rank_calc_flag = decode(rank_calc_flag, 'Y', 'Y', l_rank_tbl(i)),
437: process_attr_values_flag =
438: decode(process_attr_values_flag,
439: 'I', 'I',

Line 452: INSERT INTO jty_changed_terrs_gt (

448: WHERE terr_id = child_terrs.terr_id;
449:
450:
451: IF (SQL%ROWCOUNT = 0) THEN
452: INSERT INTO jty_changed_terrs_gt (
453: terr_id
454: ,rank_calc_flag
455: ,process_attr_values_flag
456: ,matching_sql_flag

Line 470: -- l_query := 'create table jty_changed_terrs_rk_test as select * from jty_changed_terrs_gt';

466: END LOOP; /* end loop FOR child_terrs IN c_child_terrs (l_terr_id_tbl(i)) */
467: END LOOP; /* end loop FOR i IN l_terr_id_tbl.FIRST .. l_terr_id_tbl.LAST */
468: END IF; /* end IF (l_terr_id_tbl.COUNT > 0) */
469:
470: -- l_query := 'create table jty_changed_terrs_rk_test as select * from jty_changed_terrs_gt';
471: --EXECUTE IMMEDIATE l_query;
472:
473: SELECT
474: a.terr_id

Line 502: jty_changed_terrs_gt a

498: ,p_terr_change_tab.parent_num_winners
499: ,p_terr_change_tab.start_date
500: ,p_terr_change_tab.end_date
501: FROM
502: jty_changed_terrs_gt a
503: ,jtf_terr_all b
504: ,jtf_terr_all c
505: WHERE a.terr_id = b.terr_id(+)
506: AND b.parent_territory_id = c.terr_id(+)