DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on INV_RESERVATION_GLOBAL

Line 1061: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1057: l_return_status VARCHAR2(3);
1058: l_msg_count NUMBER;
1059: l_init_msg_lst VARCHAR2(1) := fnd_api.g_true;
1060: l_msg_data VARCHAR2(2000);
1061: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1062: l_serial_number inv_reservation_global.serial_number_tbl_type;
1063: BEGIN
1064: x_return_status := FND_API.G_RET_STS_SUCCESS;
1065: l_rsv_rec.reservation_id := p_reserv_id ;

Line 1062: l_serial_number inv_reservation_global.serial_number_tbl_type;

1058: l_msg_count NUMBER;
1059: l_init_msg_lst VARCHAR2(1) := fnd_api.g_true;
1060: l_msg_data VARCHAR2(2000);
1061: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1062: l_serial_number inv_reservation_global.serial_number_tbl_type;
1063: BEGIN
1064: x_return_status := FND_API.G_RET_STS_SUCCESS;
1065: l_rsv_rec.reservation_id := p_reserv_id ;
1066: INV_RESERVATION_PUB.delete_reservation(l_api_version_number

Line 3406: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

3402: l_api_version_number number :=1;
3403: l_init_msg_lst varchar2(1) := fnd_api.g_true;
3404: x_msg_count number;
3405: -- x_msg_data varchar2(128);
3406: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3407: l_serial_number inv_reservation_global.serial_number_tbl_type;
3408: x_serial_number inv_reservation_global.serial_number_tbl_type;
3409: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3410: l_force_reservation_flag varchar2(1) := fnd_api.g_true;

Line 3407: l_serial_number inv_reservation_global.serial_number_tbl_type;

3403: l_init_msg_lst varchar2(1) := fnd_api.g_true;
3404: x_msg_count number;
3405: -- x_msg_data varchar2(128);
3406: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3407: l_serial_number inv_reservation_global.serial_number_tbl_type;
3408: x_serial_number inv_reservation_global.serial_number_tbl_type;
3409: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3410: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
3411: l_validation_flag varchar2(1) := fnd_api.g_true;

Line 3408: x_serial_number inv_reservation_global.serial_number_tbl_type;

3404: x_msg_count number;
3405: -- x_msg_data varchar2(128);
3406: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3407: l_serial_number inv_reservation_global.serial_number_tbl_type;
3408: x_serial_number inv_reservation_global.serial_number_tbl_type;
3409: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3410: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
3411: l_validation_flag varchar2(1) := fnd_api.g_true;
3412: l_source_type_id NUMBER;

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

3455: l_rsv_rec.detailed_quantity := null;
3456: l_rsv_rec.autodetail_group_id := NULL;
3457: l_rsv_rec.external_source_code := NULL;
3458: l_rsv_rec.external_source_line_id := NULL;
3459: l_rsv_rec.supply_source_type_id := 13; --inv_reservation_global.g_source_type_internal_req;
3460: l_rsv_rec.supply_source_header_id := NULL;
3461: l_rsv_rec.supply_source_line_id := NULL;
3462: l_rsv_rec.supply_source_name := NULL;
3463: l_rsv_rec.supply_source_line_detail := NULL;

Line 3546: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

3542: I NUMBER;
3543: l_api_version_number number :=1;
3544: l_init_msg_lst varchar2(1) := fnd_api.g_true;
3545: -- x_msg_data varchar2(128);
3546: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3547: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3548: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
3549: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
3550: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;

Line 3547: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

3543: l_api_version_number number :=1;
3544: l_init_msg_lst varchar2(1) := fnd_api.g_true;
3545: -- x_msg_data varchar2(128);
3546: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3547: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3548: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
3549: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
3550: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3551: l_is_transfer_supply varchar2(1) := fnd_api.g_true;

Line 3548: l_old_serial_number inv_reservation_global.serial_number_tbl_type;

3544: l_init_msg_lst varchar2(1) := fnd_api.g_true;
3545: -- x_msg_data varchar2(128);
3546: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3547: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3548: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
3549: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
3550: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3551: l_is_transfer_supply varchar2(1) := fnd_api.g_true;
3552: l_validation_flag varchar2(1) := fnd_api.g_true;

Line 3549: l_new_serial_number inv_reservation_global.serial_number_tbl_type;

3545: -- x_msg_data varchar2(128);
3546: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3547: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3548: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
3549: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
3550: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3551: l_is_transfer_supply varchar2(1) := fnd_api.g_true;
3552: l_validation_flag varchar2(1) := fnd_api.g_true;
3553: l_source_type_id NUMBER;

Line 5702: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

5698: l_api_version_number number :=1;
5699: l_init_msg_lst varchar2(1) := fnd_api.g_true;
5700: x_msg_count number;
5701: -- x_msg_data varchar2(128);
5702: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5703: l_serial_number inv_reservation_global.serial_number_tbl_type;
5704: x_serial_number inv_reservation_global.serial_number_tbl_type;
5705: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5706: l_force_reservation_flag varchar2(1) := fnd_api.g_true;

Line 5703: l_serial_number inv_reservation_global.serial_number_tbl_type;

5699: l_init_msg_lst varchar2(1) := fnd_api.g_true;
5700: x_msg_count number;
5701: -- x_msg_data varchar2(128);
5702: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5703: l_serial_number inv_reservation_global.serial_number_tbl_type;
5704: x_serial_number inv_reservation_global.serial_number_tbl_type;
5705: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5706: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
5707: l_validation_flag varchar2(1) := fnd_api.g_true;

Line 5704: x_serial_number inv_reservation_global.serial_number_tbl_type;

5700: x_msg_count number;
5701: -- x_msg_data varchar2(128);
5702: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5703: l_serial_number inv_reservation_global.serial_number_tbl_type;
5704: x_serial_number inv_reservation_global.serial_number_tbl_type;
5705: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5706: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
5707: l_validation_flag varchar2(1) := fnd_api.g_true;
5708: l_source_type_id NUMBER;

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

5740: l_rsv_rec.detailed_quantity := null;
5741: l_rsv_rec.autodetail_group_id := NULL;
5742: l_rsv_rec.external_source_code := NULL;
5743: l_rsv_rec.external_source_line_id := NULL;
5744: l_rsv_rec.supply_source_type_id := 13; --inv_reservation_global.g_source_type_internal_req;
5745: l_rsv_rec.supply_source_header_id := NULL;
5746: l_rsv_rec.supply_source_line_id := NULL;
5747: l_rsv_rec.supply_source_name := NULL;
5748: l_rsv_rec.supply_source_line_detail := NULL;