APPS.AMS_LISTDEDUPE_PVT dependencies on DBMS_SQL

Line 85: l_cursor_name := DBMS_SQL.open_cursor;

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

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

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

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

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

Line 94: DBMS_SQL.close_cursor (l_cursor_name);

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