APPS.JTF_XML_IA_PUB dependencies on JTF_XML_INV_AUTHS

Line 38: CURSOR auth_id_s IS SELECT JTF_XML_INV_AUTHS_S.NEXTVAL FROM sys.dual;

34:
35: l_row_id VARCHAR2(30) := NULL;
36: l_auth_id NUMBER := NULL;
37:
38: CURSOR auth_id_s IS SELECT JTF_XML_INV_AUTHS_S.NEXTVAL FROM sys.dual;
39:
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT CREATE_AUTH;

Line 69: insert into JTF_XML_INV_AUTHS (

65: OPEN auth_id_s;
66: FETCH auth_id_s INTO l_auth_id;
67: CLOSE auth_id_s;
68:
69: insert into JTF_XML_INV_AUTHS (
70: AUTH_ID,
71: URL,
72: AUTH_NAME,
73: AUTH_TYPE,

Line 192: FROM JTF_XML_INV_AUTHS

188:
189: -- real logic --
190: ----------------
191: SELECT OBJECT_VERSION_NUMBER INTO l_object_version
192: FROM JTF_XML_INV_AUTHS
193: WHERE AUTH_ID = p_AUTH_ID;
194:
195: -- checking for object version number
196: -- if (l_object_version IS NULL OR l_object_version > p_OBJ_VER_NUMBER) THEN

Line 205: update JTF_XML_INV_AUTHS set

201:
202: -- SELECT * INTO l_ip_row FROM JTF_XML_INV_PARAMS
203: -- WHERE PARAM_ID = p_PARAM_ID;
204:
205: update JTF_XML_INV_AUTHS set
206: END_DATE = SYSDATE,
207: OBJECT_VERSION_NUMBER = l_object_version,
208: LAST_UPDATE_DATE = SYSDATE,
209: LAST_UPDATED_BY = G_USER_ID,

Line 303: FROM JTF_XML_INV_AUTHS

299:
300: -- real logic --
301: -------------------------------
302: SELECT OBJECT_VERSION_NUMBER into x_OBJ_VER_NUMBER
303: FROM JTF_XML_INV_AUTHS
304: WHERE AUTH_ID = p_AUTH_ID;
305:
306: IF (sql%notfound) THEN
307: --raise no_data_found;

Line 403: FROM JTF_XML_INV_AUTHS

399:
400: -- real logic --
401: ----------------
402: SELECT OBJECT_VERSION_NUMBER INTO l_object_version
403: FROM JTF_XML_INV_AUTHS
404: WHERE AUTH_ID = p_AUTH_ID;
405:
406: -- checking for object version number
407: -- if (l_object_version IS NULL OR l_object_version > p_OBJ_VER_NUMBER) THEN

Line 416: update JTF_XML_INV_AUTHS set

412:
413: -- SELECT * INTO l_ip_row FROM JTF_XML_INV_PARAMS
414: -- WHERE PARAM_ID = p_PARAM_ID;
415:
416: update JTF_XML_INV_AUTHS set
417: URL = p_URL,
418: AUTH_NAME = p_AUTH_NAME,
419: AUTH_TYPE = p_AUTH_TYPE,
420: AUTH_INFO = p_AUTH_INFO,

Line 522: update JTF_XML_INV_AUTHS set

518:
519: -- SELECT * INTO l_ip_row FROM JTF_XML_INV_PARAMS
520: -- WHERE PARAM_ID = p_PARAM_ID;
521:
522: update JTF_XML_INV_AUTHS set
523: END_DATE = SYSDATE,
524: LAST_UPDATE_DATE = SYSDATE,
525: LAST_UPDATED_BY = G_USER_ID,
526: LAST_UPDATE_LOGIN = G_LOGIN_ID

Line 624: update JTF_XML_INV_AUTHS set

620:
621: -- SELECT * INTO l_ip_row FROM JTF_XML_INV_PARAMS
622: -- WHERE PARAM_ID = p_PARAM_ID;
623:
624: update JTF_XML_INV_AUTHS set
625: URL = p_NEW_URL,
626: LAST_UPDATE_DATE = SYSDATE,
627: LAST_UPDATED_BY = G_USER_ID,
628: LAST_UPDATE_LOGIN = G_LOGIN_ID