18: --
19: -- End of Comments
20: --
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(
257:
258: l_success_flag VARCHAR2(250);
259: l_error_code VARCHAR2(250);
260: BEGIN
261: l_user_id := FND_GLOBAL.USER_ID;
262: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
263: l_sysdate := sysdate;
264:
265: /* Check to see if the unique id is alreday present in jtf_seeded_qual_all_b */
258: l_success_flag VARCHAR2(250);
259: l_error_code VARCHAR2(250);
260: BEGIN
261: l_user_id := FND_GLOBAL.USER_ID;
262: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
263: l_sysdate := sysdate;
264:
265: /* Check to see if the unique id is alreday present in jtf_seeded_qual_all_b */
266: SELECT count(*)