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

Line 11: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

7:
8: -- LOCAL PROCEDURES
9:
10: PROCEDURE derive_io_rcv_line_qty(
11: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
12: n IN OUT NOCOPY BINARY_INTEGER,
13: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
14: );
15:

Line 13: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

9:
10: PROCEDURE derive_io_rcv_line_qty(
11: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
12: n IN OUT NOCOPY BINARY_INTEGER,
13: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
14: );
15:
16: PROCEDURE derive_trans_del_line_quantity(
17: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 17: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

13: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
14: );
15:
16: PROCEDURE derive_trans_del_line_quantity(
17: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
18: n IN OUT NOCOPY BINARY_INTEGER,
19: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
20: );
21:

Line 19: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

15:
16: PROCEDURE derive_trans_del_line_quantity(
17: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
18: n IN OUT NOCOPY BINARY_INTEGER,
19: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
20: );
21:
22: PROCEDURE derive_io_correct_line_qty(
23: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 23: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

19: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
20: );
21:
22: PROCEDURE derive_io_correct_line_qty(
23: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
24: n IN OUT NOCOPY BINARY_INTEGER,
25: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
26: );
27:

Line 25: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

21:
22: PROCEDURE derive_io_correct_line_qty(
23: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
24: n IN OUT NOCOPY BINARY_INTEGER,
25: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
26: );
27:
28: PROCEDURE derive_io_shipment_info(
29: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 29: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

25: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
26: );
27:
28: PROCEDURE derive_io_shipment_info(
29: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
30: n IN OUT NOCOPY BINARY_INTEGER
31: );
32:
33: -- GLOBAL PROCEDURES

Line 36: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

32:
33: -- GLOBAL PROCEDURES
34:
35: PROCEDURE derive_internal_order_header(
36: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
37: ) IS
38: BEGIN
39: rcv_roi_header_common.derive_ship_to_org_info(p_header_record);
40: rcv_roi_header_common.derive_from_org_info(p_header_record);

Line 47: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

43: -- derive shipment info?
44: END derive_internal_order_header;
45:
46: PROCEDURE default_internal_order_header(
47: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
48: ) IS
49: BEGIN
50: rcv_roi_header_common.default_last_update_info(p_header_record);
51: rcv_roi_header_common.default_creation_info(p_header_record);

Line 78: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

74: END IF;
75: END default_internal_order_header;
76:
77: PROCEDURE validate_internal_order_header(
78: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
79: ) IS
80: BEGIN
81: rcv_roi_header_common.validate_trx_type(p_header_record);
82: -- validate_document_type(p_header_record);

Line 101: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

97: * default_shipment_info defaults the shipment_header_id if the
98: * shipment_num is given for an inter-org/internal req receipts.
99: */
100: PROCEDURE default_shipment_info(
101: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
102: ) IS
103: x_count NUMBER;
104: BEGIN
105: IF p_header_record.header_record.receipt_header_id IS NOT NULL THEN

Line 154: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

150: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
151: END default_shipment_info;
152:
153: PROCEDURE update_header(
154: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
155: ) IS
156: BEGIN
157: -- Bug 12591134: Start
158: IF (g_asn_debug = 'Y') THEN

Line 265: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

261: WHERE shipment_header_id = p_header_record.header_record.receipt_header_id;
262: END update_header;
263:
264: PROCEDURE derive_io_receive_line(
265: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
266: n IN OUT NOCOPY BINARY_INTEGER,
267: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
268: x_header_record IN rcv_roi_preprocessor.header_rec_type
269: ) IS

Line 267: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

263:
264: PROCEDURE derive_io_receive_line(
265: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
266: n IN OUT NOCOPY BINARY_INTEGER,
267: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
268: x_header_record IN rcv_roi_preprocessor.header_rec_type
269: ) IS
270: BEGIN
271: x_progress := '000';

Line 268: x_header_record IN rcv_roi_preprocessor.header_rec_type

264: PROCEDURE derive_io_receive_line(
265: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
266: n IN OUT NOCOPY BINARY_INTEGER,
267: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
268: x_header_record IN rcv_roi_preprocessor.header_rec_type
269: ) IS
270: BEGIN
271: x_progress := '000';
272:

Line 337: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

333: /* Bug3591830 - END */
334: END derive_io_receive_line;
335:
336: PROCEDURE derive_io_trans_line(
337: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
338: n IN OUT NOCOPY BINARY_INTEGER,
339: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
340: x_header_record IN rcv_roi_preprocessor.header_rec_type
341: ) IS

Line 339: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

335:
336: PROCEDURE derive_io_trans_line(
337: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
338: n IN OUT NOCOPY BINARY_INTEGER,
339: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
340: x_header_record IN rcv_roi_preprocessor.header_rec_type
341: ) IS
342: BEGIN
343: IF (g_asn_debug = 'Y') THEN

Line 340: x_header_record IN rcv_roi_preprocessor.header_rec_type

336: PROCEDURE derive_io_trans_line(
337: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
338: n IN OUT NOCOPY BINARY_INTEGER,
339: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
340: x_header_record IN rcv_roi_preprocessor.header_rec_type
341: ) IS
342: BEGIN
343: IF (g_asn_debug = 'Y') THEN
344: asn_debug.put_line('enter derive_io_trans_line ');

Line 401: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

397: );
398: END derive_io_trans_line;
399:
400: PROCEDURE derive_io_correct_line(
401: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
402: n IN OUT NOCOPY BINARY_INTEGER,
403: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
404: x_header_record IN rcv_roi_preprocessor.header_rec_type
405: ) IS

Line 403: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

399:
400: PROCEDURE derive_io_correct_line(
401: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
402: n IN OUT NOCOPY BINARY_INTEGER,
403: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
404: x_header_record IN rcv_roi_preprocessor.header_rec_type
405: ) IS
406: BEGIN
407: IF (g_asn_debug = 'Y') THEN

Line 404: x_header_record IN rcv_roi_preprocessor.header_rec_type

400: PROCEDURE derive_io_correct_line(
401: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
402: n IN OUT NOCOPY BINARY_INTEGER,
403: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
404: x_header_record IN rcv_roi_preprocessor.header_rec_type
405: ) IS
406: BEGIN
407: IF (g_asn_debug = 'Y') THEN
408: asn_debug.put_line('enter derive_correction_line ');

Line 447: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

443: );
444: END derive_io_correct_line;
445:
446: PROCEDURE default_io_receive_line(
447: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
448: n IN BINARY_INTEGER
449: ) IS
450: l_routing_header_id NUMBER;
451: BEGIN

Line 506: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

502: x_cascaded_table(n).routing_header_id := l_routing_header_id;
503: END default_io_receive_line;
504:
505: PROCEDURE default_io_trans_line(
506: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
507: n IN BINARY_INTEGER
508: ) IS
509: BEGIN
510: -- logic should match int-org transfer

Line 515: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

511: rcv_int_org_transfer.default_int_org_trans_del(x_cascaded_table, n);
512: END default_io_trans_line;
513:
514: PROCEDURE default_io_correct_line(
515: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
516: n IN BINARY_INTEGER
517: ) IS
518: BEGIN
519: -- logic should match int-org transfer

Line 524: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

520: rcv_int_org_transfer.default_int_org_cor_line(x_cascaded_table, n);
521: END default_io_correct_line;
522:
523: PROCEDURE validate_io_receive_line(
524: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
525: n IN BINARY_INTEGER,
526: x_header_record IN rcv_roi_preprocessor.header_rec_type
527: ) IS
528: l_parent_deliver_to_person_id NUMBER := null; --Bug#6375015

Line 526: x_header_record IN rcv_roi_preprocessor.header_rec_type

522:
523: PROCEDURE validate_io_receive_line(
524: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
525: n IN BINARY_INTEGER,
526: x_header_record IN rcv_roi_preprocessor.header_rec_type
527: ) IS
528: l_parent_deliver_to_person_id NUMBER := null; --Bug#6375015
529: l_skip_validation NUMBER := 0; --Bug#6375015
530: BEGIN

Line 736: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

732: NULL;
733: END validate_io_receive_line;
734:
735: PROCEDURE derive_io_rcv_line_qty(
736: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
737: n IN OUT NOCOPY BINARY_INTEGER,
738: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
739: ) IS
740: /* Bug 3684984.

Line 738: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

734:
735: PROCEDURE derive_io_rcv_line_qty(
736: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
737: n IN OUT NOCOPY BINARY_INTEGER,
738: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
739: ) IS
740: /* Bug 3684984.
741: * Added the columns requisition_line_id, employee_id and
742: * po_line_location_id to the cursor. We used to get this before

Line 1616: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1612: END IF;
1613: END derive_io_rcv_line_qty;
1614:
1615: PROCEDURE derive_trans_del_line_quantity(
1616: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1617: n IN OUT NOCOPY BINARY_INTEGER,
1618: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
1619: ) IS
1620: BEGIN

Line 1618: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

1614:
1615: PROCEDURE derive_trans_del_line_quantity(
1616: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1617: n IN OUT NOCOPY BINARY_INTEGER,
1618: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
1619: ) IS
1620: BEGIN
1621: -- logic should match inter-org transfer, so
1622: rcv_int_org_transfer.derive_trans_del_line_quantity(x_cascaded_table,

Line 1629: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1625: );
1626: END derive_trans_del_line_quantity;
1627:
1628: PROCEDURE derive_io_correct_line_qty(
1629: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1630: n IN OUT NOCOPY BINARY_INTEGER,
1631: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
1632: ) IS
1633: BEGIN

Line 1631: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type

1627:
1628: PROCEDURE derive_io_correct_line_qty(
1629: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1630: n IN OUT NOCOPY BINARY_INTEGER,
1631: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
1632: ) IS
1633: BEGIN
1634: -- logic is the same for inter_org xfer, so...
1635: rcv_int_org_transfer.derive_int_org_cor_line_qty(x_cascaded_table,

Line 1642: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1638: );
1639: END derive_io_correct_line_qty;
1640:
1641: PROCEDURE derive_io_shipment_info(
1642: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1643: n IN OUT NOCOPY BINARY_INTEGER
1644: ) IS
1645: l_shipment_header_id NUMBER;
1646: l_shipment_line_id NUMBER;

Line 1726: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1722: If rcv_shipment_line_id is not known, it will try to get the value based on
1723: rcv_shipment_header_id only if the rsh has got only one rsl.
1724: */
1725: PROCEDURE get_deliver_to_person_from_rsl(
1726: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1727: n IN BINARY_INTEGER
1728: ) IS
1729: l_deliver_to_person_id NUMBER;
1730: l_rsl_count NUMBER;

Line 1800: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1796: This function is called from validate_io_rcv_line() and it tries to default
1797: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions).
1798: */
1799: FUNCTION get_deliver_to_person_from_rt(
1800: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1801: n IN BINARY_INTEGER
1802: ) RETURN NUMBER IS
1803: l_parent_deliver_to_person_id NUMBER := null;
1804: BEGIN

Line 1828: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1824: the deliver_to_person_id mentioned in the parent transaction(i.e from rcv_transactions_interface).
1825: */
1826:
1827: FUNCTION get_deliver_to_person_from_rti(
1828: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1829: n IN BINARY_INTEGER
1830: ) RETURN NUMBER IS
1831: l_parent_deliver_to_person_id NUMBER := null;
1832: BEGIN