APPS.IBY_ACCPPMTMTHD_PKG dependencies on IBY_ACCTTYPE

Line 29: i_instrtype in iby_accttype.instrtype%type,

25: ** Purpose: Check if the specified payeeid and pmtmethod exists or not.
26: */
27: function pmtMthdExists(i_ecappid in iby_accppmtmthd.ecappid%type,
28: i_payeeid in iby_accppmtmthd.payeeid%type,
29: i_instrtype in iby_accttype.instrtype%type,
30: i_accttype in iby_accttype.accttype%type,
31: o_status out nocopy iby_accppmtmthd.status%type)
32: return boolean
33: is

Line 30: i_accttype in iby_accttype.accttype%type,

26: */
27: function pmtMthdExists(i_ecappid in iby_accppmtmthd.ecappid%type,
28: i_payeeid in iby_accppmtmthd.payeeid%type,
29: i_instrtype in iby_accttype.instrtype%type,
30: i_accttype in iby_accttype.accttype%type,
31: o_status out nocopy iby_accppmtmthd.status%type)
32: return boolean
33: is
34: l_flag boolean := false;

Line 37: ci_instrtype iby_accttype.instrtype%type,

33: is
34: l_flag boolean := false;
35: cursor c_pmtmthd (ci_ecappid in iby_accppmtmthd.ecappid%type,
36: ci_payeeid in iby_accppmtmthd.payeeid%type,
37: ci_instrtype iby_accttype.instrtype%type,
38: ci_accttype iby_accttype.accttype%type)
39: is
40: SELECT status
41: FROM iby_accppmtmthd accp, iby_accttype acct

Line 38: ci_accttype iby_accttype.accttype%type)

34: l_flag boolean := false;
35: cursor c_pmtmthd (ci_ecappid in iby_accppmtmthd.ecappid%type,
36: ci_payeeid in iby_accppmtmthd.payeeid%type,
37: ci_instrtype iby_accttype.instrtype%type,
38: ci_accttype iby_accttype.accttype%type)
39: is
40: SELECT status
41: FROM iby_accppmtmthd accp, iby_accttype acct
42: WHERE accp.payeeid = ci_payeeid

Line 41: FROM iby_accppmtmthd accp, iby_accttype acct

37: ci_instrtype iby_accttype.instrtype%type,
38: ci_accttype iby_accttype.accttype%type)
39: is
40: SELECT status
41: FROM iby_accppmtmthd accp, iby_accttype acct
42: WHERE accp.payeeid = ci_payeeid
43: AND accp.ecappid = ci_ecappid
44: AND accp.accttypeid = acct.accttypeid
45: AND acct.instrtype = ci_instrtype

Line 79: i_instrtype in iby_accttype.instrtype%type,

75: ** i_accttype : Type of the account. Example, Checking, SAVINGS, VISA, MATERCARD.
76: */
77: procedure createAccpPmtMthd(i_ecappid in iby_accppmtmthd.ecappid%type,
78: i_payeeid in iby_accppmtmthd.payeeid%type,
79: i_instrtype in iby_accttype.instrtype%type,
80: i_accttype in iby_accttype.accttype%type )
81: is
82:
83: l_accttypeid iby_accttype.accttypeid%type;

Line 80: i_accttype in iby_accttype.accttype%type )

76: */
77: procedure createAccpPmtMthd(i_ecappid in iby_accppmtmthd.ecappid%type,
78: i_payeeid in iby_accppmtmthd.payeeid%type,
79: i_instrtype in iby_accttype.instrtype%type,
80: i_accttype in iby_accttype.accttype%type )
81: is
82:
83: l_accttypeid iby_accttype.accttypeid%type;
84: l_mpayeeid iby_accppmtmthd.mpayeeid%type;

Line 83: l_accttypeid iby_accttype.accttypeid%type;

79: i_instrtype in iby_accttype.instrtype%type,
80: i_accttype in iby_accttype.accttype%type )
81: is
82:
83: l_accttypeid iby_accttype.accttypeid%type;
84: l_mpayeeid iby_accppmtmthd.mpayeeid%type;
85: l_status iby_accppmtmthd.status%type;
86:
87: begin

Line 116: FROM iby_accttype acct

112: WHERE payeeid = i_payeeid
113: AND ecappid = i_ecappid
114: AND status = 0
115: AND accttypeid in ( SELECT accttypeid
116: FROM iby_accttype acct
117: WHERE acct.instrtype = i_instrtype
118: AND acct.accttype = i_accttype );
119: end if;
120: else

Line 124: iby_accttype_pkg.createAccttype(i_accttype, i_instrtype,

120: else
121:
122: -- brand new, add it in
123: -- create an acct type as needed
124: iby_accttype_pkg.createAccttype(i_accttype, i_instrtype,
125: l_accttypeid);
126: INSERT INTO iby_accppmtmthd ( ecappid, mpayeeid, payeeid,
127: accttypeid, status,
128: last_update_date, last_updated_by,

Line 152: i_instrtype iby_accttype.instrtype%type,

148: ** i_accttype : Type of the account. Example, Checking, SAVINGS, VISA, MATERCARD.
149: */
150: procedure deleteAccpPmtMthd(i_ecappid iby_accppmtmthd.ecappid%type,
151: i_payeeid iby_accppmtmthd.payeeid%type,
152: i_instrtype iby_accttype.instrtype%type,
153: i_accttype iby_accttype.accttype%type)
154: is
155: begin
156: /*

Line 153: i_accttype iby_accttype.accttype%type)

149: */
150: procedure deleteAccpPmtMthd(i_ecappid iby_accppmtmthd.ecappid%type,
151: i_payeeid iby_accppmtmthd.payeeid%type,
152: i_instrtype iby_accttype.instrtype%type,
153: i_accttype iby_accttype.accttype%type)
154: is
155: begin
156: /*
157: ** Update the iby_accppmtmthd table to mark the row as inactive.

Line 169: FROM iby_accttype acct

165: WHERE payeeid = i_payeeid
166: AND ecappid = i_ecappid
167: AND status = 1
168: AND accttypeid in ( SELECT accttypeid
169: FROM iby_accttype acct
170: WHERE acct.instrtype = i_instrtype
171: AND acct.accttype = i_accttype );
172: if ( sql%notfound ) then
173: raise_application_error(-20000, 'IBY_20501#', FALSE);