2: /*$Header: ibypbpupb.pls 115.9 2003/08/05 04:50:49 fxzhang noship $ */
3:
4: -- package global variables
5: -- status codes used in this package
6: G_STATUS_SUCCESS CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_SUCCESS;
7: G_STATUS_BEP_ERROR CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BEP_ERROR;
8: G_STATUS_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BATCH_PARTIAL;
9: G_STATUS_QRY_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PARTIAL;
10: G_STATUS_QRY_BATCH_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_FAIL;
3:
4: -- package global variables
5: -- status codes used in this package
6: G_STATUS_SUCCESS CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_SUCCESS;
7: G_STATUS_BEP_ERROR CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BEP_ERROR;
8: G_STATUS_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BATCH_PARTIAL;
9: G_STATUS_QRY_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PARTIAL;
10: G_STATUS_QRY_BATCH_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_FAIL;
11: G_STATUS_QRY_BATCH_PENDING CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PENDING;
4: -- package global variables
5: -- status codes used in this package
6: G_STATUS_SUCCESS CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_SUCCESS;
7: G_STATUS_BEP_ERROR CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BEP_ERROR;
8: G_STATUS_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BATCH_PARTIAL;
9: G_STATUS_QRY_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PARTIAL;
10: G_STATUS_QRY_BATCH_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_FAIL;
11: G_STATUS_QRY_BATCH_PENDING CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PENDING;
12: G_STATUS_QRY_TRXN_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_TRXN_FAIL;
5: -- status codes used in this package
6: G_STATUS_SUCCESS CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_SUCCESS;
7: G_STATUS_BEP_ERROR CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BEP_ERROR;
8: G_STATUS_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BATCH_PARTIAL;
9: G_STATUS_QRY_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PARTIAL;
10: G_STATUS_QRY_BATCH_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_FAIL;
11: G_STATUS_QRY_BATCH_PENDING CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PENDING;
12: G_STATUS_QRY_TRXN_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_TRXN_FAIL;
13:
6: G_STATUS_SUCCESS CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_SUCCESS;
7: G_STATUS_BEP_ERROR CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BEP_ERROR;
8: G_STATUS_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BATCH_PARTIAL;
9: G_STATUS_QRY_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PARTIAL;
10: G_STATUS_QRY_BATCH_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_FAIL;
11: G_STATUS_QRY_BATCH_PENDING CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PENDING;
12: G_STATUS_QRY_TRXN_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_TRXN_FAIL;
13:
14: /* ========================================================================
7: G_STATUS_BEP_ERROR CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BEP_ERROR;
8: G_STATUS_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BATCH_PARTIAL;
9: G_STATUS_QRY_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PARTIAL;
10: G_STATUS_QRY_BATCH_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_FAIL;
11: G_STATUS_QRY_BATCH_PENDING CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PENDING;
12: G_STATUS_QRY_TRXN_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_TRXN_FAIL;
13:
14: /* ========================================================================
15: -- Procedure Name: updateBatchStatus
8: G_STATUS_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_BATCH_PARTIAL;
9: G_STATUS_QRY_BATCH_PARTIAL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PARTIAL;
10: G_STATUS_QRY_BATCH_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_FAIL;
11: G_STATUS_QRY_BATCH_PENDING CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_BATCH_PENDING;
12: G_STATUS_QRY_TRXN_FAIL CONSTANT NUMBER := IBY_UTILITY_PVT.STATUS_QRY_TRXN_FAIL;
13:
14: /* ========================================================================
15: -- Procedure Name: updateBatchStatus
16: --