APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on DBMS_SQL

Line 9: sqlstr DBMS_SQL.VARCHAR2S;

5: TYPE char_tab IS TABLE OF pay_action_information.action_information1%type INDEX BY BINARY_INTEGER;
6: g_xml_nwr char_tab;
7: --
8: g_action_ctx_id NUMBER;
9: sqlstr DBMS_SQL.VARCHAR2S;
10: l_cntr_sql NUMBER;
11: g_year VARCHAR2(10);
12: g_report_type VARCHAR2(20);
13: g_payroll_type VARCHAR2(40) DEFAULT NULL; --8552196

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

384: -- Name : BUILD_SQL
385: -- Description : This procedure builds dynamic SQL string.
386: --------------------------------------------------------------------------------
387: --
388: PROCEDURE build_sql(p_sqlstr_tab IN OUT NOCOPY DBMS_SQL.VARCHAR2S
389: ,p_cntr IN OUT NOCOPY NUMBER
390: ,p_string VARCHAR2) AS
391: --
392: l_proc_name varchar2(100);

Line 2118: csr := dbms_sql.open_cursor;

2114: build_sql(sqlstr, l_cntr_sql, 'pay_nl_nwr_xml_extract_pkg.load_xml(''CE'', NULL, ''Loonaangifte'', NULL);');
2115: END IF;
2116: build_sql(sqlstr, l_cntr_sql, 'END;');
2117: --
2118: csr := dbms_sql.open_cursor;
2119: dbms_sql.parse (csr,
2120: sqlstr,
2121: sqlstr.first(),
2122: sqlstr.last(),

Line 2119: dbms_sql.parse (csr,

2115: END IF;
2116: build_sql(sqlstr, l_cntr_sql, 'END;');
2117: --
2118: csr := dbms_sql.open_cursor;
2119: dbms_sql.parse (csr,
2120: sqlstr,
2121: sqlstr.first(),
2122: sqlstr.last(),
2123: false,

Line 2124: dbms_sql.v7);

2120: sqlstr,
2121: sqlstr.first(),
2122: sqlstr.last(),
2123: false,
2124: dbms_sql.v7);
2125: ret := dbms_sql.execute(csr);
2126: dbms_sql.close_cursor(csr);
2127: --
2128: WritetoCLOB(p_xfdf_string => l_xml);

Line 2125: ret := dbms_sql.execute(csr);

2121: sqlstr.first(),
2122: sqlstr.last(),
2123: false,
2124: dbms_sql.v7);
2125: ret := dbms_sql.execute(csr);
2126: dbms_sql.close_cursor(csr);
2127: --
2128: WritetoCLOB(p_xfdf_string => l_xml);
2129: --

Line 2126: dbms_sql.close_cursor(csr);

2122: sqlstr.last(),
2123: false,
2124: dbms_sql.v7);
2125: ret := dbms_sql.execute(csr);
2126: dbms_sql.close_cursor(csr);
2127: --
2128: WritetoCLOB(p_xfdf_string => l_xml);
2129: --
2130: p_xml := l_xml;