DBA Data[Home] [Help]

APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_QUERIES_PARAM

Line 3862: from ams_list_queries_param

3858: where list_query_id = l_query_id ;
3859:
3860: cursor c_param_values(l_query_id in number) is
3861: select PARAMETER_ORDER, PARAMETER_VALUE,parameter_name
3862: from ams_list_queries_param
3863: where list_query_id = l_query_id
3864: order by PARAMETER_ORDER;
3865:
3866: l_remote_update_sql VARCHAR2(32767);

Line 3916: from ams_list_queries_param

3912:
3913: --Bug 4685389. bmuthukr. to check the total # of parameters
3914: cursor c_check_num_params(p_incl_object_id number) is
3915: select count(1)
3916: from ams_list_queries_param
3917: where list_query_id = p_incl_object_id;
3918:
3919: l_tot_params number := 0;
3920: --

Line 8686: from ams_list_queries_param

8682: where list_query_id = l_query_id ;
8683:
8684: cursor c_param_values(l_query_id in number) is
8685: select PARAMETER_ORDER, PARAMETER_VALUE,parameter_name
8686: from ams_list_queries_param
8687: where list_query_id = l_query_id
8688: order by PARAMETER_ORDER;
8689:
8690: l_string VARCHAR2(32767);

Line 8745: from ams_list_queries_param

8741:
8742: --Bug 4685389. bmuthukr. to check the total # of parameters
8743: cursor c_check_num_params(p_incl_object_id number) is
8744: select count(1)
8745: from ams_list_queries_param
8746: where list_query_id = p_incl_object_id;
8747:
8748: l_tot_params number := 0;
8749: --