72: -- Type : Private
73: -- Description : This procedure creates a CMRO non-routine (service request and its unit effectivity).
74: -- Pre-reqs :
75: --
76: -- Standard IN Parameters :
77: -- p_api_version NUMBER Required
78: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
79: -- p_commit VARCHAR2 := FND_API.G_FALSE
80: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
80: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
81: -- p_default VARCHAR2 := FND_API.G_FALSE
82: -- p_module_type VARCHAR2 := NULL
83: --
84: -- Standard OUT Parameters :
85: -- x_return_status VARCHAR2 Required
86: -- x_msg_count NUMBER Required
87: -- x_msg_data VARCHAR2 Required
88: --
94: --
95: -- End of Comments --
96: PROCEDURE Create_SR
97: (
98: -- Standard IN params
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_default IN VARCHAR2 := FND_API.G_FALSE,
104: p_module_type IN VARCHAR2 := NULL,
105: -- Standard OUT params
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: -- Procedure IN, OUT, IN/OUT params
116: -- Type : Private
117: -- Description : This procedure updates a CMRO non-routine (service request and its unit effectivity).
118: -- Pre-reqs :
119: --
120: -- Standard IN Parameters :
121: -- p_api_version NUMBER Required
122: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
123: -- p_commit VARCHAR2 := FND_API.G_FALSE
124: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
124: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
125: -- p_default VARCHAR2 := FND_API.G_FALSE
126: -- p_module_type VARCHAR2 := NULL
127: --
128: -- Standard OUT Parameters :
129: -- x_return_status VARCHAR2 Required
130: -- x_msg_count NUMBER Required
131: -- x_msg_data VARCHAR2 Required
132: --
138: --
139: -- End of Comments --
140: PROCEDURE Update_SR
141: (
142: -- Standard IN params
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_default IN VARCHAR2 := FND_API.G_FALSE,
148: p_module_type IN VARCHAR2 := NULL,
149: -- Standard OUT params
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: -- Procedure IN, OUT, IN/OUT params
160: -- Type : Private
161: -- Description : This procedure submits the unit effectivity of a CMRO non-routine for approval.
162: -- Pre-reqs :
163: --
164: -- Standard IN Parameters :
165: -- p_api_version NUMBER Required
166: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
167: -- p_commit VARCHAR2 := FND_API.G_FALSE
168: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
168: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
169: -- p_default VARCHAR2 := FND_API.G_FALSE
170: -- p_module_type VARCHAR2 := NULL
171: --
172: -- Standard OUT Parameters :
173: -- x_return_status VARCHAR2 Required
174: -- x_msg_count NUMBER Required
175: -- x_msg_data VARCHAR2 Required
176: --
183: --
184: -- End of Comments --
185: PROCEDURE Initiate_Mel_Cdl_Approval
186: (
187: -- Standard IN params
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_default IN VARCHAR2 := FND_API.G_FALSE,
193: p_module_type IN VARCHAR2 := NULL,
194: -- Standard OUT params
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: -- Procedure IN, OUT, IN/OUT params
269: -- Description : This procedure verifies whether there are any open non-routines for a particular
270: -- MEL/CDL or Product Classification node.
271: -- Pre-reqs :
272: --
273: -- Standard IN Parameters :
274: --
275: -- Standard OUT Parameters :
276: -- x_return_status VARCHAR2 Required
277: --
271: -- Pre-reqs :
272: --
273: -- Standard IN Parameters :
274: --
275: -- Standard OUT Parameters :
276: -- x_return_status VARCHAR2 Required
277: --
278: -- Procedure IN, OUT, IN/OUT params :
279: -- p_mel_cdl_header_id NUMBER (one of p_mel_cdl_header_id or p_pc_node_id is mandatory)
284: --
285: -- End of Comments --
286: PROCEDURE Check_Open_NRs
287: (
288: -- Standard OUT params
289: x_return_status OUT NOCOPY VARCHAR2,
290: -- Procedure IN, OUT, IN/OUT params
291: p_mel_cdl_header_id IN NUMBER DEFAULT NULL,
292: p_pc_node_id IN NUMBER DEFAULT NULL