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.POR_RCV_ORD_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 354: delete from rcv_transactions_interface

350: x_progress := 'groupPoTransaction 040 sql exception ' || substr(SQLERRM,12,200);
351:
352: asn_debug.put_line(x_progress);
353:
354: delete from rcv_transactions_interface
355: where group_id = X_group_id;
356:
357: PO_REQS_CONTROL_SV.commit_changes;
358:

Line 546: delete from rcv_transactions_interface

542: x_progress := 'groupInternalTransaction 040 sql exception ' || substr(SQLERRM,12,200);
543:
544: asn_debug.put_line(x_progress);
545:
546: delete from rcv_transactions_interface
547: where group_id = X_group_id;
548:
549: PO_REQS_CONTROL_SV.commit_changes;
550:

Line 639: INSERT INTO RCV_TRANSACTIONS_INTERFACE (

635: asn_debug.put_line(x_progress);
636: x_progress := 'insert internal transaction, primary_uom= ' || X_primary_uom ||'; primary_qty=' || to_char(X_primary_qty);
637: asn_debug.put_line(x_progress);
638:
639: INSERT INTO RCV_TRANSACTIONS_INTERFACE (
640: INTERFACE_TRANSACTION_ID,
641: GROUP_ID,
642: ORG_ID,
643: LAST_UPDATE_DATE,

Line 706: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

702: REQUISITION_LINE_ID,
703: COMMENTS,
704: WAYBILL_AIRBILL_NUM,
705: USSGL_TRANSACTION_CODE )
706: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
707: X_group_id,
708: MO_GLOBAL.get_current_org_id,
709: SYSDATE,
710: X_user_id,

Line 953: /* Insert the rows that were checked into RCV_TRANSACTIONS_INTERFACE */

949: end if;
950:
951: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE X_receipt_qty' || X_receipt_qty || ' X_receipt_amt ' || X_receipt_amt);
952:
953: /* Insert the rows that were checked into RCV_TRANSACTIONS_INTERFACE */
954:
955: SELECT POD.DESTINATION_TYPE_CODE,
956: 'PO',
957: NVL(POLL.PROMISED_DATE, POLL.NEED_BY_DATE),

Line 1052: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE Inserting values in RCV_TRANSACTIONS_INTERFACE');

1048: POH.PO_HEADER_ID = x_po_header_id and
1049: POLL.LINE_LOCATION_ID = x_line_location_id and
1050: POD.PO_DISTRIBUTION_ID = X_po_distribution_id;
1051:
1052: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE Inserting values in RCV_TRANSACTIONS_INTERFACE');
1053:
1054: INSERT INTO RCV_TRANSACTIONS_INTERFACE (
1055: INTERFACE_TRANSACTION_ID,
1056: GROUP_ID,

Line 1054: INSERT INTO RCV_TRANSACTIONS_INTERFACE (

1050: POD.PO_DISTRIBUTION_ID = X_po_distribution_id;
1051:
1052: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE Inserting values in RCV_TRANSACTIONS_INTERFACE');
1053:
1054: INSERT INTO RCV_TRANSACTIONS_INTERFACE (
1055: INTERFACE_TRANSACTION_ID,
1056: GROUP_ID,
1057: ORG_ID,
1058: LAST_UPDATE_DATE,

Line 1125: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

1121: USSGL_TRANSACTION_CODE,
1122: JOB_ID,
1123: MATCHING_BASIS,
1124: COUNTRY_OF_ORIGIN_CODE)
1125: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1126: X_group_id,
1127: MO_GLOBAL.get_current_org_id,
1128: SYSDATE,
1129: X_user_id,

Line 1251: from rcv_transactions_interface rti

1247:
1248: begin
1249: select org_id
1250: into x_txn_org_id
1251: from rcv_transactions_interface rti
1252: where rti.group_id = x_group_id and rownum = 1;
1253:
1254: asn_debug.put_line('process_transactions x_txn_org_id:' || x_txn_org_id);
1255:

Line 1370: FROM RCV_TRANSACTIONS_INTERFACE RTI, PO_DISTRIBUTIONS_ALL POD

1366:
1367: cursor c0 is
1368: SELECT RTI.TO_ORGANIZATION_ID,
1369: RTI.VENDOR_ID, RTI.WAYBILL_AIRBILL_NUM, POD.ORG_ID
1370: FROM RCV_TRANSACTIONS_INTERFACE RTI, PO_DISTRIBUTIONS_ALL POD
1371: WHERE GROUP_ID = X_GROUP_ID AND
1372: SHIPMENT_LINE_ID IS NULL AND
1373: RTI.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
1374: GROUP BY RTI.TO_ORGANIZATION_ID, RTI.VENDOR_ID, RTI.WAYBILL_AIRBILL_NUM, POD.ORG_ID;

Line 1380: from rcv_transactions_interface

1376: /*
1377: cursor c0 is
1378: select distinct to_organization_id,
1379: vendor_id,waybill_airbill_num
1380: from rcv_transactions_interface
1381: where group_id = X_group_id and shipment_line_id is null;
1382: -- for update of shipment_header_id;
1383: */
1384:

Line 1387: from rcv_transactions_interface

1383: */
1384:
1385: cursor c1 is
1386: select to_organization_id, shipment_header_id, comments, packing_slip,waybill_airbill_num
1387: from rcv_transactions_interface
1388: where group_id = X_group_id and shipment_line_id is not null and
1389: shipment_header_id is not null;
1390:
1391: cursor c2 is

Line 1393: from rcv_transactions_interface trans

1389: shipment_header_id is not null;
1390:
1391: cursor c2 is
1392: select distinct shipment_header_id
1393: from rcv_transactions_interface trans
1394: where group_id = X_group_id and shipment_line_id is not null and
1395: shipment_header_id is not null;
1396:
1397:

Line 1400: X_vendor_id rcv_transactions_interface.vendor_id%type;

1396:
1397:
1398: X_sysdate date := SYSDATE;
1399: X_userid number := 0;
1400: X_vendor_id rcv_transactions_interface.vendor_id%type;
1401: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1402: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1403: X_receipt_num rcv_shipment_headers.receipt_num%type;
1404: X_created_by rcv_shipment_headers.created_by%type;

Line 1402: X_to_org_id rcv_transactions_interface.to_organization_id%type;

1398: X_sysdate date := SYSDATE;
1399: X_userid number := 0;
1400: X_vendor_id rcv_transactions_interface.vendor_id%type;
1401: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1402: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1403: X_receipt_num rcv_shipment_headers.receipt_num%type;
1404: X_created_by rcv_shipment_headers.created_by%type;
1405: X_last_update_login rcv_shipment_headers.last_update_login%type;
1406: X_count number := 0;

Line 1424: X_vendor_site_id rcv_transactions_interface.vendor_site_id%type;

1420: x_new_comments VARCHAR2(240);
1421: x_new_packingSlip VARCHAR2(25);
1422: x_new_waybillNum VARCHAR2(20);
1423: x_asn_type VARCHAR2(25);
1424: X_vendor_site_id rcv_transactions_interface.vendor_site_id%type;
1425:
1426: begin
1427:
1428: X_created_by := fnd_global.user_id;

Line 1534: update rcv_transactions_interface

1530: x_line_waybill_airbill_num,
1531: NULL);
1532:
1533: IF x_line_waybill_airbill_num IS NULL THEN
1534: update rcv_transactions_interface
1535: set shipment_header_id = x_shipment_header_id
1536: where group_id = X_group_id
1537: and to_organization_id = x_to_org_id
1538: and vendor_id = x_vendor_id

Line 1543: update rcv_transactions_interface

1539: and shipment_line_id is null
1540: AND waybill_airbill_num IS NULL;
1541: x_req_number := NULL;
1542: ELSE
1543: update rcv_transactions_interface
1544: set shipment_header_id = x_shipment_header_id
1545: where group_id = X_group_id
1546: and to_organization_id = x_to_org_id
1547: and vendor_id = x_vendor_id

Line 1556: FROM rcv_transactions_interface

1552:
1553: BEGIN
1554: SELECT distinct vendor_site_id
1555: INTO X_vendor_site_id
1556: FROM rcv_transactions_interface
1557: WHERE group_id = X_group_id and
1558: shipment_header_id = x_shipment_header_id;
1559:
1560: asn_debug.put_line('vendor_site='||to_char(X_vendor_site_id));

Line 1714: from rcv_transactions_interface rti

1710:
1711: begin
1712: select org_id
1713: into x_txn_org_id
1714: from rcv_transactions_interface rti
1715: where rti.group_id = x_group_id and rownum = 1;
1716:
1717: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1718: mo_global.set_policy_context(p_access_mode => 'S',

Line 1904: delete from rcv_transactions_interface

1900: if (delete_rows) then
1901:
1902: BEGIN
1903:
1904: delete from rcv_transactions_interface
1905: where group_id = X_group_id;
1906:
1907:
1908: PO_REQS_CONTROL_SV.commit_changes;

Line 1954: FROM RCV_TRANSACTIONS_INTERFACE

1950: BEGIN
1951:
1952: SELECT COUNT(1)
1953: INTO x_rec_count
1954: FROM RCV_TRANSACTIONS_INTERFACE
1955: WHERE group_id = x_group_id;
1956:
1957: IF (x_rec_count = 0) THEN
1958: