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.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_LABOR_PERFORMANCE_RATES

Line 244: type t_wip_lab_perf_rate is table of wip_labor_performance_rates%rowtype index by binary_integer;

240: /* PL/SQL table for storing metrics data for a particular employee */
241: type t_emp_perf_temp is table of rec_emp_perf_temp index by varchar2(25);
242: v_emp_perf_temp t_emp_perf_temp;
243:
244: type t_wip_lab_perf_rate is table of wip_labor_performance_rates%rowtype index by binary_integer;
245: v_wip_lab_perf_rate t_wip_lab_perf_rate;
246:
247: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
248: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;

Line 247: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;

243:
244: type t_wip_lab_perf_rate is table of wip_labor_performance_rates%rowtype index by binary_integer;
245: v_wip_lab_perf_rate t_wip_lab_perf_rate;
246:
247: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
248: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
249: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
250: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
251: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;

Line 248: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;

244: type t_wip_lab_perf_rate is table of wip_labor_performance_rates%rowtype index by binary_integer;
245: v_wip_lab_perf_rate t_wip_lab_perf_rate;
246:
247: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
248: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
249: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
250: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
251: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
252: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;

Line 249: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;

245: v_wip_lab_perf_rate t_wip_lab_perf_rate;
246:
247: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
248: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
249: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
250: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
251: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
252: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
253: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;

Line 250: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;

246:
247: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
248: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
249: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
250: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
251: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
252: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
253: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
254: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;

Line 251: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;

247: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
248: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
249: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
250: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
251: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
252: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
253: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
254: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;
255:

Line 252: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;

248: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
249: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
250: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
251: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
252: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
253: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
254: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;
255:
256: v_date_sequence t_date_sequence;

Line 253: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;

249: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
250: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
251: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
252: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
253: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
254: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;
255:
256: v_date_sequence t_date_sequence;
257: v_shift_num t_shift_num;

Line 254: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;

250: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
251: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
252: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
253: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
254: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;
255:
256: v_date_sequence t_date_sequence;
257: v_shift_num t_shift_num;
258: v_m1_att1 t_m1_att1;

Line 825: /* Delete existing records in wip_labor_performance_rates table for the org.*/

821:
822: /* Check for the metrics preferences and its requirement: End */
823:
824: if l_metric1_required or l_metric2_required or l_metric3_required then
825: /* Delete existing records in wip_labor_performance_rates table for the org.*/
826:
827: delete from wip_labor_performance_rates
828: where organization_id= p_organization_id;
829:

Line 827: delete from wip_labor_performance_rates

823:
824: if l_metric1_required or l_metric2_required or l_metric3_required then
825: /* Delete existing records in wip_labor_performance_rates table for the org.*/
826:
827: delete from wip_labor_performance_rates
828: where organization_id= p_organization_id;
829:
830: l_stmt_num :=60;
831:

Line 1343: INSERT into WIP_LABOR_PERFORMANCE_RATES values v_wip_lab_perf_rate(cntr);

1339: l_stmt_num :=380;
1340:
1341: /* Bulk Insert Records into Metrics Table */
1342: forall cntr in v_wip_lab_perf_rate.first..v_wip_lab_perf_rate.last
1343: INSERT into WIP_LABOR_PERFORMANCE_RATES values v_wip_lab_perf_rate(cntr);
1344:
1345: l_stmt_num :=390;
1346: if (g_logLevel <= wip_constants.trace_logging) then
1347: wip_ws_util.trace_log('Insertion of all calculated records is successful.');

Line 1379: from wip_labor_performance_rates

1375: decode(l_metric2_attribute1,1,max(metric2_attribute1),sum(metric2_attribute1)) m2_att1,
1376: decode(l_metric2_attribute2,1,max(metric2_attribute2),sum(metric2_attribute2)) m2_att2,
1377: decode(l_metric3_attribute1,1,max(metric3_attribute1),sum(metric3_attribute1)) m3_att1,
1378: decode(l_metric3_attribute2,1,max(metric3_attribute2),sum(metric3_attribute2)) m3_att2
1379: from wip_labor_performance_rates
1380: where organization_id = p_organization_id
1381: group by
1382: date_sequence,
1383: shift_num,

Line 1397: insert into wip_labor_performance_rates

1393: end if;
1394:
1395: /* Insert into Metrics Table the org level summary data. Use -1 for dept,res and employee */
1396: forall org_index in v_shift_num.first..v_shift_num.last
1397: insert into wip_labor_performance_rates
1398: (
1399: ORGANIZATION_ID,
1400: DEPARTMENT_ID,
1401: RESOURCE_ID,