DBA Data[Home] [Help]

PACKAGE: APPS.ECX_DOCUMENT_STANDARDS_API

Source


1 PACKAGE ECX_DOCUMENT_STANDARDS_API 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;