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.GMP_WPS_WRITER dependencies on WIP_DATETIMES

Line 51: v_start_date := wip_datetimes.float_to_DT(pstart_date/1440+phorizon);

47: BEGIN
48:
49: v_batch_id := pbatch_id;
50: return_status := 0;
51: v_start_date := wip_datetimes.float_to_DT(pstart_date/1440+phorizon);
52: v_end_date := wip_datetimes.float_to_DT(pend_date/1440+phorizon);
53: v_batch_status := 0;
54:
55: OPEN validate_batch_header;

Line 52: v_end_date := wip_datetimes.float_to_DT(pend_date/1440+phorizon);

48:
49: v_batch_id := pbatch_id;
50: return_status := 0;
51: v_start_date := wip_datetimes.float_to_DT(pstart_date/1440+phorizon);
52: v_end_date := wip_datetimes.float_to_DT(pend_date/1440+phorizon);
53: v_batch_status := 0;
54:
55: OPEN validate_batch_header;
56: FETCH validate_batch_header INTO v_batch_status, v_last_update_date;

Line 61: last_update_date := wip_datetimes.float_to_DT(plast_update/1440+phorizon+1);

57:
58: IF validate_batch_header%NOTFOUND THEN
59: return_status := -1;
60: ELSE
61: last_update_date := wip_datetimes.float_to_DT(plast_update/1440+phorizon+1);
62:
63: IF v_last_update_date > last_update_date THEN
64: return_status := -2;
65: ELSIF v_batch_status > 2 THEN

Line 198: last_update_date := wip_datetimes.float_to_DT(plast_update(i)/1440+phorizon+1);

194: return_status := -1;
195: ELSIF v_step_status > 1 THEN
196: return_status := -2;
197: ELSE
198: last_update_date := wip_datetimes.float_to_DT(plast_update(i)/1440+phorizon+1);
199: IF v_last_update_date > last_update_date THEN
200: return_status := -2;
201: ELSE
202: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);

Line 202: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);

198: last_update_date := wip_datetimes.float_to_DT(plast_update(i)/1440+phorizon+1);
199: IF v_last_update_date > last_update_date THEN
200: return_status := -2;
201: ELSE
202: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
203: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
204:
205: UPDATE
206: gme_batch_steps

Line 203: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);

199: IF v_last_update_date > last_update_date THEN
200: return_status := -2;
201: ELSE
202: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
203: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
204:
205: UPDATE
206: gme_batch_steps
207: SET

Line 397: last_update_date := wip_datetimes.float_to_DT(plast_update/1440+phorizon+1);

393: return_status := -1;
394: ELSIF v_step_status > 1 THEN
395: return_status := -2;
396: ELSE
397: last_update_date := wip_datetimes.float_to_DT(plast_update/1440+phorizon+1);
398: IF v_last_update_date > last_update_date THEN
399: return_status := -3;
400: ELSE
401: v_start_date := wip_datetimes.float_to_DT(pstart_date/1440+phorizon);

Line 401: v_start_date := wip_datetimes.float_to_DT(pstart_date/1440+phorizon);

397: last_update_date := wip_datetimes.float_to_DT(plast_update/1440+phorizon+1);
398: IF v_last_update_date > last_update_date THEN
399: return_status := -3;
400: ELSE
401: v_start_date := wip_datetimes.float_to_DT(pstart_date/1440+phorizon);
402: v_end_date := wip_datetimes.float_to_DT(pend_date/1440+phorizon);
403:
404: UPDATE
405: gme_batch_step_activities

Line 402: v_end_date := wip_datetimes.float_to_DT(pend_date/1440+phorizon);

398: IF v_last_update_date > last_update_date THEN
399: return_status := -3;
400: ELSE
401: v_start_date := wip_datetimes.float_to_DT(pstart_date/1440+phorizon);
402: v_end_date := wip_datetimes.float_to_DT(pend_date/1440+phorizon);
403:
404: UPDATE
405: gme_batch_step_activities
406: SET

Line 638: last_update_date := wip_datetimes.float_to_DT(plast_update(i)/1440+phorizon+1);

634: return_status := -1;
635: ELSIF v_step_status > 1 THEN
636: return_status := -2;
637: ELSE
638: last_update_date := wip_datetimes.float_to_DT(plast_update(i)/1440+phorizon+1);
639: IF v_last_update_date > last_update_date THEN
640: return_status := -3;
641: ELSE
642: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);

Line 642: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);

638: last_update_date := wip_datetimes.float_to_DT(plast_update(i)/1440+phorizon+1);
639: IF v_last_update_date > last_update_date THEN
640: return_status := -3;
641: ELSE
642: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
643: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
644: v_seq_dep_usage :=
645: inv_convert.inv_um_convert(-1,38,(pseq_dep_usage(i)/60),puom_hour,
646: v_uom_code,NULL,NULL);

Line 643: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);

639: IF v_last_update_date > last_update_date THEN
640: return_status := -3;
641: ELSE
642: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
643: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
644: v_seq_dep_usage :=
645: inv_convert.inv_um_convert(-1,38,(pseq_dep_usage(i)/60),puom_hour,
646: v_uom_code,NULL,NULL);
647:

Line 981: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);

977: ELSE
978: temp_date := (pend_date(i) - pstart_date(i))/60;
979: v_res_usage := inv_convert.inv_um_convert(-1,38,temp_date,
980: puom_hour,v_uom_code,NULL,NULL);
981: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
982: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
983:
984: v_in_trans_row.line_id := v_act_resource_id;
985: v_in_trans_row.ORGANIZATION_ID := v_ORGANIZATION_ID; -- For R12.0

Line 982: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);

978: temp_date := (pend_date(i) - pstart_date(i))/60;
979: v_res_usage := inv_convert.inv_um_convert(-1,38,temp_date,
980: puom_hour,v_uom_code,NULL,NULL);
981: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
982: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
983:
984: v_in_trans_row.line_id := v_act_resource_id;
985: v_in_trans_row.ORGANIZATION_ID := v_ORGANIZATION_ID; -- For R12.0
986: v_in_trans_row.doc_type := v_doc_prod;