DBA Data[Home] [Help]

APPS.OE_SALES_CAN_UTIL dependencies on OE_GLOBALS

Line 44: l_control_rec OE_GLOBALS.Control_Rec_Type;

40: Is
41: l_api_name VARCHAR2(30) := 'UPDATELINE';
42: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
43: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
44: l_control_rec OE_GLOBALS.Control_Rec_Type;
45: l_return_status VARCHAR2(1);
46: l_line_rec OE_Order_PUB.Line_Rec_Type;
47:
48: --

Line 110: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

106: l_line_tbl(1).change_reason := p_change_reason;
107: l_line_tbl(1).change_comments := p_change_comments;
108:
109: -- Set Operation.
110: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
111:
112: -- Populate line table
113:
114: -- Call OE_Order_PVT.Process_order

Line 251: OE_DEBUG_PUB.add('Entering perform_line_change() with reason required flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);

247: -- defined at booked orders only, then cancel history record would be inserted
248: -- without reason code.
249:
250: IF l_debug_level > 0 THEN
251: OE_DEBUG_PUB.add('Entering perform_line_change() with reason required flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
252: END IF;
253:
254: l_order_quantity_uom := p_line_rec.order_quantity_uom; --bug 5702849
255: oe_debug_pub.add('5702849: Value of l_order_quantity_uom :'||l_order_quantity_uom);

Line 257: IF (p_line_rec.operation <> oe_globals.g_opr_create AND

253:
254: l_order_quantity_uom := p_line_rec.order_quantity_uom; --bug 5702849
255: oe_debug_pub.add('5702849: Value of l_order_quantity_uom :'||l_order_quantity_uom);
256:
257: IF (p_line_rec.operation <> oe_globals.g_opr_create AND
258: p_line_rec.split_action_code <> 'SPLIT') THEN
259:
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add('Entering oe_sales_can_util.perform_line_change' ) ;

Line 269: lhisttypecode := OE_GLOBALS.G_CAN_HIST_TYPE_CODE;

265:
266: IF (nvl(p_line_rec.ordered_quantity, 0) < nvl(p_old_line_rec.ordered_quantity, 0)) THEN
267: l_cancelled_qty := nvl(p_old_line_rec.ordered_quantity, 0) - nvl(p_line_rec.ordered_quantity, 0);
268: IF (oe_sales_can_util.G_REQUIRE_REASON) THEN
269: lhisttypecode := OE_GLOBALS.G_CAN_HIST_TYPE_CODE;
270: ELSE
271: lhisttypecode := 'QUANTITY UPDATE';
272: END IF;
273: ELSIF (nvl(p_line_rec.ordered_quantity, 0) > nvl(p_old_line_rec.ordered_quantity, 0)) THEN

Line 281: lhisttypecode := OE_GLOBALS.G_CAN_HIST_TYPE_CODE;

277: -- INVCONV
278: IF (nvl(p_line_rec.ordered_quantity2, 0) < nvl(p_old_line_rec.ordered_quantity2, 0)) THEN
279: l_cancelled_qty2 := nvl(p_old_line_rec.ordered_quantity2, 0) - nvl(p_line_rec.ordered_quantity2, 0);
280: IF (oe_sales_can_util.G_REQUIRE_REASON) THEN
281: lhisttypecode := OE_GLOBALS.G_CAN_HIST_TYPE_CODE;
282: ELSE
283: lhisttypecode := 'QUANTITY UPDATE';
284: END IF;
285: ELSIF (nvl(p_line_rec.ordered_quantity2, 0) > nvl(p_old_line_rec.ordered_quantity2, 0)) THEN

Line 335: -- is cancelled, it will log a OE_GLOBALS.G_UPDATE_REQUISITION delayed

331: -- there will not be any descrepancy between the OM and Purchasing for
332: -- partial internal sales order line cancellation, createed as part of
333: -- system split after partial shipping against the original internal sales
334: -- order line. From this project, onwards, if an internal sales order line
335: -- is cancelled, it will log a OE_GLOBALS.G_UPDATE_REQUISITION delayed
336: -- request, whose execution will call the Puchasing API
337: -- PO_RCO_Validation_GRP.Update_ReqCancel_from_SO(). It will be this
338: -- purchasing API responsibility to update the MTL_Supply table for
339: -- quantity change in internal sales order line.

Line 421: OE_DEBUG_PUB.add('Audit Trail Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);

417: /* IR ISO Change Management project End */
418:
419:
420: IF l_debug_level > 0 THEN
421: OE_DEBUG_PUB.add('Audit Trail Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
422: oe_debug_pub.add('Line change reason : '||p_line_rec.change_reason,1);
423: END IF;
424:
425: -- #2743789 changes

Line 435: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N' THEN

431:
432: --Commented out hre following block of code for bug #3665150
433: /* IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN -- reinstated for 2653505
434:
435: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N' THEN
436: IF p_line_rec.change_reason IS NULL OR
437: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add('Cancellation Reason is Not Provided',1);

Line 468: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

464: END IF;
465:
466: --11.5.10 Versioning/Audit Trail updates
467: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
468: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
469: p_entity_id => p_line_rec.line_id,
470: p_hist_type_code => lhisttypecode);
471: --log delayed request
472: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 472: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

468: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
469: p_entity_id => p_line_rec.line_id,
470: p_hist_type_code => lhisttypecode);
471: --log delayed request
472: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
473: p_entity_id => p_line_rec.header_id,
474: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
475: p_requesting_entity_id => p_line_rec.line_id,
476: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

Line 474: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

470: p_hist_type_code => lhisttypecode);
471: --log delayed request
472: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
473: p_entity_id => p_line_rec.header_id,
474: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
475: p_requesting_entity_id => p_line_rec.line_id,
476: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
477: x_return_status => l_return_status);
478: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

Line 476: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

472: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
473: p_entity_id => p_line_rec.header_id,
474: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
475: p_requesting_entity_id => p_line_rec.line_id,
476: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
477: x_return_status => l_return_status);
478: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
479: ELSE
480: OE_CHG_ORDER_PVT.RecordLineHist

Line 478: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

474: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
475: p_requesting_entity_id => p_line_rec.line_id,
476: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
477: x_return_status => l_return_status);
478: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
479: ELSE
480: OE_CHG_ORDER_PVT.RecordLineHist
481: ( p_line_id => p_line_rec.line_id
482: , p_line_rec => p_line_rec

Line 579: OE_STANDARD_WF.Get_LineProcessName(OE_GLOBALS.G_WFI_LIN, p_line_rec.line_id,

575: /*
576: ** Recommented for clarity. WF activity is progressed in OEXULINB.pls
577:
578: Abort Wf activities
579: OE_STANDARD_WF.Get_LineProcessName(OE_GLOBALS.G_WFI_LIN, p_line_rec.line_id,
580: l_line_process_name);
581:
582: If p_line_rec.ordered_quantity = 0 then
583: wf_engine.abortprocess(OE_Globals.G_WFI_LIN

Line 583: wf_engine.abortprocess(OE_Globals.G_WFI_LIN

579: OE_STANDARD_WF.Get_LineProcessName(OE_GLOBALS.G_WFI_LIN, p_line_rec.line_id,
580: l_line_process_name);
581:
582: If p_line_rec.ordered_quantity = 0 then
583: wf_engine.abortprocess(OE_Globals.G_WFI_LIN
584: ,to_char(p_line_rec.line_id)
585: ,l_line_process_name);
586: OE_DEBUG_PUB.ADD('Calling Wf Handle Error ');
587: Using Retry option to run close activity

Line 588: OE_GLOBALS.G_RECURSION_MODE := 'Y';

584: ,to_char(p_line_rec.line_id)
585: ,l_line_process_name);
586: OE_DEBUG_PUB.ADD('Calling Wf Handle Error ');
587: Using Retry option to run close activity
588: OE_GLOBALS.G_RECURSION_MODE := 'Y';
589: wf_engine.handleerror(OE_Globals.G_WFI_LIN
590: ,to_char(p_line_rec.line_id)
591: ,'CLOSE_LINE',
592: 'RETRY','CANCEL');

Line 589: wf_engine.handleerror(OE_Globals.G_WFI_LIN

585: ,l_line_process_name);
586: OE_DEBUG_PUB.ADD('Calling Wf Handle Error ');
587: Using Retry option to run close activity
588: OE_GLOBALS.G_RECURSION_MODE := 'Y';
589: wf_engine.handleerror(OE_Globals.G_WFI_LIN
590: ,to_char(p_line_rec.line_id)
591: ,'CLOSE_LINE',
592: 'RETRY','CANCEL');
593: OE_DEBUG_PUB.ADD('After Calling Wf Handle Error ');

Line 595: OE_GLOBALS.G_RECURSION_MODE := 'N';

591: ,'CLOSE_LINE',
592: 'RETRY','CANCEL');
593: OE_DEBUG_PUB.ADD('After Calling Wf Handle Error ');
594: NULL;
595: OE_GLOBALS.G_RECURSION_MODE := 'N';
596: end if;
597: */
598:
599: -- Release Holds

Line 642: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

638:
639: IF p_line_rec.ordered_quantity = 0 THEN
640:
641: oe_delayed_requests_pvt.log_request(
642: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
643: p_entity_id => p_line_rec.header_id,
644: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
645: p_requesting_entity_id => p_line_rec.header_id,
646: p_request_type => OE_GLOBALS.G_DELETE_CHARGES,

Line 644: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

640:
641: oe_delayed_requests_pvt.log_request(
642: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
643: p_entity_id => p_line_rec.header_id,
644: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
645: p_requesting_entity_id => p_line_rec.header_id,
646: p_request_type => OE_GLOBALS.G_DELETE_CHARGES,
647: x_return_status => l_return_status);
648:

Line 646: p_request_type => OE_GLOBALS.G_DELETE_CHARGES,

642: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
643: p_entity_id => p_line_rec.header_id,
644: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
645: p_requesting_entity_id => p_line_rec.header_id,
646: p_request_type => OE_GLOBALS.G_DELETE_CHARGES,
647: x_return_status => l_return_status);
648:
649: End if;
650:

Line 697: IF (p_x_line_rec.operation <> oe_globals.g_opr_create AND

693: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
694: --
695: BEGIN
696: -- x_line_Rec := p_line_Rec;
697: IF (p_x_line_rec.operation <> oe_globals.g_opr_create AND
698: nvl(p_x_line_rec.split_action_code,'X') <> 'SPLIT') THEN
699: -- OE_SALES_CAN_UTIL.G_REQUIRE_REASON := FALSE;
700:
701: IF l_debug_level > 0 THEN

Line 1034: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)

1030: --
1031: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1032: --
1033: begin
1034: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
1035: THEN
1036: --IF (nvl(p_line_rec.line_category_code,' ') <> 'RETURN') THEN
1037:
1038: /* Fix bug # 2136529: Get the old quantities from the database */

Line 1057: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN

1053: oe_debug_pub.add( 'OLD CANCELLED QUANTITY IS: '||L_OLD_CAN_QUANTITY ) ;
1054: END IF;
1055:
1056: IF (l_old_ord_quantity > p_line_rec.ordered_quantity)
1057: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN
1058: l_new_can_quantity := l_old_ord_quantity - p_line_rec.ordered_quantity
1059: + l_old_can_quantity;
1060: ELSE
1061: l_new_can_quantity := l_old_can_quantity;

Line 1131: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) THEN

1127: RETURN p_line_rec.cancelled_quantity;
1128: */
1129:
1130: --Bug# 4009268
1131: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) THEN
1132: oe_debug_pub.add('New ordered_quantity and Old ordered_quantity are equal ');
1133: RETURN nvl(p_line_rec.cancelled_quantity,0);
1134: END IF;
1135:

Line 1233: OE_DEBUG_PUB.add('Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);

1229:
1230: IF l_debug_level > 0 THEN
1231: OE_DEBUG_PUB.ADD('Entering oe_sales_can_util.perform_cancel_order',5);
1232: OE_DEBUG_PUB.ADD('perform cancel order header id : '||p_header_rec.header_id,5);
1233: OE_DEBUG_PUB.add('Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
1234: OE_DEBUG_PUB.add('Reason provided is : '||p_header_rec.change_reason,1);
1235: END IF;
1236:
1237: --g_ord_lvl_can := TRUE; Commented for bug# 2922468

Line 1239: IF (oe_sales_can_util.G_REQUIRE_REASON AND OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N') THEN

1235: END IF;
1236:
1237: --g_ord_lvl_can := TRUE; Commented for bug# 2922468
1238:
1239: IF (oe_sales_can_util.G_REQUIRE_REASON AND OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N') THEN
1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add( 'CHANGE REASON IS REQUIRED' ) ;
1242: END IF;
1243: IF p_header_rec.change_reason IS NULL THEN

Line 1274: IF l_line_old_tbl(j).item_type_code = OE_Globals.G_ITEM_SERVICE AND

1270: oe_debug_pub.add( 'LINE SELECTED FOR CANCELLATION , ID: '|| L_LINE_OLD_TBL ( J ) .LINE_ID , 1 ) ;
1271: END IF;
1272:
1273: /* Fix for bug # 2126033 */
1274: IF l_line_old_tbl(j).item_type_code = OE_Globals.G_ITEM_SERVICE AND
1275: l_line_old_tbl(j).service_reference_type_code = 'ORDER' THEN
1276:
1277: begin
1278: select 'Y'

Line 1329: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;

1325: l_x_line_old_tbl(i) := l_line_old_tbl(j);
1326: l_line_tbl(i).db_flag := FND_API.G_TRUE;
1327: --l_line_tbl(i).cancelled_quantity := l_line_tbl(i).ordered_quantity;
1328: l_line_tbl(i).ordered_quantity :=0;
1329: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1330: l_line_tbl(i).change_reason :=p_header_rec.change_reason;
1331: l_line_tbl(i).change_comments :=p_header_Rec.change_comments;
1332: /*l_line_tbl(i).cancelled_flag := 'Y';
1333: l_line_tbl(i).flow_status_code := 'CANCELLED';

Line 1478: --OE_STANDARD_WF.Get_HdrProcessName(OE_GLOBALS.G_WFI_HDR, p_header_rec.header_id,

1474:
1475:
1476:
1477: -- Abort the Wf and close the Header
1478: --OE_STANDARD_WF.Get_HdrProcessName(OE_GLOBALS.G_WFI_HDR, p_header_rec.header_id,
1479: --l_line_process_name);
1480:
1481: -- Moved this post line process
1482: /*IF oe_sales_can_util.g_order_cancel THEN

Line 1483: wf_engine.handleerror(OE_Globals.G_WFI_HDR

1479: --l_line_process_name);
1480:
1481: -- Moved this post line process
1482: /*IF oe_sales_can_util.g_order_cancel THEN
1483: wf_engine.handleerror(OE_Globals.G_WFI_HDR
1484: ,to_char(p_header_rec.header_id)
1485: ,'CLOSE_HEADER',
1486: 'SKIP','CANCEL');
1487: END IF; */

Line 1519: l_control_rec OE_GLOBALS.Control_Rec_Type;

1515: , p_line_old_tbl IN OE_ORDER_PUB.LINE_TBL_TYPE
1516: , x_return_status OUT NOCOPY VARCHAR2)
1517:
1518: IS
1519: l_control_rec OE_GLOBALS.Control_Rec_Type;
1520: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1521: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1522: l_api_name CONSTANT VARCHAR2(30) := 'PerformLineCancellation';
1523: x_msg_count NUMBER;

Line 1779: p_item_type => OE_GLOBALS.G_WFI_LIN

1775:
1776: ELSE -- fulfillment of all related lines was successful
1777: l_item_key := to_char(l_line_id);
1778: Oe_line_fullfill.Get_Activity_Result(
1779: p_item_type => OE_GLOBALS.G_WFI_LIN
1780: ,p_item_key => l_item_key
1781: ,p_activity_name => 'FULFILL_LINE'
1782: ,x_return_status => l_return_status
1783: ,x_activity_result => l_activity_result

Line 1906: IF l_line_old_tbl(i).item_type_code = OE_Globals.G_ITEM_SERVICE AND

1902: oe_debug_pub.add( 'LINE SELECTED FOR CANCELLATION , ID: '|| L_LINE_OLD_TBL ( I ) .LINE_ID , 1 ) ;
1903: END IF;
1904:
1905: /* Fix for bug # 2126033 */
1906: IF l_line_old_tbl(i).item_type_code = OE_Globals.G_ITEM_SERVICE AND
1907: l_line_old_tbl(i).service_reference_type_code = 'ORDER' THEN
1908:
1909: begin
1910: select 'Y'

Line 1965: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;

1961: l_x_line_old_tbl(J) := l_line_old_tbl(I);
1962: l_line_tbl(J).db_flag := FND_API.G_TRUE;
1963: --l_line_tbl(J).cancelled_quantity := l_line_tbl(J).ordered_quantity;
1964: l_line_tbl(j).ordered_quantity :=0;
1965: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
1966: l_line_tbl(j).change_reason :=p_header_rec.change_reason;
1967: l_line_tbl(j).change_comments :=p_header_Rec.change_comments;
1968: /*
1969: ** Fix bug # 2660104:

Line 2098: IF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_HEADER

2094: OE_DEBUG_PUB.ADD('Entity:' || x_request_rec.param1 );
2095: OE_DEBUG_PUB.ADD('Entity id:' || x_request_rec.entity_id );
2096: end if;
2097:
2098: IF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_HEADER
2099: THEN
2100:
2101: if l_debug_level > 0 then
2102: OE_DEBUG_PUB.ADD('Before select ');

Line 2112: wf_engine.handleerror(OE_Globals.G_WFI_HDR

2108: if l_debug_level > 0 then
2109: OE_DEBUG_PUB.ADD('Before cancelling header flow ');
2110: end if;
2111:
2112: wf_engine.handleerror(OE_Globals.G_WFI_HDR
2113: ,to_char(x_request_rec.entity_id)
2114: ,'CLOSE_HEADER',
2115: 'RETRY','CANCEL');
2116:

Line 2123: ELSIF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_LINE

2119: if l_debug_level > 0 then
2120: OE_DEBUG_PUB.ADD('after cancelling header flow ');
2121: end if;
2122:
2123: ELSIF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_LINE
2124: THEN
2125:
2126: if l_debug_level > 0 then
2127: OE_DEBUG_PUB.ADD('before select Cursoer C1 ');

Line 2140: wf_engine.handleerror(OE_Globals.G_WFI_LIN

2136: Update oe_order_lines_all
2137: set cancelled_flag = 'Y' where
2138: line_id = x_request_rec.entity_id;
2139:
2140: wf_engine.handleerror(OE_Globals.G_WFI_LIN
2141: ,to_char(x_request_rec.entity_id)
2142: ,'CLOSE_LINE',
2143: 'RETRY','CANCEL');
2144: End if; -- Ordered quantity

Line 2195: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2)

2191:
2192: IF l_debug_level > 0 THEN
2193: oe_debug_pub.add( 'entering Cal_Cancelled_Qty2') ;
2194: END IF;
2195: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2)
2196: THEN
2197: IF l_debug_level > 0 THEN
2198: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 1 ') ;
2199: END IF;

Line 2222: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN

2218: oe_debug_pub.add( 'OLD CANCELLED QUANTITY2 IS: '||L_OLD_CAN_QUANTITY2 ) ;
2219: END IF;
2220:
2221: IF (l_old_ord_quantity2 > p_line_rec.ordered_quantity2)
2222: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN
2223: l_new_can_quantity2 := l_old_ord_quantity2 - p_line_rec.ordered_quantity2
2224: + l_old_can_quantity2;
2225: ELSE
2226: l_new_can_quantity2 := l_old_can_quantity2;

Line 2304: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN

2300: RETURN p_line_rec.cancelled_quantity;
2301: */
2302:
2303: --Bug# 4009268
2304: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN
2305: oe_debug_pub.add('New ordered_quantity2 and Old ordered_quantity2 are equal ');
2306: RETURN p_line_rec.cancelled_quantity2;
2307: END IF;
2308: