APPS.IBY_FREQ_OF_PURCH_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 8: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,

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

Line 9: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,

5:
6: PROCEDURE eval_factor
7: (
8: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
9: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
10: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
11: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
12: i_master_key in iby_payee.master_key%TYPE,
13: o_score out NOCOPY integer

Line 10: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,

6: PROCEDURE eval_factor
7: (
8: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
9: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
10: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
11: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
12: i_master_key in iby_payee.master_key%TYPE,
13: o_score out NOCOPY integer
14: )

Line 11: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,

7: (
8: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
9: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
10: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
11: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
12: i_master_key in iby_payee.master_key%TYPE,
13: o_score out NOCOPY integer
14: )
15: IS

Line 25: l_ccnum_hash iby_trxn_summaries_all.instrnum_hash%TYPE;

21: l_no_of_purchases int;
22: l_purchases_counter INT;
23: l_duration int;
24: l_duration_type varchar2(10);
25: l_ccnum_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
26: l_ccnum_obfs iby_trxn_summaries_all.instrnumber%TYPE;
27:
28: CURSOR c_get_config(ci_payeeid varchar2) IS
29: SELECT duration, duration_type, frequency

Line 26: l_ccnum_obfs iby_trxn_summaries_all.instrnumber%TYPE;

22: l_purchases_counter INT;
23: l_duration int;
24: l_duration_type varchar2(10);
25: l_ccnum_hash iby_trxn_summaries_all.instrnum_hash%TYPE;
26: l_ccnum_obfs iby_trxn_summaries_all.instrnumber%TYPE;
27:
28: CURSOR c_get_config(ci_payeeid varchar2) IS
29: SELECT duration, duration_type, frequency
30: FROM iby_irf_pmt_frequency

Line 40: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

36: -- hard-encrypted) forms
37: --
38:
39: CURSOR c_get_fop_instrnum(
40: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
41: ci_ccNumber varchar2,
42: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
43: ci_fromDate date
44: ) IS

Line 42: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,

38:
39: CURSOR c_get_fop_instrnum(
40: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
41: ci_ccNumber varchar2,
42: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
43: ci_fromDate date
44: ) IS
45: SELECT count(1)
46: FROM iby_trxn_summaries_all tx

Line 46: FROM iby_trxn_summaries_all tx

42: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
43: ci_fromDate date
44: ) IS
45: SELECT count(1)
46: FROM iby_trxn_summaries_all tx
47: WHERE ((ci_ccNumber = instrNumber) OR (ci_ccNumHash = instrnum_hash))
48: AND reqdate >= ci_fromDate
49: AND reqType = 'ORAPMTREQ'
50: AND (status IN (0,11,100,111))

Line 54: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

50: AND (status IN (0,11,100,111))
51: AND payeeid = ci_payeeid;
52:
53: CURSOR c_get_fop_instrid(
54: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
55: ci_instrid int,
56: ci_fromDate date
57: ) IS
58: SELECT count(1)

Line 59: FROM iby_trxn_summaries_all tx

55: ci_instrid int,
56: ci_fromDate date
57: ) IS
58: SELECT count(1)
59: FROM iby_trxn_summaries_all tx
60: WHERE (ci_instrid = payerInstrid)
61: AND reqdate >= ci_fromDate
62: AND reqType = 'ORAPMTREQ'
63: AND (status IN (0,11,100,111))