APPS.BOM_OP_RES_UTIL dependencies on BOM_OPERATION_RESOURCES

Line 124: SELECT * FROM BOM_OPERATION_RESOURCES

120: , l_bo_id VARCHAR2
121: , p_acd_type NUMBER )
122: IS
123:
124: SELECT * FROM BOM_OPERATION_RESOURCES
125: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO
126: AND NVL(ACD_TYPE, FND_API.G_MISS_NUM)
127: = NVL(p_acd_type,FND_API.G_MISS_NUM))
128: OR

Line 138: op_res_rec BOM_OPERATION_RESOURCES%ROWTYPE ;

134: AND RESOURCE_SEQ_NUM = p_resource_sequence_number
135: AND OPERATION_SEQUENCE_ID = p_operation_sequence_id
136: ;
137:
138: op_res_rec BOM_OPERATION_RESOURCES%ROWTYPE ;
139:
140:
141: BEGIN
142:

Line 434: * table; BOM_OPERATION_RESOURCES

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

Line 454: INSERT INTO BOM_OPERATION_RESOURCES

450:
451: x_return_status := FND_API.G_RET_STS_SUCCESS ;
452:
453: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
454: INSERT INTO BOM_OPERATION_RESOURCES
455: (
456: operation_sequence_id
457: , resource_seq_num
458: , resource_id

Line 605: UPDATE BOM_OPERATION_RESOURCES

601:
602: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;
603: END IF ;
604:
605: UPDATE BOM_OPERATION_RESOURCES
606: SET
607: resource_id = p_rev_op_res_unexp_rec.resource_id
608: , activity_id = p_rev_op_res_unexp_rec.activity_id
609: , standard_rate_flag = p_rev_op_resource_rec.standard_rate_flag

Line 706: DELETE FROM BOM_OPERATION_RESOURCES

702:
703: x_return_status := FND_API.G_RET_STS_SUCCESS ;
704:
705:
706: DELETE FROM BOM_OPERATION_RESOURCES
707: WHERE operation_sequence_id = p_rev_op_res_unexp_rec.operation_sequence_id
708: AND resource_seq_num = p_rev_op_resource_rec.resource_sequence_number
709: AND NVL(acd_type, 1) = NVL(p_rev_op_resource_rec.acd_type,1) ;
710:

Line 721: FROM BOM_OPERATION_RESOURCES bor

717: *******************************************************************/
718:
719: DELETE FROM BOM_SUB_OPERATION_RESOURCES sor
720: WHERE NOT EXISTS ( SELECT 'AnOther Res not exist'
721: FROM BOM_OPERATION_RESOURCES bor
722: WHERE bor.substitute_group_num = sor.substitute_group_num
723: AND bor.operation_sequence_id = sor.operation_sequence_id
724: )
725: AND sor.substitute_group_num = nvl(p_rev_op_resource_rec.substitute_group_number, p_rev_op_res_unexp_rec.substitute_group_number)