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_REPETITIVE_UTILITIES dependencies on WIP_REPETITIVE_SCHEDULES

Line 65: WIP_REPETITIVE_SCHEDULES WRS

61: FROM BOM_CALENDAR_DATES CD1,
62: BOM_CALENDAR_DATES CD2,
63: BOM_CALENDAR_DATES CD3,
64: BOM_CALENDAR_DATES CD4,
65: WIP_REPETITIVE_SCHEDULES WRS
66: WHERE WRS.ORGANIZATION_ID = p_org_id
67: AND WRS.REPETITIVE_SCHEDULE_ID = p_sched_id
68: AND CD1.CALENDAR_CODE = x_cal_code
69: AND CD1.EXCEPTION_SET_ID = x_excp_set_id

Line 97: SELECT WIP_REPETITIVE_SCHEDULES_S.NEXTVAL

93: AND OPERATION_SEQ_NUM = x_first_op
94: AND REPETITIVE_SCHEDULE_ID = p_sched_id;
95:
96: CURSOR nu_sched_id IS
97: SELECT WIP_REPETITIVE_SCHEDULES_S.NEXTVAL
98: FROM DUAL;
99:
100: CURSOR per_bal IS
101: SELECT WRS.line_id, WRI.class_code

Line 102: FROM WIP_REPETITIVE_ITEMS WRI, WIP_REPETITIVE_SCHEDULES WRS

98: FROM DUAL;
99:
100: CURSOR per_bal IS
101: SELECT WRS.line_id, WRI.class_code
102: FROM WIP_REPETITIVE_ITEMS WRI, WIP_REPETITIVE_SCHEDULES WRS
103: WHERE WRS.REPETITIVE_SCHEDULE_ID = p_new_sched_id
104: AND WRS.ORGANIZATION_ID = p_org_id
105: AND WRS.WIP_ENTITY_ID = x_wip_id
106: AND WRI.WIP_ENTITY_ID = x_wip_id

Line 167: INSERT INTO WIP_REPETITIVE_SCHEDULES

163: fetch nu_sched_id into p_new_sched_id;
164: close nu_sched_id;
165:
166: -- inserting new schedule
167: INSERT INTO WIP_REPETITIVE_SCHEDULES
168: (REPETITIVE_SCHEDULE_ID, ORGANIZATION_ID,
169: LAST_UPDATE_DATE, LAST_UPDATED_BY,
170: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
171: REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 238: WIP_REPETITIVE_SCHEDULES WRS

234: WRS.ATTRIBUTE12, WRS.ATTRIBUTE13,
235: WRS.ATTRIBUTE14, WRS.ATTRIBUTE15
236: FROM BOM_CALENDAR_DATES CD1,
237: BOM_CALENDAR_DATES CD2,
238: WIP_REPETITIVE_SCHEDULES WRS
239: WHERE WRS.ORGANIZATION_ID = p_org_id
240: AND WRS.REPETITIVE_SCHEDULE_ID = p_sched_id
241: AND CD1.CALENDAR_CODE = x_cal_code
242: AND CD1.EXCEPTION_SET_ID = x_excp_set_id

Line 260: UPDATE WIP_REPETITIVE_SCHEDULES

256:
257: -- set processed days, lusd, lucd of the old schedule to reflect days the
258: -- schedule actually ran
259:
260: UPDATE WIP_REPETITIVE_SCHEDULES
261: SET PROCESSING_WORK_DAYS = x_rnd_days_ran,
262: LAST_UNIT_START_DATE =
263: (SELECT TO_DATE(TO_CHAR(CALENDAR_DATE, WIP_CONSTANTS.DATE_FMT) || ' ' ||
264: TO_CHAR(LAST_UNIT_START_DATE, WIP_CONSTANTS.TIMESEC_FMT),

Line 659: FROM wip_repetitive_schedules wrs

655: wrs.line_id,
656: decode(p_rollfwd_type,
657: WIP_CONSTANTS.ROLL_EC_IMP,
658: 0, wrs.quantity_completed)
659: FROM wip_repetitive_schedules wrs
660: WHERE wrs.organization_id = p_org_id
661: AND wrs.repetitive_schedule_id =
662: decode(p_rollfwd_type, WIP_CONSTANTS.ROLL_EC_IMP, p_rollfwd_sched_id,
663: p_closed_sched_id);

Line 670: FROM wip_repetitive_schedules r1,

666: SELECT r1.repetitive_schedule_id,
667: r1.status_type,
668: r1.daily_production_rate * r1.processing_work_days,
669: r1.first_unit_start_date
670: FROM wip_repetitive_schedules r1,
671: wip_repetitive_schedules r2,
672: wip_parameters p
673: WHERE r1.organization_id = p_org_id
674: AND r2.organization_id = p_org_id

Line 671: wip_repetitive_schedules r2,

667: r1.status_type,
668: r1.daily_production_rate * r1.processing_work_days,
669: r1.first_unit_start_date
670: FROM wip_repetitive_schedules r1,
671: wip_repetitive_schedules r2,
672: wip_parameters p
673: WHERE r1.organization_id = p_org_id
674: AND r2.organization_id = p_org_id
675: AND p.organization_id = p_org_id

Line 691: FROM wip_repetitive_schedules wrs

687: CURSOR roll_ec IS
688: SELECT wrs.status_type,
689: wrs.daily_production_rate * wrs.processing_work_days,
690: wrs.first_unit_start_date
691: FROM wip_repetitive_schedules wrs
692: WHERE wrs.organization_id = p_org_id
693: AND wrs.repetitive_schedule_id = p_rollfwd_sched_id;
694:
695: CURSOR nxt_fstop IS

Line 916: UPDATE wip_repetitive_schedules wrs

912: IF ((p_rollfwd_type = WIP_CONSTANTS.ROLL_COMPLETE) OR
913: (p_rollfwd_type = WIP_CONSTANTS.ROLL_CANCEL)) THEN
914:
915: -- set the closed status of closed schedule
916: UPDATE wip_repetitive_schedules wrs
917: SET wrs.status_type = x_closed_status_type,
918: wrs.date_closed =
919: decode(x_closed_status_type,
920: WIP_CONSTANTS.COMP_CHRG,

Line 943: UPDATE wip_repetitive_schedules wrs

939:
940: IF (x_rollfwd_status_type = WIP_CONSTANTS.UNRELEASED) THEN
941:
942: -- release next schedule
943: UPDATE wip_repetitive_schedules wrs
944: SET wrs.status_type = WIP_CONSTANTS.RELEASED,
945: wrs.date_released = SYSDATE,
946: wrs.last_update_date = SYSDATE,
947: wrs.last_updated_by = x_user_id,

Line 1040: from wip_repetitive_schedules wrs

1036: x_last_sched_id OUT NOCOPY NUMBER,
1037: x_error_mesg OUT NOCOPY VARCHAR2) is
1038: CURSOR first_sched IS
1039: select wrs.repetitive_schedule_id
1040: from wip_repetitive_schedules wrs
1041: where wrs.organization_id = p_org_id
1042: and wrs.wip_entity_id = p_wip_entity_id
1043: and wrs.line_id = p_line_id
1044: and wrs.status_type in (3,4)

Line 1049: from wip_repetitive_schedules wrs

1045: order by wrs.LAST_UNIT_START_DATE asc;
1046:
1047: CURSOR last_sched IS
1048: select wrs.repetitive_schedule_id
1049: from wip_repetitive_schedules wrs
1050: where wrs.organization_id = p_org_id
1051: and wrs.wip_entity_id = p_wip_entity_id
1052: and wrs.line_id = p_line_id
1053: and wrs.status_type in (3,4)

Line 1088: from wip_repetitive_schedules wrs

1084: l_line_id number;
1085: cursor get_line (c_rep_sched_id number,
1086: c_org_id number) is
1087: select line_id
1088: from wip_repetitive_schedules wrs
1089: where wrs.repetitive_schedule_id = p_rep_sched_id
1090: and wrs.organization_id = p_org_id;
1091:
1092: BEGIN