The following lines contain the word 'select', 'insert', 'update' or 'delete':
should be inserted.
*/
PROCEDURE Process_Scheduling_Request
( p_request_ind IN NUMBER
,p_request_rec IN OE_Order_PUB.request_rec_type
,x_return_status OUT NOCOPY VARCHAR2);
,p_delete IN Varchar2 default FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2)
IS
cursor included_lines_cur(p_header_id in number) is
select line_id
from oe_order_lines_all
where header_id = p_header_id
and item_type_code = 'INCLUDED';
l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
l_updated_options_tbl OE_Order_PUB.request_tbl_type;
OE_DELAYED_REQUESTS_UTIL.Insert_Set
(p_request_rec => l_request_rec,
x_return_status => l_return_status);
ELSIF l_request_type = OE_GLOBALS.G_INSERT_INTO_SETS then
IF l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
/* Commenting out nocopy per Rupal */
null;
/* OE_Process_Models.Insert_Into_Line_Sets
(p_line_id =>l_entity_id
,p_top_model_line_id =>l_request_rec.param2
,p_set_type => 'ALL'
,x_return_status =>l_return_status
); */
OE_GLOBALS.G_INSERT_RMA then
OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_SCREDIT_ADJUSTMENT
( x_return_status =>l_return_status
,p_line_id => l_entity_id
);
OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_OPTIONS_INCLUDED
( x_return_status =>l_return_status
,p_line_id => l_entity_id
);
IF NOT((l_request_rec.param1 = OE_GLOBALS.G_OPR_UPDATE and
nvl(l_request_rec.param2,'USER') = 'SYSTEM' and
NVL(l_request_rec.param3,'X') = 'SPLIT')
OR
(l_request_rec.param1 = OE_GLOBALS.G_OPR_CREATE AND
l_request_rec.param4 IS NOT NULL AND
nvl(l_request_rec.param2, 'USER') = 'SYSTEM'))
THEN
OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_LOT_SERIAL
( x_return_status =>l_return_status
,p_line_id => l_entity_id
);
ELSIF l_request_rec.request_type = OE_GLOBALS.G_UPDATE_SHIPPING THEN
OE_Delayed_Requests_UTIL.Update_Shipping
( p_update_shipping_tbl => g_delayed_requests
, p_line_id => l_request_rec.entity_id
, p_operation => l_request_rec.request_unique_key1
, x_return_status => l_return_status
);
ELSIF l_request_rec.request_type = OE_GLOBALS.G_UPDATE_REQUISITION THEN
IF NVL(l_request_rec.param2,'N') = 'Y' THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('Requisition Header Cancellation is TRUE',5);
OE_Delayed_Requests_UTIL.Update_Requisition_Info
( P_Requisition_Header_id => l_request_rec.request_unique_key2
, P_Requisition_Line_id => l_request_rec.request_unique_key3
, P_Header_id => l_header_id
, p_Line_id => l_line_id
, p_Line_ids => l_request_rec.long_param1
, p_num_records => l_request_rec.param3
, P_Quantity_Change => l_request_rec.param1
, P_Quantity2_Change => l_request_rec.param4 --Bug 14211120
, P_New_Schedule_Ship_Date => l_request_rec.date_param1
, P_Cancel_order => l_cancel_order -- Param2
, X_Return_Status => l_return_status
);
ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('upd: processed with cfg val', 3);
ELSIF l_request_type = OE_GLOBALS.G_DELETE_OPTION THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('del: processed with cfg val', 3);
IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION OR
G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
THEN
IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION
AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
THEN
l_d_index := l_d_index + 1;
l_deleted_options_tbl(l_d_index) :=
g_delayed_requests(K);
IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
THEN
l_u_index := l_u_index + 1;
l_updated_options_tbl(l_u_index) :=
g_delayed_requests(K);
, p_deleted_options_tbl => l_deleted_options_tbl
, p_updated_options_tbl => l_updated_options_tbl
, x_return_status => l_return_status
);
oe_debug_pub.add('deleteing after success ', 3);
OE_GLOBALS.G_DELETE_OPTION OR
G_Delayed_Requests(K).request_type =
OE_GLOBALS.G_UPDATE_OPTION ) AND
G_Delayed_Requests(K).param1 = l_request_rec.entity_id
THEN
G_Delayed_Requests.delete(K);
oe_debug_pub.add('deleteing after success ', 3);
G_Delayed_Requests.delete(K);
l_sch_set_tbl.delete;
l_sch_set_tbl.delete;
OE_GLOBALS.G_INSERT_SERVICE then
OE_DELAYED_REQUESTS_UTIL.INSERT_SERVICE_FOR_OPTIONS
( x_return_status => l_return_status
, p_serviced_line_id => l_entity_id
);
g_delayed_requests.delete(l_prc_adj_index);
ELSIF l_request_type = OE_GLOBALS.G_UPDATE_SERVICE THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('CSH-- Before calls OE_Service_Util.cascade_changes', 1);
ELSIF l_request_type = OE_GLOBALS.G_DELETE_CHARGES THEN
OE_Header_Util.cancel_header_charges
(
p_header_id => l_request_rec.entity_id,
--p_x_line_id => to_number(l_request_rec.param1),
x_return_status => l_return_status
);
g_delayed_requests.delete(K);
g_delayed_requests.delete(K);
g_delayed_requests.delete(l_count);
OE_GLOBALS.G_DELETE_SET THEN
l_set_id := l_request_rec.param1;
OE_GLOBALS.G_DELETE_SET)
AND G_Delayed_Requests(K).param1 = l_set_id
AND K <> p_request_ind THEN
g_delayed_requests.delete(K);
oe_set_util.Delete_Set(p_request_rec => l_request_rec
, x_return_status => l_return_status);
oe_debug_pub.add('Delete Set Return Status ' || l_return_status,1);
ELSIF l_request_type = OE_GLOBALS.G_UPDATE_COMMITMENT THEN
OE_Commitment_Pvt.update_commitment
( p_line_id => l_request_rec.entity_id
,x_return_status => l_return_status
);
ELSIF l_request_type = OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('OEXVREQB param1 is: '||l_request_rec.param1,3);
OE_Commitment_Pvt.update_commitment_applied
( p_line_id => l_request_rec.entity_id
,p_amount => l_request_rec.param1
,p_header_id => l_request_rec.param2
,p_commitment_id => l_request_rec.param3
,x_return_status => l_return_status
);
oe_debug_pub.add('Executing Delete_Changed_Lines delayed request');
Oe_Line_Adj_Util.Delete_Changed_Lines_Tbl;
oe_debug_pub.add('After Delete_Changed_Lines delayed request');
ELSIF l_request_type = OE_GLOBALS.G_UPDATE_HDR_PAYMENT then
IF l_debug_level > 0 THEN
oe_debug_pub.add('param1 is : ' || l_request_rec.param1);
AND l_request_rec.param1 = 'UPDATE_LINE' THEN
payment_line_id := l_request_rec.entity_id;
oe_debug_pub.add('header id for update_hdr_payment is : ' || payment_header_id,3);
oe_debug_pub.add('line id for update_hdr_payment is : ' || payment_line_id,3);
OE_PrePayment_Pvt.Update_Hdr_Payment (
p_header_id => payment_header_id
, p_action => l_request_rec.param1
, p_line_id => payment_line_id
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
p_calling_action => 'UPDATE',
p_amount => null,
p_delayed_request=> FND_API.G_TRUE,
x_msg_data => l_msg_data,
x_msg_count => l_msg_count,
x_return_status => l_return_status);
ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENT_HOLD THEN
IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
payment_line_id := l_request_rec.entity_id;
oe_debug_pub.add('header id for delete_payment_hold is : ' || payment_header_id,3);
oe_debug_pub.add('line id for delete_payment_hold is : ' || payment_line_id,3);
OE_PrePayment_Pvt.Delete_Payment_Hold
( p_line_id => payment_line_id
, p_header_id => payment_header_id
, p_hold_type => l_request_rec.param1
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENTS THEN
IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
payment_line_id := l_request_rec.entity_id;
oe_debug_pub.add('header id for delete_payments is : ' || payment_header_id,3);
oe_debug_pub.add('line id for delete_payments is : ' || payment_line_id,3);
OE_PrePayment_Pvt.Delete_Payments
( p_line_id => payment_line_id
, p_header_id => payment_header_id
, p_invoice_to_org_id => old_invoice_to_org_id
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
IF (p_delete = FND_API.G_TRUE) then
G_Delayed_Requests.Delete(p_request_ind);
BUG 1794544 - do not delete from req entities table
, delete table in the end when all requests are processed
This to improve performance as this search loops through
the entire pl/sql table which becomes very large with
greater number of lines being processed
-- Delete all the records in the requesting entities table
-- that have this request.
l_req_entity_ind := G_Requesting_Entities.First;
G_Requesting_Entities.Delete(l_req_entity_ind);
IF (p_delete = FND_API.G_TRUE)
AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
-- Bug 11811300 starts
IF G_Delayed_Requests(p_request_ind).request_type IN
(OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
-- Bug 11811300 ends
THEN -- 9714072
G_Delayed_Requests.Delete(p_request_ind);
IF (p_delete = FND_API.G_TRUE)
AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
-- Bug 11811300 starts
IF G_Delayed_Requests(p_request_ind).request_type IN
(OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
-- Bug 11811300 ends
THEN -- 9714072
G_Delayed_Requests.Delete(p_request_ind);
IF (p_delete = FND_API.G_TRUE)
AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
-- Bug 11811300 starts
IF G_Delayed_Requests(p_request_ind).request_type IN
(OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
-- Bug 11811300 ends
THEN -- 9714072
G_Delayed_Requests.Delete(p_request_ind);
IF (p_delete = FND_API.G_TRUE)
AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
-- Bug 11811300 starts
IF G_Delayed_Requests(p_request_ind).request_type IN
(OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
-- Bug 11811300 ends
THEN -- 9714072
G_Delayed_Requests.Delete(p_request_ind);
OE_GLOBALS.G_UPDATE_OPTION THEN
IF l_debug_level > 0 THEN
OE_Debug_PUB.ADD('update option, orig qty '||
g_delayed_requests(l_request_ind).param4, 3);
ELSIF p_request_type = OE_GLOBALS.G_UPDATE_REQUISITION THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('Type: G_UPDATE_REQUISITION, retain old parameter values',5);
ELSE -- insert the new request
IF l_debug_level > 0 THEN
OE_Debug_PUB.ADD('New request inserted');
Procedure Delete_Request(p_entity_code IN VARCHAR2
,p_entity_id IN NUMBER
,p_request_Type IN VARCHAR2
,p_request_unique_key1 IN VARCHAR2 := NULL
,p_request_unique_key2 IN VARCHAR2 := NULL
,p_request_unique_key3 IN VARCHAR2 := NULL
,p_request_unique_key4 IN VARCHAR2 := NULL
,p_request_unique_key5 IN VARCHAR2 := NULL
,x_return_status OUT NOCOPY VARCHAR2)
IS
l_request_search_rslt Varchar2(1);
oe_debug_pub.add('Entering Procedure Delete_Request in Package OE_Delayed_Requests_Pvt');
if l_request_search_rslt = FND_API.G_TRUE -- delete the request
then
G_Delayed_Requests.Delete(l_request_ind);
BUG 1794544 - do not delete from req entities table
, delete table in the end when all requests are processed
This to improve performance as this search loops through
the entire pl/sql table which becomes very large with
greater number of lines being processed
-- Delete all the records in the requesting entities table
-- that have this request.
l_req_entity_ind := G_Requesting_Entities.First;
G_Requesting_Entities.Delete(l_req_entity_ind);
,'DeleteRequest');
End Delete_Request;
G_Delayed_Requests.DELETE;
g_requesting_entities.DELETE;
OE_Config_Schedule_Pvt.Delete_Attribute_Changes;
Oe_Line_Adj_Util.Delete_Changed_Lines_Tbl;
OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.DELETE;
,p_delete IN Varchar2 Default
FND_API.G_TRUE
,x_return_status OUT NOCOPY Varchar2)
IS
l_request_ind Number;
,p_delete => p_delete
,x_return_status => l_return_status
);
,p_delete in Varchar2 Default FND_API.G_TRUE
,x_return_status OUT NOCOPY Varchar2) IS
l_return_status Varchar2(30);
,p_delete => p_delete
,x_return_status => l_return_status
);
,p_delete in Varchar2 Default FND_API.G_TRUE
,x_return_status OUT NOCOPY Varchar2
) IS
l_return_status Varchar2(30);
,p_delete => p_delete
,x_return_status => l_return_status
);
G_Delayed_Requests.DELETE(l_entity_id_tbl(l_count).request_ind);
BUG 1794544 - do not delete from req entities table
, delete table in the end when all requests are processed
This to improve performance as this search loops through
the entire pl/sql table which becomes very large with
greater number of lines being processed
l_req_entity_ind := G_Requesting_Entities.First;
G_Requesting_Entities.Delete(l_req_entity_ind);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
(p_request_type => OE_GLOBALS.G_INSERT_INTO_SETS
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
, p_delete => FND_API.G_TRUE
, x_return_status => l_return_status );
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
(p_request_type => OE_GLOBALS.G_INSERT_RMA
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
(p_request_type => OE_GLOBALS.G_INSERT_SERVICE
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
(p_request_type => OE_GLOBALS.G_DELETE_CHARGES
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
(p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
(p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
(p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
(p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
( p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
, p_delete => FND_API.G_TRUE
, x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
SELECT order_source_id, orig_sys_document_ref, change_sequence,
source_document_type_id, source_document_id
INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
l_source_document_type_id, l_source_document_id
FROM OE_ORDER_HEADERS_ALL
WHERE header_id = l_request_rec.entity_id;
SELECT order_source_id, orig_sys_document_ref, change_sequence,
source_document_type_id, source_document_id, orig_sys_line_ref,
source_document_line_id, orig_sys_shipment_ref, header_id
INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
FROM OE_ORDER_LINES_ALL
WHERE line_id = l_request_rec.entity_id;
SELECT header_id
INTO l_header_id
FROM oe_price_adjustments
WHERE price_adjustment_id = l_request_rec.entity_id;
SELECT order_source_id, orig_sys_document_ref, change_sequence,
source_document_type_id, source_document_id
INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
l_source_document_type_id, l_source_document_id
FROM OE_ORDER_HEADERS_ALL
WHERE header_id = l_header_id;
SELECT line_id
INTO l_line_id
FROM oe_price_adjustments
WHERE price_adjustment_id = l_request_rec.entity_id;
SELECT order_source_id, orig_sys_document_ref, change_sequence,
source_document_type_id, source_document_id, orig_sys_line_ref,
source_document_line_id, orig_sys_shipment_ref, header_id
INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
FROM OE_ORDER_LINES_ALL
WHERE line_id = l_line_id;
SELECT header_id
INTO l_header_id
FROM oe_sales_credits
WHERE sales_credit_id = l_request_rec.entity_id;
SELECT order_source_id, orig_sys_document_ref, change_sequence,
source_document_type_id, source_document_id
INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
l_source_document_type_id, l_source_document_id
FROM OE_ORDER_HEADERS_ALL
WHERE header_id = l_header_id;
SELECT line_id
INTO l_line_id
FROM oe_sales_credits
WHERE sales_credit_id = l_request_rec.entity_id;
SELECT order_source_id, orig_sys_document_ref, change_sequence,
source_document_type_id, source_document_id, orig_sys_line_ref,
source_document_line_id, orig_sys_shipment_ref, header_id
INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
FROM OE_ORDER_LINES_ALL
WHERE line_id = l_line_id;
OE_MSG_PUB.update_msg_context(
p_header_id => l_request_rec.entity_id);
OE_MSG_PUB.update_msg_context(
p_line_id => l_request_rec.entity_id);
Procedure Delete_Reqs_for_Deleted_Entity ( p_entity_code IN Varchar2
, p_delete_against IN BOOLEAN := TRUE
, p_entity_id in Number := NULL
, x_return_status OUT NOCOPY Varchar2)
IS
i number;
request_delete BOOLEAN;
oe_debug_pub.add('In Delete_Reqs_for_Deleted_Entity');
IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_DELETE_OPTION) THEN --Bug # 12316022
config_req_id := i;
oe_debug_pub.add('Delete above request');
-- delete records in requesting entity tables with this request
j := G_Requesting_Entities.first;
G_Requesting_Entities.Delete(j);
-- delete the delayed request
G_Delayed_Requests.Delete(i);
IF NOT p_delete_against THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('Delete against is FALSE');
-- initialize request delete to TRUE
request_delete := TRUE;
-- set the delete to FALSE if there are other entities that
-- logged the same request but if the same entity has logged this
-- request, then delete in the requesting entities table
j := G_Requesting_Entities.first;
G_Requesting_Entities.Delete(j);
request_delete := FALSE;
IF request_delete
AND G_Delayed_Requests.Exists(req_ind) THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('Delete following request =>');
G_Delayed_Requests.Delete(req_ind);
,'Delete_Reqs_for_Deleted_Entity');
End Delete_Reqs_for_Deleted_Entity;
SELECT ato_line_id
INTO l_ato_line_id
FROM oe_order_lines
WHERE line_id = G_Delayed_Requests(K).entity_id;
G_Delayed_Requests.DELETE(K);
SELECT ato_line_id
INTO l_ato_line_id
FROM oe_order_lines
WHERE line_id = G_Delayed_Requests(K).entity_id;
G_Delayed_Requests.DELETE(K);
delete_request(p_entity_code => p_request_rec.entity_code,
p_entity_id => p_request_rec.entity_id,
p_request_type => p_request_rec.request_type,
p_request_unique_key1 => 'BATCH',
p_request_unique_key2 => 'Y',
x_return_status => l_return_status);
oe_debug_pub.add('delete all other price_order request.',1);
delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_request_rec.entity_id,
p_request_type => p_request_rec.request_type,
p_request_unique_key1 => 'ORDER',
x_return_status => l_return_status);
delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_request_rec.entity_id,
p_request_type => p_request_rec.request_type,
p_request_unique_key1 => 'BATCH',
x_return_status => l_return_status);
delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_request_rec.entity_id,
p_request_type => p_request_rec.request_type,
p_request_unique_key1 => 'ORDER,BOOK',
x_return_status => l_return_status);
delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
p_entity_id => p_request_rec.entity_id,
p_request_type => p_request_rec.request_type,
p_request_unique_key1 => 'BATCH,BOOK',
x_return_status => l_return_status);
oe_debug_pub.add('need to have two separate requests ORDER,BOOK + N and LINE + Y and delete BATCH,BOOK + Y',1);
delete_request(p_entity_code => p_request_rec.entity_code,
p_entity_id => p_request_rec.entity_id,
p_request_type => p_request_rec.request_type,
p_request_unique_key1 => 'BATCH,BOOK',
p_request_unique_key2 => 'Y',
x_return_status => l_return_status);
oe_debug_pub.add('Delete Line',3);
delete_request(p_entity_code => p_request_rec.entity_code,
p_entity_id => p_request_rec.entity_id,
p_request_type => p_request_rec.request_type,
p_request_unique_key1 => 'LINE',
p_request_unique_key2 => NULL,
x_return_status => l_return_status);