1 PACKAGE AHL_OSP_SERV_ITEM_RELS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVOSRS.pls 120.0 2005/07/06 15:53:18 jeli noship $ */
3 /*#
4 * This package Contains Record types and public procedures to process shipment headers, and lines that are related to OSP Orders.
5 * @rep:scope public
6 * @rep:product AHL
7 * @rep:displayname Process OSP Inv Itm Service Itm Relations
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_OSP_ORDER
10 */
11
12 ---------------------------------
13 -- Define Record Type for Node --
14 ---------------------------------
15
16 TYPE Inv_Serv_Item_Rels_Rec_Type IS RECORD
17 ( inv_ser_item_rel_id NUMBER
18 , obj_ver_num NUMBER
19 , inv_item_id NUMBER
20 , inv_item_name VARCHAR2(240)
21 , inv_org_id NUMBER
22 , inv_org_name VARCHAR2(240)
23 , service_item_id NUMBER
24 , service_item_name VARCHAR2(240)
25 , rank NUMBER
26 , active_start_date DATE
27 , active_end_date DATE
28 , for_all_org_flag VARCHAR(1) := 'N' -- possible values Y,N
29 , operation_flag VARCHAR2(1) -- possible values C,U,D
30 );
31
32
33 ------------------------
34 -- Declare Procedures --
35 ------------------------
36
37 -- Start of Comments --
38 -- Procedure name : PROCESS_SERV_ITM_RELS
39 -- Type : Public
40 -- Function : For creating/updating relationship between Inv Item and Service Item.
41 -- Pre-reqs :
42 -- Parameters :
43 --
44 -- Standard IN Parameters :
45 -- p_api_version IN NUMBER Default 1.0
46 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
47 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
48 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
49 -- Standard OUT Parameters :
50 -- x_return_status OUT NOCOPY VARCHAR2 Required
51 -- x_msg_count OUT NOCOPY NUMBER Required
52 -- x_msg_data OUT NOCOPY VARCHAR2 Required
53 --
54 -- Process Order Parameters:
55 -- p_x_Inv_serv_item_rec IN OUT NOCOPY Inv_Serv_Item_Rels_Rec_Type Required
56 -- All parameters for Inv Item Service Item relationship
57 --
58 --
59 -- Version :
60 -- Initial Version 1.0
61 --
62 -- End of Comments.
63 /*#
64 * This procedure is used to process a Shipment order related to an OSP Order.
65 * @param p_api_version API Version Number
66 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
67 * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
68 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
69 * @param p_module_type Module type of the caller
70 * @param p_x_Inv_serv_item_rec Contains the attributes of the Shipment header, of type AHL_OSP_SHIPMENT_PUB.Ship_Header_Rec_Type
71 * @param x_return_status return status
72 * @param x_msg_count return message count
73 * @param x_msg_data return message data
74 * @rep:scope public
75 * @rep:lifecycle active
76 * @rep:displayname Process Inv Item Service Item Relations
77 */
78 PROCEDURE PROCESS_SERV_ITM_RELS (
79 p_api_version IN NUMBER := 1.0,
80 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
81 p_commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83 p_module_type IN VARCHAR2 := NULL,
84 p_x_Inv_serv_item_rec IN OUT NOCOPY AHL_OSP_SERV_ITEM_RELS_PVT.Inv_Serv_Item_Rels_Rec_Type,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2);
88
89
90
91
92 End AHL_OSP_SERV_ITEM_RELS_PVT;