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

Line 49: procedure createPayment(i_ecappid in iby_trxn_summaries_all.ecappid%type,

45: ** tangible, payment and request objects. Status of the payment
46: ** is marked as PENDING.
47: ** return the tid of the payments object.
48: */
49: procedure createPayment(i_ecappid in iby_trxn_summaries_all.ecappid%type,
50: i_payeeid in iby_trxn_summaries_all.payeeid%type,
51: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
52: i_payerid in iby_trxn_summaries_all.payerid%type,
53: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,

Line 50: i_payeeid in iby_trxn_summaries_all.payeeid%type,

46: ** is marked as PENDING.
47: ** return the tid of the payments object.
48: */
49: procedure createPayment(i_ecappid in iby_trxn_summaries_all.ecappid%type,
50: i_payeeid in iby_trxn_summaries_all.payeeid%type,
51: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
52: i_payerid in iby_trxn_summaries_all.payerid%type,
53: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
54: i_billamount in iby_trxn_summaries_all.amount%type,

Line 51: i_instrid in iby_trxn_summaries_all.payerinstrid%type,

47: ** return the tid of the payments object.
48: */
49: procedure createPayment(i_ecappid in iby_trxn_summaries_all.ecappid%type,
50: i_payeeid in iby_trxn_summaries_all.payeeid%type,
51: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
52: i_payerid in iby_trxn_summaries_all.payerid%type,
53: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
54: i_billamount in iby_trxn_summaries_all.amount%type,
55: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,

Line 52: i_payerid in iby_trxn_summaries_all.payerid%type,

48: */
49: procedure createPayment(i_ecappid in iby_trxn_summaries_all.ecappid%type,
50: i_payeeid in iby_trxn_summaries_all.payeeid%type,
51: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
52: i_payerid in iby_trxn_summaries_all.payerid%type,
53: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
54: i_billamount in iby_trxn_summaries_all.amount%type,
55: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,
56: i_billAcct in iby_tangible.acctno%type,

Line 53: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,

49: procedure createPayment(i_ecappid in iby_trxn_summaries_all.ecappid%type,
50: i_payeeid in iby_trxn_summaries_all.payeeid%type,
51: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
52: i_payerid in iby_trxn_summaries_all.payerid%type,
53: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
54: i_billamount in iby_trxn_summaries_all.amount%type,
55: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,
56: i_billAcct in iby_tangible.acctno%type,
57: i_billRefInfo in iby_tangible.refinfo%type,

Line 54: i_billamount in iby_trxn_summaries_all.amount%type,

50: i_payeeid in iby_trxn_summaries_all.payeeid%type,
51: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
52: i_payerid in iby_trxn_summaries_all.payerid%type,
53: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
54: i_billamount in iby_trxn_summaries_all.amount%type,
55: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,
56: i_billAcct in iby_tangible.acctno%type,
57: i_billRefInfo in iby_tangible.refinfo%type,
58: i_billMemo in iby_tangible.memo%type,

Line 55: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,

51: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
52: i_payerid in iby_trxn_summaries_all.payerid%type,
53: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
54: i_billamount in iby_trxn_summaries_all.amount%type,
55: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,
56: i_billAcct in iby_tangible.acctno%type,
57: i_billRefInfo in iby_tangible.refinfo%type,
58: i_billMemo in iby_tangible.memo%type,
59: i_billOrdermedium in iby_tangible.order_medium%TYPE,

Line 61: i_scheddate in iby_trxn_summaries_all.settledate%type,

57: i_billRefInfo in iby_tangible.refinfo%type,
58: i_billMemo in iby_tangible.memo%type,
59: i_billOrdermedium in iby_tangible.order_medium%TYPE,
60: i_billEftAuthMethod in iby_tangible.eft_auth_method%TYPE,
61: i_scheddate in iby_trxn_summaries_all.settledate%type,
62: i_reqtype in iby_trxn_summaries_all.reqtype%type,
63: i_reqdate in iby_trxn_summaries_all.reqdate%type,
64: i_bepid in iby_trxn_summaries_all.bepid%type,
65: i_bepkey in iby_trxn_summaries_all.bepkey%type,

Line 62: i_reqtype in iby_trxn_summaries_all.reqtype%type,

58: i_billMemo in iby_tangible.memo%type,
59: i_billOrdermedium in iby_tangible.order_medium%TYPE,
60: i_billEftAuthMethod in iby_tangible.eft_auth_method%TYPE,
61: i_scheddate in iby_trxn_summaries_all.settledate%type,
62: i_reqtype in iby_trxn_summaries_all.reqtype%type,
63: i_reqdate in iby_trxn_summaries_all.reqdate%type,
64: i_bepid in iby_trxn_summaries_all.bepid%type,
65: i_bepkey in iby_trxn_summaries_all.bepkey%type,
66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,

Line 63: i_reqdate in iby_trxn_summaries_all.reqdate%type,

59: i_billOrdermedium in iby_tangible.order_medium%TYPE,
60: i_billEftAuthMethod in iby_tangible.eft_auth_method%TYPE,
61: i_scheddate in iby_trxn_summaries_all.settledate%type,
62: i_reqtype in iby_trxn_summaries_all.reqtype%type,
63: i_reqdate in iby_trxn_summaries_all.reqdate%type,
64: i_bepid in iby_trxn_summaries_all.bepid%type,
65: i_bepkey in iby_trxn_summaries_all.bepkey%type,
66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
67: i_psreqId in iby_trxn_fi.psreqid%type,

Line 64: i_bepid in iby_trxn_summaries_all.bepid%type,

60: i_billEftAuthMethod in iby_tangible.eft_auth_method%TYPE,
61: i_scheddate in iby_trxn_summaries_all.settledate%type,
62: i_reqtype in iby_trxn_summaries_all.reqtype%type,
63: i_reqdate in iby_trxn_summaries_all.reqdate%type,
64: i_bepid in iby_trxn_summaries_all.bepid%type,
65: i_bepkey in iby_trxn_summaries_all.bepkey%type,
66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
67: i_psreqId in iby_trxn_fi.psreqid%type,
68: i_nlslang in iby_trxn_summaries_all.nlslang%type,

Line 65: i_bepkey in iby_trxn_summaries_all.bepkey%type,

61: i_scheddate in iby_trxn_summaries_all.settledate%type,
62: i_reqtype in iby_trxn_summaries_all.reqtype%type,
63: i_reqdate in iby_trxn_summaries_all.reqdate%type,
64: i_bepid in iby_trxn_summaries_all.bepid%type,
65: i_bepkey in iby_trxn_summaries_all.bepkey%type,
66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
67: i_psreqId in iby_trxn_fi.psreqid%type,
68: i_nlslang in iby_trxn_summaries_all.nlslang%type,
69: i_splitId in iby_trxn_fi.splitId%type,

Line 66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,

62: i_reqtype in iby_trxn_summaries_all.reqtype%type,
63: i_reqdate in iby_trxn_summaries_all.reqdate%type,
64: i_bepid in iby_trxn_summaries_all.bepid%type,
65: i_bepkey in iby_trxn_summaries_all.bepkey%type,
66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
67: i_psreqId in iby_trxn_fi.psreqid%type,
68: i_nlslang in iby_trxn_summaries_all.nlslang%type,
69: i_splitId in iby_trxn_fi.splitId%type,
70: i_org_id in iby_trxn_summaries_all.org_id%type,

Line 68: i_nlslang in iby_trxn_summaries_all.nlslang%type,

64: i_bepid in iby_trxn_summaries_all.bepid%type,
65: i_bepkey in iby_trxn_summaries_all.bepkey%type,
66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
67: i_psreqId in iby_trxn_fi.psreqid%type,
68: i_nlslang in iby_trxn_summaries_all.nlslang%type,
69: i_splitId in iby_trxn_fi.splitId%type,
70: i_org_id in iby_trxn_summaries_all.org_id%type,
71: i_org_type in iby_trxn_summaries_all.org_type%type,
72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,

Line 70: i_org_id in iby_trxn_summaries_all.org_id%type,

66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
67: i_psreqId in iby_trxn_fi.psreqid%type,
68: i_nlslang in iby_trxn_summaries_all.nlslang%type,
69: i_splitId in iby_trxn_fi.splitId%type,
70: i_org_id in iby_trxn_summaries_all.org_id%type,
71: i_org_type in iby_trxn_summaries_all.org_type%type,
72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,
73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,
74: i_acctsiteid in iby_trxn_summaries_all.acct_site_id%type,

Line 71: i_org_type in iby_trxn_summaries_all.org_type%type,

67: i_psreqId in iby_trxn_fi.psreqid%type,
68: i_nlslang in iby_trxn_summaries_all.nlslang%type,
69: i_splitId in iby_trxn_fi.splitId%type,
70: i_org_id in iby_trxn_summaries_all.org_id%type,
71: i_org_type in iby_trxn_summaries_all.org_type%type,
72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,
73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,
74: i_acctsiteid in iby_trxn_summaries_all.acct_site_id%type,
75: i_acctsiteuseid in iby_trxn_summaries_all.acct_site_use_id%type,

Line 72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,

68: i_nlslang in iby_trxn_summaries_all.nlslang%type,
69: i_splitId in iby_trxn_fi.splitId%type,
70: i_org_id in iby_trxn_summaries_all.org_id%type,
71: i_org_type in iby_trxn_summaries_all.org_type%type,
72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,
73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,
74: i_acctsiteid in iby_trxn_summaries_all.acct_site_id%type,
75: i_acctsiteuseid in iby_trxn_summaries_all.acct_site_use_id%type,
76: i_profilecode in iby_trxn_summaries_all.process_profile_code%type,

Line 73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,

69: i_splitId in iby_trxn_fi.splitId%type,
70: i_org_id in iby_trxn_summaries_all.org_id%type,
71: i_org_type in iby_trxn_summaries_all.org_type%type,
72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,
73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,
74: i_acctsiteid in iby_trxn_summaries_all.acct_site_id%type,
75: i_acctsiteuseid in iby_trxn_summaries_all.acct_site_use_id%type,
76: i_profilecode in iby_trxn_summaries_all.process_profile_code%type,
77: io_tid in out nocopy iby_trxn_summaries_all.transactionid%type)

Line 74: i_acctsiteid in iby_trxn_summaries_all.acct_site_id%type,

70: i_org_id in iby_trxn_summaries_all.org_id%type,
71: i_org_type in iby_trxn_summaries_all.org_type%type,
72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,
73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,
74: i_acctsiteid in iby_trxn_summaries_all.acct_site_id%type,
75: i_acctsiteuseid in iby_trxn_summaries_all.acct_site_use_id%type,
76: i_profilecode in iby_trxn_summaries_all.process_profile_code%type,
77: io_tid in out nocopy iby_trxn_summaries_all.transactionid%type)
78: is

Line 75: i_acctsiteuseid in iby_trxn_summaries_all.acct_site_use_id%type,

71: i_org_type in iby_trxn_summaries_all.org_type%type,
72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,
73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,
74: i_acctsiteid in iby_trxn_summaries_all.acct_site_id%type,
75: i_acctsiteuseid in iby_trxn_summaries_all.acct_site_use_id%type,
76: i_profilecode in iby_trxn_summaries_all.process_profile_code%type,
77: io_tid in out nocopy iby_trxn_summaries_all.transactionid%type)
78: is
79:

Line 76: i_profilecode in iby_trxn_summaries_all.process_profile_code%type,

72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,
73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,
74: i_acctsiteid in iby_trxn_summaries_all.acct_site_id%type,
75: i_acctsiteuseid in iby_trxn_summaries_all.acct_site_use_id%type,
76: i_profilecode in iby_trxn_summaries_all.process_profile_code%type,
77: io_tid in out nocopy iby_trxn_summaries_all.transactionid%type)
78: is
79:
80: l_mtangibleid iby_tangible.mtangibleid%type;

Line 77: io_tid in out nocopy iby_trxn_summaries_all.transactionid%type)

73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,
74: i_acctsiteid in iby_trxn_summaries_all.acct_site_id%type,
75: i_acctsiteuseid in iby_trxn_summaries_all.acct_site_use_id%type,
76: i_profilecode in iby_trxn_summaries_all.process_profile_code%type,
77: io_tid in out nocopy iby_trxn_summaries_all.transactionid%type)
78: is
79:
80: l_mtangibleid iby_tangible.mtangibleid%type;
81: l_tmid iby_trxn_summaries_all.trxnmid%type;

Line 81: l_tmid iby_trxn_summaries_all.trxnmid%type;

77: io_tid in out nocopy iby_trxn_summaries_all.transactionid%type)
78: is
79:
80: l_mtangibleid iby_tangible.mtangibleid%type;
81: l_tmid iby_trxn_summaries_all.trxnmid%type;
82: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
83: l_tid iby_trxn_summaries_all.transactionId%type;
84: l_mpayeeid iby_payee.mpayeeid%type;
85: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;

Line 82: l_old_tmid iby_trxn_summaries_all.trxnmid%type;

78: is
79:
80: l_mtangibleid iby_tangible.mtangibleid%type;
81: l_tmid iby_trxn_summaries_all.trxnmid%type;
82: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
83: l_tid iby_trxn_summaries_all.transactionId%type;
84: l_mpayeeid iby_payee.mpayeeid%type;
85: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
86: l_reference_amount iby_trxn_summaries_all.amount%type;

Line 83: l_tid iby_trxn_summaries_all.transactionId%type;

79:
80: l_mtangibleid iby_tangible.mtangibleid%type;
81: l_tmid iby_trxn_summaries_all.trxnmid%type;
82: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
83: l_tid iby_trxn_summaries_all.transactionId%type;
84: l_mpayeeid iby_payee.mpayeeid%type;
85: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
86: l_reference_amount iby_trxn_summaries_all.amount%type;
87: l_status iby_trxn_summaries_all.status%type;

Line 85: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;

81: l_tmid iby_trxn_summaries_all.trxnmid%type;
82: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
83: l_tid iby_trxn_summaries_all.transactionId%type;
84: l_mpayeeid iby_payee.mpayeeid%type;
85: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
86: l_reference_amount iby_trxn_summaries_all.amount%type;
87: l_status iby_trxn_summaries_all.status%type;
88: l_beptype iby_bepinfo.bep_type%type;
89: l_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE;

Line 86: l_reference_amount iby_trxn_summaries_all.amount%type;

82: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
83: l_tid iby_trxn_summaries_all.transactionId%type;
84: l_mpayeeid iby_payee.mpayeeid%type;
85: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
86: l_reference_amount iby_trxn_summaries_all.amount%type;
87: l_status iby_trxn_summaries_all.status%type;
88: l_beptype iby_bepinfo.bep_type%type;
89: l_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE;
90: l_reqtype iby_trxn_summaries_all.reqtype%TYPE;

Line 87: l_status iby_trxn_summaries_all.status%type;

83: l_tid iby_trxn_summaries_all.transactionId%type;
84: l_mpayeeid iby_payee.mpayeeid%type;
85: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
86: l_reference_amount iby_trxn_summaries_all.amount%type;
87: l_status iby_trxn_summaries_all.status%type;
88: l_beptype iby_bepinfo.bep_type%type;
89: l_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE;
90: l_reqtype iby_trxn_summaries_all.reqtype%TYPE;
91:

Line 89: l_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE;

85: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
86: l_reference_amount iby_trxn_summaries_all.amount%type;
87: l_status iby_trxn_summaries_all.status%type;
88: l_beptype iby_bepinfo.bep_type%type;
89: l_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE;
90: l_reqtype iby_trxn_summaries_all.reqtype%TYPE;
91:
92: l_settle_cust_ref iby_trxn_summaries_all.
93: settlement_customer_reference%TYPE;

Line 90: l_reqtype iby_trxn_summaries_all.reqtype%TYPE;

86: l_reference_amount iby_trxn_summaries_all.amount%type;
87: l_status iby_trxn_summaries_all.status%type;
88: l_beptype iby_bepinfo.bep_type%type;
89: l_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE;
90: l_reqtype iby_trxn_summaries_all.reqtype%TYPE;
91:
92: l_settle_cust_ref iby_trxn_summaries_all.
93: settlement_customer_reference%TYPE;
94: l_first_trx_flag iby_trxn_summaries_all.first_trxn_flag%TYPE;

Line 92: l_settle_cust_ref iby_trxn_summaries_all.

88: l_beptype iby_bepinfo.bep_type%type;
89: l_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE;
90: l_reqtype iby_trxn_summaries_all.reqtype%TYPE;
91:
92: l_settle_cust_ref iby_trxn_summaries_all.
93: settlement_customer_reference%TYPE;
94: l_first_trx_flag iby_trxn_summaries_all.first_trxn_flag%TYPE;
95:
96: l_cnt NUMBER := 0;

Line 94: l_first_trx_flag iby_trxn_summaries_all.first_trxn_flag%TYPE;

90: l_reqtype iby_trxn_summaries_all.reqtype%TYPE;
91:
92: l_settle_cust_ref iby_trxn_summaries_all.
93: settlement_customer_reference%TYPE;
94: l_first_trx_flag iby_trxn_summaries_all.first_trxn_flag%TYPE;
95:
96: l_cnt NUMBER := 0;
97:
98: cursor c_tmid is

Line 102: cursor c_reference(ci_tangible_id iby_trxn_summaries_all.tangibleid%type) is

98: cursor c_tmid is
99: select iby_trxnsumm_mid_s.nextval
100: from dual;
101:
102: cursor c_reference(ci_tangible_id iby_trxn_summaries_all.tangibleid%type) is
103: select proc_reference_code, amount
104: from iby_trxn_summaries_all
105: where tangibleid= ci_tangible_id
106: --and trxntypeid=20

Line 104: from iby_trxn_summaries_all

100: from dual;
101:
102: cursor c_reference(ci_tangible_id iby_trxn_summaries_all.tangibleid%type) is
103: select proc_reference_code, amount
104: from iby_trxn_summaries_all
105: where tangibleid= ci_tangible_id
106: --and trxntypeid=20
107: --and status=0
108: order by trxnmid desc;

Line 112: from iby_trxn_summaries_all

108: order by trxnmid desc;
109:
110: cursor c_settle_exists is
111: select trxnmid, mtangibleid
112: from iby_trxn_summaries_all
113: where tangibleid=i_tangibleid
114: and payeeid=i_payeeid
115: and bepid=i_bepid
116: and bepkey=i_bepkey

Line 265: IBY_TRXN_SUMMARIES_ALL trxn

261: COUNT(*)
262: INTO
263: l_cnt
264: FROM
265: IBY_TRXN_SUMMARIES_ALL trxn
266: WHERE
267: trxn.mpayeeid = l_mpayeeid AND
268: trxn.instrtype = 'BANKACCOUNT' AND
269: trxn.instrsubtype = 'ACH' AND

Line 326: insert into iby_trxn_summaries_all

322: i_billCurDef, i_billAcct,i_billRefInfo,
323: i_billMemo, i_billOrderMedium, i_billEftAuthMethod, l_mtangibleid);
324:
325:
326: insert into iby_trxn_summaries_all
327: ( trxnMId, transactionId, tangibleid,
328: mpayeeid, payeeid, payeeinstrid,
329: bepid, bepkey, ecappid, org_id, org_type,
330: paymentMethodname, payerid, payerinstrid,

Line 388: UPDATE iby_trxn_summaries_all

384: i_billOrderMedium, -- IN i_billOrderMedium
385: i_billEftAuthMethod); -- IN i_billEftAuthMethod
386:
387:
388: UPDATE iby_trxn_summaries_all
389: SET
390: org_id = i_org_id,
391: ecappid = i_ecappid,
392: payeeid = i_payeeid,

Line 426: Function requestExists(i_tid iby_trxn_summaries_all.transactionId%type,

422: commit;
423: end createPayment;
424:
425:
426: Function requestExists(i_tid iby_trxn_summaries_all.transactionId%type,
427: i_reqtype iby_trxn_summaries_all.reqtype%type)
428: return boolean
429: is
430: l_cnt int;

Line 427: i_reqtype iby_trxn_summaries_all.reqtype%type)

423: end createPayment;
424:
425:
426: Function requestExists(i_tid iby_trxn_summaries_all.transactionId%type,
427: i_reqtype iby_trxn_summaries_all.reqtype%type)
428: return boolean
429: is
430: l_cnt int;
431: begin

Line 438: from iby_trxn_summaries_all s

434: ** payeeid. If count is more than 0, it means, request already exists
435: ** otherwise does not exist.
436: */
437: select count(*) into l_cnt
438: from iby_trxn_summaries_all s
439: where transactionId = i_tid
440: and reqType = i_reqType;
441:
442: -- and status = 0

Line 452: Function requestExists(i_payeeid iby_trxn_summaries_all.payeeid%type,

448: end if;
449: end requestExists;
450:
451:
452: Function requestExists(i_payeeid iby_trxn_summaries_all.payeeid%type,
453: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
454: i_splitId in iby_trxn_fi.splitId%type,
455: i_reqtype iby_trxn_summaries_all.reqtype%type)
456: return boolean

Line 453: i_tangibleid iby_trxn_summaries_all.tangibleid%type,

449: end requestExists;
450:
451:
452: Function requestExists(i_payeeid iby_trxn_summaries_all.payeeid%type,
453: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
454: i_splitId in iby_trxn_fi.splitId%type,
455: i_reqtype iby_trxn_summaries_all.reqtype%type)
456: return boolean
457: is

Line 455: i_reqtype iby_trxn_summaries_all.reqtype%type)

451:
452: Function requestExists(i_payeeid iby_trxn_summaries_all.payeeid%type,
453: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
454: i_splitId in iby_trxn_fi.splitId%type,
455: i_reqtype iby_trxn_summaries_all.reqtype%type)
456: return boolean
457: is
458: l_cnt int;
459: begin

Line 466: from iby_trxn_summaries_all s

462: ** payeeid. If count is more than 0, it means, request already exists
463: ** otherwise does not exist.
464: */
465: select count(*) into l_cnt
466: from iby_trxn_summaries_all s
467: where payeeId = i_payeeId
468: and tangibleid = i_tangibleId
469: and UPPER(reqType) = UPPER(i_reqType)
470: and trxntypeid not in (20);

Line 490: function canModifyorCancel(i_tid in iby_trxn_summaries_all.transactionId%type)

486: ** can be modified or not.
487: ** In Params: i_tid, transaction id.
488: ** out Params: boolean , true if it can be modified otherwise false.
489: */
490: function canModifyorCancel(i_tid in iby_trxn_summaries_all.transactionId%type)
491: return boolean
492: is
493: l_cnt int;
494: begin

Line 496: from iby_trxn_summaries_all s

492: is
493: l_cnt int;
494: begin
495: select count(*) into l_cnt
496: from iby_trxn_summaries_all s
497: where transactionId = i_tid
498: and (( (reqtype = 'ORAPMTREQ' or reqtype = 'ORAPMTCREDIT') and (status <> -99 and status <> 100)) or
499: (reqtype = 'ORAPMTCANC'));
500: if ( l_cnt = 0 ) then

Line 519: i_payeeid in iby_trxn_summaries_all.payeeid%type,

515: ** tangible. Modify the payment object that payment id matched,
516: ** then create the request object.
517: */
518: procedure modifyPayment(i_ecappid in iby_ecapp.ecappid%type,
519: i_payeeid in iby_trxn_summaries_all.payeeid%type,
520: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
521: i_payerid in iby_trxn_summaries_all.payerid%type,
522: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
523: i_billamount in iby_trxn_summaries_all.amount%type,

Line 520: i_instrid in iby_trxn_summaries_all.payerinstrid%type,

516: ** then create the request object.
517: */
518: procedure modifyPayment(i_ecappid in iby_ecapp.ecappid%type,
519: i_payeeid in iby_trxn_summaries_all.payeeid%type,
520: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
521: i_payerid in iby_trxn_summaries_all.payerid%type,
522: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
523: i_billamount in iby_trxn_summaries_all.amount%type,
524: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,

Line 521: i_payerid in iby_trxn_summaries_all.payerid%type,

517: */
518: procedure modifyPayment(i_ecappid in iby_ecapp.ecappid%type,
519: i_payeeid in iby_trxn_summaries_all.payeeid%type,
520: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
521: i_payerid in iby_trxn_summaries_all.payerid%type,
522: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
523: i_billamount in iby_trxn_summaries_all.amount%type,
524: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,
525: i_billAcct in iby_tangible.acctno%type,

Line 522: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,

518: procedure modifyPayment(i_ecappid in iby_ecapp.ecappid%type,
519: i_payeeid in iby_trxn_summaries_all.payeeid%type,
520: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
521: i_payerid in iby_trxn_summaries_all.payerid%type,
522: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
523: i_billamount in iby_trxn_summaries_all.amount%type,
524: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,
525: i_billAcct in iby_tangible.acctno%type,
526: i_billRefInfo in iby_tangible.refinfo%type,

Line 523: i_billamount in iby_trxn_summaries_all.amount%type,

519: i_payeeid in iby_trxn_summaries_all.payeeid%type,
520: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
521: i_payerid in iby_trxn_summaries_all.payerid%type,
522: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
523: i_billamount in iby_trxn_summaries_all.amount%type,
524: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,
525: i_billAcct in iby_tangible.acctno%type,
526: i_billRefInfo in iby_tangible.refinfo%type,
527: i_billMemo in iby_tangible.memo%type,

Line 524: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,

520: i_instrid in iby_trxn_summaries_all.payerinstrid%type,
521: i_payerid in iby_trxn_summaries_all.payerid%type,
522: i_tangibleid in iby_trxn_summaries_all.tangibleid%type,
523: i_billamount in iby_trxn_summaries_all.amount%type,
524: i_billcurDef in iby_trxn_summaries_all.currencynamecode%type,
525: i_billAcct in iby_tangible.acctno%type,
526: i_billRefInfo in iby_tangible.refinfo%type,
527: i_billMemo in iby_tangible.memo%type,
528: i_billOrdermedium in iby_tangible.order_medium%TYPE,

Line 530: i_scheddate in iby_trxn_summaries_all.settledate%type,

526: i_billRefInfo in iby_tangible.refinfo%type,
527: i_billMemo in iby_tangible.memo%type,
528: i_billOrdermedium in iby_tangible.order_medium%TYPE,
529: i_billEftAuthMethod in iby_tangible.eft_auth_method%TYPE,
530: i_scheddate in iby_trxn_summaries_all.settledate%type,
531: i_reqtype in iby_trxn_summaries_all.reqtype%type,
532: i_reqdate in iby_trxn_summaries_all.reqdate%type,
533: i_bepid in iby_trxn_summaries_all.bepid%type,
534: i_bepkey in iby_trxn_summaries_all.bepkey%type,

Line 531: i_reqtype in iby_trxn_summaries_all.reqtype%type,

527: i_billMemo in iby_tangible.memo%type,
528: i_billOrdermedium in iby_tangible.order_medium%TYPE,
529: i_billEftAuthMethod in iby_tangible.eft_auth_method%TYPE,
530: i_scheddate in iby_trxn_summaries_all.settledate%type,
531: i_reqtype in iby_trxn_summaries_all.reqtype%type,
532: i_reqdate in iby_trxn_summaries_all.reqdate%type,
533: i_bepid in iby_trxn_summaries_all.bepid%type,
534: i_bepkey in iby_trxn_summaries_all.bepkey%type,
535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,

Line 532: i_reqdate in iby_trxn_summaries_all.reqdate%type,

528: i_billOrdermedium in iby_tangible.order_medium%TYPE,
529: i_billEftAuthMethod in iby_tangible.eft_auth_method%TYPE,
530: i_scheddate in iby_trxn_summaries_all.settledate%type,
531: i_reqtype in iby_trxn_summaries_all.reqtype%type,
532: i_reqdate in iby_trxn_summaries_all.reqdate%type,
533: i_bepid in iby_trxn_summaries_all.bepid%type,
534: i_bepkey in iby_trxn_summaries_all.bepkey%type,
535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
536: i_psreqId in iby_trxn_fi.psreqid%type,

Line 533: i_bepid in iby_trxn_summaries_all.bepid%type,

529: i_billEftAuthMethod in iby_tangible.eft_auth_method%TYPE,
530: i_scheddate in iby_trxn_summaries_all.settledate%type,
531: i_reqtype in iby_trxn_summaries_all.reqtype%type,
532: i_reqdate in iby_trxn_summaries_all.reqdate%type,
533: i_bepid in iby_trxn_summaries_all.bepid%type,
534: i_bepkey in iby_trxn_summaries_all.bepkey%type,
535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
536: i_psreqId in iby_trxn_fi.psreqid%type,
537: i_nlslang in iby_trxn_summaries_all.nlslang%type,

Line 534: i_bepkey in iby_trxn_summaries_all.bepkey%type,

530: i_scheddate in iby_trxn_summaries_all.settledate%type,
531: i_reqtype in iby_trxn_summaries_all.reqtype%type,
532: i_reqdate in iby_trxn_summaries_all.reqdate%type,
533: i_bepid in iby_trxn_summaries_all.bepid%type,
534: i_bepkey in iby_trxn_summaries_all.bepkey%type,
535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
536: i_psreqId in iby_trxn_fi.psreqid%type,
537: i_nlslang in iby_trxn_summaries_all.nlslang%type,
538: i_tid in iby_trxn_summaries_all.transactionid%type,

Line 535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,

531: i_reqtype in iby_trxn_summaries_all.reqtype%type,
532: i_reqdate in iby_trxn_summaries_all.reqdate%type,
533: i_bepid in iby_trxn_summaries_all.bepid%type,
534: i_bepkey in iby_trxn_summaries_all.bepkey%type,
535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
536: i_psreqId in iby_trxn_fi.psreqid%type,
537: i_nlslang in iby_trxn_summaries_all.nlslang%type,
538: i_tid in iby_trxn_summaries_all.transactionid%type,
539: i_org_id in iby_trxn_summaries_all.org_id%type)

Line 537: i_nlslang in iby_trxn_summaries_all.nlslang%type,

533: i_bepid in iby_trxn_summaries_all.bepid%type,
534: i_bepkey in iby_trxn_summaries_all.bepkey%type,
535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
536: i_psreqId in iby_trxn_fi.psreqid%type,
537: i_nlslang in iby_trxn_summaries_all.nlslang%type,
538: i_tid in iby_trxn_summaries_all.transactionid%type,
539: i_org_id in iby_trxn_summaries_all.org_id%type)
540: is
541: l_mtangibleid iby_tangible.mtangibleid%type;

Line 538: i_tid in iby_trxn_summaries_all.transactionid%type,

534: i_bepkey in iby_trxn_summaries_all.bepkey%type,
535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
536: i_psreqId in iby_trxn_fi.psreqid%type,
537: i_nlslang in iby_trxn_summaries_all.nlslang%type,
538: i_tid in iby_trxn_summaries_all.transactionid%type,
539: i_org_id in iby_trxn_summaries_all.org_id%type)
540: is
541: l_mtangibleid iby_tangible.mtangibleid%type;
542: l_tmid iby_trxn_summaries_all.trxnmid%type;

Line 539: i_org_id in iby_trxn_summaries_all.org_id%type)

535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
536: i_psreqId in iby_trxn_fi.psreqid%type,
537: i_nlslang in iby_trxn_summaries_all.nlslang%type,
538: i_tid in iby_trxn_summaries_all.transactionid%type,
539: i_org_id in iby_trxn_summaries_all.org_id%type)
540: is
541: l_mtangibleid iby_tangible.mtangibleid%type;
542: l_tmid iby_trxn_summaries_all.trxnmid%type;
543: l_tangibleid iby_trxn_summaries_all.tangibleid%type;

Line 542: l_tmid iby_trxn_summaries_all.trxnmid%type;

538: i_tid in iby_trxn_summaries_all.transactionid%type,
539: i_org_id in iby_trxn_summaries_all.org_id%type)
540: is
541: l_mtangibleid iby_tangible.mtangibleid%type;
542: l_tmid iby_trxn_summaries_all.trxnmid%type;
543: l_tangibleid iby_trxn_summaries_all.tangibleid%type;
544: l_reqtype iby_trxn_summaries_all.reqtype%type;
545:
546: l_mpayeeid iby_payee.mpayeeid%type;

Line 543: l_tangibleid iby_trxn_summaries_all.tangibleid%type;

539: i_org_id in iby_trxn_summaries_all.org_id%type)
540: is
541: l_mtangibleid iby_tangible.mtangibleid%type;
542: l_tmid iby_trxn_summaries_all.trxnmid%type;
543: l_tangibleid iby_trxn_summaries_all.tangibleid%type;
544: l_reqtype iby_trxn_summaries_all.reqtype%type;
545:
546: l_mpayeeid iby_payee.mpayeeid%type;
547:

Line 544: l_reqtype iby_trxn_summaries_all.reqtype%type;

540: is
541: l_mtangibleid iby_tangible.mtangibleid%type;
542: l_tmid iby_trxn_summaries_all.trxnmid%type;
543: l_tangibleid iby_trxn_summaries_all.tangibleid%type;
544: l_reqtype iby_trxn_summaries_all.reqtype%type;
545:
546: l_mpayeeid iby_payee.mpayeeid%type;
547:
548: cursor c_tmid is

Line 552: cursor c_mtangibleid(ci_tid in iby_trxn_summaries_all.transactionid%type)

548: cursor c_tmid is
549: select iby_trxnsumm_mid_s.nextval
550: from dual;
551:
552: cursor c_mtangibleid(ci_tid in iby_trxn_summaries_all.transactionid%type)
553: is
554: select mtangibleid , tangibleid
555: from iby_trxn_summaries_all
556: where transactionId = ci_tid

Line 555: from iby_trxn_summaries_all

551:
552: cursor c_mtangibleid(ci_tid in iby_trxn_summaries_all.transactionid%type)
553: is
554: select mtangibleid , tangibleid
555: from iby_trxn_summaries_all
556: where transactionId = ci_tid
557: group by mtangibleid , tangibleid;
558: l_splitId iby_trxn_fi.splitId%type;
559: begin

Line 606: select reqtype into l_reqtype from iby_trxn_summaries_all

602:
603: /*
604: ** get the reqtype
605: */
606: select reqtype into l_reqtype from iby_trxn_summaries_all
607: WHERE transactionId = i_tid and status = 100
608: and (reqtype = 'ORAPMTREQ' or reqtype = 'ORAPMTCREDIT');
609:
610:

Line 614: update iby_trxn_summaries_all

610:
611: /*
612: ** update the transactions table with the new data.
613: */
614: update iby_trxn_summaries_all
615: set status = -99,
616: last_update_date = sysdate,
617: updatedate = sysdate,
618: last_updated_by = fnd_global.user_id,

Line 631: from iby_trxn_summaries_all

627:
628: select splitId into l_splitId
629: from iby_trxn_fi
630: where trxnmid in ( select trxnmid
631: from iby_trxn_summaries_all
632: where transactionId = i_tid)
633: and rownum < 2;
634: /*
635: ** Make entry in the payments table.

Line 638: insert into iby_trxn_summaries_all

634: /*
635: ** Make entry in the payments table.
636: */
637: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
638: insert into iby_trxn_summaries_all
639: ( trxnMId, transactionId, tangibleid,
640: mpayeeid, payeeid, bepid, bepkey, ecappid,
641: org_id, paymentMethodname,
642: payerid, payerinstrid, amount,

Line 692: procedure deletePayment( i_tid in iby_trxn_summaries_all.transactionId%type )

688: ** Purpose: Marks the payment whose id matches the tid passed as
689: ** 'CANCELLED'.
690: */
691: -- procedure deletePayment(i_ecappid in iby_ecapp.ecappid%type,
692: procedure deletePayment( i_tid in iby_trxn_summaries_all.transactionId%type )
693: is
694: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
695: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
696: l_tid iby_trxn_summaries_all.transactionId%type;

Line 694: l_old_tmid iby_trxn_summaries_all.trxnmid%type;

690: */
691: -- procedure deletePayment(i_ecappid in iby_ecapp.ecappid%type,
692: procedure deletePayment( i_tid in iby_trxn_summaries_all.transactionId%type )
693: is
694: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
695: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
696: l_tid iby_trxn_summaries_all.transactionId%type;
697: l_status iby_trxn_summaries_all.status%type;
698:

Line 695: l_new_tmid iby_trxn_summaries_all.trxnmid%type;

691: -- procedure deletePayment(i_ecappid in iby_ecapp.ecappid%type,
692: procedure deletePayment( i_tid in iby_trxn_summaries_all.transactionId%type )
693: is
694: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
695: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
696: l_tid iby_trxn_summaries_all.transactionId%type;
697: l_status iby_trxn_summaries_all.status%type;
698:
699: cursor c_tmid is

Line 696: l_tid iby_trxn_summaries_all.transactionId%type;

692: procedure deletePayment( i_tid in iby_trxn_summaries_all.transactionId%type )
693: is
694: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
695: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
696: l_tid iby_trxn_summaries_all.transactionId%type;
697: l_status iby_trxn_summaries_all.status%type;
698:
699: cursor c_tmid is
700: select iby_trxnsumm_mid_s.nextval

Line 697: l_status iby_trxn_summaries_all.status%type;

693: is
694: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
695: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
696: l_tid iby_trxn_summaries_all.transactionId%type;
697: l_status iby_trxn_summaries_all.status%type;
698:
699: cursor c_tmid is
700: select iby_trxnsumm_mid_s.nextval
701: from dual;

Line 703: cursor getLatestTMID(ci_tid in iby_trxn_summaries_all.transactionId%type) is

699: cursor c_tmid is
700: select iby_trxnsumm_mid_s.nextval
701: from dual;
702:
703: cursor getLatestTMID(ci_tid in iby_trxn_summaries_all.transactionId%type) is
704: select trxnmid , status
705: from iby_trxn_summaries_all s
706: where transactionid=ci_tid
707: and status = 100

Line 705: from iby_trxn_summaries_all s

701: from dual;
702:
703: cursor getLatestTMID(ci_tid in iby_trxn_summaries_all.transactionId%type) is
704: select trxnmid , status
705: from iby_trxn_summaries_all s
706: where transactionid=ci_tid
707: and status = 100
708: -- // status for pending.
709: and (reqtype = 'ORAPMTREQ' or reqtype = 'ORAPMTCREDIT');

Line 748: update iby_trxn_summaries_all

744: close c_tmid;
745: /*
746: ** update the transactions table with the new data.
747: */
748: update iby_trxn_summaries_all
749: set status = -99,
750: last_update_date = sysdate,
751: updatedate = sysdate,
752: last_updated_by = fnd_global.user_id,

Line 762: insert into iby_trxn_summaries_all

758: /*
759: ** Insert record, with values that of latest record and increment the
760: ** tid value by 1.
761: */
762: insert into iby_trxn_summaries_all
763: ( trxnMId, transactionId, tangibleid,
764: mpayeeid, payeeid, bepid, ecappid,
765: org_id, paymentMethodname,
766: payerid, payerinstrid,

Line 784: from iby_trxn_summaries_all

780: mtangibleId, nlslang, 'BANKACCOUNT',
781: sysdate, sysdate, fnd_global.user_id,
782: sysdate, fnd_global.user_id,
783: fnd_global.login_id, 1,'Y'
784: from iby_trxn_summaries_all
785: where trxnmid = l_old_tmid;
786:
787:
788: insert into iby_trxn_fi

Line 817: procedure setTrxnStatus(i_tmid in iby_trxn_summaries_all.trxnmid%type,

813: * Purpose: Modify the status of the transaction
814: *
815: */
816:
817: procedure setTrxnStatus(i_tmid in iby_trxn_summaries_all.trxnmid%type,
818: i_status in iby_trxn_summaries_all.status%type)
819: is
820:
821: begin

Line 818: i_status in iby_trxn_summaries_all.status%type)

814: *
815: */
816:
817: procedure setTrxnStatus(i_tmid in iby_trxn_summaries_all.trxnmid%type,
818: i_status in iby_trxn_summaries_all.status%type)
819: is
820:
821: begin
822:

Line 823: update iby_trxn_summaries_all

819: is
820:
821: begin
822:
823: update iby_trxn_summaries_all
824: set status=i_status
825: where trxnmid=i_tmid;
826:
827: commit;

Line 842: i_tid in iby_trxn_summaries_all.transactionId%type,

838: ** 'ORAPMTRETURN'.
839: */
840:
841: procedure createReturnPayment(
842: i_tid in iby_trxn_summaries_all.transactionId%type,
843: i_currencycode in iby_trxn_summaries_all.currencynamecode%type,
844: i_amount in iby_trxn_summaries_all.amount%type,
845: io_trxnmid in out nocopy iby_trxn_summaries_all.trxnmid%type
846: )

Line 843: i_currencycode in iby_trxn_summaries_all.currencynamecode%type,

839: */
840:
841: procedure createReturnPayment(
842: i_tid in iby_trxn_summaries_all.transactionId%type,
843: i_currencycode in iby_trxn_summaries_all.currencynamecode%type,
844: i_amount in iby_trxn_summaries_all.amount%type,
845: io_trxnmid in out nocopy iby_trxn_summaries_all.trxnmid%type
846: )
847: is

Line 844: i_amount in iby_trxn_summaries_all.amount%type,

840:
841: procedure createReturnPayment(
842: i_tid in iby_trxn_summaries_all.transactionId%type,
843: i_currencycode in iby_trxn_summaries_all.currencynamecode%type,
844: i_amount in iby_trxn_summaries_all.amount%type,
845: io_trxnmid in out nocopy iby_trxn_summaries_all.trxnmid%type
846: )
847: is
848: l_old_tmid iby_trxn_summaries_all.trxnmid%type;

Line 845: io_trxnmid in out nocopy iby_trxn_summaries_all.trxnmid%type

841: procedure createReturnPayment(
842: i_tid in iby_trxn_summaries_all.transactionId%type,
843: i_currencycode in iby_trxn_summaries_all.currencynamecode%type,
844: i_amount in iby_trxn_summaries_all.amount%type,
845: io_trxnmid in out nocopy iby_trxn_summaries_all.trxnmid%type
846: )
847: is
848: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
849: l_new_tmid iby_trxn_summaries_all.trxnmid%type;

Line 848: l_old_tmid iby_trxn_summaries_all.trxnmid%type;

844: i_amount in iby_trxn_summaries_all.amount%type,
845: io_trxnmid in out nocopy iby_trxn_summaries_all.trxnmid%type
846: )
847: is
848: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
849: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
850: l_tid iby_trxn_summaries_all.transactionId%type;
851: l_status iby_trxn_summaries_all.status%type;
852: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;

Line 849: l_new_tmid iby_trxn_summaries_all.trxnmid%type;

845: io_trxnmid in out nocopy iby_trxn_summaries_all.trxnmid%type
846: )
847: is
848: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
849: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
850: l_tid iby_trxn_summaries_all.transactionId%type;
851: l_status iby_trxn_summaries_all.status%type;
852: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
853: l_trxn_exists VARCHAR2(1);

Line 850: l_tid iby_trxn_summaries_all.transactionId%type;

846: )
847: is
848: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
849: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
850: l_tid iby_trxn_summaries_all.transactionId%type;
851: l_status iby_trxn_summaries_all.status%type;
852: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
853: l_trxn_exists VARCHAR2(1);
854: cursor c_tmid is

Line 851: l_status iby_trxn_summaries_all.status%type;

847: is
848: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
849: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
850: l_tid iby_trxn_summaries_all.transactionId%type;
851: l_status iby_trxn_summaries_all.status%type;
852: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
853: l_trxn_exists VARCHAR2(1);
854: cursor c_tmid is
855: select iby_trxnsumm_mid_s.nextval

Line 852: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;

848: l_old_tmid iby_trxn_summaries_all.trxnmid%type;
849: l_new_tmid iby_trxn_summaries_all.trxnmid%type;
850: l_tid iby_trxn_summaries_all.transactionId%type;
851: l_status iby_trxn_summaries_all.status%type;
852: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
853: l_trxn_exists VARCHAR2(1);
854: cursor c_tmid is
855: select iby_trxnsumm_mid_s.nextval
856: from dual;

Line 860: FROM iby_trxn_summaries_all s

856: from dual;
857:
858: CURSOR trxn_exists IS
859: SELECT 'Y', trxnmid
860: FROM iby_trxn_summaries_all s
861: WHERE transactionid=i_tid
862: AND trxntypeid=5
863: AND status <> '0'
864: ORDER BY reqdate desc;

Line 866: cursor getLatestTMID(ci_tid in iby_trxn_summaries_all.transactionId%type) is

862: AND trxntypeid=5
863: AND status <> '0'
864: ORDER BY reqdate desc;
865:
866: cursor getLatestTMID(ci_tid in iby_trxn_summaries_all.transactionId%type) is
867: select trxnmid , status, proc_reference_code
868: from iby_trxn_summaries_all s
869: where transactionid=ci_tid
870: and status in ( 0, 100)

Line 868: from iby_trxn_summaries_all s

864: ORDER BY reqdate desc;
865:
866: cursor getLatestTMID(ci_tid in iby_trxn_summaries_all.transactionId%type) is
867: select trxnmid , status, proc_reference_code
868: from iby_trxn_summaries_all s
869: where transactionid=ci_tid
870: and status in ( 0, 100)
871: -- // status for pending or success.
872: and (reqtype = 'ORAPMTREQ')

Line 899: update iby_trxn_summaries_all

895:
896:
897: IF (NVL(l_trxn_exists, 'N') = 'Y') THEN
898:
899: update iby_trxn_summaries_all
900: set currencynamecode=i_currencycode,
901: amount=i_amount,
902: proc_reference_code=l_reference_code,
903: last_update_date = sysdate,

Line 925: insert into iby_trxn_summaries_all

921: /*
922: ** Insert record, with values that of latest record and increment the
923: ** tid value by 1.
924: */
925: insert into iby_trxn_summaries_all
926: ( trxnMId, transactionId, tangibleid,
927: mpayeeid, payeeid, bepid, ecappid,
928: org_id, paymentMethodname,
929: payerid, payerinstrid,

Line 951: from iby_trxn_summaries_all

947: sysdate, fnd_global.user_id,
948: fnd_global.login_id, 1,
949: proc_reference_code, amount, 5, bepkey,'Y'
950: , payment_channel_code,settledate,settlement_due_date
951: from iby_trxn_summaries_all
952: where trxnmid = l_old_tmid;
953:
954:
955: insert into iby_trxn_fi

Line 982: i_trxnmid in iby_trxn_summaries_all.trxnmid%type,

978: *
979: */
980:
981: procedure updateTrxn(
982: i_trxnmid in iby_trxn_summaries_all.trxnmid%type,
983: i_status in iby_trxn_summaries_all.status%type,
984: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
985: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
986: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,

Line 983: i_status in iby_trxn_summaries_all.status%type,

979: */
980:
981: procedure updateTrxn(
982: i_trxnmid in iby_trxn_summaries_all.trxnmid%type,
983: i_status in iby_trxn_summaries_all.status%type,
984: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
985: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
986: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
987: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE)

Line 984: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,

980:
981: procedure updateTrxn(
982: i_trxnmid in iby_trxn_summaries_all.trxnmid%type,
983: i_status in iby_trxn_summaries_all.status%type,
984: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
985: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
986: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
987: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE)
988: is

Line 985: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,

981: procedure updateTrxn(
982: i_trxnmid in iby_trxn_summaries_all.trxnmid%type,
983: i_status in iby_trxn_summaries_all.status%type,
984: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
985: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
986: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
987: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE)
988: is
989:

Line 986: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,

982: i_trxnmid in iby_trxn_summaries_all.trxnmid%type,
983: i_status in iby_trxn_summaries_all.status%type,
984: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
985: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
986: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
987: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE)
988: is
989:
990: begin

Line 987: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE)

983: i_status in iby_trxn_summaries_all.status%type,
984: i_bepcode IN iby_trxn_summaries_all.BEPCode%TYPE,
985: i_bepmessage IN iby_trxn_summaries_all.BEPMessage%TYPE,
986: i_errorlocation IN iby_trxn_summaries_all.errorlocation%TYPE,
987: i_referenceCode IN iby_trxn_summaries_all.proc_reference_code%TYPE)
988: is
989:
990: begin
991:

Line 992: UPDATE iby_trxn_summaries_all

988: is
989:
990: begin
991:
992: UPDATE iby_trxn_summaries_all
993: SET
994: status = i_status,
995: bepcode = i_bepcode,
996: bepmessage = i_bepmessage,