eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_DEFAULT_OP_SEQ dependencies on BOM_RTG_PUB

Line 295: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

291: END Get_Op_Yield_Enabled_Flag ;
292:
293:
294: PROCEDURE Get_Flex_Op_Seq
295: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
296: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
297: )
298: IS
299: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

Line 296: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

292:
293:
294: PROCEDURE Get_Flex_Op_Seq
295: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
296: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
297: )
298: IS
299: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
300: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

Line 299: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

295: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
296: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
297: )
298: IS
299: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
300: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
301:
302: BEGIN
303: -- Initialize operation exp and unexp record

Line 300: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

296: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
297: )
298: IS
299: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
300: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
301:
302: BEGIN
303: -- Initialize operation exp and unexp record
304: l_com_operation_rec := p_com_operation_rec ;

Line 392: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

388: * Set Standard Operation infor to exposed and unexposed
389: * coulumns regarding reference flag
390: **********************************************************************/
391: PROCEDURE Default_Std_Op_Attributes
392: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
393: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
394: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
395: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
396: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 393: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

389: * coulumns regarding reference flag
390: **********************************************************************/
391: PROCEDURE Default_Std_Op_Attributes
392: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
393: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
394: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
395: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
396: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
397: , x_return_status IN OUT NOCOPY VARCHAR2

Line 394: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

390: **********************************************************************/
391: PROCEDURE Default_Std_Op_Attributes
392: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
393: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
394: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
395: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
396: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
397: , x_return_status IN OUT NOCOPY VARCHAR2
398: )

Line 395: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

391: PROCEDURE Default_Std_Op_Attributes
392: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
393: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
394: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
395: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
396: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
397: , x_return_status IN OUT NOCOPY VARCHAR2
398: )
399: IS

Line 404: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type;

400: -- Variables
401: l_std_op_found BOOLEAN ; -- Indicate Std OP is found
402: l_copy_std_op BOOLEAN ; -- Indicate Copy Std Op has been proceeded
403:
404: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type;
405: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
406:
407: -- Error Handlig Variables
408: l_return_status VARCHAR2(1);

Line 405: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;

401: l_std_op_found BOOLEAN ; -- Indicate Std OP is found
402: l_copy_std_op BOOLEAN ; -- Indicate Copy Std Op has been proceeded
403:
404: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type;
405: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
406:
407: -- Error Handlig Variables
408: l_return_status VARCHAR2(1);
409: l_err_text VARCHAR2(2000) ;

Line 876: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

872: * This procedure will default values in all the operation
873: * fields that the user has left unfilled.
874: **********************************************************************/
875: PROCEDURE Attribute_Defaulting
876: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
877: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
878: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
879: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
880: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 877: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

873: * fields that the user has left unfilled.
874: **********************************************************************/
875: PROCEDURE Attribute_Defaulting
876: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
877: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
878: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
879: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
880: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
881: , x_return_status IN OUT NOCOPY VARCHAR2

Line 878: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

874: **********************************************************************/
875: PROCEDURE Attribute_Defaulting
876: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
877: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
878: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
879: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
880: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
881: , x_return_status IN OUT NOCOPY VARCHAR2
882: )

Line 879: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

875: PROCEDURE Attribute_Defaulting
876: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
877: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
878: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
879: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
880: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
881: , x_return_status IN OUT NOCOPY VARCHAR2
882: )
883: IS

Line 884: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

880: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
881: , x_return_status IN OUT NOCOPY VARCHAR2
882: )
883: IS
884: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
885: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
886:
887: l_return_status VARCHAR2(1);
888: l_err_text VARCHAR2(2000) ;

Line 885: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

881: , x_return_status IN OUT NOCOPY VARCHAR2
882: )
883: IS
884: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
885: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
886:
887: l_return_status VARCHAR2(1);
888: l_err_text VARCHAR2(2000) ;
889: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 896: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

892:
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894:
895: -- Convert Routing Operation to Common Operation
896: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
897: ( p_rtg_operation_rec => p_operation_rec
898: , p_rtg_op_unexp_rec => p_op_unexp_rec
899: , x_com_operation_rec => l_com_operation_rec
900: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 910: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec

906: --
907: BOM_Default_Op_Seq.Attribute_Defaulting
908: ( p_com_operation_rec => l_com_operation_rec
909: , p_com_op_unexp_rec => l_com_op_unexp_rec
910: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec
911: , x_com_operation_rec => l_com_operation_rec
912: , x_com_op_unexp_rec => l_com_op_unexp_rec
913: , x_return_status => x_return_status
914: , x_mesg_token_tbl => x_mesg_token_tbl

Line 919: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp

915: ) ;
916:
917:
918: -- Convert the Common record to Routing Record
919: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp
920: ( p_com_operation_rec => l_com_operation_rec
921: , p_com_op_unexp_rec => l_com_op_unexp_rec
922: , x_rtg_operation_rec => x_operation_rec
923: , x_rtg_op_unexp_rec => x_op_unexp_rec

Line 943: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

939: * This procedure will default values in all the operation.
940: * fields that the user has left unfilled.
941: *********************************************************************/
942: PROCEDURE Attribute_Defaulting
943: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
944: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
945: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
946: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
947: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

Line 944: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

940: * fields that the user has left unfilled.
941: *********************************************************************/
942: PROCEDURE Attribute_Defaulting
943: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
944: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
945: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
946: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
947: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
948: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 945: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type

941: *********************************************************************/
942: PROCEDURE Attribute_Defaulting
943: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
944: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
945: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
946: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
947: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
948: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
949: , x_return_status IN OUT NOCOPY VARCHAR2

Line 946: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

942: PROCEDURE Attribute_Defaulting
943: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
944: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
945: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
946: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
947: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
948: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
949: , x_return_status IN OUT NOCOPY VARCHAR2
950: )

Line 947: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

943: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
944: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
945: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
946: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
947: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
948: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
949: , x_return_status IN OUT NOCOPY VARCHAR2
950: )
951: IS

Line 952: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

948: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
949: , x_return_status IN OUT NOCOPY VARCHAR2
950: )
951: IS
952: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
953: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
954:
955: l_return_status VARCHAR2(1);
956: l_err_text VARCHAR2(2000) ;

Line 953: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

949: , x_return_status IN OUT NOCOPY VARCHAR2
950: )
951: IS
952: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
953: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
954:
955: l_return_status VARCHAR2(1);
956: l_err_text VARCHAR2(2000) ;
957: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 965: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

961: x_return_status := FND_API.G_RET_STS_SUCCESS;
962:
963:
964: -- Convert Revised Operation to Common Operation
965: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
966: ( p_rev_operation_rec => p_rev_operation_rec
967: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
968: , x_com_operation_rec => l_com_operation_rec
969: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 979: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec

975: --
976: BOM_Default_Op_Seq.Attribute_Defaulting
977: ( p_com_operation_rec => l_com_operation_rec
978: , p_com_op_unexp_rec => l_com_op_unexp_rec
979: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec
980: , x_com_operation_rec => l_com_operation_rec
981: , x_com_op_unexp_rec => l_com_op_unexp_rec
982: , x_return_status => x_return_status
983: , x_mesg_token_tbl => x_mesg_token_tbl

Line 987: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp

983: , x_mesg_token_tbl => x_mesg_token_tbl
984: ) ;
985:
986: -- Convert the Common record to Revised Operation record
987: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp
988: ( p_com_operation_rec => l_com_operation_rec
989: , p_com_op_unexp_rec => l_com_op_unexp_rec
990: , x_rev_operation_rec => x_rev_operation_rec
991: , x_rev_op_unexp_rec => x_rev_op_unexp_rec

Line 1012: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

1008: * appropriate values. Defualting will happen for
1009: * exposed as well as unexposed columns.
1010: *********************************************************************/
1011: PROCEDURE Attribute_Defaulting
1012: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1013: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1014: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1015: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1016: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

Line 1013: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1009: * exposed as well as unexposed columns.
1010: *********************************************************************/
1011: PROCEDURE Attribute_Defaulting
1012: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1013: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1014: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1015: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1016: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1017: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1014: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type

1010: *********************************************************************/
1011: PROCEDURE Attribute_Defaulting
1012: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1013: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1014: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1015: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1016: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1017: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1018: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1015: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

1011: PROCEDURE Attribute_Defaulting
1012: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1013: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1014: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1015: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1016: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1017: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1018: , x_return_status IN OUT NOCOPY VARCHAR2
1019: )

Line 1016: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1012: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1013: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1014: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1015: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1016: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1017: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1018: , x_return_status IN OUT NOCOPY VARCHAR2
1019: )
1020:

Line 1023: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1019: )
1020:
1021: IS
1022:
1023: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1024: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1025:
1026: l_return_status VARCHAR2(1);
1027: l_temp_return_status VARCHAR2(1);

Line 1024: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1020:
1021: IS
1022:
1023: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1024: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1025:
1026: l_return_status VARCHAR2(1);
1027: l_temp_return_status VARCHAR2(1);
1028: l_err_text VARCHAR2(2000) ;

Line 1466: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

1462: * The procedure will populate the NULL columns from the record that
1463: * is queried from the database.
1464: ********************************************************************/
1465: PROCEDURE Populate_Null_Columns
1466: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1467: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1468: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1469: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1470: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

Line 1467: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1463: * is queried from the database.
1464: ********************************************************************/
1465: PROCEDURE Populate_Null_Columns
1466: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1467: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1468: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1469: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1470: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1471: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

Line 1468: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

1464: ********************************************************************/
1465: PROCEDURE Populate_Null_Columns
1466: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1467: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1468: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1469: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1470: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1471: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1472: )

Line 1469: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1465: PROCEDURE Populate_Null_Columns
1466: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1467: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1468: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1469: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1470: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1471: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1472: )
1473:

Line 1470: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

1466: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1467: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1468: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1469: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1470: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1471: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1472: )
1473:
1474: IS

Line 1471: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1467: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1468: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1469: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1470: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1471: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1472: )
1473:
1474: IS
1475: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

Line 1475: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1471: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1472: )
1473:
1474: IS
1475: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1476: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1477: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1478: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1479:

Line 1476: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1472: )
1473:
1474: IS
1475: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1476: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1477: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1478: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1479:
1480:

Line 1477: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1473:
1474: IS
1475: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1476: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1477: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1478: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1479:
1480:
1481: BEGIN

Line 1478: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1474: IS
1475: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1476: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1477: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1478: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1479:
1480:
1481: BEGIN
1482:

Line 1484: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

1480:
1481: BEGIN
1482:
1483: -- Convert Routing Operation to Common Operation
1484: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
1485: ( p_rtg_operation_rec => p_operation_rec
1486: , p_rtg_op_unexp_rec => p_op_unexp_rec
1487: , x_com_operation_rec => l_com_operation_rec
1488: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1492: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

1488: , x_com_op_unexp_rec => l_com_op_unexp_rec
1489: ) ;
1490:
1491: -- Also Convert Old Routing Operation to Old Common Operation
1492: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
1493: ( p_rtg_operation_rec => p_old_operation_rec
1494: , p_rtg_op_unexp_rec => p_old_op_unexp_rec
1495: , x_com_operation_rec => l_old_com_operation_rec
1496: , x_com_op_unexp_rec => l_old_com_op_unexp_rec

Line 1518: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp

1514: -- record back in the RTG BO's records
1515: --
1516:
1517: -- Convert the Common record to Routing Record
1518: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp
1519: ( p_com_operation_rec => l_com_operation_rec
1520: , p_com_op_unexp_rec => l_com_op_unexp_rec
1521: , x_rtg_operation_rec => x_operation_rec
1522: , x_rtg_op_unexp_rec => x_op_unexp_rec

Line 1547: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

1543: * The procedure will populate the NULL columns from the record that
1544: * is queried from the database.
1545: ********************************************************************/
1546: PROCEDURE Populate_Null_Columns
1547: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1548: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1549: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1550: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1551: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

Line 1548: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

1544: * is queried from the database.
1545: ********************************************************************/
1546: PROCEDURE Populate_Null_Columns
1547: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1548: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1549: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1550: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1551: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1552: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type )

Line 1549: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

1545: ********************************************************************/
1546: PROCEDURE Populate_Null_Columns
1547: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1548: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1549: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1550: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1551: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1552: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type )
1553: IS

Line 1550: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

1546: PROCEDURE Populate_Null_Columns
1547: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1548: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1549: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1550: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1551: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1552: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type )
1553: IS
1554: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

Line 1551: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

1547: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1548: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1549: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1550: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1551: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1552: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type )
1553: IS
1554: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1555: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

Line 1552: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type )

1548: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1549: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1550: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1551: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1552: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type )
1553: IS
1554: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1555: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1556: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

Line 1554: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1550: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1551: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1552: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type )
1553: IS
1554: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1555: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1556: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1557: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1558:

Line 1555: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1551: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1552: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type )
1553: IS
1554: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1555: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1556: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1557: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1558:
1559:

Line 1556: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1552: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type )
1553: IS
1554: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1555: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1556: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1557: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1558:
1559:
1560: BEGIN

Line 1557: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1553: IS
1554: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1555: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1556: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1557: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1558:
1559:
1560: BEGIN
1561:

Line 1564: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

1560: BEGIN
1561:
1562:
1563: -- Convert Revised Operation to Common Operation
1564: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
1565: ( p_rev_operation_rec => p_rev_operation_rec
1566: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
1567: , x_com_operation_rec => l_com_operation_rec
1568: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1572: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

1568: , x_com_op_unexp_rec => l_com_op_unexp_rec
1569: ) ;
1570:
1571: -- Also Convert Old Revised Operation to Old Common Operation
1572: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
1573: ( p_rev_operation_rec => p_old_rev_operation_rec
1574: , p_rev_op_unexp_rec => p_old_rev_op_unexp_rec
1575: , x_com_operation_rec => l_old_com_operation_rec
1576: , x_com_op_unexp_rec => l_old_com_op_unexp_rec

Line 1599: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp

1595: -- record back in the RTG BO's records
1596: --
1597:
1598: -- Convert the Common record to Revised Operation record
1599: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp
1600: ( p_com_operation_rec => l_com_operation_rec
1601: , p_com_op_unexp_rec => l_com_op_unexp_rec
1602: , x_rev_operation_rec => x_rev_operation_rec
1603: , x_rev_op_unexp_rec => x_rev_op_unexp_rec

Line 1624: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

1620: * record with values from the database record, for all
1621: * columns that the user has left NULL.
1622: ********************************************************************/
1623: PROCEDURE Populate_Null_Columns
1624: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1625: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1626: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1627: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1628: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

Line 1625: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1621: * columns that the user has left NULL.
1622: ********************************************************************/
1623: PROCEDURE Populate_Null_Columns
1624: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1625: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1626: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1627: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1628: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1629: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

Line 1626: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

1622: ********************************************************************/
1623: PROCEDURE Populate_Null_Columns
1624: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1625: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1626: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1627: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1628: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1629: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1630: )

Line 1627: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1623: PROCEDURE Populate_Null_Columns
1624: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1625: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1626: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1627: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1628: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1629: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1630: )
1631: IS

Line 1628: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

1624: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1625: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1626: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1627: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1628: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1629: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1630: )
1631: IS
1632:

Line 1629: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1625: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1626: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1627: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1628: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1629: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1630: )
1631: IS
1632:
1633: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

Line 1633: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1629: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1630: )
1631: IS
1632:
1633: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1634: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1635:
1636: BEGIN
1637: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

Line 1634: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1630: )
1631: IS
1632:
1633: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1634: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1635:
1636: BEGIN
1637: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1638: ('Within the Rev. Operation Populate null columns...') ;

Line 2046: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

2042: * This procedure will entity default values in all the operation.
2043: * fields that the user has left unfilled.
2044: **********************************************************************/
2045: PROCEDURE Entity_Defaulting
2046: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2047: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2048: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2049: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2050: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2047: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

2043: * fields that the user has left unfilled.
2044: **********************************************************************/
2045: PROCEDURE Entity_Defaulting
2046: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2047: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2048: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2049: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2050: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2051: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2048: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

2044: **********************************************************************/
2045: PROCEDURE Entity_Defaulting
2046: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2047: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2048: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2049: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2050: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2051: , x_return_status IN OUT NOCOPY VARCHAR2
2052: )

Line 2049: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

2045: PROCEDURE Entity_Defaulting
2046: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2047: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2048: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2049: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2050: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2051: , x_return_status IN OUT NOCOPY VARCHAR2
2052: )
2053: IS

Line 2054: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

2050: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2051: , x_return_status IN OUT NOCOPY VARCHAR2
2052: )
2053: IS
2054: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2055: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2056:
2057: l_return_status VARCHAR2(1);
2058: l_err_text VARCHAR2(2000) ;

Line 2055: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

2051: , x_return_status IN OUT NOCOPY VARCHAR2
2052: )
2053: IS
2054: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2055: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2056:
2057: l_return_status VARCHAR2(1);
2058: l_err_text VARCHAR2(2000) ;
2059: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 2074: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

2070: -- Entity Defaulting procedure.
2071: --
2072:
2073: -- Convert Routing Operation to Common Operation
2074: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
2075: ( p_rtg_operation_rec => p_operation_rec
2076: , p_rtg_op_unexp_rec => p_op_unexp_rec
2077: , x_com_operation_rec => l_com_operation_rec
2078: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 2088: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec

2084: --
2085: BOM_Default_Op_Seq.Entity_Defaulting
2086: ( p_com_operation_rec => l_com_operation_rec
2087: , p_com_op_unexp_rec => l_com_op_unexp_rec
2088: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec
2089: , x_com_operation_rec => l_com_operation_rec
2090: , x_com_op_unexp_rec => l_com_op_unexp_rec
2091: , x_return_status => x_return_status
2092: , x_mesg_token_tbl => x_mesg_token_tbl

Line 2097: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp

2093: ) ;
2094:
2095:
2096: -- Convert the Common record to Routing Record
2097: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp
2098: ( p_com_operation_rec => l_com_operation_rec
2099: , p_com_op_unexp_rec => l_com_op_unexp_rec
2100: , x_rtg_operation_rec => x_operation_rec
2101: , x_rtg_op_unexp_rec => x_op_unexp_rec

Line 2120: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

2116: * This procedure will entity default values in all the operation.
2117: * fields that the user has left unfilled.
2118: **********************************************************************/
2119: PROCEDURE Entity_Defaulting
2120: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2121: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2122: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2123: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2124: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

Line 2121: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

2117: * fields that the user has left unfilled.
2118: **********************************************************************/
2119: PROCEDURE Entity_Defaulting
2120: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2121: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2122: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2123: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2124: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2125: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2122: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type

2118: **********************************************************************/
2119: PROCEDURE Entity_Defaulting
2120: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2121: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2122: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2123: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2124: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2125: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2126: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2123: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

2119: PROCEDURE Entity_Defaulting
2120: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2121: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2122: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2123: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2124: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2125: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2126: , x_return_status IN OUT NOCOPY VARCHAR2
2127: )

Line 2124: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

2120: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2121: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2122: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2123: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2124: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2125: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2126: , x_return_status IN OUT NOCOPY VARCHAR2
2127: )
2128:

Line 2130: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

2126: , x_return_status IN OUT NOCOPY VARCHAR2
2127: )
2128:
2129: IS
2130: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2131: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2132: l_return_status VARCHAR2(1);
2133: l_err_text VARCHAR2(2000) ;
2134: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 2131: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

2127: )
2128:
2129: IS
2130: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2131: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2132: l_return_status VARCHAR2(1);
2133: l_err_text VARCHAR2(2000) ;
2134: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2135:

Line 2149: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

2145: -- Entity Defaulting procedure.
2146: --
2147:
2148: -- Convert Revised Operation to Common Operation
2149: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
2150: ( p_rev_operation_rec => p_rev_operation_rec
2151: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
2152: , x_com_operation_rec => l_com_operation_rec
2153: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 2163: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec

2159: --
2160: BOM_Default_Op_Seq.Entity_Defaulting
2161: ( p_com_operation_rec => l_com_operation_rec
2162: , p_com_op_unexp_rec => l_com_op_unexp_rec
2163: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec
2164: , x_com_operation_rec => l_com_operation_rec
2165: , x_com_op_unexp_rec => l_com_op_unexp_rec
2166: , x_return_status => x_return_status
2167: , x_mesg_token_tbl => x_mesg_token_tbl

Line 2172: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp

2168: ) ;
2169:
2170:
2171: -- Convert the Common record to Revised Operation record
2172: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp
2173: ( p_com_operation_rec => l_com_operation_rec
2174: , p_com_op_unexp_rec => l_com_op_unexp_rec
2175: , x_rev_operation_rec => x_rev_operation_rec
2176: , x_rev_op_unexp_rec => x_rev_op_unexp_rec

Line 2198: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

2194: * appropriate values. Defualting will happen for
2195: * exposed as well as unexposed columns.
2196: *********************************************************************/
2197: PROCEDURE Entity_Defaulting
2198: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2199: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2200: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2201: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2202: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

Line 2199: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2195: * exposed as well as unexposed columns.
2196: *********************************************************************/
2197: PROCEDURE Entity_Defaulting
2198: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2199: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2200: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2201: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2202: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2203: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2200: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type

2196: *********************************************************************/
2197: PROCEDURE Entity_Defaulting
2198: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2199: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2200: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2201: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2202: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2203: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2204: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2201: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

2197: PROCEDURE Entity_Defaulting
2198: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2199: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2200: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2201: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2202: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2203: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2204: , x_return_status IN OUT NOCOPY VARCHAR2
2205: )

Line 2202: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2198: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2199: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2200: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
2201: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2202: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2203: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2204: , x_return_status IN OUT NOCOPY VARCHAR2
2205: )
2206:

Line 2209: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

2205: )
2206:
2207: IS
2208:
2209: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2210: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2211:
2212: l_return_status VARCHAR2(1);
2213: l_err_text VARCHAR2(2000) ;

Line 2210: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

2206:
2207: IS
2208:
2209: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2210: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2211:
2212: l_return_status VARCHAR2(1);
2213: l_err_text VARCHAR2(2000) ;
2214: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;