1 PACKAGE AHL_MATERIALS_GRP AUTHID CURRENT_USER AS
2 /* $Header: AHLGMATS.pls 120.1.12020000.2 2012/12/06 22:27:20 sareepar ship $ */
3 /*
4 * This Group package spec provides the apis which will be invoked from VCP for
5 * 1. Querying alternate items for a Work order's primary item requirement.
6 * 2. Updating CMRO material requirements with alternate items or dates as
7 * recommended by VCP/PS for a Work Order.
8 */
9
10 -- Record to represent an Item and its alternate item
11 TYPE Alt_Item_rec_type IS RECORD (
12 PRIMARY_ITEM_ID NUMBER,
13 ALTERNATE_ITEM_ID NUMBER,
14 PRIMARY_ITEM_QUANTITY NUMBER,
15 PRIMARY_ITEM_UOM_CODE VARCHAR2(3),
16 ALT_ITEM_QUANTITY NUMBER,
17 ALT_ITEM_UOM_CODE VARCHAR2(3),
18 REQUESTED_DATE DATE,
19 OPERATION_SEQUENCE NUMBER,
20 SCHEDULED_MATERIAL_ID NUMBER, -- Internal to CMRO: Can be ignored by VCP
21 PRIORITY NUMBER
22 );
23
24 -- Table of Records representing an Item and its alternate item
25 TYPE Alt_Item_Tbl_Type IS TABLE OF Alt_Item_rec_type
26 INDEX BY BINARY_INTEGER;
27
28 ----------------------------------------
29 -- Start of Comments --
30 -- Procedure name : GET_WO_ALTERNATES
31 -- Type : Public
32 -- Function : Gets all the material requirements for a Work order and its alternates
33 -- Parameters :
34 --
35 -- Standard IN Parameters :
36 -- p_api_version IN NUMBER Required
37 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
38 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
39 --
40 -- Standard OUT Parameters :
41 -- x_return_status OUT VARCHAR2 Required
42 -- x_msg_count OUT NUMBER Required
43 -- x_msg_data OUT VARCHAR2 Required
44 --
45 -- GET_WO_ALTERNATES Parameters:
46 -- p_wip_entity_id IN NUMBER Required
47 -- x_alt_item_tbl OUT Alt_Item_Tbl_Type Represents the table of items and alternates.
48 -- If a given primary Item has n applicable alternates, there will be n records having
49 -- the same PRIMARY_ITEM_ID+PRIMARY_ITEM_QUANTITY+PRIMARY_ITEM_UOM_CODE. These records will
50 -- differ in the values of ALTERNATE_ITEM_ID
51 --
52 -- Version :
53 -- Initial Version 1.0
54 --
55 -- End of Comments.
56
57 PROCEDURE GET_WO_ALTERNATES
58 (
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_wip_entity_id IN NUMBER,
66 x_alt_item_tbl OUT NOCOPY Alt_Item_Tbl_Type
67 );
68
69 ----------------------------------------
70 -- Start of Comments --
71 -- Procedure name : UPDATE_WO_MATERIALS
72 -- Type : Public
73 -- Function : Updates CMRO material requirements with alternate items or dates
74 -- Parameters :
75 --
76 -- Standard IN Parameters :
77 -- p_api_version IN NUMBER Required
78 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
79 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
80 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
81 --
82 -- Standard OUT Parameters :
83 -- x_return_status OUT VARCHAR2 Required
84 -- x_msg_count OUT NUMBER Required
85 -- x_msg_data OUT VARCHAR2 Required
86 --
87 -- UPDATE_WO_MATERIALS Parameters:
88 -- p_wip_entity_id IN NUMBER Required
89 -- p_alt_item_tbl IN Alt_Item_Tbl_Type Represents the table of items and its alternates.
90 -- For each item and its recommended alternate, there will be one record in this table.
91 -- Table can be empty if only the date has changed.
92 --
93 -- Version :
94 -- Initial Version 1.0
95 --
96 -- End of Comments.
97
98 PROCEDURE UPDATE_WO_MATERIALS
99 (
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102 p_commit IN VARCHAR2 := FND_API.G_FALSE,
103 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_wip_entity_id IN NUMBER,
108 p_alt_item_tbl IN Alt_Item_Tbl_Type
109 );
110
111
112 END AHL_MATERIALS_GRP;