eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_GLOBALS

Line 53: and h.source_document_type_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

49: -- the OE_Order_Headers_N7 index for performance reasons
50: where h.header_id = l.header_id
51: and h.source_document_id = p_internal_req_header_id
52: and l.source_document_line_id = p_internal_req_line_id
53: and h.source_document_type_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
54: and h.open_flag = 'Y'
55: and l.open_flag = 'Y'
56: and nvl(l.cancelled_flag,'N') = 'N'
57: and nvl(l.fulfilled_flag,'N') = 'N'

Line 199: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

195: oe_debug_pub.add( ' Checking if Update operation is allowed for a record',5);
196: END IF;
197: IF ( NOT l_entity_update_allowed ) AND ( l_attr_update_allowed ) THEN
198:
199: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
200:
201: OE_Line_Security.Entity -- Is_OP_Constrained
202: ( p_LINE_rec => l_line_rec
203: , x_result => l_result

Line 278: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add( ' Calling OE_Line_SEcurity.Entity',5);
276: END IF;
277:
278: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
279: l_line_rec.ordered_quantity := 0;
280: IF l_line_rec.ordered_quantity2 IS NOT NULL AND l_line_rec.ordered_quantity2 <> 0 THEN
281: l_line_rec.ordered_quantity2 := 0;
282: END IF;

Line 427: l_control_rec OE_GLOBALS.Control_Rec_Type;

423: IS
424:
425: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
426: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
427: l_control_rec OE_GLOBALS.Control_Rec_Type;
428: l_return_status VARCHAR2(1);
429: l_header_id NUMBER;
430: l_msg_count NUMBER;
431: l_msg_data VARCHAR2(2000);

Line 658: OE_GLOBALS.G_SYS_HOLD := TRUE; -- bug 9494397

654: l_hold_source_rec.hold_entity_id := l_line_ids_rec.header_id;
655: l_hold_source_rec.line_id := l_line_ids_rec.line_id; -- Line level hold
656: l_hold_source_rec.header_id := l_line_ids_rec.header_id;
657:
658: OE_GLOBALS.G_SYS_HOLD := TRUE; -- bug 9494397
659: OE_Holds_Pvt.apply_holds
660: ( p_hold_source_rec => l_hold_source_rec
661: , x_return_status => l_return_status
662: , x_msg_count => l_msg_count

Line 664: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397

660: ( p_hold_source_rec => l_hold_source_rec
661: , x_return_status => l_return_status
662: , x_msg_count => l_msg_count
663: , x_msg_data => l_msg_data );
664: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
665:
666: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
667: RAISE FND_API.G_EXC_ERROR;
668: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 698: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397

694:
695: -- Added for 8583903
696: oe_debug_pub.debug_off;
697: oe_Debug_pub.setdebuglevel(0);
698: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 711: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397

707:
708: -- Added for 8583903
709: oe_debug_pub.debug_off;
710: oe_Debug_pub.setdebuglevel(0);
711: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
712:
713: WHEN OTHERS THEN
714: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);
715: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

Line 729: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397

725:
726: -- Added for 8583903
727: oe_debug_pub.debug_off;
728: oe_Debug_pub.setdebuglevel(0);
729: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
730:
731: End Apply_Hold_for_IReq;
732:
733:

Line 856: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

852: and l.line_id = oh.line_id
853: and oh.hold_source_id = hs.hold_source_id
854: and hs.hold_id = 17
855: and oh.hold_release_id is null
856: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
857: and h.source_document_id = l_req_hdr_id
858: and l.source_document_line_id = P_internal_req_line_id;
859:
860: IF l_debug_level > 0 THEN

Line 875: OE_GLOBALS.G_SYS_HOLD := TRUE; -- bug 9494397

871: l_hold_release_rec.release_reason_code := 'IR_ISO_HOLD';
872: -- We need to seed a new reason as a lookup code
873: l_hold_release_rec.release_comment := 'IR ISO Change Management System hold is released';
874:
875: OE_GLOBALS.G_SYS_HOLD := TRUE; -- bug 9494397
876: OE_Holds_Pvt.Release_Holds( p_hold_source_rec => l_hold_source_rec
877: , p_hold_release_rec => l_hold_release_rec
878: , x_return_status => l_return_status
879: , x_msg_count => l_msg_count

Line 881: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397

877: , p_hold_release_rec => l_hold_release_rec
878: , x_return_status => l_return_status
879: , x_msg_count => l_msg_count
880: , x_msg_data => l_msg_data );
881: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
882:
883: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
884: RAISE FND_API.G_EXC_ERROR;
885: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 940: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397

936:
937: -- Added for 8583903
938: oe_debug_pub.debug_off;
939: oe_Debug_pub.setdebuglevel(0);
940: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
941:
942:
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
944: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

Line 954: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397

950:
951: -- Added for 8583903
952: oe_debug_pub.debug_off;
953: oe_Debug_pub.setdebuglevel(0);
954: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
955:
956: WHEN OTHERS THEN
957: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);
958: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

Line 972: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397

968:
969: -- Added for 8583903
970: oe_debug_pub.debug_off;
971: oe_Debug_pub.setdebuglevel(0);
972: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
973:
974: End Release_Hold_for_IReq;
975:
976:

Line 1084: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

1080: select h.header_id
1081: into l_header_id
1082: from oe_order_headers_all h
1083: where h.source_document_id = p_internal_req_header_id
1084: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1085: and h.open_flag = 'Y';
1086:
1087: IF l_debug_level > 0 THEN
1088: oe_debug_pub.add( ' Header id is '||l_header_id,5);

Line 1342: -- and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

1338: from oe_order_lines_all l
1339: -- , oe_order_headers_all h
1340: where nvl(l.shipped_quantity,0) = 0
1341: -- and h.orig_sys_document_ref = p_internal_req_header_id
1342: -- and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1343: -- and h.header_id = v_order_header_id
1344: -- and h.header_id = l.header_id
1345: and l.source_document_id = p_internal_req_header_id
1346: and l.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

Line 1346: and l.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

1342: -- and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1343: -- and h.header_id = v_order_header_id
1344: -- and h.header_id = l.header_id
1345: and l.source_document_id = p_internal_req_header_id
1346: and l.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1347: and l.header_id = v_order_header_id
1348: -- and h.open_flag = 'Y'
1349: and nvl(cancelled_flag,'N') = 'N'
1350: and l.open_flag = 'Y'

Line 1364: l_control_rec OE_GLOBALS.Control_Rec_Type;

1360: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
1361: l_line_ids_rec Line_Id_rec_Type;
1362: l_line_orig_rec OE_Order_PUB.Line_Rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
1363: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1364: l_control_rec OE_GLOBALS.Control_Rec_Type;
1365: l_return_status VARCHAR2(1);
1366: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1367: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1368: l_line_id NUMBER;

Line 1526: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

1522: select header_id
1523: into l_order_header_id
1524: from oe_order_headers_all h
1525: where h.source_document_id = l_req_hdr_id
1526: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1527: and h.open_flag = 'Y';
1528: Exception
1529: WHEN No_Data_found THEN
1530: IF l_debug_level > 0 THEN

Line 1566: l_line_tbl(l_cancel_eligble_lin).operation := OE_GLOBALS.G_OPR_UPDATE;

1562: l_line_tbl(l_cancel_eligble_lin) := l_line_orig_rec;
1563:
1564: -- l_line_tbl(l_cancel_eligble_lin).line_id := l_line_id;
1565: -- l_line_tbl(l_cancel_eligble_lin).header_id := l_header_id;
1566: l_line_tbl(l_cancel_eligble_lin).operation := OE_GLOBALS.G_OPR_UPDATE;
1567: l_line_tbl(l_cancel_eligble_lin).ordered_quantity := 0;
1568: l_line_tbl(l_cancel_eligble_lin).change_reason := 'IR_ISO_CMS_CHG'; -- 'Internal requisition initiated change';
1569: IF (l_line_ord_qty2 IS NOT NULL AND l_line_ord_qty2 <> 0 ) THEN
1570: l_line_tbl(l_cancel_eligble_lin).ordered_quantity2 := 0;

Line 1603: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL

1599: , p_orig_sys_document_line_ref => null
1600: , p_change_sequence => null
1601: , p_source_document_id => l_req_hdr_id
1602: , p_source_document_line_id => null
1603: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL
1604: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);
1605:
1606: OE_Header_Util.lock_Row
1607: ( p_header_id => l_order_header_id

Line 1604: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);

1600: , p_change_sequence => null
1601: , p_source_document_id => l_req_hdr_id
1602: , p_source_document_line_id => null
1603: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL
1604: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);
1605:
1606: OE_Header_Util.lock_Row
1607: ( p_header_id => l_order_header_id
1608: , p_x_header_rec => l_header_rec

Line 1615: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1611: l_old_header_rec := l_header_rec;
1612:
1613: l_header_rec.cancelled_flag :='Y';
1614: l_header_rec.change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1615: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1616:
1617: l_control_rec.controlled_operation := TRUE;
1618: l_control_rec.default_attributes := FALSE;
1619:

Line 1721: l_line_tbl(l_lin_cancel).operation := OE_GLOBALS.G_OPR_UPDATE;

1717: , x_line_rec => l_line_orig_rec);
1718: l_line_tbl(l_lin_cancel) := l_line_orig_rec;
1719: -- l_line_tbl(l_lin_cancel).line_id := l_line_ids_rec.line_id;
1720: -- l_line_tbl(l_lin_cancel).header_id := l_line_ids_rec.header_id;
1721: l_line_tbl(l_lin_cancel).operation := OE_GLOBALS.G_OPR_UPDATE;
1722: l_line_tbl(l_lin_cancel).ordered_quantity := 0;
1723: l_line_tbl(l_lin_cancel).change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1724: IF (l_line_ids_rec.ordered_quantity2 IS NOT NULL
1725: AND l_line_ids_rec.ordered_quantity2 <> 0 ) THEN

Line 1751: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND

1747: IF l_debug_level > 0 THEN
1748: oe_debug_pub.add(' Only Request Date is changed',5);
1749: oe_debug_pub.add(' Check if update is allowed for line_id '||l_line_ids_rec.line_id,5);
1750: END IF;
1751: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND
1752: Update_Allowed( p_Line_id => l_line_ids_rec.line_id
1753: , P_Attribute => 'REQUEST_DATE') THEN
1754:
1755: IF l_debug_level > 0 THEN

Line 1768: l_line_tbl(l_lin_update).operation := OE_GLOBALS.G_OPR_UPDATE;

1764: l_line_tbl(l_lin_update) := l_line_orig_rec;
1765:
1766: -- l_line_tbl(l_lin_update).line_id := l_line_ids_rec.line_id;
1767: -- l_line_tbl(l_lin_update).header_id := l_line_ids_rec.header_id;
1768: l_line_tbl(l_lin_update).operation := OE_GLOBALS.G_OPR_UPDATE;
1769: l_line_tbl(l_lin_update).request_date := P_New_Request_Date;
1770: l_line_tbl(l_lin_update).change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1771:
1772: l_Process_Line_Entity := TRUE;

Line 1800: l_line_tbl(l_lin_update).operation := OE_GLOBALS.G_OPR_UPDATE;

1796:
1797: -- l_line_tbl(l_lin_update).line_id := l_line_ids_rec.line_id;
1798: -- l_line_tbl(l_lin_update).header_id := l_line_ids_rec.header_id;
1799: l_line_tbl(l_lin_update).ordered_quantity := l_line_ids_rec.ordered_quantity + P_Delta_Ordered_Qty;
1800: l_line_tbl(l_lin_update).operation := OE_GLOBALS.G_OPR_UPDATE;
1801: l_line_tbl(l_lin_update).change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1802:
1803: l_Process_Line_Entity := TRUE;
1804:

Line 1819: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND

1815: IF l_debug_level > 0 THEN
1816: oe_debug_pub.add(' Both Request Date and Ordered Quantity are changed',5);
1817: oe_debug_pub.add(' Check for update of Line_id '||l_line_ids_rec.line_id,5);
1818: END IF;
1819: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND
1820: Update_Allowed( p_Line_id => l_line_ids_rec.line_id
1821: , P_Attribute => 'ALL') THEN
1822:
1823: l_lin_update := l_lin_update + 1;

Line 1832: l_line_tbl(l_lin_update).operation := OE_GLOBALS.G_OPR_UPDATE;

1828:
1829: -- l_line_tbl(l_lin_update).line_id := l_line_ids_rec.line_id;
1830: -- l_line_tbl(l_lin_update).header_id := l_line_ids_rec.header_id;
1831: l_line_tbl(l_lin_update).ordered_quantity := l_line_ids_rec.ordered_quantity + P_Delta_Ordered_Qty;
1832: l_line_tbl(l_lin_update).operation := OE_GLOBALS.G_OPR_UPDATE;
1833: l_line_tbl(l_lin_update).request_date := P_New_Request_Date;
1834: l_line_tbl(l_lin_update).change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1835:
1836: l_Process_Line_Entity := TRUE;

Line 1862: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL

1858: , p_orig_sys_document_line_ref => P_internal_req_line_id
1859: , p_change_sequence => null
1860: , p_source_document_id => l_req_hdr_id
1861: , p_source_document_line_id => P_internal_req_line_id
1862: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL
1863: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);
1864:
1865: Process_Line_Entity
1866: ( p_line_tbl => l_line_tbl

Line 1863: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);

1859: , p_change_sequence => null
1860: , p_source_document_id => l_req_hdr_id
1861: , p_source_document_line_id => P_internal_req_line_id
1862: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL
1863: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);
1864:
1865: Process_Line_Entity
1866: ( p_line_tbl => l_line_tbl
1867: , p_mode => P_mode