APPS.JTY_TAE_CONTROL_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 131: jtf_qual_type_usgs_all b

127: AND trans_object_type_id = p_trans_id
128: AND relation_product not in (
129: SELECT qual_relation_product
130: FROM jtf_terr_qtype_usgs_all a,
131: jtf_qual_type_usgs_all b
132: WHERE a.qual_type_usg_id = b.qual_type_usg_id
133: AND b.source_id = p_source_id
134: AND b.qual_type_id = p_trans_id)
135: RETURNING qual_product_id, relation_product BULK COLLECT INTO l_qual_prd_id_tbl, l_rel_prd_tbl;

Line 172: jtf_qual_type_usgs_all b

168: AND trans_type_id = p_trans_id
169: AND attr_relation_product not in (
170: SELECT qual_relation_product
171: FROM jtf_terr_qtype_usgs_all a,
172: jtf_qual_type_usgs_all b
173: WHERE a.qual_type_usg_id = b.qual_type_usg_id
174: AND b.source_id = p_source_id
175: AND b.qual_type_id = p_trans_id)
176: RETURNING dea_attr_products_id, attr_relation_product BULK COLLECT INTO l_qual_prd_id_tbl, l_rel_prd_tbl;

Line 279: FROM jtf_qual_type_usgs_all

275:
276: BEGIN
277: SELECT qual_type_usg_id
278: INTO l_qual_type_usg_id
279: FROM jtf_qual_type_usgs_all
280: WHERE source_id = p_source_id
281: AND qual_type_id = p_trans_id;
282: EXCEPTION
283: WHEN NO_DATA_FOUND THEN

Line 284: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||

280: WHERE source_id = p_source_id
281: AND qual_type_id = p_trans_id;
282: EXCEPTION
283: WHEN NO_DATA_FOUND THEN
284: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
285: p_trans_id;
286: jty_log(FND_LOG.LEVEL_EXCEPTION,
287: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.no_qual_type_usg_id',
288: x_msg_data);

Line 1010: FROM jtf_qual_type_usgs_all

1006:
1007: BEGIN
1008: SELECT qual_type_usg_id
1009: INTO l_qual_type_usg_id
1010: FROM jtf_qual_type_usgs_all
1011: WHERE source_id = p_source_id
1012: AND qual_type_id = p_trans_id;
1013: EXCEPTION
1014: WHEN NO_DATA_FOUND THEN

Line 1015: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||

1011: WHERE source_id = p_source_id
1012: AND qual_type_id = p_trans_id;
1013: EXCEPTION
1014: WHEN NO_DATA_FOUND THEN
1015: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
1016: p_trans_id;
1017: jty_log(FND_LOG.LEVEL_EXCEPTION,
1018: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.no_qual_type_usg_id',
1019: x_msg_data);