1 PACKAGE GR_DOCUMENT_HEADINGS_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIDHS.pls 115.6 2002/10/28 23:01:30 mgrosser ship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_document_headings_seqno IN NUMBER,
7 p_document_code IN VARCHAR2,
8 p_main_heading_code IN VARCHAR2,
9 p_main_display_order IN NUMBER,
10 p_sub_heading_code IN VARCHAR2,
11 p_sub_display_order IN NUMBER,
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_current_seq OUT NOCOPY NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_oracle_error OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2);
22 PROCEDURE Update_Row
23 (p_commit IN VARCHAR2,
24 p_called_by_form IN VARCHAR2,
25 p_rowid IN VARCHAR2,
26 p_document_headings_seqno IN NUMBER,
27 p_document_code IN VARCHAR2,
28 p_main_heading_code IN VARCHAR2,
29 p_main_display_order IN NUMBER,
30 p_sub_heading_code IN VARCHAR2,
31 p_sub_display_order IN NUMBER,
32 p_created_by IN NUMBER,
33 p_creation_date IN DATE,
34 p_last_updated_by IN NUMBER,
35 p_last_update_date IN DATE,
36 p_last_update_login IN NUMBER,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_oracle_error OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2);
40
41
42 PROCEDURE Update_Display_Columns
43 (p_commit IN VARCHAR2,
44 p_called_by_form IN VARCHAR2,
45 p_document_headings_seqno IN NUMBER,
46 p_main_display_order IN NUMBER,
47 p_sub_display_order IN NUMBER,
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
55
56 PROCEDURE Lock_Row
57 (p_commit IN VARCHAR2,
58 p_called_by_form IN VARCHAR2,
59 p_rowid IN VARCHAR2,
60 p_document_headings_seqno IN NUMBER,
61 p_document_code IN VARCHAR2,
62 p_main_heading_code IN VARCHAR2,
63 p_main_display_order IN NUMBER,
64 p_sub_heading_code IN VARCHAR2,
65 p_sub_display_order IN NUMBER,
66 p_created_by IN NUMBER,
67 p_creation_date IN DATE,
68 p_last_updated_by IN NUMBER,
69 p_last_update_date IN DATE,
70 p_last_update_login IN NUMBER,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_oracle_error OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2);
74 PROCEDURE Delete_Row
75 (p_commit IN VARCHAR2,
76 p_called_by_form IN VARCHAR2,
77 p_rowid IN VARCHAR2,
78 p_document_headings_seqno IN NUMBER,
79 p_document_code IN VARCHAR2,
80 p_main_heading_code IN VARCHAR2,
81 p_main_display_order IN NUMBER,
82 p_sub_heading_code IN VARCHAR2,
83 p_sub_display_order IN NUMBER,
84 p_created_by IN NUMBER,
85 p_creation_date IN DATE,
86 p_last_updated_by IN NUMBER,
87 p_last_update_date IN DATE,
88 p_last_update_login IN NUMBER,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_oracle_error OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2);
92 PROCEDURE Delete_Rows
93 (p_commit IN VARCHAR2,
94 p_called_by_form IN VARCHAR2,
95 p_document_code IN VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_oracle_error OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2);
99 PROCEDURE Check_Foreign_Keys
100 (p_document_headings_seqno IN NUMBER,
101 p_document_code IN VARCHAR2,
102 p_main_heading_code IN VARCHAR2,
103 p_main_display_order IN NUMBER,
104 p_sub_heading_code IN VARCHAR2,
105 p_sub_display_order IN NUMBER,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_oracle_error OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2);
109 PROCEDURE Check_Integrity
110 (p_called_by_form IN VARCHAR2,
111 p_document_headings_seqno IN NUMBER,
112 p_document_code IN VARCHAR2,
113 p_main_heading_code IN VARCHAR2,
114 p_main_display_order IN NUMBER,
115 p_sub_heading_code IN VARCHAR2,
116 p_sub_display_order IN NUMBER,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_oracle_error OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2);
120 PROCEDURE Check_Primary_Key
121 (p_document_headings_seqno IN NUMBER,
122 p_called_by_form IN VARCHAR2,
123 x_rowid OUT NOCOPY VARCHAR2,
124 x_key_exists OUT NOCOPY VARCHAR2);
125
126 PROCEDURE Lock_Rows
127 (p_document_code IN VARCHAR2,
128 p_last_update_date IN DATE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_oracle_error OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2);
132 END GR_DOCUMENT_HEADINGS_PKG;