3: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
4: x_progress VARCHAR2(3);
5: e_validation_error EXCEPTION;
6: PROCEDURE derive_int_org_rcv_line(
7: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8: n IN OUT NOCOPY BINARY_INTEGER,
9: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10: x_header_record IN rcv_roi_preprocessor.header_rec_type
11: ) IS
5: e_validation_error EXCEPTION;
6: PROCEDURE derive_int_org_rcv_line(
7: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8: n IN OUT NOCOPY BINARY_INTEGER,
9: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10: x_header_record IN rcv_roi_preprocessor.header_rec_type
11: ) IS
12: BEGIN
13: x_progress := '000';
6: PROCEDURE derive_int_org_rcv_line(
7: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8: n IN OUT NOCOPY BINARY_INTEGER,
9: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
10: x_header_record IN rcv_roi_preprocessor.header_rec_type
11: ) IS
12: BEGIN
13: x_progress := '000';
14:
52: );
53: END derive_int_org_rcv_line;
54:
55: PROCEDURE derive_int_org_rcv_line_qty(
56: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
57: n IN OUT NOCOPY BINARY_INTEGER,
58: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
59: ) IS
60: -- x_include_closed_po varchar2(1); -- bug 1887728
54:
55: PROCEDURE derive_int_org_rcv_line_qty(
56: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
57: n IN OUT NOCOPY BINARY_INTEGER,
58: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
59: ) IS
60: -- x_include_closed_po varchar2(1); -- bug 1887728
61:
62: CURSOR shipments(
879: END IF;
880: END derive_int_org_rcv_line_qty;
881:
882: PROCEDURE default_int_org_rcv_line(
883: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
884: n IN BINARY_INTEGER
885: ) IS
886: x_progress VARCHAR2(3);
887: x_locator_control NUMBER;
1043: NULL;
1044: END default_int_org_rcv_line;
1045:
1046: PROCEDURE validate_int_org_rcv_line(
1047: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1048: n IN BINARY_INTEGER,
1049: x_header_record IN rcv_roi_preprocessor.header_rec_type
1050: ) IS
1051: BEGIN
1045:
1046: PROCEDURE validate_int_org_rcv_line(
1047: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1048: n IN BINARY_INTEGER,
1049: x_header_record IN rcv_roi_preprocessor.header_rec_type
1050: ) IS
1051: BEGIN
1052: IF (g_asn_debug = 'Y') THEN
1053: asn_debug.put_line('Enter validate_int_org_rcv_line');
1107: --=======================================================================================
1108:
1109:
1110: PROCEDURE derive_int_org_trans_del(
1111: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1112: n IN OUT NOCOPY BINARY_INTEGER,
1113: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1114: x_header_record IN rcv_roi_preprocessor.header_rec_type
1115: ) IS
1109:
1110: PROCEDURE derive_int_org_trans_del(
1111: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1112: n IN OUT NOCOPY BINARY_INTEGER,
1113: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1114: x_header_record IN rcv_roi_preprocessor.header_rec_type
1115: ) IS
1116: BEGIN
1117: IF (g_asn_debug = 'Y') THEN
1110: PROCEDURE derive_int_org_trans_del(
1111: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1112: n IN OUT NOCOPY BINARY_INTEGER,
1113: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1114: x_header_record IN rcv_roi_preprocessor.header_rec_type
1115: ) IS
1116: BEGIN
1117: IF (g_asn_debug = 'Y') THEN
1118: asn_debug.put_line('enter derive_int_org_trans_del ');
1162: );
1163: END derive_int_org_trans_del;
1164:
1165: PROCEDURE default_int_org_trans_del(
1166: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1167: n IN BINARY_INTEGER
1168: ) IS
1169: p_trx_record rcv_roi_header_common.common_default_record_type;
1170:
1472: NULL;
1473: END default_int_org_trans_del;
1474:
1475: PROCEDURE derive_trans_del_line_quantity(
1476: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1477: n IN OUT NOCOPY BINARY_INTEGER,
1478: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
1479: ) IS
1480: x_include_closed_po VARCHAR2(1); -- Bug 1887728
1474:
1475: PROCEDURE derive_trans_del_line_quantity(
1476: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1477: n IN OUT NOCOPY BINARY_INTEGER,
1478: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
1479: ) IS
1480: x_include_closed_po VARCHAR2(1); -- Bug 1887728
1481: /*
1482: ** Might be a compatibility issue between the two record definitions
2201: END derive_trans_del_line_quantity;
2202:
2203: /*-------- corrections --------------------------*/
2204: PROCEDURE derive_int_org_cor_line(
2205: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2206: n IN OUT NOCOPY BINARY_INTEGER,
2207: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2208: x_header_record IN rcv_roi_preprocessor.header_rec_type
2209: ) IS
2203: /*-------- corrections --------------------------*/
2204: PROCEDURE derive_int_org_cor_line(
2205: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2206: n IN OUT NOCOPY BINARY_INTEGER,
2207: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2208: x_header_record IN rcv_roi_preprocessor.header_rec_type
2209: ) IS
2210: BEGIN
2211: IF (g_asn_debug = 'Y') THEN
2204: PROCEDURE derive_int_org_cor_line(
2205: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2206: n IN OUT NOCOPY BINARY_INTEGER,
2207: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2208: x_header_record IN rcv_roi_preprocessor.header_rec_type
2209: ) IS
2210: BEGIN
2211: IF (g_asn_debug = 'Y') THEN
2212: asn_debug.put_line('enter derive_correction_line ');
2243: );
2244: END derive_int_org_cor_line;
2245:
2246: PROCEDURE derive_int_org_cor_line_qty(
2247: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2248: n IN OUT NOCOPY BINARY_INTEGER,
2249: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
2250: ) IS
2251: x_record_count NUMBER;
2245:
2246: PROCEDURE derive_int_org_cor_line_qty(
2247: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2248: n IN OUT NOCOPY BINARY_INTEGER,
2249: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
2250: ) IS
2251: x_record_count NUMBER;
2252: x_remaining_quantity NUMBER := 0;
2253: x_progress VARCHAR2(3);
3033: END IF;
3034: END derive_int_org_cor_line_qty;
3035:
3036: PROCEDURE default_int_org_cor_line(
3037: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3038: n IN BINARY_INTEGER
3039: ) IS
3040: p_trx_record rcv_roi_header_common.common_default_record_type;
3041:
3394: * inter-org shipments.
3395: */
3396:
3397: PROCEDURE validate_ref_integrity(
3398: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3399: n IN BINARY_INTEGER,
3400: x_header_record IN rcv_roi_preprocessor.header_rec_type
3401: ) IS
3402: x_error_status VARCHAR2(1);
3396:
3397: PROCEDURE validate_ref_integrity(
3398: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3399: n IN BINARY_INTEGER,
3400: x_header_record IN rcv_roi_preprocessor.header_rec_type
3401: ) IS
3402: x_error_status VARCHAR2(1);
3403: x_header_id number;
3404: BEGIN