PACKAGE: APPS.XTR_HEDGE_PRO_TESTS_PKG

Source

1 PACKAGE XTR_HEDGE_PRO_TESTS_PKG as
2 /* $Header: xtrhpros.pls 120.2 2005/06/29 08:28:46 badiredd noship $ */
3 
4 PROCEDURE INSERT_ROW(
5 		X_ROWID IN OUT NOCOPY VARCHAR2,
6 		X_HEDGE_PRO_TEST_ID NUMBER,
7 		X_HEDGE_ATTRIBUTE_ID NUMBER,
8 		X_COMPANY_CODE VARCHAR2,
9 		X_RESULT_CODE VARCHAR2,
10 		X_RESULT_DATE DATE,
11 		X_LAST_TEST_DATE DATE,
12 		X_PERFORMED_BY NUMBER,
13 		X_COMMENTS VARCHAR2,
14 		X_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
15 		X_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
16 		X_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
17 		X_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
18 		X_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
19 		X_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
20 		X_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
21 		X_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
22 		X_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
23 		X_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
24 		X_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
25 		X_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
26 		X_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
27 		X_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
28 		X_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
29 		X_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
30 		X_CREATED_BY NUMBER,
31 		X_CREATION_DATE DATE,
32 		X_LAST_UPDATED_BY NUMBER,
33 		X_LAST_UPDATE_DATE DATE,
34 		X_LAST_UPDATE_LOGIN NUMBER);
35 
36 PROCEDURE DELETE_ROW (X_HEDGE_PRO_TEST_ID NUMBER);
37 
38 
39 PROCEDURE UPDATE_ROW(
40 		X_ROWID VARCHAR2,
41                 X_HEDGE_PRO_TEST_ID NUMBER,
42                 X_HEDGE_ATTRIBUTE_ID NUMBER,
43                 X_COMPANY_CODE VARCHAR2,
44                 X_RESULT_CODE VARCHAR2,
45                 X_RESULT_DATE DATE,
46                 X_LAST_TEST_DATE DATE,
47                 X_PERFORMED_BY NUMBER,
48                 X_COMMENTS VARCHAR2,
49 		X_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
50 		X_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
51 		X_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
52 		X_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
53 		X_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
54 		X_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
55 		X_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
56 		X_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
57 		X_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
58 		X_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
59 		X_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
60 		X_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
61 		X_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
62 		X_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
63 		X_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
64 		X_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
65 		X_LAST_UPDATED_BY NUMBER,
66 		X_LAST_UPDATE_DATE DATE,
67 		X_LAST_UPDATE_LOGIN NUMBER);
68 
69 PROCEDURE LOCK_ROW(
70 		X_ROWID VARCHAR2,
71                 X_HEDGE_PRO_TEST_ID NUMBER,
72                 X_HEDGE_ATTRIBUTE_ID NUMBER,
73                 X_COMPANY_CODE VARCHAR2,
74                 X_RESULT_CODE VARCHAR2,
75                 X_RESULT_DATE DATE,
76                 X_LAST_TEST_DATE DATE,
77                 X_PERFORMED_BY NUMBER,
78                 X_COMMENTS VARCHAR2,
79 		X_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
80 		X_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
81 		X_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
82 		X_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
83 		X_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
84 		X_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
85 		X_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
86 		X_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
87 		X_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
88 		X_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
89 		X_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
90 		X_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
91 		X_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
92 		X_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
93 		X_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
94 		X_ATTRIBUTE15 VARCHAR2 DEFAULT NULL);
95 
96 END XTR_HEDGE_PRO_TESTS_PKG;
97