[Home] [Help]
PACKAGE: APPS.AMS_DELIVKITITEM_PUB
Source
1 PACKAGE AMS_DelivKitItem_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspkits.pls 115.3 2002/11/14 00:21:21 musman noship $ */
3
4 ---------------------------------------------------------------------
5 -- PROCEDURE
6 -- create_DelivKitItem
7 --
8 -- PURPOSE
9 -- Create a Deliverable Kit Item.
10 --
11 -- PARAMETERS
12 -- p_deliv_kit_item_rec: the new record to be inserted
13 -- x_deliv_kit_item_id: return the PK of the created Deliverable Kit Item
14 --
15 -- NOTES
16 -- 1. object_version_number will be set to 1.
17 -- 2. If DelivKitItem_id is passed in, the uniqueness will be checked.
18 -- Raise exception in case of duplicates.
19 -- 3. If DelivKitItem_id is not passed in, generate a unique one from
20 -- the sequence.
21 ---------------------------------------------------------------------
22 PROCEDURE create_DelivKitItem(
23 p_api_version_number IN NUMBER,
24 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
25 p_commit IN VARCHAR2 := FND_API.g_false,
26 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
27
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31
32 p_deliv_kit_item_rec IN AMS_DelivKitItem_PVT.deliv_kit_item_rec_type,
33 x_deliv_kit_item_id OUT NOCOPY NUMBER
34 );
35
36
37 --------------------------------------------------------------------
38 -- PROCEDURE
39 -- delete_DelivKitItem
40 --
41 -- PURPOSE
42 -- Delete a Deliverable Kit Item.
43 --
44 -- PARAMETERS
45 -- p_deliv_kit_item_id : the DelivKitItem_id
46 -- p_object_version: the object_version_number
47 --
48 -- NOTES
49 -- 1. Raise exception if the object_version_number doesn't match.
50 --
51 --------------------------------------------------------------------
52 PROCEDURE delete_DelivKitItem(
53 p_api_version_number IN NUMBER,
54 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
55 p_commit IN VARCHAR2 := FND_API.g_false,
56 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
57
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61
62 p_deliv_kit_item_id IN NUMBER,
63 p_object_version_number IN NUMBER
64 );
65
66
67 -------------------------------------------------------------------
68 -- PROCEDURE
69 -- lock_DelivKitItem
70 --
71 -- PURPOSE
72 -- Lock a Deliverable Kit Item.
73 --
74 -- PARAMETERS
75 -- p_deliv_kit_item_id: the DelivKitItem_id
76 -- p_object_version: the object_version_number
77 --
78 -- NOTES
79 -- 1. Raise exception if the object_version_number doesn't match.
80 --------------------------------------------------------------------
81 PROCEDURE lock_DelivKitItem(
82 p_api_version_number IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
84
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88
89 p_deliv_kit_item_id IN NUMBER,
90 p_object_version_number IN NUMBER
91 );
92
93
94 ---------------------------------------------------------------------
95 -- PROCEDURE
96 -- update_DelivKitItem
97 --
98 -- PURPOSE
99 -- Update a Deliverable Kit Item.
100 --
101 -- PARAMETERS
102 -- p_deliv_kit_item_rec: the record with new items
103 --
104 -- NOTES
105 -- 1. Raise exception if the object_version_number doesn't match.
106 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
107 -- that column won't be updated.
108 ----------------------------------------------------------------------
109 PROCEDURE update_DelivKitItem(
110 p_api_version_number IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
112 p_commit IN VARCHAR2 := FND_API.g_false,
113 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
114
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118
119 p_deliv_kit_item_rec IN AMS_DelivKitItem_PVT.deliv_kit_item_rec_type
120 );
121
122
123 ---------------------------------------------------------------------
124 -- PROCEDURE
125 -- validate_DelivKitItem
126 --
127 -- PURPOSE
128 -- Validate a Deliverable Kit Item. record.
129 --
130 -- PARAMETERS
131 -- p_deliv_kit_item_rec: the DelivKitItem record to be validated
132 --
133 -- NOTES
134 -- 1. p_deliv_kit_item_rec should be the complete DelivKitItem record. There
135 -- should not be any FND_API.g_miss_char/num/date in it.
136 ----------------------------------------------------------------------
137 PROCEDURE validate_DelivKitItem(
138 p_api_version_number IN NUMBER,
139 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
140 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
141
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145
146 p_deliv_kit_item_rec IN AMS_DelivKitItem_PVT.deliv_kit_item_rec_type
147 );
148
149
150 END AMS_DelivKitItem_PUB;