[Home] [Help]
1131: ELSE
1132: bsd.shift_date + bst.to_time/86400
1133: END
1134: --bsd.shift_date + bst.to_time/86400
1135: from bom_resource_shifts brs,
1136: mtl_parameters mp,
1137: bom_shift_dates bsd,
1138: bom_shift_times bst,
1139: bom_department_resources bdr
1238: select 1
1239: into l_dummy
1240: from dual
1241: where exists (select 1
1242: from bom_resource_shifts brs,
1243: bom_department_resources bdr
1244: where bdr.department_id = x_resTbls.deptID(p_idx)
1245: and bdr.resource_id = x_resTbls.resID(p_idx)
1246: and brs.resource_id = bdr.resource_id
1550: p_orgID IN NUMBER,
1551: x_shifts IN OUT NOCOPY shift_recTbl_t,
1552: x_returnStatus OUT NOCOPY VARCHAR2) is
1553:
1554: /*bug 10251978 (FP 10086620): Modified the cursor to include capacity_units value from bom_resource_shifts table*/
1555: cursor c_capacityDtls(v_resID NUMBER,
1556: v_deptID NUMBER,
1557: v_orgID NUMBER) is
1558: select brc.shift_num,
1564: brc.action_type,
1565: brs.capacity_units
1566: from bom_resource_changes brc,
1567: crp_simulation_sets crp,
1568: BOM_RESOURCE_SHIFTS brs
1569: where brc.department_id = v_deptID
1570: and brc.resource_id = v_resID
1571: and crp.organization_id = v_orgID
1572: and crp.simulation_set = brc.simulation_set
2254: ELSE
2255: bsd.shift_date + bst.to_time/86400
2256: END
2257: --bsd.shift_date + bst.to_time/86400
2258: from bom_resource_shifts brs,
2259: mtl_parameters mp,
2260: bom_shift_dates bsd,
2261: bom_shift_times bst,
2262: bom_department_resources bdr
2363: select 1
2364: into l_dummy
2365: from dual
2366: where exists (select 1
2367: from bom_resource_shifts brs,
2368: bom_department_resources bdr
2369: where bdr.department_id = x_resTbls.deptID(p_idx)
2370: and bdr.resource_id = x_resTbls.resID(p_idx)
2371: and brs.resource_id = bdr.resource_id