904: P_DATASRC_APP_ID in NUMBER
905: ) is
906: begin
907: delete from AR_BPA_ITEMS_TL
908: where item_id in (select item_id from ar_bpa_items_b
909: where SEEDED_APPLICATION_ID = P_DATASRC_APP_ID);
910:
911: delete from AR_BPA_ITEMS_B
912: where SEEDED_APPLICATION_ID = P_DATASRC_APP_ID;
907: delete from AR_BPA_ITEMS_TL
908: where item_id in (select item_id from ar_bpa_items_b
909: where SEEDED_APPLICATION_ID = P_DATASRC_APP_ID);
910:
911: delete from AR_BPA_ITEMS_B
912: where SEEDED_APPLICATION_ID = P_DATASRC_APP_ID;
913:
914: end DELETE_FLEXFIELD_ITEMS;
915: