APPS.IBY_TRXN_AMT_LMT_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_trxn_amt_lmt_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_amount IN iby_trxn_summaries_all.amount%TYPE,
11: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
12: i_ccNumber IN iby_trxn_summaries_all.instrnumber%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_amount IN iby_trxn_summaries_all.amount%TYPE,
11: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
12: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
13: i_master_key IN iby_payee.master_key%TYPE,

Line 10: i_amount IN iby_trxn_summaries_all.amount%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_amount IN iby_trxn_summaries_all.amount%TYPE,
11: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
12: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
13: i_master_key IN iby_payee.master_key%TYPE,
14: o_score OUT NOCOPY INTEGER

Line 11: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,

7: (
8: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
9: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
10: i_amount IN iby_trxn_summaries_all.amount%TYPE,
11: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
12: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
13: i_master_key IN iby_payee.master_key%TYPE,
14: o_score OUT NOCOPY INTEGER
15: )

Line 12: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,

8: i_ecappid IN iby_trxn_summaries_all.ecappid%TYPE,
9: i_payeeid IN iby_trxn_summaries_all.payeeid%TYPE,
10: i_amount IN iby_trxn_summaries_all.amount%TYPE,
11: i_instrid IN iby_trxn_summaries_all.payerinstrid%TYPE,
12: i_ccNumber IN iby_trxn_summaries_all.instrnumber%TYPE,
13: i_master_key IN iby_payee.master_key%TYPE,
14: o_score OUT NOCOPY INTEGER
15: )
16: IS

Line 26: l_ccnum_hash iby_trxn_summaries_all.instrnum_hash%TYPE;

22: l_purchases_counter NUMBER;
23: l_duration int;
24: l_duration_type varchar2(10);
25: l_count integer;
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_config(ci_payeeid varchar2) is
30: select duration, duration_type, amount

Line 27: l_ccnum_obfs iby_trxn_summaries_all.instrnumber%TYPE;

23: l_duration int;
24: l_duration_type varchar2(10);
25: l_count integer;
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_config(ci_payeeid varchar2) is
30: select duration, duration_type, amount
31: from iby_irf_trxn_amt_limit

Line 36: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

32: where ( payeeid = ci_payeeid ) or
33: ( payeeid is null and ci_payeeid is null);
34:
35: CURSOR c_get_fop_instrnum(
36: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
37: ci_ccNumber varchar2,
38: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
39: ci_fromDate date
40: ) IS

Line 38: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,

34:
35: CURSOR c_get_fop_instrnum(
36: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
37: ci_ccNumber varchar2,
38: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
39: ci_fromDate date
40: ) IS
41: SELECT NVL(sum(amount),0)
42: FROM iby_trxn_summaries_all tx

Line 42: FROM iby_trxn_summaries_all tx

38: ci_ccNumHash iby_trxn_summaries_all.instrnum_hash%TYPE,
39: ci_fromDate date
40: ) IS
41: SELECT NVL(sum(amount),0)
42: FROM iby_trxn_summaries_all tx
43: WHERE ((ci_ccNumber = instrNumber) OR (ci_ccNumHash = instrnum_hash))
44: AND reqdate >= ci_fromDate
45: AND reqType = 'ORAPMTREQ'
46: AND (status IN (0,11,100,111))

Line 50: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,

46: AND (status IN (0,11,100,111))
47: AND payeeid = ci_payeeid;
48:
49: CURSOR c_get_fop_instrid(
50: ci_payeeid iby_trxn_summaries_all.payeeid%TYPE,
51: ci_instrid int,
52: ci_fromDate date
53: ) IS
54: SELECT NVL(sum(amount),0)

Line 55: FROM iby_trxn_summaries_all tx

51: ci_instrid int,
52: ci_fromDate date
53: ) IS
54: SELECT NVL(sum(amount),0)
55: FROM iby_trxn_summaries_all tx
56: WHERE (ci_instrid = payerInstrid)
57: AND reqdate >= ci_fromDate
58: AND reqType = 'ORAPMTREQ'
59: AND (status IN (0,11,100,111))