1 package GMD_CUSTOMER_TESTS_PVT AUTHID CURRENT_USER as
2 /* $Header: GMDVTCUS.pls 115.4 2002/12/03 17:10:19 cnagarba noship $*/
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy ROWID,
6 X_TEST_ID in NUMBER,
7 X_CUST_ID in NUMBER,
8 X_REPORT_PRECISION in NUMBER,
9 X_TEXT_CODE in NUMBER,
10 X_CUST_TEST_DISPLAY in VARCHAR2,
11 X_CREATION_DATE in DATE,
12 X_CREATED_BY in NUMBER,
13 X_LAST_UPDATE_DATE in DATE,
14 X_LAST_UPDATED_BY in NUMBER,
15 X_LAST_UPDATE_LOGIN in NUMBER);
16
17 FUNCTION INSERT_ROW(p_customer_tests_rec IN GMD_CUSTOMER_TESTS%ROWTYPE) RETURN BOOLEAN ;
18
19 procedure LOCK_ROW (
20 X_TEST_ID in NUMBER,
21 X_CUST_ID in NUMBER,
22 X_REPORT_PRECISION in NUMBER,
23 X_TEXT_CODE in NUMBER,
24 X_CUST_TEST_DISPLAY in VARCHAR2
25 );
26 procedure UPDATE_ROW (
27 X_TEST_ID in NUMBER,
28 X_CUST_ID in NUMBER,
29 X_REPORT_PRECISION in NUMBER,
30 X_TEXT_CODE in NUMBER,
31 X_CUST_TEST_DISPLAY in VARCHAR2,
32 X_LAST_UPDATE_DATE in DATE,
33 X_LAST_UPDATED_BY in NUMBER,
34 X_LAST_UPDATE_LOGIN in NUMBER
35 );
36
37 FUNCTION DELETE_ROW (
38 P_TEST_ID IN NUMBER,
39 P_CUST_ID IN NUMBER) RETURN BOOLEAN ;
40
41 FUNCTION lock_row (
42 P_TEST_ID IN NUMBER,
43 P_CUST_ID IN NUMBER) RETURN BOOLEAN ;
44
45 procedure ADD_LANGUAGE;
46 end GMD_CUSTOMER_TESTS_PVT;