1 PACKAGE AHL_OSP_ACCOMP_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVOSAS.pls 120.0.12020000.2 2012/12/11 07:40:06 sareepar noship $ */
3
4 ------------------------
5 -- Declare Procedures --
6 ------------------------
7
8 -- Start of Comments --
9 -- Procedure name : accomplish_osp_mrs
10 -- Type : Private
11 -- Function : Procedure to Accomplish one or more MRs associated to a OSP Line.
12 -- The records in the AHL_OSP_ACCOMPLISHMENTS will also be updated
13 -- Will be called from the Service Details UI.
14 -- Pre-reqs :
15 -- Parameters :
16 --
17 -- Standard IN Parameters :
18 -- p_api_version IN NUMBER Default 1.0
19 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
20 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
21 -- Standard OUT Parameters :
22 -- x_return_status OUT VARCHAR2 Required
23 -- x_msg_count OUT NUMBER Required
24 -- x_msg_data OUT VARCHAR2 Required
25 -- process_disposition Parameters:
26 --
27 -- p_accomplishment_id IN NUMBER
28 -- If this parameter is passed, only a single UMP record is created and accomplished.
29 -- p_osp_order_line_id IN NUMBER
30 -- If this parameter is passed without passing the p_accomplishment_id parameter,
31 -- All the unaccomplished MRs assigned to the the OSP Line (and return line)
32 -- will be processed: UMP record created and immediately accomplished
33 --
34 -- Version :
35 -- Initial Version 1.0
36 --
37 -- End of Comments.
38
39 PROCEDURE accomplish_osp_mrs(
40 p_api_version IN NUMBER := 1.0,
41 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_accomplishment_id IN NUMBER,
44 p_osp_order_line_id IN NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2);
48
49 FUNCTION Is_Received_Inst_Same (
50 p_osp_order_line_id IN NUMBER) RETURN VARCHAR2;
51
52 --------------------------
53 End AHL_OSP_ACCOMP_PVT;
54 ----------------------------------------------