APPS.XTR_HEDGE_PRO_TESTS_PKG dependencies on XTR_HEDGE_PRO_TESTS

Line 1: PACKAGE BODY XTR_HEDGE_PRO_TESTS_PKG as

1: PACKAGE BODY XTR_HEDGE_PRO_TESTS_PKG as
2: /* $Header: xtrhprob.pls 120.1 2005/06/29 08:27:31 badiredd noship $ */
3:
4: PROCEDURE INSERT_ROW(
5: X_ROWID IN OUT NOCOPY VARCHAR2,

Line 35: cursor C is select ROWID from XTR_HEDGE_PRO_TESTS

31: X_CREATION_DATE DATE,
32: X_LAST_UPDATED_BY NUMBER,
33: X_LAST_UPDATE_DATE DATE,
34: X_LAST_UPDATE_LOGIN NUMBER) IS
35: cursor C is select ROWID from XTR_HEDGE_PRO_TESTS
36: where HEDGE_PRO_TEST_ID = X_HEDGE_PRO_TEST_ID;
37:
38: BEGIN
39: INSERT INTO XTR_HEDGE_PRO_TESTS(

Line 39: INSERT INTO XTR_HEDGE_PRO_TESTS(

35: cursor C is select ROWID from XTR_HEDGE_PRO_TESTS
36: where HEDGE_PRO_TEST_ID = X_HEDGE_PRO_TEST_ID;
37:
38: BEGIN
39: INSERT INTO XTR_HEDGE_PRO_TESTS(
40: HEDGE_PRO_TEST_ID,
41: HEDGE_ATTRIBUTE_ID,
42: COMPANY_CODE,
43: RESULT_CODE,

Line 113: DELETE FROM XTR_HEDGE_PRO_TESTS

109: PROCEDURE DELETE_ROW (X_HEDGE_PRO_TEST_ID NUMBER) IS
110:
111: BEGIN
112: -- DELETE THE ROW, SINCE NOT USED ANYWHERE ELSE
113: DELETE FROM XTR_HEDGE_PRO_TESTS
114: WHERE HEDGE_PRO_TEST_ID = X_HEDGE_PRO_TEST_ID;
115: IF (SQL%NOTFOUND) THEN
116: RAISE NO_DATA_FOUND;
117: END IF;

Line 151: UPDATE XTR_HEDGE_PRO_TESTS

147: X_LAST_UPDATED_BY NUMBER,
148: X_LAST_UPDATE_DATE DATE,
149: X_LAST_UPDATE_LOGIN NUMBER) IS
150: BEGIN
151: UPDATE XTR_HEDGE_PRO_TESTS
152: SET
153: HEDGE_PRO_TEST_ID = X_HEDGE_PRO_TEST_ID,
154: HEDGE_ATTRIBUTE_ID = X_HEDGE_ATTRIBUTE_ID,
155: COMPANY_CODE = X_COMPANY_CODE,

Line 216: FROM XTR_HEDGE_PRO_TESTS

212: X_ATTRIBUTE15 VARCHAR2) IS
213:
214: CURSOR C IS
215: SELECT *
216: FROM XTR_HEDGE_PRO_TESTS
217: WHERE HEDGE_PRO_TEST_ID = X_HEDGE_PRO_TEST_ID
218: FOR UPDATE OF RESULT_CODE NOWAIT;
219: RECINFO C%ROWTYPE;
220:

Line 307: END XTR_HEDGE_PRO_TESTS_PKG;

303: APP_EXCEPTION.RAISE_EXCEPTION;
304: END IF;
305: END LOCK_ROW;
306:
307: END XTR_HEDGE_PRO_TESTS_PKG;
308: