1 PACKAGE PON_FORMS_UTIL_PVT AUTHID CURRENT_USER as
2 /* $Header: PONFMUTS.pls 120.11 2011/11/16 07:22:38 nrayi ship $ */
3
4 PROCEDURE print_error_log(p_module IN VARCHAR2,
5 p_message IN VARCHAR2);
6
7 PROCEDURE print_debug_log(p_module IN VARCHAR2,
8 p_message IN VARCHAR2);
9
10 Function GetSYSTEMDate(p_field_code in Varchar2,
11 p_id in Varchar2) return Date;
12 Function GetSYSTEMNumber(p_field_code in Varchar2,
13 p_id in Varchar2) return Number;
14 Function GetSYSTEMChar(p_field_code in Varchar2,
15 p_id in Varchar2) return Varchar2;
16
17 Function GetFLEXINDENDENTVALUE(p_value_set_name in varchar2,
18 p_id_value in Varchar2) Return Varchar2;
19 Function GetFLEXTBLVALUE(p_field_code in varchar2,
20 p_id_value in Varchar2) Return Varchar2;
21
22 Procedure GENERATE_XMLQUERY (p_form_id in Number, -- top form
23 p_query_stmt IN OUT NOCOPY Varchar2,
24 p_error IN OUT NOCOPY VARCHAR2,
25 p_result IN OUT NOCOPY number -- 0: Success, 1: failure
26 );
27 Procedure GENERATE_XMLSCHEMA (p_form_id in Number, -- top form
28 p_schema OUT NOCOPY CLOB,
29 p_error IN OUT NOCOPY VARCHAR2,
30 p_result IN OUT NOCOPY number, -- 0: Success, 1: failure
31 x_xml_query OUT NOCOPY VARCHAR2 ---The xml query
32 );
33 Procedure GENERATE_XML (p_form_id in Number, -- top form
34 p_entity_code Varchar2,
35 p_entity_pk1 Varchar2,
36 p_xml OUT NOCOPY CLOB,
37 p_xdo_stylesheet_code OUT NOCOPY VARCHAR2,
38 p_error OUT NOCOPY VARCHAR2,
39 p_result OUT NOCOPY number -- 0: Success, 1: failure
40 ) ;
41
42 PROCEDURE COMPILE_FORM(p_form_id IN NUMBER);
43
44
45
46 FUNCTION getDataEntryRegionName(p_form_id IN NUMBER) RETURN VARCHAR2;
47 FUNCTION getReadOnlyRegionName(p_form_id IN NUMBER) RETURN VARCHAR2;
48 FUNCTION getFlexValue(p_field_code IN VARCHAR2, p_mapping_column IN VARCHAR2, p_form_field_id IN NUMBER) RETURN VARCHAR2;
49
50 Procedure GetValSetQueryIdOrder ( p_value_set_name IN VARCHAR2,
51 p_query_stmt OUT NOCOPY Varchar2,
52 p_orderby OUT NOCOPY Varchar2,
53 p_id_column_exists OUT NOCOPY Varchar2,
54 p_is_table_based OUT NOCOPY VARCHAR2,
55 p_error OUT NOCOPY Varchar2,
56 p_result OUT NOCOPY number
57 );
58
59 PROCEDURE GENERATE_FORM_DETAILS (p_form_id IN NUMBER,
60 p_generate_mode IN VARCHAR2, -- ALL, XSD, JRAD
61 p_schema OUT NOCOPY CLOB,
62 p_error IN OUT NOCOPY VARCHAR2,
63 p_result IN OUT NOCOPY NUMBER -- 0: success, 1 - failure
64 );
65
66
67 procedure publishAbstract(p_auction_header_id IN NUMBER,
68 p_include_pdf_flag IN VARCHAR2,
69 p_publish_action IN VARCHAR2,
70 x_result OUT NOCOPY VARCHAR2,
71 x_error_code OUT NOCOPY VARCHAR2,
72 x_error_message OUT NOCOPY VARCHAR2);
73
74
75 PROCEDURE performPostSaveChanges(p_form_id IN NUMBER,
76 p_entity_pk1 IN VARCHAR2,
77 p_entity_code IN VARCHAR2,
78 p_include_pdf IN VARCHAR2,
79 x_result OUT NOCOPY VARCHAR2,
80 x_error_code OUT NOCOPY VARCHAR2,
81 x_error_message OUT NOCOPY VARCHAR2);
82
83
84 PROCEDURE deleteFormFieldValues(p_form_id IN NUMBER,
85 p_entity_pk1 IN VARCHAR2,
86 p_entity_code IN VARCHAR2,
87 p_section_id IN NUMBER,
88 p_parent_fk IN NUMBER,
89 x_result OUT NOCOPY VARCHAR2,
90 x_error_code OUT NOCOPY VARCHAR2,
91 x_error_message OUT NOCOPY VARCHAR2);
92
93
94 Function Get_Freight(p_carrier_code IN Varchar2,
95 p_inventory_organization_id IN Number)
96 return Varchar2;
97
98 FUNCTION GET_EXTERNAL_REGISTER_URL (p_org_id IN NUMBER) RETURN VARCHAR2 ;
99
100 PROCEDURE deleteValues( p_form_id IN NUMBER,
101 p_entity_pk1 IN VARCHAR2,
102 p_entity_code IN VARCHAR2,
103 x_result OUT NOCOPY VARCHAR2,
104 x_error_code OUT NOCOPY VARCHAR2,
105 x_error_message OUT NOCOPY VARCHAR2);
106
107 FUNCTION default_system_field_url RETURN VARCHAR2;
108
109 FUNCTION default_system_field_line_item(p_auction_header_id IN NUMBER,
110 p_attr_name IN VARCHAR2) RETURN VARCHAR2;
111
112 FUNCTION default_sys_field_max_amount(p_auction_header_id IN NUMBER,
113 p_attr_name IN VARCHAR2)
114 RETURN VARCHAR2;
115
116 FUNCTION get_fed_desc(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
117
118 FUNCTION get_fed_uploadtype(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
119
120
121 FUNCTION get_uda_value(p_attr_group_type IN VARCHAR2 DEFAULT 'PON_AUC_HDRS_EXT_ATTRS',
122 p_attr_group_name IN VARCHAR2,
123 p_attr_name IN VARCHAR2,
124 p_from IN VARCHAR2 DEFAULT 'pon_auction_headers_ext_b',
125 p_where IN VARCHAR2 DEFAULT NULL,
126 p_auction_header_id IN NUMBER) RETURN VARCHAR2;
127
128 FUNCTION get_uda_fed_offadd(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
129
130 FUNCTION get_uda_fed_zip(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
131
132 FUNCTION get_uda_fed_contact(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
133
134 FUNCTION get_uda_fed_setaside(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
135
136 FUNCTION get_uda_fed_popaddress(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
137
138 FUNCTION get_uda_fed_popzip(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
139
140 FUNCTION get_uda_fed_popcountry(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
141
142 FUNCTION get_uda_fed_email(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
143
144 FUNCTION get_fed_file_link(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
145
146 FUNCTION get_UDA_display_value(p_auction_header_id IN NUMBER,
147 p_attr_internal_num_value IN NUMBER DEFAULT null,
148 p_attr_internal_str_value IN VARCHAR2 DEFAULT null,
149 p_attr_internal_name IN VARCHAR2,
150 p_attr_group_int_name IN VARCHAR2,
151 p_attr_group_type IN VARCHAR2 DEFAULT 'PON_AUC_HDRS_EXT_ATTRS'
152 ) RETURN VARCHAR2;
153 FUNCTION decrypt (KEY IN VARCHAR2,
154 VALUE IN VARCHAR2
155 ) RETURN VARCHAR2;
156
157 PROCEDURE post_wf(p_itemtype IN VARCHAR2,
158 p_form_id IN Number, -- top form
159 p_entity_pk1 IN Varchar2,
160 p_from_role_name IN Varchar2,
161 p_xml IN VARCHAR2,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_reutrn_error OUT NOCOPY VARCHAR2);
164
165 procedure validate_fed_fields_length(p_field_code IN VARCHAR2,
166 p_field_length IN NUMBER,
167 x_result OUT NOCOPY VARCHAR2,
168 x_error_code OUT NOCOPY VARCHAR2,
169 x_error_message OUT NOCOPY VARCHAR2);
170
171
172 FUNCTION get_fed_onfbo(p_auction_header_id IN NUMBER)
173 RETURN VARCHAR2;
174
175 procedure get_posting_date(p_auction_header_id IN NUMBER,
176 p_form_id IN NUMBER,
177 x_posting_date OUT NOCOPY VARCHAR2,
178 x_result OUT NOCOPY VARCHAR2,
179 x_error_code OUT NOCOPY VARCHAR2,
180 x_error_message OUT NOCOPY VARCHAR2);
181
182
183 END PON_FORMS_UTIL_PVT;