APPS.AMS_LIST_QUERY_PVT dependencies on AMS_LIST_QUERIES_PARAM

Line 497: delete from ams_list_queries_param

493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495: update ams_list_queries_all set parameterized_flag = 'Y'
496: where parent_list_query_id = l_parent_list_query_id;
497: delete from ams_list_queries_param
498: where list_query_id = l_parent_list_query_id ;
499: FOR I in p_query_param.first .. p_query_param.last
500: loop
501: INSERT INTO AMS_LIST_QUERIES_PARAM(

Line 501: INSERT INTO AMS_LIST_QUERIES_PARAM(

497: delete from ams_list_queries_param
498: where list_query_id = l_parent_list_query_id ;
499: FOR I in p_query_param.first .. p_query_param.last
500: loop
501: INSERT INTO AMS_LIST_QUERIES_PARAM(
502: LIST_QUERY_PARAM_ID ,
503: LIST_QUERY_ID ,
504: LAST_UPDATE_DATE ,
505: LAST_UPDATED_BY ,

Line 514: AMS_LIST_QUERIES_PARAM_S.NEXTVAL

510: PARAMETER_ORDER ,
511: PARAMETER_VALUE
512: )
513: VALUES (
514: AMS_LIST_QUERIES_PARAM_S.NEXTVAL
515: ,l_parent_list_query_id
516: ,SYSDATE
517: ,FND_GLOBAL.User_Id
518: ,SYSDATE