77: END Get_Y_Coordinate ;
78:
79:
80: PROCEDURE Get_Flex_Op_Network
81: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
82: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
83: )
84: IS
85: BEGIN
78:
79:
80: PROCEDURE Get_Flex_Op_Network
81: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
82: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
83: )
84: IS
85: BEGIN
86:
166: * Purpose : Attribute Defaulting will default the necessary null
167: * attribute with appropriate values.
168: **********************************************************************/
169: PROCEDURE Attribute_Defaulting
170: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
171: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
172: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
173: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
174: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
167: * attribute with appropriate values.
168: **********************************************************************/
169: PROCEDURE Attribute_Defaulting
170: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
171: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
172: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
173: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
174: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
175: , x_return_status IN OUT NOCOPY VARCHAR2
168: **********************************************************************/
169: PROCEDURE Attribute_Defaulting
170: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
171: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
172: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
173: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
174: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
175: , x_return_status IN OUT NOCOPY VARCHAR2
176: )
169: PROCEDURE Attribute_Defaulting
170: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
171: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
172: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
173: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
174: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
175: , x_return_status IN OUT NOCOPY VARCHAR2
176: )
177: IS
282: * Purpose : Entity Attribute Defaulting will default the necessary
283: * entity level attribute with appropriate values.
284: **********************************************************************/
285: PROCEDURE Entity_Attribute_Defaulting
286: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
287: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
288: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
289: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
290: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
283: * entity level attribute with appropriate values.
284: **********************************************************************/
285: PROCEDURE Entity_Attribute_Defaulting
286: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
287: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
288: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
289: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
290: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
291: , x_return_status IN OUT NOCOPY VARCHAR2
284: **********************************************************************/
285: PROCEDURE Entity_Attribute_Defaulting
286: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
287: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
288: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
289: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
290: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
291: , x_return_status IN OUT NOCOPY VARCHAR2
292: )
285: PROCEDURE Entity_Attribute_Defaulting
286: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
287: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
288: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
289: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
290: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
291: , x_return_status IN OUT NOCOPY VARCHAR2
292: )
293: IS
507: * value from the old record.
508: * This procedure is not called CREATE
509: ********************************************************************/
510: PROCEDURE Populate_Null_Columns
511: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
512: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
513: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
514: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
515: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
508: * This procedure is not called CREATE
509: ********************************************************************/
510: PROCEDURE Populate_Null_Columns
511: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
512: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
513: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
514: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
515: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
516: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
509: ********************************************************************/
510: PROCEDURE Populate_Null_Columns
511: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
512: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
513: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
514: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
515: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
516: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
517: )
510: PROCEDURE Populate_Null_Columns
511: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
512: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
513: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
514: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
515: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
516: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
517: )
518: IS
511: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
512: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
513: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
514: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
515: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
516: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
517: )
518: IS
519: BEGIN
512: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
513: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
514: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
515: , x_op_network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
516: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
517: )
518: IS
519: BEGIN
520: