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 DUAL

Line 372: x_job_name From Dual;

368: -- generate the Job Name by appending a sequence generated number to the passed in
369: -- job_prefix
370:
371: Select p_job_prefix || TO_CHAR( CSD_JOB_NAME_S.NEXTVAL ) into
372: x_job_name From Dual;
373:
374:
375: -- Check if the job name generated is unique for the specified organization,
376: -- if not loop around till a unique job name is generated

Line 1829: SELECT mtl_material_transactions_s.nextval from dual;

1825: wdj.primary_item_id = msi.inventory_item_id and
1826: wdj.organization_id = msi.organization_id;
1827:
1828: CURSOR get_mtl_header_id IS
1829: SELECT mtl_material_transactions_s.nextval from dual;
1830:
1831: CURSOR get_last_operation_dtls(c_org_id NUMBER) IS
1832: SELECT
1833: wo.quantity_waiting_to_move,

Line 2508: SELECT wip_transactions_s.nextval from dual;

2504: l_qty_in_queue NUMBER := 0;
2505: -- end swai: bug 5330060
2506:
2507: CURSOR get_transaction_id IS
2508: SELECT wip_transactions_s.nextval from dual;
2509:
2510:
2511: Cursor check_mv_interface_errors ( c_group_id NUMBER ) IS
2512: select wip.wip_entity_name, mv.fm_operation_seq_num

Line 2536: SELECT mtl_material_transactions_s.nextval from dual; */

2532: where rownum=1;
2533: -- end swai: bug 5330060
2534:
2535: /* CURSOR get_material_transaction_id IS
2536: SELECT mtl_material_transactions_s.nextval from dual; */
2537:
2538:
2539: BEGIN
2540:

Line 2899: SELECT mtl_material_transactions_s.nextval from dual;

2895: -- end swai: bug 13820264, FP of bug#13797285, subhat
2896:
2897:
2898: CURSOR get_mtl_header_id IS
2899: SELECT mtl_material_transactions_s.nextval from dual;
2900:
2901: CURSOR get_org_locator_control_code(p_organization_id NUMBER) IS
2902: SELECT stock_locator_control_code from mtl_parameters
2903: where organization_id = p_organization_id;

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 3942: SELECT mtl_material_transactions_s.nextval from dual;

3938: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3939: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3940:
3941: CURSOR get_mtl_header_id IS
3942: SELECT mtl_material_transactions_s.nextval from dual;
3943:
3944: BEGIN
3945:
3946: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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 6534: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_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,
6538: p_organization_id => l_job_header_rec.organization_id,

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 7338: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_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;
7342:

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;