APPS.BOM_VAL_TO_ID dependencies on BOM_BO_PUB

Line 385: ( p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

381: * and a return satus of success or failure will be
382: * returned to the calling program.
383: *********************************************************************/
384: PROCEDURE BOM_Header_UUI_To_UI
385: ( p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
386: , p_bom_header_unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
387: , x_bom_header_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
388: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
389: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 386: , p_bom_header_unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

382: * returned to the calling program.
383: *********************************************************************/
384: PROCEDURE BOM_Header_UUI_To_UI
385: ( p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
386: , p_bom_header_unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
387: , x_bom_header_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
388: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
389: , x_Return_Status IN OUT NOCOPY VARCHAR2
390: )

Line 387: , x_bom_header_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

383: *********************************************************************/
384: PROCEDURE BOM_Header_UUI_To_UI
385: ( p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
386: , p_bom_header_unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
387: , x_bom_header_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
388: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
389: , x_Return_Status IN OUT NOCOPY VARCHAR2
390: )
391: IS

Line 393: l_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;

389: , x_Return_Status IN OUT NOCOPY VARCHAR2
390: )
391: IS
392: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
393: l_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
394: l_return_status VARCHAR2(1);
395: l_err_text VARCHAR2(2000);
396:
397: CURSOR c_Check_Alternate( p_alt_designator VARCHAR2,

Line 527: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

523: *********************************************************************/
524: PROCEDURE Bom_Header_VID
525: ( x_Return_Status IN OUT NOCOPY VARCHAR2
526: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
527: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
528: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
529: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
530: )
531: IS

Line 528: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

524: PROCEDURE Bom_Header_VID
525: ( x_Return_Status IN OUT NOCOPY VARCHAR2
526: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
527: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
528: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
529: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
530: )
531: IS
532: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;

Line 529: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

525: ( x_Return_Status IN OUT NOCOPY VARCHAR2
526: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
527: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
528: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
529: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
530: )
531: IS
532: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
533: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 536: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

532: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
533: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
534: l_err_text VARCHAR2(2000);
535: l_Token_Tbl Error_Handler.Token_Tbl_Type;
536: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
537: := p_bom_head_unexp_rec;
538: l_src_bill_sequence_id NUMBER;
539:
540: BEGIN

Line 731: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type

727: * convert the user friendly values for the primary key
728: * of Revisions entity columns.
729: *******************************************************************/
730: PROCEDURE Bom_Revision_UUI_To_UI2
731: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
732: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
733: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
734: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
735: , x_return_status IN OUT NOCOPY VARCHAR2

Line 732: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type

728: * of Revisions entity columns.
729: *******************************************************************/
730: PROCEDURE Bom_Revision_UUI_To_UI2
731: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
732: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
733: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
734: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
735: , x_return_status IN OUT NOCOPY VARCHAR2
736: )

Line 733: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type

729: *******************************************************************/
730: PROCEDURE Bom_Revision_UUI_To_UI2
731: ( p_bom_revision_rec IN Bom_Bo_Pub.Bom_Revision_Rec_Type
732: , p_bom_rev_unexp_rec IN Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
733: , x_bom_rev_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type
734: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
735: , x_return_status IN OUT NOCOPY VARCHAR2
736: )
737: IS

Line 739: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;

735: , x_return_status IN OUT NOCOPY VARCHAR2
736: )
737: IS
738: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
739: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;
740: l_err_text VARCHAR2(2000);
741: BEGIN
742: x_bom_rev_unexp_rec := p_bom_rev_unexp_rec;
743: l_bom_rev_unexp_rec := p_bom_rev_unexp_rec;

Line 1145: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1141: ********************************************************************/
1142: PROCEDURE Rev_Component_VID
1143: ( x_Return_Status IN OUT NOCOPY Varchar2
1144: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1145: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1146: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1147: , p_Rev_Component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1148: ) IS
1149: l_return_value NUMBER;

Line 1146: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1142: PROCEDURE Rev_Component_VID
1143: ( x_Return_Status IN OUT NOCOPY Varchar2
1144: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1145: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1146: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1147: , p_Rev_Component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1148: ) IS
1149: l_return_value NUMBER;
1150: l_Return_Status VARCHAR2(1);

Line 1147: , p_Rev_Component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

1143: ( x_Return_Status IN OUT NOCOPY Varchar2
1144: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1145: , p_Rev_Comp_Unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1146: , x_Rev_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1147: , p_Rev_Component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1148: ) IS
1149: l_return_value NUMBER;
1150: l_Return_Status VARCHAR2(1);
1151: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 1153: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

1149: l_return_value NUMBER;
1150: l_Return_Status VARCHAR2(1);
1151: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1152: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1153: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
1154:
1155: BEGIN
1156: l_Return_Status := FND_API.G_RET_STS_SUCCESS;
1157: l_Rev_Comp_Unexp_Rec := p_Rev_Comp_Unexp_Rec;

Line 1388: ( p_rev_component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

1384: * for all the revised component columns that form the
1385: * unique key for this entity.
1386: *********************************************************************/
1387: PROCEDURE Rev_Component_UUI_To_UI
1388: ( p_rev_component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1389: , p_rev_comp_unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1390: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1391: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1392: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 1389: , p_rev_comp_unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1385: * unique key for this entity.
1386: *********************************************************************/
1387: PROCEDURE Rev_Component_UUI_To_UI
1388: ( p_rev_component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1389: , p_rev_comp_unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1390: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1391: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1392: , x_Return_Status IN OUT NOCOPY VARCHAR2
1393: )

Line 1390: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1386: *********************************************************************/
1387: PROCEDURE Rev_Component_UUI_To_UI
1388: ( p_rev_component_Rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1389: , p_rev_comp_unexp_Rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1390: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1391: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1392: , x_Return_Status IN OUT NOCOPY VARCHAR2
1393: )
1394: IS

Line 1396: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

1392: , x_Return_Status IN OUT NOCOPY VARCHAR2
1393: )
1394: IS
1395: l_err_text VARCHAR2(2000);
1396: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
1397: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1398: l_Return_status VARCHAR2(1);
1399: BEGIN
1400: l_rev_comp_unexp_rec := p_rev_comp_unexp_Rec;

Line 1513: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type

1509: * This procedure will convert all those values which
1510: * will cause the siblings to error out.
1511: ********************************************************************/
1512: PROCEDURE Rev_Component_UUI_to_UI2
1513: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1514: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1515: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1516: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1517: , x_other_message IN OUT NOCOPY VARCHAR2

Line 1514: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1510: * will cause the siblings to error out.
1511: ********************************************************************/
1512: PROCEDURE Rev_Component_UUI_to_UI2
1513: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1514: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1515: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1516: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1517: , x_other_message IN OUT NOCOPY VARCHAR2
1518: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type

Line 1515: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1511: ********************************************************************/
1512: PROCEDURE Rev_Component_UUI_to_UI2
1513: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type
1514: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1515: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1516: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1517: , x_other_message IN OUT NOCOPY VARCHAR2
1518: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
1519: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 1524: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

1520: )
1521: IS
1522: l_return_status VARCHAR2(1);
1523: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1524: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
1525: := p_rev_comp_unexp_rec;
1526: l_err_text VARCHAR2(2000);
1527: BEGIN
1528:

Line 1838: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

1834: * the Substitute component columns that form the unique
1835: * key for this entity.
1836: ********************************************************************/
1837: PROCEDURE Sub_Component_UUI_To_UI
1838: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
1839: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
1840: , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
1841: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1842: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 1839: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

1835: * key for this entity.
1836: ********************************************************************/
1837: PROCEDURE Sub_Component_UUI_To_UI
1838: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
1839: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
1840: , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
1841: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1842: , x_Return_Status IN OUT NOCOPY VARCHAR2
1843: )

Line 1840: , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

1836: ********************************************************************/
1837: PROCEDURE Sub_Component_UUI_To_UI
1838: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
1839: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
1840: , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
1841: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1842: , x_Return_Status IN OUT NOCOPY VARCHAR2
1843: )
1844: IS

Line 1845: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

1841: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1842: , x_Return_Status IN OUT NOCOPY VARCHAR2
1843: )
1844: IS
1845: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1846: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1847: l_Err_Text VARCHAR2(2000);
1848: l_return_status VARCHAR2(1);
1849: l_token_tbl Error_Handler.Token_Tbl_Type;

Line 2031: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

2027: * the scope of the error when conversion in this procedure
2028: * fail and would then error all the siblings.
2029: ***************************************************************************/
2030: PROCEDURE Sub_Component_UUI_To_UI2
2031: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
2032: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
2033: , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
2034: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2035: , x_other_message IN OUT NOCOPY VARCHAR2

Line 2032: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

2028: * fail and would then error all the siblings.
2029: ***************************************************************************/
2030: PROCEDURE Sub_Component_UUI_To_UI2
2031: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
2032: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
2033: , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
2034: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2035: , x_other_message IN OUT NOCOPY VARCHAR2
2036: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type

Line 2033: , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

2029: ***************************************************************************/
2030: PROCEDURE Sub_Component_UUI_To_UI2
2031: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
2032: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
2033: , x_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
2034: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2035: , x_other_message IN OUT NOCOPY VARCHAR2
2036: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
2037: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 2040: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

2036: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
2037: , x_Return_Status IN OUT NOCOPY VARCHAR2
2038: )
2039: IS
2040: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
2041: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2042: l_Err_Text VARCHAR2(2000);
2043: l_return_status VARCHAR2(1);
2044: l_dummy NUMBER;

Line 2480: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

2476: * Purpose : This procedure will convert user unique idx columns
2477: * into unique id columns.
2478: ********************************************************************/
2479: PROCEDURE Ref_Designator_UUI_To_UI
2480: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
2481: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2482: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2483: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2484: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 2481: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

2477: * into unique id columns.
2478: ********************************************************************/
2479: PROCEDURE Ref_Designator_UUI_To_UI
2480: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
2481: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2482: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2483: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2484: , x_Return_Status IN OUT NOCOPY VARCHAR2
2485: )

Line 2482: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

2478: ********************************************************************/
2479: PROCEDURE Ref_Designator_UUI_To_UI
2480: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
2481: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2482: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2483: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2484: , x_Return_Status IN OUT NOCOPY VARCHAR2
2485: )
2486: IS

Line 2487: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

2483: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2484: , x_Return_Status IN OUT NOCOPY VARCHAR2
2485: )
2486: IS
2487: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
2488: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2489: l_Err_Text VARCHAR2(2000);
2490: l_Return_Status VARCHAR2(1);
2491: l_token_tbl Error_Handler.Token_Tbl_Type;

Line 2617: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

2613: * program can decide on the scope of the error if the
2614: * conversion in this procedure fails.
2615: ******************************************************************/
2616: PROCEDURE Ref_Designator_UUI_To_UI2
2617: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
2618: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2619: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2620: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2621: , x_other_message IN OUT NOCOPY VARCHAR2

Line 2618: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

2614: * conversion in this procedure fails.
2615: ******************************************************************/
2616: PROCEDURE Ref_Designator_UUI_To_UI2
2617: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
2618: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2619: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2620: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2621: , x_other_message IN OUT NOCOPY VARCHAR2
2622: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type

Line 2619: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

2615: ******************************************************************/
2616: PROCEDURE Ref_Designator_UUI_To_UI2
2617: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
2618: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2619: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
2620: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2621: , x_other_message IN OUT NOCOPY VARCHAR2
2622: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
2623: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 2626: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type :=

2622: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
2623: , x_Return_Status IN OUT NOCOPY VARCHAR2
2624: )
2625: IS
2626: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type :=
2627: p_ref_desg_unexp_rec;
2628: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2629: l_Err_Text VARCHAR2(2000);
2630: l_Return_Status VARCHAR2(1);

Line 3027: ( p_bom_component_Rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type

3023: ** Procedures used by BOM Business Object
3024: */
3025:
3026: PROCEDURE Bom_Component_UUI_To_UI
3027: ( p_bom_component_Rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3028: , p_bom_comp_unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3029: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3030: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3031: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 3028: , p_bom_comp_unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

3024: */
3025:
3026: PROCEDURE Bom_Component_UUI_To_UI
3027: ( p_bom_component_Rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3028: , p_bom_comp_unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3029: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3030: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3031: , x_Return_Status IN OUT NOCOPY VARCHAR2
3032: )

Line 3029: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

3025:
3026: PROCEDURE Bom_Component_UUI_To_UI
3027: ( p_bom_component_Rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3028: , p_bom_comp_unexp_Rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3029: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3030: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3031: , x_Return_Status IN OUT NOCOPY VARCHAR2
3032: )
3033: IS

Line 3034: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;

3030: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3031: , x_Return_Status IN OUT NOCOPY VARCHAR2
3032: )
3033: IS
3034: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3035: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
3036: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
3037: BEGIN
3038:

Line 3035: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

3031: , x_Return_Status IN OUT NOCOPY VARCHAR2
3032: )
3033: IS
3034: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3035: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
3036: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
3037: BEGIN
3038:
3039: --

Line 3036: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;

3032: )
3033: IS
3034: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3035: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
3036: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
3037: BEGIN
3038:
3039: --
3040: -- Convert the BOM Record to ECO

Line 3042: Bom_Bo_Pub.Convert_BomComp_To_EcoComp

3038:
3039: --
3040: -- Convert the BOM Record to ECO
3041: --
3042: Bom_Bo_Pub.Convert_BomComp_To_EcoComp
3043: ( p_bom_component_rec => p_bom_component_rec
3044: , p_bom_comp_unexp_rec => p_bom_comp_unexp_rec
3045: , x_rev_component_rec => l_rev_component_rec
3046: , x_rev_comp_unexp_rec => l_rev_comp_unexp_rec

Line 3060: Bom_Bo_Pub.Convert_EcoComp_To_BomComp

3056:
3057: --
3058: -- Convert the Eco Component back to BOM
3059: --
3060: Bom_Bo_Pub.Convert_EcoComp_To_BomComp
3061: ( p_rev_component_rec => l_rev_component_rec
3062: , p_rev_comp_unexp_rec => l_rev_comp_unexp_rec
3063: , x_bom_component_rec => l_bom_component_rec
3064: , x_bom_comp_unexp_rec => x_bom_comp_unexp_rec

Line 3071: ( p_Bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type

3067: END Bom_Component_UUI_To_UI;
3068:
3069:
3070: PROCEDURE Bom_Component_UUI_to_UI2
3071: ( p_Bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3072: , p_Bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3073: , x_Bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3074: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3075: , x_other_message IN OUT NOCOPY VARCHAR2

Line 3072: , p_Bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

3068:
3069:
3070: PROCEDURE Bom_Component_UUI_to_UI2
3071: ( p_Bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3072: , p_Bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3073: , x_Bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3074: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3075: , x_other_message IN OUT NOCOPY VARCHAR2
3076: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type

Line 3073: , x_Bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

3069:
3070: PROCEDURE Bom_Component_UUI_to_UI2
3071: ( p_Bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3072: , p_Bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3073: , x_Bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3074: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3075: , x_other_message IN OUT NOCOPY VARCHAR2
3076: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
3077: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 3080: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;

3076: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
3077: , x_Return_Status IN OUT NOCOPY VARCHAR2
3078: )
3079: IS
3080: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3081: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
3082: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
3083: BEGIN
3084:

Line 3081: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

3077: , x_Return_Status IN OUT NOCOPY VARCHAR2
3078: )
3079: IS
3080: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3081: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
3082: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
3083: BEGIN
3084:
3085: --

Line 3082: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;

3078: )
3079: IS
3080: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3081: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
3082: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
3083: BEGIN
3084:
3085: --
3086: -- Convert the BOM Record to ECO

Line 3088: Bom_Bo_Pub.Convert_BomComp_To_EcoComp

3084:
3085: --
3086: -- Convert the BOM Record to ECO
3087: --
3088: Bom_Bo_Pub.Convert_BomComp_To_EcoComp
3089: ( p_bom_component_rec => p_bom_component_rec
3090: , p_bom_comp_unexp_rec => p_bom_comp_unexp_rec
3091: , x_rev_component_rec => l_rev_component_rec
3092: , x_rev_comp_unexp_rec => l_rev_comp_unexp_rec

Line 3108: Bom_Bo_Pub.Convert_EcoComp_To_BomComp

3104:
3105: --
3106: -- Convert the Eco Component back to BOM
3107: --
3108: Bom_Bo_Pub.Convert_EcoComp_To_BomComp
3109: ( p_rev_component_rec => l_rev_component_rec
3110: , p_rev_comp_unexp_rec => l_rev_comp_unexp_rec
3111: , x_bom_component_rec => l_bom_component_rec
3112: , x_bom_comp_unexp_rec => x_bom_comp_unexp_rec

Line 3121: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

3117:
3118: PROCEDURE Bom_Component_VID
3119: ( x_return_status IN OUT NOCOPY VARCHAR2
3120: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3121: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3122: , p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3123: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3124: )
3125: IS

Line 3122: , p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type

3118: PROCEDURE Bom_Component_VID
3119: ( x_return_status IN OUT NOCOPY VARCHAR2
3120: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3121: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3122: , p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3123: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3124: )
3125: IS
3126: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;

Line 3123: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

3119: ( x_return_status IN OUT NOCOPY VARCHAR2
3120: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3121: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3122: , p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3123: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3124: )
3125: IS
3126: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3127: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

Line 3126: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;

3122: , p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type
3123: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3124: )
3125: IS
3126: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3127: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
3128: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
3129: BEGIN
3130:

Line 3127: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;

3123: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
3124: )
3125: IS
3126: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3127: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
3128: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
3129: BEGIN
3130:
3131: --

Line 3128: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;

3124: )
3125: IS
3126: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
3127: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
3128: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
3129: BEGIN
3130:
3131: --
3132: -- Convert the BOM Record to ECO

Line 3134: Bom_Bo_Pub.Convert_BomComp_To_EcoComp

3130:
3131: --
3132: -- Convert the BOM Record to ECO
3133: --
3134: Bom_Bo_Pub.Convert_BomComp_To_EcoComp
3135: ( p_bom_component_rec => p_bom_component_rec
3136: , p_bom_comp_unexp_rec => p_bom_comp_unexp_rec
3137: , x_rev_component_rec => l_rev_component_rec
3138: , x_rev_comp_unexp_rec => l_rev_comp_unexp_rec

Line 3152: Bom_Bo_Pub.Convert_EcoComp_To_BomComp

3148:
3149: --
3150: -- Convert the Eco Component back to BOM
3151: --
3152: Bom_Bo_Pub.Convert_EcoComp_To_BomComp
3153: ( p_rev_component_rec => l_rev_component_rec
3154: , p_rev_comp_unexp_rec => l_rev_comp_unexp_rec
3155: , x_bom_component_rec => l_bom_component_rec
3156: , x_bom_comp_unexp_rec => x_bom_comp_unexp_rec

Line 3162: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

3158:
3159: END Bom_Component_VID;
3160:
3161: PROCEDURE Sub_Component_UUI_To_UI
3162: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
3163: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3164: , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3165: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3166: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 3163: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

3159: END Bom_Component_VID;
3160:
3161: PROCEDURE Sub_Component_UUI_To_UI
3162: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
3163: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3164: , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3165: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3166: , x_Return_Status IN OUT NOCOPY VARCHAR2
3167: )

Line 3164: , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

3160:
3161: PROCEDURE Sub_Component_UUI_To_UI
3162: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
3163: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3164: , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3165: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3166: , x_Return_Status IN OUT NOCOPY VARCHAR2
3167: )
3168: IS

Line 3169: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

3165: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3166: , x_Return_Status IN OUT NOCOPY VARCHAR2
3167: )
3168: IS
3169: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
3170: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
3171: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
3172: BEGIN
3173: --

Line 3170: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

3166: , x_Return_Status IN OUT NOCOPY VARCHAR2
3167: )
3168: IS
3169: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
3170: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
3171: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
3172: BEGIN
3173: --
3174: -- Convert the BOM Substitute Component to ECO

Line 3171: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

3167: )
3168: IS
3169: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
3170: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
3171: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
3172: BEGIN
3173: --
3174: -- Convert the BOM Substitute Component to ECO
3175: --

Line 3177: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

3173: --
3174: -- Convert the BOM Substitute Component to ECO
3175: --
3176:
3177: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
3178: ( p_bom_sub_component_rec => p_bom_sub_component_rec
3179: , p_bom_sub_comp_unexp_rec => p_bom_sub_comp_unexp_rec
3180: , x_sub_component_rec => l_sub_component_rec
3181: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec

Line 3196: Bom_Bo_Pub.Convert_EcoSComp_to_BomSComp

3192: );
3193:
3194: -- Convert the ECO Record back to BOM
3195:
3196: Bom_Bo_Pub.Convert_EcoSComp_to_BomSComp
3197: ( p_sub_component_rec => l_sub_component_rec
3198: , p_sub_comp_unexp_rec => l_sub_comp_unexp_rec
3199: , x_bom_sub_component_rec => l_bom_sub_component_rec
3200: , x_bom_sub_comp_unexp_rec => x_bom_sub_comp_unexp_rec

Line 3206: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

3202:
3203: END Sub_Component_UUI_To_UI;
3204:
3205: PROCEDURE Sub_Component_UUI_To_UI2
3206: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
3207: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3208: , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3209: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3210: , x_other_message IN OUT NOCOPY VARCHAR2

Line 3207: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

3203: END Sub_Component_UUI_To_UI;
3204:
3205: PROCEDURE Sub_Component_UUI_To_UI2
3206: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
3207: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3208: , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3209: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3210: , x_other_message IN OUT NOCOPY VARCHAR2
3211: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type

Line 3208: , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

3204:
3205: PROCEDURE Sub_Component_UUI_To_UI2
3206: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
3207: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3208: , x_bom_sub_Comp_unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
3209: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3210: , x_other_message IN OUT NOCOPY VARCHAR2
3211: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
3212: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 3215: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

3211: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
3212: , x_Return_Status IN OUT NOCOPY VARCHAR2
3213: )
3214: IS
3215: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
3216: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
3217: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
3218: BEGIN
3219: --

Line 3216: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

3212: , x_Return_Status IN OUT NOCOPY VARCHAR2
3213: )
3214: IS
3215: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
3216: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
3217: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
3218: BEGIN
3219: --
3220: -- Convert the BOM Substitute Component to ECO

Line 3217: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

3213: )
3214: IS
3215: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
3216: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
3217: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
3218: BEGIN
3219: --
3220: -- Convert the BOM Substitute Component to ECO
3221: --

Line 3223: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

3219: --
3220: -- Convert the BOM Substitute Component to ECO
3221: --
3222:
3223: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
3224: ( p_bom_sub_component_rec => p_bom_sub_component_rec
3225: , p_bom_sub_comp_unexp_rec => p_bom_sub_comp_unexp_rec
3226: , x_sub_component_rec => l_sub_component_rec
3227: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec

Line 3244: Bom_Bo_Pub.Convert_EcoSComp_to_BomSComp

3240: );
3241:
3242: -- Convert the ECO Record back to BOM
3243:
3244: Bom_Bo_Pub.Convert_EcoSComp_to_BomSComp
3245: ( p_sub_component_rec => l_sub_component_rec
3246: , p_sub_comp_unexp_rec => l_sub_comp_unexp_rec
3247: , x_bom_sub_component_rec => l_bom_sub_component_rec
3248: , x_bom_sub_comp_unexp_rec => x_bom_sub_comp_unexp_rec

Line 3255: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

3251: END Sub_Component_UUI_To_UI2;
3252:
3253:
3254: PROCEDURE Ref_Designator_UUI_To_UI
3255: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
3256: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3257: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3258: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3259: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 3256: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

3252:
3253:
3254: PROCEDURE Ref_Designator_UUI_To_UI
3255: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
3256: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3257: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3258: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3259: , x_Return_Status IN OUT NOCOPY VARCHAR2
3260: )

Line 3257: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

3253:
3254: PROCEDURE Ref_Designator_UUI_To_UI
3255: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
3256: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3257: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3258: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3259: , x_Return_Status IN OUT NOCOPY VARCHAR2
3260: )
3261: IS

Line 3262: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;

3258: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3259: , x_Return_Status IN OUT NOCOPY VARCHAR2
3260: )
3261: IS
3262: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
3263: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
3264: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
3265: BEGIN
3266: --

Line 3263: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

3259: , x_Return_Status IN OUT NOCOPY VARCHAR2
3260: )
3261: IS
3262: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
3263: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
3264: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
3265: BEGIN
3266: --
3267: -- Convert the BOM reference designator record to ECO

Line 3264: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;

3260: )
3261: IS
3262: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
3263: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
3264: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
3265: BEGIN
3266: --
3267: -- Convert the BOM reference designator record to ECO
3268: --

Line 3269: Bom_Bo_Pub.Convert_BomDesg_To_EcoDesg

3265: BEGIN
3266: --
3267: -- Convert the BOM reference designator record to ECO
3268: --
3269: Bom_Bo_Pub.Convert_BomDesg_To_EcoDesg
3270: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
3271: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
3272: , x_ref_designator_rec => l_ref_designator_rec
3273: , x_ref_desg_unexp_rec => l_ref_desg_unexp_rec

Line 3288: Bom_Bo_Pub.Convert_EcoDesg_To_BomDesg

3284: );
3285:
3286: -- Convert the ECO Reference Designator back to BOM
3287:
3288: Bom_Bo_Pub.Convert_EcoDesg_To_BomDesg
3289: ( p_ref_designator_rec => l_ref_designator_rec
3290: , p_ref_desg_unexp_rec => l_ref_desg_unexp_rec
3291: , x_bom_ref_designator_rec => l_bom_ref_designator_rec
3292: , x_bom_ref_desg_unexp_rec => x_bom_ref_desg_unexp_rec

Line 3298: ( p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

3294:
3295: END Ref_Designator_UUI_To_UI;
3296:
3297: PROCEDURE Ref_Designator_UUI_To_UI2
3298: ( p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
3299: , p_Bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3300: , x_Bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3301: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3302: , x_other_message IN OUT NOCOPY VARCHAR2

Line 3299: , p_Bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

3295: END Ref_Designator_UUI_To_UI;
3296:
3297: PROCEDURE Ref_Designator_UUI_To_UI2
3298: ( p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
3299: , p_Bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3300: , x_Bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3301: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3302: , x_other_message IN OUT NOCOPY VARCHAR2
3303: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type

Line 3300: , x_Bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

3296:
3297: PROCEDURE Ref_Designator_UUI_To_UI2
3298: ( p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
3299: , p_Bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3300: , x_Bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
3301: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3302: , x_other_message IN OUT NOCOPY VARCHAR2
3303: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
3304: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 3307: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;

3303: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
3304: , x_Return_Status IN OUT NOCOPY VARCHAR2
3305: )
3306: IS
3307: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
3308: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
3309: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
3310: BEGIN
3311: --

Line 3308: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

3304: , x_Return_Status IN OUT NOCOPY VARCHAR2
3305: )
3306: IS
3307: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
3308: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
3309: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
3310: BEGIN
3311: --
3312: -- Convert the BOM reference designator record to ECO

Line 3309: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;

3305: )
3306: IS
3307: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
3308: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
3309: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
3310: BEGIN
3311: --
3312: -- Convert the BOM reference designator record to ECO
3313: --

Line 3314: Bom_Bo_Pub.Convert_BomDesg_To_EcoDesg

3310: BEGIN
3311: --
3312: -- Convert the BOM reference designator record to ECO
3313: --
3314: Bom_Bo_Pub.Convert_BomDesg_To_EcoDesg
3315: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
3316: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
3317: , x_ref_designator_rec => l_ref_designator_rec
3318: , x_ref_desg_unexp_rec => l_ref_desg_unexp_rec

Line 3335: Bom_Bo_Pub.Convert_EcoDesg_To_BomDesg

3331: );
3332:
3333: -- Convert the ECO Reference Designator back to BOM
3334:
3335: Bom_Bo_Pub.Convert_EcoDesg_To_BomDesg
3336: ( p_ref_designator_rec => l_ref_designator_rec
3337: , p_ref_desg_unexp_rec => l_ref_desg_unexp_rec
3338: , x_bom_ref_designator_rec => l_bom_ref_designator_rec
3339: , x_bom_ref_desg_unexp_rec => x_bom_ref_desg_unexp_rec

Line 3356: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type

3352: * Purpose : This procedure will convert user unique idx columns
3353: * into unique id columns.
3354: ********************************************************************/
3355: PROCEDURE Bom_Comp_Operation_UUI_To_UI
3356: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
3357: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3358: , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3359: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3360: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 3357: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type

3353: * into unique id columns.
3354: ********************************************************************/
3355: PROCEDURE Bom_Comp_Operation_UUI_To_UI
3356: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
3357: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3358: , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3359: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3360: , x_Return_Status IN OUT NOCOPY VARCHAR2
3361: )

Line 3358: , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type

3354: ********************************************************************/
3355: PROCEDURE Bom_Comp_Operation_UUI_To_UI
3356: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
3357: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3358: , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3359: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3360: , x_Return_Status IN OUT NOCOPY VARCHAR2
3361: )
3362: IS

Line 3363: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;

3359: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3360: , x_Return_Status IN OUT NOCOPY VARCHAR2
3361: )
3362: IS
3363: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
3364: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3365: l_Err_Text VARCHAR2(2000);
3366: l_Return_Status VARCHAR2(1);
3367: l_token_tbl Error_Handler.Token_Tbl_Type;

Line 3484: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type

3480: * program can decide on the scope of the error if the
3481: * conversion in this procedure fails.
3482: ******************************************************************/
3483: PROCEDURE Bom_Comp_Operation_UUI_To_UI2
3484: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
3485: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3486: , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3487: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3488: , x_other_message IN OUT NOCOPY VARCHAR2

Line 3485: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type

3481: * conversion in this procedure fails.
3482: ******************************************************************/
3483: PROCEDURE Bom_Comp_Operation_UUI_To_UI2
3484: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
3485: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3486: , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3487: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3488: , x_other_message IN OUT NOCOPY VARCHAR2
3489: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type

Line 3486: , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type

3482: ******************************************************************/
3483: PROCEDURE Bom_Comp_Operation_UUI_To_UI2
3484: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
3485: , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3486: , x_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
3487: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3488: , x_other_message IN OUT NOCOPY VARCHAR2
3489: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
3490: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 3493: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type :=

3489: , x_other_token_tbl IN OUT NOCOPY Error_Handler.Token_Tbl_Type
3490: , x_Return_Status IN OUT NOCOPY VARCHAR2
3491: )
3492: IS
3493: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type :=
3494: p_bom_comp_ops_unexp_rec;
3495: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3496: l_Err_Text VARCHAR2(2000);
3497: l_Return_Status VARCHAR2(1);