APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on DBMS_SQL

Line 1024: l_header dbms_sql.varchar2a;

1020: -- |---------------------------< rebuild_package >----------------------------|
1021: -- ----------------------------------------------------------------------------
1022: procedure rebuild_package(p_rebuild_dimension in boolean default false)
1023: is
1024: l_header dbms_sql.varchar2a;
1025: l_body dbms_sql.varchar2a;
1026: l_csr number;
1027: l_dummy number;
1028: l_reset_date varchar2(30);

Line 1025: l_body dbms_sql.varchar2a;

1021: -- ----------------------------------------------------------------------------
1022: procedure rebuild_package(p_rebuild_dimension in boolean default false)
1023: is
1024: l_header dbms_sql.varchar2a;
1025: l_body dbms_sql.varchar2a;
1026: l_csr number;
1027: l_dummy number;
1028: l_reset_date varchar2(30);
1029: l_frequency_type varchar2(30);

Line 1320: l_csr := dbms_sql.open_cursor;

1316: --
1317: add_body('--');
1318: add_body('end pay_jp_dynamic_dimension_pkg;');
1319: --
1320: l_csr := dbms_sql.open_cursor;
1321: --
1322: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1323: l_dummy := dbms_sql.execute(l_csr);
1324: --

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

1318: add_body('end pay_jp_dynamic_dimension_pkg;');
1319: --
1320: l_csr := dbms_sql.open_cursor;
1321: --
1322: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1323: l_dummy := dbms_sql.execute(l_csr);
1324: --
1325: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1326: l_dummy := dbms_sql.execute(l_csr);

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

1319: --
1320: l_csr := dbms_sql.open_cursor;
1321: --
1322: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1323: l_dummy := dbms_sql.execute(l_csr);
1324: --
1325: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1326: l_dummy := dbms_sql.execute(l_csr);
1327: --

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

1321: --
1322: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1323: l_dummy := dbms_sql.execute(l_csr);
1324: --
1325: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1326: l_dummy := dbms_sql.execute(l_csr);
1327: --
1328: dbms_sql.close_cursor(l_csr);
1329: end if;

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

1322: dbms_sql.parse(l_csr, l_header, 1, l_header.count, true, dbms_sql.native);
1323: l_dummy := dbms_sql.execute(l_csr);
1324: --
1325: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1326: l_dummy := dbms_sql.execute(l_csr);
1327: --
1328: dbms_sql.close_cursor(l_csr);
1329: end if;
1330: end rebuild_package;

Line 1328: dbms_sql.close_cursor(l_csr);

1324: --
1325: dbms_sql.parse(l_csr, l_body, 1, l_body.count, true, dbms_sql.native);
1326: l_dummy := dbms_sql.execute(l_csr);
1327: --
1328: dbms_sql.close_cursor(l_csr);
1329: end if;
1330: end rebuild_package;
1331: --
1332: procedure rebuild_package(