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 238: type t_wip_lab_perf_rate is table of wip_labor_performance_rates%rowtype index by binary_integer;

234: /* PL/SQL table for storing metrics data for a particular employee */
235: type t_emp_perf_temp is table of rec_emp_perf_temp index by varchar2(25);
236: v_emp_perf_temp t_emp_perf_temp;
237:
238: type t_wip_lab_perf_rate is table of wip_labor_performance_rates%rowtype index by binary_integer;
239: v_wip_lab_perf_rate t_wip_lab_perf_rate;
240:
241: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
242: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;

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

237:
238: type t_wip_lab_perf_rate is table of wip_labor_performance_rates%rowtype index by binary_integer;
239: v_wip_lab_perf_rate t_wip_lab_perf_rate;
240:
241: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
242: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
243: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
244: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
245: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;

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

238: type t_wip_lab_perf_rate is table of wip_labor_performance_rates%rowtype index by binary_integer;
239: v_wip_lab_perf_rate t_wip_lab_perf_rate;
240:
241: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
242: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
243: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
244: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
245: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
246: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;

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

239: v_wip_lab_perf_rate t_wip_lab_perf_rate;
240:
241: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
242: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
243: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
244: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
245: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
246: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
247: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;

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

240:
241: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
242: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
243: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
244: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
245: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
246: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
247: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
248: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;

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

241: type t_date_sequence is table of wip_labor_performance_rates.date_sequence%type index by binary_integer;
242: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
243: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
244: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
245: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
246: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
247: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
248: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;
249:

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

242: type t_shift_num is table of wip_labor_performance_rates.shift_num%type index by binary_integer;
243: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
244: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
245: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
246: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
247: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
248: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;
249:
250: v_date_sequence t_date_sequence;

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

243: type t_m1_att1 is table of wip_labor_performance_rates.metric1_attribute1%type index by binary_integer;
244: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
245: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
246: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
247: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
248: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;
249:
250: v_date_sequence t_date_sequence;
251: v_shift_num t_shift_num;

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

244: type t_m1_att2 is table of wip_labor_performance_rates.metric1_attribute2%type index by binary_integer;
245: type t_m2_att1 is table of wip_labor_performance_rates.metric2_attribute1%type index by binary_integer;
246: type t_m2_att2 is table of wip_labor_performance_rates.metric2_attribute2%type index by binary_integer;
247: type t_m3_att1 is table of wip_labor_performance_rates.metric3_attribute1%type index by binary_integer;
248: type t_m3_att2 is table of wip_labor_performance_rates.metric3_attribute2%type index by binary_integer;
249:
250: v_date_sequence t_date_sequence;
251: v_shift_num t_shift_num;
252: v_m1_att1 t_m1_att1;

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

795:
796: /* Check for the metrics preferences and its requirement: End */
797:
798: if l_metric1_required or l_metric2_required or l_metric3_required then
799: /* Delete existing records in wip_labor_performance_rates table for the org.*/
800:
801: delete from wip_labor_performance_rates
802: where organization_id= p_organization_id;
803:

Line 801: delete from wip_labor_performance_rates

797:
798: if l_metric1_required or l_metric2_required or l_metric3_required then
799: /* Delete existing records in wip_labor_performance_rates table for the org.*/
800:
801: delete from wip_labor_performance_rates
802: where organization_id= p_organization_id;
803:
804: l_stmt_num :=60;
805:

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

1241: l_stmt_num :=380;
1242:
1243: /* Bulk Insert Records into Metrics Table */
1244: forall cntr in v_wip_lab_perf_rate.first..v_wip_lab_perf_rate.last
1245: INSERT into WIP_LABOR_PERFORMANCE_RATES values v_wip_lab_perf_rate(cntr);
1246:
1247: l_stmt_num :=390;
1248: if (g_logLevel <= wip_constants.trace_logging) then
1249: wip_ws_util.trace_log('Insertion of all calculated records is successful.');

Line 1281: from wip_labor_performance_rates

1277: decode(l_metric2_attribute1,1,max(metric2_attribute1),sum(metric2_attribute1)) m2_att1,
1278: decode(l_metric2_attribute2,1,max(metric2_attribute2),sum(metric2_attribute2)) m2_att2,
1279: decode(l_metric3_attribute1,1,max(metric3_attribute1),sum(metric3_attribute1)) m3_att1,
1280: decode(l_metric3_attribute2,1,max(metric3_attribute2),sum(metric3_attribute2)) m3_att2
1281: from wip_labor_performance_rates
1282: where organization_id = p_organization_id
1283: group by
1284: date_sequence,
1285: shift_num,

Line 1299: insert into wip_labor_performance_rates

1295: end if;
1296:
1297: /* Insert into Metrics Table the org level summary data. Use -1 for dept,res and employee */
1298: forall org_index in v_shift_num.first..v_shift_num.last
1299: insert into wip_labor_performance_rates
1300: (
1301: ORGANIZATION_ID,
1302: DEPARTMENT_ID,
1303: RESOURCE_ID,