1 PACKAGE AHL_OSP_PO_REQ_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPRQS.pls 120.0 2008/01/30 22:38:37 jaramana noship $ */
3 ---------------------------------------------------------------------
4 -- Define Record Types for record structures needed by the APIs --
5 ---------------------------------------------------------------------
6
7 ----------------------------------------------
8 -- Define Table Type for records structures --
9 ----------------------------------------------
10
11 ------------------------
12 -- Declare Procedures --
13 ------------------------
14 -----------------------------------------
15 -- Public Procedure Definitions follow --
16 -----------------------------------------
17 -- Start of Comments --
18 -- Procedure name : Create_PO_Requisition
19 -- Type : Private
20 -- Function : Validates OSP Information and inserts records into PO Requisition Interface tables
21 -- Launches Concurrent Program to initiate PO Requisition creation
22 -- Updates OSP table with request id, batch id and interface header id
23 -- Pre-reqs :
24 -- Parameters :
25 --
26 -- Standard IN Parameters :
27 -- p_api_version IN NUMBER Required
28 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
29 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
30 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
31 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
32 -- p_module_type IN VARCHAR2 Default NULL.
33 --
34 -- Standard OUT Parameters :
35 -- x_return_status OUT VARCHAR2 Required
36 -- x_msg_count OUT NUMBER Required
37 -- x_msg_data OUT VARCHAR2 Required
38 --
39 -- Create_PO_Requisition Parameters:
40 -- p_osp_order_id IN NUMBER Required
41 -- The Id of the OSP Order for which to create the Purchase Requisition
42 -- p_osp_order_number IN NUMBER Required
43 -- The Number of the OSP Order for which to create the Purchase Requisition
44 -- x_batch_id OUT NUMBER Required
45 -- Contains the batch id if the concurrent program was launched successfully.
46 -- x_request_id OUT NUMBER Required
47 -- Contains the concurrent request id if the concurrent program was launched successfully.
48 --
49 --
50 -- Version :
51 -- Initial Version 1.0
52 --
53 -- End of Comments.
54
55 PROCEDURE Create_PO_Requisition
56 (
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59 p_commit IN VARCHAR2 := FND_API.G_FALSE,
60 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61 p_module_type IN VARCHAR2 := NULL,
62 p_osp_order_id IN NUMBER := NULL, -- Required if Number is not given
63 p_osp_order_number IN NUMBER := NULL, -- Required if Id is not given
64 x_batch_id OUT NOCOPY NUMBER,
65 x_request_id OUT NOCOPY NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71 ----------------------------------------
72
73 -- Start of Comments --
74 -- Procedure name : Associate_All_New_Reqs
75 -- Type : Private
76 -- Function : Updates AHL_OSP_ORDERS_B.PO_REQ_HEADER_ID and
77 -- AHL_OSP_ORDER_LINES.PO_REQ_LINE_ID with REQUISITION_HEADER_ID and
78 -- REQUISITION_LINE_ID respectively for all submitted OSP Orders (for Requisitions).
79 -- Pre-reqs :
80 -- Parameters :
81 --
82 -- Standard IN Parameters :
83 -- p_api_version IN NUMBER Required
84 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
85 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
86 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
87 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
88 -- p_module_type IN VARCHAR2 Default NULL.
89 --
90 -- Standard OUT Parameters :
91 -- x_return_status OUT VARCHAR2 Required
92 -- x_msg_count OUT NUMBER Required
93 -- x_msg_data OUT VARCHAR2 Required
94 --
95 -- Version :
96 -- Initial Version 1.0
97 --
98 -- End of Comments.
99
100 PROCEDURE Associate_All_New_Reqs
101 (
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104 p_commit IN VARCHAR2 := FND_API.G_FALSE,
105 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106 p_default IN VARCHAR2 := FND_API.G_TRUE,
107 p_module_type IN VARCHAR2 := NULL,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2
111 );
112
113 -- Start of Comments --
114 -- Procedure name : PO_Synch_All_Requisitions
115 -- Type : Private
116 -- Function : Synchronizes all OSPs based on the Requisition Status
117 -- 1. Handles successfully completed Requisition Submissions (Updates OSP tables)
118 -- 2. Handles failed Requsition Submissions (Updates OSP Status)
119 -- 3. Handles Cancelled Requisition Lines (Updates OSP Line status, deletes shipment lines)
120 -- 4. Handles Deleted Requisition Lines (Updates OSP Line status, deletes shipment lines)
121 -- Pre-reqs :
122 -- Parameters :
123 --
124 -- Standard IN Parameters :
125 -- p_api_version IN NUMBER Required
126 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
127 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
128 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
129 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
130 -- p_module_type IN VARCHAR2 Default NULL.
131 --
132 -- Standard OUT Parameters :
133 -- x_return_status OUT VARCHAR2 Required
134 -- x_msg_count OUT NUMBER Required
135 -- x_msg_data OUT VARCHAR2 Required
136 --
137 -- PO_Synch_All_Requisitions parameters:
138 -- p_concurrent_flag IN VARCHAR2 Default N.
139 -- Writes debug Information to Concurrent Program's Log File if set to 'Y'
140 --
141 -- Version :
142 -- Initial Version 1.0
143 --
144 -- End of Comments.
145
146 PROCEDURE PO_Synch_All_Requisitions
147 (
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150 p_commit IN VARCHAR2 := FND_API.G_FALSE,
151 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152 p_default IN VARCHAR2 := FND_API.G_TRUE,
153 p_module_type IN VARCHAR2 := NULL,
154 p_concurrent_flag IN VARCHAR2 := 'N',
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2
158 );
159
160
161 -- This function determines if the Requisition is closed/cancelled.
162 FUNCTION Is_PO_Req_Closed(p_po_req_header_id IN NUMBER) RETURN VARCHAR2;
163
164 END AHL_OSP_PO_REQ_PVT;