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 50: and h.source_document_type_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

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

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

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

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

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

Line 424: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

Line 790: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

786: and l.line_id = oh.line_id
787: and oh.hold_source_id = hs.hold_source_id
788: and hs.hold_id = 17
789: and oh.hold_release_id is null
790: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
791: and h.source_document_id = l_req_hdr_id
792: and l.source_document_line_id = P_internal_req_line_id;
793:
794: IF l_debug_level > 0 THEN

Line 973: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

969: select h.header_id
970: into l_header_id
971: from oe_order_headers_all h
972: where h.source_document_id = p_internal_req_header_id
973: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
974: and h.open_flag = 'Y';
975:
976: IF l_debug_level > 0 THEN
977: oe_debug_pub.add( ' Header id is '||l_header_id,5);

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

1206: from oe_order_lines_all l
1207: -- , oe_order_headers_all h
1208: where nvl(l.shipped_quantity,0) = 0
1209: -- and h.orig_sys_document_ref = p_internal_req_header_id
1210: -- and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1211: -- and h.header_id = v_order_header_id
1212: -- and h.header_id = l.header_id
1213: and l.source_document_id = p_internal_req_header_id
1214: and l.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

Line 1214: and l.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

1210: -- and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1211: -- and h.header_id = v_order_header_id
1212: -- and h.header_id = l.header_id
1213: and l.source_document_id = p_internal_req_header_id
1214: and l.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1215: and l.header_id = v_order_header_id
1216: -- and h.open_flag = 'Y'
1217: and nvl(cancelled_flag,'N') = 'N'
1218: and l.open_flag = 'Y'

Line 1232: l_control_rec OE_GLOBALS.Control_Rec_Type;

1228: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
1229: l_line_ids_rec Line_Id_rec_Type;
1230: l_line_orig_rec OE_Order_PUB.Line_Rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
1231: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1232: l_control_rec OE_GLOBALS.Control_Rec_Type;
1233: l_return_status VARCHAR2(1);
1234: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1235: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1236: l_line_id NUMBER;

Line 1375: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

1371: select header_id
1372: into l_order_header_id
1373: from oe_order_headers_all h
1374: where h.source_document_id = l_req_hdr_id
1375: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1376: and h.open_flag = 'Y';
1377: Exception
1378: WHEN No_Data_found THEN
1379: IF l_debug_level > 0 THEN

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

1411: l_line_tbl(l_cancel_eligble_lin) := l_line_orig_rec;
1412:
1413: -- l_line_tbl(l_cancel_eligble_lin).line_id := l_line_id;
1414: -- l_line_tbl(l_cancel_eligble_lin).header_id := l_header_id;
1415: l_line_tbl(l_cancel_eligble_lin).operation := OE_GLOBALS.G_OPR_UPDATE;
1416: l_line_tbl(l_cancel_eligble_lin).ordered_quantity := 0;
1417: l_line_tbl(l_cancel_eligble_lin).change_reason := 'IR_ISO_CMS_CHG'; -- 'Internal requisition initiated change';
1418: IF (l_line_ord_qty2 IS NOT NULL AND l_line_ord_qty2 <> 0 ) THEN
1419: l_line_tbl(l_cancel_eligble_lin).ordered_quantity2 := 0;

Line 1452: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL

1448: , p_orig_sys_document_line_ref => null
1449: , p_change_sequence => null
1450: , p_source_document_id => l_req_hdr_id
1451: , p_source_document_line_id => null
1452: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL
1453: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);
1454:
1455: OE_Header_Util.lock_Row
1456: ( p_header_id => l_order_header_id

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

1449: , p_change_sequence => null
1450: , p_source_document_id => l_req_hdr_id
1451: , p_source_document_line_id => null
1452: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL
1453: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);
1454:
1455: OE_Header_Util.lock_Row
1456: ( p_header_id => l_order_header_id
1457: , p_x_header_rec => l_header_rec

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

1460: l_old_header_rec := l_header_rec;
1461:
1462: l_header_rec.cancelled_flag :='Y';
1463: l_header_rec.change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1464: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1465:
1466: l_control_rec.controlled_operation := TRUE;
1467: l_control_rec.default_attributes := FALSE;
1468:

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

1566: , x_line_rec => l_line_orig_rec);
1567: l_line_tbl(l_lin_cancel) := l_line_orig_rec;
1568: -- l_line_tbl(l_lin_cancel).line_id := l_line_ids_rec.line_id;
1569: -- l_line_tbl(l_lin_cancel).header_id := l_line_ids_rec.header_id;
1570: l_line_tbl(l_lin_cancel).operation := OE_GLOBALS.G_OPR_UPDATE;
1571: l_line_tbl(l_lin_cancel).ordered_quantity := 0;
1572: l_line_tbl(l_lin_cancel).change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1573: IF (l_line_ids_rec.ordered_quantity2 IS NOT NULL
1574: AND l_line_ids_rec.ordered_quantity2 <> 0 ) THEN

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

1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add(' Only Request Date is changed',5);
1598: oe_debug_pub.add(' Check if update is allowed for line_id '||l_line_ids_rec.line_id,5);
1599: END IF;
1600: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND
1601: Update_Allowed( p_Line_id => l_line_ids_rec.line_id
1602: , P_Attribute => 'REQUEST_DATE') THEN
1603:
1604: IF l_debug_level > 0 THEN

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

1613: l_line_tbl(l_lin_update) := l_line_orig_rec;
1614:
1615: -- l_line_tbl(l_lin_update).line_id := l_line_ids_rec.line_id;
1616: -- l_line_tbl(l_lin_update).header_id := l_line_ids_rec.header_id;
1617: l_line_tbl(l_lin_update).operation := OE_GLOBALS.G_OPR_UPDATE;
1618: l_line_tbl(l_lin_update).request_date := P_New_Request_Date;
1619: l_line_tbl(l_lin_update).change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1620:
1621: l_Process_Line_Entity := TRUE;

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

1645:
1646: -- l_line_tbl(l_lin_update).line_id := l_line_ids_rec.line_id;
1647: -- l_line_tbl(l_lin_update).header_id := l_line_ids_rec.header_id;
1648: l_line_tbl(l_lin_update).ordered_quantity := l_line_ids_rec.ordered_quantity + P_Delta_Ordered_Qty;
1649: l_line_tbl(l_lin_update).operation := OE_GLOBALS.G_OPR_UPDATE;
1650: l_line_tbl(l_lin_update).change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1651:
1652: l_Process_Line_Entity := TRUE;
1653:

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

1664: IF l_debug_level > 0 THEN
1665: oe_debug_pub.add(' Both Request Date and Ordered Quantity are changed',5);
1666: oe_debug_pub.add(' Check for update of Line_id '||l_line_ids_rec.line_id,5);
1667: END IF;
1668: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND
1669: Update_Allowed( p_Line_id => l_line_ids_rec.line_id
1670: , P_Attribute => 'ALL') THEN
1671:
1672: l_lin_update := l_lin_update + 1;

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

1677:
1678: -- l_line_tbl(l_lin_update).line_id := l_line_ids_rec.line_id;
1679: -- l_line_tbl(l_lin_update).header_id := l_line_ids_rec.header_id;
1680: l_line_tbl(l_lin_update).ordered_quantity := l_line_ids_rec.ordered_quantity + P_Delta_Ordered_Qty;
1681: l_line_tbl(l_lin_update).operation := OE_GLOBALS.G_OPR_UPDATE;
1682: l_line_tbl(l_lin_update).request_date := P_New_Request_Date;
1683: l_line_tbl(l_lin_update).change_reason := 'IR_ISO_CMS_CHG'; --'Internal requisition initiated change';
1684:
1685: l_Process_Line_Entity := TRUE;

Line 1711: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL

1707: , p_orig_sys_document_line_ref => P_internal_req_line_id
1708: , p_change_sequence => null
1709: , p_source_document_id => l_req_hdr_id
1710: , p_source_document_line_id => P_internal_req_line_id
1711: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL
1712: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);
1713:
1714: Process_Line_Entity
1715: ( p_line_tbl => l_line_tbl

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

1708: , p_change_sequence => null
1709: , p_source_document_id => l_req_hdr_id
1710: , p_source_document_line_id => P_internal_req_line_id
1711: , p_order_source_id => OE_Globals.G_ORDER_SOURCE_INTERNAL
1712: , p_source_document_type_id => OE_Globals.G_ORDER_SOURCE_INTERNAL);
1713:
1714: Process_Line_Entity
1715: ( p_line_tbl => l_line_tbl
1716: , p_mode => P_mode