DBA Data[Home] [Help]

APPS.BOM_SUB_COMPONENT_UTIL dependencies on BOM_GLOBALS

Line 236: , LAST_UPDATED_BY = BOM_Globals.Get_User_Id

232: , Original_system_Reference =
233: p_sub_component_rec.original_system_reference
234: , Enforce_Int_Requirements = p_sub_comp_unexp_rec.Enforce_Int_Requirements_Code
235: , LAST_UPDATE_DATE = SYSDATE
236: , LAST_UPDATED_BY = BOM_Globals.Get_User_Id
237: , LAST_UPDATE_LOGIN = BOM_Globals.Get_Login_Id
238: , REQUEST_ID = Fnd_Global.Conc_Request_Id
239: , PROGRAM_ID = Fnd_Global.Conc_Program_Id
240: , PROGRAM_APPLICATION_ID = Fnd_Global.Prog_Appl_Id

Line 237: , LAST_UPDATE_LOGIN = BOM_Globals.Get_Login_Id

233: p_sub_component_rec.original_system_reference
234: , Enforce_Int_Requirements = p_sub_comp_unexp_rec.Enforce_Int_Requirements_Code
235: , LAST_UPDATE_DATE = SYSDATE
236: , LAST_UPDATED_BY = BOM_Globals.Get_User_Id
237: , LAST_UPDATE_LOGIN = BOM_Globals.Get_Login_Id
238: , REQUEST_ID = Fnd_Global.Conc_Request_Id
239: , PROGRAM_ID = Fnd_Global.Conc_Program_Id
240: , PROGRAM_APPLICATION_ID = Fnd_Global.Prog_Appl_Id
241: , PROGRAM_UPDATE_DATE = SYSDATE

Line 349: IF Bom_Globals.Get_Caller_Type = 'MIGRATION' THEN

345: BEGIN
346:
347: Error_Handler.Write_Debug ('Inserting SCOMP Perform Writes ...');
348: --Bug 7712832 changes start
349: IF Bom_Globals.Get_Caller_Type = 'MIGRATION' THEN
350: l_src_comp_seq_id := Common_CompSeqIdSC( p_comp_seq_id => p_sub_comp_Unexp_rec.component_sequence_id
351: );
352: END IF;
353: --Bug 7712832 changes end

Line 393: , Bom_globals.Get_User_Id

389: )
390: VALUES
391: ( p_sub_comp_unexp_rec.substitute_component_id
392: , SYSDATE
393: , Bom_globals.Get_User_Id
394: , SYSDATE
395: , Bom_Globals.Get_User_Id
396: , Bom_Globals.Get_User_Id
397: , p_sub_component_rec.substitute_item_quantity

Line 395: , Bom_Globals.Get_User_Id

391: ( p_sub_comp_unexp_rec.substitute_component_id
392: , SYSDATE
393: , Bom_globals.Get_User_Id
394: , SYSDATE
395: , Bom_Globals.Get_User_Id
396: , Bom_Globals.Get_User_Id
397: , p_sub_component_rec.substitute_item_quantity
398: , p_sub_comp_Unexp_rec.component_sequence_id
399: , p_sub_component_rec.acd_type

Line 396: , Bom_Globals.Get_User_Id

392: , SYSDATE
393: , Bom_globals.Get_User_Id
394: , SYSDATE
395: , Bom_Globals.Get_User_Id
396: , Bom_Globals.Get_User_Id
397: , p_sub_component_rec.substitute_item_quantity
398: , p_sub_comp_Unexp_rec.component_sequence_id
399: , p_sub_component_rec.acd_type
400: , p_sub_component_rec.Eco_Name

Line 402: , Bom_Globals.Get_Prog_AppId

398: , p_sub_comp_Unexp_rec.component_sequence_id
399: , p_sub_component_rec.acd_type
400: , p_sub_component_rec.Eco_Name
401: , Fnd_Global.Conc_Request_Id /* Request Id */
402: , Bom_Globals.Get_Prog_AppId
403: , SYSDATE
404: , p_sub_component_rec.attribute_category
405: , p_sub_component_rec.attribute1
406: , p_sub_component_rec.attribute2

Line 420: , Bom_Globals.Get_Prog_Id

416: , p_sub_component_rec.attribute12
417: , p_sub_component_rec.attribute13
418: , p_sub_component_rec.attribute14
419: , p_sub_component_rec.attribute15
420: , Bom_Globals.Get_Prog_Id
421: , p_sub_component_rec.Original_System_Reference
422: , p_sub_comp_Unexp_rec.enforce_int_requirements_code
423: , l_src_comp_seq_id --bug 7713832
424: );

Line 425: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN --Bug 7713832

421: , p_sub_component_rec.Original_System_Reference
422: , p_sub_comp_Unexp_rec.enforce_int_requirements_code
423: , l_src_comp_seq_id --bug 7713832
424: );
425: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN --Bug 7713832
426: BOMPCMBM.Insert_Related_Sub_Comp(p_component_sequence_id => p_sub_comp_Unexp_rec.component_sequence_id
427: , p_sub_comp_item_id => p_sub_comp_unexp_rec.substitute_component_id
428: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
429: , x_Return_Status => x_return_status);

Line 476: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;

472: l_processed BOOLEAN;
473: l_return_status VARCHAR2(200);
474: l_err_text VARCHAR2(255);
475: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
476: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
477: BEGIN
478:
479: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
480: THEN

Line 479: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO

475: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
476: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
477: BEGIN
478:
479: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
480: THEN
481: Bom_GLOBALS.Check_Approved_For_Process(p_change_notice,
482: Bom_GLOBALS.Get_org_id,
483: l_processed,

Line 481: Bom_GLOBALS.Check_Approved_For_Process(p_change_notice,

477: BEGIN
478:
479: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
480: THEN
481: Bom_GLOBALS.Check_Approved_For_Process(p_change_notice,
482: Bom_GLOBALS.Get_org_id,
483: l_processed,
484: l_err_text);
485:

Line 482: Bom_GLOBALS.Get_org_id,

478:
479: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
480: THEN
481: Bom_GLOBALS.Check_Approved_For_Process(p_change_notice,
482: Bom_GLOBALS.Get_org_id,
483: l_processed,
484: l_err_text);
485:
486: if (l_processed = TRUE) then

Line 487: Bom_GLOBALS.Set_Request_For_approval(p_change_notice,

483: l_processed,
484: l_err_text);
485:
486: if (l_processed = TRUE) then
487: Bom_GLOBALS.Set_Request_For_approval(p_change_notice,
488: Bom_GLOBALS.Get_org_id,
489: l_err_text);
490: end if;
491: END IF;

Line 488: Bom_GLOBALS.Get_org_id,

484: l_err_text);
485:
486: if (l_processed = TRUE) then
487: Bom_GLOBALS.Set_Request_For_approval(p_change_notice,
488: Bom_GLOBALS.Get_org_id,
489: l_err_text);
490: end if;
491: END IF;
492:

Line 496: AND (( l_BO_Id = Bom_Globals.G_ECO_BO AND

492:
493: DELETE FROM BOM_SUBSTITUTE_COMPONENTS
494: WHERE SUBSTITUTE_COMPONENT_ID = p_substitute_component_id
495: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
496: AND (( l_BO_Id = Bom_Globals.G_ECO_BO AND
497: ACD_TYPE = p_acd_type
498: ) OR
499: (l_BO_Id = Bom_Globals.G_BOM_BO AND
500: acd_type IS NULL

Line 499: (l_BO_Id = Bom_Globals.G_BOM_BO AND

495: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
496: AND (( l_BO_Id = Bom_Globals.G_ECO_BO AND
497: ACD_TYPE = p_acd_type
498: ) OR
499: (l_BO_Id = Bom_Globals.G_BOM_BO AND
500: acd_type IS NULL
501: )
502: );
503: BOMPCMBM.Delete_Related_Sub_Comp( p_src_comp_seq => p_component_sequence_id

Line 620: x_return_status := Bom_Globals.G_RECORD_FOUND;

616: lookup_code = x_sub_comp_unexp_rec.enforce_int_requirements_code;
617: END IF;
618:
619: x_Sub_Component_Rec := l_sub_component_rec;
620: x_return_status := Bom_Globals.G_RECORD_FOUND;
621:
622: EXCEPTION
623: WHEN NO_DATA_FOUND THEN
624: x_Sub_Component_Rec := l_sub_component_rec;

Line 625: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;

621:
622: EXCEPTION
623: WHEN NO_DATA_FOUND THEN
624: x_Sub_Component_Rec := l_sub_component_rec;
625: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
626:
627: WHEN OTHERS THEN
628: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
629:

Line 628: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;

624: x_Sub_Component_Rec := l_sub_component_rec;
625: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
626:
627: WHEN OTHERS THEN
628: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
629:
630: END Query_Row;
631:
632: -- Procedure lock_Row

Line 670: IF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE

666: Error_Handler.Write_Debug ('In SCOMP Perform Writes ...is MISSING');
667: ELSE
668: Error_Handler.Write_Debug('In SCOMP Perform Writes...'||l_sub_component_rec.transaction_type);
669: END IF;
670: IF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE
671: THEN
672: Insert_Row( p_sub_component_rec => l_sub_component_rec
673: , p_Sub_Comp_Unexp_Rec => l_sub_comp_unexp_rec
674: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 677: ELSIF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

673: , p_Sub_Comp_Unexp_Rec => l_sub_comp_unexp_rec
674: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
675: , x_return_status => l_return_status
676: );
677: ELSIF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
678: THEN
679: Update_Row( p_sub_component_rec => l_sub_component_rec
680: , p_Sub_Comp_Unexp_Rec => l_sub_comp_unexp_rec
681: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 685: ELSIF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_DELETE

681: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
682: , x_return_status => l_return_status
683: );
684:
685: ELSIF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_DELETE
686: THEN
687: Delete_Row
688: ( p_substitute_component_id =>
689: l_sub_comp_unexp_rec.substitute_component_id