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:
38: CURSOR lot_numbers(
39: l_interface_id NUMBER
40: ) IS

Line 49: rcv_transactions_interface rti

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

Line 90: l_item_id rcv_transactions_interface.item_id%TYPE;

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

Line 133: FROM rcv_transactions_interface

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

Line 155: FROM rcv_transactions rt

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

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

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

Line 393: FROM rcv_transactions_interface rti

389: rti.request_id,
390: rti.program_application_id,
391: rti.program_id,
392: rti.program_update_date
393: FROM rcv_transactions_interface rti
394: WHERE rti.interface_transaction_id = p_interface_transaction_id;
395: WHEN OTHERS THEN
396: IF (g_asn_debug = 'Y') THEN
397: asn_debug.put_line('others insert_rcv_lots_supply');

Line 430: FROM rcv_transactions_interface rti

426: rti.request_id,
427: rti.program_application_id,
428: rti.program_id,
429: rti.program_update_date
430: FROM rcv_transactions_interface rti
431: WHERE rti.interface_transaction_id = p_interface_transaction_id;
432: END insert_rcv_lots_supply;
433:
434: --

Line 468: l_transaction_id rcv_transactions.transaction_id%TYPE;

464: l_cur_serial_number VARCHAR2(30);
465: l_range_numbers NUMBER;
466: l_serial_suffix_length NUMBER;
467: l_delete_shipment_supply VARCHAR2(1) := 'N';
468: l_transaction_id rcv_transactions.transaction_id%TYPE;
469: l_serial_count NUMBER;
470: l_lpn_id rcv_supply.lpn_id%TYPE;
471: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
472: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;

Line 471: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

467: l_delete_shipment_supply VARCHAR2(1) := 'N';
468: l_transaction_id rcv_transactions.transaction_id%TYPE;
469: l_serial_count NUMBER;
470: l_lpn_id rcv_supply.lpn_id%TYPE;
471: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
472: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
473: l_item_id rcv_transactions_interface.item_id%TYPE;
474: BEGIN
475: IF (g_asn_debug = 'Y') THEN

Line 473: l_item_id rcv_transactions_interface.item_id%TYPE;

469: l_serial_count NUMBER;
470: l_lpn_id rcv_supply.lpn_id%TYPE;
471: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
472: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
473: l_item_id rcv_transactions_interface.item_id%TYPE;
474: BEGIN
475: IF (g_asn_debug = 'Y') THEN
476: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);
477: asn_debug.put_line('p_shipment_line_id ' || p_shipment_line_id);

Line 512: FROM rcv_transactions_interface

508: * a value and validation_flag is N.
509: */
510: SELECT NVL(validation_flag, 'N')
511: INTO l_validation_flag
512: FROM rcv_transactions_interface
513: WHERE interface_transaction_id = p_interface_transaction_id;
514:
515: SELECT NVL(lpn_id, -999)
516: INTO l_lpn_id

Line 574: FROM rcv_transactions rt

570:
571: /* End Bug#3359105 */
572: SELECT transaction_id
573: INTO l_transaction_id
574: FROM rcv_transactions rt
575: WHERE rt.interface_transaction_id = p_interface_transaction_id;
576:
577: IF (g_asn_debug = 'Y') THEN
578: asn_debug.put_line('l_range_numbers ' || l_range_numbers);

Line 690: FROM rcv_transactions_interface rti

686: rti.request_id,
687: rti.program_application_id,
688: rti.program_id,
689: rti.program_update_date
690: FROM rcv_transactions_interface rti
691: WHERE rti.interface_transaction_id = p_interface_transaction_id;
692: WHEN OTHERS THEN
693: IF (g_asn_debug = 'Y') THEN
694: asn_debug.put_line('others insert_rcv_serials_supply ');

Line 727: FROM rcv_transactions_interface rti

723: rti.request_id,
724: rti.program_application_id,
725: rti.program_id,
726: rti.program_update_date
727: FROM rcv_transactions_interface rti
728: WHERE rti.interface_transaction_id = p_interface_transaction_id;
729: END insert_rcv_serials_supply;
730:
731: PROCEDURE split_serial_number(

Line 800: rcv_transactions_interface rti

796: rti.item_id,
797: rti.unit_of_measure,
798: rti.to_organization_id
799: FROM mtl_transaction_lots_temp mtlt,
800: rcv_transactions_interface rti
801: WHERE product_transaction_id = p_interface_id
802: AND product_code = 'RCV'
803: AND rti.interface_transaction_id = mtlt.product_transaction_id
804: GROUP BY mtlt.lot_number,

Line 819: l_parent_trans_type rcv_transactions.transaction_type%TYPE;

815: * Changed the declaration of l_lot_num from varchar2(30) to rcv_lots_supply.lot_num%TYPE
816: */
817: l_lot_num rcv_lots_supply.lot_num%TYPE;
818: l_factor NUMBER;
819: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
820: l_count NUMBER;
821: l_count1 NUMBER;
822: l_count2 NUMBER;
823: l_transaction_id rcv_transactions.transaction_id%TYPE;

Line 823: l_transaction_id rcv_transactions.transaction_id%TYPE;

819: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
820: l_count NUMBER;
821: l_count1 NUMBER;
822: l_count2 NUMBER;
823: l_transaction_id rcv_transactions.transaction_id%TYPE;
824: l_lot_count NUMBER;
825: l_update_shipment_supply VARCHAR2(1) := 'N';
826: l_organization_id NUMBER;
827: /* INVCONV*/

Line 831: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

827: /* INVCONV*/
828: /* l_sublot_num VARCHAR2(32); */
829: /*end , INVCONV*/
830: l_lpn_id rcv_supply.lpn_id%TYPE;
831: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
832:
833: CURSOR supply_quantity(
834: l_lot_num VARCHAR2,
835: /* INVCONV*/

Line 877: l_item_id rcv_transactions_interface.item_id%TYPE;

873: l_ship_id NUMBER;
874: l_ship_line_id NUMBER;
875: l_rls_qty NUMBER;
876: l_rls_primary_qty NUMBER;
877: l_item_id rcv_transactions_interface.item_id%TYPE;
878: l_parent_uom VARCHAR2(25);
879: l_parent_secondary_uom VARCHAR2(25);
880: l_txn_uom VARCHAR2(25);
881: l_primary_uom VARCHAR2(25);

Line 923: FROM rcv_transactions_interface

919: * a value and validation_flag is N.
920: */
921: SELECT NVL(validation_flag, 'N')
922: INTO l_validation_flag
923: FROM rcv_transactions_interface
924: WHERE interface_transaction_id = p_interface_transaction_id;
925:
926: SELECT NVL(lpn_id, -999)
927: INTO l_lpn_id

Line 977: FROM rcv_transactions

973: INTO l_parent_trans_type,
974: l_organization_id,
975: l_parent_uom,
976: l_parent_secondary_uom
977: FROM rcv_transactions
978: WHERE transaction_id = p_parent_supply_id;
979:
980: /* INVCONV , Update for OPM transactions also. Punit Kumar */
981:

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

1090: * shipment supply qty, it must be
1091: * in terms of uom in rsl.
1092: */
1093: IF (l_txn_uom <> l_parent_uom) THEN
1094: l_qty_to_be_updated := rcv_transactions_interface_sv.convert_into_correct_qty(l_primary_qty_to_be_updated,
1095: l_primary_uom,
1096: l_item_id,
1097: l_parent_uom
1098: );

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

1209: asn_debug.put_line('l_parent_uom ' || l_parent_uom);
1210: END IF;
1211:
1212: IF (l_txn_uom <> l_parent_uom) THEN
1213: l_qty_to_be_updated := rcv_transactions_interface_sv.convert_into_correct_qty(l_primary_qty_to_be_updated,
1214: l_primary_uom,
1215: l_item_id,
1216: l_parent_uom
1217: );

Line 1352: FROM rcv_transactions_interface rti

1348: rti.request_id,
1349: rti.program_application_id,
1350: rti.program_id,
1351: rti.program_update_date
1352: FROM rcv_transactions_interface rti
1353: WHERE rti.interface_transaction_id = p_interface_transaction_id;
1354: WHEN OTHERS THEN
1355: IF (g_asn_debug = 'Y') THEN
1356: asn_debug.put_line('others update_rcv_lots_supply ');

Line 1389: FROM rcv_transactions_interface rti

1385: rti.request_id,
1386: rti.program_application_id,
1387: rti.program_id,
1388: rti.program_update_date
1389: FROM rcv_transactions_interface rti
1390: WHERE rti.interface_transaction_id = p_interface_transaction_id;
1391: END update_rcv_lots_supply;
1392:
1393: PROCEDURE update_rcv_serials_supply(

Line 1431: l_parent_trans_type rcv_transactions.transaction_type%TYPE;

1427: l_cur_serial_number VARCHAR2(30);
1428: l_range_numbers NUMBER;
1429: l_serial_count NUMBER;
1430: l_update_shipment_supply VARCHAR2(1) := 'N';
1431: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
1432: l_lpn_id rcv_supply.lpn_id%TYPE;
1433: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1434: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
1435: l_item_id rcv_transactions_interface.item_id%TYPE;

Line 1433: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

1429: l_serial_count NUMBER;
1430: l_update_shipment_supply VARCHAR2(1) := 'N';
1431: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
1432: l_lpn_id rcv_supply.lpn_id%TYPE;
1433: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1434: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
1435: l_item_id rcv_transactions_interface.item_id%TYPE;
1436: BEGIN
1437: IF (g_asn_debug = 'Y') THEN

Line 1435: l_item_id rcv_transactions_interface.item_id%TYPE;

1431: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
1432: l_lpn_id rcv_supply.lpn_id%TYPE;
1433: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1434: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
1435: l_item_id rcv_transactions_interface.item_id%TYPE;
1436: BEGIN
1437: IF (g_asn_debug = 'Y') THEN
1438: asn_debug.put_line('Enter update_rcv_serials_supply ');
1439: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);

Line 1476: FROM rcv_transactions_interface

1472: * a value and validation_flag is N.
1473: */
1474: SELECT NVL(validation_flag, 'N')
1475: INTO l_validation_flag
1476: FROM rcv_transactions_interface
1477: WHERE interface_transaction_id = p_interface_transaction_id;
1478:
1479: SELECT NVL(lpn_id, -999)
1480: INTO l_lpn_id

Line 1522: FROM rcv_transactions

1518: END IF;
1519:
1520: SELECT transaction_type
1521: INTO l_parent_trans_type
1522: FROM rcv_transactions
1523: WHERE transaction_id = p_parent_supply_id;
1524:
1525: IF ( p_transaction_type = 'CORRECTION'
1526: AND l_parent_trans_type = 'RECEIVE'

Line 1709: FROM rcv_transactions_interface rti

1705: rti.request_id,
1706: rti.program_application_id,
1707: rti.program_id,
1708: rti.program_update_date
1709: FROM rcv_transactions_interface rti
1710: WHERE rti.interface_transaction_id = p_interface_transaction_id;
1711: WHEN OTHERS THEN
1712: IF (g_asn_debug = 'Y') THEN
1713: asn_debug.put_line('others update_rcv_serials_supply');

Line 1746: FROM rcv_transactions_interface rti

1742: rti.request_id,
1743: rti.program_application_id,
1744: rti.program_id,
1745: rti.program_update_date
1746: FROM rcv_transactions_interface rti
1747: WHERE rti.interface_transaction_id = p_interface_transaction_id;
1748: END update_rcv_serials_supply;
1749:
1750: PROCEDURE insert_lot_supply(

Line 1764: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

1760:
1761: l_rowid VARCHAR2(255);
1762: l_lot_count NUMBER;
1763: l_lpn_id rcv_supply.lpn_id%TYPE;
1764: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1765: BEGIN
1766: IF (g_asn_debug = 'Y') THEN
1767: asn_debug.put_line('Enter insert_lots_supply');
1768: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);

Line 1802: FROM rcv_transactions_interface

1798: * a value and validation_flag is N.
1799: */
1800: SELECT NVL(validation_flag, 'N')
1801: INTO l_validation_flag
1802: FROM rcv_transactions_interface
1803: WHERE interface_transaction_id = p_interface_transaction_id;
1804:
1805: SELECT NVL(lpn_id, -999)
1806: INTO l_lpn_id

Line 1945: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

1941:
1942: l_rowid VARCHAR2(255);
1943: l_serial_count NUMBER;
1944: l_lpn_id rcv_supply.lpn_id%TYPE;
1945: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1946: BEGIN
1947: IF (g_asn_debug = 'Y') THEN
1948: asn_debug.put_line('Enter insert_serial_supply ');
1949: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);

Line 1985: FROM rcv_transactions_interface

1981: * a value and validation_flag is N.
1982: */
1983: SELECT NVL(validation_flag, 'N')
1984: INTO l_validation_flag
1985: FROM rcv_transactions_interface
1986: WHERE interface_transaction_id = p_interface_transaction_id;
1987:
1988: SELECT NVL(lpn_id, -999)
1989: INTO l_lpn_id

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

1999: asn_debug.put_line('l_validation_flag ' || l_validation_flag);
2000: asn_debug.put_line(' l_lpn_id ' || l_lpn_id);
2001: END IF;
2002:
2003: /* We can only use rcv_transactions but in cases of direct deliver
2004: * there will be two rows in rt with same interface_txn_id. Hence
2005: * use rcv_supply and this way we will only use the receiving row.
2006: */
2007: INSERT INTO rcv_serials_supply

Line 2088: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;

2084: x_return_status OUT NOCOPY VARCHAR2
2085: ) IS
2086: l_lot_count NUMBER;
2087: l_lpn_id rcv_supply.lpn_id%TYPE;
2088: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
2089: BEGIN
2090: IF (g_asn_debug = 'Y') THEN
2091: asn_debug.put_line(' enter insert_lot_transactions');
2092: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);

Line 2186: FROM rcv_transactions_interface rti,

2182: /* mtltview.sublot_num, */
2183: /*end ,INVCONV*/
2184: mtltview.secondary_qty,
2185: mtltview.reason_code
2186: FROM rcv_transactions_interface rti,
2187: (SELECT SUM(mtlt.transaction_quantity) qty,
2188: SUM(mtlt.primary_quantity) primary_qty,
2189: SUM(mtlt.secondary_quantity) secondary_qty,
2190: mtlt.lot_number,

Line 2236: l_lpn_group_id rcv_transactions_interface.lpn_group_id%TYPE;

2232: PROCEDURE validate_lpn_groups(
2233: p_request_id IN NUMBER,
2234: p_group_id IN NUMBER
2235: ) IS
2236: l_lpn_group_id rcv_transactions_interface.lpn_group_id%TYPE;
2237: l_ret_status VARCHAR2(20);
2238: l_msg_cnt NUMBER;
2239: l_msg_data VARCHAR2(100);
2240: l_return BOOLEAN := TRUE;

Line 2296: FROM rcv_transactions_interface

2292: shipment_header_id
2293: INTO l_header_id,
2294: l_asn_type,
2295: l_ship_id
2296: FROM rcv_transactions_interface
2297: WHERE lpn_group_id = l_lpn_group_id
2298: AND GROUP_ID = DECODE(p_group_id,
2299: 0, GROUP_ID,
2300: p_group_id

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

2335: END IF; --}
2336: -- insert into interface errors
2337: -- need to get correct error message for pushing to errors table
2338:
2339: rcv_error_pkg.set_error_message('RCV_TRANSACTIONS_INTERFACE');
2340: rcv_error_pkg.set_token('LPN_GROUP_ID', l_lpn_group_id);
2341: rcv_error_pkg.log_interface_error('LPN_GROUP_ID', FALSE);
2342: END IF; --}
2343: END IF; --}