[Home] [Help]
603:
604: ELSIF (ctx_type = 'IO') THEN
605: BEGIN
606: SELECT organization_name INTO v_ctxt_name
607: FROM org_organization_definitions
608: WHERE user_definition_enable_date < SYSDATE
609: AND (disable_date IS NULL
610: OR disable_date > SYSDATE)
611: AND organization_id = ctx_id;
614: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
615: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
616: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
617: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
618: fnd_message.set_token('AZW_ERROR_STMT','select name from org_organization_definitions');
619: APP_EXCEPTION.RAISE_EXCEPTION;
620: END;
621:
622: ELSIF (ctx_type = 'OU') THEN
864: ORDER BY organization_id;
865:
866: CURSOR io_cursor IS
867: SELECT organization_id, organization_name
868: FROM org_organization_definitions
869: WHERE user_definition_enable_date < SYSDATE
870: AND (disable_date IS NULL
871: OR disable_date > SYSDATE)
872: ORDER BY organization_id;
1334:
1335: CURSOR invalid_io_processes_cursor IS
1336: SELECT ap.item_type, ap.process_name, ap.context_id
1337: FROM az_processes ap,
1338: org_organization_definitions ood
1339: WHERE ap.context_type = 'IO'
1340: AND ap.process_type = g_current_mode
1341: AND ap.context_id > -1
1342: AND ap.context_id = ood.organization_id
1370: DELETE from az_processes
1371: WHERE context_type = 'IO'
1372: AND context_id not in
1373: ( select distinct organization_id
1374: from org_organization_definitions);
1375: -- get rid of non-existent OU processes from az_processes
1376: DELETE from az_processes
1377: WHERE context_type = 'OU'
1378: AND context_id not in