APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on DBMS_SQL

Line 1006: l_header dbms_sql.varchar2a;

1002: -- |---------------------------< rebuild_package >----------------------------|
1003: -- ----------------------------------------------------------------------------
1004: procedure rebuild_package(p_rebuild_dimension in boolean default false)
1005: is
1006: l_header dbms_sql.varchar2a;
1007: l_body dbms_sql.varchar2a;
1008: l_csr number;
1009: l_dummy number;
1010: l_reset_date varchar2(30);

Line 1007: l_body dbms_sql.varchar2a;

1003: -- ----------------------------------------------------------------------------
1004: procedure rebuild_package(p_rebuild_dimension in boolean default false)
1005: is
1006: l_header dbms_sql.varchar2a;
1007: l_body dbms_sql.varchar2a;
1008: l_csr number;
1009: l_dummy number;
1010: l_reset_date varchar2(30);
1011: l_frequency_type varchar2(30);

Line 1302: l_csr := dbms_sql.open_cursor;

1298: --
1299: add_body('--');
1300: add_body('end pay_jp_dynamic_dimension_pkg;');
1301: --
1302: l_csr := dbms_sql.open_cursor;
1303: --
1304: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1305: l_dummy := dbms_sql.execute(l_csr);
1306: --

Line 1304: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);

1300: add_body('end pay_jp_dynamic_dimension_pkg;');
1301: --
1302: l_csr := dbms_sql.open_cursor;
1303: --
1304: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1305: l_dummy := dbms_sql.execute(l_csr);
1306: --
1307: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1308: l_dummy := dbms_sql.execute(l_csr);

Line 1305: l_dummy := dbms_sql.execute(l_csr);

1301: --
1302: l_csr := dbms_sql.open_cursor;
1303: --
1304: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1305: l_dummy := dbms_sql.execute(l_csr);
1306: --
1307: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1308: l_dummy := dbms_sql.execute(l_csr);
1309: --

Line 1307: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);

1303: --
1304: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1305: l_dummy := dbms_sql.execute(l_csr);
1306: --
1307: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1308: l_dummy := dbms_sql.execute(l_csr);
1309: --
1310: dbms_sql.close_cursor(l_csr);
1311: end if;

Line 1308: l_dummy := dbms_sql.execute(l_csr);

1304: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1305: l_dummy := dbms_sql.execute(l_csr);
1306: --
1307: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1308: l_dummy := dbms_sql.execute(l_csr);
1309: --
1310: dbms_sql.close_cursor(l_csr);
1311: end if;
1312: end rebuild_package;

Line 1310: dbms_sql.close_cursor(l_csr);

1306: --
1307: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1308: l_dummy := dbms_sql.execute(l_csr);
1309: --
1310: dbms_sql.close_cursor(l_csr);
1311: end if;
1312: end rebuild_package;
1313: --
1314: procedure rebuild_package(