DBA Data[Home] [Help]

APPS.AMS_LISTGENERATION_PKG dependencies on DBMS_SQL

Line 3723: l_sql_2 DBMS_SQL.VARCHAR2S;

3719: l_select_condition varchar2(2000);
3720: l_select_add_condition varchar2(2000);
3721: l_msg_data VARCHAR2(2000);
3722: l_msg_count number;
3723: l_sql_2 DBMS_SQL.VARCHAR2S;
3724: l_sql_string_final varchar2(4000);
3725: j number := 1;
3726: BEGIN
3727: write_to_act_log('Executing process_cell since segment has been included in list/target group selections.', 'LIST', g_list_header_id,'LOW');

Line 12808: l_sql_2 DBMS_SQL.VARCHAR2S;

12804: l_select_condition varchar2(2000);
12805: l_select_add_condition varchar2(2000);
12806: l_msg_data VARCHAR2(2000);
12807: l_msg_count number;
12808: l_sql_2 DBMS_SQL.VARCHAR2S;
12809: l_sql_string_final varchar2(4000);
12810: j number := 1;
12811: BEGIN
12812: