DBA Data[Home] [Help]

APPS.ENG_REV_COMPONENT_UTIL dependencies on BOM_GLOBALS

Line 228: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id

224: NULL,p_rev_component_rec.operation_sequence_number,
225: p_rev_component_Rec.new_operation_sequence_number
226: )
227: , LAST_UPDATE_DATE = SYSDATE
228: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
229: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
230: , ITEM_NUM = p_rev_component_rec.item_sequence_number
231: , COMPONENT_QUANTITY = p_rev_component_rec.quantity_per_assembly
232: , COMPONENT_YIELD_FACTOR = p_rev_component_rec.projected_yield

Line 229: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id

225: p_rev_component_Rec.new_operation_sequence_number
226: )
227: , LAST_UPDATE_DATE = SYSDATE
228: , LAST_UPDATED_BY = Bom_Globals.Get_User_Id
229: , LAST_UPDATE_LOGIN = Bom_Globals.Get_User_Id
230: , ITEM_NUM = p_rev_component_rec.item_sequence_number
231: , COMPONENT_QUANTITY = p_rev_component_rec.quantity_per_assembly
232: , COMPONENT_YIELD_FACTOR = p_rev_component_rec.projected_yield
233: , COMPONENT_REMARKS = p_rev_component_rec.comments

Line 264: , PROGRAM_ID = Bom_Globals.Get_Prog_Id

260: , INCLUDE_ON_SHIP_DOCS = p_rev_component_rec.include_on_ship_docs
261: , LOW_QUANTITY = p_rev_component_rec.minimum_allowed_quantity
262: , ACD_TYPE = p_rev_component_rec.acd_type
263: , PROGRAM_UPDATE_DATE = SYSDATE
264: , PROGRAM_ID = Bom_Globals.Get_Prog_Id
265: , Original_System_Reference =
266: p_rev_component_rec.original_system_reference
267: , From_End_Item_Unit_Number =
268: p_rev_component_rec.from_end_item_unit_number

Line 393: , Bom_Globals.Get_Prog_AppId

389: , NULL /* Cost Factor */
390: , p_rev_component_rec.required_for_revenue
391: , p_rev_component_rec.maximum_allowed_quantity
392: , p_rev_comp_Unexp_rec.component_sequence_id
393: , Bom_Globals.Get_Prog_AppId
394: , p_rev_component_rec.wip_supply_type
395: , DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,
396: NULL, p_rev_comp_Unexp_rec.supply_locator_id)
397: , p_rev_comp_Unexp_rec.bom_item_type

Line 401: , Bom_Globals.Get_User_Id /* Last Updated By */

397: , p_rev_comp_Unexp_rec.bom_item_type
398: , p_rev_component_rec.operation_sequence_number
399: , p_rev_comp_Unexp_rec.component_item_id
400: , SYSDATE /* Last Update Date */
401: , Bom_Globals.Get_User_Id /* Last Updated By */
402: , SYSDATE /* Creation Date */
403: , Bom_Globals.Get_User_Id /* Created By */
404: , Bom_Globals.Get_User_Id /* Last Update Login */
405: , p_rev_component_rec.item_sequence_number

Line 403: , Bom_Globals.Get_User_Id /* Created By */

399: , p_rev_comp_Unexp_rec.component_item_id
400: , SYSDATE /* Last Update Date */
401: , Bom_Globals.Get_User_Id /* Last Updated By */
402: , SYSDATE /* Creation Date */
403: , Bom_Globals.Get_User_Id /* Created By */
404: , Bom_Globals.Get_User_Id /* Last Update Login */
405: , p_rev_component_rec.item_sequence_number
406: , p_rev_component_rec.quantity_per_assembly
407: , p_rev_component_rec.projected_yield

Line 404: , Bom_Globals.Get_User_Id /* Last Update Login */

400: , SYSDATE /* Last Update Date */
401: , Bom_Globals.Get_User_Id /* Last Updated By */
402: , SYSDATE /* Creation Date */
403: , Bom_Globals.Get_User_Id /* Created By */
404: , Bom_Globals.Get_User_Id /* Last Update Login */
405: , p_rev_component_rec.item_sequence_number
406: , p_rev_component_rec.quantity_per_assembly
407: , p_rev_component_rec.projected_yield
408: , p_rev_component_rec.comments

Line 445: , Bom_Globals.Get_Prog_Id

441: , p_rev_component_rec.acd_type
442: , p_rev_comp_Unexp_rec.old_component_sequence_id
443: , p_rev_comp_Unexp_rec.bill_sequence_id
444: , NULL /* Request Id */
445: , Bom_Globals.Get_Prog_Id
446: , SYSDATE /* program_update_date */
447: , p_rev_comp_Unexp_rec.pick_components
448: , p_rev_component_rec.original_system_reference
449: , p_rev_component_rec.from_end_item_unit_number

Line 675: x_Return_Status := Bom_Globals.G_RECORD_FOUND;

671: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR) =
672: NVL(p_from_end_item_number, FND_API.G_MISS_CHAR);
673: --dbms_output.put_line('Finished querying and assigning component record . . .');
674:
675: x_Return_Status := Bom_Globals.G_RECORD_FOUND;
676: x_Rev_Component_Rec := l_rev_component_rec;
677: x_Rev_Comp_Unexp_Rec := l_Rev_Comp_Unexp_Rec;
678:
679: EXCEPTION

Line 682: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;

678:
679: EXCEPTION
680:
681: WHEN NO_DATA_FOUND THEN
682: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
683: x_rev_component_rec := l_rev_component_rec;
684: x_Rev_Comp_Unexp_Rec := l_Rev_Comp_Unexp_Rec;
685:
686: WHEN OTHERS THEN

Line 745: IF l_Rev_Component_Rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE THEN

741: l_rev_component_rec := p_rev_component_rec;
742: l_rev_comp_unexp_rec := p_rev_comp_unexp_rec;
743: l_return_status := FND_API.G_RET_STS_SUCCESS;
744:
745: IF l_Rev_Component_Rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE THEN
746:
747: --dbms_output.put_line('Test Harness: Executing Insert Row. . . ');
748:
749: FOR CheckBillExists IN c_CheckBillExists LOOP

Line 783: , p_last_updated_by => Bom_Globals.Get_User_Id

779: , p_common_bill_sequence_id =>
780: l_rev_comp_unexp_rec.bill_sequence_id
781: , p_assembly_type => l_assembly_type
782: , p_last_update_date => SYSDATE
783: , p_last_updated_by => Bom_Globals.Get_User_Id
784: , p_creation_date => SYSDATE
785: , p_created_by => Bom_Globals.Get_User_Id
786: , p_revised_item_seq_id =>
787: l_rev_comp_unexp_rec.revised_item_sequence_id

Line 785: , p_created_by => Bom_Globals.Get_User_Id

781: , p_assembly_type => l_assembly_type
782: , p_last_update_date => SYSDATE
783: , p_last_updated_by => Bom_Globals.Get_User_Id
784: , p_creation_date => SYSDATE
785: , p_created_by => Bom_Globals.Get_User_Id
786: , p_revised_item_seq_id =>
787: l_rev_comp_unexp_rec.revised_item_sequence_id
788: , p_original_system_reference =>
789: l_rev_component_rec.original_system_reference);

Line 798: ELSIF l_Rev_Component_Rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

794: , p_Rev_Comp_Unexp_Rec => l_Rev_Comp_Unexp_Rec
795: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
796: , x_return_status => l_Return_Status
797: );
798: ELSIF l_Rev_Component_Rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
799: THEN
800:
801: --dbms_output.put_line('Test Harness: Executing Update Row. . . ');
802:

Line 809: ELSIF l_Rev_Component_Rec.Transaction_Type = Bom_GLOBALS.G_OPR_DELETE

805: , p_Rev_Comp_Unexp_Rec => l_Rev_Comp_Unexp_Rec
806: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
807: , x_return_status => l_Return_Status
808: );
809: ELSIF l_Rev_Component_Rec.Transaction_Type = Bom_GLOBALS.G_OPR_DELETE
810: THEN
811:
812: --dbms_output.put_line('Test Harness: Executing Delete Row. . . ');
813:

Line 820: ELSIF l_Rev_Component_Rec.Transaction_Type = Bom_GLOBALS.G_OPR_CANCEL

816: l_Rev_Comp_Unexp_Rec.Component_Sequence_Id
817: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
818: , x_return_status => l_Return_Status
819: );
820: ELSIF l_Rev_Component_Rec.Transaction_Type = Bom_GLOBALS.G_OPR_CANCEL
821: THEN
822: --dbms_output.put_line('Perform Cancel Component . . .');
823:
824: --

Line 855: Bom_Globals.Get_User_ID

851: l_comp_seq_id
852: , p_cancel_comments =>
853: l_rev_component_rec.cancel_comments
854: , p_user_id =>
855: Bom_Globals.Get_User_ID
856: , p_login_id =>
857: Bom_Globals.Get_Login_ID
858: );
859:

Line 857: Bom_Globals.Get_Login_ID

853: l_rev_component_rec.cancel_comments
854: , p_user_id =>
855: Bom_Globals.Get_User_ID
856: , p_login_id =>
857: Bom_Globals.Get_Login_ID
858: );
859:
860: END IF;
861: