APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTY_TERR_VALUES_IDX_HEADER

Line 71: FROM jty_terr_values_idx_header A

67: Cursor getProductList(cl_source_id number) IS
68: SELECT A.terr_values_idx_header_id,
69: A.index_name,
70: A.qual_usg_id
71: FROM jty_terr_values_idx_header A
72: WHERE A.source_id = p_source_id
73: AND A.build_index_flag = 'Y'
74: -- the condition below is necessary for incremental mode where the index may be already present
75: AND NOT EXISTS (

Line 106: FROM jty_terr_values_idx_header A,

102:
103: Cursor getDropIndexCandidates(cl_source_id in number, cl_owner in varchar2) IS
104: SELECT A.index_name,
105: B.owner
106: FROM jty_terr_values_idx_header A,
107: dba_indexes B
108: WHERE A.source_id = p_source_id
109: AND A.build_index_flag = 'N'
110: AND A.index_name = B.index_name

Line 134: UPDATE jty_terr_values_idx_header a

130:
131: /* In incremental mode mark all the qualifier combination present */
132: /* in jtf_tae_qual_products as being used by active territories */
133: IF (p_mode = 'INCREMENTAL') THEN
134: UPDATE jty_terr_values_idx_header a
135: SET a.delete_flag = 'N'
136: WHERE a.source_id = p_source_id
137: AND a.delete_flag = 'Y'
138: AND a.relation_product in (

Line 265: UPDATE jty_terr_values_idx_header

261: alter_statement := 'ALTER INDEX ' || l_ora_username || '.' || prd.index_name || ' NOPARALLEL';
262: EXECUTE IMMEDIATE alter_statement;
263: EXCEPTION
264: WHEN duplicate_index THEN
265: UPDATE jty_terr_values_idx_header
266: SET BUILD_INDEX_FLAG = 'N'
267: WHERE terr_values_idx_header_id = prd.terr_values_idx_header_id;
268: END;
269: END IF; /* end IF (j > 1) */

Line 288: FROM jty_terr_values_idx_header hdr

284: IF (p_mode = 'INCREMENTAL') THEN
285: DELETE jty_terr_values_idx_details dtl
286: WHERE EXISTS (
287: SELECT 1
288: FROM jty_terr_values_idx_header hdr
289: WHERE dtl.terr_values_idx_header_id = hdr.terr_values_idx_header_id
290: AND hdr.source_id = p_source_id
291: AND hdr.delete_flag = 'Y');
292:

Line 293: DELETE jty_terr_values_idx_header hdr

289: WHERE dtl.terr_values_idx_header_id = hdr.terr_values_idx_header_id
290: AND hdr.source_id = p_source_id
291: AND hdr.delete_flag = 'Y');
292:
293: DELETE jty_terr_values_idx_header hdr
294: WHERE hdr.source_id = p_source_id
295: AND hdr.delete_flag = 'Y';
296:
297: END IF;

Line 2465: FROM jty_terr_values_idx_header hdr

2461:
2462: DELETE jty_terr_values_idx_details dtl
2463: WHERE EXISTS (
2464: SELECT 1
2465: FROM jty_terr_values_idx_header hdr
2466: WHERE dtl.terr_values_idx_header_id = hdr.terr_values_idx_header_id
2467: AND hdr.source_id = p_source_id );
2468:
2469: DELETE jty_terr_values_idx_header hdr

Line 2469: DELETE jty_terr_values_idx_header hdr

2465: FROM jty_terr_values_idx_header hdr
2466: WHERE dtl.terr_values_idx_header_id = hdr.terr_values_idx_header_id
2467: AND hdr.source_id = p_source_id );
2468:
2469: DELETE jty_terr_values_idx_header hdr
2470: WHERE hdr.source_id = p_source_id;
2471:
2472: EXECUTE IMMEDIATE 'truncate table '||l_table_owner || '.' || l_table_name ;
2473: ELSIF (p_mode = 'DATE EFFECTIVE') THEN

Line 2516: UPDATE jty_terr_values_idx_header

2512:
2513: /* mark all the records to be deleted */
2514: /* delete_flag will be updated to 'N' for qualifiers that are used by active territories while generating real time matching sql */
2515: /* delete_flag will be updated to 'N' for qualifier combinations used by active territories after updating jtf_tae_qual_products */
2516: UPDATE jty_terr_values_idx_header
2517: SET delete_flag = 'Y'
2518: WHERE source_id = p_source_id;
2519: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
2520: