DBA Data[Home] [Help]

APPS.BOM_RTG_EAM_UTIL dependencies on BOM_RTG_PUB

Line 1039: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type

1035: * Purpose : Procedure will validate for eAM Rtg Network.
1036: * This procedure is called by Routing BO and BOMFDONW form
1037: *********************************************************************/
1038: PROCEDURE Check_Eam_Rtg_Network
1039: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
1040: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
1041: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
1042: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
1043: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type

Line 1040: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type

1036: * This procedure is called by Routing BO and BOMFDONW form
1037: *********************************************************************/
1038: PROCEDURE Check_Eam_Rtg_Network
1039: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
1040: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
1041: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
1042: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
1043: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
1044: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1041: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type

1037: *********************************************************************/
1038: PROCEDURE Check_Eam_Rtg_Network
1039: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
1040: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
1041: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
1042: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
1043: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
1044: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1045: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1042: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type

1038: PROCEDURE Check_Eam_Rtg_Network
1039: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
1040: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
1041: , p_old_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
1042: , p_old_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
1043: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
1044: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1045: , x_return_status IN OUT NOCOPY VARCHAR2
1046: )

Line 1907: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type

1903:
1904:
1905: PROCEDURE Create_OpNwkTbl_From_OpLinkTbl
1906: ( p_op_link_tbl IN Bom_Rtg_Eam_Util.Op_Link_Tbl_Type
1907: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
1908: )
1909: IS
1910:
1911: -- Retrieve operation network from RBO_NWK

Line 2001: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;

1997: )
1998: IS
1999:
2000: /* Record and Table declaration */
2001: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2002: l_out_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2003: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2004: l_out_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;

Line 2002: l_out_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;

1998: IS
1999:
2000: /* Record and Table declaration */
2001: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2002: l_out_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2003: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2004: l_out_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;

Line 2003: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;

1999:
2000: /* Record and Table declaration */
2001: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2002: l_out_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2003: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2004: l_out_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;

Line 2004: l_out_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;

2000: /* Record and Table declaration */
2001: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2002: l_out_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2003: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2004: l_out_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;

Line 2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;

2001: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2002: l_out_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2003: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2004: l_out_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2009: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;

Line 2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;

2002: l_out_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type ;
2003: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2004: l_out_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2009: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2010: l_out_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;

Line 2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;

2003: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2004: l_out_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2009: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2010: l_out_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2011: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;

Line 2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;

2004: l_out_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2009: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2010: l_out_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2011: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
2012: l_out_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;

Line 2009: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;

2005: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2009: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2010: l_out_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2011: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
2012: l_out_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
2013:

Line 2010: l_out_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;

2006: l_out_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type ;
2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2009: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2010: l_out_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2011: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
2012: l_out_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
2013:
2014: l_return_status VARCHAR2(1);

Line 2011: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;

2007: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2009: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2010: l_out_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2011: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
2012: l_out_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
2013:
2014: l_return_status VARCHAR2(1);
2015: l_unexp_error VARCHAR2(1000);

Line 2012: l_out_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;

2008: l_out_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
2009: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2010: l_out_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type ;
2011: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
2012: l_out_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type ;
2013:
2014: l_return_status VARCHAR2(1);
2015: l_unexp_error VARCHAR2(1000);
2016: l_msg_count NUMBER := 0;

Line 2042: Bom_Rtg_Pub.Process_Rtg

2038: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
2039: ('Call Routing Business Object Public API . . . ');
2040: END IF ;
2041:
2042: Bom_Rtg_Pub.Process_Rtg
2043: ( p_init_msg_list => TRUE
2044: , p_rtg_header_rec => l_rtg_header_rec
2045: , p_rtg_revision_tbl => l_rtg_revision_tbl
2046: , p_operation_tbl => l_operation_tbl