1 PACKAGE GR_PROCESS_DOCUMENTS_INSERTS AUTHID CURRENT_USER AS
2 /* $Header: GRPDOCIS.pls 115.1 2002/10/30 17:26:02 gkelly noship $ */
3
4 PROCEDURE Worksheet_Insert_Row
5 (p_line_number IN OUT NOCOPY NUMBER,
6 p_output_type IN VARCHAR2,
7 p_user_id IN NUMBER,
8 p_current_date IN DATE,
9 p_language_code IN VARCHAR2,
10 p_session_id IN NUMBER,
11 p_item_code IN VARCHAR2,
12 p_print_font IN VARCHAR2,
13 p_print_size IN NUMBER,
14 p_text_line IN VARCHAR2,
15 p_line_type IN VARCHAR2,
16 x_return_status OUT NOCOPY VARCHAR2);
17
18
19 PROCEDURE Document_Insert_Row
20 (p_line_number IN OUT NOCOPY NUMBER,
21 p_output_type IN VARCHAR2,
22 p_document_text_id IN NUMBER,
23 p_user_id IN NUMBER,
24 p_current_date IN DATE,
25 p_session_id IN NUMBER,
26 p_item_code IN VARCHAR2,
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 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_data OUT NOCOPY VARCHAR2);
33
34
35 PROCEDURE Insert_Work_Row
36 (p_session_id IN NUMBER,
37 p_document_code IN VARCHAR2,
38 p_main_heading_code IN VARCHAR2,
39 p_main_display_order IN NUMBER,
40 p_sub_heading_code IN VARCHAR2,
41 p_sub_display_order IN NUMBER,
42 p_record_type IN VARCHAR2,
43 p_label_or_phrase_code IN VARCHAR2,
44 p_concentration_percent IN NUMBER,
45 p_label_class IN VARCHAR2,
46 p_phrase_hierarchy IN NUMBER,
47 p_phrase_type IN VARCHAR2,
48 p_print_flag IN VARCHAR2,
49 p_source_itemcode IN VARCHAR2,
50 p_structure_display_order IN NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_data OUT NOCOPY VARCHAR2);
53
54
55 PROCEDURE Insert_Data_Record
56 (p_line_number IN OUT NOCOPY NUMBER,
57 p_line_type IN VARCHAR2,
58 p_output_type IN VARCHAR2,
59 p_user_id IN NUMBER,
60 p_current_date IN DATE,
61 p_language_code IN VARCHAR2,
62 p_document_text_id IN NUMBER,
63 p_session_id IN NUMBER,
64 p_document_item IN VARCHAR2,
65 p_print_font IN VARCHAR2,
66 p_print_size IN NUMBER,
67 p_text_line_1 IN VARCHAR2,
68 p_text_line_2 IN VARCHAR2,
69 p_source_action IN VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2);
71
72
73 PROCEDURE Insert_Gr_Work_Worksheets
74 (p_output_type IN VARCHAR2,
75 p_line_number IN OUT NOCOPY NUMBER,
76 p_session_id IN NUMBER,
77 p_item_code IN VARCHAR2,
78 p_print_font IN VARCHAR2,
79 p_print_size IN NUMBER,
80 p_text_line IN VARCHAR2,
81 p_line_type IN VARCHAR2,
82 x_return_status OUT NOCOPY VARCHAR2);
83
84
85 PROCEDURE Insert_XML_Data
86 (p_line_number IN OUT NOCOPY NUMBER,
87 p_output_type IN VARCHAR2,
88 p_user_id IN NUMBER,
89 p_current_date IN DATE,
90 p_language_code IN VARCHAR2,
91 p_document_text_id IN NUMBER,
92 p_session_id IN NUMBER,
93 p_document_item IN VARCHAR2,
94 p_print_font IN VARCHAR2,
95 p_print_size IN NUMBER,
96 p_value IN VARCHAR2,
97 p_line_type IN VARCHAR2,
98 p_source IN VARCHAR2,
99 x_return_status OUT NOCOPY VARCHAR2);
100
101
102 END GR_PROCESS_DOCUMENTS_INSERTS;
103
[Home] [Help]