1 PACKAGE eam_org_maint_defaults_pvt AUTHID CURRENT_USER AS
2 /* $Header: EAMVOMDS.pls 120.0.12020000.3 2013/02/14 13:40:20 rsandepo ship $*/
3 -- Start of comments
4 -- API name : eam_org_maint_defaults_pvt
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 insert_row
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_object_type IN NUMBER
45 ,p_object_id IN NUMBER
46 ,p_organization_id IN NUMBER
47 ,p_owning_department_id IN NUMBER := NULL
48 ,p_accounting_class_code IN VARCHAR2 := NULL
49 ,p_area_id IN NUMBER := NULL
50 ,p_activity_cause_code IN VARCHAR2 := NULL
51 ,p_activity_type_code IN VARCHAR2 := NULL
52 ,p_activity_source_code IN VARCHAR2 := NULL
53 ,p_work_order_type IN NUMBER := NULL
54 ,p_planner IN NUMBER := NULL
55 ,p_firm IN NUMBER := NULL
56 ,p_planned IN VARCHAR2 := NULL
57 ,p_notification_required IN VARCHAR2 := NULL
58 ,p_shutdown_type_code IN VARCHAR2 := NULL
59 ,p_tagging_required_flag IN VARCHAR2 := NULL
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 ) ;
64
65 PROCEDURE update_row
66 (
67 p_api_version IN NUMBER
68 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
69 ,p_commit IN VARCHAR2 := fnd_api.g_false
70 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
71 ,p_object_type IN NUMBER
72 ,p_object_id IN NUMBER
73 ,p_organization_id IN NUMBER
74 ,p_owning_department_id IN NUMBER := NULL
75 ,p_accounting_class_code IN VARCHAR2 := NULL
76 ,p_area_id IN NUMBER := NULL
77 ,p_activity_cause_code IN VARCHAR2 := NULL
78 ,p_activity_type_code IN VARCHAR2 := NULL
79 ,p_activity_source_code IN VARCHAR2 := NULL
80 ,p_work_order_type IN NUMBER := NULL
81 ,p_planner IN NUMBER := NULL
82 ,p_firm IN NUMBER := NULL
83 ,p_planned IN VARCHAR2 := NULL
84 ,p_notification_required IN VARCHAR2 := NULL
85 ,p_shutdown_type_code IN VARCHAR2 := NULL
86 ,p_tagging_required_flag IN VARCHAR2 := NULL
87 ,x_return_status OUT NOCOPY VARCHAR2
88 ,x_msg_count OUT NOCOPY NUMBER
89 ,x_msg_data OUT NOCOPY VARCHAR2
90 ) ;
91
92 PROCEDURE update_insert_row
93 (
94 p_api_version IN NUMBER
95 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
96 ,p_commit IN VARCHAR2 := fnd_api.g_false
97 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98 ,p_object_type IN NUMBER
99 ,p_object_id IN NUMBER
100 ,p_organization_id IN NUMBER
101 ,p_owning_department_id IN NUMBER := NULL
102 ,p_accounting_class_code IN VARCHAR2 := NULL
103 ,p_area_id IN NUMBER := NULL
104 ,p_activity_cause_code IN VARCHAR2 := NULL
105 ,p_activity_type_code IN VARCHAR2 := NULL
106 ,p_activity_source_code IN VARCHAR2 := NULL
107 ,p_work_order_type IN NUMBER := NULL
108 ,p_planner IN NUMBER := NULL
109 ,p_firm IN NUMBER := NULL
110 ,p_planned IN VARCHAR2 := NULL
111 ,p_notification_required IN VARCHAR2 := NULL
112 ,p_shutdown_type_code IN VARCHAR2 := NULL
113 ,p_tagging_required_flag IN VARCHAR2 := NULL
114 ,x_return_status OUT NOCOPY VARCHAR2
115 ,x_msg_count OUT NOCOPY NUMBER
116 ,x_msg_data OUT NOCOPY VARCHAR2
117 ) ;
118
119 END eam_org_maint_defaults_pvt;