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_PURCHASE_RELEASE_PVT dependencies on OE_GLOBALS

Line 88: l_control_rec OE_GLOBALS.control_rec_type;

84: -- For Process Order
85: l_line_rec OE_ORDER_PUB.line_rec_type;
86: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
87: l_line_tbl OE_ORDER_PUB.line_tbl_type;
88: l_control_rec OE_GLOBALS.control_rec_type;
89:
90: l_valid_employee VARCHAR2(25);
91: l_temp_employee_Id NUMBER; -- Temp ID got from profile option
92: l_order_source_id NUMBER;

Line 166: l_user_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'USER_ID');

162:
163:
164: /* Added for the bug 6118936 */
165:
166: l_user_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'USER_ID');
167: l_resp_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'RESPONSIBILITY_ID');
168: l_application_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'APPLICATION_ID');
169:
170:

Line 167: l_resp_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'RESPONSIBILITY_ID');

163:
164: /* Added for the bug 6118936 */
165:
166: l_user_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'USER_ID');
167: l_resp_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'RESPONSIBILITY_ID');
168: l_application_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'APPLICATION_ID');
169:
170:
171: IF l_debug_level > 0 THEN

Line 168: l_application_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'APPLICATION_ID');

164: /* Added for the bug 6118936 */
165:
166: l_user_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'USER_ID');
167: l_resp_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'RESPONSIBILITY_ID');
168: l_application_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'APPLICATION_ID');
169:
170:
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add('User id => ' ||l_user_id,1);

Line 181: IF FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD') = OE_GLOBALS.G_IIFM_PICK_RELEASE THEN

177:
178: /* End of bug 6118936 */
179:
180:
181: IF FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD') = OE_GLOBALS.G_IIFM_PICK_RELEASE THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add('may need to freeze inc items',5);
184: END IF;
185:

Line 220: IF (l_drop_ship_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE) THEN

216: p_mode => p_mode);
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add('Source Type Code => '||l_drop_ship_line_rec.source_type_code,5);
219: END IF;
220: IF (l_drop_ship_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE) THEN
221: OPEN C_Payment_Type(l_drop_ship_line_rec.header_id);
222: FETCH C_Payment_Type INTO l_payment_type;
223: CLOSE C_Payment_Type;
224:

Line 434: IF NOT OE_GLOBALS.Equal(l_drop_ship_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL) THEN

430: oe_debug_pub.add('Item type code ' || l_drop_ship_line_rec.item_type_code , 1 ) ;
431: END IF;
432:
433:
434: IF NOT OE_GLOBALS.Equal(l_drop_ship_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
435: IF l_debug_level > 0 THEN
436: oe_debug_pub.add('Wrong source type '|| l_drop_ship_line_rec.line_id,3);
437: END IF;
438: l_drop_ship_line_rec.result := G_RES_NOT_APPLICABLE;

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

474: l_old_line_tbl(1) := l_line_rec;
475:
476: l_line_rec.schedule_ship_date := l_line_rec.request_date;
477:
478: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
479: l_line_tbl(1) := l_line_rec;
480:
481: /* Start Audit Trail */
482: l_line_tbl(1).change_reason := 'SYSTEM';

Line 491: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;

487: l_control_rec.change_attributes := TRUE;
488: l_control_rec.validate_entity := TRUE;
489: l_control_rec.write_to_DB := TRUE;
490: l_control_rec.check_security := TRUE;
491: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
492: l_control_rec.process := TRUE;
493:
494: -- Instruct API to retain its caches
495:

Line 1086: AND sl.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL;

1082: AND sl.inventory_item_id = msi.inventory_item_id
1083: AND sl.ship_from_org_id = msi.organization_id
1084: AND mp.organization_id = msi.organization_id
1085: AND sl.ship_to_org_id = pla.site_use_id(+)
1086: AND sl.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL;
1087:
1088: l_drop_ship_line_rec Drop_Ship_Line_Rec_Type;
1089: l_drop_ship_tbl Drop_Ship_Tbl_Type;
1090: l_line_count NUMBER;

Line 1383: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param1

1379: END IF;
1380:
1381: IF p_request_tbl(I).param15 = 'UPDATE' THEN
1382:
1383: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param1
1384: ,p_request_tbl(I).param8) THEN
1385:
1386: IF l_req_created = 'N' THEN
1387: l_ds_quantity := p_request_tbl(I).param8;

Line 1410: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param2

1406:
1407: END IF;
1408:
1409:
1410: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param2
1411: ,p_request_tbl(I).param9) THEN
1412: IF l_req_created = 'N' THEN
1413: l_ds_ordered_quantity_uom := p_request_tbl(I).param9;
1414: END IF;

Line 1426: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param3

1422:
1423:
1424: END IF;
1425:
1426: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param3
1427: ,p_request_tbl(I).param10) THEN
1428:
1429: l_ds_new_ship_to_location_id := Get_Shipto_Location_id(p_request_tbl(I).param10);
1430: l_ds_old_ship_to_location_id := Get_Shipto_Location_id(p_request_tbl(I).param3);

Line 1432: IF NOT OE_GLOBALS.EQUAL(l_ds_new_ship_to_location_id,

1428:
1429: l_ds_new_ship_to_location_id := Get_Shipto_Location_id(p_request_tbl(I).param10);
1430: l_ds_old_ship_to_location_id := Get_Shipto_Location_id(p_request_tbl(I).param3);
1431:
1432: IF NOT OE_GLOBALS.EQUAL(l_ds_new_ship_to_location_id,
1433: l_ds_old_ship_to_location_id) THEN
1434:
1435: IF l_req_created = 'N' THEN
1436: l_ds_ship_to_location_id := l_ds_new_ship_to_location_id;

Line 1463: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param4

1459: END IF;
1460:
1461:
1462:
1463: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param4
1464: ,p_request_tbl(I).param11) THEN
1465:
1466: IF l_req_created = 'N' THEN
1467: l_ds_ordered_quantity2 := p_request_tbl(I).param11;

Line 1490: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param5

1486:
1487: END IF;
1488:
1489:
1490: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param5
1491: ,p_request_tbl(I).param12) THEN
1492:
1493: IF l_req_created = 'N' THEN
1494: l_ds_ordered_quantity_uom2 := p_request_tbl(I).param12;

Line 1506: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param6

1502: END IF;
1503:
1504: END IF;
1505:
1506: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param6
1507: ,p_request_tbl(I).param13) THEN
1508:
1509: IF l_req_created = 'N' THEN
1510: l_ds_preferred_grade := p_request_tbl(I).param13;

Line 1526: -- IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param7 ,p_request_tbl(I).param14) THEN

1522:
1523:
1524: /*****Begin changes for bug#6918700*********/
1525:
1526: -- IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param7 ,p_request_tbl(I).param14) THEN
1527:
1528: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).date_param1 ,p_request_tbl(I).date_param2) THEN
1529: /*****End changes for bug#6918700*********/
1530:

Line 1528: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).date_param1 ,p_request_tbl(I).date_param2) THEN

1524: /*****Begin changes for bug#6918700*********/
1525:
1526: -- IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).param7 ,p_request_tbl(I).param14) THEN
1527:
1528: IF NOT OE_GLOBALS.EQUAL(p_request_tbl(I).date_param1 ,p_request_tbl(I).date_param2) THEN
1529: /*****End changes for bug#6918700*********/
1530:
1531: IF l_req_created = 'N' THEN
1532: /*****Begin changes for bug#6918700*********/