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: --
48: -- Version :
49: -- Initial Version 1.0
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
70: * @rep:lifecycle active
71: * @rep:displayname Create Route
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: );
94:
95: -- Start of Comments --
117: -- p_x_route_rec IN OUT AHL_RM_ROUTE_PVT.route_rec_type Required
118: -- p_x_route_doc_tbl IN OUT AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl
119: -- p_x_route_operation_tbl IN OUT AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type
120: -- p_x_route_resource_tbl IN OUT AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type
121: -- p_x_route_material_tbl IN OUT AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
122: -- p_x_route_panel_tbl IN OUT AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
123: --
124: -- Version :
125: -- Initial Version 1.0
139: * @param p_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
140: * @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
141: * @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
142: * @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
143: * @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
144: * @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
145: * @rep:scope public
146: * @rep:lifecycle active
147: * @rep:displayname Modify Route
163: p_route_rec IN AHL_RM_ROUTE_PVT.route_rec_type,
164: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
165: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
166: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
167: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
168: p_x_route_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
169: );
170:
171: -- Start of Comments --
405: -- Procedure Parameters :
406: -- p_route_id IN NUMBER,
407: -- p_route_number IN VARCHAR2,
408: -- p_route_revision IN NUMBER,
409: -- p_x_route_efct_rec IN OUT AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type Required
410: -- p_x_route_efct_mat_tbl IN OUT AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type Required
411: --
412: -- Version :
413: -- Initial Version 1.0
406: -- p_route_id IN NUMBER,
407: -- p_route_number IN VARCHAR2,
408: -- p_route_revision IN NUMBER,
409: -- p_x_route_efct_rec IN OUT AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type Required
410: -- p_x_route_efct_mat_tbl IN OUT AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type Required
411: --
412: -- Version :
413: -- Initial Version 1.0
414: --
426: * @param x_msg_data API Return message data, if any. Standard API parameter
427: * @param p_route_id Route ID of the Route to which the Disposition is added.
428: * @param p_route_number Route Number of the Route to which the Disposition is added.
429: * @param p_route_revision Route Revision of the Route to which the Disposition is added.
430: * @param p_x_route_efct_rec Disposition effectivities record of type AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type
431: * @param p_x_route_efct_mat_tbl Disposition details table of type AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
432: * @rep:scope public
433: * @rep:lifecycle active
434: * @rep:displayname Process Route Disposition
427: * @param p_route_id Route ID of the Route to which the Disposition is added.
428: * @param p_route_number Route Number of the Route to which the Disposition is added.
429: * @param p_route_revision Route Revision of the Route to which the Disposition is added.
430: * @param p_x_route_efct_rec Disposition effectivities record of type AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type
431: * @param p_x_route_efct_mat_tbl Disposition details table of type AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
432: * @rep:scope public
433: * @rep:lifecycle active
434: * @rep:displayname Process Route Disposition
435: */
449: -- procedure params
450: p_route_id IN NUMBER,
451: p_route_number IN VARCHAR2,
452: p_route_revision IN NUMBER,
453: p_x_route_efct_rec IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type,
454: p_x_route_efct_mat_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
455: );
456:
457: -- Start of Comments --
450: p_route_id IN NUMBER,
451: p_route_number IN VARCHAR2,
452: p_route_revision IN NUMBER,
453: p_x_route_efct_rec IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type,
454: p_x_route_efct_mat_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
455: );
456:
457: -- Start of Comments --
458: --