DBA Data[Home] [Help]

APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_ROI_TRANSACTION

Line 20: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

16: asn_debug.put_line('enter int_org_rcv line');
17: END IF;
18:
19: -- 1) derive ship to org info
20: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
21: n,
22: x_header_record
23: );
24: x_progress := '002';

Line 32: rcv_roi_transaction.derive_item_info(x_cascaded_table, n);

28: END IF;
29:
30: x_progress := '010';
31: -- 5) derive item info
32: rcv_roi_transaction.derive_item_info(x_cascaded_table, n);
33: x_progress := '015';
34: rcv_roi_header_common.derive_uom_info(x_cascaded_table, n);
35: -- 6) derive substitute item info
36: rcv_roi_transaction.derive_substitute_item_info(x_cascaded_table, n);

Line 36: rcv_roi_transaction.derive_substitute_item_info(x_cascaded_table, n);

32: rcv_roi_transaction.derive_item_info(x_cascaded_table, n);
33: x_progress := '015';
34: rcv_roi_header_common.derive_uom_info(x_cascaded_table, n);
35: -- 6) derive substitute item info
36: rcv_roi_transaction.derive_substitute_item_info(x_cascaded_table, n);
37: x_progress := '020';
38: -- 8) derive from org info
39: rcv_roi_transaction.derive_from_org_info(x_cascaded_table, n);
40: x_progress := '035';

Line 39: rcv_roi_transaction.derive_from_org_info(x_cascaded_table, n);

35: -- 6) derive substitute item info
36: rcv_roi_transaction.derive_substitute_item_info(x_cascaded_table, n);
37: x_progress := '020';
38: -- 8) derive from org info
39: rcv_roi_transaction.derive_from_org_info(x_cascaded_table, n);
40: x_progress := '035';
41: -- 12) derive routing header info
42: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);
43: x_progress := '070';

Line 42: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);

38: -- 8) derive from org info
39: rcv_roi_transaction.derive_from_org_info(x_cascaded_table, n);
40: x_progress := '035';
41: -- 12) derive routing header info
42: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);
43: x_progress := '070';
44: asn_debug.put_line('progress in IOrcv : x_progress = ' || x_progress);
45: -- derive auto transact code
46: rcv_roi_transaction.derive_auto_transact_code(x_cascaded_table, n);

Line 46: rcv_roi_transaction.derive_auto_transact_code(x_cascaded_table, n);

42: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);
43: x_progress := '070';
44: asn_debug.put_line('progress in IOrcv : x_progress = ' || x_progress);
45: -- derive auto transact code
46: rcv_roi_transaction.derive_auto_transact_code(x_cascaded_table, n);
47: asn_debug.put_line('progress in IOrcv : before derive qty');
48: -- quantity > 0
49: derive_int_org_rcv_line_qty(x_cascaded_table,
50: n,

Line 570: x_temp_already_allocated_qty := rcv_roi_transaction.convert_into_correct_qty(x_cascaded_table(i).quantity,

566:
567: IF n > 1 THEN -- we will do this for all rows except the 1st
568: FOR i IN 1 ..(n - 1) LOOP
569: IF x_cascaded_table(i).item_id = x_shipmentrec.item_id THEN
570: x_temp_already_allocated_qty := rcv_roi_transaction.convert_into_correct_qty(x_cascaded_table(i).quantity,
571: x_cascaded_table(i).unit_of_measure,
572: x_cascaded_table(i).item_id,
573: x_shipmentrec.unit_of_measure
574: );

Line 621: x_remaining_qty_rsl_uom := rcv_roi_transaction.convert_into_correct_qty(x_remaining_quantity,

617: -- po -> primary uom
618: -- if any of the conversions fail then we cannot use that record
619:
620: x_remaining_qty_rsl_uom := 0; -- initialize
621: x_remaining_qty_rsl_uom := rcv_roi_transaction.convert_into_correct_qty(x_remaining_quantity,
622: temp_cascaded_table(1).unit_of_measure,
623: temp_cascaded_table(1).item_id,
624: x_shipmentrec.unit_of_measure
625: );

Line 648: x_remaining_quantity := rcv_roi_transaction.convert_into_correct_qty(x_remaining_qty_rsl_uom,

644: END IF;
645:
646: x_remaining_qty_rsl_uom := x_remaining_qty_rsl_uom - x_converted_trx_qty;
647: -- change rsl uom qty to uom of first line in cascaded table so both qtys are in sync
648: x_remaining_quantity := rcv_roi_transaction.convert_into_correct_qty(x_remaining_qty_rsl_uom,
649: x_shipmentrec.unit_of_measure,
650: temp_cascaded_table(1).item_id,
651: temp_cascaded_table(1).unit_of_measure
652: );

Line 711: l_temp_qty := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,

707: temp_cascaded_table(current_n).source_doc_unit_of_measure := x_shipmentrec.unit_of_measure;
708:
709: IF (temp_cascaded_table(current_n).unit_of_measure <> x_shipmentrec.unit_of_measure) THEN
710: --Bug 8631613 For some conversions residual qty. is causing issues while doing put away.
711: l_temp_qty := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,
712: x_shipmentrec.unit_of_measure,
713: temp_cascaded_table(current_n).item_id,
714: temp_cascaded_table(current_n).unit_of_measure
715: ); -- in asn uom

Line 721: /*temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,

717: IF ( Round(l_temp_qty,7) <> temp_cascaded_table(current_n).quantity ) THEN
718: temp_cascaded_table(current_n).quantity := l_temp_qty;
719: END IF;
720:
721: /*temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,
722: x_shipmentrec.unit_of_measure,
723: temp_cascaded_table(current_n).item_id,
724: temp_cascaded_table(current_n).unit_of_measure
725: ); -- in asn uom*/

Line 738: l_pri_temp_qty:=rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,

734:
735: -- primary qty in primary uom
736: IF (temp_cascaded_table(current_n).primary_unit_of_measure <> x_shipmentrec.unit_of_measure) THEN
737: --Bug 8631613
738: l_pri_temp_qty:=rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,
739: x_shipmentrec.unit_of_measure,
740: temp_cascaded_table(current_n).item_id,
741: temp_cascaded_table(current_n).primary_unit_of_measure
742: );

Line 747: /*temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,

743: IF (Round(l_pri_temp_qty,7) <> NVL(temp_cascaded_table(current_n).primary_quantity,-1)) THEN
744: temp_cascaded_table(current_n).primary_quantity := l_pri_temp_qty;
745: END IF;
746:
747: /*temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,
748: x_shipmentrec.unit_of_measure,
749: temp_cascaded_table(current_n).item_id,
750: temp_cascaded_table(current_n).primary_unit_of_measure
751: );*/

Line 997: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);

993: x_cascaded_table(n).currency_conversion_rate := default_shipment_info.currency_conversion_rate;
994: x_cascaded_table(n).currency_conversion_type := default_shipment_info.currency_conversion_type;
995: x_cascaded_table(n).currency_conversion_date := default_shipment_info.currency_conversion_date;
996: --- WMS Changes
997: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
998:
999: -- if deliver transaction
1000: -- if location not entered on form => location_id and deliver_to_location_id are null
1001: -- if location entered on form => location_id and deliver_to_location_id are the same

Line 1090: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */

1086: asn_debug.put_line('Enter validate_int_org_rcv_line');
1087: END IF;
1088:
1089: x_progress := '000';
1090: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */
1091: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
1092: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
1093: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
1094: /*Bug 8671559

Line 1091: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);

1087: END IF;
1088:
1089: x_progress := '000';
1090: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */
1091: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
1092: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
1093: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
1094: /*Bug 8671559
1095: Adding IF condition to ensure that the validation call for freight carriers is not made for

Line 1092: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);

1088:
1089: x_progress := '000';
1090: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */
1091: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
1092: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
1093: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
1094: /*Bug 8671559
1095: Adding IF condition to ensure that the validation call for freight carriers is not made for
1096: Inter-Org Transfers when the values are the same at the header and transaction levels.

Line 1093: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);

1089: x_progress := '000';
1090: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */
1091: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
1092: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
1093: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
1094: /*Bug 8671559
1095: Adding IF condition to ensure that the validation call for freight carriers is not made for
1096: Inter-Org Transfers when the values are the same at the header and transaction levels.
1097: */

Line 1101: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);

1097: */
1098: IF (x_cascaded_table(n).freight_carrier_code = x_header_record.header_record.freight_carrier_code) THEN
1099: NULL;
1100: ELSE
1101: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
1102: END IF;
1103: /* End of fix for Bug 8671559 */
1104: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
1105:

Line 1104: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);

1100: ELSE
1101: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
1102: END IF;
1103: /* End of fix for Bug 8671559 */
1104: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
1105:
1106: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
1107: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
1108: END IF;

Line 1107: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);

1103: /* End of fix for Bug 8671559 */
1104: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
1105:
1106: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
1107: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
1108: END IF;
1109:
1110: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1111: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);

Line 1110: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);

1106: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
1107: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
1108: END IF;
1109:
1110: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1111: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1112: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1113: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1114: rcv_roi_transaction.validate_locator(x_cascaded_table, n);

Line 1111: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);

1107: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
1108: END IF;
1109:
1110: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1111: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1112: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1113: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1114: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1115: rcv_roi_transaction.validate_tax_code(x_cascaded_table,

Line 1112: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);

1108: END IF;
1109:
1110: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1111: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1112: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1113: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1114: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1115: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1116: n,

Line 1113: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);

1109:
1110: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1111: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1112: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1113: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1114: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1115: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1116: n,
1117: x_header_record.header_record.asn_type

Line 1114: rcv_roi_transaction.validate_locator(x_cascaded_table, n);

1110: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1111: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1112: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1113: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1114: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1115: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1116: n,
1117: x_header_record.header_record.asn_type
1118: ); /* Bug3454491 */

Line 1115: rcv_roi_transaction.validate_tax_code(x_cascaded_table,

1111: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1112: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1113: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1114: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1115: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1116: n,
1117: x_header_record.header_record.asn_type
1118: ); /* Bug3454491 */
1119: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);

Line 1119: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);

1115: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1116: n,
1117: x_header_record.header_record.asn_type
1118: ); /* Bug3454491 */
1119: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);
1120: /* Bug 3735972.
1121: * We used to call rcv_roi_transaction.validate_ref_integrity that had
1122: * code only for PO.
1123: * We now have a similar one to validate internal orders and

Line 1121: * We used to call rcv_roi_transaction.validate_ref_integrity that had

1117: x_header_record.header_record.asn_type
1118: ); /* Bug3454491 */
1119: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);
1120: /* Bug 3735972.
1121: * We used to call rcv_roi_transaction.validate_ref_integrity that had
1122: * code only for PO.
1123: * We now have a similar one to validate internal orders and
1124: * inter-org shipments in rcv_int_org_transfer package.
1125: */

Line 1130: rcv_roi_transaction.exchange_sub_items(x_cascaded_table, n);

1126: rcv_int_org_transfer.validate_ref_integrity(x_cascaded_table,
1127: n,
1128: x_header_record
1129: );
1130: rcv_roi_transaction.exchange_sub_items(x_cascaded_table, n);
1131:
1132: /* INVCONV , introduced following call . Punit Kumar */
1133: rcv_roi_transaction.validate_opm_attributes(x_cascaded_table, n);
1134:

Line 1133: rcv_roi_transaction.validate_opm_attributes(x_cascaded_table, n);

1129: );
1130: rcv_roi_transaction.exchange_sub_items(x_cascaded_table, n);
1131:
1132: /* INVCONV , introduced following call . Punit Kumar */
1133: rcv_roi_transaction.validate_opm_attributes(x_cascaded_table, n);
1134:
1135: /* end , INVCONV */
1136:
1137:

Line 1165: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

1161: asn_debug.put_line('enter derive_int_org_trans_del ');
1162: END IF;
1163:
1164: /* Derive the to_org_id */
1165: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
1166: n,
1167: x_header_record
1168: );
1169:

Line 1193: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);

1189: * needed for Transfer also.
1190: */
1191: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
1192: asn_debug.put_line('doing ship to location /locator derivations ');
1193: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
1194: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
1195: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
1196: END IF;
1197:

Line 1194: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change

1190: */
1191: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
1192: asn_debug.put_line('doing ship to location /locator derivations ');
1193: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
1194: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
1195: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
1196: END IF;
1197:
1198: x_progress := '091';

Line 1195: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change

1191: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
1192: asn_debug.put_line('doing ship to location /locator derivations ');
1193: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
1194: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
1195: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
1196: END IF;
1197:
1198: x_progress := '091';
1199: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);

Line 1199: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);

1195: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
1196: END IF;
1197:
1198: x_progress := '091';
1199: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);
1200: /* Auto_transact_code is null for all these transaction types */
1201: x_cascaded_table(n).auto_transact_code := NULL;
1202: derive_trans_del_line_quantity(x_cascaded_table,
1203: n,

Line 1485: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);

1481: * has not provided then we will not default for the other transactions.
1482: * from_subinventory will be the to_sub of the parent .
1483: */
1484: ---WMS Changes
1485: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);
1486:
1487: IF (x_cascaded_table(n).transaction_type = 'DELIVER') THEN
1488: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
1489: END IF;

Line 1488: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);

1484: ---WMS Changes
1485: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);
1486:
1487: IF (x_cascaded_table(n).transaction_type = 'DELIVER') THEN
1488: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
1489: END IF;
1490:
1491: /*
1492: ** Make sure to set the location_id properly

Line 1643: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);

1639: already_derived := TRUE;
1640: END IF; --}
1641:
1642: IF (NOT already_derived) THEN --{
1643: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);
1644:
1645: /* This means that there was no error in derive_parent_id which means that the
1646: * this is a child and need to get the values from the rti and not from the plsql table.
1647: */

Line 1984: rcv_roi_transaction.get_interface_available_qty(temp_cascaded_table,

1980:
1981: insert_into_table := FALSE;
1982: already_allocated_qty := 0;
1983: -- need to find out if the parent is in rti
1984: rcv_roi_transaction.get_interface_available_qty(temp_cascaded_table,
1985: current_n,
1986: x_converted_parent_trx_qty
1987: );
1988:

Line 2013: x_remaining_qty_parent_uom := rcv_roi_transaction.convert_into_correct_qty(x_remaining_quantity,

2009: IF (g_asn_debug = 'Y') THEN
2010: asn_debug.put_line('qty from GET_AVAILABLE_QUANTITY for transfer is ' || x_converted_parent_trx_qty);
2011: END IF;
2012:
2013: x_remaining_qty_parent_uom := rcv_roi_transaction.convert_into_correct_qty(x_remaining_quantity,
2014: temp_cascaded_table(1).unit_of_measure,
2015: temp_cascaded_table(1).item_id,
2016: x_int_org_transferrec.unit_of_meas
2017: );

Line 2039: x_remaining_quantity := rcv_roi_transaction.convert_into_correct_qty(x_remaining_qty_parent_uom,

2035: */
2036: x_remaining_qty_parent_uom := x_remaining_qty_parent_uom - x_converted_parent_trx_qty;
2037:
2038: IF (temp_cascaded_table(current_n).unit_of_measure <> x_int_org_transferrec.unit_of_meas) THEN
2039: x_remaining_quantity := rcv_roi_transaction.convert_into_correct_qty(x_remaining_qty_parent_uom,
2040: x_int_org_transferrec.unit_of_meas,
2041: temp_cascaded_table(1).item_id,
2042: temp_cascaded_table(1).unit_of_measure
2043: );

Line 2107: l_temp_qty := rcv_roi_transaction.convert_into_correct_qty( x_converted_parent_trx_qty,

2103: temp_cascaded_table(current_n).primary_unit_of_measure := x_int_org_transferrec.primary_unit_of_measure;
2104:
2105: IF (temp_cascaded_table(current_n).unit_of_measure <> x_int_org_transferrec.unit_of_meas) THEN
2106: --Bug 8631613 For some conversions residual qty. is causing issues while doing put away.
2107: l_temp_qty := rcv_roi_transaction.convert_into_correct_qty( x_converted_parent_trx_qty,
2108: x_int_org_transferrec.unit_of_meas,
2109: temp_cascaded_table(current_n).item_id,
2110: temp_cascaded_table(current_n).unit_of_measure
2111: ); -- in asn uom

Line 2115: /*temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,

2111: ); -- in asn uom
2112: IF ( Round(l_temp_qty,7) <> temp_cascaded_table(current_n).quantity ) THEN
2113: temp_cascaded_table(current_n).quantity := l_temp_qty;
2114: END IF;
2115: /*temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,
2116: x_int_org_transferrec.unit_of_meas,
2117: temp_cascaded_table(current_n).item_id,
2118: temp_cascaded_table(current_n).unit_of_measure
2119: ); -- in asn uom*/

Line 2131: l_pri_temp_qty := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,

2127: END IF;
2128:
2129: IF (temp_cascaded_table(current_n).primary_unit_of_measure <> x_int_org_transferrec.unit_of_meas) THEN
2130: --Bug 8631613
2131: l_pri_temp_qty := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,
2132: x_int_org_transferrec.unit_of_meas,
2133: temp_cascaded_table(current_n).item_id,
2134: temp_cascaded_table(current_n).primary_unit_of_measure
2135: );

Line 2140: /*temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,

2136: IF (Round(l_pri_temp_qty,7) <> NVL(temp_cascaded_table(current_n).primary_quantity,-1)) THEN
2137: temp_cascaded_table(current_n).primary_quantity := l_pri_temp_qty;
2138: END IF;
2139:
2140: /*temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,
2141: x_int_org_transferrec.unit_of_meas,
2142: temp_cascaded_table(current_n).item_id,
2143: temp_cascaded_table(current_n).primary_unit_of_measure
2144: );*/

Line 2291: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

2287: asn_debug.put_line('enter derive_correction_line ');
2288: END IF;
2289:
2290: /* Derive the to_org_id */
2291: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
2292: n,
2293: x_header_record
2294: );
2295:

Line 2312: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);

2308: END IF;
2309: END IF;
2310:
2311: x_progress := '091';
2312: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);
2313: /* Auto_transact_code is null for all these transaction types */
2314: x_cascaded_table(n).auto_transact_code := NULL;
2315: derive_int_org_cor_line_qty(x_cascaded_table,
2316: n,

Line 2464: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);

2460: OPEN int_org_cor_rt(x_cascaded_table(n).parent_transaction_id, x_cascaded_table(n).to_organization_id);
2461: END IF; ---}
2462:
2463: IF (NOT already_derived) THEN --{
2464: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);
2465:
2466: /* This means that there was no error in
2467: * derive_parent_id which means that the
2468: * this is a child and need to get the values

Line 2813: rcv_roi_transaction.get_interface_available_qty(temp_cascaded_table,

2809:
2810: insert_into_table := FALSE;
2811: already_allocated_qty := 0;
2812: -- need to find out if the parent/grandparent are in rti
2813: rcv_roi_transaction.get_interface_available_qty(temp_cascaded_table,
2814: current_n,
2815: x_converted_parent_trx_qty
2816: );
2817:

Line 3041: temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,

3037: IF (g_asn_debug = 'Y') THEN
3038: asn_debug.put_line('primary uoms not the same and need to convert quantity');
3039: END IF;
3040:
3041: temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,
3042: int_org_cor_rec.unit_of_meas,
3043: temp_cascaded_table(current_n).item_id,
3044: temp_cascaded_table(current_n).primary_unit_of_measure
3045: );

Line 3429: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);

3425: END IF; -- if po_transfer%found is true }
3426:
3427: /* Default the from and to subinventory and locator_id */
3428: ----WMS Changes
3429: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);
3430: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
3431:
3432: /*
3433: BEGIN Comment: Bug: 4735484

Line 3430: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);

3426:
3427: /* Default the from and to subinventory and locator_id */
3428: ----WMS Changes
3429: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);
3430: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
3431:
3432: /*
3433: BEGIN Comment: Bug: 4735484
3434: