[Home] [Help]
23: |
24: |
25: *-----------------------------------------------------------------------*/
26: PROCEDURE createLogicalGroups(
27: x_batches_tab IN IBY_TRANSACTIONCC_PKG.batchAttrTabType
28: )
29: IS
30:
31: select_clause VARCHAR(4000);
467: l_mbatchid iby_batches_all.mbatchid%type;
468: l_module_name CONSTANT VARCHAR2(200) :=
469: G_PKG_NAME || '.createBatchCloseTrxnsNew';
470:
471: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
472: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
473:
474: l_index NUMBER;
475:
468: l_module_name CONSTANT VARCHAR2(200) :=
469: G_PKG_NAME || '.createBatchCloseTrxnsNew';
470:
471: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
472: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
473:
474: l_index NUMBER;
475:
476: l_system_prof_code iby_fndcpt_sys_eft_pf_b.funds_xfer_format_code%type;
531: /*
532: * Group all the transactions for this profile into
533: * batches as per the grouping attributes on the profile.
534: */
535: IBY_TRANSACTIONCC_PKG.performTransactionGrouping(
536: instr_type_in,
537: req_type_in,
538: f_pmt_channel_in,
539: f_curr_in,
802: last_updated_by = fnd_global.user_id,
803: object_version_number = object_version_number + 1
804: WHERE
805: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
806: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED
807: ;
808:
809: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
810: print_debuginfo(l_module_name, 'Finished updating transaction'
882: l_mbatchid iby_batches_all.mbatchid%type;
883: l_module_name CONSTANT VARCHAR2(200) :=
884: G_PKG_NAME || '.createBatchCloseTrxnsNew2';
885:
886: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
887: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
888: numProfCodes NUMBER;
889: strProfCodes VARCHAR2(200);
890: l_cursor_stmt VARCHAR2(1000);
883: l_module_name CONSTANT VARCHAR2(200) :=
884: G_PKG_NAME || '.createBatchCloseTrxnsNew2';
885:
886: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
887: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
888: numProfCodes NUMBER;
889: strProfCodes VARCHAR2(200);
890: l_cursor_stmt VARCHAR2(1000);
891: TYPE dyn_transactions IS REF CURSOR;
979: /*
980: * Group all the transactions for this profile into
981: * batches as per the grouping attributes on the profile.
982: */
983: IBY_TRANSACTIONCC_PKG.performTransactionGrouping(
984: profile_code_array,
985: instr_type_in,
986: req_type_in,
987: f_pmt_channel_in,
1267: last_updated_by = fnd_global.user_id,
1268: object_version_number = object_version_number + 1
1269: WHERE
1270: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
1271: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED
1272: ;
1273:
1274: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1275: print_debuginfo(l_module_name, 'Finished updating transaction'
1534: IF (iby_fipayments_pkg.requestExists(i_payeeid, i_tangibleid(j), NULL, i_reqtype)) THEN
1535: raise_application_error(-20000, 'IBY_20560#', FALSE);
1536: END IF;
1537:
1538: o_trxnid(j) := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid(j));
1539:
1540: OPEN c_trxnmid;
1541: FETCH c_trxnmid INTO l_trxnmid(j);
1542: CLOSE c_trxnmid;
1772:
1773: -- this function returns the existing transactionid from the iby_trxn_summaries_all
1774: -- table if one exist for the payeeid and tangibleid, or a new one from the DB
1775: -- sequence if none exists.
1776: o_trxnid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);
1777:
1778: -- Verify if transaction already exist and aget l_trxnmid so that the
1779: -- update is done using the PK
1780: