DBA Data[Home] [Help]

APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_ROI_PREPROCESSOR

Line 7: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 9: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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';

Line 10: x_header_record IN rcv_roi_preprocessor.header_rec_type

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:

Line 56: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 58: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

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(

Line 883: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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;

Line 1047: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1049: x_header_record IN rcv_roi_preprocessor.header_rec_type

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');

Line 1111: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1113: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1114: x_header_record IN rcv_roi_preprocessor.header_rec_type

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 ');

Line 1166: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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:

Line 1476: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1478: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

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

Line 2205: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 2207: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 2208: x_header_record IN rcv_roi_preprocessor.header_rec_type

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 ');

Line 2247: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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;

Line 2249: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

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);

Line 3037: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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:

Line 3398: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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);

Line 3400: x_header_record IN rcv_roi_preprocessor.header_rec_type

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