APPS.PAY_AE_RULES dependencies on DBMS_SQL

Line 276: sqlstr DBMS_SQL.VARCHAR2S;

272:
273: l_xml CLOB;
274: cntr_flex_col NUMBER;
275: l_flex_col_num NUMBER;
276: sqlstr DBMS_SQL.VARCHAR2S;
277: csr NUMBER;
278: ret NUMBER;
279: l_cntr_sql NUMBER;
280: l_total_pay NUMBER;

Line 286: PROCEDURE build_sql(p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S,

282: l_total_deductions NUMBER;
283: l_input_value VARCHAR2(100);
284:
285:
286: PROCEDURE build_sql(p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S,
287: p_cntr IN OUT NOCOPY NUMBER,
288: p_string VARCHAR2) AS
289: --
290: l_proc_name varchar2(100);