APPS.AMS_LIST_PURGE_PVT dependencies on AMS_QUERY_TEMPLATE_INSTANCE

Line 989: ams_query_template_instance inst

985: FORALL i in 1 .. p_id_tbl.count
986: DELETE from ams_query_condition_value value
987: WHERE EXISTS (SELECT 1
988: FROM ams_query_temp_inst_cond_assoc assoc,
989: ams_query_template_instance inst
990: WHERE assoc.template_instance_id = inst.template_instance_id
991: AND value.assoc_id = assoc.assoc_id
992: AND inst.instance_used_by_id = p_id_tbl(i));
993:

Line 997: FROM ams_query_template_instance inst

993:
994: FORALL i in 1 .. p_id_tbl.count
995: DELETE from AMS_QUERY_TEMP_INST_COND_ASSOC assoc
996: WHERE EXISTS (SELECT 1
997: FROM ams_query_template_instance inst
998: WHERE assoc.template_instance_id = inst.template_instance_id
999: AND inst.instance_used_by_id = p_id_tbl(i));
1000:
1001: FORALL i in 1 .. p_id_tbl.count

Line 1002: DELETE from ams_query_template_instance

998: WHERE assoc.template_instance_id = inst.template_instance_id
999: AND inst.instance_used_by_id = p_id_tbl(i));
1000:
1001: FORALL i in 1 .. p_id_tbl.count
1002: DELETE from ams_query_template_instance
1003: WHERE instance_used_by_id = p_id_tbl(i);
1004:
1005: UPDATE ams_query_template_all qt
1006: SET in_use_flag = 'N'

Line 1008: FROM ams_query_template_instance inst

1004:
1005: UPDATE ams_query_template_all qt
1006: SET in_use_flag = 'N'
1007: WHERE NOT EXISTS (SELECT 1
1008: FROM ams_query_template_instance inst
1009: WHERE qt.template_id = inst.template_id
1010: AND inst.instance_used_by_id is not null);
1011:
1012:

Line 1016: FROM ams_query_template_instance inst

1012:
1013: UPDATE ams_query_condition cond
1014: SET condition_in_use_flag = 'N'
1015: WHERE NOT EXISTS (SELECT 1
1016: FROM ams_query_template_instance inst
1017: WHERE cond.template_id = inst.template_id
1018: AND inst.instance_used_by_id is not null);
1019:
1020: FORALL i in 1 .. p_id_tbl.count