APPS.AMS_LISTDEDUPE_PVT dependencies on DBMS_SQL

Line 86: l_cursor_name := DBMS_SQL.open_cursor;

82: BEGIN
83:
84: --executing dynamic sql statement to populate the merge_key field in ams_list_entries.
85:
86: l_cursor_name := DBMS_SQL.open_cursor;
87: --insert into temp(text2) values('after open cursor');commit;
88:
89: DBMS_SQL.parse (l_cursor_name, p_stmt, DBMS_SQL.native);
90: --insert into temp(text2) values('after sql parse');commit;

Line 89: DBMS_SQL.parse (l_cursor_name, p_stmt, DBMS_SQL.native);

85:
86: l_cursor_name := DBMS_SQL.open_cursor;
87: --insert into temp(text2) values('after open cursor');commit;
88:
89: DBMS_SQL.parse (l_cursor_name, p_stmt, DBMS_SQL.native);
90: --insert into temp(text2) values('after sql parse');commit;
91:
92: l_rows_processed := DBMS_SQL.execute (l_cursor_name);
93: --insert into temp(text2) values('after execute');commit;

Line 92: l_rows_processed := DBMS_SQL.execute (l_cursor_name);

88:
89: DBMS_SQL.parse (l_cursor_name, p_stmt, DBMS_SQL.native);
90: --insert into temp(text2) values('after sql parse');commit;
91:
92: l_rows_processed := DBMS_SQL.execute (l_cursor_name);
93: --insert into temp(text2) values('after execute');commit;
94:
95: DBMS_SQL.close_cursor (l_cursor_name);
96: --insert into temp(text2) values('after close cursor');commit;

Line 95: DBMS_SQL.close_cursor (l_cursor_name);

91:
92: l_rows_processed := DBMS_SQL.execute (l_cursor_name);
93: --insert into temp(text2) values('after execute');commit;
94:
95: DBMS_SQL.close_cursor (l_cursor_name);
96: --insert into temp(text2) values('after close cursor');commit;
97:
98: RETURN (l_rows_processed);
99: