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 314: FROM rcv_transactions

310: SELECT currency_conversion_date,
311: currency_conversion_rate
312: INTO v_ratedate,
313: v_rate
314: FROM rcv_transactions
315: WHERE transaction_id = rcv_trx.parent_transaction_id;
316:
317: rcv_trx.currency_conversion_date := v_ratedate;
318: rcv_trx.currency_conversion_rate := v_rate;

Line 484: DELETE FROM rcv_transactions_interface

480: X_rows_failed := rows_failed;
481:
482: /* Bug 4891693 fixed. deleting records from RTI which has quantity = 0 */
483: BEGIN
484: DELETE FROM rcv_transactions_interface
485: WHERE group_id = X_group_id
486: AND quantity = 0;
487: EXCEPTION
488: WHEN OTHERS THEN

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

503: FUNCTION NAME: val_rcv_trx_interface
504:
505: ===========================================================================*/
506:
507: FUNCTION val_rcv_trx_interface (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
508: X_txn_from_web IN BOOLEAN,--Bug 5855096
509: X_txn_from_wf IN BOOLEAN)--Bug 5855096
510: RETURN BOOLEAN IS
511:

Line 747: valid_receiving_controls := rcv_transactions_sv.val_receiving_controls (

743: X_progress := '100';
744:
745: -- htp.p ('validating receiving controls'); -- htp.nl;
746:
747: valid_receiving_controls := rcv_transactions_sv.val_receiving_controls (
748: rcv_trx.transaction_type,
749: rcv_trx.auto_transact_code,
750: rcv_trx.expected_receipt_date,
751: rcv_trx.transaction_date,

Line 903: valid_deliver_dest := rcv_transactions_sv.val_deliver_destination (

899: /*
900: ** Check that the destination information is valid
901: */
902: X_progress := '130';
903: valid_deliver_dest := rcv_transactions_sv.val_deliver_destination (
904: rcv_trx.to_organization_id,
905: rcv_trx.item_id,
906: rcv_trx.destination_type_code,
907: rcv_trx.deliver_to_location_id,

Line 1062: valid_wip_info := rcv_transactions_sv.val_wip_info (

1058: IF (rcv_trx.destination_type_code = 'SHOP FLOOR') THEN
1059:
1060: X_progress := '160';
1061:
1062: valid_wip_info := rcv_transactions_sv.val_wip_info (
1063: rcv_trx.to_organization_id,
1064: rcv_trx.wip_entity_id,
1065: rcv_trx.wip_operation_seq_num,
1066: rcv_trx.wip_resource_seq_num,

Line 1138: IF (NOT rcv_transactions_sv.val_pending_receipt_trx (

1134: (rcv_trx.transaction_type = 'RECEIVE' OR
1135: rcv_trx.auto_transact_code = 'RECEIVE')) THEN
1136:
1137: X_progress := '120';
1138: IF (NOT rcv_transactions_sv.val_pending_receipt_trx (
1139: rcv_trx.po_line_location_id,
1140: rcv_trx.group_id)) THEN
1141:
1142: X_column_name := 'PO_LINE_LOCATION_ID';

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

1147: -- htp.p ('pending delivery transactions validation failed'); -- htp.nl;
1148:
1149: RETURN (FALSE);
1150:
1151: END IF; -- (NOT rcv_transactions_sv.val_pending_transactions)
1152:
1153: END IF; -- (rcv_trx.source_document_code = 'PO')
1154:
1155: END IF; -- (rcv_trx.auto_transact_code = 'DELIVER' ...)

Line 1173: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE)

1169:
1170: ===========================================================================*/
1171:
1172: PROCEDURE set_trx_defaults (
1173: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE)
1174: IS
1175:
1176: inventory_receipt BOOLEAN := FALSE;
1177: item_rev_exists BOOLEAN := FALSE;

Line 1257: inventory_receipt := rcv_transactions_sv.val_if_inventory_destination (

1253:
1254: /*
1255: ** Set the default item rev if one is not set on the transaction
1256: */
1257: inventory_receipt := rcv_transactions_sv.val_if_inventory_destination (
1258: rcv_trx.po_line_location_id, rcv_trx.shipment_line_id);
1259:
1260: /*
1261: ** If this is has an inventory destination and there is not item rev

Line 1367: from rcv_transactions_interface

1363: */
1364:
1365: select count(po_distribution_id)
1366: into x_dist_count
1367: from rcv_transactions_interface
1368: where transaction_type = 'EXPRESS DIRECT'
1369: and po_line_location_id = rcv_trx.po_line_location_id
1370: and shipment_line_id = rcv_trx.shipment_line_id;
1371:

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

1745: /*
1746: ** Prints a transaction record
1747: */
1748:
1749: PROCEDURE print_record (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
1750:
1751: BEGIN
1752: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1753: htp.code('interface_transaction_id : ' ||

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

1816: /*
1817: ** Insert into PO_INTERFACE_ERRORS table
1818: */
1819:
1820: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
1821: X_column_name IN VARCHAR2,
1822: X_err_message IN VARCHAR2) as
1823:
1824: X_progress VARCHAR2(3) := '000';