1 PACKAGE GR_ITEM_DOCUMENT_DTLS_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIIDDS.pls 115.4 2002/10/25 20:30:36 methomas ship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_item_code IN VARCHAR2,
7 p_document_code IN VARCHAR2,
8 p_phrase_code IN VARCHAR2,
9 p_display_order IN NUMBER,
10 p_main_heading_code IN VARCHAR2,
11 p_sub_heading_code IN VARCHAR2,
12 p_print_size IN NUMBER,
13 p_print_font IN VARCHAR2,
14 p_created_by IN NUMBER,
15 p_creation_date IN DATE,
16 p_last_updated_by IN NUMBER,
17 p_last_update_date IN DATE,
18 p_last_update_login IN NUMBER,
19 p_phrase_group_code IN VARCHAR2,
20 x_rowid OUT NOCOPY VARCHAR2,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_oracle_error OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2);
24 PROCEDURE Update_Row
25 (p_commit IN VARCHAR2,
26 p_called_by_form IN VARCHAR2,
27 p_rowid IN VARCHAR2,
28 p_item_code IN VARCHAR2,
29 p_document_code IN VARCHAR2,
30 p_phrase_code IN VARCHAR2,
31 p_display_order IN NUMBER,
32 p_main_heading_code IN VARCHAR2,
33 p_sub_heading_code IN VARCHAR2,
34 p_print_size IN NUMBER,
35 p_print_font IN VARCHAR2,
36 p_created_by IN NUMBER,
37 p_creation_date IN DATE,
38 p_last_updated_by IN NUMBER,
39 p_last_update_date IN DATE,
40 p_last_update_login IN NUMBER,
41 p_phrase_group_code IN VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_oracle_error OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2);
45 PROCEDURE Lock_Row
46 (p_commit IN VARCHAR2,
47 p_called_by_form IN VARCHAR2,
48 p_rowid IN VARCHAR2,
49 p_item_code IN VARCHAR2,
50 p_document_code IN VARCHAR2,
51 p_phrase_code IN VARCHAR2,
52 p_display_order IN NUMBER,
53 p_main_heading_code IN VARCHAR2,
54 p_sub_heading_code IN VARCHAR2,
55 p_print_size IN NUMBER,
56 p_print_font IN VARCHAR2,
57 p_created_by IN NUMBER,
58 p_creation_date IN DATE,
59 p_last_updated_by IN NUMBER,
60 p_last_update_date IN DATE,
61 p_last_update_login IN NUMBER,
62 p_phrase_group_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 PROCEDURE Delete_Row
67 (p_commit IN VARCHAR2,
68 p_called_by_form IN VARCHAR2,
69 p_rowid IN VARCHAR2,
70 p_item_code IN VARCHAR2,
71 p_document_code IN VARCHAR2,
72 p_phrase_code IN VARCHAR2,
73 p_display_order IN NUMBER,
74 p_main_heading_code IN VARCHAR2,
75 p_sub_heading_code IN VARCHAR2,
76 p_print_size IN NUMBER,
77 p_print_font IN VARCHAR2,
78 p_created_by IN NUMBER,
79 p_creation_date IN DATE,
80 p_last_updated_by IN NUMBER,
81 p_last_update_date IN DATE,
82 p_last_update_login IN NUMBER,
83 p_phrase_group_code IN VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_oracle_error OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2);
87 /*
88 ** p delete option has one of five values
89 ** 'I' - Delete all rows for the specified item.
90 ** 'D' - Delete all rows for the specified document.
91 ** 'P' - Delete all rows for the specified phrase.
92 */
93 PROCEDURE Delete_Rows
94 (p_commit IN VARCHAR2,
95 p_called_by_form IN VARCHAR2,
96 p_delete_option IN VARCHAR2,
97 p_item_code IN VARCHAR2,
98 p_document_code IN VARCHAR2,
99 p_phrase_code 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_Foreign_Keys
104 (p_item_code IN VARCHAR2,
105 p_document_code IN VARCHAR2,
106 p_phrase_code IN VARCHAR2,
107 p_display_order IN NUMBER,
108 p_main_heading_code IN VARCHAR2,
109 p_sub_heading_code IN VARCHAR2,
110 p_print_size IN NUMBER,
111 p_print_font IN VARCHAR2,
112 p_phrase_group_code IN VARCHAR2,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_oracle_error OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2);
116 PROCEDURE Check_Integrity
117 (p_called_by_form IN VARCHAR2,
118 p_item_code IN VARCHAR2,
119 p_document_code IN VARCHAR2,
120 p_phrase_code IN VARCHAR2,
121 p_display_order IN NUMBER,
122 p_main_heading_code IN VARCHAR2,
123 p_sub_heading_code IN VARCHAR2,
124 p_print_size IN NUMBER,
125 p_print_font IN VARCHAR2,
126 p_phrase_group_code IN VARCHAR2,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_oracle_error OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2);
130 PROCEDURE Check_Primary_Key
131 (p_item_code IN VARCHAR2,
132 p_document_code IN VARCHAR2,
133 p_phrase_code IN VARCHAR2,
134 p_display_order IN NUMBER,
135 p_called_by_form IN VARCHAR2,
136 x_rowid OUT NOCOPY VARCHAR2,
137 x_key_exists OUT NOCOPY VARCHAR2);
138 END GR_ITEM_DOCUMENT_DTLS_PKG;