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) := asn_debug.is_debug_on; -- Bug 9152790
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 916: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

912: END IF;
913: END derive_int_org_rcv_line_qty;
914:
915: PROCEDURE default_int_org_rcv_line(
916: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
917: n IN BINARY_INTEGER
918: ) IS
919: x_progress VARCHAR2(3);
920: x_locator_control NUMBER;

Line 1080: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1076: NULL;
1077: END default_int_org_rcv_line;
1078:
1079: PROCEDURE validate_int_org_rcv_line(
1080: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1081: n IN BINARY_INTEGER,
1082: x_header_record IN rcv_roi_preprocessor.header_rec_type
1083: ) IS
1084: BEGIN

Line 1082: x_header_record IN rcv_roi_preprocessor.header_rec_type

1078:
1079: PROCEDURE validate_int_org_rcv_line(
1080: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1081: n IN BINARY_INTEGER,
1082: x_header_record IN rcv_roi_preprocessor.header_rec_type
1083: ) IS
1084: BEGIN
1085: IF (g_asn_debug = 'Y') THEN
1086: asn_debug.put_line('Enter validate_int_org_rcv_line');

Line 1154: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1150: --=======================================================================================
1151:
1152:
1153: PROCEDURE derive_int_org_trans_del(
1154: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1155: n IN OUT NOCOPY BINARY_INTEGER,
1156: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1157: x_header_record IN rcv_roi_preprocessor.header_rec_type
1158: ) IS

Line 1156: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1152:
1153: PROCEDURE derive_int_org_trans_del(
1154: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1155: n IN OUT NOCOPY BINARY_INTEGER,
1156: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1157: x_header_record IN rcv_roi_preprocessor.header_rec_type
1158: ) IS
1159: BEGIN
1160: IF (g_asn_debug = 'Y') THEN

Line 1157: x_header_record IN rcv_roi_preprocessor.header_rec_type

1153: PROCEDURE derive_int_org_trans_del(
1154: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1155: n IN OUT NOCOPY BINARY_INTEGER,
1156: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1157: x_header_record IN rcv_roi_preprocessor.header_rec_type
1158: ) IS
1159: BEGIN
1160: IF (g_asn_debug = 'Y') THEN
1161: asn_debug.put_line('enter derive_int_org_trans_del ');

Line 1209: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1205: );
1206: END derive_int_org_trans_del;
1207:
1208: PROCEDURE default_int_org_trans_del(
1209: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1210: n IN BINARY_INTEGER
1211: ) IS
1212: p_trx_record rcv_roi_header_common.common_default_record_type;
1213:

Line 1519: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1515: NULL;
1516: END default_int_org_trans_del;
1517:
1518: PROCEDURE derive_trans_del_line_quantity(
1519: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1520: n IN OUT NOCOPY BINARY_INTEGER,
1521: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
1522: ) IS
1523: x_include_closed_po VARCHAR2(1); -- Bug 1887728

Line 1521: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

1517:
1518: PROCEDURE derive_trans_del_line_quantity(
1519: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1520: n IN OUT NOCOPY BINARY_INTEGER,
1521: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
1522: ) IS
1523: x_include_closed_po VARCHAR2(1); -- Bug 1887728
1524: /*
1525: ** Might be a compatibility issue between the two record definitions

Line 2280: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2276: END derive_trans_del_line_quantity;
2277:
2278: /*-------- corrections --------------------------*/
2279: PROCEDURE derive_int_org_cor_line(
2280: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2281: n IN OUT NOCOPY BINARY_INTEGER,
2282: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2283: x_header_record IN rcv_roi_preprocessor.header_rec_type
2284: ) IS

Line 2282: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2278: /*-------- corrections --------------------------*/
2279: PROCEDURE derive_int_org_cor_line(
2280: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2281: n IN OUT NOCOPY BINARY_INTEGER,
2282: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2283: x_header_record IN rcv_roi_preprocessor.header_rec_type
2284: ) IS
2285: BEGIN
2286: IF (g_asn_debug = 'Y') THEN

Line 2283: x_header_record IN rcv_roi_preprocessor.header_rec_type

2279: PROCEDURE derive_int_org_cor_line(
2280: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2281: n IN OUT NOCOPY BINARY_INTEGER,
2282: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2283: x_header_record IN rcv_roi_preprocessor.header_rec_type
2284: ) IS
2285: BEGIN
2286: IF (g_asn_debug = 'Y') THEN
2287: asn_debug.put_line('enter derive_correction_line ');

Line 2322: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2318: );
2319: END derive_int_org_cor_line;
2320:
2321: PROCEDURE derive_int_org_cor_line_qty(
2322: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2323: n IN OUT NOCOPY BINARY_INTEGER,
2324: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
2325: ) IS
2326: x_record_count NUMBER;

Line 2324: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

2320:
2321: PROCEDURE derive_int_org_cor_line_qty(
2322: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2323: n IN OUT NOCOPY BINARY_INTEGER,
2324: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
2325: ) IS
2326: x_record_count NUMBER;
2327: x_remaining_quantity NUMBER := 0;
2328: x_progress VARCHAR2(3);

Line 3112: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

3108: END IF;
3109: END derive_int_org_cor_line_qty;
3110:
3111: PROCEDURE default_int_org_cor_line(
3112: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3113: n IN BINARY_INTEGER
3114: ) IS
3115: p_trx_record rcv_roi_header_common.common_default_record_type;
3116:

Line 3473: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

3469: * inter-org shipments.
3470: */
3471:
3472: PROCEDURE validate_ref_integrity(
3473: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3474: n IN BINARY_INTEGER,
3475: x_header_record IN rcv_roi_preprocessor.header_rec_type
3476: ) IS
3477: x_error_status VARCHAR2(1);

Line 3475: x_header_record IN rcv_roi_preprocessor.header_rec_type

3471:
3472: PROCEDURE validate_ref_integrity(
3473: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3474: n IN BINARY_INTEGER,
3475: x_header_record IN rcv_roi_preprocessor.header_rec_type
3476: ) IS
3477: x_error_status VARCHAR2(1);
3478: x_header_id number;
3479: BEGIN