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.
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,
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,
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
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: );
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:
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: /**
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,
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,
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',
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'
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: );
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: /**
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: (
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,
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,
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: );
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:
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: (
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,
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
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;
53: x_msg Out nocopy Varchar2,
54: p_standard_id In pls_integer
55: );
56:
57: END ECX_DOCUMENT_STANDARDS_API;