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 3917: from ams_list_queries_param

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

Line 8776: from ams_list_queries_param

8772: where list_query_id = l_query_id ;
8773:
8774: cursor c_param_values(l_query_id in number) is
8775: select PARAMETER_ORDER, PARAMETER_VALUE,parameter_name
8776: from ams_list_queries_param
8777: where list_query_id = l_query_id
8778: order by PARAMETER_ORDER;
8779:
8780: l_string VARCHAR2(32767);

Line 8840: from ams_list_queries_param

8836:
8837: --Bug 4685389. bmuthukr. to check the total # of parameters
8838: cursor c_check_num_params(p_incl_object_id number) is
8839: select count(1)
8840: from ams_list_queries_param
8841: where list_query_id = p_incl_object_id;
8842:
8843: l_tot_params number := 0;
8844: --