APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_DEA_ATTR_PRODUCTS_S

Line 111: DELETE FROM jty_dea_attr_products_sql

107: ( SELECT NULL
108: FROM jty_dea_attr_products i
109: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
110:
111: DELETE FROM jty_dea_attr_products_sql
112: WHERE source_id = p_source_id
113: AND trans_type_id = p_trans_id
114: AND keep_flag <> 'Y';
115:

Line 192: DELETE FROM jty_dea_attr_products_sql

188: WHERE MOD(i.attr_relation_product, o.relation_factor) = 0 );
189:
190: IF (l_rel_prd_tbl.COUNT > 0) THEN
191: FORALL i IN l_rel_prd_tbl.FIRST .. l_rel_prd_tbl.LAST
192: DELETE FROM jty_dea_attr_products_sql
193: WHERE source_id = p_source_id
194: AND trans_type_id = p_trans_id
195: AND attr_relation_product = l_rel_prd_tbl(i)
196: AND keep_flag <> 'Y';

Line 1035: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL

1031: IF (p_qual_prd_tbl.COUNT > 0) THEN
1032: FOR i IN p_qual_prd_tbl.FIRST .. p_qual_prd_tbl.LAST LOOP
1033: l_counter := l_counter + 1;
1034:
1035: SELECT JTY_DEA_ATTR_PRODUCTS_S.NEXTVAL
1036: INTO l_qual_product_id
1037: FROM dual;
1038:
1039: -- POPULATE PRODUCTS