APPS.AMS_LISTHEADER_PVT dependencies on AMS_LIST_SRC_TYPE_USAGES

Line 1902: --Delete all entries in the ams_list_src_type_usages table. --

1898: DELETE FROM ams_list_entries
1899: WHERE list_header_id =l_listheader_rec.list_header_id;
1900:
1901: ------------------------------------------------------------------------------
1902: --Delete all entries in the ams_list_src_type_usages table. --
1903: --These entries must be refreshed each time that a list is refreshed. --
1904: ------------------------------------------------------------------------------
1905: DELETE FROM ams_list_src_type_usages
1906: WHERE list_header_id =l_listheader_rec.list_header_id;

Line 1905: DELETE FROM ams_list_src_type_usages

1901: ------------------------------------------------------------------------------
1902: --Delete all entries in the ams_list_src_type_usages table. --
1903: --These entries must be refreshed each time that a list is refreshed. --
1904: ------------------------------------------------------------------------------
1905: DELETE FROM ams_list_src_type_usages
1906: WHERE list_header_id =l_listheader_rec.list_header_id;
1907:
1908: --clear associations
1909: l_listheader_rec.list_used_by_id:=0;

Line 2158: -- Deletes from The following tables Ams_List_Src_Type_Usages,

2154: -- PURPOSE
2155: -- This procedure deletes a list header record that satisfy caller needs
2156: --
2157: -- NOTES
2158: -- Deletes from The following tables Ams_List_Src_Type_Usages,
2159: -- Ams_List_Rule_Usages,
2160: -- Ams_List_Entries,
2161: -- Ams_List_Select_Actions
2162: -- Ams_List_Headers_All.

Line 2230: DELETE FROM ams_list_src_type_usages

2226: IF (AMS_DEBUG_LOW_ON) THEN
2227: NULL;
2228: END IF;
2229:
2230: DELETE FROM ams_list_src_type_usages
2231: WHERE list_header_id = l_list_header_id;
2232:
2233: DELETE FROM ams_list_rule_usages
2234: WHERE list_header_id = l_list_header_id;