DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on JTF_VARCHAR2_TABLE_100

Line 2293: l_item_description_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
2297: l_source_subinv_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 2294: l_uom_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
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();

Line 2297: l_source_subinv_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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;
2301:

Line 2303: x_requisition_type JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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;
2303: x_requisition_type JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2304: x_op_created VARCHAR2(1);
2305:
2306: begin
2307: savepoint create_requisition;

Line 2407: l_item_description_tbl := JTF_VARCHAR2_TABLE_100();

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();
2411: l_source_subinv_tbl := JTF_VARCHAR2_TABLE_100();

Line 2408: l_uom_code_tbl := JTF_VARCHAR2_TABLE_100();

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();
2411: l_source_subinv_tbl := JTF_VARCHAR2_TABLE_100();
2412: l_op_seq_num_tbl := JTF_NUMBER_TABLE();

Line 2411: l_source_subinv_tbl := JTF_VARCHAR2_TABLE_100();

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:
2415: l_wip_entity_id_tbl.EXTEND(p_wip_entity_id_tbl.COUNT);

Line 2413: x_requisition_type := 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);
2417: l_item_description_tbl.EXTEND(p_wip_entity_id_tbl.COUNT);

Line 2796: l_authorization JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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);
2800: x_phase VARCHAR2(15);

Line 2797: l_req_type JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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);
2800: x_phase VARCHAR2(15);
2801: x_status VARCHAR2(10);