APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_DEA_VALUES_IDX_HEADER

Line 1057: FROM jty_dea_values_idx_header

1053: l_no_of_records := 0;
1054:
1055: SELECT count(*)
1056: INTO l_no_of_records
1057: FROM jty_dea_values_idx_header
1058: WHERE source_id = p_source_id
1059: AND relation_product = p_qual_prd_tbl(i);
1060:
1061: IF (l_no_of_records = 0) THEN

Line 1063: SELECT jty_dea_values_idx_header_s.nextval

1059: AND relation_product = p_qual_prd_tbl(i);
1060:
1061: IF (l_no_of_records = 0) THEN
1062:
1063: SELECT jty_dea_values_idx_header_s.nextval
1064: INTO l_header_seq
1065: FROM dual;
1066:
1067: INSERT INTO jty_dea_values_idx_header (

Line 1067: INSERT INTO jty_dea_values_idx_header (

1063: SELECT jty_dea_values_idx_header_s.nextval
1064: INTO l_header_seq
1065: FROM dual;
1066:
1067: INSERT INTO jty_dea_values_idx_header (
1068: dea_values_idx_header_id
1069: ,source_id
1070: ,last_update_date
1071: ,last_updated_by

Line 1663: FROM jty_dea_values_idx_header A,

1659: S_subset_L VARCHAR2(1);
1660:
1661: CURSOR all_sets(cl_source_id number) is
1662: SELECT A.dea_values_idx_header_id, count(*) num_components
1663: FROM jty_dea_values_idx_header A,
1664: jty_dea_values_idx_details B
1665: WHERE A.source_id = cl_source_id
1666: AND A.dea_values_idx_header_id = B.dea_values_idx_header_id
1667: AND B.values_col_map is not null

Line 1676: FROM jty_dea_values_idx_header A,

1672: , cl_source_id IN NUMBER
1673: , cl_dea_values_idx_header_id IN NUMBER) is
1674: SELECT * FROM (
1675: SELECT A.dea_values_idx_header_id, count(*) num_components
1676: FROM jty_dea_values_idx_header A,
1677: jty_dea_values_idx_details B
1678: WHERE A.source_id = cl_source_id
1679: AND A.dea_values_idx_header_id <> cl_dea_values_idx_header_id
1680: AND A.dea_values_idx_header_id = B.dea_values_idx_header_id

Line 1738: UPDATE jty_dea_values_idx_header

1734:
1735: END LOOP; /* end loop FOR cl_set_L IN larger_or_eq_sets */
1736:
1737: IF S_subset_L = 'Y' THEN
1738: UPDATE jty_dea_values_idx_header
1739: SET BUILD_INDEX_FLAG = 'N'
1740: WHERE dea_values_idx_header_id = cl_set_S.dea_values_idx_header_id;
1741:
1742: END IF;