DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_DELAYED_REQUESTS_PVT

Line 2807: OE_Delayed_Requests_PVT.Delete_Request

2803:
2804: oe_debug_pub.add
2805: ('deleting req '|| p_update_shipping_tbl(l_update_shipping_index).entity_id);
2806:
2807: OE_Delayed_Requests_PVT.Delete_Request
2808: (p_entity_code => p_update_shipping_tbl(l_update_shipping_index).entity_code
2809: ,p_entity_id => p_update_shipping_tbl(l_update_shipping_index).entity_id
2810: ,p_request_Type => p_update_shipping_tbl(l_update_shipping_index).request_type
2811: ,p_request_unique_key1

Line 2875: OE_Delayed_Requests_PVT.Delete_Request

2871: oe_debug_pub.add('RUnique 1 : '||p_ship_confirmation_tbl(l_shipping_index).request_unique_key1,2);
2872: oe_debug_pub.add('Entity Id : '||to_char(p_ship_confirmation_tbl(l_shipping_index).entity_id),2);
2873: IF p_line_id <> p_ship_confirmation_tbl(l_shipping_index).entity_id THEN
2874:
2875: OE_Delayed_Requests_PVT.Delete_Request
2876: (p_entity_code => p_ship_confirmation_tbl(l_shipping_index).entity_code
2877: ,p_entity_id => p_ship_confirmation_tbl(l_shipping_index).entity_id
2878: ,p_request_Type => p_ship_confirmation_tbl(l_shipping_index).request_type
2879: ,p_request_unique_key1 => p_ship_confirmation_tbl(l_shipping_index).request_unique_key1

Line 4437: OE_Delayed_Requests_PVT.Delete_Request

4433: -- Delete the G_CASCADE_OPTIONS_SERVICE delayed request logged for the option/included lines
4434: -- this is necessary when both G_INSERT_SERVICE and G_CASCADE_OPTIONS_SERVICE requests are logged in the same session
4435: -- Execution of both will result in duplicate service lines attached to included items
4436:
4437: OE_Delayed_Requests_PVT.Delete_Request
4438: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE
4439: ,p_entity_id => l_child.line_id
4440: ,p_request_Type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE
4441: ,x_return_status => x_del_req_ret_status);

Line 5359: p_entity_id_tbl IN OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type ,

5355:
5356: END Schedule_Line;
5357:
5358: PROCEDURE Process_Tax(
5359: p_entity_id_tbl IN OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type ,
5360: x_return_status OUT NOCOPY VARCHAR2)
5361: IS
5362: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
5363: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5366: l_entity_id_tbl OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type ;

5362: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
5363: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5364: v_start NUMBER;
5365: v_end NUMBER;
5366: l_entity_id_tbl OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type ;
5367: l_tax_rec_out_tbl OM_TAX_UTIL.om_tax_out_tab_type;
5368: l_requesting_entity_id NUMBER; --TaxER
5369: l_request_ind NUMBER;
5370: l_call_credit_checking VARCHAR2(30);

Line 5425: oe_debug_pub.add( 'value count '|| OE_Delayed_Requests_PVT.G_Delayed_Requests.count);

5421: LOOP
5422: l_requesting_entity_id := p_entity_id_tbl(i).entity_id; --TaxER
5423: l_request_ind := p_entity_id_tbl(i).request_ind; --TaxER
5424: IF l_debug_level > 0 THEN
5425: oe_debug_pub.add( 'value count '|| OE_Delayed_Requests_PVT.G_Delayed_Requests.count);
5426: END IF;
5427: /* Bug # 3337661: Corrected IF stmt by using OE_GLOBALS.G_TAX_LINE */
5428: -- Front Ported for bug 3397062
5429: IF OE_Delayed_Requests_PVT.G_Delayed_Requests.exists(l_request_ind) AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).request_type = OE_GLOBALS.G_TAX_LINE THEN

Line 5429: IF OE_Delayed_Requests_PVT.G_Delayed_Requests.exists(l_request_ind) AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).request_type = OE_GLOBALS.G_TAX_LINE THEN

5425: oe_debug_pub.add( 'value count '|| OE_Delayed_Requests_PVT.G_Delayed_Requests.count);
5426: END IF;
5427: /* Bug # 3337661: Corrected IF stmt by using OE_GLOBALS.G_TAX_LINE */
5428: -- Front Ported for bug 3397062
5429: IF OE_Delayed_Requests_PVT.G_Delayed_Requests.exists(l_request_ind) AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).request_type = OE_GLOBALS.G_TAX_LINE THEN
5430: l_call_credit_checking := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).param1;
5431: END IF;
5432: IF l_debug_level > 0 THEN
5433: oe_debug_pub.add('OEXUREQB: call_credit_checking is: '||l_call_credit_checking,1);

Line 5430: l_call_credit_checking := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).param1;

5426: END IF;
5427: /* Bug # 3337661: Corrected IF stmt by using OE_GLOBALS.G_TAX_LINE */
5428: -- Front Ported for bug 3397062
5429: IF OE_Delayed_Requests_PVT.G_Delayed_Requests.exists(l_request_ind) AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).request_type = OE_GLOBALS.G_TAX_LINE THEN
5430: l_call_credit_checking := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).param1;
5431: END IF;
5432: IF l_debug_level > 0 THEN
5433: oe_debug_pub.add('OEXUREQB: call_credit_checking is: '||l_call_credit_checking,1);
5434: END IF;

Line 5515: OE_Delayed_Requests_Pvt.Log_Request( p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

5511: IF OE_Commitment_Pvt.Do_Commitment_Sequencing AND l_line_rec.commitment_id IS NOT NULL THEN
5512: IF l_debug_level > 0 THEN
5513: oe_debug_pub.add('Logging delayed request for Commitment when tax value changes.', 2);
5514: END IF;
5515: OE_Delayed_Requests_Pvt.Log_Request( p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5516: p_entity_id => l_line_rec.line_id,
5517: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5518: p_requesting_entity_id => l_line_rec.line_id,
5519: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

Line 5534: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

5530: IF OE_PrePayment_UTIL.is_prepaid_order(l_line_rec.header_id) = 'N' OR (OE_PrePayment_UTIL.is_prepaid_order(l_line_rec.header_id) = 'Y' AND l_line_rec.booked_flag ='Y' AND l_line_rec.shipped_quantity IS NULL) THEN
5531: IF l_debug_level > 0 THEN
5532: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value',2);
5533: END IF;
5534: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5535: p_entity_id => l_line_rec.header_id,
5536: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5537: p_requesting_entity_id => l_line_rec.line_id,
5538: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 5553: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

5549: AND l_line_rec.shipped_quantity IS NULL THEN
5550: IF l_debug_level > 0 THEN
5551: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value for prepaid order',2);
5552: END IF;
5553: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5554: p_entity_id => l_line_rec.header_id,
5555: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5556: p_requesting_entity_id => l_line_rec.line_id,
5557: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 5570: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

5566: IF NVL(l_payment_type_code, ' ') <> 'CREDIT_CARD' --bug 2679223
5567: AND NVL(l_call_credit_checking, 'Y') <> 'No_Credit_Checking' THEN
5568: IF NVL(l_total_tax, 0) > NVL(l_old_total_tax, 0) THEN
5569: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value',2);
5570: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5571: p_entity_id => l_line_rec.header_id,
5572: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5573: p_requesting_entity_id => l_line_rec.line_id,
5574: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 5590: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

5586: x_msg_data => l_msg_data ,
5587: x_return_status => l_return_status );
5588: IF ( l_hold_result = FND_API.G_TRUE ) THEN
5589: oe_debug_pub.add('Logging delayed request for verify payment for change in tax value and hold exist') ;
5590: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5591: p_entity_id => l_line_rec.header_id,
5592: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5593: p_requesting_entity_id => l_line_rec.line_id,
5594: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 5786: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

5782: -- lkxu, added for bug 1581188
5783: -- Logging delayed requests for Verify Payment if tax value
5784: -- has increased AND Payment Type Code is Credit Card.
5785: IF NVL(l_total_tax,0) > NVL(l_old_total_tax,0) AND l_payment_type_code = 'CREDIT_CARD' AND l_header_rec.booked_flag ='Y' THEN
5786: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5787: p_entity_id => l_header_rec.header_id,
5788: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5789: p_requesting_entity_id => l_header_rec.header_id,
5790: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 5799: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

5795: ELSIF NVL(l_total_tax,0) < NVL(l_old_total_tax,0) AND OE_PrePayment_UTIL.is_prepaid_order(l_header_rec.header_id) = 'Y' AND l_header_rec.booked_flag ='Y' AND l_payment_type_code = 'CREDIT_CARD' THEN
5796: IF l_debug_level > 0 THEN
5797: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value for prepaid order',2);
5798: END IF;
5799: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5800: p_entity_id => l_header_rec.header_id,
5801: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5802: p_requesting_entity_id => l_header_rec.header_id,
5803: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 5816: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

5812: IF NVL(l_payment_type_code, ' ') <> 'CREDIT_CARD' --bug 2679223
5813: AND NVL(l_call_credit_checking, 'Y') <> 'No_Credit_Checking' THEN
5814: IF NVL(l_total_tax, 0) > NVL(l_old_total_tax, 0) THEN
5815: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value',2);
5816: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5817: p_entity_id => l_header_rec.header_id,
5818: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5819: p_requesting_entity_id => l_header_rec.header_id,
5820: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 5823: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

5819: p_requesting_entity_id => l_header_rec.header_id,
5820: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
5821: x_return_status => l_return_status);
5822: ELSIF NVL(l_total_tax,0) < NVL(l_old_total_tax,0) THEN
5823: OE_delayed_requests_Pvt.log_request (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5824: p_entity_id => l_header_rec.header_id,
5825: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5826: p_requesting_entity_id => l_header_rec.header_id,
5827: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 6407: l_request_rec := OE_Delayed_Requests_PVT.G_Delayed_Requests(p_request_ind);

6403:
6404: Begin
6405:
6406:
6407: l_request_rec := OE_Delayed_Requests_PVT.G_Delayed_Requests(p_request_ind);
6408: l_header_id := l_request_rec.entity_id;
6409:
6410: IF l_debug_level > 0 THEN
6411: oe_debug_pub.add( 'retrieving key information from base table') ;

Line 6571: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.first;

6567: END IF;
6568: END IF; -- end of check for customer ack request
6569:
6570:
6571: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.first;
6572:
6573: --find and insert lines for that header
6574: WHILE l_count IS NOT NULL LOOP
6575:

Line 6577: IF OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).request_type = OE_GLOBALS.G_GENERATE_XML_REQ_LN

6573: --find and insert lines for that header
6574: WHILE l_count IS NOT NULL LOOP
6575:
6576: --Check to see if this is a line-level xml request for the same transaction type and header id
6577: IF OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).request_type = OE_GLOBALS.G_GENERATE_XML_REQ_LN
6578: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param1 = l_header_id
6579: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN
6580:
6581: -- add this line to the lines table for insertion

Line 6578: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param1 = l_header_id

6574: WHILE l_count IS NOT NULL LOOP
6575:
6576: --Check to see if this is a line-level xml request for the same transaction type and header id
6577: IF OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).request_type = OE_GLOBALS.G_GENERATE_XML_REQ_LN
6578: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param1 = l_header_id
6579: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN
6580:
6581: -- add this line to the lines table for insertion
6582: IF l_debug_level > 0 THEN

Line 6579: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN

6575:
6576: --Check to see if this is a line-level xml request for the same transaction type and header id
6577: IF OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).request_type = OE_GLOBALS.G_GENERATE_XML_REQ_LN
6578: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param1 = l_header_id
6579: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN
6580:
6581: -- add this line to the lines table for insertion
6582: IF l_debug_level > 0 THEN
6583: oe_debug_pub.add( 'LINE_ID FOR ACKNOWLEDGMENT => ' || OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id ) ;

Line 6583: oe_debug_pub.add( 'LINE_ID FOR ACKNOWLEDGMENT => ' || OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id ) ;

6579: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN
6580:
6581: -- add this line to the lines table for insertion
6582: IF l_debug_level > 0 THEN
6583: oe_debug_pub.add( 'LINE_ID FOR ACKNOWLEDGMENT => ' || OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id ) ;
6584: END IF;
6585:
6586: If l_line_found = 'N' then
6587: --set flag to show that a line has been found

Line 6604: l_bulk_line_rec.line_id(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;

6600: l_bulk_line_rec.sold_to_org_id.extend;
6601: l_bulk_line_rec.change_sequence.extend;
6602:
6603: l_bulk_line_rec.header_id(i) := l_header_id;
6604: l_bulk_line_rec.line_id(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;
6605: l_bulk_line_rec.xml_transaction_type_code(i) := l_acknowledgment_type;
6606: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;
6607: l_bulk_line_rec.request_id(i) := l_itemkey;
6608: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);

Line 6606: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;

6602:
6603: l_bulk_line_rec.header_id(i) := l_header_id;
6604: l_bulk_line_rec.line_id(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;
6605: l_bulk_line_rec.xml_transaction_type_code(i) := l_acknowledgment_type;
6606: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;
6607: l_bulk_line_rec.request_id(i) := l_itemkey;
6608: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);
6609: l_bulk_line_rec.change_sequence(i) :=OE_Delayed_Requests_PVT. G_Delayed_Requests(l_count).param5;
6610:

Line 6608: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);

6604: l_bulk_line_rec.line_id(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;
6605: l_bulk_line_rec.xml_transaction_type_code(i) := l_acknowledgment_type;
6606: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;
6607: l_bulk_line_rec.request_id(i) := l_itemkey;
6608: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);
6609: l_bulk_line_rec.change_sequence(i) :=OE_Delayed_Requests_PVT. G_Delayed_Requests(l_count).param5;
6610:
6611: IF l_debug_level > 0 THEN
6612: oe_debug_pub.add( 'after assignment to bulk record') ;

Line 6609: l_bulk_line_rec.change_sequence(i) :=OE_Delayed_Requests_PVT. G_Delayed_Requests(l_count).param5;

6605: l_bulk_line_rec.xml_transaction_type_code(i) := l_acknowledgment_type;
6606: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;
6607: l_bulk_line_rec.request_id(i) := l_itemkey;
6608: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);
6609: l_bulk_line_rec.change_sequence(i) :=OE_Delayed_Requests_PVT. G_Delayed_Requests(l_count).param5;
6610:
6611: IF l_debug_level > 0 THEN
6612: oe_debug_pub.add( 'after assignment to bulk record') ;
6613: end if;

Line 6622: l_line_id_tbl(i).line_id := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;

6618: -- 5738023
6619: IF l_debug_level > 0 THEN
6620: oe_debug_pub.add( 'Assigning entity id to line table', 3);
6621: END IF;
6622: l_line_id_tbl(i).line_id := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;
6623: END IF;
6624:
6625: i := i + 1;
6626:

Line 6629: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);

6625: i := i + 1;
6626:
6627:
6628: l_count_old := l_count;
6629: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);
6630:
6631: -- Processing has been done, so delete line-level request now
6632: OE_Delayed_Requests_PVT.G_Delayed_Requests.Delete(l_count_old);
6633:

Line 6632: OE_Delayed_Requests_PVT.G_Delayed_Requests.Delete(l_count_old);

6628: l_count_old := l_count;
6629: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);
6630:
6631: -- Processing has been done, so delete line-level request now
6632: OE_Delayed_Requests_PVT.G_Delayed_Requests.Delete(l_count_old);
6633:
6634: ELSE
6635: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);
6636: END IF;

Line 6635: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);

6631: -- Processing has been done, so delete line-level request now
6632: OE_Delayed_Requests_PVT.G_Delayed_Requests.Delete(l_count_old);
6633:
6634: ELSE
6635: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);
6636: END IF;
6637:
6638: END LOOP;
6639: