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.IBY_TRANSACTIONCC_PKG dependencies on IBY_TRANSACTIONCC_PKG

Line 1: PACKAGE BODY iby_transactioncc_pkg AS

1: PACKAGE BODY iby_transactioncc_pkg AS
2: /*$Header: ibytxccb.pls 120.99.12020000.3 2012/10/04 16:42:44 dhati ship $*/
3:
4: --
5: -- Declare global variables

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_TRANSACTIONCC_PKG';

5: -- Declare global variables
6: --
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_TRANSACTIONCC_PKG';
10: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_TRANSACTIONCC_PKG';
11:
12: --
13: -- USE: Validates the current open batch for the given (payee,bep,bep key)

Line 10: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_TRANSACTIONCC_PKG';

6: --
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_TRANSACTIONCC_PKG';
10: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_TRANSACTIONCC_PKG';
11:
12: --
13: -- USE: Validates the current open batch for the given (payee,bep,bep key)
14: -- combination. This involves making sure: 1) the batch contains

Line 645: l_dbg_mod VARCHAR2(100) := 'IBY_TRANSACTIONCC_PKG' || '.insert_rev_result';

641: extend_names_in IN JTF_VARCHAR2_TABLE_100,
642: extend_vals_in IN JTF_VARCHAR2_TABLE_200
643: )
644: IS
645: l_dbg_mod VARCHAR2(100) := 'IBY_TRANSACTIONCC_PKG' || '.insert_rev_result';
646: l_old_auth_trxnmid NUMBER;
647: l_new_auth_trxnmid NUMBER;
648: l_cursor_empty BOOLEAN;
649:

Line 902: l_module_name CONSTANT VARCHAR2(200) := 'IBY_TRANSACTIONCC_PKG.insert_other_txn';

898: l_cursor_empty BOOLEAN;
899: l_process_profile_code iby_trxn_summaries_all.process_profile_code%TYPE;
900: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
901: l_pmt_chnl_code iby_trxn_summaries_all.payment_channel_code%TYPE;
902: l_module_name CONSTANT VARCHAR2(200) := 'IBY_TRANSACTIONCC_PKG.insert_other_txn';
903: l_subtype iby_trxn_summaries_all.instrsubtype%type;
904:
905: l_currency iby_transactions_v.currency%TYPE;
906: l_payerid iby_trxn_summaries_all.payerid%TYPE;

Line 1561: ((req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR

1557: --
1558: -- if the bep is a processor, then we create a batch
1559: --
1560: IF ( (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
1561: ((req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
1562: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)))
1563: THEN
1564:
1565: --

Line 1562: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)))

1558: -- if the bep is a processor, then we create a batch
1559: --
1560: IF ( (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
1561: ((req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
1562: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)))
1563: THEN
1564:
1565: --
1566: -- associate all trxns in the current open batch

Line 1571: status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING,

1567: -- with the bathc id of the batch close
1568: --
1569: UPDATE iby_trxn_summaries_all
1570: SET
1571: status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING,
1572: batchid = merch_batchid_in,
1573: mbatchid = l_mbatchid,
1574: last_update_date = sysdate,
1575: updatedate = sysdate,

Line 1581: AND (status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED)

1577: object_version_number = object_version_number + 1
1578: WHERE (bepid = vendor_id_in)
1579: AND (bepkey = vendor_key_in)
1580: AND (payeeid = merchant_id_in)
1581: AND (status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED)
1582: AND ((instrtype IN (iby_creditcard_pkg.C_INSTRTYPE_CCARD,
1583: iby_creditcard_pkg.C_INSTRTYPE_PCARD)
1584: AND
1585: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))

Line 1585: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))

1581: AND (status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED)
1582: AND ((instrtype IN (iby_creditcard_pkg.C_INSTRTYPE_CCARD,
1583: iby_creditcard_pkg.C_INSTRTYPE_PCARD)
1584: AND
1585: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))
1586: OR
1587: (instrtype IN (l_pinlessdebitcard)
1588: AND
1589: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE))

Line 1589: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE))

1585: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))
1586: OR
1587: (instrtype IN (l_pinlessdebitcard)
1588: AND
1589: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE))
1590: OR
1591: instrtype IS NULL)
1592: AND (batchid IS NULL);
1593:

Line 1868: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR

1864: --
1865: IF (
1866: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
1867: (
1868: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
1869: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)
1870: )
1871: ) THEN
1872:

Line 1869: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)

1865: IF (
1866: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
1867: (
1868: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
1869: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)
1870: )
1871: ) THEN
1872:
1873: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1998: status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING,

1994: /*------------------------------------------
1995: UPDATE
1996: IBY_TRXN_SUMMARIES_ALL
1997: SET
1998: status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING,
1999: batchid = merch_batchid_in
2000: || '_' || i,
2001: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,
2002: last_update_date = sysdate,

Line 2010: (status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED)i

2006: WHERE
2007: (bepid = vendor_id_in) AND
2008: (bepkey = vendor_key_in) AND
2009: (payeeid = merchant_id_in) AND
2010: (status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED)i
2011: AND
2012: (
2013: (instrtype IN
2014: (iby_creditcard_pkg.C_INSTRTYPE_CCARD,

Line 2017: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))

2013: (instrtype IN
2014: (iby_creditcard_pkg.C_INSTRTYPE_CCARD,
2015: iby_creditcard_pkg.C_INSTRTYPE_PCARD) AND
2016: (req_type_in =
2017: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))
2018: OR
2019: (instrtype IN (l_pinlessdebitcard) AND
2020: (req_type_in = iby_transactioncc_pkg.
2021: C_REQTYPE_PDC_BATCHCLOSE)

Line 2020: (req_type_in = iby_transactioncc_pkg.

2016: (req_type_in =
2017: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))
2018: OR
2019: (instrtype IN (l_pinlessdebitcard) AND
2020: (req_type_in = iby_transactioncc_pkg.
2021: C_REQTYPE_PDC_BATCHCLOSE)
2022: )
2023: OR
2024: instrtype IS NULL

Line 2038: status = iby_transactioncc_pkg.

2034: END IF;
2035: UPDATE
2036: IBY_TRXN_SUMMARIES_ALL
2037: SET
2038: status = iby_transactioncc_pkg.
2039: C_STATUS_BATCH_PENDING,
2040: batchid = l_trxns_in_batch_tab(i).
2041: batch_id,
2042: mbatchid = l_trxns_in_batch_tab(i).

Line 2050: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED

2046: last_updated_by = fnd_global.user_id,
2047: object_version_number = object_version_number + 1
2048: WHERE
2049: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
2050: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED
2051: ;
2052:
2053: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2054: print_debuginfo(l_module_name, 'Finished updating '

Line 2532: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR

2528: --
2529: IF (
2530: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
2531: (
2532: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
2533: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)
2534: )
2535: ) THEN
2536:

Line 2533: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)

2529: IF (
2530: (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_PROCESSOR) AND
2531: (
2532: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE) OR
2533: (req_type_in = iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE)
2534: )
2535: ) THEN
2536:
2537: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2660: status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING,

2656: /*------------------------------------------
2657: UPDATE
2658: IBY_TRXN_SUMMARIES_ALL
2659: SET
2660: status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING,
2661: batchid = merch_batchid_in
2662: || '_' || i,
2663: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,
2664: last_update_date = sysdate,

Line 2672: (status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED)i

2668: WHERE
2669: (bepid = vendor_id_in) AND
2670: (bepkey = vendor_key_in) AND
2671: (payeeid = merchant_id_in) AND
2672: (status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED)i
2673: AND
2674: (
2675: (instrtype IN
2676: (iby_creditcard_pkg.C_INSTRTYPE_CCARD,

Line 2679: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))

2675: (instrtype IN
2676: (iby_creditcard_pkg.C_INSTRTYPE_CCARD,
2677: iby_creditcard_pkg.C_INSTRTYPE_PCARD) AND
2678: (req_type_in =
2679: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))
2680: OR
2681: (instrtype IN (l_pinlessdebitcard) AND
2682: (req_type_in = iby_transactioncc_pkg.
2683: C_REQTYPE_PDC_BATCHCLOSE)

Line 2682: (req_type_in = iby_transactioncc_pkg.

2678: (req_type_in =
2679: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE))
2680: OR
2681: (instrtype IN (l_pinlessdebitcard) AND
2682: (req_type_in = iby_transactioncc_pkg.
2683: C_REQTYPE_PDC_BATCHCLOSE)
2684: )
2685: OR
2686: instrtype IS NULL

Line 2701: status = iby_transactioncc_pkg.

2697:
2698: /*UPDATE
2699: IBY_TRXN_SUMMARIES_ALL
2700: SET
2701: status = iby_transactioncc_pkg.
2702: C_STATUS_BATCH_PENDING,
2703: batchid = l_trxns_in_batch_tab(i).
2704: batch_id,
2705: mbatchid = l_trxns_in_batch_tab(i).

Line 2713: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED

2709: last_updated_by = fnd_global.user_id,
2710: object_version_number = object_version_number + 1
2711: WHERE
2712: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
2713: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED
2714: ;*/
2715:
2716: /*IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2717: print_debuginfo(l_module_name, 'Finished updating '

Line 3046: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

3042: f_maturity_date IN IBY_TRXN_SUMMARIES_ALL.
3043: br_maturity_date%TYPE,
3044: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
3045: instrtype%TYPE,
3046: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
3047: batchAttrTabType,
3048: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
3049: trxnsInBatchTabType
3050: )

Line 3048: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

3044: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
3045: instrtype%TYPE,
3046: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
3047: batchAttrTabType,
3048: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
3049: trxnsInBatchTabType
3050: )
3051: IS
3052: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 3137: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;

3133: * \_______|_______|__|_______|_______|__/ \_______|____/
3134: *
3135: */
3136:
3137: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;
3138: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
3139:
3140: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
3141: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;

Line 3138: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;

3134: *
3135: */
3136:
3137: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;
3138: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
3139:
3140: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
3141: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
3142:

Line 3140: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;

3136:
3137: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;
3138: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
3139:
3140: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
3141: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
3142:
3143: l_trxnGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
3144:

Line 3141: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;

3137: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;
3138: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
3139:
3140: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
3141: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
3142:
3143: l_trxnGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
3144:
3145: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';

Line 3143: l_trxnGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;

3139:
3140: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
3141: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
3142:
3143: l_trxnGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
3144:
3145: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
3146: l_bankaccount CONSTANT VARCHAR2(100) :='BANKACCOUNT';
3147:

Line 3231: txn.status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED AND

3227: WHERE
3228: user_prof.user_cc_profile_code = p_profile_code AND
3229: txn.process_profile_code = user_prof.user_cc_profile_code AND
3230: sys_prof.sys_cc_profile_code = user_prof.sys_cc_profile_code AND
3231: txn.status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED AND
3232: (
3233: /*
3234: * This clause will pick up credit card / purchase card
3235: * transactions.

Line 3247: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,

3243: AND
3244: (
3245: txn.reqtype IN
3246: (
3247: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,
3248: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,
3249: iby_transactioncc_pkg.C_REQTYPE_CREDIT,
3250: iby_transactioncc_pkg.C_REQTYPE_RETURN
3251: )

Line 3248: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,

3244: (
3245: txn.reqtype IN
3246: (
3247: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,
3248: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,
3249: iby_transactioncc_pkg.C_REQTYPE_CREDIT,
3250: iby_transactioncc_pkg.C_REQTYPE_RETURN
3251: )
3252: )

Line 3249: iby_transactioncc_pkg.C_REQTYPE_CREDIT,

3245: txn.reqtype IN
3246: (
3247: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,
3248: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,
3249: iby_transactioncc_pkg.C_REQTYPE_CREDIT,
3250: iby_transactioncc_pkg.C_REQTYPE_RETURN
3251: )
3252: )
3253: AND

Line 3250: iby_transactioncc_pkg.C_REQTYPE_RETURN

3246: (
3247: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,
3248: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,
3249: iby_transactioncc_pkg.C_REQTYPE_CREDIT,
3250: iby_transactioncc_pkg.C_REQTYPE_RETURN
3251: )
3252: )
3253: AND
3254: (

Line 3277: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE,

3273: AND
3274: (
3275: txn.reqtype IN
3276: (
3277: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE,
3278: iby_transactioncc_pkg.C_REQTYPE_REQUEST
3279: )
3280: )
3281: AND

Line 3278: iby_transactioncc_pkg.C_REQTYPE_REQUEST

3274: (
3275: txn.reqtype IN
3276: (
3277: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE,
3278: iby_transactioncc_pkg.C_REQTYPE_REQUEST
3279: )
3280: )
3281: AND
3282: (

Line 3304: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE,

3300: AND
3301: (
3302: txn.reqtype IN
3303: (
3304: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE,
3305: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ
3306: )
3307: )
3308: AND

Line 3305: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ

3301: (
3302: txn.reqtype IN
3303: (
3304: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE,
3305: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ
3306: )
3307: )
3308: AND
3309: (

Line 3669: iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED, /* open_batch */

3665: OPEN l_trxn_cursor FOR
3666: l_cursor_stmt
3667: USING
3668: p_profile_code, /* profile_code */
3669: iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED, /* open_batch */
3670: instr_type, /* A */
3671: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C1 */
3672: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
3673: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */

Line 3673: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */

3669: iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED, /* open_batch */
3670: instr_type, /* A */
3671: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C1 */
3672: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
3673: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */
3674: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */
3675: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */
3676: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */
3677: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */

Line 3674: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */

3670: instr_type, /* A */
3671: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C1 */
3672: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
3673: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */
3674: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */
3675: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */
3676: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */
3677: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */
3678: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */

Line 3675: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */

3671: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C1 */
3672: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
3673: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */
3674: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */
3675: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */
3676: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */
3677: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */
3678: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */
3679: instr_type, /* C */

Line 3676: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */

3672: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
3673: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */
3674: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */
3675: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */
3676: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */
3677: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */
3678: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */
3679: instr_type, /* C */
3680: l_pinlessdebitcard, /* P1 */

Line 3681: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE, /* T2A */

3677: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */
3678: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */
3679: instr_type, /* C */
3680: l_pinlessdebitcard, /* P1 */
3681: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE, /* T2A */
3682: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T2B */
3683: l_pinlessdebitcard, /* P2 */
3684: instr_type, /* E */
3685: l_bankaccount, /* B1 */

Line 3682: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T2B */

3678: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */
3679: instr_type, /* C */
3680: l_pinlessdebitcard, /* P1 */
3681: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE, /* T2A */
3682: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T2B */
3683: l_pinlessdebitcard, /* P2 */
3684: instr_type, /* E */
3685: l_bankaccount, /* B1 */
3686: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */

Line 3686: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */

3682: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T2B */
3683: l_pinlessdebitcard, /* P2 */
3684: instr_type, /* E */
3685: l_bankaccount, /* B1 */
3686: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */
3687: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ, /* T3B */
3688: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T3C */
3689: l_bankaccount /* B2 */
3690: ;

Line 3687: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ, /* T3B */

3683: l_pinlessdebitcard, /* P2 */
3684: instr_type, /* E */
3685: l_bankaccount, /* B1 */
3686: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */
3687: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ, /* T3B */
3688: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T3C */
3689: l_bankaccount /* B2 */
3690: ;
3691: FETCH l_trxn_cursor BULK COLLECT INTO l_trxnGrpCriTab;

Line 3688: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T3C */

3684: instr_type, /* E */
3685: l_bankaccount, /* B1 */
3686: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */
3687: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ, /* T3B */
3688: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T3C */
3689: l_bankaccount /* B2 */
3690: ;
3691: FETCH l_trxn_cursor BULK COLLECT INTO l_trxnGrpCriTab;
3692: CLOSE l_trxn_cursor;

Line 4211: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

4207: f_instr_type IN IBY_TRXN_SUMMARIES_ALL.
4208: instrtype%TYPE,
4209: merch_batchid_in IN iby_batches_all.batchid%TYPE,
4210:
4211: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
4212: batchAttrTabType,
4213: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
4214: trxnsInBatchTabType
4215: )

Line 4213: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.

4209: merch_batchid_in IN iby_batches_all.batchid%TYPE,
4210:
4211: x_batchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
4212: batchAttrTabType,
4213: x_trxnsInBatchTab IN OUT NOCOPY IBY_TRANSACTIONCC_PKG.
4214: trxnsInBatchTabType
4215: )
4216: IS
4217: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 4302: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;

4298: * \_______|_______|__|_______|_______|__/ \_______|____/
4299: *
4300: */
4301:
4302: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;
4303: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4304: emptyTrxnInsBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4305:
4306: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;

Line 4303: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;

4299: *
4300: */
4301:
4302: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;
4303: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4304: emptyTrxnInsBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4305:
4306: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
4307: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;

Line 4304: emptyTrxnInsBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;

4300: */
4301:
4302: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;
4303: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4304: emptyTrxnInsBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4305:
4306: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
4307: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
4308:

Line 4306: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;

4302: l_batchRec IBY_TRANSACTIONCC_PKG.batchAttrRecType;
4303: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4304: emptyTrxnInsBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4305:
4306: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
4307: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
4308:
4309: l_trxnGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
4310: emptyGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;

Line 4307: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;

4303: l_trxnsInBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4304: emptyTrxnInsBatchTab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
4305:
4306: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
4307: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
4308:
4309: l_trxnGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
4310: emptyGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
4311:

Line 4309: l_trxnGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;

4305:
4306: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
4307: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
4308:
4309: l_trxnGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
4310: emptyGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
4311:
4312: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
4313: l_bankaccount CONSTANT VARCHAR2(100) :='BANKACCOUNT';

Line 4310: emptyGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;

4306: l_trxnsInBatchRec IBY_TRANSACTIONCC_PKG.trxnsInBatchRecType;
4307: l_batchTab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
4308:
4309: l_trxnGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
4310: emptyGrpCriTab IBY_TRANSACTIONCC_PKG.trxnGroupCriteriaTabType;
4311:
4312: l_pinlessdebitcard CONSTANT VARCHAR2(100) :='PINLESSDEBITCARD';
4313: l_bankaccount CONSTANT VARCHAR2(100) :='BANKACCOUNT';
4314:

Line 4404: txn.status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED AND

4400: WHERE
4401: user_prof.user_cc_profile_code IN (strProfiles) AND
4402: txn.process_profile_code = user_prof.user_cc_profile_code AND
4403: sys_prof.sys_cc_profile_code = user_prof.sys_cc_profile_code AND
4404: txn.status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED AND
4405: (
4406: /*
4407: * This clause will pick up credit card / purchase card
4408: * transactions.

Line 4420: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,

4416: AND
4417: (
4418: txn.reqtype IN
4419: (
4420: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,
4421: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,
4422: iby_transactioncc_pkg.C_REQTYPE_CREDIT,
4423: iby_transactioncc_pkg.C_REQTYPE_RETURN
4424: )

Line 4421: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,

4417: (
4418: txn.reqtype IN
4419: (
4420: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,
4421: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,
4422: iby_transactioncc_pkg.C_REQTYPE_CREDIT,
4423: iby_transactioncc_pkg.C_REQTYPE_RETURN
4424: )
4425: )

Line 4422: iby_transactioncc_pkg.C_REQTYPE_CREDIT,

4418: txn.reqtype IN
4419: (
4420: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,
4421: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,
4422: iby_transactioncc_pkg.C_REQTYPE_CREDIT,
4423: iby_transactioncc_pkg.C_REQTYPE_RETURN
4424: )
4425: )
4426: AND

Line 4423: iby_transactioncc_pkg.C_REQTYPE_RETURN

4419: (
4420: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE,
4421: iby_transactioncc_pkg.C_REQTYPE_CAPTURE,
4422: iby_transactioncc_pkg.C_REQTYPE_CREDIT,
4423: iby_transactioncc_pkg.C_REQTYPE_RETURN
4424: )
4425: )
4426: AND
4427: (

Line 4450: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE,

4446: AND
4447: (
4448: txn.reqtype IN
4449: (
4450: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE,
4451: iby_transactioncc_pkg.C_REQTYPE_REQUEST
4452: )
4453: )
4454: AND

Line 4451: iby_transactioncc_pkg.C_REQTYPE_REQUEST

4447: (
4448: txn.reqtype IN
4449: (
4450: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE,
4451: iby_transactioncc_pkg.C_REQTYPE_REQUEST
4452: )
4453: )
4454: AND
4455: (

Line 4477: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE,

4473: AND
4474: (
4475: txn.reqtype IN
4476: (
4477: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE,
4478: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ
4479: )
4480: )
4481: AND

Line 4478: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ

4474: (
4475: txn.reqtype IN
4476: (
4477: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE,
4478: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ
4479: )
4480: )
4481: AND
4482: (

Line 4870: iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED, /* open_batch */

4866: l_cursor_stmt
4867: USING
4868: -- comment out this one as we have already put this value in a comma separated string
4869: --p_profile_code, /* profile_code */
4870: iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED, /* open_batch */
4871: instr_type, /* A */
4872: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C1 */
4873: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
4874: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */

Line 4874: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */

4870: iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED, /* open_batch */
4871: instr_type, /* A */
4872: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C1 */
4873: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
4874: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */
4875: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */
4876: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */
4877: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */
4878: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T1E */

Line 4875: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */

4871: instr_type, /* A */
4872: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C1 */
4873: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
4874: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */
4875: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */
4876: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */
4877: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */
4878: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T1E */
4879: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */

Line 4876: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */

4872: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C1 */
4873: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
4874: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */
4875: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */
4876: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */
4877: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */
4878: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T1E */
4879: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */
4880: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */

Line 4877: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */

4873: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C2 */
4874: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */
4875: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */
4876: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */
4877: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */
4878: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T1E */
4879: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */
4880: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */
4881: instr_type, /* C */

Line 4878: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T1E */

4874: iby_transactioncc_pkg.C_REQTYPE_BATCHCLOSE, /* T1A */
4875: iby_transactioncc_pkg.C_REQTYPE_CAPTURE, /* T1B */
4876: iby_transactioncc_pkg.C_REQTYPE_CREDIT, /* T1C */
4877: iby_transactioncc_pkg.C_REQTYPE_RETURN, /* T1D */
4878: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T1E */
4879: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */
4880: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */
4881: instr_type, /* C */
4882: l_pinlessdebitcard, /* P1 */

Line 4883: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE, /* T2A */

4879: iby_creditcard_pkg.C_INSTRTYPE_CCARD, /* C3 */
4880: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */
4881: instr_type, /* C */
4882: l_pinlessdebitcard, /* P1 */
4883: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE, /* T2A */
4884: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T2B */
4885: l_pinlessdebitcard, /* P2 */
4886: instr_type, /* E */
4887: l_bankaccount, /* B1 */

Line 4884: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T2B */

4880: iby_creditcard_pkg.C_INSTRTYPE_PCARD, /* C4 */
4881: instr_type, /* C */
4882: l_pinlessdebitcard, /* P1 */
4883: iby_transactioncc_pkg.C_REQTYPE_PDC_BATCHCLOSE, /* T2A */
4884: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T2B */
4885: l_pinlessdebitcard, /* P2 */
4886: instr_type, /* E */
4887: l_bankaccount, /* B1 */
4888: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */

Line 4888: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */

4884: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T2B */
4885: l_pinlessdebitcard, /* P2 */
4886: instr_type, /* E */
4887: l_bankaccount, /* B1 */
4888: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */
4889: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ, /* T3B */
4890: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T3C */
4891: l_bankaccount /* B2 */
4892: ;

Line 4889: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ, /* T3B */

4885: l_pinlessdebitcard, /* P2 */
4886: instr_type, /* E */
4887: l_bankaccount, /* B1 */
4888: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */
4889: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ, /* T3B */
4890: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T3C */
4891: l_bankaccount /* B2 */
4892: ;
4893: --Bug 8658052

Line 4890: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T3C */

4886: instr_type, /* E */
4887: l_bankaccount, /* B1 */
4888: iby_transactioncc_pkg.C_REQTYPE_EFT_BATCHCLOSE, /* T3A */
4889: iby_transactioncc_pkg.C_REQTYPE_BATCHREQ, /* T3B */
4890: iby_transactioncc_pkg.C_REQTYPE_REQUEST, /* T3C */
4891: l_bankaccount /* B2 */
4892: ;
4893: --Bug 8658052
4894: --Included fetch limit

Line 5390: status = iby_transactioncc_pkg.

5386: /* Bug 9958732 : Used INDEX hint to force the index */
5387: UPDATE /*+ INDEX(IBY_TRXN_SUMMARIES_ALL IBY_TRXN_SUMM_TRANS_ID_N1) */
5388: IBY_TRXN_SUMMARIES_ALL
5389: SET
5390: status = iby_transactioncc_pkg.
5391: C_STATUS_BATCH_PENDING,
5392: batchid = trxnTab.batchid(i),
5393: mbatchid = trxnTab.mbatchid(i),
5394: last_update_date = sysdate,

Line 5400: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED

5396: last_updated_by = fnd_global.user_id,
5397: object_version_number = object_version_number + 1
5398: WHERE
5399: transactionid = trxnTab.transactionid(i) AND
5400: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED
5401: ;
5402: -- Bug# 8658052
5403: -- Freeing up the memory space. Assign an empty table
5404: l_trxnGrpCriTab:= emptyGrpCriTab;

Line 6486: AND (status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING)

6482: AND (tangibleid = ci_orderid)
6483: -- ack cannot distinguish between credits and returns
6484: AND (DECODE(reqtype, 'ORAPMTRETURN','ORAPMTCREDIT', reqtype) =
6485: ci_reqtype)
6486: AND (status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING)
6487: AND (mbatchid = ci_mbatchid);
6488:
6489: -- [lmallick] - bug# 9414266
6490: -- gets the trxnmid of the capture trxn associated with the auth

Line 6518: AND ibs.status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING;

6514: AND ibs.trxntypeid IN(8, 5, 11)
6515: AND orig_trxn.trxnmid=ibc.trxnmid
6516: AND ibc.tracenumber=ci_tracenumber
6517: AND ibs.mbatchid=ci_mbatchid
6518: AND ibs.status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING;
6519:
6520: BEGIN
6521:
6522: IF (c_tmid%ISOPEN) THEN CLOSE c_tmid; END IF;

Line 6650: AND (status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING);

6646: last_updated_by = fnd_global.user_id,
6647: object_version_number = object_version_number + 1
6648: WHERE (payeeid = payeeid_in)
6649: AND (mbatchid = batchid_in)
6650: AND (status = iby_transactioncc_pkg.C_STATUS_BATCH_PENDING);
6651: END IF;
6652: END IF;
6653:
6654: COMMIT;

Line 6982: l_dbg_mod VARCHAR2(100) := 'IBY_TRANSACTIONCC_PKG' || '.Encrypt_CC_Data';

6978: tx.instrtype) = 'CREDITCARD')
6979: AND tx.trxnmid = core.trxnmid
6980: AND NVL(core.encrypted, 'N') = 'N';
6981:
6982: l_dbg_mod VARCHAR2(100) := 'IBY_TRANSACTIONCC_PKG' || '.Encrypt_CC_Data';
6983: BEGIN
6984:
6985: IF (iby_creditcard_pkg.Get_CC_Encrypt_Mode() =
6986: iby_security_pkg.G_ENCRYPT_MODE_NONE)

Line 7003: IBY_TRANSACTIONCC_PKG.prepare_instr_data

6999: -- Invoke the encryption API only if the card# is numeric, or else
7000: -- the API might thow an exception resulting in abrupt termination
7001: -- of the program.
7002: IF('Y' = IBY_UTILITY_PVT.isNumeric(txn_rec.ccnum)) THEN
7003: IBY_TRANSACTIONCC_PKG.prepare_instr_data
7004: (FND_API.G_FALSE,
7005: p_sys_key,
7006: txn_rec.ccnum,
7007: txn_rec.instrtype,

Line 7127: iby_transactioncc_pkg.unencrypt_instr_num

7123: CURSOR c_tx_ccnumber(ci_sys_key IN IBY_SECURITY_PKG.DES3_KEY_TYPE)
7124: IS
7125: SELECT /*+ rowid(tx) */
7126: tx.trxnmid,
7127: iby_transactioncc_pkg.unencrypt_instr_num
7128: (tx.instrnumber, NULL, NULL, ci_sys_key,
7129: k.subkey_cipher_text, tx.instrnum_sec_segment_id,
7130: seg.segment_cipher_text, r.card_number_prefix,
7131: NVL(r.card_number_length,tx.instrnum_length),

Line 7299: AND (status=iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED)

7295: -- don't bother until ecapp scoping is seriously
7296: -- supported by IBY
7297: --
7298: --AND (ci_ecappid=ecappid)
7299: AND (status=iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED)
7300: AND (batchid IS NULL)
7301: AND (instrtype IN (iby_creditcard_pkg.C_INSTRTYPE_CCARD,
7302: iby_creditcard_pkg.C_INSTRTYPE_PCARD)
7303: OR instrtype IS NULL);

Line 7378: iby_transactioncc_pkg.insert_batch_status

7374: -- define the batch; note that this method
7375: -- commits data, so no need for a commit
7376: -- statement to follow
7377: --
7378: iby_transactioncc_pkg.insert_batch_status
7379: (
7380: batchid_out,
7381: payeeid_in,
7382: bepid_in,

Line 7385: iby_transactioncc_pkg.C_STATUS_COMMUNICATION_ERROR,

7381: payeeid_in,
7382: bepid_in,
7383: bepkey_in,
7384: iby_creditcard_pkg.C_INSTRTYPE_CCARD,
7385: iby_transactioncc_pkg.C_STATUS_COMMUNICATION_ERROR,
7386: SYSDATE,
7387: '',
7388: '',
7389: trxncount_out,

Line 7390: iby_transactioncc_pkg.C_STATUS_COMMUNICATION_ERROR,

7386: SYSDATE,
7387: '',
7388: '',
7389: trxncount_out,
7390: iby_transactioncc_pkg.C_STATUS_COMMUNICATION_ERROR,
7391: 0,
7392: 0,
7393: 0,
7394: '',

Line 7556: END iby_transactioncc_pkg;

7552: trxnTab.batchid.delete;
7553: print_debuginfo(l_module_name, 'EXIT');
7554: END;
7555:
7556: END iby_transactioncc_pkg;