1 PACKAGE AHL_OSP_ORDERS_PUB AS
2 /* $Header: AHLPOSPS.pls 120.1 2005/09/13 22:09:50 jaramana noship $ */
3 /*#
4 * This package provides the procedure to Validate, Insert/Update/Delete an osp order header along with its associated lines.
5 * @rep:scope public
6 * @rep:product AHL
7 * @rep:displayname Process OSP Order
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_OSP_ORDER
10 */
11 ------------------------
12 -- Declare Procedures --
13 ------------------------
14
15 -- Start of Comments --
16 -- Procedure name : process_osp_order
17 -- Type : Public
18 -- Function : For a given set of osp order header and lines, will validate and insert/update/delete
19 -- the osp order information.
20 -- Pre-reqs :
21 -- Parameters :
22 --
23 -- Standard IN Parameters :
24 -- p_api_version IN NUMBER Default 1.0
25 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
26 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
27 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
28 -- Standard OUT Parameters :
29 -- x_return_status OUT VARCHAR2 Required
30 -- x_msg_count OUT NUMBER Required
31 -- x_msg_data OUT VARCHAR2 Required
32 --
33 -- p_module_type IN VARCHAR2 Required.
34 --
35 -- This parameter indicates the front-end form interface. The default value is 'JSP'. If the value
36 -- is JSP, then this API clears out all id columns and validations are done using the values based
37 -- on which the Id's are populated.
38 --
39 -- process_osp_order Parameters:
40 --
41 -- p_x_osp_order_rec IN OUT AHL_OSP_ORDERS_PVT.osp_order_rec_type Required
42 -- OSP Order Header record
43 -- p_x_osp_order_lines_tbl IN OUT AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type Required
44 -- OSP Order Lines
45 --
46 --
47 -- Version :
48 -- Initial Version 1.0
49 --
50 -- End of Comments.
51 /*#
52 * This procedure is used to validate and insert/update/delete an osp order.
53 * @param p_api_version API Version Number
54 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
55 * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
56 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
57 * @param p_module_type Module type of the caller
58 * @param p_x_osp_order_rec OSP Header Record
59 * @param p_x_osp_order_lines_tbl Table of OSP Order line Records.
60 * @param p_org_id Optional Org Id Parameter for R12 MOAC Compliance.
61 * @param x_return_status return status
62 * @param x_msg_count return message count
63 * @param x_msg_data return message data
64 * @rep:scope public
65 * @rep:lifecycle active
66 * @rep:displayname Process OSP Order
67 */
68 PROCEDURE process_osp_order(
69 p_api_version IN NUMBER := 1.0,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 p_module_type IN VARCHAR2 := NULL,
74 p_x_osp_order_rec IN OUT NOCOPY AHL_OSP_ORDERS_PVT.osp_order_rec_type,
75 p_x_osp_order_lines_tbl IN OUT NOCOPY AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type,
76 p_org_id IN NUMBER := null,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2);
80
81
82 END AHL_OSP_ORDERS_PUB; -- Package spec
83 ----------------------------------------------