APPS.AD_PA_CRITERIA_UTIL dependencies on AD_PA_CRITERIA_PRODUCTS

Line 336: -- Delete rows from ad_pa_criteria and ad_pa_criteria_products for 11.5.9

332: is
333:
334: --
335: -- Create/update all three of the pre-seeded Criteria Sets
336: -- Delete rows from ad_pa_criteria and ad_pa_criteria_products for 11.5.9
337: x_statement varchar2(100);
338: G_UN_FND varchar2(30) := null;
339: l_stat varchar2(1) := null;
340: l_ind varchar2(1) := null;

Line 371: where table_name = 'AD_PA_CRITERIA_PRODUCTS'

367: --DBMS_OUTPUT.PUT_LINE('Username -> [' || G_UN_FND || ']');
368:
369: select 'y' into x_statement
370: from dba_tables
371: where table_name = 'AD_PA_CRITERIA_PRODUCTS'
372: and owner = G_UN_FND;
373:
374: if x_statement = 'y' then
375: begin

Line 378: from ad_pa_criteria_products acp

374: if x_statement = 'y' then
375: begin
376: delete from ad_pa_criteria ac
377: where advisor_criteria_id in ( select advisor_criteria_id
378: from ad_pa_criteria_products acp
379: where acp.advisor_criteria_id = ac.advisor_criteria_id);
380: DELETE from AD_PA_CRITERIA_products;
381: exception
382: when no_data_found then

Line 380: DELETE from AD_PA_CRITERIA_products;

376: delete from ad_pa_criteria ac
377: where advisor_criteria_id in ( select advisor_criteria_id
378: from ad_pa_criteria_products acp
379: where acp.advisor_criteria_id = ac.advisor_criteria_id);
380: DELETE from AD_PA_CRITERIA_products;
381: exception
382: when no_data_found then
383: null;
384: end;