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.

[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on FND_GLOBAL

Line 1266: FND_GLOBAL.USER_ID,

1262: 'PENDING',
1263: 'VENDOR',
1264: 'NEW',
1265: SYSDATE,
1266: FND_GLOBAL.USER_ID,
1267: FND_GLOBAL.LOGIN_ID,
1268: SYSDATE,
1269: FND_GLOBAL.USER_ID,
1270: l_po_vendor_id,

Line 1267: FND_GLOBAL.LOGIN_ID,

1263: 'VENDOR',
1264: 'NEW',
1265: SYSDATE,
1266: FND_GLOBAL.USER_ID,
1267: FND_GLOBAL.LOGIN_ID,
1268: SYSDATE,
1269: FND_GLOBAL.USER_ID,
1270: l_po_vendor_id,
1271: l_po_vendor_site_id,

Line 1269: FND_GLOBAL.USER_ID,

1265: SYSDATE,
1266: FND_GLOBAL.USER_ID,
1267: FND_GLOBAL.LOGIN_ID,
1268: SYSDATE,
1269: FND_GLOBAL.USER_ID,
1270: l_po_vendor_id,
1271: l_po_vendor_site_id,
1272: l_ship_to_org_id
1273: );

Line 1317: FND_GLOBAL.USER_ID,

1313: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1314: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1315: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1316: SYSDATE,
1317: FND_GLOBAL.USER_ID,
1318: FND_GLOBAL.LOGIN_ID,
1319: SYSDATE,
1320: FND_GLOBAL.USER_ID,
1321: 'RECEIVE',

Line 1318: FND_GLOBAL.LOGIN_ID,

1314: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1315: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1316: SYSDATE,
1317: FND_GLOBAL.USER_ID,
1318: FND_GLOBAL.LOGIN_ID,
1319: SYSDATE,
1320: FND_GLOBAL.USER_ID,
1321: 'RECEIVE',
1322: SYSDATE,

Line 1320: FND_GLOBAL.USER_ID,

1316: SYSDATE,
1317: FND_GLOBAL.USER_ID,
1318: FND_GLOBAL.LOGIN_ID,
1319: SYSDATE,
1320: FND_GLOBAL.USER_ID,
1321: 'RECEIVE',
1322: SYSDATE,
1323: 'PENDING',
1324: 'BATCH',

Line 2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;

2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
2201:
2202: --Insert values into the RCV_HEADERS_INTERFACE

Line 2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;

2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
2201:
2202: --Insert values into the RCV_HEADERS_INTERFACE
2203: INSERT INTO RCV_HEADERS_INTERFACE

Line 2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;

2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
2201:
2202: --Insert values into the RCV_HEADERS_INTERFACE
2203: INSERT INTO RCV_HEADERS_INTERFACE
2204: (

Line 2419: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,

2415: VALUES
2416: (
2417: l_mtl_transaction_id, --TRANSACTION_INTERFACE_ID,
2418: SYSDATE, --LAST_UPDATE_DATE,
2419: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2420: SYSDATE, --CREATION_DATE,
2421: FND_GLOBAL.USER_ID, --CREATED_BY,
2422: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2423: l_trans_lot_number, --LOT_NUMBER,

Line 2421: FND_GLOBAL.USER_ID, --CREATED_BY,

2417: l_mtl_transaction_id, --TRANSACTION_INTERFACE_ID,
2418: SYSDATE, --LAST_UPDATE_DATE,
2419: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2420: SYSDATE, --CREATION_DATE,
2421: FND_GLOBAL.USER_ID, --CREATED_BY,
2422: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2423: l_trans_lot_number, --LOT_NUMBER,
2424: p_rma_receipt_rec.RECEIPT_QUANTITY, --TRANSACTION_QUANTITY
2425: p_rma_receipt_rec.RECEIPT_QUANTITY, --PRIMARY_QUANTITY

Line 2422: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,

2418: SYSDATE, --LAST_UPDATE_DATE,
2419: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2420: SYSDATE, --CREATION_DATE,
2421: FND_GLOBAL.USER_ID, --CREATED_BY,
2422: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2423: l_trans_lot_number, --LOT_NUMBER,
2424: p_rma_receipt_rec.RECEIPT_QUANTITY, --TRANSACTION_QUANTITY
2425: p_rma_receipt_rec.RECEIPT_QUANTITY, --PRIMARY_QUANTITY
2426: 'RCV', --PRODUCT_CODE,

Line 2450: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,

2446: VALUES
2447: (
2448: l_mtl_transaction_id, --TRANSACTION_INTERFACE_ID,
2449: SYSDATE, --LAST_UPDATE_DATE,
2450: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2451: SYSDATE, --CREATION_DATE,
2452: FND_GLOBAL.USER_ID, --CREATED_BY,
2453: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2454: l_trans_serial_number, --FM_SERIAL_NUMBER,

Line 2452: FND_GLOBAL.USER_ID, --CREATED_BY,

2448: l_mtl_transaction_id, --TRANSACTION_INTERFACE_ID,
2449: SYSDATE, --LAST_UPDATE_DATE,
2450: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2451: SYSDATE, --CREATION_DATE,
2452: FND_GLOBAL.USER_ID, --CREATED_BY,
2453: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2454: l_trans_serial_number, --FM_SERIAL_NUMBER,
2455: l_trans_serial_number, --TO_SERIAL_NUMBER,
2456: 'RCV', --PRODUCT_CODE,

Line 2453: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,

2449: SYSDATE, --LAST_UPDATE_DATE,
2450: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY,
2451: SYSDATE, --CREATION_DATE,
2452: FND_GLOBAL.USER_ID, --CREATED_BY,
2453: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
2454: l_trans_serial_number, --FM_SERIAL_NUMBER,
2455: l_trans_serial_number, --TO_SERIAL_NUMBER,
2456: 'RCV', --PRODUCT_CODE,
2457: l_intf_transaction_id --PRODUCT_TRANSACTION_ID