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

Line 6: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,

2: /*$Header: ibypmthb.pls 120.3.12000000.2 2007/09/06 09:54:36 lmallick ship $*/
3: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.iby_pmt_history_pkg';
4: PROCEDURE eval_factor
5: (
6: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
7: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
8: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
9: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
10: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,

Line 7: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,

3: G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.iby_pmt_history_pkg';
4: PROCEDURE eval_factor
5: (
6: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
7: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
8: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
9: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
10: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
11: i_master_key IN iby_payee.master_key%TYPE,

Line 8: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,

4: PROCEDURE eval_factor
5: (
6: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
7: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
8: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
9: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
10: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
11: i_master_key IN iby_payee.master_key%TYPE,
12: o_score OUT NOCOPY INTEGER

Line 9: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,

5: (
6: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
7: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
8: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
9: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
10: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
11: i_master_key IN iby_payee.master_key%TYPE,
12: o_score OUT NOCOPY INTEGER
13: )

Line 10: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,

6: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
7: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
8: i_payerid IN iby_trxn_summaries_all.payerid%TYPE,
9: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
10: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
11: i_master_key IN iby_payee.master_key%TYPE,
12: o_score OUT NOCOPY INTEGER
13: )
14: IS

Line 26: l_ccnum_hash iby_trxn_summaries_all.instrnum_hash%TYPE;

22: l_score varchar2(10);
23: l_payeeid varchar2(80);
24: l_no_of_purchases integer;
25: l_purchases_counter INT;
26: l_ccnum_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
27: l_ccnum_obfs iby_trxn_summaries_all.instrnumber%TYPE;
28:
29: cursor c_get_ranges(ci_pmt_hist_id integer) is
30: select frequency_low_range lower_limit,

Line 27: l_ccnum_obfs iby_trxn_summaries_all.instrnumber%TYPE;

23: l_payeeid varchar2(80);
24: l_no_of_purchases integer;
25: l_purchases_counter INT;
26: l_ccnum_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
27: l_ccnum_obfs iby_trxn_summaries_all.instrnumber%TYPE;
28:
29: cursor c_get_ranges(ci_pmt_hist_id integer) is
30: select frequency_low_range lower_limit,
31: frequency_high_range upper_limit, score

Line 48: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

44: -- to avoid expensive, unnecessary queries
45: --
46: CURSOR c_get_history_instrnum
47: (
48: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
49: ci_ccNum iby_trxn_summaries_all.instrnumber%TYPE,
50: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
51: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
52: )

Line 49: ci_ccNum iby_trxn_summaries_all.instrnumber%TYPE,

45: --
46: CURSOR c_get_history_instrnum
47: (
48: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
49: ci_ccNum iby_trxn_summaries_all.instrnumber%TYPE,
50: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
51: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
52: )
53: IS

Line 50: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,

46: CURSOR c_get_history_instrnum
47: (
48: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
49: ci_ccNum iby_trxn_summaries_all.instrnumber%TYPE,
50: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
51: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
52: )
53: IS
54: SELECT count(1)

Line 51: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE

47: (
48: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
49: ci_ccNum iby_trxn_summaries_all.instrnumber%TYPE,
50: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
51: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
52: )
53: IS
54: SELECT count(1)
55: FROM iby_trxn_summaries_all

Line 55: FROM iby_trxn_summaries_all

51: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
52: )
53: IS
54: SELECT count(1)
55: FROM iby_trxn_summaries_all
56: WHERE ((instrnumber = ci_ccNum) OR (instrnum_hash = ci_ccNumHash))
57: AND reqdate >= ci_fromDate
58: AND reqtype = 'ORAPMTREQ'
59: AND (status IN (0,11,10,111))

Line 64: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

60: AND (payeeid = ci_payeeid);
61:
62: CURSOR c_get_history_payer
63: (
64: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
65: ci_payerid iby_trxn_summaries_all.payerid%TYPE,
66: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
67: )
68: IS

Line 65: ci_payerid iby_trxn_summaries_all.payerid%TYPE,

61:
62: CURSOR c_get_history_payer
63: (
64: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
65: ci_payerid iby_trxn_summaries_all.payerid%TYPE,
66: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
67: )
68: IS
69: SELECT count(1)

Line 66: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE

62: CURSOR c_get_history_payer
63: (
64: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
65: ci_payerid iby_trxn_summaries_all.payerid%TYPE,
66: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
67: )
68: IS
69: SELECT count(1)
70: FROM iby_trxn_summaries_all

Line 70: FROM iby_trxn_summaries_all

66: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
67: )
68: IS
69: SELECT count(1)
70: FROM iby_trxn_summaries_all
71: WHERE (payerid = ci_payerid)
72: AND reqdate >= ci_fromDate
73: AND reqtype = 'ORAPMTREQ'
74: AND (status IN (0,11,10,111))

Line 79: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

75: AND (payeeid = ci_payeeid);
76:
77: CURSOR c_get_history_payerinstr
78: (
79: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
80: ci_instrid iby_trxn_summaries_all.payerinstrid%TYPE,
81: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
82: )
83: IS

Line 80: ci_instrid iby_trxn_summaries_all.payerinstrid%TYPE,

76:
77: CURSOR c_get_history_payerinstr
78: (
79: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
80: ci_instrid iby_trxn_summaries_all.payerinstrid%TYPE,
81: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
82: )
83: IS
84: SELECT count(1)

Line 81: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE

77: CURSOR c_get_history_payerinstr
78: (
79: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
80: ci_instrid iby_trxn_summaries_all.payerinstrid%TYPE,
81: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
82: )
83: IS
84: SELECT count(1)
85: FROM iby_trxn_summaries_all

Line 85: FROM iby_trxn_summaries_all

81: ci_fromDate iby_trxn_summaries_all.reqdate%TYPE
82: )
83: IS
84: SELECT count(1)
85: FROM iby_trxn_summaries_all
86: WHERE (payerinstrid = ci_instrid)
87: AND reqdate >= ci_fromDate
88: AND reqtype = 'ORAPMTREQ'
89: AND (status IN (0,11,10,111))