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 2653: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

2649: -- l_job_details_rec.wip_supply_type := lc_push_wip_supply_type;
2650: l_job_details_rec.wip_supply_type := null;
2651: -- Get the Group_id to be used for WIP Mass Load,
2652:
2653: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
2654:
2655: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
2656:
2657: l_job_details_rec.group_id := l_job_header_rec.group_id;

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

3002:
3003:
3004: -- Get the Group_id to be used for WIP Mass Load,
3005:
3006: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;
3007:
3008: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
3009:
3010: -- l_job_details_rec.group_id := l_job_header_rec.header_id;

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

3011: l_job_details_rec.parent_header_id := l_job_header_rec.header_id;
3012:
3013:
3014:
3015: -- SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
3016:
3017:
3018: --Commenting out as don't think this is needed
3019: -- Need to remove ro_quantity as well, later on if not neede

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

3826:
3827:
3828: -- Get the Group_id to be used for WIP Mass Load,
3829:
3830: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
3831:
3832: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
3833:
3834: l_job_details_rec.group_id := l_job_header_rec.group_id;

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

3925: -- l_job_details_rec.quantity_per_assembly := l_required_quantity / p_ro_quantity;
3926:
3927: -- Get the Group_id to be used for WIP Mass Load,
3928:
3929: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.header_id FROM dual;
3930:
3931: -- l_job_header_rec.group_id := l_job_header_rec.header_id;
3932:
3933: -- l_job_details_rec.group_id := l_job_header_rec.group_id;

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

4366: end if;
4367:
4368:
4369: -- Get the Group_id to be used for WIP Mass Load,
4370: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
4371:
4372:
4373: -- get job_quantity
4374: open get_job_quantity ( p_mtl_txn_dtls_tbl(mtl_ctr).wip_entity_id);

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

4775: If p_res_txn_dtls_tbl(res_ctr).new_row = 'Y' then
4776:
4777: -- Get the Group_id to be used for WIP Mass Load,
4778:
4779: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
4780:
4781: -- get job_quantity
4782: open get_job_quantity ( p_res_txn_dtls_tbl(res_ctr).wip_entity_id);
4783: fetch get_job_quantity into l_job_quantity;

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

5145:
5146: IF p_op_dtls_tbl(op_ctr).operation_seq_num is not null THEN
5147: -- Get the Group_id to be used for WIP Mass Load,
5148:
5149: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
5150:
5151: -- set job header info
5152: l_job_header_rec.header_id := l_job_header_rec.group_id;
5153: l_job_header_rec.wip_entity_id := p_op_dtls_tbl(op_ctr).wip_entity_id;

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

5620:
5621:
5622: -- Get the Group_id to be used for WIP Create Job,
5623:
5624: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
5625:
5626: l_job_header_rec.interface_id := l_job_header_rec.group_id;
5627:
5628: generate_job_name ( p_job_prefix =>l_job_prefix,

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

6290: -- table. This is passed to the insert_job_header
6291: -- procedure
6292:
6293: -- Get the Group_id to be used for WIP Create Job,
6294: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
6295:
6296: l_job_header_rec.interface_id := l_job_header_rec.group_id;
6297: l_job_header_rec.bom_reference_id := bills_routes_rec.bom_reference_id ;
6298: l_job_header_rec.routing_reference_id := bills_routes_rec.routing_reference_id ;