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_TRANSACTIONEFT_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 41: l_logical_group_reference iby_trxn_summaries_all.logical_group_reference%TYPE;

37: l_grouping_mode varchar2(40);
38: l_grp_cntr NUMBER;
39:
40: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;
41: l_logical_group_reference iby_trxn_summaries_all.logical_group_reference%TYPE;
42: l_module_name VARCHAR2(200) := G_PKG_NAME || '.createLogicalGroups';
43:
44: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
45: prev_legal_entity_id iby_trxn_summaries_all.legal_entity_id%TYPE;

Line 44: prev_org_id iby_trxn_summaries_all.org_id%TYPE;

40: l_mbatch_id IBY_BATCHES_ALL.mbatchid%TYPE;
41: l_logical_group_reference iby_trxn_summaries_all.logical_group_reference%TYPE;
42: l_module_name VARCHAR2(200) := G_PKG_NAME || '.createLogicalGroups';
43:
44: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
45: prev_legal_entity_id iby_trxn_summaries_all.legal_entity_id%TYPE;
46: prev_payeeinstrid iby_trxn_summaries_all.payeeinstrid%TYPE;
47: prev_currencynamecode iby_trxn_summaries_all.currencynamecode%TYPE;
48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;

Line 45: prev_legal_entity_id iby_trxn_summaries_all.legal_entity_id%TYPE;

41: l_logical_group_reference iby_trxn_summaries_all.logical_group_reference%TYPE;
42: l_module_name VARCHAR2(200) := G_PKG_NAME || '.createLogicalGroups';
43:
44: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
45: prev_legal_entity_id iby_trxn_summaries_all.legal_entity_id%TYPE;
46: prev_payeeinstrid iby_trxn_summaries_all.payeeinstrid%TYPE;
47: prev_currencynamecode iby_trxn_summaries_all.currencynamecode%TYPE;
48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;
49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;

Line 46: prev_payeeinstrid iby_trxn_summaries_all.payeeinstrid%TYPE;

42: l_module_name VARCHAR2(200) := G_PKG_NAME || '.createLogicalGroups';
43:
44: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
45: prev_legal_entity_id iby_trxn_summaries_all.legal_entity_id%TYPE;
46: prev_payeeinstrid iby_trxn_summaries_all.payeeinstrid%TYPE;
47: prev_currencynamecode iby_trxn_summaries_all.currencynamecode%TYPE;
48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;
49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;
50: prev_seq_type iby_trxn_summaries_all.seq_type%TYPE;

Line 47: prev_currencynamecode iby_trxn_summaries_all.currencynamecode%TYPE;

43:
44: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
45: prev_legal_entity_id iby_trxn_summaries_all.legal_entity_id%TYPE;
46: prev_payeeinstrid iby_trxn_summaries_all.payeeinstrid%TYPE;
47: prev_currencynamecode iby_trxn_summaries_all.currencynamecode%TYPE;
48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;
49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;
50: prev_seq_type iby_trxn_summaries_all.seq_type%TYPE;
51: prev_service_level iby_trxn_summaries_all.service_level%TYPE;

Line 48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;

44: prev_org_id iby_trxn_summaries_all.org_id%TYPE;
45: prev_legal_entity_id iby_trxn_summaries_all.legal_entity_id%TYPE;
46: prev_payeeinstrid iby_trxn_summaries_all.payeeinstrid%TYPE;
47: prev_currencynamecode iby_trxn_summaries_all.currencynamecode%TYPE;
48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;
49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;
50: prev_seq_type iby_trxn_summaries_all.seq_type%TYPE;
51: prev_service_level iby_trxn_summaries_all.service_level%TYPE;
52: prev_localinstr iby_trxn_summaries_all.localinstr%TYPE;

Line 49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;

45: prev_legal_entity_id iby_trxn_summaries_all.legal_entity_id%TYPE;
46: prev_payeeinstrid iby_trxn_summaries_all.payeeinstrid%TYPE;
47: prev_currencynamecode iby_trxn_summaries_all.currencynamecode%TYPE;
48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;
49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;
50: prev_seq_type iby_trxn_summaries_all.seq_type%TYPE;
51: prev_service_level iby_trxn_summaries_all.service_level%TYPE;
52: prev_localinstr iby_trxn_summaries_all.localinstr%TYPE;
53: prev_bank_charge_bearer_code iby_trxn_summaries_all.bank_charge_bearer_code%TYPE;

Line 50: prev_seq_type iby_trxn_summaries_all.seq_type%TYPE;

46: prev_payeeinstrid iby_trxn_summaries_all.payeeinstrid%TYPE;
47: prev_currencynamecode iby_trxn_summaries_all.currencynamecode%TYPE;
48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;
49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;
50: prev_seq_type iby_trxn_summaries_all.seq_type%TYPE;
51: prev_service_level iby_trxn_summaries_all.service_level%TYPE;
52: prev_localinstr iby_trxn_summaries_all.localinstr%TYPE;
53: prev_bank_charge_bearer_code iby_trxn_summaries_all.bank_charge_bearer_code%TYPE;
54:

Line 51: prev_service_level iby_trxn_summaries_all.service_level%TYPE;

47: prev_currencynamecode iby_trxn_summaries_all.currencynamecode%TYPE;
48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;
49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;
50: prev_seq_type iby_trxn_summaries_all.seq_type%TYPE;
51: prev_service_level iby_trxn_summaries_all.service_level%TYPE;
52: prev_localinstr iby_trxn_summaries_all.localinstr%TYPE;
53: prev_bank_charge_bearer_code iby_trxn_summaries_all.bank_charge_bearer_code%TYPE;
54:
55:

Line 52: prev_localinstr iby_trxn_summaries_all.localinstr%TYPE;

48: prev_settledate iby_trxn_summaries_all.settledate%TYPE;
49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;
50: prev_seq_type iby_trxn_summaries_all.seq_type%TYPE;
51: prev_service_level iby_trxn_summaries_all.service_level%TYPE;
52: prev_localinstr iby_trxn_summaries_all.localinstr%TYPE;
53: prev_bank_charge_bearer_code iby_trxn_summaries_all.bank_charge_bearer_code%TYPE;
54:
55:
56: TYPE type_trxnmid IS TABLE OF

Line 53: prev_bank_charge_bearer_code iby_trxn_summaries_all.bank_charge_bearer_code%TYPE;

49: prev_category_purpose iby_trxn_summaries_all.category_purpose%TYPE;
50: prev_seq_type iby_trxn_summaries_all.seq_type%TYPE;
51: prev_service_level iby_trxn_summaries_all.service_level%TYPE;
52: prev_localinstr iby_trxn_summaries_all.localinstr%TYPE;
53: prev_bank_charge_bearer_code iby_trxn_summaries_all.bank_charge_bearer_code%TYPE;
54:
55:
56: TYPE type_trxnmid IS TABLE OF
57: IBY_TRXN_SUMMARIES_ALL.trxnmid%TYPE

Line 57: IBY_TRXN_SUMMARIES_ALL.trxnmid%TYPE

53: prev_bank_charge_bearer_code iby_trxn_summaries_all.bank_charge_bearer_code%TYPE;
54:
55:
56: TYPE type_trxnmid IS TABLE OF
57: IBY_TRXN_SUMMARIES_ALL.trxnmid%TYPE
58: INDEX BY BINARY_INTEGER;
59: t_trxnmid type_trxnmid;
60:
61: TYPE type_org_id IS TABLE OF

Line 62: IBY_TRXN_SUMMARIES_ALL.org_id%TYPE

58: INDEX BY BINARY_INTEGER;
59: t_trxnmid type_trxnmid;
60:
61: TYPE type_org_id IS TABLE OF
62: IBY_TRXN_SUMMARIES_ALL.org_id%TYPE
63: INDEX BY BINARY_INTEGER;
64: t_org_id type_org_id;
65:
66: TYPE type_legal_entity_id IS TABLE OF

Line 67: IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE

63: INDEX BY BINARY_INTEGER;
64: t_org_id type_org_id;
65:
66: TYPE type_legal_entity_id IS TABLE OF
67: IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE
68: INDEX BY BINARY_INTEGER;
69: t_legal_entity_id type_legal_entity_id;
70:
71: TYPE type_payeeinstrid IS TABLE OF

Line 72: IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE

68: INDEX BY BINARY_INTEGER;
69: t_legal_entity_id type_legal_entity_id;
70:
71: TYPE type_payeeinstrid IS TABLE OF
72: IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE
73: INDEX BY BINARY_INTEGER;
74: t_payeeinstrid type_payeeinstrid;
75:
76: TYPE type_currencynamecode IS TABLE OF

Line 77: IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE

73: INDEX BY BINARY_INTEGER;
74: t_payeeinstrid type_payeeinstrid;
75:
76: TYPE type_currencynamecode IS TABLE OF
77: IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE
78: INDEX BY BINARY_INTEGER;
79: t_currencynamecode type_currencynamecode;
80:
81: TYPE type_settledate IS TABLE OF

Line 82: IBY_TRXN_SUMMARIES_ALL.settledate%TYPE

78: INDEX BY BINARY_INTEGER;
79: t_currencynamecode type_currencynamecode;
80:
81: TYPE type_settledate IS TABLE OF
82: IBY_TRXN_SUMMARIES_ALL.settledate%TYPE
83: INDEX BY BINARY_INTEGER;
84: t_settledate type_settledate;
85:
86: TYPE type_category_purpose IS TABLE OF

Line 87: IBY_TRXN_SUMMARIES_ALL.category_purpose%TYPE

83: INDEX BY BINARY_INTEGER;
84: t_settledate type_settledate;
85:
86: TYPE type_category_purpose IS TABLE OF
87: IBY_TRXN_SUMMARIES_ALL.category_purpose%TYPE
88: INDEX BY BINARY_INTEGER;
89: t_category_purpose type_category_purpose;
90:
91: TYPE type_seq_type IS TABLE OF

Line 92: IBY_TRXN_SUMMARIES_ALL.seq_type%TYPE

88: INDEX BY BINARY_INTEGER;
89: t_category_purpose type_category_purpose;
90:
91: TYPE type_seq_type IS TABLE OF
92: IBY_TRXN_SUMMARIES_ALL.seq_type%TYPE
93: INDEX BY BINARY_INTEGER;
94: t_seq_type type_seq_type;
95:
96: TYPE type_service_level IS TABLE OF

Line 97: IBY_TRXN_SUMMARIES_ALL.service_level%TYPE

93: INDEX BY BINARY_INTEGER;
94: t_seq_type type_seq_type;
95:
96: TYPE type_service_level IS TABLE OF
97: IBY_TRXN_SUMMARIES_ALL.service_level%TYPE
98: INDEX BY BINARY_INTEGER;
99: t_service_level type_service_level;
100:
101: TYPE type_localinstr IS TABLE OF

Line 102: IBY_TRXN_SUMMARIES_ALL.localinstr%TYPE

98: INDEX BY BINARY_INTEGER;
99: t_service_level type_service_level;
100:
101: TYPE type_localinstr IS TABLE OF
102: IBY_TRXN_SUMMARIES_ALL.localinstr%TYPE
103: INDEX BY BINARY_INTEGER;
104: t_localinstr type_localinstr;
105:
106: TYPE type_bank_charge_bearer_code IS TABLE OF

Line 107: IBY_TRXN_SUMMARIES_ALL.bank_charge_bearer_code%TYPE

103: INDEX BY BINARY_INTEGER;
104: t_localinstr type_localinstr;
105:
106: TYPE type_bank_charge_bearer_code IS TABLE OF
107: IBY_TRXN_SUMMARIES_ALL.bank_charge_bearer_code%TYPE
108: INDEX BY BINARY_INTEGER;
109: t_bank_charge_bearer_code type_bank_charge_bearer_code;
110:
111: TYPE type_logical_group_reference IS TABLE OF

Line 112: IBY_TRXN_SUMMARIES_ALL.logical_group_reference%TYPE

108: INDEX BY BINARY_INTEGER;
109: t_bank_charge_bearer_code type_bank_charge_bearer_code;
110:
111: TYPE type_logical_group_reference IS TABLE OF
112: IBY_TRXN_SUMMARIES_ALL.logical_group_reference%TYPE
113: INDEX BY BINARY_INTEGER;
114: t_logical_group_reference type_logical_group_reference;
115:
116: BEGIN

Line 164: from_clause :=' FROM IBY_TRXN_SUMMARIES_ALL';

160: prev_service_level :='';
161: prev_localinstr :='';
162: prev_bank_charge_bearer_code :='';
163:
164: from_clause :=' FROM IBY_TRXN_SUMMARIES_ALL';
165: where_clause := ' WHERE mbatchid = ' || l_mbatch_id;
166:
167: order_clause := ' ORDER BY ';
168: order_clause := order_clause || ' org_id , legal_entity_id, payeeinstrid, currencynamecode, settledate, ';

Line 286: UPDATE IBY_TRXN_SUMMARIES_ALL

282: END IF;
283: END LOOP;
284:
285: FORALL j IN t_trxnmid.FIRST .. t_trxnmid.LAST
286: UPDATE IBY_TRXN_SUMMARIES_ALL
287: SET logical_group_reference = t_logical_group_reference(j)
288: WHERE trxnmid = t_trxnmid(j);
289:
290: END IF;

Line 329: iby_trxn_summaries_all

325: COUNT(*)
326: INTO
327: numtrxns_out
328: FROM
329: iby_trxn_summaries_all
330: WHERE
331: status = oldstatus_in AND
332: payeeid = merchant_id_in AND
333: bepid = vendor_id_in AND

Line 398: IBY_TRXN_SUMMARIES_ALL

394: 0
395: ,sysdate);
396:
397: UPDATE
398: IBY_TRXN_SUMMARIES_ALL
399: SET
400: status = newstatus_in,
401: batchid = merch_batchid_in,
402: mbatchid = l_mbatchid,

Line 447: f_pmt_channel_in IN iby_trxn_summaries_all.

443: instr_type_in IN iby_batches_all.
444: instrument_type%TYPE,
445: br_disputed_flag_in IN iby_batches_all.
446: br_disputed_flag%TYPE,
447: f_pmt_channel_in IN iby_trxn_summaries_all.
448: payment_channel_code%TYPE,
449: f_curr_in IN iby_trxn_summaries_all.
450: currencynamecode%TYPE,
451: f_settle_date IN iby_trxn_summaries_all.

Line 449: f_curr_in IN iby_trxn_summaries_all.

445: br_disputed_flag_in IN iby_batches_all.
446: br_disputed_flag%TYPE,
447: f_pmt_channel_in IN iby_trxn_summaries_all.
448: payment_channel_code%TYPE,
449: f_curr_in IN iby_trxn_summaries_all.
450: currencynamecode%TYPE,
451: f_settle_date IN iby_trxn_summaries_all.
452: settledate%TYPE,
453: f_due_date IN iby_trxn_summaries_all.

Line 451: f_settle_date IN iby_trxn_summaries_all.

447: f_pmt_channel_in IN iby_trxn_summaries_all.
448: payment_channel_code%TYPE,
449: f_curr_in IN iby_trxn_summaries_all.
450: currencynamecode%TYPE,
451: f_settle_date IN iby_trxn_summaries_all.
452: settledate%TYPE,
453: f_due_date IN iby_trxn_summaries_all.
454: settlement_due_date%TYPE,
455: f_maturity_date IN iby_trxn_summaries_all.

Line 453: f_due_date IN iby_trxn_summaries_all.

449: f_curr_in IN iby_trxn_summaries_all.
450: currencynamecode%TYPE,
451: f_settle_date IN iby_trxn_summaries_all.
452: settledate%TYPE,
453: f_due_date IN iby_trxn_summaries_all.
454: settlement_due_date%TYPE,
455: f_maturity_date IN iby_trxn_summaries_all.
456: br_maturity_date%TYPE,
457: f_instr_type IN iby_trxn_summaries_all.

Line 455: f_maturity_date IN iby_trxn_summaries_all.

451: f_settle_date IN iby_trxn_summaries_all.
452: settledate%TYPE,
453: f_due_date IN iby_trxn_summaries_all.
454: settlement_due_date%TYPE,
455: f_maturity_date IN iby_trxn_summaries_all.
456: br_maturity_date%TYPE,
457: f_instr_type IN iby_trxn_summaries_all.
458: instrtype%TYPE,
459: numtrxns_out OUT NOCOPY NUMBER,

Line 457: f_instr_type IN iby_trxn_summaries_all.

453: f_due_date IN iby_trxn_summaries_all.
454: settlement_due_date%TYPE,
455: f_maturity_date IN iby_trxn_summaries_all.
456: br_maturity_date%TYPE,
457: f_instr_type IN iby_trxn_summaries_all.
458: instrtype%TYPE,
459: numtrxns_out OUT NOCOPY NUMBER,
460: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
461: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 512: iby_trxn_summaries_all

508: COUNT(*)
509: INTO
510: numtrxns_out
511: FROM
512: iby_trxn_summaries_all
513: WHERE
514: status = oldstatus_in AND
515: payeeid = merchant_id_in AND
516: bepid = vendor_id_in AND

Line 795: IBY_TRXN_SUMMARIES_ALL

791: || l_trxns_in_batch_tab(i).trxn_id);
792:
793: END IF;
794: UPDATE
795: IBY_TRXN_SUMMARIES_ALL
796: SET
797: status = newstatus_in,
798: batchid = l_trxns_in_batch_tab(i).batch_id,
799: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,

Line 862: f_pmt_channel_in IN iby_trxn_summaries_all.

858: instr_type_in IN iby_batches_all.
859: instrument_type%TYPE,
860: br_disputed_flag_in IN iby_batches_all.
861: br_disputed_flag%TYPE,
862: f_pmt_channel_in IN iby_trxn_summaries_all.
863: payment_channel_code%TYPE,
864: f_curr_in IN iby_trxn_summaries_all.
865: currencynamecode%TYPE,
866: f_settle_date IN iby_trxn_summaries_all.

Line 864: f_curr_in IN iby_trxn_summaries_all.

860: br_disputed_flag_in IN iby_batches_all.
861: br_disputed_flag%TYPE,
862: f_pmt_channel_in IN iby_trxn_summaries_all.
863: payment_channel_code%TYPE,
864: f_curr_in IN iby_trxn_summaries_all.
865: currencynamecode%TYPE,
866: f_settle_date IN iby_trxn_summaries_all.
867: settledate%TYPE,
868: f_due_date IN iby_trxn_summaries_all.

Line 866: f_settle_date IN iby_trxn_summaries_all.

862: f_pmt_channel_in IN iby_trxn_summaries_all.
863: payment_channel_code%TYPE,
864: f_curr_in IN iby_trxn_summaries_all.
865: currencynamecode%TYPE,
866: f_settle_date IN iby_trxn_summaries_all.
867: settledate%TYPE,
868: f_due_date IN iby_trxn_summaries_all.
869: settlement_due_date%TYPE,
870: f_maturity_date IN iby_trxn_summaries_all.

Line 868: f_due_date IN iby_trxn_summaries_all.

864: f_curr_in IN iby_trxn_summaries_all.
865: currencynamecode%TYPE,
866: f_settle_date IN iby_trxn_summaries_all.
867: settledate%TYPE,
868: f_due_date IN iby_trxn_summaries_all.
869: settlement_due_date%TYPE,
870: f_maturity_date IN iby_trxn_summaries_all.
871: br_maturity_date%TYPE,
872: f_instr_type IN iby_trxn_summaries_all.

Line 870: f_maturity_date IN iby_trxn_summaries_all.

866: f_settle_date IN iby_trxn_summaries_all.
867: settledate%TYPE,
868: f_due_date IN iby_trxn_summaries_all.
869: settlement_due_date%TYPE,
870: f_maturity_date IN iby_trxn_summaries_all.
871: br_maturity_date%TYPE,
872: f_instr_type IN iby_trxn_summaries_all.
873: instrtype%TYPE,
874: numtrxns_out OUT NOCOPY NUMBER,

Line 872: f_instr_type IN iby_trxn_summaries_all.

868: f_due_date IN iby_trxn_summaries_all.
869: settlement_due_date%TYPE,
870: f_maturity_date IN iby_trxn_summaries_all.
871: br_maturity_date%TYPE,
872: f_instr_type IN iby_trxn_summaries_all.
873: instrtype%TYPE,
874: numtrxns_out OUT NOCOPY NUMBER,
875: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
876: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 944: iby_trxn_summaries_all

940: COUNT(*)
941: INTO
942: numtrxns_out
943: FROM
944: iby_trxn_summaries_all
945: WHERE
946: status = oldstatus_in AND
947: payeeid = merchant_id_in AND
948: bepid = vendor_id_in AND

Line 956: ' iby_trxn_summaries_all WHERE '||

952: instrtype = 'BANKACCOUNT';
953: */
954:
955: l_cursor_stmt := ' SELECT COUNT(*) FROM '||
956: ' iby_trxn_summaries_all WHERE '||
957: ' status = '||oldstatus_in||' AND '||
958: ' payeeid = '''||merchant_id_in||''' AND '||
959: ' bepid = '||vendor_id_in||' AND '||
960: ' process_profile_code IN ('||strProfCodes||') AND '||

Line 1260: IBY_TRXN_SUMMARIES_ALL

1256: || l_trxns_in_batch_tab(i).trxn_id);
1257:
1258: END IF;
1259: UPDATE
1260: IBY_TRXN_SUMMARIES_ALL
1261: SET
1262: status = newstatus_in,
1263: batchid = l_trxns_in_batch_tab(i).batch_id,
1264: mbatchid = l_trxns_in_batch_tab(i).mbatch_id,

Line 1355: UPDATE iby_trxn_summaries_all

1351: SENTCOUNTERDAILY = SENTCOUNTERDAILY + 1
1352: WHERE batchid = merch_batchid_in
1353: AND payeeid = merchant_id_in;
1354:
1355: UPDATE iby_trxn_summaries_all
1356: SET
1357: STATUS = newstatus_in,
1358: BEPCODE = vendor_code_in,
1359: BEPMESSAGE = vendor_message_in,

Line 1412: UPDATE iby_trxn_summaries_all

1408: o_status_arr( l_index ) := c_SUCCESS;
1409:
1410: BEGIN -- Nested block begins
1411:
1412: UPDATE iby_trxn_summaries_all
1413: SET STATUS = i_status_arr( l_index ),
1414: BEPCODE = i_errCode_arr( l_index ),
1415: BEPMESSAGE = i_errMsg_arr( l_index ),
1416: LAST_UPDATE_DATE = sysdate,

Line 1447: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,

1443:
1444: END updateTrxnResultStatus;
1445:
1446: PROCEDURE insertEFTBatchTrxns(
1447: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1448: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1449: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1450: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,

Line 1448: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,

1444: END updateTrxnResultStatus;
1445:
1446: PROCEDURE insertEFTBatchTrxns(
1447: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1448: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1449: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1450: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,

Line 1449: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,

1445:
1446: PROCEDURE insertEFTBatchTrxns(
1447: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1448: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1449: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1450: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1453: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,

Line 1450: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,

1446: PROCEDURE insertEFTBatchTrxns(
1447: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1448: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1449: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1450: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1453: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1454: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,

Line 1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,

1447: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1448: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1449: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1450: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1453: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1454: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1455: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,

Line 1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,

1448: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1449: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1450: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1453: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1454: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1455: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1456: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,

Line 1453: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,

1449: i_ecbatchid IN iby_trxn_summaries_all.ecbatchid%TYPE,
1450: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1453: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1454: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1455: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1456: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1457:

Line 1454: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,

1450: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1453: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1454: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1455: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1456: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1457:
1458: i_payerinstrid IN JTF_NUMBER_TABLE,

Line 1455: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,

1451: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1453: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1454: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1455: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1456: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1457:
1458: i_payerinstrid IN JTF_NUMBER_TABLE,
1459: i_amount IN JTF_NUMBER_TABLE,

Line 1456: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,

1452: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1453: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1454: i_reqdate IN iby_trxn_summaries_all.reqdate%TYPE,
1455: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1456: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1457:
1458: i_payerinstrid IN JTF_NUMBER_TABLE,
1459: i_amount IN JTF_NUMBER_TABLE,
1460: i_payerid IN JTF_VARCHAR2_TABLE_100,

Line 1493: FROM iby_trxn_summaries_all

1489: * Check if this EC batch is already been submitted
1490: * by the EC application.
1491: */
1492: SELECT count(*) INTO l_count
1493: FROM iby_trxn_summaries_all
1494: WHERE ecbatchid = i_ecbatchid
1495: AND ecappid = i_ecappid
1496: AND payeeid = i_payeeid;
1497:

Line 1559: from iby_trxn_summaries_all s

1555: /**
1556: * Check for duplicate tangible ids
1557: */
1558: select count(*) into l_count
1559: from iby_trxn_summaries_all s
1560: where payeeId = i_payeeId
1561: and tangibleid = i_tangibleId(j)
1562: and UPPER(reqType) = UPPER(i_reqType);
1563:

Line 1586: * Create transaction records in iby_trxn_summaries_all.

1582: fnd_global.login_id, 1
1583: );
1584:
1585: /**
1586: * Create transaction records in iby_trxn_summaries_all.
1587: */
1588: INSERT INTO iby_trxn_summaries_all
1589: (
1590: org_id, ecappid, mpayeeid, payeeid,

Line 1588: INSERT INTO iby_trxn_summaries_all

1584:
1585: /**
1586: * Create transaction records in iby_trxn_summaries_all.
1587: */
1588: INSERT INTO iby_trxn_summaries_all
1589: (
1590: org_id, ecappid, mpayeeid, payeeid,
1591: bepid, bepkey, paymentMethodname,
1592: ecbatchid, trxnmid, transactionid, mtangibleId,

Line 1640: UPDATE iby_trxn_summaries_all

1636: last_update_login= fnd_global.login_id,
1637: object_version_number = 1
1638: where tangibleid = i_tangibleid(j);
1639:
1640: UPDATE iby_trxn_summaries_all
1641: set org_id = i_orgid,
1642: ecappid = i_ecappid,
1643: mpayeeid = l_mpayeeid,
1644: payeeid = i_payeeid,

Line 1695: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,

1691: -- database.
1692: -------------------------------------------------------------------------
1693:
1694: PROCEDURE createEFTVerifyTrxn(
1695: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1696: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1697: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1698: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,

Line 1696: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,

1692: -------------------------------------------------------------------------
1693:
1694: PROCEDURE createEFTVerifyTrxn(
1695: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1696: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1697: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1698: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,

Line 1697: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,

1693:
1694: PROCEDURE createEFTVerifyTrxn(
1695: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1696: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1697: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1698: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,

Line 1698: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,

1694: PROCEDURE createEFTVerifyTrxn(
1695: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1696: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1697: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1698: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,

Line 1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,

1695: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
1696: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1697: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1698: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,

Line 1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,

1696: i_reqtype IN iby_trxn_summaries_all.reqtype%TYPE,
1697: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1698: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1704: i_status IN iby_trxn_summaries_all.status%TYPE,

Line 1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,

1697: i_bepid IN iby_trxn_summaries_all.bepid%TYPE,
1698: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1704: i_status IN iby_trxn_summaries_all.status%TYPE,
1705: i_refinfo IN iby_tangible.refinfo%TYPE,

Line 1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,

1698: i_bepkey IN iby_trxn_summaries_all.bepkey%TYPE,
1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1704: i_status IN iby_trxn_summaries_all.status%TYPE,
1705: i_refinfo IN iby_tangible.refinfo%TYPE,
1706: i_memo IN iby_tangible.memo%TYPE,

Line 1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,

1699: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1704: i_status IN iby_trxn_summaries_all.status%TYPE,
1705: i_refinfo IN iby_tangible.refinfo%TYPE,
1706: i_memo IN iby_tangible.memo%TYPE,
1707: i_acctno IN iby_tangible.acctno%TYPE,

Line 1704: i_status IN iby_trxn_summaries_all.status%TYPE,

1700: i_payeeinstrid IN iby_trxn_summaries_all.payeeinstrid%TYPE,
1701: i_tangibleid IN iby_trxn_summaries_all.tangibleid%TYPE,
1702: i_amount IN iby_trxn_summaries_all.amount%TYPE,
1703: i_currency IN iby_trxn_summaries_all.currencynamecode%TYPE,
1704: i_status IN iby_trxn_summaries_all.status%TYPE,
1705: i_refinfo IN iby_tangible.refinfo%TYPE,
1706: i_memo IN iby_tangible.memo%TYPE,
1707: i_acctno IN iby_tangible.acctno%TYPE,
1708: i_ordermedium IN iby_tangible.order_medium%TYPE,

Line 1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,

1706: i_memo IN iby_tangible.memo%TYPE,
1707: i_acctno IN iby_tangible.acctno%TYPE,
1708: i_ordermedium IN iby_tangible.order_medium%TYPE,
1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,

Line 1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,

1707: i_acctno IN iby_tangible.acctno%TYPE,
1708: i_ordermedium IN iby_tangible.order_medium%TYPE,
1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,

Line 1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,

1708: i_ordermedium IN iby_tangible.order_medium%TYPE,
1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,

Line 1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,

1709: i_eftauthmethod IN iby_tangible.eft_auth_method%TYPE,
1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,

Line 1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,

1710: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,

Line 1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,

1711: i_pmtmethod IN iby_trxn_summaries_all.paymentmethodname%TYPE,
1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,

Line 1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,

1712: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,

Line 1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,

1713: i_instrtype IN iby_trxn_summaries_all.instrtype%TYPE,
1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,

Line 1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,

1714: i_instrsubtype IN iby_trxn_summaries_all.instrsubtype%TYPE,
1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1722: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,

Line 1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,

1715: i_payerinstrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1722: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,

Line 1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,

1716: i_trxndate IN iby_trxn_summaries_all.updatedate%TYPE,
1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1722: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,

Line 1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,

1717: i_trxntypeid IN iby_trxn_summaries_all.TrxntypeID%TYPE,
1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1722: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1725: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,

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

1718: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1722: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1725: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1726: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,

Line 1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,

1719: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1722: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1725: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1726: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1727: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,

Line 1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,

1720: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1722: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1725: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1726: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1727: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1728: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE

Line 1725: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,

1721: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE,
1722: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1725: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1726: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1727: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1728: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1729: ) IS

Line 1726: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,

1722: o_trxnid OUT NOCOPY iby_trxn_summaries_all.transactionid%TYPE,
1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1725: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1726: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1727: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1728: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1729: ) IS
1730:

Line 1727: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,

1723: i_orgtype IN iby_trxn_summaries_all.org_type%TYPE,
1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1725: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1726: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1727: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1728: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1729: ) IS
1730:
1731: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;

Line 1728: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE

1724: i_pmtchannelcode IN iby_trxn_summaries_all.payment_channel_code%TYPE,
1725: i_factoredflag IN iby_trxn_summaries_all.factored_flag%TYPE,
1726: i_pmtinstrassignmentId IN iby_trxn_summaries_all.payer_instr_assignment_id%TYPE,
1727: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1728: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1729: ) IS
1730:
1731: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;
1732: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;

Line 1731: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;

1727: i_process_profile_code IN iby_trxn_summaries_all.process_profile_code%TYPE,
1728: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1729: ) IS
1730:
1731: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;
1732: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;
1733:
1734: -- new parameters for eft authorizations
1735: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;

Line 1732: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;

1728: o_trxnmid OUT NOCOPY iby_trxn_summaries_all.trxnmid%TYPE
1729: ) IS
1730:
1731: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;
1732: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;
1733:
1734: -- new parameters for eft authorizations
1735: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1736: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;

Line 1735: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;

1731: l_mtangibleid iby_trxn_summaries_all.mtangibleid%TYPE;
1732: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;
1733:
1734: -- new parameters for eft authorizations
1735: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1736: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;
1737: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;
1738: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1739: l_mpayeeid iby_payee.mpayeeid%TYPE;

Line 1736: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;

1732: l_trxnmid iby_trxn_summaries_all.transactionid%TYPE;
1733:
1734: -- new parameters for eft authorizations
1735: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1736: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;
1737: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;
1738: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1739: l_mpayeeid iby_payee.mpayeeid%TYPE;
1740: l_trxn_exists VARCHAR2(1);

Line 1737: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;

1733:
1734: -- new parameters for eft authorizations
1735: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1736: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;
1737: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;
1738: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1739: l_mpayeeid iby_payee.mpayeeid%TYPE;
1740: l_trxn_exists VARCHAR2(1);
1741:

Line 1738: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;

1734: -- new parameters for eft authorizations
1735: l_debit_auth_flag iby_trxn_summaries_all.debit_auth_flag%TYPE;
1736: l_debit_auth_method iby_trxn_summaries_all.debit_auth_method%TYPE;
1737: l_debit_auth_reference iby_trxn_summaries_all.debit_auth_reference%TYPE;
1738: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1739: l_mpayeeid iby_payee.mpayeeid%TYPE;
1740: l_trxn_exists VARCHAR2(1);
1741:
1742: l_payer_notif_flag iby_trxn_summaries_all.payer_notification_required%TYPE;

Line 1742: l_payer_notif_flag iby_trxn_summaries_all.payer_notification_required%TYPE;

1738: l_payer_party_id iby_trxn_summaries_all.payer_party_id%TYPE;
1739: l_mpayeeid iby_payee.mpayeeid%TYPE;
1740: l_trxn_exists VARCHAR2(1);
1741:
1742: l_payer_notif_flag iby_trxn_summaries_all.payer_notification_required%TYPE;
1743: l_bep_type iby_bepinfo.bep_type%TYPE;
1744:
1745: CURSOR trxn_exists IS
1746: SELECT 'Y', trxnmid, mtangibleid

Line 1747: FROM iby_trxn_summaries_all s

1743: l_bep_type iby_bepinfo.bep_type%TYPE;
1744:
1745: CURSOR trxn_exists IS
1746: SELECT 'Y', trxnmid, mtangibleid
1747: FROM iby_trxn_summaries_all s
1748: WHERE payeeId = i_payeeId
1749: AND tangibleid = i_tangibleid
1750: AND UPPER(reqType) = UPPER(i_reqType)
1751: AND status <> '0'

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

1752: ORDER BY trxnmid desc;
1753: -- It will update the same transaction if not successfull
1754: -- of the same request type
1755:
1756: CURSOR c_payer_notif_eft (i_user_fcpp_code iby_trxn_summaries_all.process_profile_code%TYPE) IS
1757: SELECT DECODE(payer_notification_format, null, 'N', 'Y')
1758: FROM iby_fndcpt_user_eft_pf_b up, iby_fndcpt_sys_eft_pf_b sp
1759: WHERE up.sys_eft_profile_code = sp.sys_eft_profile_code
1760: AND up.user_eft_profile_code = i_user_fcpp_code;

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

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

Line 1852: -- Create transaction records in iby_trxn_summaries_all.

1848: i_eftauthmethod, -- IN i_billEftAuthMethod
1849: l_mtangibleid); -- OUT io_mtangibleid
1850:
1851:
1852: -- Create transaction records in iby_trxn_summaries_all.
1853: INSERT INTO iby_trxn_summaries_all(
1854: trxnmid,
1855: org_id,
1856: ecappid,

Line 1853: INSERT INTO iby_trxn_summaries_all(

1849: l_mtangibleid); -- OUT io_mtangibleid
1850:
1851:
1852: -- Create transaction records in iby_trxn_summaries_all.
1853: INSERT INTO iby_trxn_summaries_all(
1854: trxnmid,
1855: org_id,
1856: ecappid,
1857: mpayeeid,

Line 1963: UPDATE iby_trxn_summaries_all

1959: i_memo, -- IN i_billMemo
1960: i_ordermedium, -- IN i_billOrderMedium
1961: i_eftauthmethod); -- IN i_billEftAuthMethod
1962:
1963: UPDATE iby_trxn_summaries_all
1964: SET tangibleid = i_tangibleid,
1965: org_id = i_orgid,
1966: ecappid = i_ecappid,
1967: mpayeeid = l_mpayeeid,

Line 2120: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,

2116:
2117:
2118: PROCEDURE validate_open_batch
2119: (
2120: p_bep_id IN iby_trxn_summaries_all.bepid%TYPE,
2121: p_mbatch_id IN iby_batches_all.mbatchid%TYPE,
2122: p_funds_xfer_format_code IN iby_fndcpt_sys_eft_pf_b.funds_xfer_format_code%TYPE
2123: )
2124: IS

Line 2166: FROM iby_batches_all ba, iby_trxn_summaries_all ts

2162: END IF;
2163:
2164: SELECT COUNT(transactionid)
2165: INTO l_trxn_count
2166: FROM iby_batches_all ba, iby_trxn_summaries_all ts
2167: WHERE (ba.mbatchid = p_mbatch_id)
2168: AND (ba.payeeid = ts.payeeid)
2169: AND (ba.batchid = ts.batchid);
2170: --