APPS.JTY_CUST_QUAL_PKG dependencies on JTF_QUAL_USGS_ALL

Line 25: /* and UPDATE_ATTR_VAL_STMT in the table jtf_qual_usgs_all */

21:
22: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
23:
24: /* this procedure forms the insert and update statement for the columns UPDATE_ATTR_VAL_STMT */
25: /* and UPDATE_ATTR_VAL_STMT in the table jtf_qual_usgs_all */
26: PROCEDURE get_attr_val_stmt(
27: p_comparison_operator IN VARCHAR2,
28: p_low_value_char IN VARCHAR2,
29: p_high_value_char IN VARCHAR2,

Line 277: /* Check to see if the unique id is alreday present in jtf_qual_usgs_all */

273: errbuf := 'Unique ID alreday present in jtf_seeded_qual_all_b';
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:
277: /* Check to see if the unique id is alreday present in jtf_qual_usgs_all */
278: SELECT count(*)
279: INTO l_count
280: FROM jtf_qual_usgs_all
281: WHERE qual_usg_id = p_seeded_qual_id;

Line 280: FROM jtf_qual_usgs_all

276:
277: /* Check to see if the unique id is alreday present in jtf_qual_usgs_all */
278: SELECT count(*)
279: INTO l_count
280: FROM jtf_qual_usgs_all
281: WHERE qual_usg_id = p_seeded_qual_id;
282:
283: IF (l_count > 0) THEN
284: retcode := 2;

Line 285: errbuf := 'Unique ID alreday present in jtf_qual_usgs_all';

281: WHERE qual_usg_id = p_seeded_qual_id;
282:
283: IF (l_count > 0) THEN
284: retcode := 2;
285: errbuf := 'Unique ID alreday present in jtf_qual_usgs_all';
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: /* get the qual_type_usg_id corr to source and transaction type */

Line 391: INSERT INTO JTF_QUAL_USGS_ALL (

387: p_description,
388: null,
389: null);
390:
391: INSERT INTO JTF_QUAL_USGS_ALL (
392: QUAL_USG_ID,
393: LAST_UPDATE_DATE,
394: LAST_UPDATED_BY,
395: CREATION_DATE,