DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on STANDARD

Line 7915: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking for standard operation from WORK_ORDER') ; END IF ;

7911: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
7912: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
7913:
7914:
7915: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking for standard operation from WORK_ORDER') ; END IF ;
7916:
7917: if (l_eam_wo_rec.asset_activity_id IS NOT NULL and
7918: (l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
7919: or

Line 7927: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exploding standard operation from WORK_ORDER') ; END IF ;

7923: then
7924: null ;
7925: else
7926:
7927: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exploding standard operation from WORK_ORDER') ; END IF ;
7928:
7929: -- Need to explode standard operations
7930:
7931: IF l_eam_op_tbl.COUNT > 0 THEN

Line 7929: -- Need to explode standard operations

7925: else
7926:
7927: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exploding standard operation from WORK_ORDER') ; END IF ;
7928:
7929: -- Need to explode standard operations
7930:
7931: IF l_eam_op_tbl.COUNT > 0 THEN
7932: FOR J IN l_eam_op_tbl.FIRST..l_eam_op_tbl.LAST LOOP
7933: IF l_eam_op_tbl(J).standard_operation_id IS NOT NULL THEN

Line 7933: IF l_eam_op_tbl(J).standard_operation_id IS NOT NULL THEN

7929: -- Need to explode standard operations
7930:
7931: IF l_eam_op_tbl.COUNT > 0 THEN
7932: FOR J IN l_eam_op_tbl.FIRST..l_eam_op_tbl.LAST LOOP
7933: IF l_eam_op_tbl(J).standard_operation_id IS NOT NULL THEN
7934: declare
7935:
7936: CURSOR resOP IS
7937: select

Line 7959: bsor.STANDARD_RATE_FLAG,

7955: bsor.ACTIVITY_ID,
7956: bsor.SCHEDULE_FLAG,
7957: bsor.ASSIGNED_UNITS,
7958: DECODE(bsor.autocharge_type,1,2,4,3,2,2,3,3,2) autocharge_type,
7959: bsor.STANDARD_RATE_FLAG,
7960: 0 APPLIED_RESOURCE_UNITS,
7961: 0 APPLIED_RESOURCE_VALUE,
7962: nvl(l_eam_op_tbl(J).start_date,sysdate) start_date,
7963: nvl(l_eam_op_tbl(J).completion_date,sysdate) completion_date,

Line 7983: from bom_standard_operations bso,

7979: bsor.ATTRIBUTE15,
7980: bso.DEPARTMENT_ID,
7981: decode(bsor.SCHEDULE_FLAG,2,null,bsor.resource_seq_num) ,
7982: bsor.SUBSTITUTE_GROUP_NUM
7983: from bom_standard_operations bso,
7984: bom_std_op_resources bsor,
7985: bom_resources br
7986: where bso.standard_operation_id = bsor.standard_operation_id
7987: and br.resource_id = bsor.resource_id

Line 7986: where bso.standard_operation_id = bsor.standard_operation_id

7982: bsor.SUBSTITUTE_GROUP_NUM
7983: from bom_standard_operations bso,
7984: bom_std_op_resources bsor,
7985: bom_resources br
7986: where bso.standard_operation_id = bsor.standard_operation_id
7987: and br.resource_id = bsor.resource_id
7988: and bso.standard_operation_id = l_eam_op_tbl(J).standard_operation_id
7989: and bso.organization_id = l_eam_op_tbl(J).organization_id;
7990:

Line 7988: and bso.standard_operation_id = l_eam_op_tbl(J).standard_operation_id

7984: bom_std_op_resources bsor,
7985: bom_resources br
7986: where bso.standard_operation_id = bsor.standard_operation_id
7987: and br.resource_id = bsor.resource_id
7988: and bso.standard_operation_id = l_eam_op_tbl(J).standard_operation_id
7989: and bso.organization_id = l_eam_op_tbl(J).organization_id;
7990:
7991: l_res_cnt NUMBER ;
7992: begin

Line 8014: l_eam_res_tbl(l_res_cnt).STANDARD_RATE_FLAG := resrec.STANDARD_RATE_FLAG;

8010: l_eam_res_tbl(l_res_cnt).ACTIVITY_ID := resrec.ACTIVITY_ID;
8011: l_eam_res_tbl(l_res_cnt).SCHEDULED_FLAG := resrec.SCHEDULE_FLAG;
8012: l_eam_res_tbl(l_res_cnt).ASSIGNED_UNITS := resrec.ASSIGNED_UNITS;
8013: l_eam_res_tbl(l_res_cnt).AUTOCHARGE_TYPE := resrec.AUTOCHARGE_TYPE;
8014: l_eam_res_tbl(l_res_cnt).STANDARD_RATE_FLAG := resrec.STANDARD_RATE_FLAG;
8015: l_eam_res_tbl(l_res_cnt).APPLIED_RESOURCE_UNITS := resrec.APPLIED_RESOURCE_UNITS;
8016: l_eam_res_tbl(l_res_cnt).APPLIED_RESOURCE_VALUE := resrec.APPLIED_RESOURCE_VALUE;
8017: l_eam_res_tbl(l_res_cnt).START_DATE := resrec.START_DATE;
8018: l_eam_res_tbl(l_res_cnt).COMPLETION_DATE := resrec.COMPLETION_DATE;

Line 8042: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Completed Exploding standard operation from WORK_ORDER') ; END IF ;

8038: l_eam_res_tbl(l_res_cnt).RETURN_STATUS := l_eam_op_tbl(J).RETURN_STATUS ;
8039: l_eam_res_tbl(l_res_cnt).TRANSACTION_TYPE := l_eam_op_tbl(J).TRANSACTION_TYPE ;
8040: END LOOP;
8041: END;
8042: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Completed Exploding standard operation from WORK_ORDER') ; END IF ;
8043:
8044: END IF;
8045:
8046: END LOOP;