[Home] [Help]
PACKAGE: APPS.RRS_ATTR_PANE
Source
1 PACKAGE RRS_ATTR_PANE AUTHID CURRENT_USER AS
2 /* $Header: RRSGATPS.pls 120.8 2010/12/06 22:33:09 jijiao noship $ */
3
4
5 PROCEDURE Get_Primary_Attributes
6 (
7 p_object_type IN VARCHAR2,
8 p_object_id IN VARCHAR2,
9 x_primary_attributes OUT NOCOPY rrs_primary_attribute_rec,
10 x_error_messages OUT NOCOPY rrs_error_msg_tab
11 );
12
13 TYPE t_array_of_number IS TABLE OF NUMBER;
14 TYPE t_attribute_rec IS RECORD (attr_name VARCHAR2(30),
15 attr_display_name VARCHAR2(80),
16 display_code VARCHAR2(10), -- Bug Fix 9453429: Add display_code
17 description VARCHAR2(240),
18 sequence NUMBER);
19 TYPE t_attribute_tab IS TABLE OF t_attribute_rec;
20 TYPE t_page_entry_rec IS RECORD (attr_group_type VARCHAR2(40),
21 attr_group_name VARCHAR2(30),
22 sequence NUMBER);
23 TYPE t_page_entry_tab IS TABLE OF t_page_entry_rec;
24
25 e_no_uda EXCEPTION;
26 e_no_page_found EXCEPTION;
27 e_no_page_entry_found EXCEPTION;
28
29 PROCEDURE Get_Attribute_Page
30 (
31 p_where_used IN VARCHAR2,
32 p_object_type IN VARCHAR2,
33 p_object_id IN NUMBER,
34 p_object1 IN VARCHAR2,
35 p_classification_code1 IN VARCHAR2,
36 p_object2 IN VARCHAR2,
37 p_classification_code2 IN VARCHAR2,
38 x_primary_attributes OUT NOCOPY rrs_primary_attribute_rec,
39 x_ag_page_tab OUT NOCOPY rrs_attr_group_page_tab,
40 x_attr_group_tab OUT NOCOPY rrs_attribute_group_tab,
41 x_attribute_tab OUT NOCOPY rrs_attribute_tab,
42 x_error_messages OUT NOCOPY rrs_error_msg_tab
43 );
44
45 TYPE array_of_string IS TABLE OF VARCHAR2(200);
46 TYPE attr_info_rec IS RECORD (database_column EGO_ATTRS_V.DATABASE_COLUMN%TYPE,
47 data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE,
48 info_1 EGO_ATTRS_V.INFO_1%TYPE,
49 uom_class EGO_ATTRS_V.UOM_CLASS%TYPE,
50 value_set_id EGO_ATTRS_V.VALUE_SET_ID%TYPE,
51 validation_code EGO_ATTRS_V.VALIDATION_CODE%TYPE,
52 display_code EGO_ATTRS_V.DISPLAY_CODE%TYPE,
53 display_meaning EGO_ATTRS_V.DISPLAY_MEANING%TYPE);
54
55 e_no_attribute_found EXCEPTION;
56 e_no_attr_group_found EXCEPTION;
57 e_no_ext_row_found EXCEPTION;
58 e_no_uom_found EXCEPTION;
59 e_no_value_set_value_found EXCEPTION;
60 e_invalid_where_clause EXCEPTION;
61
62 PROCEDURE Get_Display_Value
63 (
64 p_object_type IN VARCHAR2,
65 p_object_id IN NUMBER,
66 p_attr_group_type IN VARCHAR2,
67 p_attr_group_name IN VARCHAR2,
68 p_attr_name IN VARCHAR2,
69 p_ext_id IN NUMBER,
70 x_display_value OUT NOCOPY VARCHAR2,
71 x_display_type OUT NOCOPY VARCHAR2,
72 x_dynamic_url OUT NOCOPY VARCHAR2,
73 x_error_messages OUT NOCOPY rrs_error_msg_tab
74 );
75
76 Procedure Get_Display_Value
77 (
78 p_object_type IN VARCHAR2,
79 p_object_id IN NUMBER,
80 p_attr_group_id IN NUMBER,
81 p_ext_id IN NUMBER,
82 p_column_name IN VARCHAR2,
83 x_display_value OUT NOCOPY VARCHAR2,
84 x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 --Added for Bug Fix 6969229
88 Procedure Get_Disp_Value_Without_UOM
89 (
90 p_object_type IN VARCHAR2,
91 p_object_id IN NUMBER,
92 p_attr_group_id IN NUMBER,
93 p_ext_id IN NUMBER,
94 p_column_name IN VARCHAR2,
95 x_display_value OUT NOCOPY VARCHAR2,
96 x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 -- Bug Fix 9709269: Convert Server Timezone to Client Timezone
100 FUNCTION To_Client_Timezone(p_date IN DATE)
101 RETURN TIMESTAMP;
102
103 PROCEDURE Record_Error
104 (
105 p_error_message IN VARCHAR2,
106 x_error_messages OUT NOCOPY rrs_error_msg_tab
107 );
108
109 --PROCEDURE TEST;
110
111 END RRS_ATTR_PANE;