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_ROI_HEADER_COMMON dependencies on RCV_ROI_PREPROCESSOR

Line 22: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

18: x_location_id NUMBER;
19: e_validation_error EXCEPTION;
20:
21: PROCEDURE derive_ship_to_org_info(
22: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
23: ) IS
24: BEGIN
25: /* Derive Ship To Organization Information
26: * organization_id is uk. org_organization_definitions is a view */

Line 63: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

59: END IF;
60: END derive_ship_to_org_info;
61:
62: PROCEDURE derive_from_org_info(
63: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
64: ) IS
65: BEGIN
66: /* derive from organization information */
67: IF p_header_record.error_record.error_status IN('S', 'W')

Line 94: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

90: END IF;
91: END derive_from_org_info;
92:
93: PROCEDURE derive_location_info(
94: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
95: ) IS
96: BEGIN
97: /* Derive Location Information */
98: /* HR_LOCATION has 2 unique indexes

Line 129: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

125: END IF;
126: END derive_location_info;
127:
128: PROCEDURE derive_payment_terms_info(
129: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
130: ) IS
131: BEGIN
132: /* Derive Payment Terms Information */
133: IF p_header_record.error_record.error_status IN('S', 'W')

Line 163: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

159: END IF;
160: END derive_payment_terms_info;
161:
162: PROCEDURE derive_receiver_info(
163: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
164: ) IS
165: BEGIN
166: IF p_header_record.error_record.error_status IN('S', 'W')
167: AND p_header_record.header_record.transaction_type <> 'CANCEL'

Line 196: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

192: END IF;
193: END derive_receiver_info;
194:
195: PROCEDURE derive_shipment_header_id(
196: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
197: ) IS
198: BEGIN
199: /* Derive shipment_header_id if transaction type = CANCEL */
200:

Line 242: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

238: END IF;
239: END derive_shipment_header_id;
240:
241: PROCEDURE derive_ship_to_org_from_rti(
242: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
243: ) IS
244: x_header_interface_id NUMBER;
245: x_to_organization_code VARCHAR2(3);
246: x_to_organization_id NUMBER; /* Bug#3909973 - (1) */

Line 364: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

360: p_header_record.error_record.error_message := SQLERRM;
361: END derive_ship_to_org_from_rti;
362:
363: PROCEDURE derive_uom_info(
364: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
365: n IN BINARY_INTEGER
366: ) IS
367: BEGIN
368: asn_debug.put_line('inside derive_uom_info');

Line 422: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

418: END IF; -- set uom_code
419: END derive_uom_info;
420:
421: PROCEDURE genreceiptnum(
422: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
423: ) IS
424: l_count NUMBER;
425: PRAGMA AUTONOMOUS_TRANSACTION;
426: BEGIN

Line 514: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

510: -- Default auto_transact_code if it is null
511: END commondefaultcode;
512:
513: PROCEDURE default_last_update_info(
514: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
515: ) IS
516: BEGIN
517: /* last_update_date */
518: IF p_header_record.header_record.last_update_date IS NULL THEN

Line 546: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

542: END IF;
543: END default_last_update_info;
544:
545: PROCEDURE default_creation_info(
546: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
547: ) IS
548: BEGIN
549: /* creation_date */
550: IF p_header_record.header_record.creation_date IS NULL THEN

Line 569: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

565: END IF;
566: END default_creation_info;
567:
568: PROCEDURE default_asn_type(
569: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
570: ) IS
571: BEGIN
572: /* Default STD into asn_type for null asn_type */
573: IF p_header_record.header_record.asn_type IS NULL THEN

Line 583: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

579: END IF;
580: END default_asn_type;
581:
582: PROCEDURE default_shipment_header_id(
583: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
584: ) IS
585: BEGIN
586: /* generate the shipment_header_id */
587: /* shipment_header_id - receipt_header_id is the same */

Line 609: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

605: END IF;
606: END default_shipment_header_id;
607:
608: PROCEDURE default_receipt_info(
609: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
610: ) IS
611: v_rcv_type po_system_parameters.user_defined_receipt_num_code%TYPE;
612: v_count NUMBER := 0;
613: BEGIN

Line 687: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

683: END IF;
684: END default_receipt_info;
685:
686: PROCEDURE default_ship_to_location_info(
687: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
688: ) IS
689: temp_count NUMBER;
690: x_po_header_id NUMBER;
691: x_document_num VARCHAR2(20);

Line 782: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

778: END IF;
779: END default_ship_to_location_info;
780:
781: PROCEDURE default_ship_from_loc_info(
782: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
783: ) IS
784: BEGIN
785: /* This is now handled by the defaulting package. No need to do it here */
786: NULL;

Line 790: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

786: NULL;
787: END default_ship_from_loc_info;
788:
789: PROCEDURE validate_trx_type(
790: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
791: ) IS
792: BEGIN
793: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN
794: RETURN;

Line 824: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

820: NULL;
821: END validate_trx_type;
822:
823: PROCEDURE validate_expected_receipt_date(
824: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
825: ) IS
826: BEGIN
827: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN
828: RETURN;

Line 855: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

851: NULL;
852: END validate_expected_receipt_date;
853:
854: PROCEDURE validate_receipt_num(
855: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
856: ) IS
857: BEGIN
858: /* Validate Receipt Number */
859: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN

Line 907: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

903: NULL;
904: END validate_receipt_num;
905:
906: PROCEDURE validate_ship_to_org_info(
907: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
908: ) IS
909: BEGIN
910: /* Validate Ship To Organization Information */
911: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN

Line 1069: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1065: NULL;
1066: END validate_ship_to_org_info;
1067:
1068: PROCEDURE validate_from_org_info(
1069: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1070: ) IS
1071: BEGIN
1072: /* validate from organization information */
1073: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN

Line 1126: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1122: NULL;
1123: END validate_from_org_info;
1124:
1125: PROCEDURE validate_location_info(
1126: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1127: ) IS
1128: BEGIN
1129: /* Validate Location Information */
1130: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN

Line 1177: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1173: NULL;
1174: END validate_location_info;
1175:
1176: PROCEDURE validate_ship_from_loc_info(
1177: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1178: ) IS
1179: x_dummy NUMBER;
1180: p_in_rec wsh_po_integration_grp.validatesf_in_rec_type;
1181: x_out_rec wsh_po_integration_grp.validatesf_out_rec_type;

Line 1264: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1260: NULL;
1261: END validate_ship_from_loc_info;
1262:
1263: PROCEDURE validate_payment_terms_info(
1264: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1265: ) IS
1266: BEGIN
1267: /* Validate Payment Terms Information */
1268: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN

Line 1312: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1308: NULL;
1309: END validate_payment_terms_info;
1310:
1311: PROCEDURE validate_receiver_info(
1312: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1313: ) IS
1314: BEGIN
1315: /* validate receiver information */
1316: IF (p_header_record.error_record.error_status NOT IN('S', 'W')) THEN

Line 1356: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1352: NULL;
1353: END validate_receiver_info;
1354:
1355: PROCEDURE validate_freight_carrier_info(
1356: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1357: ) IS
1358: BEGIN
1359: /* validate freight carrier information */
1360: /* ASN and ASBN, al transaction_types except CANCEL */

Line 1397: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1393: NULL;
1394: END validate_freight_carrier_info;
1395:
1396: PROCEDURE validate_shipment_date(
1397: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1398: ) IS
1399: x_sysdate DATE := SYSDATE;
1400: BEGIN
1401: /* Validation for Shipment Date > System Date and not NULL,blank,zero */

Line 1437: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1433: NULL;
1434: END validate_shipment_date;
1435:
1436: PROCEDURE validate_item(
1437: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1438: n IN BINARY_INTEGER
1439: ) IS -- bug 608353
1440: x_progress VARCHAR2(3);
1441: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599

Line 1589: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1585: END IF;
1586: END validate_item;
1587:
1588: PROCEDURE validate_substitute_item(
1589: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1590: n IN BINARY_INTEGER
1591: ) IS
1592: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1593: x_progress VARCHAR2(3);

Line 1770: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1766: END IF;
1767: END validate_substitute_item;
1768:
1769: PROCEDURE validate_item_revision(
1770: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1771: n IN BINARY_INTEGER
1772: ) IS
1773: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1774: x_progress VARCHAR2(3);

Line 1859: PROCEDURE validate_lcm_info(p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type)

1855:
1856: END validate_item_revision;
1857:
1858: /* lcm changes */
1859: PROCEDURE validate_lcm_info(p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type)
1860: IS
1861: l_lcm_org_flag VARCHAR2(1);
1862: l_pre_rcv_flag VARCHAR2(1);
1863: BEGIN