APPS.IBY_TRANSACTIONEFT_PKG dependencies on IBY_TRANSACTIONCC_PKG

Line 184: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;

180: l_mbatchid iby_batches_all.mbatchid%type;
181: l_module_name CONSTANT VARCHAR2(200) :=
182: G_PKG_NAME || '.createBatchCloseTrxnsNew';
183:
184: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
185: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
186:
187: l_index NUMBER;
188:

Line 185: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;

181: l_module_name CONSTANT VARCHAR2(200) :=
182: G_PKG_NAME || '.createBatchCloseTrxnsNew';
183:
184: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
185: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
186:
187: l_index NUMBER;
188:
189: BEGIN

Line 240: IBY_TRANSACTIONCC_PKG.performTransactionGrouping(

236: /*
237: * Group all the transactions for this profile into
238: * batches as per the grouping attributes on the profile.
239: */
240: IBY_TRANSACTIONCC_PKG.performTransactionGrouping(
241: profile_code_in,
242: instr_type_in,
243: req_type_in,
244: f_pmt_channel_in,

Line 453: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED

449: last_updated_by = fnd_global.user_id,
450: object_version_number = object_version_number + 1
451: WHERE
452: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
453: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED
454: ;
455:
456: print_debuginfo(l_module_name, 'Finished updating transaction'
457: || l_trxns_in_batch_tab(i).trxn_id);

Line 527: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;

523: l_mbatchid iby_batches_all.mbatchid%type;
524: l_module_name CONSTANT VARCHAR2(200) :=
525: G_PKG_NAME || '.createBatchCloseTrxnsNew';
526:
527: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
528: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
529: numProfCodes NUMBER;
530: strProfCodes VARCHAR2(200);
531: l_cursor_stmt VARCHAR2(1000);

Line 528: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;

524: l_module_name CONSTANT VARCHAR2(200) :=
525: G_PKG_NAME || '.createBatchCloseTrxnsNew';
526:
527: l_batches_tab IBY_TRANSACTIONCC_PKG.batchAttrTabType;
528: l_trxns_in_batch_tab IBY_TRANSACTIONCC_PKG.trxnsInBatchTabType;
529: numProfCodes NUMBER;
530: strProfCodes VARCHAR2(200);
531: l_cursor_stmt VARCHAR2(1000);
532: TYPE dyn_transactions IS REF CURSOR;

Line 616: IBY_TRANSACTIONCC_PKG.performTransactionGrouping(

612: /*
613: * Group all the transactions for this profile into
614: * batches as per the grouping attributes on the profile.
615: */
616: IBY_TRANSACTIONCC_PKG.performTransactionGrouping(
617: profile_code_array,
618: instr_type_in,
619: req_type_in,
620: f_pmt_channel_in,

Line 834: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED

830: last_updated_by = fnd_global.user_id,
831: object_version_number = object_version_number + 1
832: WHERE
833: transactionid = l_trxns_in_batch_tab(i).trxn_id AND
834: status = iby_transactioncc_pkg.C_STATUS_OPEN_BATCHED
835: ;
836:
837: print_debuginfo(l_module_name, 'Finished updating transaction'
838: || l_trxns_in_batch_tab(i).trxn_id);

Line 1095: o_trxnid(j) := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid(j));

1091: IF (iby_fipayments_pkg.requestExists(i_payeeid, i_tangibleid(j), NULL, i_reqtype)) THEN
1092: raise_application_error(-20000, 'IBY_20560#', FALSE);
1093: END IF;
1094:
1095: o_trxnid(j) := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid(j));
1096:
1097: OPEN c_trxnmid;
1098: FETCH c_trxnmid INTO l_trxnmid(j);
1099: CLOSE c_trxnmid;

Line 1333: o_trxnid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);

1329:
1330: -- this function returns the existing transactionid from the iby_trxn_summaries_all
1331: -- table if one exist for the payeeid and tangibleid, or a new one from the DB
1332: -- sequence if none exists.
1333: o_trxnid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);
1334:
1335: -- Verify if transaction already exist and aget l_trxnmid so that the
1336: -- update is done using the PK
1337: