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.EAM_ACTIVITY_PUB dependencies on INV_ITEM_GRP

Line 131: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

127: END;
128:
129: -- ----------------------------------------------------------------------
130: PROCEDURE Create_Activity_Routing(
131: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
132: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
133: p_operation_copy_option IN NUMBER,
134: p_resource_copy_option IN NUMBER,
135:

Line 490: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

486: END;
487:
488: -- ----------------------------------------------------------------------
489: PROCEDURE Create_Activity_BOM(
490: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
491: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
492: p_material_copy_option IN NUMBER,
493:
494: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,

Line 673: ( p_item_error_tbl IN INV_Item_GRP.Error_Tbl_Type ,

669:
670: END;
671: -- ================================================================================
672: PROCEDURE Get_Errors
673: ( p_item_error_tbl IN INV_Item_GRP.Error_Tbl_Type ,
674: x_error_msg_old IN VARCHAR2,
675: x_error_msg_new OUT NOCOPY VARCHAR2
676: )
677: IS

Line 694: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

690: -- ================================================================================
691:
692: -- ----------------------------------------------------------------------
693: PROCEDURE Create_Item(
694: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
695: p_template_id IN NUMBER := NULL,
696: p_template_name IN VARCHAR2 := NULL,
697:
698: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

Line 698: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

694: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
695: p_template_id IN NUMBER := NULL,
696: p_template_name IN VARCHAR2 := NULL,
697:
698: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
699: x_curr_item_return_status OUT NOCOPY VARCHAR2,
700: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
701:
702: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

Line 700: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

696: p_template_name IN VARCHAR2 := NULL,
697:
698: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
699: x_curr_item_return_status OUT NOCOPY VARCHAR2,
700: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
701:
702: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
703: x_master_item_return_status OUT NOCOPY VARCHAR2,
704: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type

Line 702: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

698: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
699: x_curr_item_return_status OUT NOCOPY VARCHAR2,
700: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
701:
702: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
703: x_master_item_return_status OUT NOCOPY VARCHAR2,
704: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
705: )
706: IS

Line 704: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type

700: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
701:
702: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
703: x_master_item_return_status OUT NOCOPY VARCHAR2,
704: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
705: )
706: IS
707: l_master_organization_id NUMBER;
708: l_curr_organization_id NUMBER;

Line 709: l_item_rec INV_Item_GRP.Item_rec_type;

705: )
706: IS
707: l_master_organization_id NUMBER;
708: l_curr_organization_id NUMBER;
709: l_item_rec INV_Item_GRP.Item_rec_type;
710: l_validate_org_ret_sts VARCHAR2(1);
711:
712: l_temp_org_id NUMBER;
713: l_temp_org_code VARCHAR2(3);

Line 715: -- local variables for calling INV_Item_GRP package

711:
712: l_temp_org_id NUMBER;
713: l_temp_org_code VARCHAR2(3);
714:
715: -- local variables for calling INV_Item_GRP package
716:
717: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
718: l_x_curr_item_return_status VARCHAR2(1);
719: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 717: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

713: l_temp_org_code VARCHAR2(3);
714:
715: -- local variables for calling INV_Item_GRP package
716:
717: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
718: l_x_curr_item_return_status VARCHAR2(1);
719: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
720:
721: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 719: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

715: -- local variables for calling INV_Item_GRP package
716:
717: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
718: l_x_curr_item_return_status VARCHAR2(1);
719: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
720:
721: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
722: l_x_master_item_return_status VARCHAR2(1);
723: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 721: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

717: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
718: l_x_curr_item_return_status VARCHAR2(1);
719: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
720:
721: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
722: l_x_master_item_return_status VARCHAR2(1);
723: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
724: l_error_string VARCHAR(2000);
725:

Line 723: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

719: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
720:
721: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
722: l_x_master_item_return_status VARCHAR2(1);
723: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
724: l_error_string VARCHAR(2000);
725:
726: BEGIN
727: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.

Line 727: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.

723: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
724: l_error_string VARCHAR(2000);
725:
726: BEGIN
727: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.
728:
729: -- Copy input activity record to a working record
730: l_item_rec := p_asset_activity;
731:

Line 796: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

792: l_item_rec.organization_id := l_master_organization_id;
793: l_item_rec.organization_code := NULL;
794:
795: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
796: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
797: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
798: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
799: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
800: INV_Item_GRP.Create_Item(

Line 800: INV_Item_GRP.Create_Item(

796: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
797: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
798: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
799: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
800: INV_Item_GRP.Create_Item(
801: p_Item_rec => l_item_rec,
802: p_Template_Id => p_template_id,
803: p_Template_Name => p_template_name,
804: x_Item_rec => l_x_master_item_rec,

Line 815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');

811: x_master_item_error_tbl := l_x_master_item_error_tbl;
812:
813: -- log outputs
814: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
816: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
819: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);

Line 817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');

813: -- log outputs
814: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
816: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
819: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
820:
821: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');

814: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
815: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
816: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
817: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
818: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
819: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
820:
821: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: -- Create Item under master org fail, no use tyring to create it under child org.

Line 855: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

851: END IF;*/
852: /*Bug#3269789 - end*/
853:
854: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
855: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
856: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
857: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
858: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
859: INV_Item_GRP.Create_Item(

Line 859: INV_Item_GRP.Create_Item(

855: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
856: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
857: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
858: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
859: INV_Item_GRP.Create_Item(
860: p_Item_rec => l_item_rec,
861: p_Template_Id => p_template_id,
862: p_Template_Name => p_template_name,
863: x_Item_rec => l_x_curr_item_rec,

Line 874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');

870: x_curr_item_error_tbl := l_x_curr_item_error_tbl;
871:
872: -- log outputs
873: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
875: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);

Line 876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');

872: -- log outputs
873: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
875: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
879:
880: -- ============================================================

Line 877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');

873: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
874: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
875: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
876: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
879:
880: -- ============================================================
881: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');

Line 895: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

891: x_return_status OUT NOCOPY VARCHAR2 ,
892: x_msg_count OUT NOCOPY NUMBER ,
893: x_msg_data OUT NOCOPY VARCHAR2 ,
894:
895: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
896: p_template_id IN NUMBER := NULL,
897: p_template_name IN VARCHAR2 := NULL,
898: p_activity_type_code IN VARCHAR2 := NULL,
899: p_activity_cause_code IN VARCHAR2 := NULL,

Line 912: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

908:
909: -- x_inventory_item_id OUT NUMBER, -- the inventory_item_it the system has created
910: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
911:
912: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
913: x_curr_item_return_status OUT NOCOPY VARCHAR2,
914: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
915: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
916: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 914: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

910: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
911:
912: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
913: x_curr_item_return_status OUT NOCOPY VARCHAR2,
914: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
915: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
916: x_master_item_return_status OUT NOCOPY VARCHAR2,
917: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
918:

Line 915: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

911:
912: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
913: x_curr_item_return_status OUT NOCOPY VARCHAR2,
914: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
915: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
916: x_master_item_return_status OUT NOCOPY VARCHAR2,
917: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
918:
919: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

Line 917: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

913: x_curr_item_return_status OUT NOCOPY VARCHAR2,
914: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
915: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
916: x_master_item_return_status OUT NOCOPY VARCHAR2,
917: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
918:
919: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
920: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
921: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

Line 953: -- local variables for calling INV_Item_GRP package

949: -- local variables for validating source Work Order
950: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
951: l_x_work_order_ret_sts VARCHAR2(1);
952:
953: -- local variables for calling INV_Item_GRP package
954: l_asset_activity INV_Item_GRP.Item_rec_type;
955: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
956: l_x_curr_item_return_status VARCHAR2(1);
957: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 954: l_asset_activity INV_Item_GRP.Item_rec_type;

950: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
951: l_x_work_order_ret_sts VARCHAR2(1);
952:
953: -- local variables for calling INV_Item_GRP package
954: l_asset_activity INV_Item_GRP.Item_rec_type;
955: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
956: l_x_curr_item_return_status VARCHAR2(1);
957: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
958: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 955: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

951: l_x_work_order_ret_sts VARCHAR2(1);
952:
953: -- local variables for calling INV_Item_GRP package
954: l_asset_activity INV_Item_GRP.Item_rec_type;
955: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
956: l_x_curr_item_return_status VARCHAR2(1);
957: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
958: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
959: l_x_master_item_return_status VARCHAR2(1);

Line 957: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

953: -- local variables for calling INV_Item_GRP package
954: l_asset_activity INV_Item_GRP.Item_rec_type;
955: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
956: l_x_curr_item_return_status VARCHAR2(1);
957: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
958: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
959: l_x_master_item_return_status VARCHAR2(1);
960: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
961:

Line 958: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

954: l_asset_activity INV_Item_GRP.Item_rec_type;
955: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
956: l_x_curr_item_return_status VARCHAR2(1);
957: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
958: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
959: l_x_master_item_return_status VARCHAR2(1);
960: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
961:
962: -- local variabels for calling BOM Business Object API

Line 960: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

956: l_x_curr_item_return_status VARCHAR2(1);
957: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
958: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
959: l_x_master_item_return_status VARCHAR2(1);
960: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
961:
962: -- local variabels for calling BOM Business Object API
963: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
964: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

Line 1063: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.

1059: p_association_copy_option
1060: );
1061:
1062: -- ============================================================
1063: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.
1064:
1065: l_asset_activity := p_asset_activity;
1066:
1067: -- Get org id from work order

Line 1337: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

1333: x_msg_count OUT NOCOPY NUMBER ,
1334: x_msg_data OUT NOCOPY VARCHAR2 ,
1335:
1336: -- target activity, need to set org, item name, description
1337: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
1338:
1339:
1340: p_template_id IN NUMBER := NULL,
1341: p_template_name IN VARCHAR2 := NULL,

Line 1362: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

1358: p_bom_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
1359: p_routing_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
1360: p_association_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
1361:
1362: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1363: x_curr_item_return_status OUT NOCOPY VARCHAR2,
1364: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1365: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1366: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 1364: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

1360: p_association_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
1361:
1362: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1363: x_curr_item_return_status OUT NOCOPY VARCHAR2,
1364: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1365: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1366: x_master_item_return_status OUT NOCOPY VARCHAR2,
1367: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1368:

Line 1365: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

1361:
1362: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1363: x_curr_item_return_status OUT NOCOPY VARCHAR2,
1364: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1365: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1366: x_master_item_return_status OUT NOCOPY VARCHAR2,
1367: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1368:
1369: x_assoc_return_status OUT NOCOPY VARCHAR2,

Line 1367: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

1363: x_curr_item_return_status OUT NOCOPY VARCHAR2,
1364: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1365: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1366: x_master_item_return_status OUT NOCOPY VARCHAR2,
1367: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1368:
1369: x_assoc_return_status OUT NOCOPY VARCHAR2,
1370: x_assoc_msg_count OUT NOCOPY NUMBER,
1371: x_assoc_msg_data OUT NOCOPY VARCHAR2,

Line 1386: -- local variables for calling INV_Item_GRP package

1382: -- local variables for validating source Work Order
1383: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1384: l_x_work_order_ret_sts VARCHAR2(1);
1385:
1386: -- local variables for calling INV_Item_GRP package
1387: l_asset_activity INV_Item_GRP.Item_rec_type;
1388: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1389: l_x_curr_item_return_status VARCHAR2(1);
1390: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 1387: l_asset_activity INV_Item_GRP.Item_rec_type;

1383: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1384: l_x_work_order_ret_sts VARCHAR2(1);
1385:
1386: -- local variables for calling INV_Item_GRP package
1387: l_asset_activity INV_Item_GRP.Item_rec_type;
1388: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1389: l_x_curr_item_return_status VARCHAR2(1);
1390: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1391: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 1388: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

1384: l_x_work_order_ret_sts VARCHAR2(1);
1385:
1386: -- local variables for calling INV_Item_GRP package
1387: l_asset_activity INV_Item_GRP.Item_rec_type;
1388: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1389: l_x_curr_item_return_status VARCHAR2(1);
1390: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1391: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
1392: l_x_master_item_return_status VARCHAR2(1);

Line 1390: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

1386: -- local variables for calling INV_Item_GRP package
1387: l_asset_activity INV_Item_GRP.Item_rec_type;
1388: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1389: l_x_curr_item_return_status VARCHAR2(1);
1390: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1391: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
1392: l_x_master_item_return_status VARCHAR2(1);
1393: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
1394:

Line 1391: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

1387: l_asset_activity INV_Item_GRP.Item_rec_type;
1388: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1389: l_x_curr_item_return_status VARCHAR2(1);
1390: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1391: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
1392: l_x_master_item_return_status VARCHAR2(1);
1393: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
1394:
1395: -- local variables for calling copy_bill API

Line 1393: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

1389: l_x_curr_item_return_status VARCHAR2(1);
1390: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1391: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
1392: l_x_master_item_return_status VARCHAR2(1);
1393: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
1394:
1395: -- local variables for calling copy_bill API
1396: l_source_bom_sequence_id NUMBER;
1397: l_target_bom_sequence_id NUMBER;

Line 1495: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.

1491: p_association_copy_option
1492: );
1493:
1494: -- ============================================================
1495: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.
1496:
1497: l_asset_activity := p_asset_activity;
1498:
1499: l_asset_activity.EAM_ACTIVITY_TYPE_CODE := p_activity_type_code;

Line 1937: l_asset_activity INV_Item_GRP.Item_Rec_Type;

1933: l_x_return_status VARCHAR2(1);
1934: l_x_msg_count NUMBER;
1935: l_x_msg_data VARCHAR2(20000);
1936:
1937: l_asset_activity INV_Item_GRP.Item_Rec_Type;
1938: l_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1939: l_x_inventory_item_id NUMBER;
1940: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1941:

Line 1943: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;

1939: l_x_inventory_item_id NUMBER;
1940: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1941:
1942: -- output variables of inv package
1943: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
1944: l_x_curr_item_return_status VARCHAR2(1);
1945: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1946: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1947: l_x_master_item_return_status VARCHAR2(1);

Line 1945: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

1941:
1942: -- output variables of inv package
1943: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
1944: l_x_curr_item_return_status VARCHAR2(1);
1945: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1946: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1947: l_x_master_item_return_status VARCHAR2(1);
1948: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1949: -- output variables of Routing Business Object API

Line 1946: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;

1942: -- output variables of inv package
1943: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
1944: l_x_curr_item_return_status VARCHAR2(1);
1945: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1946: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1947: l_x_master_item_return_status VARCHAR2(1);
1948: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1949: -- output variables of Routing Business Object API
1950: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

Line 1948: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

1944: l_x_curr_item_return_status VARCHAR2(1);
1945: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1946: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1947: l_x_master_item_return_status VARCHAR2(1);
1948: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1949: -- output variables of Routing Business Object API
1950: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1951: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1952: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

Line 2156: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

2152: p_shutdown_type_code IN VARCHAR2 := NULL,
2153: p_notification_req_flag IN VARCHAR2 := NULL,
2154: p_activity_source_code IN VARCHAR2 := NULL,
2155:
2156: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2157: x_curr_item_return_status OUT NOCOPY VARCHAR2,
2158: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
2159: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2160: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 2158: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

2154: p_activity_source_code IN VARCHAR2 := NULL,
2155:
2156: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2157: x_curr_item_return_status OUT NOCOPY VARCHAR2,
2158: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
2159: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2160: x_master_item_return_status OUT NOCOPY VARCHAR2,
2161: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
2162:

Line 2159: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

2155:
2156: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2157: x_curr_item_return_status OUT NOCOPY VARCHAR2,
2158: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
2159: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2160: x_master_item_return_status OUT NOCOPY VARCHAR2,
2161: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
2162:
2163: )

Line 2161: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type

2157: x_curr_item_return_status OUT NOCOPY VARCHAR2,
2158: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
2159: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2160: x_master_item_return_status OUT NOCOPY VARCHAR2,
2161: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
2162:
2163: )
2164: IS
2165:

Line 2166: l_asset_activity INV_Item_GRP.Item_rec_type;

2162:
2163: )
2164: IS
2165:
2166: l_asset_activity INV_Item_GRP.Item_rec_type;
2167:
2168: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2169: l_api_version CONSTANT NUMBER := 1.0;
2170:

Line 2171: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

2167:
2168: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2169: l_api_version CONSTANT NUMBER := 1.0;
2170:
2171: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2172: l_x_curr_item_return_status VARCHAR2(1);
2173: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2174:
2175: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 2173: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

2169: l_api_version CONSTANT NUMBER := 1.0;
2170:
2171: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2172: l_x_curr_item_return_status VARCHAR2(1);
2173: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2174:
2175: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2176: l_x_master_item_return_status VARCHAR2(1);
2177: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 2175: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

2171: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2172: l_x_curr_item_return_status VARCHAR2(1);
2173: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2174:
2175: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2176: l_x_master_item_return_status VARCHAR2(1);
2177: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2178:
2179: BEGIN

Line 2177: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

2173: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2174:
2175: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2176: l_x_master_item_return_status VARCHAR2(1);
2177: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2178:
2179: BEGIN
2180: -- Standard Start of API savepoint
2181: SAVEPOINT Create_Act_With_Templ_PUB;

Line 2226: -- Create Asset Activity. Call INV_Item_GRP package.

2222: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2223: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2224:
2225: -- ============================================================
2226: -- Create Asset Activity. Call INV_Item_GRP package.
2227:
2228: l_asset_activity.organization_id := p_organization_id;
2229: l_asset_activity.organization_code := p_organization_code;
2230:

Line 2379: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

2375:
2376:
2377: -- From Saurabh
2378: procedure create_bom_header(
2379: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2380: --p_source_org_id IN NUMBER,
2381: --p_source_activity_id IN NUMBER, -- inventory_item_id
2382:
2383: --p_material_copy_option IN NUMBER,

Line 2470: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

2466: x_bom_msg_list := l_x_bom_msg_list;
2467: end create_bom_header;
2468:
2469: procedure create_bom_header_form(
2470: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2471: p_inventory_item_name varchar2,
2472: p_organization_code varchar2,
2473: x_return_status OUT NOCOPY VARCHAR2
2474: )is

Line 2475: l_target_item_rec INV_Item_GRP.Item_Rec_Type;

2471: p_inventory_item_name varchar2,
2472: p_organization_code varchar2,
2473: x_return_status OUT NOCOPY VARCHAR2
2474: )is
2475: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2476: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2477: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2478: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2479: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;

Line 2552: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,

2548: p_shutdown_type_code IN VARCHAR2 := NULL,
2549: p_notification_req_flag IN VARCHAR2 := NULL,
2550: p_activity_source_code IN VARCHAR2 := NULL
2551:
2552: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2553: --x_curr_item_return_status OUT VARCHAR2,
2554: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
2555: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2556: --x_master_item_return_status OUT VARCHAR2,

Line 2554: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,

2550: p_activity_source_code IN VARCHAR2 := NULL
2551:
2552: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2553: --x_curr_item_return_status OUT VARCHAR2,
2554: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
2555: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2556: --x_master_item_return_status OUT VARCHAR2,
2557: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
2558: )is

Line 2555: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,

2551:
2552: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2553: --x_curr_item_return_status OUT VARCHAR2,
2554: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
2555: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2556: --x_master_item_return_status OUT VARCHAR2,
2557: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
2558: )is
2559: l_asset_activity INV_Item_GRP.Item_rec_type;

Line 2557: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type

2553: --x_curr_item_return_status OUT VARCHAR2,
2554: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
2555: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2556: --x_master_item_return_status OUT VARCHAR2,
2557: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
2558: )is
2559: l_asset_activity INV_Item_GRP.Item_rec_type;
2560:
2561: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';

Line 2559: l_asset_activity INV_Item_GRP.Item_rec_type;

2555: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2556: --x_master_item_return_status OUT VARCHAR2,
2557: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
2558: )is
2559: l_asset_activity INV_Item_GRP.Item_rec_type;
2560:
2561: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2562: l_api_version CONSTANT NUMBER := 1.0;
2563: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;

Line 2567: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

2563: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;
2564: l_commit CONSTANT VARCHAR2(1) := FND_API.G_TRUE ;
2565: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2566:
2567: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2568: l_x_curr_item_return_status VARCHAR2(1);
2569: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2570:
2571: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 2569: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

2565: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2566:
2567: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2568: l_x_curr_item_return_status VARCHAR2(1);
2569: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2570:
2571: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2572: l_x_master_item_return_status VARCHAR2(1);
2573: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 2571: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

2567: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2568: l_x_curr_item_return_status VARCHAR2(1);
2569: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2570:
2571: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2572: l_x_master_item_return_status VARCHAR2(1);
2573: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2574: l_msg_count number;
2575: l_msg_data varchar2(20000);

Line 2573: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

2569: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2570:
2571: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2572: l_x_master_item_return_status VARCHAR2(1);
2573: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2574: l_msg_count number;
2575: l_msg_data varchar2(20000);
2576: begin
2577:

Line 2646: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

2642:
2643: end create_activity_with_template;
2644:
2645: PROCEDURE Create_Routing_Header(
2646: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2647:
2648: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2649: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2650: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

Line 2726: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

2722:
2723: END Create_Routing_Header;
2724:
2725: procedure create_routing_header_form(
2726: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2727: p_inventory_item_name varchar2,
2728: p_organization_code varchar2,
2729: x_return_status OUT NOCOPY VARCHAR2
2730: )is

Line 2749: l_target_item_rec INV_Item_GRP.Item_Rec_Type;

2745: l_x_rtg_return_status VARCHAR2(1);
2746: l_x_rtg_msg_count NUMBER;
2747: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2748:
2749: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2750:
2751: begin
2752: l_target_item_rec.item_number := p_inventory_item_name;
2753: l_target_item_rec.organization_code := p_organization_code;

Line 2830: l_asset_activity INV_Item_GRP.Item_Rec_Type;

2826: p_association_copy_option IN NUMBER := 2 -- 1 (NONE) or 2 (ALL)
2827:
2828: )
2829: is
2830: l_asset_activity INV_Item_GRP.Item_Rec_Type;
2831: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
2832: l_x_curr_item_return_status VARCHAR2(1);
2833: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2834: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;

Line 2831: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;

2827:
2828: )
2829: is
2830: l_asset_activity INV_Item_GRP.Item_Rec_Type;
2831: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
2832: l_x_curr_item_return_status VARCHAR2(1);
2833: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2834: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
2835: l_x_master_item_return_status VARCHAR2(1);

Line 2833: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

2829: is
2830: l_asset_activity INV_Item_GRP.Item_Rec_Type;
2831: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
2832: l_x_curr_item_return_status VARCHAR2(1);
2833: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2834: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
2835: l_x_master_item_return_status VARCHAR2(1);
2836: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2837:

Line 2834: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;

2830: l_asset_activity INV_Item_GRP.Item_Rec_Type;
2831: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
2832: l_x_curr_item_return_status VARCHAR2(1);
2833: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2834: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
2835: l_x_master_item_return_status VARCHAR2(1);
2836: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2837:
2838: l_x_assoc_return_status VARCHAR2(1);

Line 2836: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

2832: l_x_curr_item_return_status VARCHAR2(1);
2833: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2834: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
2835: l_x_master_item_return_status VARCHAR2(1);
2836: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2837:
2838: l_x_assoc_return_status VARCHAR2(1);
2839: l_x_assoc_msg_count NUMBER;
2840: l_x_assoc_msg_data VARCHAR2(20000);

Line 2967: l_item_rec INV_Item_GRP.Item_rec_type;

2963: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2964:
2965:
2966: l_master_organization_id NUMBER;
2967: l_item_rec INV_Item_GRP.Item_rec_type;
2968:
2969: -- local variables for calling INV_Item_GRP package
2970:
2971: l_x_item_rec INV_Item_GRP.Item_rec_type;

Line 2969: -- local variables for calling INV_Item_GRP package

2965:
2966: l_master_organization_id NUMBER;
2967: l_item_rec INV_Item_GRP.Item_rec_type;
2968:
2969: -- local variables for calling INV_Item_GRP package
2970:
2971: l_x_item_rec INV_Item_GRP.Item_rec_type;
2972: l_x_return_status VARCHAR2(1);
2973: l_x_error_tbl INV_Item_GRP.Error_tbl_type;

Line 2971: l_x_item_rec INV_Item_GRP.Item_rec_type;

2967: l_item_rec INV_Item_GRP.Item_rec_type;
2968:
2969: -- local variables for calling INV_Item_GRP package
2970:
2971: l_x_item_rec INV_Item_GRP.Item_rec_type;
2972: l_x_return_status VARCHAR2(1);
2973: l_x_error_tbl INV_Item_GRP.Error_tbl_type;
2974: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2975: l_x_master_item_return_status VARCHAR2(1);

Line 2973: l_x_error_tbl INV_Item_GRP.Error_tbl_type;

2969: -- local variables for calling INV_Item_GRP package
2970:
2971: l_x_item_rec INV_Item_GRP.Item_rec_type;
2972: l_x_return_status VARCHAR2(1);
2973: l_x_error_tbl INV_Item_GRP.Error_tbl_type;
2974: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2975: l_x_master_item_return_status VARCHAR2(1);
2976: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2977: l_error_string VARCHAR2(2000);

Line 2974: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

2970:
2971: l_x_item_rec INV_Item_GRP.Item_rec_type;
2972: l_x_return_status VARCHAR2(1);
2973: l_x_error_tbl INV_Item_GRP.Error_tbl_type;
2974: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2975: l_x_master_item_return_status VARCHAR2(1);
2976: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2977: l_error_string VARCHAR2(2000);
2978: l_msg_string VARCHAR2(200);

Line 2976: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

2972: l_x_return_status VARCHAR2(1);
2973: l_x_error_tbl INV_Item_GRP.Error_tbl_type;
2974: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2975: l_x_master_item_return_status VARCHAR2(1);
2976: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2977: l_error_string VARCHAR2(2000);
2978: l_msg_string VARCHAR2(200);
2979:
2980:

Line 3065: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

3061: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR THEN
3062: l_item_rec.bom_enabled_flag := 'Y';
3063: END IF;
3064:
3065: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3066: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3067:
3068:
3069: INV_Item_GRP.Create_Item

Line 3069: INV_Item_GRP.Create_Item

3065: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3066: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3067:
3068:
3069: INV_Item_GRP.Create_Item
3070: (
3071: p_Item_rec => l_item_rec,
3072: p_Template_Id => 19,
3073: p_Template_Name => null,

Line 3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');

3083: );
3084:
3085: -- log outputs
3086: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3088: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3091: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);

Line 3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');

3085: -- log outputs
3086: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3088: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3091: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3092:
3093: EXCEPTION

Line 3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');

3086: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3087: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3088: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3089: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3090: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3091: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3092:
3093: EXCEPTION
3094: WHEN NO_DATA_FOUND THEN

Line 3116: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

3112: AND ROWNUM = 1;
3113:
3114: l_item_rec.organization_id := p_org_id;
3115: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
3116: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3117: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3118:
3119: Create_Item(
3120: p_asset_activity => l_item_rec,