APPS.BOM_SUB_OP_RES_UTIL dependencies on BOM_SUB_OPERATION_RESOURCES

Line 140: SELECT * FROM BOM_SUB_OPERATION_RESOURCES

136: , p_schedule_flag NUMBER /* Added for bug 13005178 */
137: )
138: IS
139:
140: SELECT * FROM BOM_SUB_OPERATION_RESOURCES
141: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO
142: AND ACD_TYPE = p_acd_type )
143: OR
144: ( l_bo_id = BOM_Rtg_Globals.G_RTG_BO

Line 154: sub_res_rec BOM_SUB_OPERATION_RESOURCES%ROWTYPE ;

150: AND OPERATION_SEQUENCE_ID = p_operation_sequence_id
151: AND REPLACEMENT_GROUP_NUM = p_replacement_group_number --bug 2489765
152: AND SCHEDULE_FLAG = p_schedule_flag; /* Added filter for bug 13005178 */
153:
154: sub_res_rec BOM_SUB_OPERATION_RESOURCES%ROWTYPE ;
155:
156:
157: BEGIN
158:

Line 440: * table; BOM_SUB_OPERATION_RESOURCES

436: * Revised Sub Operation Resource unexposed column record
437: * Parameters out: Return Status
438: * Message Token Table
439: * Purpose : This procedure will insert a record in the Sub Operation Resource
440: * table; BOM_SUB_OPERATION_RESOURCES
441: *
442: *****************************************************************************/
443: PROCEDURE Insert_Row
444: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

Line 460: INSERT INTO BOM_SUB_OPERATION_RESOURCES

456:
457: x_return_status := FND_API.G_RET_STS_SUCCESS ;
458:
459: --bug:3254815 Update request id.
460: INSERT INTO BOM_SUB_OPERATION_RESOURCES
461: (
462: operation_sequence_id
463: , substitute_group_num
464: , resource_id

Line 612: UPDATE BOM_SUB_OPERATION_RESOURCES

608: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;
609: END IF ;
610:
611:
612: UPDATE BOM_SUB_OPERATION_RESOURCES
613: SET
614: replacement_group_num = NVL(p_rev_sub_resource_rec.new_replacement_group_number, p_rev_sub_resource_rec.replacement_group_number) -- bug 3741570
615: , resource_id = NVL(p_rev_sub_res_unexp_rec.new_resource_id, p_rev_sub_res_unexp_rec.resource_id)
616: , schedule_seq_num = p_rev_sub_resource_rec.schedule_sequence_number

Line 716: DELETE FROM BOM_SUB_OPERATION_RESOURCES

712: BEGIN
713:
714: x_return_status := FND_API.G_RET_STS_SUCCESS ;
715:
716: DELETE FROM BOM_SUB_OPERATION_RESOURCES
717: WHERE NVL(acd_type, 0) = NVL(p_rev_sub_resource_rec.acd_type,0)
718: AND basis_type = p_rev_sub_resource_rec.basis_type
719: AND substitute_group_num = nvl(p_rev_sub_resource_rec.substitute_group_number, p_rev_sub_res_unexp_rec.substitute_group_number)
720: AND resource_id = p_rev_sub_res_unexp_rec.resource_id