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.

[Home] [Help]

APPS.IBY_TRANSACTIONEFT_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 42: iby_trxn_summaries_all

38: COUNT(*)
39: INTO
40: numtrxns_out
41: FROM
42: iby_trxn_summaries_all
43: WHERE
44: status = oldstatus_in AND
45: payeeid = merchant_id_in AND
46: bepid = vendor_id_in AND

Line 111: IBY_TRXN_SUMMARIES_ALL

107: 0
108: );
109:
110: UPDATE
111: IBY_TRXN_SUMMARIES_ALL
112: SET
113: status = newstatus_in,
114: batchid = merch_batchid_in,
115: mbatchid = l_mbatchid,

Line 160: f_pmt_channel_in IN iby_trxn_summaries_all.

156: instr_type_in IN iby_batches_all.
157: instrument_type%TYPE,
158: br_disputed_flag_in IN iby_batches_all.
159: br_disputed_flag%TYPE,
160: f_pmt_channel_in IN iby_trxn_summaries_all.
161: payment_channel_code%TYPE,
162: f_curr_in IN iby_trxn_summaries_all.
163: currencynamecode%TYPE,
164: f_settle_date IN iby_trxn_summaries_all.

Line 162: f_curr_in IN iby_trxn_summaries_all.

158: br_disputed_flag_in IN iby_batches_all.
159: br_disputed_flag%TYPE,
160: f_pmt_channel_in IN iby_trxn_summaries_all.
161: payment_channel_code%TYPE,
162: f_curr_in IN iby_trxn_summaries_all.
163: currencynamecode%TYPE,
164: f_settle_date IN iby_trxn_summaries_all.
165: settledate%TYPE,
166: f_due_date IN iby_trxn_summaries_all.

Line 164: f_settle_date IN iby_trxn_summaries_all.

160: f_pmt_channel_in IN iby_trxn_summaries_all.
161: payment_channel_code%TYPE,
162: f_curr_in IN iby_trxn_summaries_all.
163: currencynamecode%TYPE,
164: f_settle_date IN iby_trxn_summaries_all.
165: settledate%TYPE,
166: f_due_date IN iby_trxn_summaries_all.
167: settlement_due_date%TYPE,
168: f_maturity_date IN iby_trxn_summaries_all.

Line 166: f_due_date IN iby_trxn_summaries_all.

162: f_curr_in IN iby_trxn_summaries_all.
163: currencynamecode%TYPE,
164: f_settle_date IN iby_trxn_summaries_all.
165: settledate%TYPE,
166: f_due_date IN iby_trxn_summaries_all.
167: settlement_due_date%TYPE,
168: f_maturity_date IN iby_trxn_summaries_all.
169: br_maturity_date%TYPE,
170: f_instr_type IN iby_trxn_summaries_all.

Line 168: f_maturity_date IN iby_trxn_summaries_all.

164: f_settle_date IN iby_trxn_summaries_all.
165: settledate%TYPE,
166: f_due_date IN iby_trxn_summaries_all.
167: settlement_due_date%TYPE,
168: f_maturity_date IN iby_trxn_summaries_all.
169: br_maturity_date%TYPE,
170: f_instr_type IN iby_trxn_summaries_all.
171: instrtype%TYPE,
172: numtrxns_out OUT NOCOPY NUMBER,

Line 170: f_instr_type IN iby_trxn_summaries_all.

166: f_due_date IN iby_trxn_summaries_all.
167: settlement_due_date%TYPE,
168: f_maturity_date IN iby_trxn_summaries_all.
169: br_maturity_date%TYPE,
170: f_instr_type IN iby_trxn_summaries_all.
171: instrtype%TYPE,
172: numtrxns_out OUT NOCOPY NUMBER,
173: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
174: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 219: iby_trxn_summaries_all

215: COUNT(*)
216: INTO
217: numtrxns_out
218: FROM
219: iby_trxn_summaries_all
220: WHERE
221: status = oldstatus_in AND
222: payeeid = merchant_id_in AND
223: bepid = vendor_id_in AND

Line 442: IBY_TRXN_SUMMARIES_ALL

438: print_debuginfo(l_module_name, 'Going to update transaction '
439: || l_trxns_in_batch_tab(i).trxn_id);
440:
441: UPDATE
442: IBY_TRXN_SUMMARIES_ALL
443: SET
444: status = newstatus_in,
445: batchid = l_trxns_in_batch_tab(i).batch_id,
446: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,

Line 503: f_pmt_channel_in IN iby_trxn_summaries_all.

499: instr_type_in IN iby_batches_all.
500: instrument_type%TYPE,
501: br_disputed_flag_in IN iby_batches_all.
502: br_disputed_flag%TYPE,
503: f_pmt_channel_in IN iby_trxn_summaries_all.
504: payment_channel_code%TYPE,
505: f_curr_in IN iby_trxn_summaries_all.
506: currencynamecode%TYPE,
507: f_settle_date IN iby_trxn_summaries_all.

Line 505: f_curr_in IN iby_trxn_summaries_all.

501: br_disputed_flag_in IN iby_batches_all.
502: br_disputed_flag%TYPE,
503: f_pmt_channel_in IN iby_trxn_summaries_all.
504: payment_channel_code%TYPE,
505: f_curr_in IN iby_trxn_summaries_all.
506: currencynamecode%TYPE,
507: f_settle_date IN iby_trxn_summaries_all.
508: settledate%TYPE,
509: f_due_date IN iby_trxn_summaries_all.

Line 507: f_settle_date IN iby_trxn_summaries_all.

503: f_pmt_channel_in IN iby_trxn_summaries_all.
504: payment_channel_code%TYPE,
505: f_curr_in IN iby_trxn_summaries_all.
506: currencynamecode%TYPE,
507: f_settle_date IN iby_trxn_summaries_all.
508: settledate%TYPE,
509: f_due_date IN iby_trxn_summaries_all.
510: settlement_due_date%TYPE,
511: f_maturity_date IN iby_trxn_summaries_all.

Line 509: f_due_date IN iby_trxn_summaries_all.

505: f_curr_in IN iby_trxn_summaries_all.
506: currencynamecode%TYPE,
507: f_settle_date IN iby_trxn_summaries_all.
508: settledate%TYPE,
509: f_due_date IN iby_trxn_summaries_all.
510: settlement_due_date%TYPE,
511: f_maturity_date IN iby_trxn_summaries_all.
512: br_maturity_date%TYPE,
513: f_instr_type IN iby_trxn_summaries_all.

Line 511: f_maturity_date IN iby_trxn_summaries_all.

507: f_settle_date IN iby_trxn_summaries_all.
508: settledate%TYPE,
509: f_due_date IN iby_trxn_summaries_all.
510: settlement_due_date%TYPE,
511: f_maturity_date IN iby_trxn_summaries_all.
512: br_maturity_date%TYPE,
513: f_instr_type IN iby_trxn_summaries_all.
514: instrtype%TYPE,
515: numtrxns_out OUT NOCOPY NUMBER,

Line 513: f_instr_type IN iby_trxn_summaries_all.

509: f_due_date IN iby_trxn_summaries_all.
510: settlement_due_date%TYPE,
511: f_maturity_date IN iby_trxn_summaries_all.
512: br_maturity_date%TYPE,
513: f_instr_type IN iby_trxn_summaries_all.
514: instrtype%TYPE,
515: numtrxns_out OUT NOCOPY NUMBER,
516: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
517: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 580: iby_trxn_summaries_all

576: COUNT(*)
577: INTO
578: numtrxns_out
579: FROM
580: iby_trxn_summaries_all
581: WHERE
582: status = oldstatus_in AND
583: payeeid = merchant_id_in AND
584: bepid = vendor_id_in AND

Line 592: ' iby_trxn_summaries_all WHERE '||

588: instrtype = 'BANKACCOUNT';
589: */
590:
591: l_cursor_stmt := ' SELECT COUNT(*) FROM '||
592: ' iby_trxn_summaries_all WHERE '||
593: ' status = '||oldstatus_in||' AND '||
594: ' payeeid = '''||merchant_id_in||''' AND '||
595: ' bepid = '||vendor_id_in||' AND '||
596: ' process_profile_code IN ('||strProfCodes||') AND '||

Line 823: IBY_TRXN_SUMMARIES_ALL

819: print_debuginfo(l_module_name, 'Going to update transaction '
820: || l_trxns_in_batch_tab(i).trxn_id);
821:
822: UPDATE
823: IBY_TRXN_SUMMARIES_ALL
824: SET
825: status = newstatus_in,
826: batchid = l_trxns_in_batch_tab(i).batch_id,
827: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,

Line 912: UPDATE iby_trxn_summaries_all

908: SENTCOUNTERDAILY = SENTCOUNTERDAILY + 1
909: WHERE batchid = merch_batchid_in
910: AND payeeid = merchant_id_in;
911:
912: UPDATE iby_trxn_summaries_all
913: SET
914: STATUS = newstatus_in,
915: BEPCODE = vendor_code_in,
916: BEPMESSAGE = vendor_message_in,

Line 969: UPDATE iby_trxn_summaries_all

965: o_status_arr( l_index ) := c_SUCCESS;
966:
967: BEGIN -- Nested block begins
968:
969: UPDATE iby_trxn_summaries_all
970: SET STATUS = i_status_arr( l_index ),
971: BEPCODE = i_errCode_arr( l_index ),
972: BEPMESSAGE = i_errMsg_arr( l_index ),
973: LAST_UPDATE_DATE = sysdate,

Line 1004: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,

1000:
1001: END updateTrxnResultStatus;
1002:
1003: PROCEDURE insertEFTBatchTrxns(
1004: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1005: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1006: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1007: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,

Line 1005: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,

1001: END updateTrxnResultStatus;
1002:
1003: PROCEDURE insertEFTBatchTrxns(
1004: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1005: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1006: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1007: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,

Line 1006: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,

1002:
1003: PROCEDURE insertEFTBatchTrxns(
1004: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1005: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1006: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1007: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1010: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,

Line 1007: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,

1003: PROCEDURE insertEFTBatchTrxns(
1004: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1005: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1006: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1007: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1010: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1011: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,

Line 1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,

1004: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1005: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1006: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1007: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1010: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1011: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1012: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,

Line 1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,

1005: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1006: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1007: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1010: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1011: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1012: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1013: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,

Line 1010: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,

1006: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1007: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1010: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1011: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1012: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1013: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1014:

Line 1011: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,

1007: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1010: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1011: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1012: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1013: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1014:
1015: i_payerinstrid IN JTF_NUMBER_TABLE,

Line 1012: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,

1008: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1010: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1011: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1012: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1013: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1014:
1015: i_payerinstrid IN JTF_NUMBER_TABLE,
1016: i_amount IN JTF_NUMBER_TABLE,

Line 1013: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,

1009: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1010: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1011: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1012: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1013: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1014:
1015: i_payerinstrid IN JTF_NUMBER_TABLE,
1016: i_amount IN JTF_NUMBER_TABLE,
1017: i_payerid IN JTF_VARCHAR2_TABLE_100,

Line 1050: FROM iby_trxn_summaries_all

1046: * Check if this EC batch is already been submitted
1047: * by the EC application.
1048: */
1049: SELECT count(*) INTO l_count
1050: FROM iby_trxn_summaries_all
1051: WHERE ecbatchid = i_ecbatchid
1052: AND ecappid = i_ecappid
1053: AND payeeid = i_payeeid;
1054:

Line 1116: from iby_trxn_summaries_all s

1112: /**
1113: * Check for duplicate tangible ids
1114: */
1115: select count(*) into l_count
1116: from iby_trxn_summaries_all s
1117: where payeeId = i_payeeId
1118: and tangibleid = i_tangibleId(j)
1119: and UPPER(reqType) = UPPER(i_reqType);
1120:

Line 1143: * Create transaction records in iby_trxn_summaries_all.

1139: fnd_global.login_id, 1
1140: );
1141:
1142: /**
1143: * Create transaction records in iby_trxn_summaries_all.
1144: */
1145: INSERT INTO iby_trxn_summaries_all
1146: (
1147: org_id, ecappid, mpayeeid, payeeid,

Line 1145: INSERT INTO iby_trxn_summaries_all

1141:
1142: /**
1143: * Create transaction records in iby_trxn_summaries_all.
1144: */
1145: INSERT INTO iby_trxn_summaries_all
1146: (
1147: org_id, ecappid, mpayeeid, payeeid,
1148: bepid, bepkey, paymentMethodname,
1149: ecbatchid, trxnmid, transactionid, mtangibleId,

Line 1197: UPDATE iby_trxn_summaries_all

1193: last_update_login= fnd_global.login_id,
1194: object_version_number = 1
1195: where tangibleid = i_tangibleid(j);
1196:
1197: UPDATE iby_trxn_summaries_all
1198: set org_id = i_orgid,
1199: ecappid = i_ecappid,
1200: mpayeeid = l_mpayeeid,
1201: payeeid = i_payeeid,

Line 1252: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,

1248: -- database.
1249: -------------------------------------------------------------------------
1250:
1251: PROCEDURE createEFTVerifyTrxn(
1252: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1253: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1254: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1255: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,

Line 1253: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,

1249: -------------------------------------------------------------------------
1250:
1251: PROCEDURE createEFTVerifyTrxn(
1252: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1253: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1254: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1255: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,

Line 1254: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,

1250:
1251: PROCEDURE createEFTVerifyTrxn(
1252: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1253: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1254: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1255: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1258: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,

Line 1255: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,

1251: PROCEDURE createEFTVerifyTrxn(
1252: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1253: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1254: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1255: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1258: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1259: i_amount IN iby_trxn_summaries_all.amount%TYPE,

Line 1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,

1252: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1253: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1254: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1255: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1258: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1259: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1260: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,

Line 1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,

1253: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1254: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1255: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1258: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1259: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1260: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1261: i_status IN iby_trxn_summaries_all.status%TYPE,

Line 1258: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,

1254: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1255: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1258: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1259: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1260: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1261: i_status IN iby_trxn_summaries_all.status%TYPE,
1262: i_refinfo IN iby_tangible.refinfo%TYPE,

Line 1259: i_amount IN iby_trxn_summaries_all.amount%TYPE,

1255: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1258: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1259: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1260: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1261: i_status IN iby_trxn_summaries_all.status%TYPE,
1262: i_refinfo IN iby_tangible.refinfo%TYPE,
1263: i_memo IN iby_tangible.memo%TYPE,

Line 1260: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,

1256: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1258: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1259: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1260: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1261: i_status IN iby_trxn_summaries_all.status%TYPE,
1262: i_refinfo IN iby_tangible.refinfo%TYPE,
1263: i_memo IN iby_tangible.memo%TYPE,
1264: i_acctno IN iby_tangible.acctno%TYPE,

Line 1261: i_status IN iby_trxn_summaries_all.status%TYPE,

1257: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1258: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1259: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1260: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1261: i_status IN iby_trxn_summaries_all.status%TYPE,
1262: i_refinfo IN iby_tangible.refinfo%TYPE,
1263: i_memo IN iby_tangible.memo%TYPE,
1264: i_acctno IN iby_tangible.acctno%TYPE,
1265: i_ordermedium IN iby_tangible.order_medium%TYPE,

Line 1267: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,

1263: i_memo IN iby_tangible.memo%TYPE,
1264: i_acctno IN iby_tangible.acctno%TYPE,
1265: i_ordermedium IN iby_tangible.order_medium%TYPE,
1266: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1267: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1268: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1269: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1270: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,

Line 1268: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,

1264: i_acctno IN iby_tangible.acctno%TYPE,
1265: i_ordermedium IN iby_tangible.order_medium%TYPE,
1266: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1267: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1268: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1269: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1270: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,

Line 1269: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,

1265: i_ordermedium IN iby_tangible.order_medium%TYPE,
1266: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1267: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1268: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1269: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1270: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,

Line 1270: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,

1266: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1267: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1268: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1269: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1270: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,

Line 1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,

1267: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1268: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1269: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1270: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,

Line 1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,

1268: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1269: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1270: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,

Line 1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,

1269: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1270: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,

Line 1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,

1270: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,

Line 1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,

1271: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,

Line 1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,

1272: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,

Line 1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,

1273: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,

Line 1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,

1274: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1282: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,

Line 1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,

1275: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1282: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1283: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,

Line 1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,

1276: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1282: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1283: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1284: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,

Line 1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,

1277: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1282: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1283: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1284: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1285: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE

Line 1282: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,

1278: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1282: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1283: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1284: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1285: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1286: ) IS

Line 1283: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,

1279: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1282: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1283: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1284: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1285: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1286: ) IS
1287:

Line 1284: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,

1280: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1282: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1283: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1284: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1285: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1286: ) IS
1287:
1288: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;

Line 1285: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE

1281: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1282: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1283: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1284: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1285: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1286: ) IS
1287:
1288: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;
1289: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;

Line 1288: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;

1284: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1285: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1286: ) IS
1287:
1288: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;
1289: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;
1290:
1291: -- new parameters for eft authorizations
1292: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;

Line 1289: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;

1285: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1286: ) IS
1287:
1288: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;
1289: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;
1290:
1291: -- new parameters for eft authorizations
1292: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1293: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;

Line 1292: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;

1288: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;
1289: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;
1290:
1291: -- new parameters for eft authorizations
1292: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1293: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;
1294: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;
1295: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1296: l_mpayeeid iby_payee.mpayeeid%TYPE;

Line 1293: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;

1289: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;
1290:
1291: -- new parameters for eft authorizations
1292: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1293: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;
1294: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;
1295: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1296: l_mpayeeid iby_payee.mpayeeid%TYPE;
1297: l_trxn_exists VARCHAR2(1);

Line 1294: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;

1290:
1291: -- new parameters for eft authorizations
1292: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1293: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;
1294: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;
1295: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1296: l_mpayeeid iby_payee.mpayeeid%TYPE;
1297: l_trxn_exists VARCHAR2(1);
1298:

Line 1295: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;

1291: -- new parameters for eft authorizations
1292: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1293: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;
1294: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;
1295: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1296: l_mpayeeid iby_payee.mpayeeid%TYPE;
1297: l_trxn_exists VARCHAR2(1);
1298:
1299: l_payer_notif_flag iby_trxn_summaries_all.payer_notification_required%TYPE;

Line 1299: l_payer_notif_flag iby_trxn_summaries_all.payer_notification_required%TYPE;

1295: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1296: l_mpayeeid iby_payee.mpayeeid%TYPE;
1297: l_trxn_exists VARCHAR2(1);
1298:
1299: l_payer_notif_flag iby_trxn_summaries_all.payer_notification_required%TYPE;
1300: l_bep_type iby_bepinfo.bep_type%TYPE;
1301:
1302: CURSOR trxn_exists IS
1303: SELECT 'Y', trxnmid, mtangibleid

Line 1304: FROM iby_trxn_summaries_all s

1300: l_bep_type iby_bepinfo.bep_type%TYPE;
1301:
1302: CURSOR trxn_exists IS
1303: SELECT 'Y', trxnmid, mtangibleid
1304: FROM iby_trxn_summaries_all s
1305: WHERE payeeId = i_payeeId
1306: AND tangibleid = i_tangibleid
1307: AND UPPER(reqType) = UPPER(i_reqType)
1308: AND status <> '0'

Line 1313: CURSOR c_payer_notif_eft (i_user_fcpp_code iby_trxn_summaries_all.process_profile_code%TYPE) IS

1309: ORDER BY trxnmid desc;
1310: -- It will update the same transaction if not successfull
1311: -- of the same request type
1312:
1313: CURSOR c_payer_notif_eft (i_user_fcpp_code iby_trxn_summaries_all.process_profile_code%TYPE) IS
1314: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
1315: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp
1316: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
1317: AND up.user_eft_profile_code = i_user_fcpp_code;

Line 1330: -- this function returns the existing transactionid from the iby_trxn_summaries_all

1326:
1327: -- Get the master payeeid for the given payee
1328: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
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:

Line 1409: -- Create transaction records in iby_trxn_summaries_all.

1405: i_eftauthmethod, -- IN i_billEftAuthMethod
1406: l_mtangibleid); -- OUT io_mtangibleid
1407:
1408:
1409: -- Create transaction records in iby_trxn_summaries_all.
1410: INSERT INTO iby_trxn_summaries_all(
1411: trxnmid,
1412: org_id,
1413: ecappid,

Line 1410: INSERT INTO iby_trxn_summaries_all(

1406: l_mtangibleid); -- OUT io_mtangibleid
1407:
1408:
1409: -- Create transaction records in iby_trxn_summaries_all.
1410: INSERT INTO iby_trxn_summaries_all(
1411: trxnmid,
1412: org_id,
1413: ecappid,
1414: mpayeeid,

Line 1520: UPDATE iby_trxn_summaries_all

1516: i_memo, -- IN i_billMemo
1517: i_ordermedium, -- IN i_billOrderMedium
1518: i_eftauthmethod); -- IN i_billEftAuthMethod
1519:
1520: UPDATE iby_trxn_summaries_all
1521: SET tangibleid = i_tangibleid,
1522: org_id = i_orgid,
1523: ecappid = i_ecappid,
1524: mpayeeid = l_mpayeeid,