[Home] [Help]
39: --
40: -- Procedure Parameters :
41: -- p_x_route_rec IN OUT AHL_RM_ROUTE_PVT.route_rec_type Required
42: -- p_x_route_doc_tbl IN OUT AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl
43: -- p_x_route_operation_tbl IN OUT AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type
44: -- p_x_route_resource_tbl IN OUT AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type
45: -- p_x_route_material_tbl IN OUT AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
46: -- p_x_route_panel_tbl IN OUT AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
47: --
61: * @param x_msg_count API Return message count, if any. Standard API parameter
62: * @param x_msg_data API Return message data, if any. Standard API parameter
63: * @param p_x_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
64: * @param p_x_route_doc_tbl Route associated documents table of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Route
65: * @param p_x_route_operation_tbl Route associated operations table of type AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type that need to be associated to the Route
66: * @param p_x_route_resource_tbl Route associated resources table of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Route
67: * @param p_x_route_material_tbl Route assocaited materials table of type AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type that need to be associated to the Route
68: * @param p_x_route_panel_tbl Route associated access panels table of type AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type that need to be associated to the Route
69: * @rep:scope public
85: x_msg_data OUT NOCOPY VARCHAR2,
86: -- procedure params
87: p_x_route_rec IN OUT NOCOPY AHL_RM_ROUTE_PVT.route_rec_type,
88: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
89: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
90: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
91: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
92: p_x_route_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
93: );
109: x_msg_data OUT NOCOPY VARCHAR2,
110: -- procedure params
111: p_x_route_rec IN OUT NOCOPY AHL_RM_ROUTE_PVT.route_rec_type,
112: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
113: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
114: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
115: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
116: );
117:
139: --
140: -- Procedure Parameters :
141: -- p_x_route_rec IN OUT AHL_RM_ROUTE_PVT.route_rec_type Required
142: -- p_x_route_doc_tbl IN OUT AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl
143: -- p_x_route_operation_tbl IN OUT AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type
144: -- p_x_route_resource_tbl IN OUT AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type
145: -- p_x_route_material_tbl IN OUT AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
146: -- p_x_route_panel_tbl IN OUT AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
147: --
161: * @param x_msg_count API Return message count, if any. Standard API parameter
162: * @param x_msg_data API Return message data, if any. Standard API parameter
163: * @param p_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
164: * @param p_x_route_doc_tbl Route associated documents table of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Route
165: * @param p_x_route_operation_tbl Route associated operations table of type AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type that need to be associated to the Route
166: * @param p_x_route_resource_tbl Route associated resources table of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Route
167: * @param p_x_route_material_tbl Route associated materials table of type AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type that need to be associated to the Route
168: * @param p_x_route_panel_tbl Route associated access panels table of type AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type that need to be associated to the Route
169: * @rep:scope public
185: x_msg_data OUT NOCOPY VARCHAR2,
186: -- procedure params
187: p_route_rec IN AHL_RM_ROUTE_PVT.route_rec_type,
188: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
189: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
190: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
191: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
192: p_x_route_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
193: );
209: x_msg_data OUT NOCOPY VARCHAR2,
210: -- procedure params
211: p_route_rec IN AHL_RM_ROUTE_PVT.route_rec_type,
212: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
213: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
214: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
215: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
216: );
217: