1 PACKAGE ECX_DOCUMENT_STANDARDS_API AUTHID CURRENT_USER AS
2 -- $Header: ECXSTDAS.pls 120.2 2005/06/30 11:17:59 appldev ship $
3
4 /**
5 This Retrieve_Standard API is used to retrieve an existing XML standard definition from the ECX_Standards table.
6 **/
7 procedure retrieve_standard
8 (
9 x_return_status Out nocopy pls_integer,
10 x_msg Out nocopy Varchar2,
11 x_standard_id Out nocopy pls_integer,
12 p_standard_code In Varchar2,
13 x_standard_type In Out nocopy Varchar2,
14 x_standard_desc Out nocopy Varchar2,
15 x_data_seeded Out nocopy Varchar2
16 );
17
18 /**
19 This Create_Standard API is used to create a new XML standard definition in the ECX_Standards table.
20 **/
21 procedure create_standard
22 (
23 x_return_status Out nocopy pls_integer,
24 x_msg Out nocopy Varchar2,
25 x_standard_id Out nocopy pls_integer,
26 p_standard_code In Varchar2,
27 p_standard_type In Varchar2,
28 p_standard_desc In Varchar2,
29 p_data_seeded In Varchar2 default 'N',
30 p_owner In varchar2 default 'CUSTOM'
31 );
32 /**
33 Update_Standards API is used to update an existing XML Standard definition in the ECX_Standards table.
34 This API allows users to update the description and data seeded fields by specifying standard id
35 **/
36 procedure update_standard
37 (
38 x_return_status Out nocopy pls_integer,
39 x_msg Out nocopy Varchar2,
40 p_standard_id In pls_integer,
41 p_standard_desc In Varchar2,
42 p_data_seeded In Varchar2 default 'N',
43 p_owner In varchar2 default 'CUSTOM'
44 );
45
46 /**
47 Delete_XML_Standard API is used to delete an existing XML Standard definition in the ECX_STANDARDS
48 table and its attributes. This API allows users to delete the definitions by specifying the standard id.
49 **/
50 procedure delete_standard
51 (
52 x_return_status Out nocopy pls_integer,
53 x_msg Out nocopy Varchar2,
54 p_standard_id In pls_integer
55 );
56
57 END ECX_DOCUMENT_STANDARDS_API;