eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_CHANGED_DEA_TERRS

Line 333: /* this procedure looks at the table jty_changed_dea_terrs and retrive the master */

329: substr(errbuf, 1, 4000));
330:
331: END get_terr_for_incr_star;
332:
333: /* this procedure looks at the table jty_changed_dea_terrs and retrive the master */
334: /* list that need to be processed by dea incremental star */
335: PROCEDURE get_terr_for_dea_incr_star (
336: p_source_id IN NUMBER,
337: p_request_id IN NUMBER,

Line 350: FROM jty_changed_dea_terrs a

346: a.rank_calc_flag,
347: a.process_attr_values_flag,
348: a.matching_sql_flag,
349: a.hier_processing_flag
350: FROM jty_changed_dea_terrs a
351: WHERE a.star_request_id = cl_request_id
352: AND a.source_id = p_source_id
353: AND (a.rank_calc_flag <> 'N' OR a.process_attr_values_flag <> 'N' OR
354: a.matching_sql_flag <> 'N' OR a.hier_processing_flag <> 'N')

Line 369: TYPE l_terr_id_tbl_type IS TABLE OF jty_changed_dea_terrs.terr_id%TYPE;

365: FROM jtf_terr_all
366: START WITH terr_id = cl_terr_id
367: CONNECT BY PRIOR terr_id = parent_territory_id;
368:
369: TYPE l_terr_id_tbl_type IS TABLE OF jty_changed_dea_terrs.terr_id%TYPE;
370: TYPE l_rank_tbl_type IS TABLE OF jty_changed_dea_terrs.rank_calc_flag%TYPE;
371: TYPE l_attr_values_tbl_type IS TABLE OF jty_changed_dea_terrs.process_attr_values_flag%TYPE;
372: TYPE l_match_sql_tbl_type IS TABLE OF jty_changed_dea_terrs.matching_sql_flag%TYPE;
373: TYPE l_hier_tbl_type IS TABLE OF jty_changed_dea_terrs.hier_processing_flag%TYPE;

Line 370: TYPE l_rank_tbl_type IS TABLE OF jty_changed_dea_terrs.rank_calc_flag%TYPE;

366: START WITH terr_id = cl_terr_id
367: CONNECT BY PRIOR terr_id = parent_territory_id;
368:
369: TYPE l_terr_id_tbl_type IS TABLE OF jty_changed_dea_terrs.terr_id%TYPE;
370: TYPE l_rank_tbl_type IS TABLE OF jty_changed_dea_terrs.rank_calc_flag%TYPE;
371: TYPE l_attr_values_tbl_type IS TABLE OF jty_changed_dea_terrs.process_attr_values_flag%TYPE;
372: TYPE l_match_sql_tbl_type IS TABLE OF jty_changed_dea_terrs.matching_sql_flag%TYPE;
373: TYPE l_hier_tbl_type IS TABLE OF jty_changed_dea_terrs.hier_processing_flag%TYPE;
374:

Line 371: TYPE l_attr_values_tbl_type IS TABLE OF jty_changed_dea_terrs.process_attr_values_flag%TYPE;

367: CONNECT BY PRIOR terr_id = parent_territory_id;
368:
369: TYPE l_terr_id_tbl_type IS TABLE OF jty_changed_dea_terrs.terr_id%TYPE;
370: TYPE l_rank_tbl_type IS TABLE OF jty_changed_dea_terrs.rank_calc_flag%TYPE;
371: TYPE l_attr_values_tbl_type IS TABLE OF jty_changed_dea_terrs.process_attr_values_flag%TYPE;
372: TYPE l_match_sql_tbl_type IS TABLE OF jty_changed_dea_terrs.matching_sql_flag%TYPE;
373: TYPE l_hier_tbl_type IS TABLE OF jty_changed_dea_terrs.hier_processing_flag%TYPE;
374:
375: l_terr_id_tbl l_terr_id_tbl_type;

Line 372: TYPE l_match_sql_tbl_type IS TABLE OF jty_changed_dea_terrs.matching_sql_flag%TYPE;

368:
369: TYPE l_terr_id_tbl_type IS TABLE OF jty_changed_dea_terrs.terr_id%TYPE;
370: TYPE l_rank_tbl_type IS TABLE OF jty_changed_dea_terrs.rank_calc_flag%TYPE;
371: TYPE l_attr_values_tbl_type IS TABLE OF jty_changed_dea_terrs.process_attr_values_flag%TYPE;
372: TYPE l_match_sql_tbl_type IS TABLE OF jty_changed_dea_terrs.matching_sql_flag%TYPE;
373: TYPE l_hier_tbl_type IS TABLE OF jty_changed_dea_terrs.hier_processing_flag%TYPE;
374:
375: l_terr_id_tbl l_terr_id_tbl_type;
376: l_rank_tbl l_rank_tbl_type;

Line 373: TYPE l_hier_tbl_type IS TABLE OF jty_changed_dea_terrs.hier_processing_flag%TYPE;

369: TYPE l_terr_id_tbl_type IS TABLE OF jty_changed_dea_terrs.terr_id%TYPE;
370: TYPE l_rank_tbl_type IS TABLE OF jty_changed_dea_terrs.rank_calc_flag%TYPE;
371: TYPE l_attr_values_tbl_type IS TABLE OF jty_changed_dea_terrs.process_attr_values_flag%TYPE;
372: TYPE l_match_sql_tbl_type IS TABLE OF jty_changed_dea_terrs.matching_sql_flag%TYPE;
373: TYPE l_hier_tbl_type IS TABLE OF jty_changed_dea_terrs.hier_processing_flag%TYPE;
374:
375: l_terr_id_tbl l_terr_id_tbl_type;
376: l_rank_tbl l_rank_tbl_type;
377: l_attr_values_tbl l_attr_values_tbl_type;

Line 404: UPDATE jty_changed_dea_terrs a

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
407: AND a.source_id = p_source_id;
408:

Line 908: UPDATE jty_changed_dea_terrs

904: AND star_request_id IS NULL;
905: END IF;
906:
907: IF (p_mode = 'DATE EFFECTIVE') THEN
908: UPDATE jty_changed_dea_terrs
909: SET star_request_id = g_request_id
910: WHERE source_id = p_source_id
911: AND star_request_id IS NULL;
912: END IF;

Line 1216: DELETE jty_changed_dea_terrs

1212: WHERE a.source_id = p_source_id
1213: AND a.batch_enable_flag = 'Y';
1214:
1215: IF (l_batch_enabled = 0) THEN
1216: DELETE jty_changed_dea_terrs
1217: WHERE star_request_id = g_request_id;
1218: END IF;
1219: END IF;
1220: