DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on INV_RESERVATION_GLOBAL

Line 2746: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2742: l_return_status VARCHAR2(3);
2743: l_msg_count NUMBER;
2744: l_init_msg_lst VARCHAR2(1) := fnd_api.g_true;
2745: l_msg_data VARCHAR2(2000);
2746: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2747: l_serial_number inv_reservation_global.serial_number_tbl_type;
2748: BEGIN
2749: x_return_status := FND_API.G_RET_STS_SUCCESS;
2750: l_rsv_rec.reservation_id := p_reserv_id ;

Line 2747: l_serial_number inv_reservation_global.serial_number_tbl_type;

2743: l_msg_count NUMBER;
2744: l_init_msg_lst VARCHAR2(1) := fnd_api.g_true;
2745: l_msg_data VARCHAR2(2000);
2746: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2747: l_serial_number inv_reservation_global.serial_number_tbl_type;
2748: BEGIN
2749: x_return_status := FND_API.G_RET_STS_SUCCESS;
2750: l_rsv_rec.reservation_id := p_reserv_id ;
2751: INV_RESERVATION_PUB.delete_reservation(l_api_version_number

Line 5800: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

5796: l_api_version_number number :=1;
5797: l_init_msg_lst varchar2(1) := fnd_api.g_true;
5798: x_msg_count number;
5799: -- x_msg_data varchar2(128);
5800: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5801: l_serial_number inv_reservation_global.serial_number_tbl_type;
5802: x_serial_number inv_reservation_global.serial_number_tbl_type;
5803: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5804: l_force_reservation_flag varchar2(1) := fnd_api.g_true;

Line 5801: l_serial_number inv_reservation_global.serial_number_tbl_type;

5797: l_init_msg_lst varchar2(1) := fnd_api.g_true;
5798: x_msg_count number;
5799: -- x_msg_data varchar2(128);
5800: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5801: l_serial_number inv_reservation_global.serial_number_tbl_type;
5802: x_serial_number inv_reservation_global.serial_number_tbl_type;
5803: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5804: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
5805: l_validation_flag varchar2(1) := fnd_api.g_true;

Line 5802: x_serial_number inv_reservation_global.serial_number_tbl_type;

5798: x_msg_count number;
5799: -- x_msg_data varchar2(128);
5800: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5801: l_serial_number inv_reservation_global.serial_number_tbl_type;
5802: x_serial_number inv_reservation_global.serial_number_tbl_type;
5803: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5804: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
5805: l_validation_flag varchar2(1) := fnd_api.g_true;
5806: l_source_type_id NUMBER;

Line 5865: l_rsv_rec.supply_source_type_id := 13; --inv_reservation_global.g_source_type_internal_req;

5861: l_rsv_rec.detailed_quantity := null;
5862: l_rsv_rec.autodetail_group_id := NULL;
5863: l_rsv_rec.external_source_code := NULL;
5864: l_rsv_rec.external_source_line_id := NULL;
5865: l_rsv_rec.supply_source_type_id := 13; --inv_reservation_global.g_source_type_internal_req;
5866: l_rsv_rec.supply_source_header_id := NULL;
5867: l_rsv_rec.supply_source_line_id := NULL;
5868: l_rsv_rec.supply_source_name := NULL;
5869: l_rsv_rec.supply_source_line_detail := NULL;

Line 5971: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

5967: I NUMBER;
5968: l_api_version_number number :=1;
5969: l_init_msg_lst varchar2(1) := fnd_api.g_true;
5970: -- x_msg_data varchar2(128);
5971: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5972: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5973: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
5974: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
5975: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;

Line 5972: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

5968: l_api_version_number number :=1;
5969: l_init_msg_lst varchar2(1) := fnd_api.g_true;
5970: -- x_msg_data varchar2(128);
5971: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5972: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5973: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
5974: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
5975: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5976: l_is_transfer_supply varchar2(1) := fnd_api.g_true;

Line 5973: l_old_serial_number inv_reservation_global.serial_number_tbl_type;

5969: l_init_msg_lst varchar2(1) := fnd_api.g_true;
5970: -- x_msg_data varchar2(128);
5971: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5972: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5973: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
5974: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
5975: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5976: l_is_transfer_supply varchar2(1) := fnd_api.g_true;
5977: l_validation_flag varchar2(1) := fnd_api.g_true;

Line 5974: l_new_serial_number inv_reservation_global.serial_number_tbl_type;

5970: -- x_msg_data varchar2(128);
5971: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5972: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5973: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
5974: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
5975: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5976: l_is_transfer_supply varchar2(1) := fnd_api.g_true;
5977: l_validation_flag varchar2(1) := fnd_api.g_true;
5978: l_source_type_id NUMBER;

Line 8244: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

8240: l_api_version_number number :=1;
8241: l_init_msg_lst varchar2(1) := fnd_api.g_true;
8242: x_msg_count number;
8243: -- x_msg_data varchar2(128);
8244: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
8245: l_serial_number inv_reservation_global.serial_number_tbl_type;
8246: x_serial_number inv_reservation_global.serial_number_tbl_type;
8247: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
8248: l_force_reservation_flag varchar2(1) := fnd_api.g_true;

Line 8245: l_serial_number inv_reservation_global.serial_number_tbl_type;

8241: l_init_msg_lst varchar2(1) := fnd_api.g_true;
8242: x_msg_count number;
8243: -- x_msg_data varchar2(128);
8244: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
8245: l_serial_number inv_reservation_global.serial_number_tbl_type;
8246: x_serial_number inv_reservation_global.serial_number_tbl_type;
8247: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
8248: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
8249: l_validation_flag varchar2(1) := fnd_api.g_true;

Line 8246: x_serial_number inv_reservation_global.serial_number_tbl_type;

8242: x_msg_count number;
8243: -- x_msg_data varchar2(128);
8244: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
8245: l_serial_number inv_reservation_global.serial_number_tbl_type;
8246: x_serial_number inv_reservation_global.serial_number_tbl_type;
8247: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
8248: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
8249: l_validation_flag varchar2(1) := fnd_api.g_true;
8250: l_source_type_id NUMBER;

Line 8286: l_rsv_rec.supply_source_type_id := 13; --inv_reservation_global.g_source_type_internal_req;

8282: l_rsv_rec.detailed_quantity := null;
8283: l_rsv_rec.autodetail_group_id := NULL;
8284: l_rsv_rec.external_source_code := NULL;
8285: l_rsv_rec.external_source_line_id := NULL;
8286: l_rsv_rec.supply_source_type_id := 13; --inv_reservation_global.g_source_type_internal_req;
8287: l_rsv_rec.supply_source_header_id := NULL;
8288: l_rsv_rec.supply_source_line_id := NULL;
8289: l_rsv_rec.supply_source_name := NULL;
8290: l_rsv_rec.supply_source_line_detail := NULL;