39: * @param p_assembly_item_id IN Assembly Item Id
40: * @param p_organization_id IN Organization Id in which item is defined
41: * @param p_alternate_routing_code IN Alternate Routing Code
42: * @param x_rtg_header_rec IN OUT NOCOPY Populated Routing Header Exposed Record from queried row
43: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
44: * @param x_rtg_header_unexp_rec IN OUT NOCOPY Populated Routing Header Unexposed Record from queried row
45: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
46: * @param x_return_status IN OUT NOCOPY Return Status, Record Found or not Found
47: *
41: * @param p_alternate_routing_code IN Alternate Routing Code
42: * @param x_rtg_header_rec IN OUT NOCOPY Populated Routing Header Exposed Record from queried row
43: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
44: * @param x_rtg_header_unexp_rec IN OUT NOCOPY Populated Routing Header Unexposed Record from queried row
45: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
46: * @param x_return_status IN OUT NOCOPY Return Status, Record Found or not Found
47: *
48: * @rep:scope private
49: * @rep:lifecycle active
54: PROCEDURE Query_Row
55: ( p_assembly_item_id IN NUMBER
56: , p_organization_id IN NUMBER
57: , p_alternate_routing_code IN VARCHAR2
58: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_header_Rec_Type
59: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_header_unexposed_Rec_Type
60: , x_Return_status IN OUT NOCOPY VARCHAR2
61: );
62:
55: ( p_assembly_item_id IN NUMBER
56: , p_organization_id IN NUMBER
57: , p_alternate_routing_code IN VARCHAR2
58: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_header_Rec_Type
59: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_header_unexposed_Rec_Type
60: , x_Return_status IN OUT NOCOPY VARCHAR2
61: );
62:
63: /*#
64: * Procedure to update a database record using Exposed and Unexposed
65: * Routing Header record.
66: *
67: * @param p_rtg_header_rec IN Routing Header Exposed Record
68: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type}
69: * @param p_rtg_header_unexp_rec IN Routing Header Unexposed Record
70: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
71: * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
72: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
66: *
67: * @param p_rtg_header_rec IN Routing Header Exposed Record
68: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type}
69: * @param p_rtg_header_unexp_rec IN Routing Header Unexposed Record
70: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
71: * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
72: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
73: * @param x_return_status IN OUT NOCOPY Return Status
74: *
78: * @rep:compatibility S
79: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
80: */
81: PROCEDURE Update_Row
82: ( p_RTG_header_rec IN Bom_Rtg_Pub.RTG_Header_Rec_Type
83: , p_RTG_header_unexp_rec IN Bom_Rtg_Pub.RTG_Header_Unexposed_Rec_Type
84: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
85: , x_return_Status IN OUT NOCOPY VARCHAR2
86: );
79: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
80: */
81: PROCEDURE Update_Row
82: ( p_RTG_header_rec IN Bom_Rtg_Pub.RTG_Header_Rec_Type
83: , p_RTG_header_unexp_rec IN Bom_Rtg_Pub.RTG_Header_Unexposed_Rec_Type
84: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
85: , x_return_Status IN OUT NOCOPY VARCHAR2
86: );
87:
89: * Procedure to insert/update/delete a database record using Exposed and Unexposed
90: * Routing Header record depending on Transaction Type.
91: *
92: * @param p_rtg_header_rec IN Routing Header Exposed Record
93: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type}
94: * @param p_rtg_header_unexp_rec IN Routing Header Unexposed Record
95: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
96: * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
97: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
91: *
92: * @param p_rtg_header_rec IN Routing Header Exposed Record
93: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type}
94: * @param p_rtg_header_unexp_rec IN Routing Header Unexposed Record
95: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
96: * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
97: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
98: * @param x_return_status IN OUT NOCOPY Return Status
99: *
103: * @rep:compatibility S
104: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
105: */
106: PROCEDURE Perform_Writes
107: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
108: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
109: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
110: , x_return_status IN OUT NOCOPY VARCHAR2
111: );
104: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
105: */
106: PROCEDURE Perform_Writes
107: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
108: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
109: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
110: , x_return_status IN OUT NOCOPY VARCHAR2
111: );
112: