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 559: x_temp_already_allocated_qty := rcv_roi_transaction.convert_into_correct_qty(x_cascaded_table(i).quantity,

555:
556: IF n > 1 THEN -- we will do this for all rows except the 1st
557: FOR i IN 1 ..(n - 1) LOOP
558: IF x_cascaded_table(i).item_id = x_shipmentrec.item_id THEN
559: x_temp_already_allocated_qty := rcv_roi_transaction.convert_into_correct_qty(x_cascaded_table(i).quantity,
560: x_cascaded_table(i).unit_of_measure,
561: x_cascaded_table(i).item_id,
562: x_shipmentrec.unit_of_measure
563: );

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

606: -- po -> primary uom
607: -- if any of the conversions fail then we cannot use that record
608:
609: x_remaining_qty_rsl_uom := 0; -- initialize
610: x_remaining_qty_rsl_uom := rcv_roi_transaction.convert_into_correct_qty(x_remaining_quantity,
611: temp_cascaded_table(1).unit_of_measure,
612: temp_cascaded_table(1).item_id,
613: x_shipmentrec.unit_of_measure
614: );

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

633: END IF;
634:
635: x_remaining_qty_rsl_uom := x_remaining_qty_rsl_uom - x_converted_trx_qty;
636: -- change rsl uom qty to uom of first line in cascaded table so both qtys are in sync
637: x_remaining_quantity := rcv_roi_transaction.convert_into_correct_qty(x_remaining_qty_rsl_uom,
638: x_shipmentrec.unit_of_measure,
639: temp_cascaded_table(1).item_id,
640: temp_cascaded_table(1).unit_of_measure
641: );

Line 699: temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,

695: temp_cascaded_table(current_n).source_doc_quantity := x_converted_trx_qty; -- in rsl uom
696: temp_cascaded_table(current_n).source_doc_unit_of_measure := x_shipmentrec.unit_of_measure;
697:
698: IF (temp_cascaded_table(current_n).unit_of_measure <> x_shipmentrec.unit_of_measure) THEN
699: temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,
700: x_shipmentrec.unit_of_measure,
701: temp_cascaded_table(current_n).item_id,
702: temp_cascaded_table(current_n).unit_of_measure
703: ); -- in asn uom

Line 714: temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,

710: END IF;
711:
712: -- primary qty in primary uom
713: IF (temp_cascaded_table(current_n).primary_unit_of_measure <> x_shipmentrec.unit_of_measure) THEN
714: temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,
715: x_shipmentrec.unit_of_measure,
716: temp_cascaded_table(current_n).item_id,
717: temp_cascaded_table(current_n).primary_unit_of_measure
718: );

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

960: x_cascaded_table(n).currency_conversion_rate := default_shipment_info.currency_conversion_rate;
961: x_cascaded_table(n).currency_conversion_type := default_shipment_info.currency_conversion_type;
962: x_cascaded_table(n).currency_conversion_date := default_shipment_info.currency_conversion_date;
963: --- WMS Changes
964: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
965:
966: -- if deliver transaction
967: -- if location not entered on form => location_id and deliver_to_location_id are null
968: -- if location entered on form => location_id and deliver_to_location_id are the same

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

1053: asn_debug.put_line('Enter validate_int_org_rcv_line');
1054: END IF;
1055:
1056: x_progress := '000';
1057: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
1058: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
1059: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
1060: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
1061: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);

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

1054: END IF;
1055:
1056: x_progress := '000';
1057: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
1058: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
1059: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
1060: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
1061: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
1062:

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

1055:
1056: x_progress := '000';
1057: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
1058: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
1059: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
1060: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
1061: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
1062:
1063: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN

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

1056: x_progress := '000';
1057: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
1058: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
1059: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
1060: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
1061: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
1062:
1063: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
1064: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);

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

1057: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
1058: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
1059: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
1060: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
1061: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
1062:
1063: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
1064: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
1065: END IF;

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

1060: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
1061: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
1062:
1063: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
1064: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
1065: END IF;
1066:
1067: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1068: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);

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

1063: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
1064: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
1065: END IF;
1066:
1067: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1068: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1069: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1070: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1071: rcv_roi_transaction.validate_locator(x_cascaded_table, n);

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

1064: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
1065: END IF;
1066:
1067: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1068: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1069: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1070: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1071: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1072: rcv_roi_transaction.validate_tax_code(x_cascaded_table,

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

1065: END IF;
1066:
1067: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1068: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1069: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1070: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1071: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1072: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1073: n,

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

1066:
1067: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1068: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1069: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1070: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1071: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1072: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1073: n,
1074: x_header_record.header_record.asn_type

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

1067: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
1068: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1069: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1070: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1071: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1072: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1073: n,
1074: x_header_record.header_record.asn_type
1075: ); /* Bug3454491 */

Line 1072: rcv_roi_transaction.validate_tax_code(x_cascaded_table,

1068: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
1069: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
1070: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
1071: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
1072: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1073: n,
1074: x_header_record.header_record.asn_type
1075: ); /* Bug3454491 */
1076: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);

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

1072: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
1073: n,
1074: x_header_record.header_record.asn_type
1075: ); /* Bug3454491 */
1076: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);
1077: /* Bug 3735972.
1078: * We used to call rcv_roi_transaction.validate_ref_integrity that had
1079: * code only for PO.
1080: * We now have a similar one to validate internal orders and

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

1074: x_header_record.header_record.asn_type
1075: ); /* Bug3454491 */
1076: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);
1077: /* Bug 3735972.
1078: * We used to call rcv_roi_transaction.validate_ref_integrity that had
1079: * code only for PO.
1080: * We now have a similar one to validate internal orders and
1081: * inter-org shipments in rcv_int_org_transfer package.
1082: */

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

1083: rcv_int_org_transfer.validate_ref_integrity(x_cascaded_table,
1084: n,
1085: x_header_record
1086: );
1087: rcv_roi_transaction.exchange_sub_items(x_cascaded_table, n);
1088:
1089: /* INVCONV , introduced following call . Punit Kumar */
1090: rcv_roi_transaction.validate_opm_attributes(x_cascaded_table, n);
1091:

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

1086: );
1087: rcv_roi_transaction.exchange_sub_items(x_cascaded_table, n);
1088:
1089: /* INVCONV , introduced following call . Punit Kumar */
1090: rcv_roi_transaction.validate_opm_attributes(x_cascaded_table, n);
1091:
1092: /* end , INVCONV */
1093:
1094:

Line 1122: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

1118: asn_debug.put_line('enter derive_int_org_trans_del ');
1119: END IF;
1120:
1121: /* Derive the to_org_id */
1122: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
1123: n,
1124: x_header_record
1125: );
1126:

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

1146: * needed for Transfer also.
1147: */
1148: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
1149: asn_debug.put_line('doing ship to location /locator derivations ');
1150: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
1151: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
1152: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
1153: END IF;
1154:

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

1147: */
1148: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
1149: asn_debug.put_line('doing ship to location /locator derivations ');
1150: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
1151: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
1152: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
1153: END IF;
1154:
1155: x_progress := '091';

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

1148: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
1149: asn_debug.put_line('doing ship to location /locator derivations ');
1150: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
1151: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
1152: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
1153: END IF;
1154:
1155: x_progress := '091';
1156: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);

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

1152: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
1153: END IF;
1154:
1155: x_progress := '091';
1156: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);
1157: /* Auto_transact_code is null for all these transaction types */
1158: x_cascaded_table(n).auto_transact_code := NULL;
1159: derive_trans_del_line_quantity(x_cascaded_table,
1160: n,

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

1438: * has not provided then we will not default for the other transactions.
1439: * from_subinventory will be the to_sub of the parent .
1440: */
1441: ---WMS Changes
1442: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);
1443:
1444: IF (x_cascaded_table(n).transaction_type = 'DELIVER') THEN
1445: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
1446: END IF;

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

1441: ---WMS Changes
1442: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);
1443:
1444: IF (x_cascaded_table(n).transaction_type = 'DELIVER') THEN
1445: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
1446: END IF;
1447:
1448: /*
1449: ** Make sure to set the location_id properly

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

1592: already_derived := TRUE;
1593: END IF; --}
1594:
1595: IF (NOT already_derived) THEN --{
1596: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);
1597:
1598: /* This means that there was no error in derive_parent_id which means that the
1599: * this is a child and need to get the values from the rti and not from the plsql table.
1600: */

Line 1937: rcv_roi_transaction.get_interface_available_qty(temp_cascaded_table,

1933:
1934: insert_into_table := FALSE;
1935: already_allocated_qty := 0;
1936: -- need to find out if the parent is in rti
1937: rcv_roi_transaction.get_interface_available_qty(temp_cascaded_table,
1938: current_n,
1939: x_converted_parent_trx_qty
1940: );
1941:

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

1962: IF (g_asn_debug = 'Y') THEN
1963: asn_debug.put_line('qty from GET_AVAILABLE_QUANTITY for transfer is ' || x_converted_parent_trx_qty);
1964: END IF;
1965:
1966: x_remaining_qty_parent_uom := rcv_roi_transaction.convert_into_correct_qty(x_remaining_quantity,
1967: temp_cascaded_table(1).unit_of_measure,
1968: temp_cascaded_table(1).item_id,
1969: x_int_org_transferrec.unit_of_meas
1970: );

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

1988: */
1989: x_remaining_qty_parent_uom := x_remaining_qty_parent_uom - x_converted_parent_trx_qty;
1990:
1991: IF (temp_cascaded_table(current_n).unit_of_measure <> x_int_org_transferrec.unit_of_meas) THEN
1992: x_remaining_quantity := rcv_roi_transaction.convert_into_correct_qty(x_remaining_qty_parent_uom,
1993: x_int_org_transferrec.unit_of_meas,
1994: temp_cascaded_table(1).item_id,
1995: temp_cascaded_table(1).unit_of_measure
1996: );

Line 2059: temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,

2055:
2056: temp_cascaded_table(current_n).primary_unit_of_measure := x_int_org_transferrec.primary_unit_of_measure;
2057:
2058: IF (temp_cascaded_table(current_n).unit_of_measure <> x_int_org_transferrec.unit_of_meas) THEN
2059: temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,
2060: x_int_org_transferrec.unit_of_meas,
2061: temp_cascaded_table(current_n).item_id,
2062: temp_cascaded_table(current_n).unit_of_measure
2063: ); -- in asn uom

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

2069: temp_cascaded_table(current_n).quantity := x_converted_parent_trx_qty;
2070: END IF;
2071:
2072: IF (temp_cascaded_table(current_n).primary_unit_of_measure <> x_int_org_transferrec.unit_of_meas) THEN
2073: temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,
2074: x_int_org_transferrec.unit_of_meas,
2075: temp_cascaded_table(current_n).item_id,
2076: temp_cascaded_table(current_n).primary_unit_of_measure
2077: );

Line 2216: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

2212: asn_debug.put_line('enter derive_correction_line ');
2213: END IF;
2214:
2215: /* Derive the to_org_id */
2216: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
2217: n,
2218: x_header_record
2219: );
2220:

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

2233: END IF;
2234: END IF;
2235:
2236: x_progress := '091';
2237: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);
2238: /* Auto_transact_code is null for all these transaction types */
2239: x_cascaded_table(n).auto_transact_code := NULL;
2240: derive_int_org_cor_line_qty(x_cascaded_table,
2241: n,

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

2385: OPEN int_org_cor_rt(x_cascaded_table(n).parent_transaction_id, x_cascaded_table(n).to_organization_id);
2386: END IF; ---}
2387:
2388: IF (NOT already_derived) THEN --{
2389: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);
2390:
2391: /* This means that there was no error in
2392: * derive_parent_id which means that the
2393: * this is a child and need to get the values

Line 2738: rcv_roi_transaction.get_interface_available_qty(temp_cascaded_table,

2734:
2735: insert_into_table := FALSE;
2736: already_allocated_qty := 0;
2737: -- need to find out if the parent/grandparent are in rti
2738: rcv_roi_transaction.get_interface_available_qty(temp_cascaded_table,
2739: current_n,
2740: x_converted_parent_trx_qty
2741: );
2742:

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

2962: IF (g_asn_debug = 'Y') THEN
2963: asn_debug.put_line('primary uoms not the same and need to convert quantity');
2964: END IF;
2965:
2966: temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_parent_trx_qty,
2967: int_org_cor_rec.unit_of_meas,
2968: temp_cascaded_table(current_n).item_id,
2969: temp_cascaded_table(current_n).primary_unit_of_measure
2970: );

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

3350: END IF; -- if po_transfer%found is true }
3351:
3352: /* Default the from and to subinventory and locator_id */
3353: ----WMS Changes
3354: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);
3355: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
3356:
3357: /*
3358: BEGIN Comment: Bug: 4735484

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

3351:
3352: /* Default the from and to subinventory and locator_id */
3353: ----WMS Changes
3354: rcv_roi_transaction.default_from_subloc_info(x_cascaded_table, n);
3355: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
3356:
3357: /*
3358: BEGIN Comment: Bug: 4735484
3359: