eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JTY_TAE_CONTROL_PVT dependencies on JTF_TAE_QUAL_PRODUCTS

Line 48: TYPE l_qual_prd_id_tbl_type IS TABLE OF jtf_tae_qual_products.qual_product_id%TYPE;

44: ERRBUF OUT NOCOPY VARCHAR2,
45: RETCODE OUT NOCOPY VARCHAR2 )
46: IS
47:
48: TYPE l_qual_prd_id_tbl_type IS TABLE OF jtf_tae_qual_products.qual_product_id%TYPE;
49: TYPE l_rel_prd_tbl_type IS TABLE OF jtf_tae_qual_products.relation_product%TYPE;
50:
51: l_qual_prd_id_tbl l_qual_prd_id_tbl_type;
52: l_rel_prd_tbl l_rel_prd_tbl_type;

Line 49: TYPE l_rel_prd_tbl_type IS TABLE OF jtf_tae_qual_products.relation_product%TYPE;

45: RETCODE OUT NOCOPY VARCHAR2 )
46: IS
47:
48: TYPE l_qual_prd_id_tbl_type IS TABLE OF jtf_tae_qual_products.qual_product_id%TYPE;
49: TYPE l_rel_prd_tbl_type IS TABLE OF jtf_tae_qual_products.relation_product%TYPE;
50:
51: l_qual_prd_id_tbl l_qual_prd_id_tbl_type;
52: l_rel_prd_tbl l_rel_prd_tbl_type;
53: BEGIN

Line 67: FROM jtf_tae_qual_products

63:
64: DELETE FROM jtf_tae_qual_prod_factors
65: WHERE qual_product_id IN
66: ( SELECT qual_product_id
67: FROM jtf_tae_qual_products
68: WHERE source_id = p_source_id
69: AND trans_object_type_id = p_trans_id);
70:
71: DELETE FROM jtf_tae_qual_products

Line 71: DELETE FROM jtf_tae_qual_products

67: FROM jtf_tae_qual_products
68: WHERE source_id = p_source_id
69: AND trans_object_type_id = p_trans_id);
70:
71: DELETE FROM jtf_tae_qual_products
72: WHERE source_id = p_source_id
73: AND trans_object_type_id = p_trans_id;
74:
75: DELETE FROM jtf_tae_qual_factors o

Line 78: FROM jtf_tae_qual_products i

74:
75: DELETE FROM jtf_tae_qual_factors o
76: WHERE NOT EXISTS
77: ( SELECT NULL
78: FROM jtf_tae_qual_products i
79: WHERE MOD(i.relation_product, o.relation_factor) = 0 );
80:
81: DELETE FROM jty_tae_attr_products_sql
82: WHERE source_id = p_source_id

Line 125: DELETE FROM jtf_tae_qual_products

121: END;
122: ELSIF (p_mode = 'INCREMENTAL') THEN
123: BEGIN
124:
125: DELETE FROM jtf_tae_qual_products
126: WHERE source_id = p_source_id
127: AND trans_object_type_id = p_trans_id
128: AND relation_product not in (
129: SELECT qual_relation_product

Line 146: FROM jtf_tae_qual_products i

142:
143: DELETE FROM jtf_tae_qual_factors o
144: WHERE NOT EXISTS
145: ( SELECT NULL
146: FROM jtf_tae_qual_products i
147: WHERE MOD(i.relation_product, o.relation_factor) = 0 );
148:
149: IF (l_rel_prd_tbl.COUNT > 0) THEN
150: FORALL i IN l_rel_prd_tbl.FIRST .. l_rel_prd_tbl.LAST

Line 295: FROM jtf_tae_qual_products

291:
292: BEGIN
293: SELECT max(to_number(substr(index_name, instr(index_name, '_N') +2)))
294: INTO l_counter
295: FROM jtf_tae_qual_products
296: WHERE source_id = p_source_id
297: AND trans_object_type_id = p_trans_id;
298:
299: IF (l_counter IS NULL) THEN

Line 318: SELECT JTF_TAE_QUAL_PRODUCTS_S.NEXTVAL

314: IF (p_qual_prd_tbl.COUNT > 0) THEN
315: FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST LOOP
316: l_counter := l_counter + 1;
317:
318: SELECT JTF_TAE_QUAL_PRODUCTS_S.NEXTVAL
319: INTO l_qual_product_id
320: FROM dual;
321:
322: -- POPULATE PRODUCTS

Line 327: INSERT INTO JTF_TAE_QUAL_products

323: IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) THEN
324:
325: BEGIN
326:
327: INSERT INTO JTF_TAE_QUAL_products
328: ( QUAL_PRODUCT_ID,
329: RELATION_PRODUCT,
330: SOURCE_ID,
331: TRANS_OBJECT_TYPE_ID,

Line 1928: FROM JTF_TAE_QUAL_products p,

1924: l_first_char_flag_count NUMBER;
1925:
1926: CURSOR all_sets(cl_source_id number, cl_trans_id number) is
1927: SELECT p.trans_object_type_id, count(*) num_components, p.qual_product_id qual_product_id, p.relation_product
1928: FROM JTF_TAE_QUAL_products p,
1929: JTF_TAE_QUAL_prod_factors pf,
1930: JTF_TAE_QUAL_factors f
1931: WHERE p.qual_product_id = pf.qual_product_id
1932: AND pf.qual_factor_id = f.qual_factor_id

Line 1945: FROM JTF_TAE_QUAL_products p,

1941: , cl_source_id NUMBER
1942: , cl_trans_id NUMBER ) is
1943: SELECT * FROM (
1944: SELECT count(*) num_components, p.qual_product_id qual_product_id, p.relation_product
1945: FROM JTF_TAE_QUAL_products p,
1946: JTF_TAE_QUAL_prod_factors pf
1947: WHERE p.qual_product_id = pf.qual_product_id
1948: AND p.source_id = cl_source_id
1949: AND p.trans_object_type_id = cl_trans_id

Line 1957: FROM JTF_TAE_QUAL_products p

1953: ORDER BY 1 DESC, qual_product_id ASC;
1954:
1955: CURSOR all_empty_column_indexes(cl_source_id number, cl_trans_id number) is
1956: SELECT p.trans_object_type_id, p.qual_product_id, p.relation_product
1957: FROM JTF_TAE_QUAL_products p
1958: WHERE NOT EXISTS (SELECT *
1959: FROM JTF_TAE_QUAL_products ip,
1960: JTF_TAE_QUAL_prod_factors ipf,
1961: JTF_TAE_QUAL_factors ifc

Line 1959: FROM JTF_TAE_QUAL_products ip,

1955: CURSOR all_empty_column_indexes(cl_source_id number, cl_trans_id number) is
1956: SELECT p.trans_object_type_id, p.qual_product_id, p.relation_product
1957: FROM JTF_TAE_QUAL_products p
1958: WHERE NOT EXISTS (SELECT *
1959: FROM JTF_TAE_QUAL_products ip,
1960: JTF_TAE_QUAL_prod_factors ipf,
1961: JTF_TAE_QUAL_factors ifc
1962: WHERE use_tae_col_in_index_flag = 'Y'
1963: AND ip.qual_product_id = ipf.qual_product_id

Line 1996: FROM JTF_TAE_QUAL_products p,

1992: FROM (
1993: SELECT rownum row_count, tae_col_map, input_selectivity
1994: FROM (
1995: SELECT DISTINCT p.relation_product, f.tae_col_map, f.input_selectivity
1996: FROM JTF_TAE_QUAL_products p,
1997: JTF_TAE_QUAL_prod_factors pf,
1998: JTF_TAE_QUAL_factors f
1999: WHERE f.qual_factor_id = pf.qual_factor_id
2000: AND pf.qual_product_id = p.qual_product_id

Line 2010: FROM JTF_TAE_QUAL_products p,

2006: (
2007: SELECT rownum row_count, tae_col_map, input_selectivity
2008: FROM (
2009: SELECT DISTINCT p.relation_product, f.tae_col_map, f.input_selectivity
2010: FROM JTF_TAE_QUAL_products p,
2011: JTF_TAE_QUAL_prod_factors pf,
2012: JTF_TAE_QUAL_factors f
2013: WHERE f.qual_factor_id = pf.qual_factor_id
2014: AND pf.qual_product_id = p.qual_product_id

Line 2059: UPDATE JTF_TAE_QUAL_PRODUCTS

2055: l_first_char_flag := 'N';
2056: END IF;
2057:
2058: IF S_subset_L = 'Y' THEN
2059: UPDATE JTF_TAE_QUAL_PRODUCTS
2060: SET BUILD_INDEX_FLAG = 'N', FIRST_CHAR_FLAG = l_first_char_flag
2061: WHERE qual_product_id = cl_set_S.qual_product_id
2062: AND RELATION_PRODUCT NOT IN (4841, 324347);
2063:

Line 2064: UPDATE JTF_TAE_QUAL_PRODUCTS

2060: SET BUILD_INDEX_FLAG = 'N', FIRST_CHAR_FLAG = l_first_char_flag
2061: WHERE qual_product_id = cl_set_S.qual_product_id
2062: AND RELATION_PRODUCT NOT IN (4841, 324347);
2063:
2064: UPDATE JTF_TAE_QUAL_PRODUCTS
2065: SET FIRST_CHAR_FLAG = l_first_char_flag
2066: WHERE qual_product_id = cl_set_S.qual_product_id
2067: AND RELATION_PRODUCT IN (4841, 324347);
2068: ELSE

Line 2069: UPDATE JTF_TAE_QUAL_PRODUCTS

2065: SET FIRST_CHAR_FLAG = l_first_char_flag
2066: WHERE qual_product_id = cl_set_S.qual_product_id
2067: AND RELATION_PRODUCT IN (4841, 324347);
2068: ELSE
2069: UPDATE JTF_TAE_QUAL_PRODUCTS
2070: SET BUILD_INDEX_FLAG = 'Y', FIRST_CHAR_FLAG = l_first_char_flag
2071: WHERE qual_product_id = cl_set_S.qual_product_id;
2072: END IF;
2073:

Line 2074: UPDATE JTF_TAE_QUAL_PRODUCTS

2070: SET BUILD_INDEX_FLAG = 'Y', FIRST_CHAR_FLAG = l_first_char_flag
2071: WHERE qual_product_id = cl_set_S.qual_product_id;
2072: END IF;
2073:
2074: UPDATE JTF_TAE_QUAL_PRODUCTS
2075: SET FIRST_CHAR_FLAG = 'Y'
2076: WHERE qual_product_id = cl_set_S.qual_product_id
2077: AND RELATION_PRODUCT = 353393;
2078:

Line 2084: UPDATE JTF_TAE_QUAL_PRODUCTS p

2080:
2081: -- Set reduction complete
2082: -- Set build_index_flag = 'N' for all empty column indexes combinations
2083: FOR empty_column_index in all_empty_column_indexes(p_source_id, p_trans_id) LOOP
2084: UPDATE JTF_TAE_QUAL_PRODUCTS p
2085: SET BUILD_INDEX_FLAG = 'N'
2086: WHERE p.qual_product_id = empty_column_index.qual_product_id;
2087: END LOOP;
2088: