DBA Data[Home] [Help]

APPS.OE_RMA_RECEIVING dependencies on OE_GLOBALS

Line 136: l_control_rec OE_GLOBALS.Control_Rec_Type;

132: IS
133: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
134: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
135: l_item_key varchar2(30);
136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
138: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
139: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 205: OE_GLOBALS.set_context;

201: return;
202: END IF;
203:
204: -- This API is called directly from PO, need to set the oe global context
205: OE_GLOBALS.set_context;
206:
207: -- This if statement is to allow debug generation by setting the profile option
208:
209: IF l_debug_level > 0 THEN

Line 350: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

346: := l_old_line_tbl(1).ordered_quantity2 - p_quantity2; -- 04/20/2001 OPM
347: END IF;
348: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
349: l_opeN_line_rec.split_by := 'SYSTEM';
350: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
351: l_line_tbl(1).ordered_quantity := p_quantity;
352: IF b_dual_qty THEN
353: l_line_tbl(1).ordered_quantity2 := p_quantity2; -- 04/20/2001 OPM
354: END IF;

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

351: l_line_tbl(1).ordered_quantity := p_quantity;
352: IF b_dual_qty THEN
353: l_line_tbl(1).ordered_quantity2 := p_quantity2; -- 04/20/2001 OPM
354: END IF;
355: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
356: l_line_tbl(1).shipped_quantity := p_quantity;
357: IF b_dual_qty THEN
358: l_line_tbl(1).shipped_quantity2 := p_quantity2; -- 04/20/2001 OPM
359: l_line_tbl(1).shipping_quantity_uom2 := l_old_line_tbl(1).ordered_quantity_uom2;

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

370: l_line_tbl(1).shipped_quantity2 := p_quantity2; -- 04/20/2001 OPM
371: l_line_tbl(1).shipping_quantity_uom2 := l_old_line_tbl(1).ordered_quantity_uom2;
372: END IF;
373: l_line_tbl(1).shipping_quantity_uom := l_old_line_tbl(1).order_quantity_uom;
374: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
375:
376: END IF;
377: --set the actual shipment date on the RMA line
378:

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

424: l_line_tbl(1).fulfilled_quantity := l_updated_quantity;
425: IF b_dual_qty THEN
426: l_line_tbl(1).fulfilled_quantity2 := l_updated_quantity2; -- 04/20/2001 OPM
427: END IF;
428: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
429:
430: IF (l_line_tbl(1).shipped_quantity = l_updated_quantity) THEN
431: b_complete_inspection := TRUE;
432: END IF;

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

447: l_updated_quantity2 := l_line_tbl(1).shipped_quantity2 - p_quantity2; -- 04/20/2001 OPM
448: l_line_tbl(1).shipped_quantity2 := l_updated_quantity2;
449: END IF;
450: l_line_tbl(1).shipped_quantity := l_updated_quantity;
451: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
452: l_control_rec.check_security := FALSE;
453:
454: IF (l_line_tbl(1).shipped_quantity = l_line_tbl(1).fulfilled_quantity)
455: THEN

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

510: l_line_tbl(1).shipped_quantity := l_updated_quantity;
511: IF b_dual_qty THEN
512: l_line_tbl(1).shipped_quantity2 := l_updated_quantity2; -- 04/20/2001 OPM
513: END IF;
514: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
515: ELSE
516: l_max_qty_to_adjust := l_line_tbl(1).ordered_quantity +
517: l_tolerance_above -
518: l_line_tbl(1).shipped_quantity;

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

554: l_updated_quantity2 := l_line_tbl(1).shipped_quantity2 + p_quantity2; -- 04/20/2001 OPM
555: l_line_tbl(1).shipped_quantity := l_updated_quantity;
556: END IF;
557:
558: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
559: l_control_rec.check_security := FALSE;
560:
561: IF (l_open_line_id is NULL) THEN -- no open line
562:

Line 584: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

580: oe_debug_pub.add('Split the current line ' );
581: END IF;
582: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
583: l_open_line_rec.split_by := 'SYSTEM';
584: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
585: b_adjust_open_quantity := TRUE;
586:
587: l_line_tbl(1).ordered_quantity := l_updated_quantity;
588: IF b_dual_qty THEN

Line 647: l_open_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

643: l_updated_quantity2 := l_open_line_rec.ordered_quantity2 -
644: p_quantity2; -- 04/20/2001 OPM
645: l_open_line_rec.ordered_quantity2 := l_updated_quantity2;
646: END IF;
647: l_open_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
648: b_adjust_open_quantity := TRUE;
649: ELSIF l_updated_quantity = 0 THEN
650: -- Take the received line back to AWAITING_RETURN
651: IF l_debug_level > 0 THEN

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

736: /* End Bug 5501949 */
737: /* End Bug 6052676 */
738:
739:
740: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
741:
742: -- Modified for Bug 5501949 IF (l_line_tbl(1).shipped_quantity = l_updated_quantity) THEN
743: --Added NVL for bug 6110517
744: IF nvl(l_line_tbl(1).shipped_quantity,0) = nvl(l_line_tbl(1).fulfilled_quantity,0) THEN

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

761: l_updated_quantity2 := l_line_tbl(1).shipped_quantity2 - p_quantity2; -- 04/20/2001 OPM
762: l_line_tbl(1).shipped_quantity2 := l_updated_quantity2;
763: END IF;
764: l_line_tbl(1).shipped_quantity := l_updated_quantity;
765: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
766: l_control_rec.check_security := FALSE;
767:
768: -- For the bug fix 5099112
769: -- FOR the bug fix 7571804

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

792: := l_line_tbl(1).shipped_quantity2 - p_quantity2; -- 04/20/2001 OPM
793: l_line_tbl(1).fulfilled_quantity2
794: := l_line_tbl(1).fulfilled_quantity2 - p_quantity2;
795: END IF;
796: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
797: l_control_rec.check_security := FALSE;
798:
799:
800: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN

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

810: IF b_dual_qty THEN
811: l_updated_quantity2 := l_line_tbl(1).fulfilled_quantity2 - p_quantity2; -- 04/20/2001 OPM
812: l_line_tbl(1).fulfilled_quantity2 := l_updated_quantity2;
813: END IF;
814: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
815: l_control_rec.check_security := FALSE;
816:
817:
818: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN

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

828: IF b_dual_qty THEN
829: l_updated_quantity2 := l_line_tbl(1).fulfilled_quantity2 + p_quantity2; -- 04/20/2001 OPM
830: l_line_tbl(1).fulfilled_quantity2 := l_updated_quantity2;
831: END IF;
832: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
833: l_control_rec.check_security := FALSE;
834:
835: -- do we want to check if the line gets fulfilled at this point?
836:

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

875: l_line_tbl(1).shipped_quantity2
876: := l_line_tbl(1).shipped_quantity2 - p_quantity2; -- 04/20/2001 OPM
877: END IF;
878:
879: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
880: l_control_rec.check_security := FALSE;
881:
882: IF l_line_tbl(1).shipped_quantity = l_line_tbl(1).fulfilled_quantity
883: AND l_line_tbl(1).flow_status_code='AWAITING_RETURN_DISPOSITION'

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

904: IF b_dual_qty THEN
905: l_line_tbl(1).fulfilled_quantity2
906: := l_line_tbl(1).fulfilled_quantity2 - p_quantity2; -- 04/20/2001 OPM
907: END IF;
908: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
909:
910: END IF;
911:
912: ELSIF (p_parent_transaction_type =

Line 961: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

957: l_open_line_rec.ordered_quantity
958: := l_old_line_tbl(1).ordered_quantity - p_quantity;
959: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
960: l_open_line_rec.split_by := 'SYSTEM';
961: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
962: l_line_tbl(1).ordered_quantity := p_quantity;
963: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
964: l_line_tbl(1).shipped_quantity := p_quantity;
965:

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

959: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
960: l_open_line_rec.split_by := 'SYSTEM';
961: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
962: l_line_tbl(1).ordered_quantity := p_quantity;
963: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
964: l_line_tbl(1).shipped_quantity := p_quantity;
965:
966: IF b_dual_qty THEN
967: l_open_line_rec.ordered_quantity2

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

980: l_line_tbl(1).shipped_quantity2 := p_quantity2; -- 04/20/2001 OPM
981: END IF;
982:
983:
984: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
985:
986: END IF;
987:
988: -- Set the actual shipment date on the RMA line

Line 1272: -- OE_GLOBALS.set_context; -- removed for MOAC.

1268: --
1269: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1270: --
1271: BEGIN
1272: -- OE_GLOBALS.set_context; -- removed for MOAC.
1273: IF l_debug_level > 0 THEN
1274: oe_debug_pub.add( 'G_ORG_ID='||TO_CHAR ( OE_GLOBALS.G_ORG_ID ) , 1 ) ;
1275: END IF;
1276: SELECT open_flag,

Line 1274: oe_debug_pub.add( 'G_ORG_ID='||TO_CHAR ( OE_GLOBALS.G_ORG_ID ) , 1 ) ;

1270: --
1271: BEGIN
1272: -- OE_GLOBALS.set_context; -- removed for MOAC.
1273: IF l_debug_level > 0 THEN
1274: oe_debug_pub.add( 'G_ORG_ID='||TO_CHAR ( OE_GLOBALS.G_ORG_ID ) , 1 ) ;
1275: END IF;
1276: SELECT open_flag,
1277: invoice_interface_status_code,
1278: ordered_quantity,