DBA Data[Home] [Help]

APPS.IBY_PMTSCHEMES_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 81: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100)

77: ** for single entry, whatever in the table
78: ** for double entry, return 'BOTH' ('SSL' and 'BANKACCOUNT')
79: */
80: procedure getPmtSchemeName(i_bepid in iby_pmtschemes.bepid%type,
81: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100)
82: --o_pmtschemename out nocopy iby_pmtschemes.pmtschemename%type)
83: IS
84:
85: CURSOR c_get_pmtschemeName(ci_bepid in iby_pmtschemes.bepid%type)

Line 108: o_pmtschemeName := JTF_VARCHAR2_TABLE_100();

104: close c_get_pmtschemeName;
105: raise_application_error(-20000, 'IBY_20521#', FALSE);
106: end if;
107:
108: o_pmtschemeName := JTF_VARCHAR2_TABLE_100();
109: --o_pmtschemeName.extend(c_get_pmtschemeName%count);
110:
111: --dbms_output.put_line('rowcount is ' || c_get_pmtschemeName%rowcount);
112:

Line 135: i_pmtschemeName in JTF_VARCHAR2_TABLE_100)

131: ** Purpose: replace whatever previous existing pmtscheme with new ones
132: ** for a given bepid
133: */
134: procedure createPmtScheme(i_bepid in iby_pmtschemes.bepid%type,
135: i_pmtschemeName in JTF_VARCHAR2_TABLE_100)
136: IS
137:
138: l_count number;
139: l_pmtschemeid number;