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.AHL_RSV_RESERVATIONS_PVT dependencies on INV_RESERVATION_GLOBAL

Line 25: x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

21:
22: PROCEDURE INITIALIZE_CREATE_REC(
23: p_schedule_material_id IN NUMBER,
24: p_serial_number IN VARCHAR2,
25: x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
26: x_return_status OUT NOCOPY VARCHAR2
27: );
28:
29: ------------------------------------------------------------------------------------------------------------------

Line 87: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

83: WHERE asmt.schedule_material_id = c_scheduled_material_id;
84:
85: l_mtl_req_dtls_rec get_mtl_req_dtls_csr%ROWTYPE;
86:
87: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
88: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
89:
90: -- To fetch the instance details when you have the inventory item id, serial number and the organization id
91: -- inventory item id is from the Ahl Schedule Materials table

Line 88: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

84:
85: l_mtl_req_dtls_rec get_mtl_req_dtls_csr%ROWTYPE;
86:
87: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
88: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
89:
90: -- To fetch the instance details when you have the inventory item id, serial number and the organization id
91: -- inventory item id is from the Ahl Schedule Materials table
92: -- organization id from the Ahl Schedule Materials table

Line 135: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

131: l_reservation_id NUMBER;
132: l_reserved_quantity NUMBER;
133:
134:
135: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
136: l_x_quantity_reserved NUMBER;
137: l_x_reservation_id NUMBER;
138:
139: -- for updating the reservations

Line 140: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

136: l_x_quantity_reserved NUMBER;
137: l_x_reservation_id NUMBER;
138:
139: -- for updating the reservations
140: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
141: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
142: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
143:
144: BEGIN

Line 141: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

137: l_x_reservation_id NUMBER;
138:
139: -- for updating the reservations
140: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
141: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
142: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
143:
144: BEGIN
145: -- Standard start of API savepoint

Line 142: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

138:
139: -- for updating the reservations
140: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
141: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
142: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
143:
144: BEGIN
145: -- Standard start of API savepoint
146: SAVEPOINT CREATE_RESERVATION_PVT;

Line 521: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

517:
518: l_requested_date DATE;
519: l_reservation_id NUMBER;
520: l_x_quantity_reserved NUMBER := NULL;
521: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
522: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
523: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
524: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
525: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

Line 522: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

518: l_requested_date DATE;
519: l_reservation_id NUMBER;
520: l_x_quantity_reserved NUMBER := NULL;
521: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
522: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
523: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
524: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
525: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
526:

Line 523: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

519: l_reservation_id NUMBER;
520: l_x_quantity_reserved NUMBER := NULL;
521: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
522: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
523: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
524: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
525: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
526:
527: -- Variables to check the log level according to the coding standards

Line 524: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

520: l_x_quantity_reserved NUMBER := NULL;
521: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
522: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
523: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
524: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
525: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
526:
527: -- Variables to check the log level according to the coding standards
528: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 525: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

521: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
522: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
523: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
524: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
525: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
526:
527: -- Variables to check the log level according to the coding standards
528: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
529: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 847: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

843: l_msg_count NUMBER;
844: l_msg_data VARCHAR2(2000);
845:
846:
847: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
848: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
849: l_total_relieved_qty NUMBER :=0;
850:
851: l_ret_value NUMBER;

Line 848: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

844: l_msg_data VARCHAR2(2000);
845:
846:
847: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
848: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
849: l_total_relieved_qty NUMBER :=0;
850:
851: l_ret_value NUMBER;
852: l_reservation_id NUMBER;

Line 1205: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1201: l_msg_count NUMBER;
1202: l_msg_data VARCHAR2(2000);
1203: l_commit VARCHAR2(1) := 'F';
1204:
1205: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1206: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1207: l_reservation_id NUMBER;
1208: l_reserved_quantity NUMBER;
1209: l_x_primary_relieved_quantity NUMBER;

Line 1206: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

1202: l_msg_data VARCHAR2(2000);
1203: l_commit VARCHAR2(1) := 'F';
1204:
1205: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1206: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1207: l_reservation_id NUMBER;
1208: l_reserved_quantity NUMBER;
1209: l_x_primary_relieved_quantity NUMBER;
1210: l_x_primary_remain_quantity NUMBER;

Line 1582: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1578: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1579:
1580: l_reservation_id NUMBER;
1581: l_wip_entity_id NUMBER;
1582: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1583: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1584: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1585: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1586: l_x_to_reservation_id NUMBER;

Line 1583: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1579:
1580: l_reservation_id NUMBER;
1581: l_wip_entity_id NUMBER;
1582: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1583: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1584: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1585: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1586: l_x_to_reservation_id NUMBER;
1587:

Line 1584: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

1580: l_reservation_id NUMBER;
1581: l_wip_entity_id NUMBER;
1582: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1583: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1584: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1585: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1586: l_x_to_reservation_id NUMBER;
1587:
1588: -- Variables to check the log level according to the coding standards

Line 1585: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

1581: l_wip_entity_id NUMBER;
1582: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1583: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1584: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1585: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1586: l_x_to_reservation_id NUMBER;
1587:
1588: -- Variables to check the log level according to the coding standards
1589: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1672: l_to_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;

1668: OPEN get_wip_dtls_csr(l_get_mtl_req_dtls_rec.visit_task_id);
1669: FETCH get_wip_dtls_csr INTO l_wip_entity_id;
1670: CLOSE get_wip_dtls_csr;
1671:
1672: l_to_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;
1673: l_to_rsv_rec.demand_source_header_id := l_wip_entity_id;
1674: l_to_rsv_rec.demand_source_line_id := l_get_mtl_req_dtls_rec.operation_sequence;
1675:
1676: l_to_rsv_rec.demand_source_line_detail := l_get_mtl_req_dtls_rec.scheduled_material_id;

Line 1864: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1860: l_return_status VARCHAR2(1);
1861: l_msg_count NUMBER;
1862: l_msg_data VARCHAR2(2000);
1863:
1864: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1865: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1866: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1867: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1868: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

Line 1865: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1861: l_msg_count NUMBER;
1862: l_msg_data VARCHAR2(2000);
1863:
1864: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1865: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1866: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1867: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1868: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1869: l_x_quantity_reserved NUMBER;

Line 1866: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

1862: l_msg_data VARCHAR2(2000);
1863:
1864: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1865: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1866: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1867: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1868: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1869: l_x_quantity_reserved NUMBER;
1870:

Line 1867: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

1863:
1864: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1865: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1866: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1867: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1868: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1869: l_x_quantity_reserved NUMBER;
1870:
1871: -- Declare cursors and record variables

Line 1868: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

1864: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1865: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1866: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1867: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1868: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1869: l_x_quantity_reserved NUMBER;
1870:
1871: -- Declare cursors and record variables
1872: -- Get the all the reservation related information using the schedule material id

Line 2145: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2141: l_return_status VARCHAR2(1);
2142: l_msg_count NUMBER;
2143: l_msg_data VARCHAR2(2000);
2144:
2145: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2146: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2147: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2148: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2149: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

Line 2146: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2142: l_msg_count NUMBER;
2143: l_msg_data VARCHAR2(2000);
2144:
2145: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2146: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2147: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2148: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2149: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2150: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

Line 2147: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2143: l_msg_data VARCHAR2(2000);
2144:
2145: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2146: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2147: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2148: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2149: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2150: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2151: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

Line 2148: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

2144:
2145: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2146: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2147: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2148: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2149: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2150: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2151: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2152: l_x_quantity_reserved NUMBER;

Line 2149: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

2145: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2146: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2147: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2148: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2149: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2150: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2151: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2152: l_x_quantity_reserved NUMBER;
2153:

Line 2150: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

2146: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2147: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2148: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2149: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2150: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2151: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2152: l_x_quantity_reserved NUMBER;
2153:
2154: -- Variables to check the log level according to the coding standards

Line 2151: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

2147: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2148: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2149: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2150: l_x_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2151: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2152: l_x_quantity_reserved NUMBER;
2153:
2154: -- Variables to check the log level according to the coding standards
2155: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2261: x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

2257: ---------------------------------------------------------------------------------------------------------------------
2258: PROCEDURE INITIALIZE_CREATE_REC(
2259: p_schedule_material_id IN NUMBER,
2260: p_serial_number IN VARCHAR2,
2261: x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
2262: x_return_status OUT NOCOPY VARCHAR2
2263: )
2264: IS
2265:

Line 2389: x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

2385: x_rsv_rec.primary_reservation_quantity := NULL;
2386: x_rsv_rec.autodetail_group_id := NULL;
2387: x_rsv_rec.external_source_code := 'AHL';
2388: x_rsv_rec.external_source_line_id := NULL;
2389: x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
2390: x_rsv_rec.supply_source_header_id := NULL;
2391: x_rsv_rec.supply_source_line_id := NULL;
2392: x_rsv_rec.supply_source_name := NULL;
2393: x_rsv_rec.supply_source_line_detail := NULL;

Line 2432: x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;

2428: -- If the task is in 'released' then get the WIP entity id for demand_source_header_id
2429: OPEN get_wip_dtls_csr (l_get_mtl_req_dtls_rec.visit_task_id);
2430: FETCH get_wip_dtls_csr INTO l_get_wip_dtls_rec;
2431: CLOSE get_wip_dtls_csr;
2432: x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_wip;
2433: x_rsv_rec.demand_source_header_id := l_get_wip_dtls_rec.wip_entity_id;
2434: x_rsv_rec.demand_source_line_id := l_get_mtl_req_dtls_rec.operation_sequence;
2435: ELSIF l_get_mtl_req_dtls_rec.task_status_code = 'PLANNING' THEN
2436: -- If the task is in 'planning' then get the WIP entity id for demand_source_header_id

Line 2437: x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_inv;

2433: x_rsv_rec.demand_source_header_id := l_get_wip_dtls_rec.wip_entity_id;
2434: x_rsv_rec.demand_source_line_id := l_get_mtl_req_dtls_rec.operation_sequence;
2435: ELSIF l_get_mtl_req_dtls_rec.task_status_code = 'PLANNING' THEN
2436: -- If the task is in 'planning' then get the WIP entity id for demand_source_header_id
2437: x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_inv;
2438: x_rsv_rec.demand_source_header_id := l_get_mtl_req_dtls_rec.Visit_Task_ID;
2439: x_rsv_rec.demand_source_line_id := l_get_mtl_req_dtls_rec.rt_oper_material_id;
2440: ELSE
2441: FND_MESSAGE.set_name( 'AHL', 'AHL_RSV_ONLY_PLN_SPF_TSK' );

Line 2514: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2510: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2511:
2512: l_reservation_id NUMBER;
2513: l_wip_entity_id NUMBER;
2514: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2515: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2516: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2517: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2518: l_x_to_reservation_id NUMBER;

Line 2515: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2511:
2512: l_reservation_id NUMBER;
2513: l_wip_entity_id NUMBER;
2514: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2515: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2516: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2517: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2518: l_x_to_reservation_id NUMBER;
2519:

Line 2516: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

2512: l_reservation_id NUMBER;
2513: l_wip_entity_id NUMBER;
2514: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2515: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2516: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2517: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2518: l_x_to_reservation_id NUMBER;
2519:
2520: -- Variables to check the log level according to the coding standards

Line 2517: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

2513: l_wip_entity_id NUMBER;
2514: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2515: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2516: l_from_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2517: l_to_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
2518: l_x_to_reservation_id NUMBER;
2519:
2520: -- Variables to check the log level according to the coding standards
2521: l_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2554: l_to_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_inv;

2550: );
2551: END IF;
2552:
2553: l_from_rsv_rec.demand_source_line_detail := p_from_mat_req_id;
2554: l_to_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_inv;
2555: l_to_rsv_rec.demand_source_header_id := p_visit_task_id;
2556: l_to_rsv_rec.demand_source_line_detail := p_to_mat_req_id;
2557:
2558: IF (l_log_statement >= l_log_current_level)THEN