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_RTG_VAL_TO_ID dependencies on BOM_RTG_PUB

Line 922: ( p_rtg_header_Rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type

918: * table and a return satus of success or failure will be
919: * returned to the calling program.
920: *********************************************************************/
921: PROCEDURE RTG_Header_UUI_To_UI
922: ( p_rtg_header_Rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
923: , p_rtg_header_unexp_Rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
924: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
925: , x_Return_Status IN OUT NOCOPY VARCHAR2
926: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 923: , p_rtg_header_unexp_Rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

919: * returned to the calling program.
920: *********************************************************************/
921: PROCEDURE RTG_Header_UUI_To_UI
922: ( p_rtg_header_Rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
923: , p_rtg_header_unexp_Rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
924: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
925: , x_Return_Status IN OUT NOCOPY VARCHAR2
926: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
927: )

Line 924: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

920: *********************************************************************/
921: PROCEDURE RTG_Header_UUI_To_UI
922: ( p_rtg_header_Rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
923: , p_rtg_header_unexp_Rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
924: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
925: , x_Return_Status IN OUT NOCOPY VARCHAR2
926: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
927: )
928: IS

Line 930: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;

926: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
927: )
928: IS
929: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
930: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type;
931: l_return_status VARCHAR2(1);
932: l_err_text VARCHAR2(2000);
933: -- l_err_text_diff VARCHAR2(1);
934:

Line 1074: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type

1070: * the messsage token table filled with appropriate
1071: * error message.
1072: *********************************************************************/
1073: PROCEDURE Rtg_Header_VID
1074: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1075: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
1076: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
1077: , x_Return_Status IN OUT NOCOPY VARCHAR2
1078: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1075: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

1071: * error message.
1072: *********************************************************************/
1073: PROCEDURE Rtg_Header_VID
1074: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1075: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
1076: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
1077: , x_Return_Status IN OUT NOCOPY VARCHAR2
1078: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1079: )

Line 1076: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

1072: *********************************************************************/
1073: PROCEDURE Rtg_Header_VID
1074: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1075: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
1076: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
1077: , x_Return_Status IN OUT NOCOPY VARCHAR2
1078: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1079: )
1080: IS

Line 1085: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

1081: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1082: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1083: l_err_text VARCHAR2(2000);
1084: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1085: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
1086: := p_rtg_header_unexp_rec;
1087: BEGIN
1088:
1089: If BOM_Rtg_Globals.Get_Debug = 'Y'

Line 1342: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type

1338: * returned to the calling program.
1339: *********************************************************************/
1340:
1341: PROCEDURE Rtg_Revision_UUI_To_UI
1342: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
1343: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
1344: , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
1345: , x_return_status IN OUT NOCOPY VARCHAR2
1346: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1343: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type

1339: *********************************************************************/
1340:
1341: PROCEDURE Rtg_Revision_UUI_To_UI
1342: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
1343: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
1344: , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
1345: , x_return_status IN OUT NOCOPY VARCHAR2
1346: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1347: )

Line 1344: , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type

1340:
1341: PROCEDURE Rtg_Revision_UUI_To_UI
1342: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
1343: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
1344: , x_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
1345: , x_return_status IN OUT NOCOPY VARCHAR2
1346: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1347: )
1348: IS

Line 1350: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;

1346: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1347: )
1348: IS
1349: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1350: l_rtg_rev_unexp_rec Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type;
1351: l_return_status VARCHAR2(1);
1352: l_err_text VARCHAR2(2000);
1353:
1354:

Line 1455: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

1451: * Call Check_Entity for Common Operation.
1452: * Procedure will convert UUI to UI.
1453: *******************************************************************/
1454: PROCEDURE Operation_UUI_To_UI
1455: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1456: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1457: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1458: , x_return_status IN OUT NOCOPY VARCHAR2
1459: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1456: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1452: * Procedure will convert UUI to UI.
1453: *******************************************************************/
1454: PROCEDURE Operation_UUI_To_UI
1455: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1456: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1457: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1458: , x_return_status IN OUT NOCOPY VARCHAR2
1459: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1460: )

Line 1457: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1453: *******************************************************************/
1454: PROCEDURE Operation_UUI_To_UI
1455: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1456: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1457: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1458: , x_return_status IN OUT NOCOPY VARCHAR2
1459: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1460: )
1461: IS

Line 1462: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1458: , x_return_status IN OUT NOCOPY VARCHAR2
1459: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1460: )
1461: IS
1462: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1463: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1464: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
1465:
1466: BEGIN

Line 1463: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1459: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1460: )
1461: IS
1462: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1463: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1464: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
1465:
1466: BEGIN
1467: -- Convert Routing Operation to Common Operation

Line 1464: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;

1460: )
1461: IS
1462: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1463: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1464: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
1465:
1466: BEGIN
1467: -- Convert Routing Operation to Common Operation
1468: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

Line 1468: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

1464: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
1465:
1466: BEGIN
1467: -- Convert Routing Operation to Common Operation
1468: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
1469: ( p_rtg_operation_rec => p_operation_rec
1470: , p_rtg_op_unexp_rec => p_op_unexp_rec
1471: , x_com_operation_rec => l_com_operation_rec
1472: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1486: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp

1482: , x_mesg_token_tbl => x_mesg_token_tbl
1483: ) ;
1484:
1485: -- Convert the Common record to Routing Record
1486: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp
1487: ( p_com_operation_rec => l_com_operation_rec
1488: , p_com_op_unexp_rec => l_com_op_unexp_rec
1489: , x_rtg_operation_rec => l_operation_rec
1490: , x_rtg_op_unexp_rec => x_op_unexp_rec

Line 1508: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

1504: * Call Check_Entity for Common Operation.
1505: * Procedure will convert UUI to UI.
1506: *******************************************************************/
1507: PROCEDURE Rev_Operation_UUI_To_UI
1508: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1509: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1510: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1511: , x_return_status IN OUT NOCOPY VARCHAR2
1512: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1509: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

1505: * Procedure will convert UUI to UI.
1506: *******************************************************************/
1507: PROCEDURE Rev_Operation_UUI_To_UI
1508: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1509: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1510: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1511: , x_return_status IN OUT NOCOPY VARCHAR2
1512: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1513: )

Line 1510: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

1506: *******************************************************************/
1507: PROCEDURE Rev_Operation_UUI_To_UI
1508: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1509: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1510: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1511: , x_return_status IN OUT NOCOPY VARCHAR2
1512: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1513: )
1514:

Line 1517: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1513: )
1514:
1515:
1516: IS
1517: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1518: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1519: l_rev_op_com_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
1520:
1521: BEGIN

Line 1518: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1514:
1515:
1516: IS
1517: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1518: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1519: l_rev_op_com_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
1520:
1521: BEGIN
1522: -- Convert Revised Operation to Common Operation

Line 1519: l_rev_op_com_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;

1515:
1516: IS
1517: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1518: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1519: l_rev_op_com_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
1520:
1521: BEGIN
1522: -- Convert Revised Operation to Common Operation
1523: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 1523: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

1519: l_rev_op_com_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
1520:
1521: BEGIN
1522: -- Convert Revised Operation to Common Operation
1523: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
1524: ( p_rev_operation_rec => p_rev_operation_rec
1525: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
1526: , x_com_operation_rec => l_com_operation_rec
1527: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1541: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp

1537: , x_mesg_token_tbl => x_mesg_token_tbl
1538: ) ;
1539:
1540: -- Convert the Common record to Revised Operation record
1541: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp
1542: ( p_com_operation_rec => l_com_operation_rec
1543: , p_com_op_unexp_rec => l_com_op_unexp_rec
1544: , x_rev_operation_rec => l_rev_op_com_operation_rec
1545: , x_rev_op_unexp_rec => x_rev_op_unexp_rec

Line 1566: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

1562: * and a return satus of success or failure will be
1563: * returned to the calling program.
1564: *********************************************************************/
1565: PROCEDURE Com_Operation_UUI_To_UI
1566: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1567: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1568: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1569: , x_return_status IN OUT NOCOPY VARCHAR2
1570: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1567: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1563: * returned to the calling program.
1564: *********************************************************************/
1565: PROCEDURE Com_Operation_UUI_To_UI
1566: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1567: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1568: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1569: , x_return_status IN OUT NOCOPY VARCHAR2
1570: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1571: )

Line 1568: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1564: *********************************************************************/
1565: PROCEDURE Com_Operation_UUI_To_UI
1566: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1567: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1568: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1569: , x_return_status IN OUT NOCOPY VARCHAR2
1570: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1571: )
1572: IS

Line 1575: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;

1571: )
1572: IS
1573:
1574: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1575: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
1576: l_return_status VARCHAR2(1);
1577: l_err_text VARCHAR2(2000);
1578: l_err_text_diff VARCHAR2(1);
1579:

Line 1891: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

1887: * Procedure will perform the operation record value to ID
1888: * conversions.
1889: *******************************************************************/
1890: PROCEDURE Operation_VID
1891: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1892: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1893: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1894: , x_Return_Status IN OUT NOCOPY VARCHAR2
1895: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1892: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1888: * conversions.
1889: *******************************************************************/
1890: PROCEDURE Operation_VID
1891: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1892: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1893: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1894: , x_Return_Status IN OUT NOCOPY VARCHAR2
1895: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1896: )

Line 1893: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1889: *******************************************************************/
1890: PROCEDURE Operation_VID
1891: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1892: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1893: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1894: , x_Return_Status IN OUT NOCOPY VARCHAR2
1895: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1896: )
1897:

Line 1899: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1895: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1896: )
1897:
1898: IS
1899: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1900: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1901: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
1902:
1903: BEGIN

Line 1900: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1896: )
1897:
1898: IS
1899: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1900: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1901: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
1902:
1903: BEGIN
1904: -- Convert Routing Operation to Common Operation

Line 1901: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;

1897:
1898: IS
1899: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1900: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1901: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
1902:
1903: BEGIN
1904: -- Convert Routing Operation to Common Operation
1905: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

Line 1905: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

1901: l_operation_rec Bom_Rtg_Pub.Operation_Rec_Type ;
1902:
1903: BEGIN
1904: -- Convert Routing Operation to Common Operation
1905: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
1906: ( p_rtg_operation_rec => p_operation_rec
1907: , p_rtg_op_unexp_rec => p_op_unexp_rec
1908: , x_com_operation_rec => l_com_operation_rec
1909: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1923: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp

1919: , x_mesg_token_tbl => x_mesg_token_tbl
1920: ) ;
1921:
1922: -- Convert the Common record to Routing Record
1923: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp
1924: ( p_com_operation_rec => l_com_operation_rec
1925: , p_com_op_unexp_rec => l_com_op_unexp_rec
1926: , x_rtg_operation_rec => l_operation_rec
1927: , x_rtg_op_unexp_rec => x_op_unexp_rec

Line 1946: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

1942: * Procedure will perform the operation record value to ID
1943: * conversions.
1944: *******************************************************************/
1945: PROCEDURE Rev_Operation_VID
1946: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1947: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1948: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1949: , x_return_status IN OUT NOCOPY VARCHAR2
1950: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1947: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

1943: * conversions.
1944: *******************************************************************/
1945: PROCEDURE Rev_Operation_VID
1946: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1947: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1948: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1949: , x_return_status IN OUT NOCOPY VARCHAR2
1950: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1951: )

Line 1948: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

1944: *******************************************************************/
1945: PROCEDURE Rev_Operation_VID
1946: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1947: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1948: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1949: , x_return_status IN OUT NOCOPY VARCHAR2
1950: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1951: )
1952:

Line 1955: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1951: )
1952:
1953:
1954: IS
1955: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1956: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1957: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
1958:
1959: BEGIN

Line 1956: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1952:
1953:
1954: IS
1955: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1956: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1957: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
1958:
1959: BEGIN
1960: -- Convert Revised Operation to Common Operation

Line 1957: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;

1953:
1954: IS
1955: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1956: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1957: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
1958:
1959: BEGIN
1960: -- Convert Revised Operation to Common Operation
1961: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 1961: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

1957: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
1958:
1959: BEGIN
1960: -- Convert Revised Operation to Common Operation
1961: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
1962: ( p_rev_operation_rec => p_rev_operation_rec
1963: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
1964: , x_com_operation_rec => l_com_operation_rec
1965: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1979: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp

1975: , x_mesg_token_tbl => x_mesg_token_tbl
1976: ) ;
1977:
1978: -- Convert the Common record to Revised Operation record
1979: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp
1980: ( p_com_operation_rec => l_com_operation_rec
1981: , p_com_op_unexp_rec => l_com_op_unexp_rec
1982: , x_rev_operation_rec => l_rev_operation_rec
1983: , x_rev_op_unexp_rec => x_rev_op_unexp_rec

Line 2005: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

2001: * the messsage token table filled with appropriate
2002: * error message.
2003: *********************************************************************/
2004: PROCEDURE Com_Operation_VID
2005: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2006: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2007: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2008: , x_Return_Status IN OUT NOCOPY VARCHAR2
2009: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2006: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2002: * error message.
2003: *********************************************************************/
2004: PROCEDURE Com_Operation_VID
2005: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2006: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2007: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2008: , x_Return_Status IN OUT NOCOPY VARCHAR2
2009: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2010: )

Line 2007: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2003: *********************************************************************/
2004: PROCEDURE Com_Operation_VID
2005: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2006: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2007: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2008: , x_Return_Status IN OUT NOCOPY VARCHAR2
2009: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2010: )
2011: IS

Line 2016: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2012: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
2013: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2014: l_err_text VARCHAR2(2000);
2015: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2016: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2017: := p_com_op_unexp_rec;
2018: l_common_rtg_seq_id NUMBER;
2019: l_cfm_flag NUMBER;
2020: l_old_op_seq_number NUMBER;

Line 2428: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type

2424: * After calling Rev_Op_resource_UUI_To_UI, convert Revised
2425: * Op Resource record back to Routing Op Resource
2426: *********************************************************************/
2427: PROCEDURE Op_Resource_UUI_To_UI
2428: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
2429: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2430: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2431: , x_return_status IN OUT NOCOPY VARCHAR2
2432: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2429: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

2425: * Op Resource record back to Routing Op Resource
2426: *********************************************************************/
2427: PROCEDURE Op_Resource_UUI_To_UI
2428: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
2429: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2430: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2431: , x_return_status IN OUT NOCOPY VARCHAR2
2432: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2433: )

Line 2430: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

2426: *********************************************************************/
2427: PROCEDURE Op_Resource_UUI_To_UI
2428: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
2429: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2430: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2431: , x_return_status IN OUT NOCOPY VARCHAR2
2432: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2433: )
2434:

Line 2436: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

2432: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2433: )
2434:
2435: IS
2436: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
2437: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
2438: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
2439:
2440: BEGIN

Line 2437: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

2433: )
2434:
2435: IS
2436: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
2437: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
2438: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
2439:
2440: BEGIN
2441: -- Convert Routing Operation to ECO Operation

Line 2438: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;

2434:
2435: IS
2436: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
2437: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
2438: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
2439:
2440: BEGIN
2441: -- Convert Routing Operation to ECO Operation
2442: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

Line 2442: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

2438: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
2439:
2440: BEGIN
2441: -- Convert Routing Operation to ECO Operation
2442: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes
2443: ( p_rtg_op_resource_rec => p_op_resource_rec
2444: , p_rtg_op_res_unexp_rec => p_op_res_unexp_rec
2445: , x_rev_op_resource_rec => l_rev_op_resource_rec
2446: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec

Line 2459: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes

2455: , x_mesg_token_tbl => x_mesg_token_tbl
2456: ) ;
2457:
2458: -- Convert old Eco Opeartion Record back to Routing Operation
2459: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes
2460: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2461: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2462: , x_rtg_op_resource_rec => l_op_resource_rec
2463: , x_rtg_op_res_unexp_rec => x_op_res_unexp_rec

Line 2483: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

2479: * Message table and a return satus of success or
2480: * failure will be returned to the calling program.
2481: *********************************************************************/
2482: PROCEDURE Rev_Op_Resource_UUI_To_UI
2483: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
2484: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2485: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2486: , x_return_status IN OUT NOCOPY VARCHAR2
2487: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2484: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

2480: * failure will be returned to the calling program.
2481: *********************************************************************/
2482: PROCEDURE Rev_Op_Resource_UUI_To_UI
2483: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
2484: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2485: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2486: , x_return_status IN OUT NOCOPY VARCHAR2
2487: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2488: )

Line 2485: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

2481: *********************************************************************/
2482: PROCEDURE Rev_Op_Resource_UUI_To_UI
2483: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
2484: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2485: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2486: , x_return_status IN OUT NOCOPY VARCHAR2
2487: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2488: )
2489:

Line 2494: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

2490:
2491:
2492: IS
2493: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2494: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
2495: l_return_status VARCHAR2(1);
2496: l_err_text VARCHAR2(2000);
2497: l_cfm_flag NUMBER;
2498: l_err_text_diff VARCHAR2(1);

Line 2918: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type

2914: * After calling Rev_Op_resource_VID, convert Revised
2915: * Op Resource record back to Routing Op Resource
2916: *********************************************************************/
2917: PROCEDURE Op_Resource_VID
2918: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
2919: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2920: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2921: , x_return_status IN OUT NOCOPY VARCHAR2
2922: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2919: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

2915: * Op Resource record back to Routing Op Resource
2916: *********************************************************************/
2917: PROCEDURE Op_Resource_VID
2918: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
2919: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2920: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2921: , x_return_status IN OUT NOCOPY VARCHAR2
2922: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2923: )

Line 2920: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

2916: *********************************************************************/
2917: PROCEDURE Op_Resource_VID
2918: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
2919: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2920: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
2921: , x_return_status IN OUT NOCOPY VARCHAR2
2922: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2923: )
2924:

Line 2926: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

2922: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2923: )
2924:
2925: IS
2926: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
2927: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
2928: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
2929:
2930: BEGIN

Line 2927: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

2923: )
2924:
2925: IS
2926: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
2927: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
2928: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
2929:
2930: BEGIN
2931: -- Convert Routing Operation to ECO Operation

Line 2928: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;

2924:
2925: IS
2926: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
2927: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
2928: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
2929:
2930: BEGIN
2931: -- Convert Routing Operation to ECO Operation
2932: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

Line 2932: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

2928: l_op_resource_rec Bom_Rtg_Pub.Op_Resource_Rec_Type ;
2929:
2930: BEGIN
2931: -- Convert Routing Operation to ECO Operation
2932: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes
2933: ( p_rtg_op_resource_rec => p_op_resource_rec
2934: , p_rtg_op_res_unexp_rec => p_op_res_unexp_rec
2935: , x_rev_op_resource_rec => l_rev_op_resource_rec
2936: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec

Line 2949: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes

2945: , x_mesg_token_tbl => x_mesg_token_tbl
2946: ) ;
2947:
2948: -- Convert old Eco Opeartion Record back to Routing Operation
2949: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes
2950: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2951: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2952: , x_rtg_op_resource_rec => l_op_resource_rec
2953: , x_rtg_op_res_unexp_rec => x_op_res_unexp_rec

Line 2976: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

2972: * the messsage token table filled with appropriate
2973: * error message.
2974: *********************************************************************/
2975: PROCEDURE Rev_Op_Resource_VID
2976: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
2977: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2978: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2979: , x_Return_Status IN OUT NOCOPY VARCHAR2
2980: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2977: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

2973: * error message.
2974: *********************************************************************/
2975: PROCEDURE Rev_Op_Resource_VID
2976: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
2977: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2978: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2979: , x_Return_Status IN OUT NOCOPY VARCHAR2
2980: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2981: )

Line 2978: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

2974: *********************************************************************/
2975: PROCEDURE Rev_Op_Resource_VID
2976: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
2977: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2978: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2979: , x_Return_Status IN OUT NOCOPY VARCHAR2
2980: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2981: )
2982: IS

Line 2987: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

2983: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
2984: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2985: l_err_text VARCHAR2(2000);
2986: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2987: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
2988: := p_rev_op_res_unexp_rec ;
2989: BEGIN
2990:
2991: IF BOM_Rtg_Globals.Get_Debug = 'Y'

Line 3173: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type

3169: * After calling Rev_Sub_resource_UUI_To_UI, convert
3170: * Revised Op Resource record back to Routing Op Resource
3171: *********************************************************************/
3172: PROCEDURE Sub_Resource_UUI_To_UI
3173: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
3174: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3175: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3176: , x_return_status IN OUT NOCOPY VARCHAR2
3177: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 3174: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

3170: * Revised Op Resource record back to Routing Op Resource
3171: *********************************************************************/
3172: PROCEDURE Sub_Resource_UUI_To_UI
3173: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
3174: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3175: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3176: , x_return_status IN OUT NOCOPY VARCHAR2
3177: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3178: )

Line 3175: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

3171: *********************************************************************/
3172: PROCEDURE Sub_Resource_UUI_To_UI
3173: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
3174: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3175: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3176: , x_return_status IN OUT NOCOPY VARCHAR2
3177: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3178: )
3179:

Line 3181: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type ;

3177: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3178: )
3179:
3180: IS
3181: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type ;
3182: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
3183: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
3184:
3185: BEGIN

Line 3182: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

3178: )
3179:
3180: IS
3181: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type ;
3182: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
3183: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
3184:
3185: BEGIN
3186: -- Convert Routing Operation to ECO Operation

Line 3183: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;

3179:
3180: IS
3181: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type ;
3182: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
3183: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
3184:
3185: BEGIN
3186: -- Convert Routing Operation to ECO Operation
3187: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

Line 3187: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

3183: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
3184:
3185: BEGIN
3186: -- Convert Routing Operation to ECO Operation
3187: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes
3188: ( p_rtg_sub_resource_rec => p_sub_resource_rec
3189: , p_rtg_sub_res_unexp_rec => p_sub_res_unexp_rec
3190: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
3191: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec

Line 3204: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes

3200: , x_mesg_token_tbl => x_mesg_token_tbl
3201: ) ;
3202:
3203: -- Convert Eco Sub Resource Record back to Routing Sub Resource
3204: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes
3205: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
3206: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3207: , x_rtg_sub_resource_rec => l_sub_resource_rec
3208: , x_rtg_sub_res_unexp_rec => x_sub_res_unexp_rec

Line 3232: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

3228: * success or failure will be returned to the calling
3229: * program.
3230: *********************************************************************/
3231: PROCEDURE Rev_Sub_Resource_UUI_To_UI
3232: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
3233: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3234: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3235: , x_return_status IN OUT NOCOPY VARCHAR2
3236: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 3233: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

3229: * program.
3230: *********************************************************************/
3231: PROCEDURE Rev_Sub_Resource_UUI_To_UI
3232: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
3233: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3234: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3235: , x_return_status IN OUT NOCOPY VARCHAR2
3236: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3237: )

Line 3234: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

3230: *********************************************************************/
3231: PROCEDURE Rev_Sub_Resource_UUI_To_UI
3232: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
3233: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3234: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3235: , x_return_status IN OUT NOCOPY VARCHAR2
3236: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3237: )
3238: IS

Line 3240: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

3236: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3237: )
3238: IS
3239: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3240: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
3241: l_return_status VARCHAR2(1);
3242: l_err_text VARCHAR2(2000);
3243: l_cfm_flag NUMBER;
3244: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 3809: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type

3805: * After calling Rev_Sub_resource_VID, convert
3806: * Revised Sub Op Resource record back to Routing Sub Op Resource
3807: *********************************************************************/
3808: PROCEDURE Sub_Resource_VID
3809: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
3810: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3811: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3812: , x_Return_Status IN OUT NOCOPY VARCHAR2
3813: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 3810: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

3806: * Revised Sub Op Resource record back to Routing Sub Op Resource
3807: *********************************************************************/
3808: PROCEDURE Sub_Resource_VID
3809: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
3810: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3811: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3812: , x_Return_Status IN OUT NOCOPY VARCHAR2
3813: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3814: )

Line 3811: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

3807: *********************************************************************/
3808: PROCEDURE Sub_Resource_VID
3809: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
3810: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3811: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
3812: , x_Return_Status IN OUT NOCOPY VARCHAR2
3813: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3814: )
3815:

Line 3817: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type ;

3813: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3814: )
3815:
3816: IS
3817: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type ;
3818: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
3819: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
3820:
3821: BEGIN

Line 3818: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

3814: )
3815:
3816: IS
3817: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type ;
3818: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
3819: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
3820:
3821: BEGIN
3822: -- Convert Routing Operation to ECO Operation

Line 3819: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;

3815:
3816: IS
3817: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type ;
3818: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
3819: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
3820:
3821: BEGIN
3822: -- Convert Routing Operation to ECO Operation
3823: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

Line 3823: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

3819: l_sub_resource_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type ;
3820:
3821: BEGIN
3822: -- Convert Routing Operation to ECO Operation
3823: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes
3824: ( p_rtg_sub_resource_rec => p_sub_resource_rec
3825: , p_rtg_sub_res_unexp_rec => p_sub_res_unexp_rec
3826: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
3827: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec

Line 3840: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes

3836: , x_mesg_token_tbl => x_mesg_token_tbl
3837: ) ;
3838:
3839: -- Convert Eco Sub Resource Record back to Routing Sub Resource
3840: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes
3841: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
3842: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3843: , x_rtg_sub_resource_rec => l_sub_resource_rec
3844: , x_rtg_sub_res_unexp_rec => x_sub_res_unexp_rec

Line 3867: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

3863: * status and the messsage token table filled with
3864: * appropriate error message.
3865: *********************************************************************/
3866: PROCEDURE Rev_Sub_Resource_VID
3867: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
3868: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3869: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3870: , x_Return_Status IN OUT NOCOPY VARCHAR2
3871: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 3868: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

3864: * appropriate error message.
3865: *********************************************************************/
3866: PROCEDURE Rev_Sub_Resource_VID
3867: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
3868: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3869: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3870: , x_Return_Status IN OUT NOCOPY VARCHAR2
3871: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3872: )

Line 3869: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

3865: *********************************************************************/
3866: PROCEDURE Rev_Sub_Resource_VID
3867: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
3868: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3869: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3870: , x_Return_Status IN OUT NOCOPY VARCHAR2
3871: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3872: )
3873: IS

Line 3878: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

3874: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
3875: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3876: l_err_text VARCHAR2(2000);
3877: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3878: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
3879: := p_rev_sub_res_unexp_rec ;
3880: BEGIN
3881:
3882: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

Line 4060: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type

4056: * success or failure will be returned to the calling
4057: * program.
4058: *********************************************************************/
4059: PROCEDURE OP_Network_UUI_To_UI
4060: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
4061: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
4062: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
4063: , x_return_status IN OUT NOCOPY VARCHAR2
4064: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 4061: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type

4057: * program.
4058: *********************************************************************/
4059: PROCEDURE OP_Network_UUI_To_UI
4060: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
4061: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
4062: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
4063: , x_return_status IN OUT NOCOPY VARCHAR2
4064: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4065: )

Line 4062: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type

4058: *********************************************************************/
4059: PROCEDURE OP_Network_UUI_To_UI
4060: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
4061: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
4062: , x_op_network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
4063: , x_return_status IN OUT NOCOPY VARCHAR2
4064: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4065: )
4066: IS

Line 4068: l_op_network_unexp_rec Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type;

4064: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4065: )
4066: IS
4067: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4068: l_op_network_unexp_rec Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type;
4069: l_return_status VARCHAR2(1);
4070: l_err_text VARCHAR2(2000);
4071: l_cfm_flag NUMBER;
4072: l_err_text_diff VARCHAR2(1);