APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_TERR_VALUES_IDX_HEADER

Line 368: FROM jty_terr_values_idx_header

364: l_no_of_records := 0;
365:
366: SELECT count(*)
367: INTO l_no_of_records
368: FROM jty_terr_values_idx_header
369: WHERE source_id = p_source_id
370: AND relation_product = p_qual_prd_tbl(i);
371:
372: IF (l_no_of_records = 0) THEN

Line 374: SELECT jty_terr_values_idx_header_s.nextval

370: AND relation_product = p_qual_prd_tbl(i);
371:
372: IF (l_no_of_records = 0) THEN
373:
374: SELECT jty_terr_values_idx_header_s.nextval
375: INTO l_header_seq
376: FROM dual;
377:
378: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN' ||

Line 381: FROM jty_terr_values_idx_header

377:
378: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN' ||
379: (nvl(max(to_number(substr(index_name, instr(index_name, '_BN')+3))), 0) + 1)
380: INTO l_index_name
381: FROM jty_terr_values_idx_header
382: WHERE index_name like 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN%';
383:
384: INSERT INTO jty_terr_values_idx_header (
385: terr_values_idx_header_id

Line 384: INSERT INTO jty_terr_values_idx_header (

380: INTO l_index_name
381: FROM jty_terr_values_idx_header
382: WHERE index_name like 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN%';
383:
384: INSERT INTO jty_terr_values_idx_header (
385: terr_values_idx_header_id
386: ,source_id
387: ,last_update_date
388: ,last_updated_by

Line 1802: FROM jty_terr_values_idx_header A,

1798: S_subset_L VARCHAR2(1);
1799:
1800: CURSOR all_sets(cl_source_id number) is
1801: SELECT A.terr_values_idx_header_id, count(*) num_components
1802: FROM jty_terr_values_idx_header A,
1803: jty_terr_values_idx_details B
1804: WHERE A.source_id = cl_source_id
1805: AND A.build_index_flag = 'Y'
1806: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id

Line 1816: FROM jty_terr_values_idx_header A,

1812: , cl_source_id IN NUMBER
1813: , cl_terr_values_idx_header_id IN NUMBER) is
1814: SELECT * FROM (
1815: SELECT A.terr_values_idx_header_id, count(*) num_components
1816: FROM jty_terr_values_idx_header A,
1817: jty_terr_values_idx_details B
1818: WHERE A.source_id = cl_source_id
1819: AND A.terr_values_idx_header_id <> cl_terr_values_idx_header_id
1820: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id

Line 1841: UPDATE jty_terr_values_idx_header

1837:
1838: /* mark the indexes as obsolete for qualifers and qualifier combinations */
1839: /* that have beeen marked deleted in incremental mode */
1840: IF (p_mode = 'INCREMENTAL') THEN
1841: UPDATE jty_terr_values_idx_header
1842: SET build_index_flag = 'N'
1843: WHERE source_id = p_source_id
1844: AND delete_flag = 'Y';
1845: END IF;

Line 1885: UPDATE jty_terr_values_idx_header

1881:
1882: END LOOP; /* end loop FOR cl_set_L IN larger_or_eq_sets */
1883:
1884: IF S_subset_L = 'Y' THEN
1885: UPDATE jty_terr_values_idx_header
1886: SET BUILD_INDEX_FLAG = 'N'
1887: WHERE terr_values_idx_header_id = cl_set_S.terr_values_idx_header_id;
1888:
1889: END IF;