38: * @param p_assembly_item_id IN Assembly Item Id
39: * @param p_organization_id IN Organization Id in which item is defined
40: * @param p_revision IN Routing Revision
41: * @param x_rtg_revision_rec IN OUT NOCOPY Populated Routing Revision Exposed Record from queried row
42: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
43: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Populated Routing Revision Unexposed Record from queried row
44: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
45: * @param x_return_status IN OUT NOCOPY Return Status, Record Found or not Found
46: *
40: * @param p_revision IN Routing Revision
41: * @param x_rtg_revision_rec IN OUT NOCOPY Populated Routing Revision Exposed Record from queried row
42: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
43: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Populated Routing Revision Unexposed Record from queried row
44: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
45: * @param x_return_status IN OUT NOCOPY Return Status, Record Found or not Found
46: *
47: * @rep:scope private
48: * @rep:lifecycle active
53: PROCEDURE Query_Row
54: ( p_assembly_item_id IN NUMBER
55: , p_organization_id IN NUMBER
56: , p_revision IN VARCHAR2
57: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_revision_Rec_Type
58: , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_rev_unexposed_Rec_Type
59: , x_Return_status IN OUT NOCOPY VARCHAR2
60: );
61:
54: ( p_assembly_item_id IN NUMBER
55: , p_organization_id IN NUMBER
56: , p_revision IN VARCHAR2
57: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_revision_Rec_Type
58: , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_rev_unexposed_Rec_Type
59: , x_Return_status IN OUT NOCOPY VARCHAR2
60: );
61:
62: /*#
63: * Procedure to insert/update/delete a database record using Exposed and Unexposed
64: * Routing Revision record depending on Transaction Type.
65: *
66: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
67: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
68: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
69: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
70: * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
71: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
65: *
66: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
67: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
68: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
69: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
70: * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
71: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
72: * @param x_return_status IN OUT NOCOPY Return Status
73: *
76: * @rep:displayname Insert/Update/Delete a row for Routing Revision record
77: * @rep:compatibility S
78: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
79: */
80: PROCEDURE Perform_Writes ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_revision_Rec_Type
81: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_rev_Unexposed_Rec_Type
82: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
83: , x_return_status IN OUT NOCOPY VARCHAR2
84: );
77: * @rep:compatibility S
78: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
79: */
80: PROCEDURE Perform_Writes ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_revision_Rec_Type
81: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_rev_Unexposed_Rec_Type
82: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
83: , x_return_status IN OUT NOCOPY VARCHAR2
84: );
85: