APPS.ZPB_AW_WRITE_BACK dependencies on ZPB_VALIDATION_TEMP_DATA

Line 759: -- filter out bad queries that are in the ZPB_VALIDATION_TEMP_DATA table.

755: l_query_path VARCHAR2(255);
756: l_user_name FND_USER.USER_NAME%type;
757: l_retcode VARCHAR2(2);
758:
759: -- filter out bad queries that are in the ZPB_VALIDATION_TEMP_DATA table.
760: -- This goes for all cursors.
761:
762: cursor all_readaccess is
763: select distinct substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'ReadAccess')+10) QUERY_PATH

Line 770: from ZPB_VALIDATION_TEMP_DATA VTDATA

766: p_business_area || '/ZPBSystem/Private/Manager/%ReadAccess%' and
767: substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'ReadAccess')+10)
768: not in(
769: select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'ReadAccess')+10)
770: from ZPB_VALIDATION_TEMP_DATA VTDATA
771: where VTDATA.business_area_id = p_business_area);
772:
773: cursor all_writeaccess is
774: select distinct substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'WriteAccess')+11) QUERY_PATH

Line 781: from ZPB_VALIDATION_TEMP_DATA VTDATA

777: p_business_area || '/ZPBSystem/Private/Manager/%WriteAccess%' and
778: substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'WriteAccess')+11)
779: not in(
780: select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'WriteAccess')+11)
781: from ZPB_VALIDATION_TEMP_DATA VTDATA
782: where VTDATA.business_area_id = p_business_area);
783:
784: cursor all_ownership is
785: select distinct substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'Ownership')+9) QUERY_PATH

Line 792: from ZPB_VALIDATION_TEMP_DATA VTDATA

788: p_business_area || '/ZPBSystem/Private/Manager/%Ownership%' and
789: substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'Ownership')+9)
790: not in(
791: select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'Ownership')+9)
792: from ZPB_VALIDATION_TEMP_DATA VTDATA
793: where VTDATA.business_area_id = p_business_area);
794:
795: begin
796: select USER_NAME

Line 828: DELETE FROM zpb_validation_temp_data WHERE business_area_id = p_business_area;

824: l_query_path := each.query_path;
825: ZPB_AW.EXECUTE('call sc.set.ownership('''||l_query_path||''')');
826: end loop;
827:
828: DELETE FROM zpb_validation_temp_data WHERE business_area_id = p_business_area;
829:
830: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Done');
831:
832: ZPB_AW.EXECUTE ('update');