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_OFFLINEDB_PKG dependencies on IBY_TRXN_CORE

Line 33: ** in the iby_trxn_summaries_all and iby_trxn_core

29:
30: /*
31: ** Procedure Name : schedulePC
32: ** Purpose : creates an entry for scheduling the CreditCard payments
33: ** in the iby_trxn_summaries_all and iby_trxn_core
34: ** tables. Returns the transactionid created
35: ** by the system.
36: */
37: procedure schedulePC( i_ecappid iby_trxn_summaries_all.ecappid%type,

Line 52: i_authtype iby_trxn_core.authtype%type,

48: i_currency iby_trxn_summaries_all.currencynamecode%type,
49: i_trxntypeid iby_trxn_summaries_all.trxntypeid%type,
50: i_nlslang iby_trxn_summaries_all.Nlslang%type,
51: i_settledate iby_trxn_summaries_all.settledate%type,
52: i_authtype iby_trxn_core.authtype%type,
53: i_instrid iby_trxn_summaries_all.payerinstrid%type,
54: i_payerid iby_trxn_summaries_all.payerid%type,
55: i_org_id iby_trxn_summaries_all.org_id%type,
56:

Line 61: i_voiceauthflag iby_trxn_core.voiceauthflag%type,

57: i_instrtype iby_trxn_summaries_all.instrtype%type,
58: i_billeracct iby_tangible.acctno%type,
59: i_refinfo iby_tangible.refinfo%type,
60: i_memo iby_tangible.memo%type,
61: i_voiceauthflag iby_trxn_core.voiceauthflag%type,
62: i_authcode iby_trxn_core.authcode%type,
63: i_ponum iby_trxn_core.ponumber%type,
64: i_taxamt iby_trxn_core.taxamount%type,
65: i_shipfromzip iby_trxn_core.shipfromzip%type,

Line 62: i_authcode iby_trxn_core.authcode%type,

58: i_billeracct iby_tangible.acctno%type,
59: i_refinfo iby_tangible.refinfo%type,
60: i_memo iby_tangible.memo%type,
61: i_voiceauthflag iby_trxn_core.voiceauthflag%type,
62: i_authcode iby_trxn_core.authcode%type,
63: i_ponum iby_trxn_core.ponumber%type,
64: i_taxamt iby_trxn_core.taxamount%type,
65: i_shipfromzip iby_trxn_core.shipfromzip%type,
66: i_shiptozip iby_trxn_core.shiptozip%type,

Line 63: i_ponum iby_trxn_core.ponumber%type,

59: i_refinfo iby_tangible.refinfo%type,
60: i_memo iby_tangible.memo%type,
61: i_voiceauthflag iby_trxn_core.voiceauthflag%type,
62: i_authcode iby_trxn_core.authcode%type,
63: i_ponum iby_trxn_core.ponumber%type,
64: i_taxamt iby_trxn_core.taxamount%type,
65: i_shipfromzip iby_trxn_core.shipfromzip%type,
66: i_shiptozip iby_trxn_core.shiptozip%type,
67: i_OrderMedium IN iby_tangible.Order_Medium%TYPE,

Line 64: i_taxamt iby_trxn_core.taxamount%type,

60: i_memo iby_tangible.memo%type,
61: i_voiceauthflag iby_trxn_core.voiceauthflag%type,
62: i_authcode iby_trxn_core.authcode%type,
63: i_ponum iby_trxn_core.ponumber%type,
64: i_taxamt iby_trxn_core.taxamount%type,
65: i_shipfromzip iby_trxn_core.shipfromzip%type,
66: i_shiptozip iby_trxn_core.shiptozip%type,
67: i_OrderMedium IN iby_tangible.Order_Medium%TYPE,
68: i_EftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE

Line 65: i_shipfromzip iby_trxn_core.shipfromzip%type,

61: i_voiceauthflag iby_trxn_core.voiceauthflag%type,
62: i_authcode iby_trxn_core.authcode%type,
63: i_ponum iby_trxn_core.ponumber%type,
64: i_taxamt iby_trxn_core.taxamount%type,
65: i_shipfromzip iby_trxn_core.shipfromzip%type,
66: i_shiptozip iby_trxn_core.shiptozip%type,
67: i_OrderMedium IN iby_tangible.Order_Medium%TYPE,
68: i_EftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE
69: )

Line 66: i_shiptozip iby_trxn_core.shiptozip%type,

62: i_authcode iby_trxn_core.authcode%type,
63: i_ponum iby_trxn_core.ponumber%type,
64: i_taxamt iby_trxn_core.taxamount%type,
65: i_shipfromzip iby_trxn_core.shipfromzip%type,
66: i_shiptozip iby_trxn_core.shiptozip%type,
67: i_OrderMedium IN iby_tangible.Order_Medium%TYPE,
68: i_EftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE
69: )
70: IS

Line 148: INSERT INTO iby_trxn_core

144: i_nlslang, l_tmid, l_org_id, i_instrtype,
145: sysdate, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.login_id, 1,'Y');
146:
147: -- insert the authtype into core table
148: INSERT INTO iby_trxn_core
149: (TrxnMID, Authtype, PONumber, TaxAmount, ShipFromZip, ShipToZip,
150: last_update_date, last_updated_by, creation_date, created_by,
151: last_update_login, object_version_number, AuthCode, VoiceAuthFlag)
152: VALUES

Line 163: ** in the iby_trxn_summaries_all and iby_trxn_core

159:
160: /*
161: ** Procedure Name : scheduleCC
162: ** Purpose : creates an entry for scheduling the PurchaseCard payments
163: ** in the iby_trxn_summaries_all and iby_trxn_core
164: ** tables. Returns the transactionid created
165: ** by the system.
166: */
167: procedure scheduleCC( i_ecappid iby_trxn_summaries_all.ecappid%type,

Line 182: i_authtype iby_trxn_core.authtype%type,

178: i_currency iby_trxn_summaries_all.currencynamecode%type,
179: i_trxntypeid iby_trxn_summaries_all.trxntypeid%type,
180: i_nlslang iby_trxn_summaries_all.Nlslang%type,
181: i_settledate iby_trxn_summaries_all.settledate%type,
182: i_authtype iby_trxn_core.authtype%type,
183: i_instrid iby_trxn_summaries_all.payerinstrid%type,
184: i_payerid iby_trxn_summaries_all.payerid%type,
185: i_org_id iby_trxn_summaries_all.org_id%type,
186:

Line 192: i_voiceauthflag iby_trxn_core.voiceauthflag%type,

188:
189: i_billeracct iby_tangible.acctno%type,
190: i_refinfo iby_tangible.refinfo%type,
191: i_memo iby_tangible.memo%type,
192: i_voiceauthflag iby_trxn_core.voiceauthflag%type,
193: i_authcode iby_trxn_core.authcode%type,
194: i_OrderMedium IN iby_tangible.Order_Medium%TYPE,
195: i_EftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE
196: )

Line 193: i_authcode iby_trxn_core.authcode%type,

189: i_billeracct iby_tangible.acctno%type,
190: i_refinfo iby_tangible.refinfo%type,
191: i_memo iby_tangible.memo%type,
192: i_voiceauthflag iby_trxn_core.voiceauthflag%type,
193: i_authcode iby_trxn_core.authcode%type,
194: i_OrderMedium IN iby_tangible.Order_Medium%TYPE,
195: i_EftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE
196: )
197: IS

Line 369: i_authtype iby_trxn_core.authtype%type,

365: i_currency iby_trxn_summaries_all.currencynamecode%type,
366: i_trxntypeid iby_trxn_summaries_all.trxntypeid%type,
367: i_nlslang iby_trxn_summaries_all.Nlslang%type,
368: i_settledate iby_trxn_summaries_all.settledate%type,
369: i_authtype iby_trxn_core.authtype%type,
370: i_instrid iby_trxn_summaries_all.payerinstrid%type,
371: i_payerid iby_trxn_summaries_all.payerid%type,
372: recurringfreq iby_trxn_extended.RecurringFreq%type,
373: recurringexpdate iby_trxn_extended.RecurringExpDate%type,

Line 470: INSERT INTO iby_trxn_core

466: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
467: fnd_global.login_id, 1);
468:
469: -- insert the authtype into core table
470: INSERT INTO iby_trxn_core
471: (TrxnMID, Authtype,
472: last_update_date, last_updated_by, creation_date, created_by,
473: last_update_login, object_version_number)
474: VALUES

Line 536: ** in the iby_trxn_summaries_all and iby_trxn_core and extended

532:
533: /*
534: ** Procedure Name : scheduleSETOther
535: ** Purpose : creates an entry for scheduling the SET payments
536: ** in the iby_trxn_summaries_all and iby_trxn_core and extended
537: ** tables. Returns the transactionid created
538: ** by the system.
539: **
540: ** This procedure is used by follow-on transactions (other than cancel) such as

Line 558: i_authtype iby_trxn_core.authtype%type,

554: i_currency iby_trxn_summaries_all.currencynamecode%type,
555: i_trxntypeid iby_trxn_summaries_all.trxntypeid%type,
556: i_nlslang iby_trxn_summaries_all.Nlslang%type,
557: i_settledate iby_trxn_summaries_all.settledate%type,
558: i_authtype iby_trxn_core.authtype%type,
559: i_instrid iby_trxn_summaries_all.payerinstrid%type,
560: i_payerid iby_trxn_summaries_all.payerid%type,
561: splitid iby_trxn_extended.SplitId%type,
562: prevsplitid iby_trxn_extended.PrevSplitId%type,

Line 639: INSERT INTO iby_trxn_core

635: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
636: fnd_global.login_id, 1);
637:
638: -- insert the authtype into core table
639: INSERT INTO iby_trxn_core
640: (TrxnMID, Authtype,
641: last_update_date, last_updated_by, creation_date, created_by,
642: last_update_login, object_version_number)
643: VALUES

Line 741: FROM iby_trxn_summaries_all a, iby_trxn_core b

737:
738: if (i_reqtype = 'ORAPMTCAPTURE') then
739: SELECT count(*)
740: INTO l_cnt
741: FROM iby_trxn_summaries_all a, iby_trxn_core b
742: WHERE payeeId = i_payeeid
743: AND tangibleid = i_tangibleid
744: AND UPPER(reqType) = 'ORAPMTREQ'
745: AND bepid = i_bepid