1: package iby_pmtschemes_pkg AUTHID CURRENT_USER as
2: /*$Header: ibypmscs.pls 115.8 2002/11/19 21:32:01 jleybovi ship $*/
3:
4: /*
5: ** Procedure: checkPmtSchemes.
6: ** Purpose: get payment scheme id based on scheme name, raise exception
7: ** if scheme doesn't exist
8: */
9: procedure checkPmtScheme( i_pmtschemename in
10: iby_pmtschemes.pmtschemename%type,
11: io_pmtschemeid in out nocopy
12: iby_pmtschemes.pmtschemeid%type);
13:
14:
8: */
9: procedure checkPmtScheme( i_pmtschemename in
10: iby_pmtschemes.pmtschemename%type,
11: io_pmtschemeid in out nocopy
12: iby_pmtschemes.pmtschemeid%type);
13:
14:
15: /* Procedure: getPmtSchemeName
16: ** Purpose: return pmt scheme name based on bepid
16: ** Purpose: return pmt scheme name based on bepid
17: ** for single entry, whatever in the table
18: ** for double entry, return 'BOTH' ('SSL' and 'BANKACCOUNT')
19: */
20: procedure getPmtSchemeName(i_bepid in iby_pmtschemes.bepid%type,
21: --o_pmtschemename out nocopy iby_pmtschemes.pmtschemename%type);
22: o_pmtschemename out nocopy JTF_VARCHAR2_TABLE_100);
23:
24:
17: ** for single entry, whatever in the table
18: ** for double entry, return 'BOTH' ('SSL' and 'BANKACCOUNT')
19: */
20: procedure getPmtSchemeName(i_bepid in iby_pmtschemes.bepid%type,
21: --o_pmtschemename out nocopy iby_pmtschemes.pmtschemename%type);
22: o_pmtschemename out nocopy JTF_VARCHAR2_TABLE_100);
23:
24:
25: /* Procedure: createPmtScheme
25: /* Procedure: createPmtScheme
26: ** Purpose: replace whatever previous existing pmtscheme with new ones
27: ** for a given bepid
28: */
29: procedure createPmtScheme(i_bepid in iby_pmtschemes.bepid%type,
30: i_pmtschemename in JTF_VARCHAR2_TABLE_100);
31: --i_pmtschemename in iby_pmtschemes.pmtschemename%type,
32: --i_pmtschemeid1 in iby_pmtschemes.pmtschemeid%type,
33: --i_pmtschemeid2 in iby_pmtschemes.pmtschemeid%type);
27: ** for a given bepid
28: */
29: procedure createPmtScheme(i_bepid in iby_pmtschemes.bepid%type,
30: i_pmtschemename in JTF_VARCHAR2_TABLE_100);
31: --i_pmtschemename in iby_pmtschemes.pmtschemename%type,
32: --i_pmtschemeid1 in iby_pmtschemes.pmtschemeid%type,
33: --i_pmtschemeid2 in iby_pmtschemes.pmtschemeid%type);
34:
35: end iby_pmtschemes_pkg;
28: */
29: procedure createPmtScheme(i_bepid in iby_pmtschemes.bepid%type,
30: i_pmtschemename in JTF_VARCHAR2_TABLE_100);
31: --i_pmtschemename in iby_pmtschemes.pmtschemename%type,
32: --i_pmtschemeid1 in iby_pmtschemes.pmtschemeid%type,
33: --i_pmtschemeid2 in iby_pmtschemes.pmtschemeid%type);
34:
35: end iby_pmtschemes_pkg;
36:
29: procedure createPmtScheme(i_bepid in iby_pmtschemes.bepid%type,
30: i_pmtschemename in JTF_VARCHAR2_TABLE_100);
31: --i_pmtschemename in iby_pmtschemes.pmtschemename%type,
32: --i_pmtschemeid1 in iby_pmtschemes.pmtschemeid%type,
33: --i_pmtschemeid2 in iby_pmtschemes.pmtschemeid%type);
34:
35: end iby_pmtschemes_pkg;
36:
37:
31: --i_pmtschemename in iby_pmtschemes.pmtschemename%type,
32: --i_pmtschemeid1 in iby_pmtschemes.pmtschemeid%type,
33: --i_pmtschemeid2 in iby_pmtschemes.pmtschemeid%type);
34:
35: end iby_pmtschemes_pkg;
36:
37: