[Home] [Help]
PACKAGE: APPS.EAM_ITEM_ACTIVITIES_PUB_W
Source
1 package eam_item_activities_pub_w AUTHID CURRENT_USER as
2 /* $Header: EAMWIAAS.pls 120.0 2005/05/25 15:59:01 appldev noship $ */
3 procedure insert_item_activities(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status out nocopy VARCHAR2
8 , x_msg_count out nocopy NUMBER
9 , x_msg_data out nocopy VARCHAR2
10 , p_asset_activity_id NUMBER
11 , p_inventory_item_id NUMBER
12 , p_organization_id NUMBER
13 , p_owningdepartment_id NUMBER
14 , p_maintenance_object_id NUMBER
15 , p_creation_organization_id NUMBER
16 , p_start_date_active DATE
17 , p_end_date_active DATE
18 , p_priority_code VARCHAR2
19 , p_activity_cause_code VARCHAR2
20 , p_activity_type_code VARCHAR2
21 , p_shutdown_type_code VARCHAR2
22 , p_maintenance_object_type NUMBER
23 , p_tmpl_flag VARCHAR2
24 , p_class_code VARCHAR2
25 , p_activity_source_code VARCHAR2
26 , p_serial_number VARCHAR2
27 , p_attribute_category VARCHAR2
28 , p_attribute1 VARCHAR2
29 , p_attribute2 VARCHAR2
30 , p_attribute3 VARCHAR2
31 , p_attribute4 VARCHAR2
32 , p_attribute5 VARCHAR2
33 , p_attribute6 VARCHAR2
34 , p_attribute7 VARCHAR2
35 , p_attribute8 VARCHAR2
36 , p_attribute9 VARCHAR2
37 , p_attribute10 VARCHAR2
38 , p_attribute11 VARCHAR2
39 , p_attribute12 VARCHAR2
40 , p_attribute13 VARCHAR2
41 , p_attribute14 VARCHAR2
42 , p_attribute15 VARCHAR2
43 , p_tagging_required_flag VARCHAR2
44 , p_last_service_start_date DATE
45 , p_last_service_end_date DATE
46 , p_prev_service_start_date DATE
47 , p_prev_service_end_date DATE
48 , p_last_scheduled_start_date DATE
49 , p_last_scheduled_end_date DATE
50 , p_prev_scheduled_start_date DATE
51 , p_prev_scheduled_end_date DATE
52 , p_wip_entity_id NUMBER
53 , p_source_tmpl_id NUMBER
54 , p46_a0 JTF_NUMBER_TABLE
55 , p46_a1 JTF_NUMBER_TABLE
56 , p46_a2 JTF_NUMBER_TABLE
57 , p46_a3 JTF_NUMBER_TABLE
58 );
59 procedure update_item_activities(p_api_version NUMBER
60 , p_init_msg_list VARCHAR2
61 , p_commit VARCHAR2
62 , p_validation_level NUMBER
63 , x_return_status out nocopy VARCHAR2
64 , x_msg_count out nocopy NUMBER
65 , x_msg_data out nocopy VARCHAR2
66 , p_activity_association_id NUMBER
67 , p_asset_activity_id NUMBER
68 , p_inventory_item_id NUMBER
69 , p_organization_id NUMBER
70 , p_owningdepartment_id NUMBER
71 , p_maintenance_object_id NUMBER
72 , p_creation_organization_id NUMBER
73 , p_start_date_active DATE
74 , p_end_date_active DATE
75 , p_priority_code VARCHAR2
76 , p_activity_cause_code VARCHAR2
77 , p_activity_type_code VARCHAR2
78 , p_shutdown_type_code VARCHAR2
79 , p_maintenance_object_type NUMBER
80 , p_tmpl_flag VARCHAR2
81 , p_class_code VARCHAR2
82 , p_activity_source_code VARCHAR2
83 , p_serial_number VARCHAR2
84 , p_attribute_category VARCHAR2
85 , p_attribute1 VARCHAR2
86 , p_attribute2 VARCHAR2
87 , p_attribute3 VARCHAR2
88 , p_attribute4 VARCHAR2
89 , p_attribute5 VARCHAR2
90 , p_attribute6 VARCHAR2
91 , p_attribute7 VARCHAR2
92 , p_attribute8 VARCHAR2
93 , p_attribute9 VARCHAR2
94 , p_attribute10 VARCHAR2
95 , p_attribute11 VARCHAR2
96 , p_attribute12 VARCHAR2
97 , p_attribute13 VARCHAR2
98 , p_attribute14 VARCHAR2
99 , p_attribute15 VARCHAR2
100 , p_tagging_required_flag VARCHAR2
101 , p_last_service_start_date DATE
102 , p_last_service_end_date DATE
103 , p_prev_service_start_date DATE
104 , p_prev_service_end_date DATE
105 , p_last_scheduled_start_date DATE
106 , p_last_scheduled_end_date DATE
107 , p_prev_scheduled_start_date DATE
108 , p_prev_scheduled_end_date DATE
109 , p_wip_entity_id NUMBER
110 , p_source_tmpl_id NUMBER
111 , p47_a0 JTF_NUMBER_TABLE
112 , p47_a1 JTF_NUMBER_TABLE
113 , p47_a2 JTF_NUMBER_TABLE
114 , p47_a3 JTF_NUMBER_TABLE
115 );
116 end eam_item_activities_pub_w;