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_EXPRESS_SV dependencies on RCV_TRANSACTIONS

Line 16: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,

12: is modifed in val_express_transactions() and set_trx_defaults()
13: before calling val_rcv_trx_interface().
14: */
15: FUNCTION val_rcv_trx_interface (
16: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
17: X_txn_from_web IN BOOLEAN,--Bug 5855096
18: X_txn_from_wf IN BOOLEAN)--Bug 5855096
19: RETURN BOOLEAN;
20:

Line 22: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE);

18: X_txn_from_wf IN BOOLEAN)--Bug 5855096
19: RETURN BOOLEAN;
20:
21: PROCEDURE set_trx_defaults (
22: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE);
23:
24: PROCEDURE print_record (
25: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE);
26:

Line 25: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE);

21: PROCEDURE set_trx_defaults (
22: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE);
23:
24: PROCEDURE print_record (
25: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE);
26:
27: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
28: X_column_name IN VARCHAR2,
29: X_err_message IN VARCHAR2);

Line 27: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,

23:
24: PROCEDURE print_record (
25: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE);
26:
27: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
28: X_column_name IN VARCHAR2,
29: X_err_message IN VARCHAR2);
30:
31: /*===========================================================================

Line 43: FROM rcv_transactions_interface

39: X_rows_failed OUT NOCOPY NUMBER) IS
40:
41: CURSOR rcv_get_interface_rows IS
42: SELECT *
43: FROM rcv_transactions_interface
44: WHERE group_id = X_group_id
45: AND transaction_status_code in ( 'EXPRESS', 'CONFIRM' )
46: ORDER BY interface_transaction_id;
47:

Line 48: rcv_trx rcv_transactions_interface%ROWTYPE;

44: WHERE group_id = X_group_id
45: AND transaction_status_code in ( 'EXPRESS', 'CONFIRM' )
46: ORDER BY interface_transaction_id;
47:
48: rcv_trx rcv_transactions_interface%ROWTYPE;
49: record_num NUMBER := 0;
50: rows_succeeded NUMBER := 0;
51: rows_failed NUMBER := 0;
52: delivery_rows_succeeded NUMBER := 0;

Line 112: ** Select the rows from the rcv_transactions_interface table

108: OPEN rcv_get_interface_rows;
109:
110: /*
111: ** Loop:
112: ** Select the rows from the rcv_transactions_interface table
113: ** that will be transacted with this group_id
114: */
115: X_progress := '020';
116:

Line 324: FROM rcv_transactions

320: SELECT currency_conversion_date,
321: currency_conversion_rate
322: INTO v_ratedate,
323: v_rate
324: FROM rcv_transactions
325: WHERE transaction_id = rcv_trx.parent_transaction_id;
326:
327: rcv_trx.currency_conversion_date := v_ratedate;
328: rcv_trx.currency_conversion_rate := v_rate;

Line 494: DELETE FROM rcv_transactions_interface

490: X_rows_failed := rows_failed;
491:
492: /* Bug 4891693 fixed. deleting records from RTI which has quantity = 0 */
493: BEGIN
494: DELETE FROM rcv_transactions_interface
495: WHERE group_id = X_group_id
496: AND quantity = 0;
497: EXCEPTION
498: WHEN OTHERS THEN

Line 517: FUNCTION val_rcv_trx_interface (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,

513: FUNCTION NAME: val_rcv_trx_interface
514:
515: ===========================================================================*/
516:
517: FUNCTION val_rcv_trx_interface (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
518: X_txn_from_web IN BOOLEAN,--Bug 5855096
519: X_txn_from_wf IN BOOLEAN)--Bug 5855096
520: RETURN BOOLEAN IS
521:

Line 758: valid_receiving_controls := rcv_transactions_sv.val_receiving_controls (

754: X_progress := '100';
755:
756: -- htp.p ('validating receiving controls'); -- htp.nl;
757:
758: valid_receiving_controls := rcv_transactions_sv.val_receiving_controls (
759: rcv_trx.transaction_type,
760: rcv_trx.auto_transact_code,
761: rcv_trx.expected_receipt_date,
762: rcv_trx.transaction_date,

Line 914: valid_deliver_dest := rcv_transactions_sv.val_deliver_destination (

910: /*
911: ** Check that the destination information is valid
912: */
913: X_progress := '130';
914: valid_deliver_dest := rcv_transactions_sv.val_deliver_destination (
915: rcv_trx.to_organization_id,
916: rcv_trx.item_id,
917: rcv_trx.destination_type_code,
918: rcv_trx.deliver_to_location_id,

Line 1073: valid_wip_info := rcv_transactions_sv.val_wip_info (

1069: IF (rcv_trx.destination_type_code = 'SHOP FLOOR') THEN
1070:
1071: X_progress := '160';
1072:
1073: valid_wip_info := rcv_transactions_sv.val_wip_info (
1074: rcv_trx.to_organization_id,
1075: rcv_trx.wip_entity_id,
1076: rcv_trx.wip_operation_seq_num,
1077: rcv_trx.wip_resource_seq_num,

Line 1149: IF (NOT rcv_transactions_sv.val_pending_receipt_trx (

1145: (rcv_trx.transaction_type = 'RECEIVE' OR
1146: rcv_trx.auto_transact_code = 'RECEIVE')) THEN
1147:
1148: X_progress := '120';
1149: IF (NOT rcv_transactions_sv.val_pending_receipt_trx (
1150: rcv_trx.po_line_location_id,
1151: rcv_trx.group_id)) THEN
1152:
1153: X_column_name := 'PO_LINE_LOCATION_ID';

Line 1162: END IF; -- (NOT rcv_transactions_sv.val_pending_transactions)

1158: -- htp.p ('pending delivery transactions validation failed'); -- htp.nl;
1159:
1160: RETURN (FALSE);
1161:
1162: END IF; -- (NOT rcv_transactions_sv.val_pending_transactions)
1163:
1164: END IF; -- (rcv_trx.source_document_code = 'PO')
1165:
1166: END IF; -- (rcv_trx.auto_transact_code = 'DELIVER' ...)

Line 1251: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE)

1247:
1248: ===========================================================================*/
1249:
1250: PROCEDURE set_trx_defaults (
1251: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE)
1252: IS
1253:
1254: inventory_receipt BOOLEAN := FALSE;
1255: item_rev_exists BOOLEAN := FALSE;

Line 1362: inventory_receipt := rcv_transactions_sv.val_if_inventory_destination (

1358:
1359: /*
1360: ** Set the default item rev if one is not set on the transaction
1361: */
1362: inventory_receipt := rcv_transactions_sv.val_if_inventory_destination (
1363: rcv_trx.po_line_location_id, rcv_trx.shipment_line_id);
1364:
1365: /*
1366: ** If this is has an inventory destination and there is not item rev

Line 1472: from rcv_transactions_interface

1468: */
1469:
1470: select count(po_distribution_id)
1471: into x_dist_count
1472: from rcv_transactions_interface
1473: where transaction_type = 'EXPRESS DIRECT'
1474: and po_line_location_id = rcv_trx.po_line_location_id
1475: and shipment_line_id = rcv_trx.shipment_line_id;
1476:

Line 1891: PROCEDURE print_record (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS

1887: /*
1888: ** Prints a transaction record
1889: */
1890:
1891: PROCEDURE print_record (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
1892:
1893: BEGIN
1894: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1895: htp.code('interface_transaction_id : ' ||

Line 1962: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,

1958: /*
1959: ** Insert into PO_INTERFACE_ERRORS table
1960: */
1961:
1962: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
1963: X_column_name IN VARCHAR2,
1964: X_err_message IN VARCHAR2) as
1965:
1966: X_progress VARCHAR2(3) := '000';