APPS.FLM_KANBAN_PURGE dependencies on MTL_KANBAN_CARDS

Line 48: DELETE mtl_kanban_cards

44: Begin
45:
46: l_stmt_num := 210;
47: if (arg_delete_card = G_CANCELLED_CARDS_ONLY) then
48: DELETE mtl_kanban_cards
49: WHERE organization_id = arg_org_id
50: AND pull_sequence_id = arg_pull_seq_id
51: AND card_status = 3;
52:

Line 78: DELETE mtl_kanban_cards

74: end if;
75: elsif (arg_delete_card = G_CANCELLED_AND_NEW) then
76: -- Delete both Cancelled and New/Active Cards .
77: l_stmt_num := 230;
78: DELETE mtl_kanban_cards
79: WHERE organization_id = arg_org_id
80: AND pull_sequence_id = arg_pull_seq_id
81: AND (
82: (card_status = 3) OR

Line 215: FROM MTL_KANBAN_CARDS

211: into l_records_found
212: FROM DUAL
213: WHERE EXISTS
214: ( SELECT 1
215: FROM MTL_KANBAN_CARDS
216: WHERE organization_id = arg_org_id
217: AND pull_sequence_id = arg_pull_seq_id );
218:
219: if (l_records_found <> 0) then