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.RCV_PROCESSOR_PVT dependencies on RCV_TRANSACTIONS

Line 27: rcv_transactions rt

23: ) IS
24: CURSOR c IS
25: SELECT rls.ROWID
26: FROM rcv_lots_supply rls,
27: rcv_transactions rt
28: WHERE rt.interface_transaction_id = p_interface_transaction_id
29: AND rls.transaction_id = rt.transaction_id;
30:
31: l_rowid VARCHAR2(255);

Line 32: l_transaction_id rcv_transactions.transaction_id%TYPE;

28: WHERE rt.interface_transaction_id = p_interface_transaction_id
29: AND rls.transaction_id = rt.transaction_id;
30:
31: l_rowid VARCHAR2(255);
32: l_transaction_id rcv_transactions.transaction_id%TYPE;
33: l_lot_count NUMBER;
34: l_organization_id NUMBER;
35: l_lpn_id rcv_supply.lpn_id%TYPE;
36: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

Line 36: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

32: l_transaction_id rcv_transactions.transaction_id%TYPE;
33: l_lot_count NUMBER;
34: l_organization_id NUMBER;
35: l_lpn_id rcv_supply.lpn_id%TYPE;
36: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
37: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
38:
39: CURSOR lot_numbers(
40: l_interface_id NUMBER

Line 50: rcv_transactions_interface rti

46: rti.item_id,
47: rti.unit_of_measure,
48: rti.to_organization_id
49: FROM mtl_transaction_lots_temp mtlt,
50: rcv_transactions_interface rti
51: WHERE product_transaction_id = l_interface_id
52: AND product_code = 'RCV'
53: AND rti.interface_transaction_id = mtlt.product_transaction_id
54: GROUP BY mtlt.lot_number,

Line 89: l_item_id rcv_transactions_interface.item_id%TYPE;

85: l_ship_id NUMBER;
86: l_ship_line_id NUMBER;
87: l_rls_qty NUMBER;
88: l_rls_primary_qty NUMBER;
89: l_item_id rcv_transactions_interface.item_id%TYPE;
90: l_parent_uom VARCHAR2(25);
91: l_txn_uom VARCHAR2(25);
92: l_primary_uom VARCHAR2(25);
93: l_to_org_id NUMBER;

Line 132: FROM rcv_transactions_interface

128: * a value and validation_flag is N.
129: */
130: SELECT NVL(validation_flag, 'N')
131: INTO l_validation_flag
132: FROM rcv_transactions_interface
133: WHERE interface_transaction_id = p_interface_transaction_id;
134:
135: SELECT NVL(lpn_id, -999)
136: INTO l_lpn_id

Line 154: FROM rcv_transactions rt

150: SELECT transaction_id,
151: organization_id
152: INTO l_transaction_id,
153: l_organization_id
154: FROM rcv_transactions rt
155: WHERE rt.interface_transaction_id = p_interface_transaction_id;
156:
157: IF (g_asn_debug = 'Y') THEN
158: asn_debug.put_line('before insert_lot_supply');

Line 269: l_qty_to_be_updated := rcv_transactions_interface_sv.convert_into_correct_qty(l_primary_qty_to_be_updated,

265: asn_debug.put_line('l_parent_uom ' || l_parent_uom);
266: END IF;
267:
268: IF (l_txn_uom <> l_parent_uom) THEN
269: l_qty_to_be_updated := rcv_transactions_interface_sv.convert_into_correct_qty(l_primary_qty_to_be_updated,
270: l_primary_uom,
271: l_item_id,
272: l_parent_uom
273: );

Line 380: FROM rcv_transactions_interface rti

376: rti.request_id,
377: rti.program_application_id,
378: rti.program_id,
379: rti.program_update_date
380: FROM rcv_transactions_interface rti
381: WHERE rti.interface_transaction_id = p_interface_transaction_id;
382: WHEN OTHERS THEN
383: IF (g_asn_debug = 'Y') THEN
384: asn_debug.put_line('others insert_rcv_lots_supply');

Line 417: FROM rcv_transactions_interface rti

413: rti.request_id,
414: rti.program_application_id,
415: rti.program_id,
416: rti.program_update_date
417: FROM rcv_transactions_interface rti
418: WHERE rti.interface_transaction_id = p_interface_transaction_id;
419: END insert_rcv_lots_supply;
420:
421: --

Line 455: l_transaction_id rcv_transactions.transaction_id%TYPE;

451: l_cur_serial_number VARCHAR2(30);
452: l_range_numbers NUMBER;
453: l_serial_suffix_length NUMBER;
454: l_delete_shipment_supply VARCHAR2(1) := 'N';
455: l_transaction_id rcv_transactions.transaction_id%TYPE;
456: l_serial_count NUMBER;
457: l_lpn_id rcv_supply.lpn_id%TYPE;
458: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
459: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;

Line 458: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

454: l_delete_shipment_supply VARCHAR2(1) := 'N';
455: l_transaction_id rcv_transactions.transaction_id%TYPE;
456: l_serial_count NUMBER;
457: l_lpn_id rcv_supply.lpn_id%TYPE;
458: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
459: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
460: l_item_id rcv_transactions_interface.item_id%TYPE;
461: BEGIN
462: IF (g_asn_debug = 'Y') THEN

Line 460: l_item_id rcv_transactions_interface.item_id%TYPE;

456: l_serial_count NUMBER;
457: l_lpn_id rcv_supply.lpn_id%TYPE;
458: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
459: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
460: l_item_id rcv_transactions_interface.item_id%TYPE;
461: BEGIN
462: IF (g_asn_debug = 'Y') THEN
463: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);
464: asn_debug.put_line('p_shipment_line_id ' || p_shipment_line_id);

Line 499: FROM rcv_transactions_interface

495: * a value and validation_flag is N.
496: */
497: SELECT NVL(validation_flag, 'N')
498: INTO l_validation_flag
499: FROM rcv_transactions_interface
500: WHERE interface_transaction_id = p_interface_transaction_id;
501:
502: SELECT NVL(lpn_id, -999)
503: INTO l_lpn_id

Line 561: FROM rcv_transactions rt

557:
558: /* End Bug#3359105 */
559: SELECT transaction_id
560: INTO l_transaction_id
561: FROM rcv_transactions rt
562: WHERE rt.interface_transaction_id = p_interface_transaction_id;
563:
564: IF (g_asn_debug = 'Y') THEN
565: asn_debug.put_line('l_range_numbers ' || l_range_numbers);

Line 677: FROM rcv_transactions_interface rti

673: rti.request_id,
674: rti.program_application_id,
675: rti.program_id,
676: rti.program_update_date
677: FROM rcv_transactions_interface rti
678: WHERE rti.interface_transaction_id = p_interface_transaction_id;
679: WHEN OTHERS THEN
680: IF (g_asn_debug = 'Y') THEN
681: asn_debug.put_line('others insert_rcv_serials_supply ');

Line 714: FROM rcv_transactions_interface rti

710: rti.request_id,
711: rti.program_application_id,
712: rti.program_id,
713: rti.program_update_date
714: FROM rcv_transactions_interface rti
715: WHERE rti.interface_transaction_id = p_interface_transaction_id;
716: END insert_rcv_serials_supply;
717:
718: PROCEDURE split_serial_number(

Line 787: rcv_transactions_interface rti

783: rti.item_id,
784: rti.unit_of_measure,
785: rti.to_organization_id
786: FROM mtl_transaction_lots_temp mtlt,
787: rcv_transactions_interface rti
788: WHERE product_transaction_id = p_interface_id
789: AND product_code = 'RCV'
790: AND rti.interface_transaction_id = mtlt.product_transaction_id
791: GROUP BY mtlt.lot_number,

Line 806: l_parent_trans_type rcv_transactions.transaction_type%TYPE;

802: * Changed the declaration of l_lot_num from varchar2(30) to rcv_lots_supply.lot_num%TYPE
803: */
804: l_lot_num rcv_lots_supply.lot_num%TYPE;
805: l_factor NUMBER;
806: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
807: l_count NUMBER;
808: l_count1 NUMBER;
809: l_count2 NUMBER;
810: l_transaction_id rcv_transactions.transaction_id%TYPE;

Line 810: l_transaction_id rcv_transactions.transaction_id%TYPE;

806: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
807: l_count NUMBER;
808: l_count1 NUMBER;
809: l_count2 NUMBER;
810: l_transaction_id rcv_transactions.transaction_id%TYPE;
811: l_lot_count NUMBER;
812: l_update_shipment_supply VARCHAR2(1) := 'N';
813: l_organization_id NUMBER;
814: /* INVCONV*/

Line 818: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

814: /* INVCONV*/
815: /* l_sublot_num VARCHAR2(32); */
816: /*end , INVCONV*/
817: l_lpn_id rcv_supply.lpn_id%TYPE;
818: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
819: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
820:
821: CURSOR supply_quantity(
822: l_lot_num VARCHAR2,

Line 871: l_item_id rcv_transactions_interface.item_id%TYPE;

867: l_ship_id NUMBER;
868: l_ship_line_id NUMBER;
869: l_rls_qty NUMBER;
870: l_rls_primary_qty NUMBER;
871: l_item_id rcv_transactions_interface.item_id%TYPE;
872: l_parent_uom VARCHAR2(25);
873: l_parent_secondary_uom VARCHAR2(25);
874: l_txn_uom VARCHAR2(25);
875: l_primary_uom VARCHAR2(25);

Line 917: FROM rcv_transactions_interface

913: * a value and validation_flag is N.
914: */
915: SELECT NVL(validation_flag, 'N')
916: INTO l_validation_flag
917: FROM rcv_transactions_interface
918: WHERE interface_transaction_id = p_interface_transaction_id;
919:
920: SELECT NVL(lpn_id, -999)
921: INTO l_lpn_id

Line 971: FROM rcv_transactions

967: INTO l_parent_trans_type,
968: l_organization_id,
969: l_parent_uom,
970: l_parent_secondary_uom
971: FROM rcv_transactions
972: WHERE transaction_id = p_parent_supply_id;
973:
974: /* INVCONV , Update for OPM transactions also. Punit Kumar */
975:

Line 1088: l_qty_to_be_updated := rcv_transactions_interface_sv.convert_into_correct_qty(l_primary_qty_to_be_updated,

1084: * shipment supply qty, it must be
1085: * in terms of uom in rsl.
1086: */
1087: IF (l_txn_uom <> l_parent_uom) THEN
1088: l_qty_to_be_updated := rcv_transactions_interface_sv.convert_into_correct_qty(l_primary_qty_to_be_updated,
1089: l_primary_uom,
1090: l_item_id,
1091: l_parent_uom
1092: );

Line 1209: l_qty_to_be_updated := rcv_transactions_interface_sv.convert_into_correct_qty(l_primary_qty_to_be_updated,

1205: asn_debug.put_line('l_parent_uom ' || l_parent_uom);
1206: END IF;
1207:
1208: IF (l_txn_uom <> l_parent_uom) THEN
1209: l_qty_to_be_updated := rcv_transactions_interface_sv.convert_into_correct_qty(l_primary_qty_to_be_updated,
1210: l_primary_uom,
1211: l_item_id,
1212: l_parent_uom
1213: );

Line 1339: FROM rcv_transactions_interface rti

1335: rti.request_id,
1336: rti.program_application_id,
1337: rti.program_id,
1338: rti.program_update_date
1339: FROM rcv_transactions_interface rti
1340: WHERE rti.interface_transaction_id = p_interface_transaction_id;
1341: WHEN OTHERS THEN
1342: IF (g_asn_debug = 'Y') THEN
1343: asn_debug.put_line('others update_rcv_lots_supply ');

Line 1376: FROM rcv_transactions_interface rti

1372: rti.request_id,
1373: rti.program_application_id,
1374: rti.program_id,
1375: rti.program_update_date
1376: FROM rcv_transactions_interface rti
1377: WHERE rti.interface_transaction_id = p_interface_transaction_id;
1378: END update_rcv_lots_supply;
1379:
1380: PROCEDURE update_rcv_serials_supply(

Line 1418: l_parent_trans_type rcv_transactions.transaction_type%TYPE;

1414: l_cur_serial_number VARCHAR2(30);
1415: l_range_numbers NUMBER;
1416: l_serial_count NUMBER;
1417: l_update_shipment_supply VARCHAR2(1) := 'N';
1418: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
1419: l_lpn_id rcv_supply.lpn_id%TYPE;
1420: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1421: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
1422: l_item_id rcv_transactions_interface.item_id%TYPE;

Line 1420: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

1416: l_serial_count NUMBER;
1417: l_update_shipment_supply VARCHAR2(1) := 'N';
1418: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
1419: l_lpn_id rcv_supply.lpn_id%TYPE;
1420: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1421: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
1422: l_item_id rcv_transactions_interface.item_id%TYPE;
1423: BEGIN
1424: IF (g_asn_debug = 'Y') THEN

Line 1422: l_item_id rcv_transactions_interface.item_id%TYPE;

1418: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
1419: l_lpn_id rcv_supply.lpn_id%TYPE;
1420: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1421: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
1422: l_item_id rcv_transactions_interface.item_id%TYPE;
1423: BEGIN
1424: IF (g_asn_debug = 'Y') THEN
1425: asn_debug.put_line('Enter update_rcv_serials_supply ');
1426: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);

Line 1463: FROM rcv_transactions_interface

1459: * a value and validation_flag is N.
1460: */
1461: SELECT NVL(validation_flag, 'N')
1462: INTO l_validation_flag
1463: FROM rcv_transactions_interface
1464: WHERE interface_transaction_id = p_interface_transaction_id;
1465:
1466: SELECT NVL(lpn_id, -999)
1467: INTO l_lpn_id

Line 1509: FROM rcv_transactions

1505: END IF;
1506:
1507: SELECT transaction_type
1508: INTO l_parent_trans_type
1509: FROM rcv_transactions
1510: WHERE transaction_id = p_parent_supply_id;
1511:
1512: IF ( p_transaction_type = 'CORRECTION'
1513: AND l_parent_trans_type = 'RECEIVE'

Line 1696: FROM rcv_transactions_interface rti

1692: rti.request_id,
1693: rti.program_application_id,
1694: rti.program_id,
1695: rti.program_update_date
1696: FROM rcv_transactions_interface rti
1697: WHERE rti.interface_transaction_id = p_interface_transaction_id;
1698: WHEN OTHERS THEN
1699: IF (g_asn_debug = 'Y') THEN
1700: asn_debug.put_line('others update_rcv_serials_supply');

Line 1733: FROM rcv_transactions_interface rti

1729: rti.request_id,
1730: rti.program_application_id,
1731: rti.program_id,
1732: rti.program_update_date
1733: FROM rcv_transactions_interface rti
1734: WHERE rti.interface_transaction_id = p_interface_transaction_id;
1735: END update_rcv_serials_supply;
1736:
1737: PROCEDURE insert_lot_supply(

Line 1751: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

1747:
1748: l_rowid VARCHAR2(255);
1749: l_lot_count NUMBER;
1750: l_lpn_id rcv_supply.lpn_id%TYPE;
1751: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1752: BEGIN
1753: IF (g_asn_debug = 'Y') THEN
1754: asn_debug.put_line('Enter insert_lots_supply');
1755: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);

Line 1789: FROM rcv_transactions_interface

1785: * a value and validation_flag is N.
1786: */
1787: SELECT NVL(validation_flag, 'N')
1788: INTO l_validation_flag
1789: FROM rcv_transactions_interface
1790: WHERE interface_transaction_id = p_interface_transaction_id;
1791:
1792: SELECT NVL(lpn_id, -999)
1793: INTO l_lpn_id

Line 1932: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

1928:
1929: l_rowid VARCHAR2(255);
1930: l_serial_count NUMBER;
1931: l_lpn_id rcv_supply.lpn_id%TYPE;
1932: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1933: BEGIN
1934: IF (g_asn_debug = 'Y') THEN
1935: asn_debug.put_line('Enter insert_serial_supply ');
1936: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);

Line 1972: FROM rcv_transactions_interface

1968: * a value and validation_flag is N.
1969: */
1970: SELECT NVL(validation_flag, 'N')
1971: INTO l_validation_flag
1972: FROM rcv_transactions_interface
1973: WHERE interface_transaction_id = p_interface_transaction_id;
1974:
1975: SELECT NVL(lpn_id, -999)
1976: INTO l_lpn_id

Line 1990: /* We can only use rcv_transactions but in cases of direct deliver

1986: asn_debug.put_line('l_validation_flag ' || l_validation_flag);
1987: asn_debug.put_line(' l_lpn_id ' || l_lpn_id);
1988: END IF;
1989:
1990: /* We can only use rcv_transactions but in cases of direct deliver
1991: * there will be two rows in rt with same interface_txn_id. Hence
1992: * use rcv_supply and this way we will only use the receiving row.
1993: */
1994: INSERT INTO rcv_serials_supply

Line 2075: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

2071: x_return_status OUT NOCOPY VARCHAR2
2072: ) IS
2073: l_lot_count NUMBER;
2074: l_lpn_id rcv_supply.lpn_id%TYPE;
2075: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
2076: BEGIN
2077: IF (g_asn_debug = 'Y') THEN
2078: asn_debug.put_line(' enter insert_lot_transactions');
2079: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);

Line 2173: FROM rcv_transactions_interface rti,

2169: /* mtltview.sublot_num, */
2170: /*end ,INVCONV*/
2171: mtltview.secondary_qty,
2172: mtltview.reason_code
2173: FROM rcv_transactions_interface rti,
2174: (SELECT SUM(mtlt.transaction_quantity) qty,
2175: SUM(mtlt.primary_quantity) primary_qty,
2176: SUM(mtlt.secondary_quantity) secondary_qty,
2177: mtlt.lot_number,

Line 2223: l_lpn_group_id rcv_transactions_interface.lpn_group_id%TYPE;

2219: PROCEDURE validate_lpn_groups(
2220: p_request_id IN NUMBER,
2221: p_group_id IN NUMBER
2222: ) IS
2223: l_lpn_group_id rcv_transactions_interface.lpn_group_id%TYPE;
2224: l_ret_status VARCHAR2(20);
2225: l_msg_cnt NUMBER;
2226: l_msg_data VARCHAR2(100);
2227: l_return BOOLEAN := TRUE;

Line 2283: FROM rcv_transactions_interface

2279: shipment_header_id
2280: INTO l_header_id,
2281: l_asn_type,
2282: l_ship_id
2283: FROM rcv_transactions_interface
2284: WHERE lpn_group_id = l_lpn_group_id
2285: AND GROUP_ID = DECODE(p_group_id,
2286: 0, GROUP_ID,
2287: p_group_id

Line 2326: rcv_error_pkg.set_error_message('RCV_TRANSACTIONS_INTERFACE');

2322: END IF; --}
2323: -- insert into interface errors
2324: -- need to get correct error message for pushing to errors table
2325:
2326: rcv_error_pkg.set_error_message('RCV_TRANSACTIONS_INTERFACE');
2327: rcv_error_pkg.set_token('LPN_GROUP_ID', l_lpn_group_id);
2328: rcv_error_pkg.log_interface_error('LPN_GROUP_ID', FALSE);
2329: END IF; --}
2330: END IF; --}