APPS.JTF_XML_IA_PUB dependencies on JTF_XML_INV_AUTHS_S

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 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 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