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 360: , Bom_globals.Get_User_Id

356: )
357: VALUES
358: ( p_sub_comp_unexp_rec.substitute_component_id
359: , SYSDATE
360: , Bom_globals.Get_User_Id
361: , SYSDATE
362: , Bom_Globals.Get_User_Id
363: , Bom_Globals.Get_User_Id
364: , p_sub_component_rec.substitute_item_quantity

Line 362: , Bom_Globals.Get_User_Id

358: ( p_sub_comp_unexp_rec.substitute_component_id
359: , SYSDATE
360: , Bom_globals.Get_User_Id
361: , SYSDATE
362: , Bom_Globals.Get_User_Id
363: , Bom_Globals.Get_User_Id
364: , p_sub_component_rec.substitute_item_quantity
365: , p_sub_comp_Unexp_rec.component_sequence_id
366: , p_sub_component_rec.acd_type

Line 363: , Bom_Globals.Get_User_Id

359: , SYSDATE
360: , Bom_globals.Get_User_Id
361: , SYSDATE
362: , Bom_Globals.Get_User_Id
363: , Bom_Globals.Get_User_Id
364: , p_sub_component_rec.substitute_item_quantity
365: , p_sub_comp_Unexp_rec.component_sequence_id
366: , p_sub_component_rec.acd_type
367: , p_sub_component_rec.Eco_Name

Line 369: , Bom_Globals.Get_Prog_AppId

365: , p_sub_comp_Unexp_rec.component_sequence_id
366: , p_sub_component_rec.acd_type
367: , p_sub_component_rec.Eco_Name
368: , Fnd_Global.Conc_Request_Id /* Request Id */
369: , Bom_Globals.Get_Prog_AppId
370: , SYSDATE
371: , p_sub_component_rec.attribute_category
372: , p_sub_component_rec.attribute1
373: , p_sub_component_rec.attribute2

Line 387: , Bom_Globals.Get_Prog_Id

383: , p_sub_component_rec.attribute12
384: , p_sub_component_rec.attribute13
385: , p_sub_component_rec.attribute14
386: , p_sub_component_rec.attribute15
387: , Bom_Globals.Get_Prog_Id
388: , p_sub_component_rec.Original_System_Reference
389: , p_sub_comp_Unexp_rec.enforce_int_requirements_code
390: );
391: BOMPCMBM.Insert_Related_Sub_Comp(p_component_sequence_id => p_sub_comp_Unexp_rec.component_sequence_id

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

436: l_processed BOOLEAN;
437: l_return_status VARCHAR2(200);
438: l_err_text VARCHAR2(255);
439: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
440: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
441: BEGIN
442:
443: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
444: THEN

Line 443: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO

439: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
440: l_BO_Id VARCHAR2(3) := Bom_Globals.Get_Bo_Identifier;
441: BEGIN
442:
443: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
444: THEN
445: Bom_GLOBALS.Check_Approved_For_Process(p_change_notice,
446: Bom_GLOBALS.Get_org_id,
447: l_processed,

Line 445: Bom_GLOBALS.Check_Approved_For_Process(p_change_notice,

441: BEGIN
442:
443: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
444: THEN
445: Bom_GLOBALS.Check_Approved_For_Process(p_change_notice,
446: Bom_GLOBALS.Get_org_id,
447: l_processed,
448: l_err_text);
449:

Line 446: Bom_GLOBALS.Get_org_id,

442:
443: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
444: THEN
445: Bom_GLOBALS.Check_Approved_For_Process(p_change_notice,
446: Bom_GLOBALS.Get_org_id,
447: l_processed,
448: l_err_text);
449:
450: if (l_processed = TRUE) then

Line 451: Bom_GLOBALS.Set_Request_For_approval(p_change_notice,

447: l_processed,
448: l_err_text);
449:
450: if (l_processed = TRUE) then
451: Bom_GLOBALS.Set_Request_For_approval(p_change_notice,
452: Bom_GLOBALS.Get_org_id,
453: l_err_text);
454: end if;
455: END IF;

Line 452: Bom_GLOBALS.Get_org_id,

448: l_err_text);
449:
450: if (l_processed = TRUE) then
451: Bom_GLOBALS.Set_Request_For_approval(p_change_notice,
452: Bom_GLOBALS.Get_org_id,
453: l_err_text);
454: end if;
455: END IF;
456:

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

456:
457: DELETE FROM BOM_SUBSTITUTE_COMPONENTS
458: WHERE SUBSTITUTE_COMPONENT_ID = p_substitute_component_id
459: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
460: AND (( l_BO_Id = Bom_Globals.G_ECO_BO AND
461: ACD_TYPE = p_acd_type
462: ) OR
463: (l_BO_Id = Bom_Globals.G_BOM_BO AND
464: acd_type IS NULL

Line 463: (l_BO_Id = Bom_Globals.G_BOM_BO AND

459: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
460: AND (( l_BO_Id = Bom_Globals.G_ECO_BO AND
461: ACD_TYPE = p_acd_type
462: ) OR
463: (l_BO_Id = Bom_Globals.G_BOM_BO AND
464: acd_type IS NULL
465: )
466: );
467: BOMPCMBM.Delete_Related_Sub_Comp( p_src_comp_seq => p_component_sequence_id

Line 584: x_return_status := Bom_Globals.G_RECORD_FOUND;

580: lookup_code = x_sub_comp_unexp_rec.enforce_int_requirements_code;
581: END IF;
582:
583: x_Sub_Component_Rec := l_sub_component_rec;
584: x_return_status := Bom_Globals.G_RECORD_FOUND;
585:
586: EXCEPTION
587: WHEN NO_DATA_FOUND THEN
588: x_Sub_Component_Rec := l_sub_component_rec;

Line 589: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;

585:
586: EXCEPTION
587: WHEN NO_DATA_FOUND THEN
588: x_Sub_Component_Rec := l_sub_component_rec;
589: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
590:
591: WHEN OTHERS THEN
592: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
593:

Line 592: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;

588: x_Sub_Component_Rec := l_sub_component_rec;
589: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
590:
591: WHEN OTHERS THEN
592: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
593:
594: END Query_Row;
595:
596: -- Procedure lock_Row

Line 634: IF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE

630: Error_Handler.Write_Debug ('In SCOMP Perform Writes ...is MISSING');
631: ELSE
632: Error_Handler.Write_Debug('In SCOMP Perform Writes...'||l_sub_component_rec.transaction_type);
633: END IF;
634: IF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE
635: THEN
636: Insert_Row( p_sub_component_rec => l_sub_component_rec
637: , p_Sub_Comp_Unexp_Rec => l_sub_comp_unexp_rec
638: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 641: ELSIF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

637: , p_Sub_Comp_Unexp_Rec => l_sub_comp_unexp_rec
638: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
639: , x_return_status => l_return_status
640: );
641: ELSIF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
642: THEN
643: Update_Row( p_sub_component_rec => l_sub_component_rec
644: , p_Sub_Comp_Unexp_Rec => l_sub_comp_unexp_rec
645: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 649: ELSIF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_DELETE

645: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
646: , x_return_status => l_return_status
647: );
648:
649: ELSIF l_sub_component_rec.transaction_type = Bom_Globals.G_OPR_DELETE
650: THEN
651: Delete_Row
652: ( p_substitute_component_id =>
653: l_sub_comp_unexp_rec.substitute_component_id