1 PACKAGE PON_FORMS_UTIL_PVT as
2 /* $Header: PONFMUTS.pls 120.3 2006/03/14 23:17:07 ukottama noship $ */
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
108 END PON_FORMS_UTIL_PVT;
[Home] [Help]