1 PACKAGE GR_DOC_HDR_FTR_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIDHFS.pls 115.1 2002/10/28 23:02:38 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_line_type IN NUMBER,
8 p_line_no IN NUMBER,
9 p_left_label_code IN VARCHAR2,
10 p_right_label_code IN VARCHAR2,
11 p_created_by IN NUMBER,
12 p_creation_date IN DATE,
13 p_last_updated_by IN NUMBER,
14 p_last_update_date IN DATE,
15 p_last_update_login IN NUMBER,
16 x_rowid OUT NOCOPY VARCHAR2,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_oracle_error OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2);
20 PROCEDURE Update_Row
21 (p_commit IN VARCHAR2,
22 p_called_by_form IN VARCHAR2,
23 p_rowid IN VARCHAR2,
24 p_document_code IN VARCHAR2,
25 p_line_type IN NUMBER,
26 p_line_no IN NUMBER,
27 p_left_label_code IN VARCHAR2,
28 p_right_label_code IN VARCHAR2,
29 p_created_by IN NUMBER,
30 p_creation_date IN DATE,
31 p_last_updated_by IN NUMBER,
32 p_last_update_date IN DATE,
33 p_last_update_login IN NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_oracle_error OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2);
37 PROCEDURE Lock_Row
38 (p_commit IN VARCHAR2,
39 p_called_by_form IN VARCHAR2,
40 p_rowid IN VARCHAR2,
41 p_document_code IN VARCHAR2,
42 p_line_type IN NUMBER,
43 p_line_no IN NUMBER,
44 p_left_label_code IN VARCHAR2,
45 p_right_label_code IN VARCHAR2,
46 p_created_by IN NUMBER,
47 p_creation_date IN DATE,
48 p_last_updated_by IN NUMBER,
49 p_last_update_date IN DATE,
50 p_last_update_login IN NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_oracle_error OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2);
54 PROCEDURE Delete_Row
55 (p_commit IN VARCHAR2,
56 p_called_by_form IN VARCHAR2,
57 p_rowid IN VARCHAR2,
58 p_document_code IN VARCHAR2,
59 p_line_type IN NUMBER,
60 p_line_no IN NUMBER,
61 p_left_label_code IN VARCHAR2,
62 p_right_label_code IN VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_oracle_error OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67 PROCEDURE Check_Foreign_Keys
68 (p_document_code IN VARCHAR2,
69 p_left_label_code IN VARCHAR2,
70 p_right_label_code IN VARCHAR2,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_oracle_error OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2);
74 PROCEDURE Check_Integrity
75 (p_called_by_form IN VARCHAR2,
76 p_document_code IN VARCHAR2,
77 p_line_type IN NUMBER,
78 p_line_no IN NUMBER,
79 p_left_label_code IN VARCHAR2,
80 p_right_label_code IN VARCHAR2,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_oracle_error OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2);
84 PROCEDURE Check_Primary_Key
85 (p_document_code IN VARCHAR2,
86 p_line_type IN NUMBER,
87 p_line_no IN NUMBER,
88 p_left_label_code IN VARCHAR2,
89 p_right_label_code IN VARCHAR2,
90 p_called_by_form IN VARCHAR2,
91 x_rowid OUT NOCOPY VARCHAR2,
92 x_key_exists OUT NOCOPY VARCHAR2);
93 END GR_DOC_HDR_FTR_PKG;