1 PACKAGE AHL_LTP_REQST_MATRL_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPRMTS.pls 115.9 2003/10/29 22:28:12 ssurapan noship $ */
3 --
4 ---------------------------------------------------------------------
5 -- Define Record Types for record structures needed by the APIs --
6 ---------------------------------------------------------------------
7
8 TYPE Schedule_Mr_Rec IS RECORD (
9 SCHEDULE_MATERIALS_ID NUMBER ,
10 OBJECT_VERSION_NUMBER NUMBER ,
11 VISIT_ID NUMBER ,
12 ITEM_ID NUMBER ,
13 ITEM VARCHAR2(80) ,
14 ORG_ID NUMBER ,
15 VISIT_TASK_ID NUMBER ,
16 TASK_NAME VARCHAR2(30) ,
17 MR_ROUTE_ID NUMBER ,
18 REQ_ARRIVAL_DATE DATE ,
19 QUANTITY NUMBER ,
20 REQUEST_ID NUMBER ,
21 TRANSACTION_ID NUMBER ,
22 SCHEDULE_MAT_ID NUMBER ,
23 MRP_STATUS_CODE NUMBER ,
24 MRP_STATUS_MEAN VARCHAR2(30) ,
25 SCHEDULED_DATE DATE ,
26 SCHEDULED_QUANTITY NUMBER ,
27 PLAN_NAME VARCHAR2(30) ,
28 ITEM_GROUP_ID NUMBER ,
29 UOM_CODE VARCHAR2(30) ,
30 RT_OPER_MAT_ID NUMBER ,
31 POSITION_PATH_ID NUMBER ,
32 POSITION_PATH VARCHAR2(4000),
33 ITEM_COMP_DETAIL_ID NUMBER ,
34 RELATIONSHIP_ID NUMBER ,
35 RELATIONSHIP_NAME VARCHAR2(80) ,
36 REWORK_PERCENT NUMBER ,
37 REPLACE_PERCENT NUMBER ,
38 OPERATION_FLAG VARCHAR2(1)
39 );
40
41 TYPE Task_Details_Rec IS RECORD (
42 VISIT_ID NUMBER ,
43 ORG_ID NUMBER ,
44 VISIT_TASK_ID NUMBER ,
45 TASK_NAME VARCHAR2(30) ,
46 VISIT_TASK_NUMBER NUMBER ,
47 MR_ROUTE_ID NUMBER ,
48 INVENTORY_ITEM_ID NUMBER ,
49 ITEM VARCHAR2(80) ,
50 REQ_ARRIVAL_DATE DATE ,
51 QUANTITY NUMBER ,
52 REQUEST_ID NUMBER ,
53 MRP_STATUS_CODE NUMBER ,
54 MRP_STATUS_MEAN VARCHAR2(30) ,
55 SCHEDULED_DATE DATE ,
56 SCHEDULED_FLAG NUMBER
57 );
58
59 TYPE Planned_Materials_Rec IS RECORD (
60 SCHEDULE_MATERIAL_ID NUMBER ,
61 OBJECT_VERSION_NUMBER NUMBER ,
62 VISIT_ID NUMBER ,
63 VISIT_TASK_ID NUMBER ,
64 TASK_NAME VARCHAR2(30) ,
65 INVENTORY_ITEM_ID NUMBER ,
66 ITEM_DESCRIPTION VARCHAR2(80) ,
67 REQUESTED_DATE DATE ,
68 QUANTITY NUMBER ,
69 POSITION_PATH_ID NUMBER ,
70 RELATIONSHIP_ID NUMBER
71 );
72
73 ----------------------------------------------
74 -- Define Table Type for records structures --
75 ----------------------------------------------
76 TYPE Schedule_Mr_Tbl IS TABLE OF Schedule_Mr_Rec INDEX BY BINARY_INTEGER;
77 TYPE Task_Details_Tbl IS TABLE OF Task_Details_Rec INDEX BY BINARY_INTEGER;
78 TYPE Planned_Materials_Tbl IS TABLE OF Planned_Materials_Rec
79 INDEX BY BINARY_INTEGER;
80
81 ------------------------
82 -- Declare Procedures --
83 ------------------------
84
85 -- Start of Comments --
86 -- Procedure name : Update_Planned_Materials
87 -- Type : Private
88 -- Function : This procedure Updates Planned materials information associated to scheduled
89 -- visit, which are defined at Route Operation and Disposition level
90 -- Pre-reqs :
91 -- Parameters :
92 --
93 -- Standard IN Parameters :
94 -- p_api_version IN NUMBER Required
95 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
96 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
97 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
98 -- Based on this flag, the API will set the default attributes.
99 -- p_module_type In VARCHAR2 Default NULL
100 -- This will be null.
101 -- Standard out Parameters :
102 -- x_return_status OUT VARCHAR2 Required
103 -- x_msg_count OUT NUMBER Required
104 -- x_msg_data OUT VARCHAR2 Required
105 --
106 -- Update_Planned_Materials Parameters :
107 -- p_planned_materials_tbl IN Planned_Materials_Tbl,Required
108 --
109 --
110 PROCEDURE Update_Planned_Materials (
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
113 p_commit IN VARCHAR2 := FND_API.g_false,
114 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
115 p_module_type IN VARCHAR2 := 'JSP',
116 p_planned_Materials_tbl IN Planned_Materials_Tbl,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2
120 );
121 --
122 END AHL_LTP_REQST_MATRL_PUB;