APPS.AMS_LISTHEADER_PVT dependencies on AMS_LIST_SRC_TYPE_USAGES

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

1885: DELETE FROM ams_list_entries
1886: WHERE list_header_id =l_listheader_rec.list_header_id;
1887:
1888: ------------------------------------------------------------------------------
1889: --Delete all entries in the ams_list_src_type_usages table. --
1890: --These entries must be refreshed each time that a list is refreshed. --
1891: ------------------------------------------------------------------------------
1892: DELETE FROM ams_list_src_type_usages
1893: WHERE list_header_id =l_listheader_rec.list_header_id;

Line 1892: DELETE FROM ams_list_src_type_usages

1888: ------------------------------------------------------------------------------
1889: --Delete all entries in the ams_list_src_type_usages table. --
1890: --These entries must be refreshed each time that a list is refreshed. --
1891: ------------------------------------------------------------------------------
1892: DELETE FROM ams_list_src_type_usages
1893: WHERE list_header_id =l_listheader_rec.list_header_id;
1894:
1895: --clear associations
1896: l_listheader_rec.list_used_by_id:=0;

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

2141: -- PURPOSE
2142: -- This procedure deletes a list header record that satisfy caller needs
2143: --
2144: -- NOTES
2145: -- Deletes from The following tables Ams_List_Src_Type_Usages,
2146: -- Ams_List_Rule_Usages,
2147: -- Ams_List_Entries,
2148: -- Ams_List_Select_Actions
2149: -- Ams_List_Headers_All.

Line 2217: DELETE FROM ams_list_src_type_usages

2213: IF (AMS_DEBUG_LOW_ON) THEN
2214: NULL;
2215: END IF;
2216:
2217: DELETE FROM ams_list_src_type_usages
2218: WHERE list_header_id = l_list_header_id;
2219:
2220: DELETE FROM ams_list_rule_usages
2221: WHERE list_header_id = l_list_header_id;