eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_PROCESS_WO_PVT dependencies on STANDARD

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

8337: l_out_eam_mat_req_tbl := l_eam_mat_req_tbl;
8338: l_out_eam_direct_items_tbl := l_eam_direct_items_tbl;
8339:
8340:
8341: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Checking for standard operation from WORK_ORDER') ; END IF ;
8342:
8343: if (l_eam_wo_rec.asset_activity_id IS NOT NULL and
8344: (l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
8345: or

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

8349: then
8350: null ;
8351: else
8352:
8353: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Exploding standard operation from WORK_ORDER') ; END IF ;
8354:
8355: -- Need to explode standard operations
8356:
8357: IF l_eam_op_tbl.COUNT > 0 THEN

Line 8355: -- Need to explode standard operations

8351: else
8352:
8353: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Exploding standard operation from WORK_ORDER') ; END IF ;
8354:
8355: -- Need to explode standard operations
8356:
8357: IF l_eam_op_tbl.COUNT > 0 THEN
8358: FOR J IN l_eam_op_tbl.FIRST..l_eam_op_tbl.LAST LOOP
8359: IF l_eam_op_tbl(J).standard_operation_id IS NOT NULL THEN

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

8355: -- Need to explode standard operations
8356:
8357: IF l_eam_op_tbl.COUNT > 0 THEN
8358: FOR J IN l_eam_op_tbl.FIRST..l_eam_op_tbl.LAST LOOP
8359: IF l_eam_op_tbl(J).standard_operation_id IS NOT NULL THEN
8360: declare
8361:
8362: CURSOR resOP IS
8363: select

Line 8385: bsor.STANDARD_RATE_FLAG,

8381: bsor.ACTIVITY_ID,
8382: bsor.SCHEDULE_FLAG,
8383: bsor.ASSIGNED_UNITS,
8384: DECODE(bsor.autocharge_type,1,2,4,3,2,2,3,3,2) autocharge_type,
8385: bsor.STANDARD_RATE_FLAG,
8386: 0 APPLIED_RESOURCE_UNITS,
8387: 0 APPLIED_RESOURCE_VALUE,
8388: nvl(l_eam_op_tbl(J).start_date,sysdate) start_date,
8389: nvl(l_eam_op_tbl(J).completion_date,sysdate) completion_date,

Line 8409: from bom_standard_operations bso,

8405: bsor.ATTRIBUTE15,
8406: bso.DEPARTMENT_ID,
8407: decode(bsor.SCHEDULE_FLAG,2,null,bsor.resource_seq_num) ,
8408: bsor.SUBSTITUTE_GROUP_NUM
8409: from bom_standard_operations bso,
8410: bom_std_op_resources bsor,
8411: bom_resources br
8412: where bso.standard_operation_id = bsor.standard_operation_id
8413: and br.resource_id = bsor.resource_id

Line 8412: where bso.standard_operation_id = bsor.standard_operation_id

8408: bsor.SUBSTITUTE_GROUP_NUM
8409: from bom_standard_operations bso,
8410: bom_std_op_resources bsor,
8411: bom_resources br
8412: where bso.standard_operation_id = bsor.standard_operation_id
8413: and br.resource_id = bsor.resource_id
8414: and bso.standard_operation_id = l_eam_op_tbl(J).standard_operation_id
8415: and bso.organization_id = l_eam_op_tbl(J).organization_id;
8416:

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

8410: bom_std_op_resources bsor,
8411: bom_resources br
8412: where bso.standard_operation_id = bsor.standard_operation_id
8413: and br.resource_id = bsor.resource_id
8414: and bso.standard_operation_id = l_eam_op_tbl(J).standard_operation_id
8415: and bso.organization_id = l_eam_op_tbl(J).organization_id;
8416:
8417: l_res_cnt NUMBER ;
8418: begin

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

8436: l_eam_res_tbl(l_res_cnt).ACTIVITY_ID := resrec.ACTIVITY_ID;
8437: l_eam_res_tbl(l_res_cnt).SCHEDULED_FLAG := resrec.SCHEDULE_FLAG;
8438: l_eam_res_tbl(l_res_cnt).ASSIGNED_UNITS := resrec.ASSIGNED_UNITS;
8439: l_eam_res_tbl(l_res_cnt).AUTOCHARGE_TYPE := resrec.AUTOCHARGE_TYPE;
8440: l_eam_res_tbl(l_res_cnt).STANDARD_RATE_FLAG := resrec.STANDARD_RATE_FLAG;
8441: l_eam_res_tbl(l_res_cnt).APPLIED_RESOURCE_UNITS := resrec.APPLIED_RESOURCE_UNITS;
8442: l_eam_res_tbl(l_res_cnt).APPLIED_RESOURCE_VALUE := resrec.APPLIED_RESOURCE_VALUE;
8443: l_eam_res_tbl(l_res_cnt).START_DATE := resrec.START_DATE;
8444: l_eam_res_tbl(l_res_cnt).COMPLETION_DATE := resrec.COMPLETION_DATE;

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

8464: l_eam_res_tbl(l_res_cnt).RETURN_STATUS := l_eam_op_tbl(J).RETURN_STATUS ;
8465: l_eam_res_tbl(l_res_cnt).TRANSACTION_TYPE := l_eam_op_tbl(J).TRANSACTION_TYPE ;
8466: END LOOP;
8467: END;
8468: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Completed Exploding standard operation from WORK_ORDER') ; END IF ;
8469: --start for
8470: --Reverting the changes done for bug 11871588
8471: END IF;
8472: END LOOP;

Line 8476: --Non Standard Operation

8472: END LOOP;
8473: END IF;
8474:
8475: /*
8476: --Non Standard Operation
8477: else --if l_eam_op_tbl(J).standard_operation_id IS NULL THEN
8478: declare
8479:
8480: CURSOR nonStdResOP IS

Line 8477: else --if l_eam_op_tbl(J).standard_operation_id IS NULL THEN

8473: END IF;
8474:
8475: /*
8476: --Non Standard Operation
8477: else --if l_eam_op_tbl(J).standard_operation_id IS NULL THEN
8478: declare
8479:
8480: CURSOR nonStdResOP IS
8481: select

Line 8503: wor.STANDARD_RATE_FLAG,

8499: wor.ACTIVITY_ID,
8500: wor.SCHEDULED_FLAG,
8501: wor.ASSIGNED_UNITS,
8502: DECODE(wor.autocharge_type,1,2,4,3,2,2,3,3,2) autocharge_type,
8503: wor.STANDARD_RATE_FLAG,
8504: 0 APPLIED_RESOURCE_UNITS,
8505: 0 APPLIED_RESOURCE_VALUE,
8506: nvl(l_eam_op_tbl(J).start_date,sysdate) start_date,
8507: nvl(l_eam_op_tbl(J).completion_date,sysdate) completion_date,

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

8556: l_eam_res_tbl(l_res_cnt).ACTIVITY_ID := resrec.ACTIVITY_ID;
8557: l_eam_res_tbl(l_res_cnt).SCHEDULED_FLAG := resrec.SCHEDULED_FLAG;
8558: l_eam_res_tbl(l_res_cnt).ASSIGNED_UNITS := resrec.ASSIGNED_UNITS;
8559: l_eam_res_tbl(l_res_cnt).AUTOCHARGE_TYPE := resrec.AUTOCHARGE_TYPE;
8560: l_eam_res_tbl(l_res_cnt).STANDARD_RATE_FLAG := resrec.STANDARD_RATE_FLAG;
8561: l_eam_res_tbl(l_res_cnt).APPLIED_RESOURCE_UNITS := resrec.APPLIED_RESOURCE_UNITS;
8562: l_eam_res_tbl(l_res_cnt).APPLIED_RESOURCE_VALUE := resrec.APPLIED_RESOURCE_VALUE;
8563: l_eam_res_tbl(l_res_cnt).START_DATE := resrec.START_DATE;
8564: l_eam_res_tbl(l_res_cnt).COMPLETION_DATE := resrec.COMPLETION_DATE;

Line 8591: END IF; --non-standard oper

8587: END; --end for delcare begin end
8588: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Completed Exploding manual operation from WORK_ORDER') ; END IF ;
8589:
8590:
8591: END IF; --non-standard oper
8592:
8593:
8594:
8595: END LOOP; --operation table loop