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 208: OE_GLOBALS.set_context;

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

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

380: END IF ;
381: END IF;
382: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
383: l_opeN_line_rec.split_by := 'SYSTEM';
384: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
385: l_line_tbl(1).ordered_quantity := l_quantity;
386: IF b_dual_qty THEN
387: l_line_tbl(1).ordered_quantity2 := l_quantity2; -- 04/20/2001 OPM
388: END IF;

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

385: l_line_tbl(1).ordered_quantity := l_quantity;
386: IF b_dual_qty THEN
387: l_line_tbl(1).ordered_quantity2 := l_quantity2; -- 04/20/2001 OPM
388: END IF;
389: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
390: l_line_tbl(1).shipped_quantity := l_quantity;
391: IF b_dual_qty THEN
392: l_line_tbl(1).shipped_quantity2 := l_quantity2; -- 04/20/2001 OPM
393: l_line_tbl(1).shipping_quantity_uom2 := l_old_line_tbl(1).ordered_quantity_uom2;

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

404: l_line_tbl(1).shipped_quantity2 := l_quantity2; -- 04/20/2001 OPM
405: l_line_tbl(1).shipping_quantity_uom2 := l_old_line_tbl(1).ordered_quantity_uom2;
406: END IF;
407: l_line_tbl(1).shipping_quantity_uom := l_old_line_tbl(1).order_quantity_uom;
408: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
409:
410: END IF;
411: --set the actual shipment date on the RMA line
412:

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

458: l_line_tbl(1).fulfilled_quantity := l_updated_quantity;
459: IF b_dual_qty THEN
460: l_line_tbl(1).fulfilled_quantity2 := l_updated_quantity2; -- 04/20/2001 OPM
461: END IF;
462: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
463:
464: IF (l_line_tbl(1).shipped_quantity = l_updated_quantity) THEN
465: b_complete_inspection := TRUE;
466: END IF;

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

481: l_updated_quantity2 := l_line_tbl(1).shipped_quantity2 - l_quantity2; -- 04/20/2001 OPM
482: l_line_tbl(1).shipped_quantity2 := l_updated_quantity2;
483: END IF;
484: l_line_tbl(1).shipped_quantity := l_updated_quantity;
485: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
486: l_control_rec.check_security := FALSE;
487:
488: -- Bug 7692369 : WORKFLOW STUCK THOUGH THE LINE IS FULFILLED IN CASE FULL RETURN TO CUSTOMER
489: -- This is because comparision of fulfilled quantity w/o NVL condition.

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

548: l_line_tbl(1).shipped_quantity := l_updated_quantity;
549: IF b_dual_qty THEN
550: l_line_tbl(1).shipped_quantity2 := l_updated_quantity2; -- 04/20/2001 OPM
551: END IF;
552: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
553: ELSE
554: l_max_qty_to_adjust := l_line_tbl(1).ordered_quantity +
555: l_tolerance_above -
556: l_line_tbl(1).shipped_quantity;

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

592: l_updated_quantity2 := l_line_tbl(1).shipped_quantity2 + l_quantity2; -- 04/20/2001 OPM
593: l_line_tbl(1).shipped_quantity := l_updated_quantity;
594: END IF;
595:
596: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
597: l_control_rec.check_security := FALSE;
598:
599: IF (l_open_line_id is NULL) THEN -- no open line
600:

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

618: oe_debug_pub.add('Split the current line ' );
619: END IF;
620: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
621: l_open_line_rec.split_by := 'SYSTEM';
622: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
623: b_adjust_open_quantity := TRUE;
624:
625: l_line_tbl(1).ordered_quantity := l_updated_quantity;
626: IF b_dual_qty THEN

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

681: l_updated_quantity2 := l_open_line_rec.ordered_quantity2 -
682: l_quantity2; -- 04/20/2001 OPM
683: l_open_line_rec.ordered_quantity2 := l_updated_quantity2;
684: END IF;
685: l_open_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
686: b_adjust_open_quantity := TRUE;
687: --start bug 16284063
688: IF l_line_tbl(1).shipped_quantity = l_line_tbl(1).fulfilled_quantity
689: and l_line_tbl(1).flow_status_code='AWAITING_RETURN_DISPOSITION'

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

781: /* End Bug 5501949 */
782: /* End Bug 6052676 */
783:
784:
785: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
786:
787: -- Modified for Bug 5501949 IF (l_line_tbl(1).shipped_quantity = l_updated_quantity) THEN
788: --Added NVL for bug 6110517
789: IF nvl(l_line_tbl(1).shipped_quantity,0) = nvl(l_line_tbl(1).fulfilled_quantity,0) THEN

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

806: l_updated_quantity2 := l_line_tbl(1).shipped_quantity2 - l_quantity2; -- 04/20/2001 OPM
807: l_line_tbl(1).shipped_quantity2 := l_updated_quantity2;
808: END IF;
809: l_line_tbl(1).shipped_quantity := l_updated_quantity;
810: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
811: l_control_rec.check_security := FALSE;
812:
813: -- For the bug fix 5099112
814: -- FOR the bug fix 7571804

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

848: := l_line_tbl(1).shipped_quantity2 - l_quantity2; -- 04/20/2001 OPM
849: l_line_tbl(1).fulfilled_quantity2
850: := l_line_tbl(1).fulfilled_quantity2 - l_quantity2;
851: END IF;
852: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
853: l_control_rec.check_security := FALSE;
854:
855:
856: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN

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

866: IF b_dual_qty THEN
867: l_updated_quantity2 := l_line_tbl(1).fulfilled_quantity2 - l_quantity2; -- 04/20/2001 OPM
868: l_line_tbl(1).fulfilled_quantity2 := l_updated_quantity2;
869: END IF;
870: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
871: l_control_rec.check_security := FALSE;
872:
873:
874: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN

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

884: IF b_dual_qty THEN
885: l_updated_quantity2 := l_line_tbl(1).fulfilled_quantity2 + l_quantity2; -- 04/20/2001 OPM
886: l_line_tbl(1).fulfilled_quantity2 := l_updated_quantity2;
887: END IF;
888: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
889: l_control_rec.check_security := FALSE;
890:
891: -- do we want to check if the line gets fulfilled at this point?
892:

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

931: l_line_tbl(1).shipped_quantity2
932: := l_line_tbl(1).shipped_quantity2 - l_quantity2; -- 04/20/2001 OPM
933: END IF;
934:
935: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
936: l_control_rec.check_security := FALSE;
937:
938: IF l_line_tbl(1).shipped_quantity = l_line_tbl(1).fulfilled_quantity
939: AND l_line_tbl(1).flow_status_code='AWAITING_RETURN_DISPOSITION'

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

960: IF b_dual_qty THEN
961: l_line_tbl(1).fulfilled_quantity2
962: := l_line_tbl(1).fulfilled_quantity2 - l_quantity2; -- 04/20/2001 OPM
963: END IF;
964: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
965:
966: END IF;
967:
968: ELSIF (p_parent_transaction_type =

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

1013: l_open_line_rec.ordered_quantity
1014: := l_old_line_tbl(1).ordered_quantity - l_quantity;
1015: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
1016: l_open_line_rec.split_by := 'SYSTEM';
1017: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1018: l_line_tbl(1).ordered_quantity := l_quantity;
1019: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1020: l_line_tbl(1).shipped_quantity := l_quantity;
1021:

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

1015: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
1016: l_open_line_rec.split_by := 'SYSTEM';
1017: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1018: l_line_tbl(1).ordered_quantity := l_quantity;
1019: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1020: l_line_tbl(1).shipped_quantity := l_quantity;
1021:
1022: IF b_dual_qty THEN
1023: l_open_line_rec.ordered_quantity2

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

1036: l_line_tbl(1).shipped_quantity2 := l_quantity2; -- 04/20/2001 OPM
1037: END IF;
1038:
1039:
1040: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1041:
1042: END IF;
1043:
1044: -- Set the actual shipment date on the RMA line

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

1377: --
1378: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1379: --
1380: BEGIN
1381: -- OE_GLOBALS.set_context; -- removed for MOAC.
1382: IF l_debug_level > 0 THEN
1383: oe_debug_pub.add( 'G_ORG_ID='||TO_CHAR ( OE_GLOBALS.G_ORG_ID ) , 1 ) ;
1384: END IF;
1385: SELECT open_flag,

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

1379: --
1380: BEGIN
1381: -- OE_GLOBALS.set_context; -- removed for MOAC.
1382: IF l_debug_level > 0 THEN
1383: oe_debug_pub.add( 'G_ORG_ID='||TO_CHAR ( OE_GLOBALS.G_ORG_ID ) , 1 ) ;
1384: END IF;
1385: SELECT open_flag,
1386: invoice_interface_status_code,
1387: ordered_quantity,