APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_TERR_VALUES_IDX_HEADER

Line 327: FROM jty_terr_values_idx_header

323: l_no_of_records := 0;
324:
325: SELECT count(*)
326: INTO l_no_of_records
327: FROM jty_terr_values_idx_header
328: WHERE source_id = p_source_id
329: AND relation_product = p_qual_prd_tbl(i);
330:
331: IF (l_no_of_records = 0) THEN

Line 333: SELECT jty_terr_values_idx_header_s.nextval

329: AND relation_product = p_qual_prd_tbl(i);
330:
331: IF (l_no_of_records = 0) THEN
332:
333: SELECT jty_terr_values_idx_header_s.nextval
334: INTO l_header_seq
335: FROM dual;
336:
337: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN' ||

Line 340: FROM jty_terr_values_idx_header

336:
337: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN' ||
338: (nvl(max(to_number(substr(index_name, instr(index_name, '_BN')+3))), 0) + 1)
339: INTO l_index_name
340: FROM jty_terr_values_idx_header
341: WHERE index_name like 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN%';
342:
343: INSERT INTO jty_terr_values_idx_header (
344: terr_values_idx_header_id

Line 343: INSERT INTO jty_terr_values_idx_header (

339: INTO l_index_name
340: FROM jty_terr_values_idx_header
341: WHERE index_name like 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_BN%';
342:
343: INSERT INTO jty_terr_values_idx_header (
344: terr_values_idx_header_id
345: ,source_id
346: ,last_update_date
347: ,last_updated_by

Line 1778: FROM jty_terr_values_idx_header A,

1774: S_subset_L VARCHAR2(1);
1775:
1776: CURSOR all_sets(cl_source_id number) is
1777: SELECT A.terr_values_idx_header_id, count(*) num_components
1778: FROM jty_terr_values_idx_header A,
1779: jty_terr_values_idx_details B
1780: WHERE A.source_id = cl_source_id
1781: AND A.build_index_flag = 'Y'
1782: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id

Line 1792: FROM jty_terr_values_idx_header A,

1788: , cl_source_id IN NUMBER
1789: , cl_terr_values_idx_header_id IN NUMBER) is
1790: SELECT * FROM (
1791: SELECT A.terr_values_idx_header_id, count(*) num_components
1792: FROM jty_terr_values_idx_header A,
1793: jty_terr_values_idx_details B
1794: WHERE A.source_id = cl_source_id
1795: AND A.terr_values_idx_header_id <> cl_terr_values_idx_header_id
1796: AND A.terr_values_idx_header_id = B.terr_values_idx_header_id

Line 1819: UPDATE jty_terr_values_idx_header

1815:
1816: /* mark the indexes as obsolete for qualifers and qualifier combinations */
1817: /* that have beeen marked deleted in incremental mode */
1818: IF (p_mode = 'INCREMENTAL') THEN
1819: UPDATE jty_terr_values_idx_header
1820: SET build_index_flag = 'N'
1821: WHERE source_id = p_source_id
1822: AND delete_flag = 'Y';
1823: END IF;

Line 1863: UPDATE jty_terr_values_idx_header

1859:
1860: END LOOP; /* end loop FOR cl_set_L IN larger_or_eq_sets */
1861:
1862: IF S_subset_L = 'Y' THEN
1863: UPDATE jty_terr_values_idx_header
1864: SET BUILD_INDEX_FLAG = 'N'
1865: WHERE terr_values_idx_header_id = cl_set_S.terr_values_idx_header_id;
1866:
1867: END IF;