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.WSH_INBOUND_TXN_HISTORY_PKG dependencies on WSH_INBOUND_TXN_HISTORY

Line 1: PACKAGE BODY WSH_INBOUND_TXN_HISTORY_PKG as

1: PACKAGE BODY WSH_INBOUND_TXN_HISTORY_PKG as
2: /* $Header: WSHIBTXB.pls 120.0 2005/05/26 18:03:27 appldev noship $ */
3:
4:
5: --

Line 6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INBOUND_TXN_HISTORY_PKG';

2: /* $Header: WSHIBTXB.pls 120.0 2005/05/26 18:03:27 appldev noship $ */
3:
4:
5: --
6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INBOUND_TXN_HISTORY_PKG';
7: --
8: --===================
9: -- PROCEDURES
10: --===================

Line 91: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;

87: --
88: l_index := x_inboundTxnHistory_recTbl.transaction_type.NEXT(l_index);
89: --}
90: END LOOP;
91: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
92: --l_txn_id := wsh_inbound_txn_history_s.nextval;
93:
94: FORALL i IN x_inboundTxnHistory_recTbl.transaction_type.FIRST..x_inboundTxnHistory_recTbl.transaction_type.LAST
95: insert into wsh_inbound_txn_history

Line 92: --l_txn_id := wsh_inbound_txn_history_s.nextval;

88: l_index := x_inboundTxnHistory_recTbl.transaction_type.NEXT(l_index);
89: --}
90: END LOOP;
91: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
92: --l_txn_id := wsh_inbound_txn_history_s.nextval;
93:
94: FORALL i IN x_inboundTxnHistory_recTbl.transaction_type.FIRST..x_inboundTxnHistory_recTbl.transaction_type.LAST
95: insert into wsh_inbound_txn_history
96: (TRANSACTION_ID,

Line 95: insert into wsh_inbound_txn_history

91: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
92: --l_txn_id := wsh_inbound_txn_history_s.nextval;
93:
94: FORALL i IN x_inboundTxnHistory_recTbl.transaction_type.FIRST..x_inboundTxnHistory_recTbl.transaction_type.LAST
95: insert into wsh_inbound_txn_history
96: (TRANSACTION_ID,
97: RECEIPT_NUMBER,
98: REVISION_NUMBER,
99: SHIPMENT_NUMBER,

Line 120: values(wsh_inbound_txn_history_s.nextval,

116: LAST_UPDATED_BY,
117: CREATION_DATE,
118: CREATED_BY,
119: LAST_UPDATE_LOGIN)
120: values(wsh_inbound_txn_history_s.nextval,
121: x_inboundTxnHistory_recTbl.RECEIPT_NUMBER(i),
122: x_inboundTxnHistory_recTbl.REVISION_NUMBER(i),
123: x_inboundTxnHistory_recTbl.SHIPMENT_NUMBER(i),
124: x_inboundTxnHistory_recTbl.TRANSACTION_TYPE(i),

Line 204: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history_bulk');

200: END IF;
201: --
202: WHEN OTHERS THEN
203: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
204: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history_bulk');
205: --}
206: --
207: -- Debug Statements
208: --

Line 336: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.AUTONOMOUS_CREATE_bulk');

332: --
333: WHEN OTHERS THEN
334: ROLLBACK;
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
336: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.AUTONOMOUS_CREATE_bulk');
337: --}
338: --
339: -- Debug Statements
340: --

Line 350: -- a record in the wsh_inbound_txn_history

346: END autonomous_Create_bulk;
347:
348: --========================================================================
349: -- PROCEDURE : Create_Txn_History This procedure is used to create
350: -- a record in the wsh_inbound_txn_history
351: -- table
352: --
353: -- PARAMETERS: p_txn_history_rec This is of type ib_txn_history_rec_type.
354: -- x_txn_id Transacion Id returned by the API

Line 356: -- wsh_inbound_txn_history.

352: --
353: -- PARAMETERS: p_txn_history_rec This is of type ib_txn_history_rec_type.
354: -- x_txn_id Transacion Id returned by the API
355: -- after inserting a record into
356: -- wsh_inbound_txn_history.
357: -- x_return_status return status of the API.
358:
359: -- VERSION : current version 1.0
360: -- initial version 1.0

Line 362: -- wsh_inbound_txn_history table.

358:
359: -- VERSION : current version 1.0
360: -- initial version 1.0
361: -- COMMENT : This procedure is used to create a record in the
362: -- wsh_inbound_txn_history table.
363: -- The following are the valid transaction types -
364: -- ASN, RECEIPT, RECEIPT_ADD, RECEIPT_CORRECTION_NEGATIVE,
365: -- RECEIPT_CORRECTION_POSITIVE, ROUTING_REQUEST,
366: -- ROUTING_RESPONSE, RTV, RECEIPT_CORRECTION, RTV_CORRECTION,

Line 437: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;

433: wsh_util_core.add_message(x_return_status,l_module_name);
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:
437: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
438: --l_txn_id := wsh_inbound_txn_history_s.nextval;
439:
440: insert into wsh_inbound_txn_history
441: (TRANSACTION_ID,

Line 438: --l_txn_id := wsh_inbound_txn_history_s.nextval;

434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:
437: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
438: --l_txn_id := wsh_inbound_txn_history_s.nextval;
439:
440: insert into wsh_inbound_txn_history
441: (TRANSACTION_ID,
442: RECEIPT_NUMBER,

Line 440: insert into wsh_inbound_txn_history

436:
437: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
438: --l_txn_id := wsh_inbound_txn_history_s.nextval;
439:
440: insert into wsh_inbound_txn_history
441: (TRANSACTION_ID,
442: RECEIPT_NUMBER,
443: REVISION_NUMBER,
444: SHIPMENT_NUMBER,

Line 465: values(wsh_inbound_txn_history_s.nextval,

461: LAST_UPDATED_BY,
462: CREATION_DATE,
463: CREATED_BY,
464: LAST_UPDATE_LOGIN)
465: values(wsh_inbound_txn_history_s.nextval,
466: p_txn_history_rec.RECEIPT_NUMBER,
467: p_txn_history_rec.REVISION_NUMBER,
468: p_txn_history_rec.SHIPMENT_NUMBER,
469: p_txn_history_rec.TRANSACTION_TYPE,

Line 532: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY');

528: END IF;
529: --
530: WHEN OTHERS THEN
531: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
532: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY');
533: --}
534: --
535: -- Debug Statements
536: --

Line 664: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.AUTONOMOUS_CREATE');

660: --
661: WHEN OTHERS THEN
662: ROLLBACK;
663: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
664: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.AUTONOMOUS_CREATE');
665: --}
666: --
667: -- Debug Statements
668: --

Line 678: -- a record in the wsh_inbound_txn_history

674: END autonomous_Create;
675:
676: --========================================================================
677: -- PROCEDURE : Update_Txn_History This procedure is used to update
678: -- a record in the wsh_inbound_txn_history
679: -- table
680: --
681: -- PARAMETERS: p_txn_history_rec This is of type ib_txn_history_rec_type.
682: -- x_return_status return status of the API.

Line 687: -- in the wsh_inbound_txn_history table.

683:
684: -- VERSION : current version 1.0
685: -- initial version 1.0
686: -- COMMENT : This procedure is used to a update a record (all the attributes)
687: -- in the wsh_inbound_txn_history table.
688: --========================================================================
689: PROCEDURE update_txn_history (
690: p_txn_history_rec IN ib_txn_history_rec_type,
691: x_return_status OUT NOCOPY VARCHAR2

Line 719: update wsh_inbound_txn_history

715: WSH_DEBUG_SV.push(l_module_name);
716: END IF;
717: --
718: x_return_status := wsh_util_core.g_ret_sts_success;
719: update wsh_inbound_txn_history
720: set RECEIPT_NUMBER = DECODE
721: (
722: p_txn_history_rec.RECEIPT_NUMBER,
723: FND_API.G_MISS_CHAR,NULL,

Line 871: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.UPDATE_TXN_HISTORY');

867: END IF;
868: --
869: WHEN OTHERS THEN
870: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
871: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.UPDATE_TXN_HISTORY');
872: --}
873: --
874: -- Debug Statements
875: --

Line 885: -- a record in the wsh_inbound_txn_history

881: END update_txn_history;
882:
883: --========================================================================
884: -- PROCEDURE : Delete_Txn_History This procedure is used to delete
885: -- a record in the wsh_inbound_txn_history
886: -- table
887: --
888: -- PARAMETERS: p_transaction_id This is unique identifier of a record
889: -- in wsh_inbound_txn_history.

Line 889: -- in wsh_inbound_txn_history.

885: -- a record in the wsh_inbound_txn_history
886: -- table
887: --
888: -- PARAMETERS: p_transaction_id This is unique identifier of a record
889: -- in wsh_inbound_txn_history.
890: -- x_return_status return status of the API.
891: --
892: -- VERSION : current version 1.0
893: -- initial version 1.0

Line 895: -- wsh_inbound_txn_history table.

891: --
892: -- VERSION : current version 1.0
893: -- initial version 1.0
894: -- COMMENT : This procedure is used to delete a record in the
895: -- wsh_inbound_txn_history table.
896: --========================================================================
897: PROCEDURE delete_txn_history (
898: p_transaction_id IN NUMBER,
899: x_return_status OUT NOCOPY VARCHAR2

Line 929: delete from wsh_inbound_txn_history

925: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_ID',P_TRANSACTION_ID);
926: END IF;
927: --
928: x_return_status := wsh_util_core.g_ret_sts_success;
929: delete from wsh_inbound_txn_history
930: where transaction_id = p_transaction_id;
931: --}
932: --
933: -- Debug Statements

Line 973: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.DELETE_TXN_HISTORY');

969: END IF;
970: --
971: WHEN OTHERS THEN
972: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
973: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.DELETE_TXN_HISTORY');
974: --}
975: --
976: -- Debug Statements
977: --

Line 987: -- from wsh_inbound_txn_history based on the

983: END delete_txn_history;
984:
985: --========================================================================
986: -- PROCEDURE : Get_Txn_History This procedure is used to get the record
987: -- from wsh_inbound_txn_history based on the
988: -- inputs shipment_header_id
989: -- ,transaction_type and transaction_id.
990: --
991: -- PARAMETERS: p_transaction_id This is unique identifier of a record

Line 992: -- in wsh_inbound_txn_history.

988: -- inputs shipment_header_id
989: -- ,transaction_type and transaction_id.
990: --
991: -- PARAMETERS: p_transaction_id This is unique identifier of a record
992: -- in wsh_inbound_txn_history.
993: -- p_shipment_header_id Shipment_Header_id of the transaction.
994: -- p_transaction_type Type of Transaction.
995: -- x_txn_history_rec This is of type ib_txn_history_rec_type.
996: -- x_return_status return status of the API.

Line 1001: -- wsh_inbound_txn_history based on the inputs

997:
998: -- VERSION : current version 1.0
999: -- initial version 1.0
1000: -- COMMENT : This procedure is used to a get the record from
1001: -- wsh_inbound_txn_history based on the inputs
1002: -- shipment_header_id, transaction_type, and transaction_id.
1003: --========================================================================
1004: PROCEDURE get_txn_history (
1005: p_transaction_id IN NUMBER DEFAULT NULL,

Line 1014: -- wsh_inbound_txn_history based on the input parameters.

1010: )
1011: IS
1012: --{
1013: -- This cursor is used to get all the attributes of
1014: -- wsh_inbound_txn_history based on the input parameters.
1015: cursor l_txn_history_csr is
1016: select TRANSACTION_ID,
1017: RECEIPT_NUMBER,
1018: REVISION_NUMBER,

Line 1035: from wsh_inbound_txn_history

1031: MATCHED_BY,
1032: SHIPMENT_LINE_ID,
1033: OBJECT_VERSION_NUMBER,
1034: SHIP_FROM_LOCATION_ID -- IB-Phase-2
1035: from wsh_inbound_txn_history
1036: where transaction_id = p_transaction_id
1037: or (p_transaction_id is null
1038: AND shipment_header_id = p_shipment_header_id
1039: AND transaction_type = p_transaction_type);

Line 1118: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY');

1114: END IF;
1115: --
1116: WHEN OTHERS THEN
1117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1118: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY');
1119: --}
1120: --
1121: -- Debug Statements
1122: --

Line 1134: -- wsh_inbound_txn_history based on the

1130: --
1131: --========================================================================
1132: -- PROCEDURE : Post_Process This procedure is used to update the
1133: -- status column of the record in
1134: -- wsh_inbound_txn_history based on the
1135: -- inputs
1136: --
1137: -- PARAMETERS: p_shipment_header_id Shipment_Header_id of the transaction.
1138: -- p_max_rcv_txn_id Maximum rcv_transaction_id stored in

Line 1139: -- wsh_inbound_txn_history.

1135: -- inputs
1136: --
1137: -- PARAMETERS: p_shipment_header_id Shipment_Header_id of the transaction.
1138: -- p_max_rcv_txn_id Maximum rcv_transaction_id stored in
1139: -- wsh_inbound_txn_history.
1140: -- p_txn_status New Status of the transaction.
1141: -- p_txn_type Type of Transaction.
1142: -- x_txn_history_rec This is of type ib_txn_history_rec_type.
1143: -- x_return_status return status of the API.

Line 1161: from wsh_inbound_txn_history

1157: --{
1158: l_txn_id_tab wsh_util_core.id_tab_type;
1159: cursor l_txn_history_csr(p_shipment_header_id NUMBER) is
1160: select transaction_id
1161: from wsh_inbound_txn_history
1162: where transaction_type not in ('RECEIPT', 'ASN')
1163: and shipment_header_id = p_shipment_header_id;
1164:
1165: l_txn_history_rec ib_txn_history_rec_type;

Line 1188: delete from wsh_inbound_txn_history

1184: IF l_txn_id_tab.count > 0 THEN
1185: --{
1186:
1187: FORALL i in l_txn_id_tab.first..l_txn_id_tab.last
1188: delete from wsh_inbound_txn_history
1189: where transaction_id = l_txn_id_tab(i);
1190:
1191: get_txn_history (
1192: p_shipment_header_id => p_shipment_header_id,

Line 1308: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.POST_PROCESS');

1304: END IF;
1305: --
1306: WHEN OTHERS THEN
1307: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1308: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.POST_PROCESS');
1309: --}
1310: --
1311: -- Debug Statements
1312: --

Line 1335: from wsh_inbound_txn_history

1331: --{
1332:
1333: cursor txn_csr (p_shipment_header_id NUMBER) is
1334: select 1
1335: from wsh_inbound_txn_history
1336: where transaction_type not in ('RECEIPT', 'ASN')
1337: and shipment_header_id = p_shipment_header_id;
1338:
1339: l_txn_history_rec ib_txn_history_rec_type;

Line 1499: DELETE wsh_inbound_txn_history

1495: --
1496: IF l_txn_id > 0
1497: THEN
1498: --{
1499: DELETE wsh_inbound_txn_history
1500: WHERE transaction_type not in (C_ASN, C_RECEIPT)
1501: AND shipment_header_id = p_shipment_header_id
1502: AND max_rcv_transaction_id <= l_txn_id;
1503: --

Line 1658: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.POST_PROCESS',l_module_name);

1654: END IF;
1655: --
1656: WHEN OTHERS THEN
1657: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1658: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.POST_PROCESS',l_module_name);
1659: --
1660: -- Debug Statements
1661: --
1662: IF l_debug_on THEN

Line 1703: FROM wsh_inbound_txn_history

1699: MATCHED_BY,
1700: SHIPMENT_LINE_ID,
1701: OBJECT_VERSION_NUMBER,
1702: SHIP_FROM_LOCATION_ID -- IB-Phase-2
1703: FROM wsh_inbound_txn_history
1704: WHERE shipment_header_id = p_shipment_header_id
1705: AND transaction_type = p_transaction_type
1706: FOR UPDATE OF STATUS NOWAIT;
1707:

Line 1878: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.lock_asn_receipt_header',l_module_name);

1874: END IF;
1875: --
1876: WHEN OTHERS THEN
1877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1878: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.lock_asn_receipt_header',l_module_name);
1879: --
1880: -- Debug Statements
1881: --
1882: IF l_debug_on THEN

Line 1899: FROM wsh_inbound_txn_history

1895: IS
1896: --{
1897: CURSOR txn_csr is
1898: SELECT 1
1899: FROM wsh_inbound_txn_history
1900: WHERE transaction_id = p_transaction_id
1901: FOR UPDATE OF STATUS NOWAIT;
1902:
1903: l_param_name VARCHAR2(200);

Line 2025: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.lock_n_roll',l_module_name);

2021: --
2022: WHEN OTHERS THEN
2023: ROLLBACK TO SAVEPOINT lock_n_roll_sp;
2024: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2025: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.lock_n_roll',l_module_name);
2026: --
2027: -- Debug Statements
2028: --
2029: IF l_debug_on THEN

Line 2136: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.getTransactionTypeMeaning',l_module_name);

2132: END IF;
2133: --
2134: WHEN OTHERS THEN
2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2136: wsh_util_core.default_handler('WSH_INBOUND_TXN_HISTORY_PKG.getTransactionTypeMeaning',l_module_name);
2137: --
2138: -- Debug Statements
2139: --
2140: IF l_debug_on THEN

Line 2147: END WSH_INBOUND_TXN_HISTORY_PKG;

2143: --
2144: --}
2145: END getTransactionTypeMeaning;
2146:
2147: END WSH_INBOUND_TXN_HISTORY_PKG;