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_REPAIRS_UTIL dependencies on JTF_NUMBER_TABLE

Line 2263: p_wip_entity_id_tbl IN JTF_NUMBER_TABLE,

2259: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2260: x_return_status OUT NOCOPY VARCHAR2,
2261: x_msg_count OUT NOCOPY NUMBER,
2262: x_msg_data OUT NOCOPY VARCHAR2,
2263: p_wip_entity_id_tbl IN JTF_NUMBER_TABLE,
2264: p_quantity_tbl IN JTF_NUMBER_TABLE,
2265: p_uom_code_tbl IN VARCHAR2_TABLE_100,
2266: p_op_seq_num_tbl IN JTF_NUMBER_TABLE,
2267: p_item_id_tbl IN JTF_NUMBER_TABLE,

Line 2264: p_quantity_tbl IN JTF_NUMBER_TABLE,

2260: x_return_status OUT NOCOPY VARCHAR2,
2261: x_msg_count OUT NOCOPY NUMBER,
2262: x_msg_data OUT NOCOPY VARCHAR2,
2263: p_wip_entity_id_tbl IN JTF_NUMBER_TABLE,
2264: p_quantity_tbl IN JTF_NUMBER_TABLE,
2265: p_uom_code_tbl IN VARCHAR2_TABLE_100,
2266: p_op_seq_num_tbl IN JTF_NUMBER_TABLE,
2267: p_item_id_tbl IN JTF_NUMBER_TABLE,
2268: p_item_description_tbl IN VARCHAR2_TABLE_100,

Line 2266: p_op_seq_num_tbl IN JTF_NUMBER_TABLE,

2262: x_msg_data OUT NOCOPY VARCHAR2,
2263: p_wip_entity_id_tbl IN JTF_NUMBER_TABLE,
2264: p_quantity_tbl IN JTF_NUMBER_TABLE,
2265: p_uom_code_tbl IN VARCHAR2_TABLE_100,
2266: p_op_seq_num_tbl IN JTF_NUMBER_TABLE,
2267: p_item_id_tbl IN JTF_NUMBER_TABLE,
2268: p_item_description_tbl IN VARCHAR2_TABLE_100,
2269: p_organization_id IN NUMBER,
2270: x_request_id OUT NOCOPY NUMBER,

Line 2267: p_item_id_tbl IN JTF_NUMBER_TABLE,

2263: p_wip_entity_id_tbl IN JTF_NUMBER_TABLE,
2264: p_quantity_tbl IN JTF_NUMBER_TABLE,
2265: p_uom_code_tbl IN VARCHAR2_TABLE_100,
2266: p_op_seq_num_tbl IN JTF_NUMBER_TABLE,
2267: p_item_id_tbl IN JTF_NUMBER_TABLE,
2268: p_item_description_tbl IN VARCHAR2_TABLE_100,
2269: p_organization_id IN NUMBER,
2270: x_request_id OUT NOCOPY NUMBER,
2271: p_repair_line_id IN NUMBER DEFAULT NULL

Line 2279: l_material_account JTF_NUMBER_TABLE;

2275: lc_api_name CONSTANT VARCHAR2(30) := 'CREATE_REQUISITION';
2276: lc_mod_name CONSTANT VARCHAR2(40) := 'csd_repairs_util.create_requisition';
2277:
2278: l_person_id NUMBER;
2279: l_material_account JTF_NUMBER_TABLE;
2280: l_material_variance_account JTF_NUMBER_TABLE;
2281: l_currency VARCHAR2(30);
2282: l_project_id JTF_NUMBER_TABLE;
2283: l_task_id JTF_NUMBER_TABLE;

Line 2280: l_material_variance_account JTF_NUMBER_TABLE;

2276: lc_mod_name CONSTANT VARCHAR2(40) := 'csd_repairs_util.create_requisition';
2277:
2278: l_person_id NUMBER;
2279: l_material_account JTF_NUMBER_TABLE;
2280: l_material_variance_account JTF_NUMBER_TABLE;
2281: l_currency VARCHAR2(30);
2282: l_project_id JTF_NUMBER_TABLE;
2283: l_task_id JTF_NUMBER_TABLE;
2284: l_location_id JTF_NUMBER_TABLE;

Line 2282: l_project_id JTF_NUMBER_TABLE;

2278: l_person_id NUMBER;
2279: l_material_account JTF_NUMBER_TABLE;
2280: l_material_variance_account JTF_NUMBER_TABLE;
2281: l_currency VARCHAR2(30);
2282: l_project_id JTF_NUMBER_TABLE;
2283: l_task_id JTF_NUMBER_TABLE;
2284: l_location_id JTF_NUMBER_TABLE;
2285: l_ou_id NUMBER;
2286:

Line 2283: l_task_id JTF_NUMBER_TABLE;

2279: l_material_account JTF_NUMBER_TABLE;
2280: l_material_variance_account JTF_NUMBER_TABLE;
2281: l_currency VARCHAR2(30);
2282: l_project_id JTF_NUMBER_TABLE;
2283: l_task_id JTF_NUMBER_TABLE;
2284: l_location_id JTF_NUMBER_TABLE;
2285: l_ou_id NUMBER;
2286:
2287: l_previous_wip_entity NUMBER;

Line 2284: l_location_id JTF_NUMBER_TABLE;

2280: l_material_variance_account JTF_NUMBER_TABLE;
2281: l_currency VARCHAR2(30);
2282: l_project_id JTF_NUMBER_TABLE;
2283: l_task_id JTF_NUMBER_TABLE;
2284: l_location_id JTF_NUMBER_TABLE;
2285: l_ou_id NUMBER;
2286:
2287: l_previous_wip_entity NUMBER;
2288: l_previous_op_seq_num NUMBER;

Line 2291: l_wip_entity_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2287: l_previous_wip_entity NUMBER;
2288: l_previous_op_seq_num NUMBER;
2289: l_needby_date DATE;
2290: l_dummy NUMBER;
2291: l_wip_entity_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2292: l_item_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2293: l_item_description_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2294: l_uom_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2295: l_quantity_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 2292: l_item_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2288: l_previous_op_seq_num NUMBER;
2289: l_needby_date DATE;
2290: l_dummy NUMBER;
2291: l_wip_entity_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2292: l_item_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2293: l_item_description_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2294: l_uom_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2295: l_quantity_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2296: l_source_org_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 2295: l_quantity_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2291: l_wip_entity_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2292: l_item_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2293: l_item_description_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2294: l_uom_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2295: l_quantity_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2296: l_source_org_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2297: l_source_subinv_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2298: l_op_seq_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2299: l_mtl_txn_dtls_tab csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

Line 2296: l_source_org_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2292: l_item_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2293: l_item_description_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2294: l_uom_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2295: l_quantity_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2296: l_source_org_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2297: l_source_subinv_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2298: l_op_seq_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2299: l_mtl_txn_dtls_tab csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
2300: l_mtl_txn_dtls_upd csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

Line 2298: l_op_seq_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2294: l_uom_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2295: l_quantity_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2296: l_source_org_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2297: l_source_subinv_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2298: l_op_seq_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2299: l_mtl_txn_dtls_tab csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
2300: l_mtl_txn_dtls_upd csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
2301:
2302: x_use_custom_sourcing BOOLEAN := FALSE;

Line 2356: l_project_id := JTF_NUMBER_TABLE();

2352:
2353: l_needby_date := sysdate + l_dummy;
2354: --
2355: -- initialize the collections used for bulk binding.
2356: l_project_id := JTF_NUMBER_TABLE();
2357: l_task_id := JTF_NUMBER_TABLE();
2358: l_material_account := JTF_NUMBER_TABLE();
2359: l_material_variance_account:= JTF_NUMBER_TABLE();
2360: l_location_id := JTF_NUMBER_TABLE();

Line 2357: l_task_id := JTF_NUMBER_TABLE();

2353: l_needby_date := sysdate + l_dummy;
2354: --
2355: -- initialize the collections used for bulk binding.
2356: l_project_id := JTF_NUMBER_TABLE();
2357: l_task_id := JTF_NUMBER_TABLE();
2358: l_material_account := JTF_NUMBER_TABLE();
2359: l_material_variance_account:= JTF_NUMBER_TABLE();
2360: l_location_id := JTF_NUMBER_TABLE();
2361:

Line 2358: l_material_account := JTF_NUMBER_TABLE();

2354: --
2355: -- initialize the collections used for bulk binding.
2356: l_project_id := JTF_NUMBER_TABLE();
2357: l_task_id := JTF_NUMBER_TABLE();
2358: l_material_account := JTF_NUMBER_TABLE();
2359: l_material_variance_account:= JTF_NUMBER_TABLE();
2360: l_location_id := JTF_NUMBER_TABLE();
2361:
2362: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2359: l_material_variance_account:= JTF_NUMBER_TABLE();

2355: -- initialize the collections used for bulk binding.
2356: l_project_id := JTF_NUMBER_TABLE();
2357: l_task_id := JTF_NUMBER_TABLE();
2358: l_material_account := JTF_NUMBER_TABLE();
2359: l_material_variance_account:= JTF_NUMBER_TABLE();
2360: l_location_id := JTF_NUMBER_TABLE();
2361:
2362: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2363: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling the user hook procedure csd_logistics_cuhk.source_parts');

Line 2360: l_location_id := JTF_NUMBER_TABLE();

2356: l_project_id := JTF_NUMBER_TABLE();
2357: l_task_id := JTF_NUMBER_TABLE();
2358: l_material_account := JTF_NUMBER_TABLE();
2359: l_material_variance_account:= JTF_NUMBER_TABLE();
2360: l_location_id := JTF_NUMBER_TABLE();
2361:
2362: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2363: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling the user hook procedure csd_logistics_cuhk.source_parts');
2364: END IF;

Line 2405: l_wip_entity_id_tbl := JTF_NUMBER_TABLE();

2401: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2402: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Copying the input parameters into the local variables');
2403: END IF;
2404:
2405: l_wip_entity_id_tbl := JTF_NUMBER_TABLE();
2406: l_item_id_tbl := JTF_NUMBER_TABLE();
2407: l_item_description_tbl := JTF_VARCHAR2_TABLE_100();
2408: l_uom_code_tbl := JTF_VARCHAR2_TABLE_100();
2409: l_quantity_tbl := JTF_NUMBER_TABLE();

Line 2406: l_item_id_tbl := JTF_NUMBER_TABLE();

2402: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Copying the input parameters into the local variables');
2403: END IF;
2404:
2405: l_wip_entity_id_tbl := JTF_NUMBER_TABLE();
2406: l_item_id_tbl := JTF_NUMBER_TABLE();
2407: l_item_description_tbl := JTF_VARCHAR2_TABLE_100();
2408: l_uom_code_tbl := JTF_VARCHAR2_TABLE_100();
2409: l_quantity_tbl := JTF_NUMBER_TABLE();
2410: l_source_org_id_tbl := JTF_NUMBER_TABLE();

Line 2409: l_quantity_tbl := JTF_NUMBER_TABLE();

2405: l_wip_entity_id_tbl := JTF_NUMBER_TABLE();
2406: l_item_id_tbl := JTF_NUMBER_TABLE();
2407: l_item_description_tbl := JTF_VARCHAR2_TABLE_100();
2408: l_uom_code_tbl := JTF_VARCHAR2_TABLE_100();
2409: l_quantity_tbl := JTF_NUMBER_TABLE();
2410: l_source_org_id_tbl := JTF_NUMBER_TABLE();
2411: l_source_subinv_tbl := JTF_VARCHAR2_TABLE_100();
2412: l_op_seq_num_tbl := JTF_NUMBER_TABLE();
2413: x_requisition_type := JTF_VARCHAR2_TABLE_100();

Line 2410: l_source_org_id_tbl := JTF_NUMBER_TABLE();

2406: l_item_id_tbl := JTF_NUMBER_TABLE();
2407: l_item_description_tbl := JTF_VARCHAR2_TABLE_100();
2408: l_uom_code_tbl := JTF_VARCHAR2_TABLE_100();
2409: l_quantity_tbl := JTF_NUMBER_TABLE();
2410: l_source_org_id_tbl := JTF_NUMBER_TABLE();
2411: l_source_subinv_tbl := JTF_VARCHAR2_TABLE_100();
2412: l_op_seq_num_tbl := JTF_NUMBER_TABLE();
2413: x_requisition_type := JTF_VARCHAR2_TABLE_100();
2414:

Line 2412: l_op_seq_num_tbl := JTF_NUMBER_TABLE();

2408: l_uom_code_tbl := JTF_VARCHAR2_TABLE_100();
2409: l_quantity_tbl := JTF_NUMBER_TABLE();
2410: l_source_org_id_tbl := JTF_NUMBER_TABLE();
2411: l_source_subinv_tbl := JTF_VARCHAR2_TABLE_100();
2412: l_op_seq_num_tbl := JTF_NUMBER_TABLE();
2413: x_requisition_type := JTF_VARCHAR2_TABLE_100();
2414:
2415: l_wip_entity_id_tbl.EXTEND(p_wip_entity_id_tbl.COUNT);
2416: l_item_id_tbl.EXTEND(p_wip_entity_id_tbl.COUNT);

Line 2795: l_requisition_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2791: l_ir_operating_unit NUMBER := p_ir_operating_unit;
2792: l_so_operating_unit NUMBER := p_so_operating_unit;
2793: l_success BOOLEAN;
2794: l_request_id NUMBER;
2795: l_requisition_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2796: l_authorization JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2797: l_req_type JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2798: l_create_iso BOOLEAN := TRUE;
2799: l_dummy VARCHAR2(1);