APPS.PAY_AE_RULES dependencies on DBMS_SQL

Line 275: sqlstr DBMS_SQL.VARCHAR2S;

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

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

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