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.ENGPKIMP dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 40: -- set new wip job name used in creating wip_job_schedule_interface

36:
37: -- Oracle Order Entry
38:
39: G_OrderEntry constant number(3) := 300;
40: -- set new wip job name used in creating wip_job_schedule_interface
41:
42: rev_op_disable_date_tbl Rev_Op_Disable_Date_Tbl_Type;
43: rev_comp_disable_date_tbl Rev_Comp_Disable_Date_Tbl_Type;
44:

Line 1588: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,

1584: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1585: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1586: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1587: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1588: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1589: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1590: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1591: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1592: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,

Line 1589: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,

1585: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1586: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1587: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1588: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1589: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1590: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1591: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1592: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
1593: message_names OUT NOCOPY NameArray,

Line 8268: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id1

8264: -- IF item.update_wip = 1 and NVL(item.start_quantity,0) > 0
8265: IF l_update_wip = 1
8266: THEN
8267:
8268: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id1
8269: FROM DUAL;
8270: group_id1 := l_wip_group_id1; --- set out type value
8271:
8272: --bug 2327582

Line 8280: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id2

8276: IF NVL(l_wip_from_cum_qty, 0) > 0
8277: THEN
8278: IF l_wip_start_quantity1 <> 0
8279: THEN
8280: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id2
8281: FROM DUAL;
8282: group_id2 := l_wip_group_id2; --- set out type value
8283: ELSE group_id2 := -1;
8284: END IF;

Line 8288: INSERT INTO wip_job_schedule_interface

8284: END IF;
8285:
8286: --WIP job gets split into 2 based on the CUM quantity
8287: -- delete the original wip job
8288: INSERT INTO wip_job_schedule_interface
8289: (
8290: last_update_date
8291: , last_updated_by
8292: , creation_date

Line 8328: INSERT INTO wip_job_schedule_interface

8324:
8325: -- Create first new order
8326: IF l_wip_start_quantity1 <> 0
8327: THEN
8328: INSERT INTO wip_job_schedule_interface
8329: (
8330: last_update_date
8331: , last_updated_by
8332: , creation_date

Line 8408: INSERT INTO wip_job_schedule_interface (

8404: END IF; */
8405: END IF; -- IF l_wip_start_quantity1 <> 0
8406:
8407: -- Create second new records
8408: INSERT INTO wip_job_schedule_interface (
8409: last_update_date
8410: , last_updated_by
8411: , creation_date
8412: , created_by

Line 8495: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id

8491: LOOP
8492: l_wip_job_name2 := wip_name_for_job_rec.wip_entity_name;
8493: l_wip_last_u_compl_date2 := wip_name_for_job_rec.scheduled_completion_date;
8494:
8495: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8496: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8497: /* Added for Bug2970539, Bug 3076067 */
8498:
8499: --if (l_wip_bom_revision_date2 > today) then -- 3412747

Line 8511: INSERT INTO wip_job_schedule_interface

8507: l_wip_routing_revision_date2 := wip_name_for_job_rec.routing_revision_date;
8508: end if;
8509:
8510: --Update existing WIP headers
8511: INSERT INTO wip_job_schedule_interface
8512: (
8513: last_update_date
8514: , last_updated_by
8515: , creation_date

Line 8612: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id

8608: LOOP
8609: l_wip_job_name2 := wip_name_for_lot_rec.wip_entity_name;
8610: l_wip_last_u_compl_date2 := wip_name_for_lot_rec.scheduled_completion_date;
8611:
8612: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8613: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8614:
8615: /* Added for Bug2970539, Bug 3076067 */
8616:

Line 8632: INSERT INTO wip_job_schedule_interface

8628: then
8629: l_wip_routing_revision_date2 := wip_name_for_lot_rec.routing_revision_date;
8630: end if;
8631:
8632: INSERT INTO wip_job_schedule_interface
8633: (
8634: last_update_date
8635: , last_updated_by
8636: , creation_date

Line 8732: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id

8728: LOOP
8729: l_wip_job_name2 := wip_name_for_common_rec.wip_entity_name;
8730: l_wip_last_u_compl_date2 := wip_name_for_common_rec.scheduled_completion_date;
8731:
8732: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8733: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8734:
8735: /* Added for Bug2970539, Bug 3076067 */
8736:

Line 8753: INSERT INTO wip_job_schedule_interface

8749: l_wip_routing_revision_date2 := wip_name_for_common_rec.routing_revision_date;
8750: end if;
8751:
8752:
8753: INSERT INTO wip_job_schedule_interface
8754: (
8755: last_update_date
8756: , last_updated_by
8757: , creation_date

Line 9169: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,

9165: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
9166: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
9167: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
9168: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
9169: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9170: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9171: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
9172: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
9173: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,

Line 9170: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,

9166: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
9167: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
9168: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
9169: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9170: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9171: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
9172: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
9173: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
9174: message_names OUT NOCOPY NameArray,