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 1516: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,

1512: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1513: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1514: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1515: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1516: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1517: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1518: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1519: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1520: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,

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

1513: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1514: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1515: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1516: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1517: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1518: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1519: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
1520: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
1521: message_names OUT NOCOPY NameArray,

Line 7927: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id1

7923: -- IF item.update_wip = 1 and NVL(item.start_quantity,0) > 0
7924: IF l_update_wip = 1
7925: THEN
7926:
7927: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id1
7928: FROM DUAL;
7929: group_id1 := l_wip_group_id1; --- set out type value
7930:
7931: --bug 2327582

Line 7939: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id2

7935: IF NVL(l_wip_from_cum_qty, 0) > 0
7936: THEN
7937: IF l_wip_start_quantity1 <> 0
7938: THEN
7939: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_group_id2
7940: FROM DUAL;
7941: group_id2 := l_wip_group_id2; --- set out type value
7942: ELSE group_id2 := -1;
7943: END IF;

Line 7947: INSERT INTO wip_job_schedule_interface

7943: END IF;
7944:
7945: --WIP job gets split into 2 based on the CUM quantity
7946: -- delete the original wip job
7947: INSERT INTO wip_job_schedule_interface
7948: (
7949: last_update_date
7950: , last_updated_by
7951: , creation_date

Line 7987: INSERT INTO wip_job_schedule_interface

7983:
7984: -- Create first new order
7985: IF l_wip_start_quantity1 <> 0
7986: THEN
7987: INSERT INTO wip_job_schedule_interface
7988: (
7989: last_update_date
7990: , last_updated_by
7991: , creation_date

Line 8066: INSERT INTO wip_job_schedule_interface (

8062: END IF;
8063: END IF; -- IF l_wip_start_quantity1 <> 0
8064:
8065: -- Create second new records
8066: INSERT INTO wip_job_schedule_interface (
8067: last_update_date
8068: , last_updated_by
8069: , creation_date
8070: , created_by

Line 8152: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id

8148: LOOP
8149: l_wip_job_name2 := wip_name_for_job_rec.wip_entity_name;
8150: l_wip_last_u_compl_date2 := wip_name_for_job_rec.scheduled_completion_date;
8151:
8152: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8153: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8154: /* Added for Bug2970539, Bug 3076067 */
8155:
8156: --if (l_wip_bom_revision_date2 > today) then -- 3412747

Line 8168: INSERT INTO wip_job_schedule_interface

8164: l_wip_routing_revision_date2 := wip_name_for_job_rec.routing_revision_date;
8165: end if;
8166:
8167: --Update existing WIP headers
8168: INSERT INTO wip_job_schedule_interface
8169: (
8170: last_update_date
8171: , last_updated_by
8172: , creation_date

Line 8268: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id

8264: LOOP
8265: l_wip_job_name2 := wip_name_for_lot_rec.wip_entity_name;
8266: l_wip_last_u_compl_date2 := wip_name_for_lot_rec.scheduled_completion_date;
8267:
8268: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8269: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8270:
8271: /* Added for Bug2970539, Bug 3076067 */
8272:

Line 8288: INSERT INTO wip_job_schedule_interface

8284: then
8285: l_wip_routing_revision_date2 := wip_name_for_lot_rec.routing_revision_date;
8286: end if;
8287:
8288: INSERT INTO wip_job_schedule_interface
8289: (
8290: last_update_date
8291: , last_updated_by
8292: , creation_date

Line 8388: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id

8384: LOOP
8385: l_wip_job_name2 := wip_name_for_common_rec.wip_entity_name;
8386: l_wip_last_u_compl_date2 := wip_name_for_common_rec.scheduled_completion_date;
8387:
8388: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_wip_header_id
8389: FROM DUAL; --fix bug 5667398 cannot have duplicate header id from same group id
8390:
8391: /* Added for Bug2970539, Bug 3076067 */
8392:

Line 8409: INSERT INTO wip_job_schedule_interface

8405: l_wip_routing_revision_date2 := wip_name_for_common_rec.routing_revision_date;
8406: end if;
8407:
8408:
8409: INSERT INTO wip_job_schedule_interface
8410: (
8411: last_update_date
8412: , last_updated_by
8413: , creation_date

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

8820: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
8821: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
8822: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
8823: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
8824: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8825: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8826: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
8827: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
8828: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,

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

8821: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
8822: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
8823: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
8824: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8825: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8826: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
8827: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
8828: wip_job_name2_org_id OUT NOCOPY wip_entities.organization_id%type,
8829: message_names OUT NOCOPY NameArray,