APPS.BOM_SUB_OP_RES_UTIL dependencies on BOM_SUB_OPERATION_RESOURCES

Line 136: SELECT * FROM BOM_SUB_OPERATION_RESOURCES

132: , p_basis_type NUMBER
133: )
134: IS
135:
136: SELECT * FROM BOM_SUB_OPERATION_RESOURCES
137: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO
138: AND ACD_TYPE = p_acd_type )
139: OR
140: ( l_bo_id = BOM_Rtg_Globals.G_RTG_BO

Line 149: sub_res_rec BOM_SUB_OPERATION_RESOURCES%ROWTYPE ;

145: AND SUBSTITUTE_GROUP_NUM = p_substiute_group_number
146: AND OPERATION_SEQUENCE_ID = p_operation_sequence_id
147: AND REPLACEMENT_GROUP_NUM = p_replacement_group_number ; --bug 2489765
148:
149: sub_res_rec BOM_SUB_OPERATION_RESOURCES%ROWTYPE ;
150:
151:
152: BEGIN
153:

Line 434: * table; BOM_SUB_OPERATION_RESOURCES

430: * Revised Sub Operation Resource unexposed column record
431: * Parameters out: Return Status
432: * Message Token Table
433: * Purpose : This procedure will insert a record in the Sub Operation Resource
434: * table; BOM_SUB_OPERATION_RESOURCES
435: *
436: *****************************************************************************/
437: PROCEDURE Insert_Row
438: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

Line 454: INSERT INTO BOM_SUB_OPERATION_RESOURCES

450:
451: x_return_status := FND_API.G_RET_STS_SUCCESS ;
452:
453: --bug:3254815 Update request id.
454: INSERT INTO BOM_SUB_OPERATION_RESOURCES
455: (
456: operation_sequence_id
457: , substitute_group_num
458: , resource_id

Line 606: UPDATE BOM_SUB_OPERATION_RESOURCES

602: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;
603: END IF ;
604:
605:
606: UPDATE BOM_SUB_OPERATION_RESOURCES
607: SET
608: replacement_group_num = NVL(p_rev_sub_resource_rec.new_replacement_group_number, p_rev_sub_resource_rec.replacement_group_number) -- bug 3741570
609: , resource_id = NVL(p_rev_sub_res_unexp_rec.new_resource_id, p_rev_sub_res_unexp_rec.resource_id)
610: , schedule_seq_num = p_rev_sub_resource_rec.schedule_sequence_number

Line 709: DELETE FROM BOM_SUB_OPERATION_RESOURCES

705: BEGIN
706:
707: x_return_status := FND_API.G_RET_STS_SUCCESS ;
708:
709: DELETE FROM BOM_SUB_OPERATION_RESOURCES
710: WHERE NVL(acd_type, 0) = NVL(p_rev_sub_resource_rec.acd_type,0)
711: AND basis_type = p_rev_sub_resource_rec.basis_type
712: AND substitute_group_num = nvl(p_rev_sub_resource_rec.substitute_group_number, p_rev_sub_res_unexp_rec.substitute_group_number)
713: AND resource_id = p_rev_sub_res_unexp_rec.resource_id