891: P_DATASRC_APP_ID in NUMBER
892: ) is
893: begin
894: delete from AR_BPA_ITEMS_TL
895: where item_id in (select item_id from ar_bpa_items_b
896: where SEEDED_APPLICATION_ID = P_DATASRC_APP_ID);
897:
898: delete from AR_BPA_ITEMS_B
899: where SEEDED_APPLICATION_ID = P_DATASRC_APP_ID;
894: delete from AR_BPA_ITEMS_TL
895: where item_id in (select item_id from ar_bpa_items_b
896: where SEEDED_APPLICATION_ID = P_DATASRC_APP_ID);
897:
898: delete from AR_BPA_ITEMS_B
899: where SEEDED_APPLICATION_ID = P_DATASRC_APP_ID;
900:
901: end DELETE_FLEXFIELD_ITEMS;
902: