APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTY_DEA_VALUES_IDX_HEADER

Line 92: FROM jty_dea_values_idx_header A

88:
89: Cursor getDeaProductList(cl_source_id number) IS
90: SELECT A.dea_values_idx_header_id,
91: A.index_name
92: FROM jty_dea_values_idx_header A
93: WHERE A.source_id = p_source_id
94: AND A.build_index_flag = 'Y';
95:
96: Cursor getDeaFactorList(cl_tvhidpid number) IS

Line 116: FROM jty_dea_values_idx_header A,

112:
113: Cursor getDeaDropIndexCandidates(cl_source_id in number, cl_owner in varchar2) IS
114: SELECT A.index_name,
115: B.owner
116: FROM jty_dea_values_idx_header A,
117: dba_indexes B
118: WHERE A.source_id = p_source_id
119: AND A.build_index_flag = 'N'
120: AND A.index_name = B.index_name

Line 143: UPDATE jty_dea_values_idx_header a

139: SELECT relation_product
140: FROM jtf_tae_qual_products
141: WHERE source_id = p_source_id );
142: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
143: UPDATE jty_dea_values_idx_header a
144: SET a.delete_flag = 'N'
145: WHERE a.source_id = p_source_id
146: AND a.delete_flag = 'Y'
147: AND a.relation_product in (

Line 338: UPDATE jty_dea_values_idx_header

334: alter_statement := 'ALTER INDEX ' || l_ora_username || '.' || prd.index_name || ' NOPARALLEL';
335: EXECUTE IMMEDIATE alter_statement;
336: EXCEPTION
337: WHEN duplicate_index THEN
338: UPDATE jty_dea_values_idx_header
339: SET BUILD_INDEX_FLAG = 'N'
340: WHERE dea_values_idx_header_id = prd.dea_values_idx_header_id;
341: WHEN index_exists THEN
342: jty_log(FND_LOG.LEVEL_STATEMENT,

Line 366: FROM jty_dea_values_idx_header hdr

362: IF (p_mode = 'DEA INCREMENTAL') THEN
363: DELETE jty_dea_values_idx_details dtl
364: WHERE EXISTS (
365: SELECT 1
366: FROM jty_dea_values_idx_header hdr
367: WHERE dtl.dea_values_idx_header_id = hdr.dea_values_idx_header_id
368: AND hdr.source_id = p_source_id
369: AND hdr.delete_flag = 'Y');
370:

Line 371: DELETE jty_dea_values_idx_header hdr

367: WHERE dtl.dea_values_idx_header_id = hdr.dea_values_idx_header_id
368: AND hdr.source_id = p_source_id
369: AND hdr.delete_flag = 'Y');
370:
371: DELETE jty_dea_values_idx_header hdr
372: WHERE hdr.source_id = p_source_id
373: AND hdr.delete_flag = 'Y';
374:
375: END IF;

Line 2497: FROM jty_dea_values_idx_header hdr

2493:
2494: DELETE jty_dea_values_idx_details dtl
2495: WHERE EXISTS (
2496: SELECT 1
2497: FROM jty_dea_values_idx_header hdr
2498: WHERE dtl.dea_values_idx_header_id = hdr.dea_values_idx_header_id
2499: AND hdr.source_id = p_source_id );
2500:
2501: DELETE jty_dea_values_idx_header hdr

Line 2501: DELETE jty_dea_values_idx_header hdr

2497: FROM jty_dea_values_idx_header hdr
2498: WHERE dtl.dea_values_idx_header_id = hdr.dea_values_idx_header_id
2499: AND hdr.source_id = p_source_id );
2500:
2501: DELETE jty_dea_values_idx_header hdr
2502: WHERE hdr.source_id = p_source_id;
2503:
2504: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner || '.' || l_table_name;
2505: ELSIF (p_mode = 'INCREMENTAL') THEN

Line 2545: UPDATE jty_dea_values_idx_header

2541:
2542: /* mark all the records to be deleted */
2543: /* delete_flag will be updated to 'N' for qualifiers that are used by active territories while generating real time matching sql */
2544: /* delete_flag will be updated to 'N' for qualifier combinations used by active territories after updating jtf_tae_qual_products */
2545: UPDATE jty_dea_values_idx_header
2546: SET delete_flag = 'Y'
2547: WHERE source_id = p_source_id;
2548: END IF;
2549: