APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_DEA_VALUES_IDX_HEADER

Line 1085: FROM jty_dea_values_idx_header

1081: l_no_of_records := 0;
1082:
1083: SELECT count(*)
1084: INTO l_no_of_records
1085: FROM jty_dea_values_idx_header
1086: WHERE source_id = p_source_id
1087: AND relation_product = p_qual_prd_tbl(i);
1088:
1089: IF (l_no_of_records = 0) THEN

Line 1091: SELECT jty_dea_values_idx_header_s.nextval

1087: AND relation_product = p_qual_prd_tbl(i);
1088:
1089: IF (l_no_of_records = 0) THEN
1090:
1091: SELECT jty_dea_values_idx_header_s.nextval
1092: INTO l_header_seq
1093: FROM dual;
1094:
1095: INSERT INTO jty_dea_values_idx_header (

Line 1095: INSERT INTO jty_dea_values_idx_header (

1091: SELECT jty_dea_values_idx_header_s.nextval
1092: INTO l_header_seq
1093: FROM dual;
1094:
1095: INSERT INTO jty_dea_values_idx_header (
1096: dea_values_idx_header_id
1097: ,source_id
1098: ,last_update_date
1099: ,last_updated_by

Line 1684: FROM jty_dea_values_idx_header A,

1680: S_subset_L VARCHAR2(1);
1681:
1682: CURSOR all_sets(cl_source_id number) is
1683: SELECT A.dea_values_idx_header_id, count(*) num_components
1684: FROM jty_dea_values_idx_header A,
1685: jty_dea_values_idx_details B
1686: WHERE A.source_id = cl_source_id
1687: AND A.dea_values_idx_header_id = B.dea_values_idx_header_id
1688: AND B.values_col_map is not null

Line 1697: FROM jty_dea_values_idx_header A,

1693: , cl_source_id IN NUMBER
1694: , cl_dea_values_idx_header_id IN NUMBER) is
1695: SELECT * FROM (
1696: SELECT A.dea_values_idx_header_id, count(*) num_components
1697: FROM jty_dea_values_idx_header A,
1698: jty_dea_values_idx_details B
1699: WHERE A.source_id = cl_source_id
1700: AND A.dea_values_idx_header_id <> cl_dea_values_idx_header_id
1701: AND A.dea_values_idx_header_id = B.dea_values_idx_header_id

Line 1722: UPDATE jty_dea_values_idx_header

1718:
1719: /* mark the indexes as obsolete for qualifers and qualifier combinations */
1720: /* that have beeen marked deleted in incremental mode */
1721: IF (p_mode = 'DEA INCREMENTAL') THEN
1722: UPDATE jty_dea_values_idx_header
1723: SET delete_flag = 'N'
1724: WHERE source_id = p_source_id
1725: AND delete_flag = 'Y';
1726: END IF;

Line 1766: UPDATE jty_dea_values_idx_header

1762:
1763: END LOOP; /* end loop FOR cl_set_L IN larger_or_eq_sets */
1764:
1765: IF S_subset_L = 'Y' THEN
1766: UPDATE jty_dea_values_idx_header
1767: SET BUILD_INDEX_FLAG = 'N'
1768: WHERE dea_values_idx_header_id = cl_set_S.dea_values_idx_header_id;
1769:
1770: END IF;