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.MTL_TRANSACTIONS_INTERFACE_PKG dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1: PACKAGE BODY MTL_TRANSACTIONS_INTERFACE_PKG as

1: PACKAGE BODY MTL_TRANSACTIONS_INTERFACE_PKG as
2: /* $Header: INVTVPTB.pls 120.2 2006/05/23 13:05:46 pannapra noship $ */
3: /* 31-May-2000 Added three columns Lpn_Id, Transfer_Lpn_Id, Transfer_Cost_Group_Id
4: to take care of inventory enhancements related to WMS changes */
5:

Line 232: FROM MTL_TRANSACTIONS_INTERFACE

228: ---END INVCON kkillams
229: ) IS
230: CURSOR C IS
231: SELECT *
232: FROM MTL_TRANSACTIONS_INTERFACE
233: WHERE rowid = X_Rowid
234: FOR UPDATE of transaction_header_id NOWAIT;
235: Recinfo C%ROWTYPE;
236:

Line 1176: UPDATE MTL_TRANSACTIONS_INTERFACE

1172: number_of_components NUMBER := 0;
1173: l_transaction_batch_id NUMBER;
1174: l_transaction_header_id NUMBER;
1175: BEGIN
1176: UPDATE MTL_TRANSACTIONS_INTERFACE
1177: SET
1178: source_code = X_Source_Code,
1179: source_line_id = X_Source_Line_Id,
1180: source_header_id = X_Source_Header_Id,

Line 1412: from mtl_transactions_interface

1408: -- Bug Fix:4209056
1409:
1410: select transaction_batch_id,transaction_header_id
1411: into l_transaction_batch_id,l_transaction_header_id
1412: from mtl_transactions_interface
1413: where rowid = X_Rowid;
1414:
1415: IF (l_transaction_batch_id IS NOT NULL) THEN
1416:

Line 1417: UPDATE mtl_transactions_interface

1413: where rowid = X_Rowid;
1414:
1415: IF (l_transaction_batch_id IS NOT NULL) THEN
1416:
1417: UPDATE mtl_transactions_interface
1418: SET process_flag = 1
1419: , transaction_mode = 3
1420: , lock_flag = 2
1421: WHERE transaction_header_id = l_transaction_header_id

Line 1425: UPDATE mtl_transactions_interface

1421: WHERE transaction_header_id = l_transaction_header_id
1422: AND transaction_batch_id=l_transaction_batch_id
1423: AND Nvl(lock_flag,2) <> 1;
1424: ELSE
1425: UPDATE mtl_transactions_interface
1426: SET process_flag = 1
1427: , transaction_mode = 3
1428: , lock_flag = 2
1429: where rowid = X_Rowid;

Line 1441: FROM MTL_TRANSACTIONS_INTERFACE

1437: if (X_Process_Flag = 1 and X_Transaction_Type_Id in (44,90,91,17)) then
1438:
1439: SELECT COUNT(*)
1440: INTO NUMBER_OF_COMPONENTS
1441: FROM MTL_TRANSACTIONS_INTERFACE
1442: WHERE PARENT_ID = (SELECT nvl(TRANSACTION_INTERFACE_ID,-9999)
1443: FROM MTL_TRANSACTIONS_INTERFACE
1444: WHERE ROWID = X_Rowid)
1445: AND FLOW_SCHEDULE = 'Y';

Line 1443: FROM MTL_TRANSACTIONS_INTERFACE

1439: SELECT COUNT(*)
1440: INTO NUMBER_OF_COMPONENTS
1441: FROM MTL_TRANSACTIONS_INTERFACE
1442: WHERE PARENT_ID = (SELECT nvl(TRANSACTION_INTERFACE_ID,-9999)
1443: FROM MTL_TRANSACTIONS_INTERFACE
1444: WHERE ROWID = X_Rowid)
1445: AND FLOW_SCHEDULE = 'Y';
1446:
1447: if nvl(NUMBER_OF_COMPONENTS,0) > 0 then

Line 1448: UPDATE MTL_TRANSACTIONS_INTERFACE

1444: WHERE ROWID = X_Rowid)
1445: AND FLOW_SCHEDULE = 'Y';
1446:
1447: if nvl(NUMBER_OF_COMPONENTS,0) > 0 then
1448: UPDATE MTL_TRANSACTIONS_INTERFACE
1449: SET PROCESS_FLAG = 2,
1450: TRANSACTION_MODE = 3,
1451: LOCK_FLAG = 2,
1452: ERROR_CODE = NULL ,

Line 1455: FROM MTL_TRANSACTIONS_INTERFACE

1451: LOCK_FLAG = 2,
1452: ERROR_CODE = NULL ,
1453: ERROR_EXPLANATION = NULL
1454: WHERE PARENT_ID = (SELECT nvl(TRANSACTION_INTERFACE_ID,-9999)
1455: FROM MTL_TRANSACTIONS_INTERFACE
1456: WHERE ROWID = X_Rowid)
1457: AND FLOW_SCHEDULE = 'Y';
1458: end if;
1459: end if;

Line 1476: select transaction_Type_id into x_tran_type_id from mtl_Transactions_interface

1472:
1473: BEGIN
1474:
1475: -- Begin for the bug 2203608
1476: select transaction_Type_id into x_tran_type_id from mtl_Transactions_interface
1477: WHERE rowid = X_Rowid;
1478:
1479: if (x_tran_type_id in (44,90,91,17)) then
1480:

Line 1483: FROM MTL_TRANSACTIONS_INTERFACE

1479: if (x_tran_type_id in (44,90,91,17)) then
1480:
1481: SELECT COUNT(*)
1482: INTO NUMBER_OF_COMPONENTS
1483: FROM MTL_TRANSACTIONS_INTERFACE
1484: WHERE PARENT_ID = (SELECT nvl(TRANSACTION_INTERFACE_ID,-9999)
1485: FROM MTL_TRANSACTIONS_INTERFACE
1486: WHERE ROWID = X_Rowid)
1487: AND FLOW_SCHEDULE = 'Y';

Line 1485: FROM MTL_TRANSACTIONS_INTERFACE

1481: SELECT COUNT(*)
1482: INTO NUMBER_OF_COMPONENTS
1483: FROM MTL_TRANSACTIONS_INTERFACE
1484: WHERE PARENT_ID = (SELECT nvl(TRANSACTION_INTERFACE_ID,-9999)
1485: FROM MTL_TRANSACTIONS_INTERFACE
1486: WHERE ROWID = X_Rowid)
1487: AND FLOW_SCHEDULE = 'Y';
1488:
1489: if nvl(NUMBER_OF_COMPONENTS,0) > 0 then

Line 1490: DELETE FROM MTL_TRANSACTIONS_INTERFACE

1486: WHERE ROWID = X_Rowid)
1487: AND FLOW_SCHEDULE = 'Y';
1488:
1489: if nvl(NUMBER_OF_COMPONENTS,0) > 0 then
1490: DELETE FROM MTL_TRANSACTIONS_INTERFACE
1491: WHERE PARENT_ID = (SELECT nvl(TRANSACTION_INTERFACE_ID,-9999)
1492: FROM MTL_TRANSACTIONS_INTERFACE
1493: WHERE ROWID = X_Rowid)
1494: AND FLOW_SCHEDULE = 'Y';

Line 1492: FROM MTL_TRANSACTIONS_INTERFACE

1488:
1489: if nvl(NUMBER_OF_COMPONENTS,0) > 0 then
1490: DELETE FROM MTL_TRANSACTIONS_INTERFACE
1491: WHERE PARENT_ID = (SELECT nvl(TRANSACTION_INTERFACE_ID,-9999)
1492: FROM MTL_TRANSACTIONS_INTERFACE
1493: WHERE ROWID = X_Rowid)
1494: AND FLOW_SCHEDULE = 'Y';
1495: end if;
1496: end if;

Line 1500: DELETE FROM MTL_TRANSACTIONS_INTERFACE

1496: end if;
1497: --End for the bug 2203608
1498:
1499:
1500: DELETE FROM MTL_TRANSACTIONS_INTERFACE
1501: WHERE rowid = X_Rowid;
1502:
1503: if (SQL%NOTFOUND) then
1504: Raise NO_DATA_FOUND;

Line 1509: END MTL_TRANSACTIONS_INTERFACE_PKG;

1505: end if;
1506: END Delete_Row;
1507:
1508:
1509: END MTL_TRANSACTIONS_INTERFACE_PKG;