1 PACKAGE GR_DOCUMENT_CODES_TL_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIDCTS.pls 115.4 2002/10/28 19:11:16 mgrosser noship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_document_code IN VARCHAR2,
7 p_language IN VARCHAR2,
8 p_description IN VARCHAR2,
9 p_source_lang IN VARCHAR2,
10 p_created_by IN NUMBER,
11 p_creation_date IN DATE,
12 p_last_updated_by IN NUMBER,
13 p_last_update_date IN DATE,
14 p_last_update_login IN NUMBER,
15 x_rowid OUT NOCOPY VARCHAR2,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_oracle_error OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2);
19 PROCEDURE Update_Row
20 (p_commit IN VARCHAR2,
21 p_called_by_form IN VARCHAR2,
22 p_rowid IN VARCHAR2,
23 p_document_code IN VARCHAR2,
24 p_language IN VARCHAR2,
25 p_description IN VARCHAR2,
26 p_source_lang IN VARCHAR2,
27 p_created_by IN NUMBER,
28 p_creation_date IN DATE,
29 p_last_updated_by IN NUMBER,
30 p_last_update_date IN DATE,
31 p_last_update_login IN NUMBER,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_oracle_error OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2);
35
36 PROCEDURE Add_Language
37 (p_commit IN VARCHAR2,
38 p_called_by_form IN VARCHAR2,
39 p_document_code IN VARCHAR2,
40 p_language IN VARCHAR2,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_oracle_error OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2);
44
45 PROCEDURE Lock_Row
46 (p_commit IN VARCHAR2,
47 p_called_by_form IN VARCHAR2,
48 p_rowid IN VARCHAR2,
49 p_document_code IN VARCHAR2,
50 p_language IN VARCHAR2,
51 p_description IN VARCHAR2,
52 p_source_lang IN VARCHAR2,
53 p_created_by IN NUMBER,
54 p_creation_date IN DATE,
55 p_last_updated_by IN NUMBER,
56 p_last_update_date IN DATE,
57 p_last_update_login IN NUMBER,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_oracle_error OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2);
61 PROCEDURE Delete_Row
62 (p_commit IN VARCHAR2,
63 p_called_by_form IN VARCHAR2,
64 p_rowid IN VARCHAR2,
65 p_document_code IN VARCHAR2,
66 p_language IN VARCHAR2,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_oracle_error OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2);
70
71 PROCEDURE Delete_Rows
72 (p_commit IN VARCHAR2,
73 p_called_by_form IN VARCHAR2,
74 p_document_code IN VARCHAR2,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_oracle_error OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2);
78
79 PROCEDURE Check_Foreign_Keys
80 (p_document_code IN VARCHAR2,
81 p_language IN VARCHAR2,
82 p_source_lang IN VARCHAR2,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_oracle_error OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2);
86 PROCEDURE Check_Integrity
87 (p_called_by_form IN VARCHAR2,
88 p_document_code IN VARCHAR2,
89 p_language IN VARCHAR2,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_oracle_error OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2);
93 PROCEDURE Check_Primary_Key
94 (p_document_code IN VARCHAR2,
95 p_language IN VARCHAR2,
96 p_called_by_form IN VARCHAR2,
97 x_rowid OUT NOCOPY VARCHAR2,
98 x_key_exists OUT NOCOPY VARCHAR2);
99 PROCEDURE translate_row (
100 X_DOCUMENT_CODE IN VARCHAR2
101 ,X_LANGUAGE IN VARCHAR2
102 ,X_DESCRIPTION IN VARCHAR2
103 ,X_SOURCE_LANG IN VARCHAR2
104 );
105
106 PROCEDURE load_row (
107 X_DOCUMENT_CODE IN VARCHAR2
108 ,X_LANGUAGE IN VARCHAR2
109 ,X_DESCRIPTION IN VARCHAR2
110 ,X_SOURCE_LANG IN VARCHAR2
111 );
112
113 PROCEDURE NEW_LANGUAGE;
114
115 END GR_DOCUMENT_CODES_TL_PKG;