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 367: i_authtype iby_trxn_core.authtype%type,

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

Line 468: INSERT INTO iby_trxn_core

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

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

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

Line 556: i_authtype iby_trxn_core.authtype%type,

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

Line 637: INSERT INTO iby_trxn_core

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

Line 738: FROM iby_trxn_summaries_all a, iby_trxn_core b

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