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.CSD_HV_WIP_JOB_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE_S

Line 2998: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

2994: -- l_job_details_rec.wip_supply_type := lc_push_wip_supply_type;
2995: l_job_details_rec.wip_supply_type := null;
2996: -- Get the Group_id to be used for WIP Mass Load,
2997:
2998: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
2999:
3000: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
3001:
3002: l_job_details_rec.group_id := l_job_header_rec.group_id;

Line 3363: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;

3359:
3360:
3361: -- Get the Group_id to be used for WIP Mass Load,
3362:
3363: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;
3364:
3365: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
3366:
3367: -- l_job_details_rec.group_id := l_job_header_rec.header_id;

Line 3372: -- SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;

3368: l_job_details_rec.parent_header_id := l_job_header_rec.header_id;
3369:
3370:
3371:
3372: -- SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
3373:
3374:
3375: --Commenting out as don't think this is needed
3376: -- Need to remove ro_quantity as well, later on if not neede

Line 4267: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

4263:
4264:
4265: -- Get the Group_id to be used for WIP Mass Load,
4266:
4267: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
4268:
4269: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
4270:
4271: l_job_details_rec.group_id := l_job_header_rec.group_id;

Line 4366: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;

4362: -- l_job_details_rec.quantity_per_assembly := l_required_quantity / p_ro_quantity;
4363:
4364: -- Get the Group_id to be used for WIP Mass Load,
4365:
4366: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;
4367:
4368: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
4369:
4370: -- l_job_details_rec.group_id := l_job_header_rec.group_id;

Line 4884: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

4880: end if;
4881:
4882:
4883: -- Get the Group_id to be used for WIP Mass Load,
4884: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
4885:
4886:
4887: -- get job_quantity
4888: open get_job_quantity ( p_mtl_txn_dtls_tbl(mtl_ctr).wip_entity_id);

Line 5091: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

5087:
5088: l_job_details_rec.substitution_type := lc_substitution_change_type;
5089:
5090: -- Get the Group_id to be used for WIP Mass Load,
5091: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
5092:
5093: l_job_header_rec.header_id := l_job_header_rec.group_id;
5094: l_job_header_rec.wip_entity_id := p_mtl_txn_dtls_tbl(mtl_ctr).wip_entity_id;
5095: l_job_header_rec.organization_id := p_mtl_txn_dtls_tbl(mtl_ctr).organization_id;

Line 5575: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

5571: If p_res_txn_dtls_tbl(res_ctr).new_row = 'Y' then
5572:
5573: -- Get the Group_id to be used for WIP Mass Load,
5574:
5575: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
5576:
5577: -- get job_quantity
5578: open get_job_quantity ( p_res_txn_dtls_tbl(res_ctr).wip_entity_id);
5579: fetch get_job_quantity into l_job_quantity;

Line 5988: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

5984:
5985: IF p_op_dtls_tbl(op_ctr).operation_seq_num is not null THEN
5986: -- Get the Group_id to be used for WIP Mass Load,
5987:
5988: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
5989:
5990: -- set job header info
5991: l_job_header_rec.header_id := l_job_header_rec.group_id;
5992: l_job_header_rec.wip_entity_id := p_op_dtls_tbl(op_ctr).wip_entity_id;

Line 6529: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

6525:
6526:
6527: -- Get the Group_id to be used for WIP Create Job,
6528:
6529: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
6530:
6531: -- nnadig bug 9263438
6532: -- interface id should use sequence number from wip_interface_s
6533: -- wip_job_schedule_interface_s is for wjsi.group_id, and wip_interface_s is for wjsi.interface_id.

Line 6533: -- wip_job_schedule_interface_s is for wjsi.group_id, and wip_interface_s is for wjsi.interface_id.

6529: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
6530:
6531: -- nnadig bug 9263438
6532: -- interface id should use sequence number from wip_interface_s
6533: -- wip_job_schedule_interface_s is for wjsi.group_id, and wip_interface_s is for wjsi.interface_id.
6534: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
6535: --l_job_header_rec.interface_id := l_job_header_rec.group_id;
6536:
6537: generate_job_name ( p_job_prefix =>l_job_prefix,

Line 7333: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

7329: -- table. This is passed to the insert_job_header
7330: -- procedure
7331:
7332: -- Get the Group_id to be used for WIP Create Job,
7333: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
7334:
7335: -- nnadig: bug 9263438
7336: -- interface id should use sequence number from wip_interface_s
7337: -- wip_job_schedule_interface_s is for wjsi.group_id, wip_interface_s is for wjsi.interface_id.

Line 7337: -- wip_job_schedule_interface_s is for wjsi.group_id, wip_interface_s is for wjsi.interface_id.

7333: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
7334:
7335: -- nnadig: bug 9263438
7336: -- interface id should use sequence number from wip_interface_s
7337: -- wip_job_schedule_interface_s is for wjsi.group_id, wip_interface_s is for wjsi.interface_id.
7338: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
7339:
7340:
7341: --l_job_header_rec.interface_id := l_job_header_rec.group_id;

Line 9223: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

9219:
9220: --
9221: -- populate l_job_header_rec values
9222: --
9223: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
9224: l_job_header_rec.load_type := lc_non_std_update_load_type;
9225: l_job_header_rec.header_id := l_job_header_rec.group_id;
9226: l_job_header_rec.wip_entity_id := p_mtl_txn_dtls.wip_entity_id;
9227: l_job_header_rec.organization_id := p_mtl_txn_dtls.organization_id;