29: -- Pre-reqs : None.
30: -- Parameters :
31: -- IN : p_api_version IN NUMBER Required
32: -- p_init_msg_list IN VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_commit IN VARCHAR2 Optional
35: -- Default = FND_API.G_FALSE
36: -- p_failureset_rec IN
37: -- EAM_FailureSets_PUB.eam_failureset_rec_type
31: -- IN : p_api_version IN NUMBER Required
32: -- p_init_msg_list IN VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_commit IN VARCHAR2 Optional
35: -- Default = FND_API.G_FALSE
36: -- p_failureset_rec IN
37: -- EAM_FailureSets_PUB.eam_failureset_rec_type
38: -- Within p_failure_set_rec, set_name column
39: -- is 'Required'
46: -- End of comments
47: ***************************************************************************/
48: PROCEDURE Create_FailureSet
49: (p_api_version IN NUMBER ,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
52: p_failureset_rec IN EAM_FailureSets_PUB.eam_failureset_rec_type,
53: x_return_status OUT NOCOPY VARCHAR2 ,
54: x_msg_count OUT NOCOPY NUMBER ,
47: ***************************************************************************/
48: PROCEDURE Create_FailureSet
49: (p_api_version IN NUMBER ,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
52: p_failureset_rec IN EAM_FailureSets_PUB.eam_failureset_rec_type,
53: x_return_status OUT NOCOPY VARCHAR2 ,
54: x_msg_count OUT NOCOPY NUMBER ,
55: x_msg_data OUT NOCOPY VARCHAR2 ,
65: -- Pre-reqs : None.
66: -- Parameters :
67: -- IN : p_api_version IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_commit IN VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_failureset_rec IN
73: -- EAM_FailureSets_PUB.eam_failureset_rec_type
67: -- IN : p_api_version IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_commit IN VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_failureset_rec IN
73: -- EAM_FailureSets_PUB.eam_failureset_rec_type
74: -- Within p_failure_set_rec, either set_name or
75: -- set_id should have a value in update mode.
82: -- End of comments
83: ***************************************************************************/
84: PROCEDURE Update_FailureSet
85: (p_api_version IN NUMBER ,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
88: p_failureset_rec IN EAM_FailureSets_PUB.eam_failureset_rec_type,
89: x_return_status OUT NOCOPY VARCHAR2 ,
90: x_msg_count OUT NOCOPY NUMBER ,
83: ***************************************************************************/
84: PROCEDURE Update_FailureSet
85: (p_api_version IN NUMBER ,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
88: p_failureset_rec IN EAM_FailureSets_PUB.eam_failureset_rec_type,
89: x_return_status OUT NOCOPY VARCHAR2 ,
90: x_msg_count OUT NOCOPY NUMBER ,
91: x_msg_data OUT NOCOPY VARCHAR2 ,
100: -- Pre-reqs : None.
101: -- Parameters :
102: -- IN : p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional
104: -- Default = FND_API.G_FALSE
105: -- p_commit IN VARCHAR2 Optional
106: -- Default = FND_API.G_FALSE
107: -- p_association_rec IN
108: -- EAM_FailureSets_PUB.eam_set_association_rec_type
102: -- IN : p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional
104: -- Default = FND_API.G_FALSE
105: -- p_commit IN VARCHAR2 Optional
106: -- Default = FND_API.G_FALSE
107: -- p_association_rec IN
108: -- EAM_FailureSets_PUB.eam_set_association_rec_type
109: -- Within p_association_rec, set_id or set_name column
110: -- is 'Required' and inventory_item_id (of the asset group
118: -- End of comments
119: ***************************************************************************/
120: PROCEDURE Create_Association
121: (p_api_version IN NUMBER ,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
124: p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
125: x_return_status OUT NOCOPY VARCHAR2 ,
126: x_msg_count OUT NOCOPY NUMBER ,
119: ***************************************************************************/
120: PROCEDURE Create_Association
121: (p_api_version IN NUMBER ,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
124: p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
125: x_return_status OUT NOCOPY VARCHAR2 ,
126: x_msg_count OUT NOCOPY NUMBER ,
127: x_msg_data OUT NOCOPY VARCHAR2
135: -- Pre-reqs : None.
136: -- Parameters :
137: -- IN : p_api_version IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional
139: -- Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional
141: -- Default = FND_API.G_FALSE
142: -- p_association_rec IN
143: -- EAM_FailureSets_PUB.eam_set_association_rec_type
137: -- IN : p_api_version IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional
139: -- Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional
141: -- Default = FND_API.G_FALSE
142: -- p_association_rec IN
143: -- EAM_FailureSets_PUB.eam_set_association_rec_type
144: -- Within p_association_rec, set_id or set_name column
145: -- is 'Required' and inventory_item_id (of the asset group
153: -- End of comments
154: ***************************************************************************/
155: PROCEDURE Update_Association
156: (p_api_version IN NUMBER ,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
159: p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
160: x_return_status OUT NOCOPY VARCHAR2 ,
161: x_msg_count OUT NOCOPY NUMBER ,
154: ***************************************************************************/
155: PROCEDURE Update_Association
156: (p_api_version IN NUMBER ,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
159: p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
160: x_return_status OUT NOCOPY VARCHAR2 ,
161: x_msg_count OUT NOCOPY NUMBER ,
162: x_msg_data OUT NOCOPY VARCHAR2
170: -- Pre-reqs : None.
171: -- Parameters :
172: -- IN : p_api_version IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional
174: -- Default = FND_API.G_FALSE
175: -- p_commit IN VARCHAR2 Optional
176: -- Default = FND_API.G_FALSE
177: -- p_association_rec IN
178: -- EAM_FailureSets_PUB.eam_set_association_rec_type
172: -- IN : p_api_version IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional
174: -- Default = FND_API.G_FALSE
175: -- p_commit IN VARCHAR2 Optional
176: -- Default = FND_API.G_FALSE
177: -- p_association_rec IN
178: -- EAM_FailureSets_PUB.eam_set_association_rec_type
179: -- Within p_association_rec, set_id or set_name column
180: -- is 'Required' and inventory_item_id (of the asset group
188: -- End of comments
189: ***************************************************************************/
190: PROCEDURE Delete_Association
191: (p_api_version IN NUMBER ,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
194: p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
195: x_return_status OUT NOCOPY VARCHAR2 ,
196: x_msg_count OUT NOCOPY NUMBER ,
189: ***************************************************************************/
190: PROCEDURE Delete_Association
191: (p_api_version IN NUMBER ,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
194: p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
195: x_return_status OUT NOCOPY VARCHAR2 ,
196: x_msg_count OUT NOCOPY NUMBER ,
197: x_msg_data OUT NOCOPY VARCHAR2