1 PACKAGE eam_maint_attributes_pub AUTHID CURRENT_USER AS
2 /* $Header: EAMPMATS.pls 120.2 2005/11/29 05:00:18 yjhabak noship $*/
3 -- Start of comments
4 -- API name : eam_maint_attributes_pub
5 -- Type : Private.
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN p_api_version IN NUMBER Required
10 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13 -- parameter1
14 -- parameter2
15 -- .
16 -- .
17 -- OUT x_return_status OUT VARCHAR2(1)
18 -- x_msg_count OUT NUMBER
19 -- x_msg_data OUT VARCHAR2(2000)
20 -- parameter1
21 -- parameter2
22 -- .
23 -- .
24 -- Version Current version x.x
25 -- Changed....
26 -- previous version y.y
27 -- Changed....
28 -- .
29 -- .
30 -- previous version 2.0
31 -- Changed....
32 -- Initial version 1.0
33 --
34 -- Notes : Note text
35 --
36 -- End of comments
37
38 PROCEDURE create_maint_attributes
39 (
40 p_api_version IN NUMBER
41 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
42 ,p_commit IN VARCHAR2 := fnd_api.g_false
43 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
44 ,p_instance_id IN NUMBER
45 ,p_owning_department_id IN NUMBER := NULL
46 ,p_accounting_class_code IN VARCHAR2 := NULL
47 ,p_area_id IN NUMBER := NULL
48 ,p_parent_instance_id IN NUMBER := NULL
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 ) ;
53
54 PROCEDURE update_maint_attributes
55 (
56 p_api_version IN NUMBER
57 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
58 ,p_commit IN VARCHAR2 := fnd_api.g_false
59 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
60 ,p_instance_id IN NUMBER
61 ,p_owning_department_id IN NUMBER := NULL
62 ,p_accounting_class_code IN VARCHAR2 := NULL
63 ,p_area_id IN NUMBER := NULL
64 ,x_return_status OUT NOCOPY VARCHAR2
65 ,x_msg_count OUT NOCOPY NUMBER
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ) ;
68
69 /* Added p_mode for bug # 4764280.
70 1 - Insert and 2 - Update
71 */
72 PROCEDURE validate_maint_defaults
73 (
74 p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
76 ,p_commit IN VARCHAR2 := fnd_api.g_false
77 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
78 ,p_instance_id IN NUMBER
79 ,p_owning_department_id IN NUMBER := NULL
80 ,p_accounting_class_code IN VARCHAR2 := NULL
81 ,p_area_id IN NUMBER := NULL
82 ,p_mode IN NUMBER
83 ,x_org_id OUT NOCOPY NUMBER
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 ,x_msg_data OUT NOCOPY VARCHAR2
87 ) ;
88
89
90 END eam_maint_attributes_pub ;