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